How can I create a report that prints the "G/L Entries Preview" in Business Central?

(3) Share

Report

Posted on by Thiran

Hi all,
I want to create a report in AL that shows the "Preview Posting" G/L Entries (similar to what is shown in the G/L Entries Preview page when we click "Preview Posting" from a sales document).
Is there a way to programmatically access the temporary G/L Entries that are generated by the Preview Posting process?
Specifically:
I want to allow the user to preview posting a document (like a Sales Order),
Then generate a printable report (or printable page) showing the simulated G/L Entries,
Just like the “Preview Posting” page, but with an option to print or export.
I know that Codeunit 19 "Gen. Jnl.-Post Preview" is involved. Has anyone successfully implemented this or have guidance on how to capture the temporary G/L Entries for reporting?
Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Sagar Dangar, MCP 799 Super User 2025 Season 2 on at

Like (3)

Report

Hi,

What is purpose of creating printable report? as it's already showing on page and also you export it to excel using "Open In excel" action

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

Hi, You can try the following steps, which do not require customization and are quick.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Thiran 85 on at

Like (3)

Report

@Sagar Dangar, MCP & @YUN ZHU Thanks for your response.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (1)

Report

EDITED: Apologies for duplicated response

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (2)

Report
One quick solution would be to use Edit in Excel after previewing, if your goal is just to review the G/L Entries. But if you want to generate a printable RDLC report from the Preview Posting data, then yes — you’ll need some customization.

Here’s how you can approach it:

Use Codeunit 19 "Gen. Jnl.-Post Preview"

Call methods like RunWithDocument(...) to trigger the simulation. This generates temporary G/L entries in a buffer table (not stored in the database).

Capture the Temporary Entries

Extend the logic by copying the temporary entries from Gen. Jnl.-Post Preview into your own temporary or buffer table within the same session. You can do this within a wrapper function or via event subscribers.

Design an RDLC Report

Create a report that uses your buffer table as the dataset. Make sure it's session-based so it prints only after the preview is generated.

Reference Standard Pages

You can also study Page 14811 "Posting Preview Source" and related pages to understand how BC displays the preview posting entries on screen — useful for aligning your logic.

While not available out of the box, this approach gives you the same simulated G/L Entries as the Preview Posting screen — but in a printable format.

If this helped you, please check the box "Does this answer your question?"

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,443 Super User 2025 Season 2 on at

Like (2)

Report

Just adding more details:https://learn.microsoft.com/en-us/dynamics365/business-central/ui-how-preview-post-results

Was this reply helpful? Yes No