Hi everybody,
I need to find a data table that contains unposted transactions in NAV Dynamics.
That means my company sells goods and closes shifts monthly. I want to find a table containing orders that have not been completed, i.e. have not been posted to the Value Entries ledger. So how to find this table in the ERP SQL database.
And I'm looking for the Transaction Sales Entry table (99001497) or the Transaction Registration table (99001496) in the Source Table "Transaction Header (99001472)" with the Posting Status field.
Thanks everyone
I'm not sure what version you are using, I think you can try the following two standard fields.
Hope this helps.
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.