Our app is creating sales order lines via the Rest API and we want to track which ones the app created vs ones that were created directly in business central. We're storing the sales order line id (guid) in our database. Problem is it doesn't always match when we make later REST api calls to get the lines for the sales order. We can make 3 calls to the api to get the sales order lines and each time the set of lines will contain different line ids. I cannot find any documentation to explain this behaviour. What is the correct way to store references to sales order lines in our database?
Note... we saw similar behaviour with Acumatica. Line ids changing unexpectedly. So it must be some kind of ERP concept that I don't understand.
This is a bit strange. I checked the standard code and the SystemID will be updated when the Type and "No." are validated. If there are no modifications, there should be no changes.
You can try recording the primary key of Sales Line to see if this problem still occurs.
Thanks
ZHU
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
95,712
