Find Table "Transaction Sales Entries (99001497)"

(1) Share

Report

Posted on by RP-22070833-0

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

file1.png

I have the same question (0)

All responses (1)

Answers (0)

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (1)

Report

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? Yes No