• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Get next TRX_ID for Assembly Transaction (Microsoft Dynamics GP 2010)

I have a stored procedure to create an assembly transaction from SQL into Microsoft Dynamics GP, however, it requires the transaction ID (TRX_ID) as a parameter.

I assume that GP has a table with the most recent TRX_ID stored somewhere, but I'm not sure what it is. I know for IV (and other transactions) eConnect has sprocs to grab next next doc number, but that doesn't appear to be the case for BM Assembly transactions.

Any help would be appreciated!
1 Solution
Victoria YudinOwner / Dynamics GP ConsultantCommented:
I believe you're looking for TRX_ID in the BM40100 table.
echobridgeSenior Software EngineerAuthor Commented:
YES! I don't know how I didn't find it there! Thank you for your help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now