web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Sub ledger account gen...

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

Suggested Answer

Sub ledger account generated from Business Central

(1) Share

Report

Report

Posted on by CU01020732-0

17

Hi all

I would like to generate each customer sub ledger account as at 12/31/2025 to auditor, hence I use "customer - detail trail balance" in LCY .

There is customer revaluation adjustment (run by BC), but it looks that the customer - detail trail balance has not record the revaluation transaction.

May I know if there is any report can show the all movement of the individual customer?

Many thanks for your help.

Martina

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

AndrewThomas81 462 on at

Like (0)

Report
Copy link

Link copied!

I would asssume an auditor would want to see the detail per customer for the end of year balance which reconciles to the debtor control account, the report which will provide this is the "Aged Accounts Receivable" and print with details. Use the RDLC report not the excel one, as the excel one doesn't include document number and is therefore annoyingly useless - I have reported this to Microsoft.

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,158 Super User 2026 Season 1

#3

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans