Small and medium business | Business Central, N...

How to Find Unposted Journal Entries

(4) Share

Report

Posted on by JE-20081519-0

2,832

Hi:

How do you find a batch of unposted journal entries?

I have looked in a batch that should contain unposted entries. But, it's empty.

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 91,978 Super User 2025 Season 2 on at

Like (0)

Report

How to Find Unposted Journal Entries

No, the details in table 81 are all unposted. The details that have been posted are in table G/L Entry (17)

And Posted Gen. Journal Line (181)

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,960 Super User 2025 Season 2 on at

Like (1)

Report

How to Find Unposted Journal Entries

What do you mean by unposted journal entries? Are you referring to a batch that you are trying to post, but it fails? If you are using journals to post entries, then you should see them in the same batch if they are not posted. But if you are referring to a different process, then provide us with more details about that process.

General Ledger Entries refers to the G/L Entry table, and all the unposted data is in Gen. Journal Line if they are Payment Journal or Cash Receipt Journal, or Item Journal Line if you are trying to post Inventory

If this response resolves your concern, please confirm by clicking “Does this answer your question?”

Thank you.

Was this reply helpful? Yes No
JE-20081519-0 2,832 on at

Like (1)

Report

How to Find Unposted Journal Entries

@YUN ZHU:

I thought table 81 only holds posted data, such as "General Ledger Entries".

Does it hold unposted data, as well?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 91,978 Super User 2025 Season 2 on at

Like (0)

Report

How to Find Unposted Journal Entries

Hi, Just open the table to see it.

PS: Dynamics 365 Business Central: How to calculate the total (sum) of a column in a table (Four ways)

https://yzhums.com/61561/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 6,025 on at

Like (2)

Report

How to Find Unposted Journal Entries

Hi,

I think you can just go to the configuration package and use export to excel for 81 table (General journal line) and you will get all the required unposted lines.

Please mark "Verified" if it helps.

Was this reply helpful? Yes No