I really need some help trying to determine how I pull the next available auto increment of CMTrxNum when using eConnect.
Anybody know the eConnect method to select the next available number? If not, does anyone at least know what table contains the next available number, if I have to do it manually through code?
*This post is locked for comments
Hello,
eConnect don't have schema for next CMTRxNum,whereas it has for other transaction type.
You need to find table and update by 1, I will recommend to search GP existing storeproc for same.
sandipdjadhav.blogspot.com/.../next-document-number-web-service-using.html
msdn.microsoft.com/.../ff623613.aspx
above link will help you to understand how to use next doc Number schema.
Thanks
Sandip
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156