Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Customer Receivable Report

(0) ShareShare
ReportReport
Posted on by 5

Hello Expert,

One of my customer is asking for a report in Business central On prem with the below details:

Normally, the report will be run on a particular date (just like every day) 

The motive is to have the total due in the market (All Customers)

So Opening balance will be for (All Customers) Remaining Amount + Then, the Invoice on that day. (Total Sales) - Then, the payment on that day (Total Receipt) .. Different Mode (Cash/Cheque,etc) = And, the balance Due as on that Date.

====

I gave them report 104( Customer - Detail Trial Bal) but that didn't work. Could you please suggest if we have any standard report with the above detail?

Appreciate your help. Thanks

Julie

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,021 Moderator on at
    RE: Customer Receivable Report

    I can't remember any standard reports giving you this, so you will either have to create a report for it or use Power BI to report on thees figures.

  • thejulie Profile Picture
    5 on at
    RE: Customer Receivable Report

    Hi Nitin,

    i checked both and these reports didn't work as per the requirements

  • Suggested answer
    Nitin Verma Profile Picture
    21,544 Moderator on at
    RE: Customer Receivable Report

    Hi,

    Please check Report ID 109 and 10040

    Thanks.

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans