Customer Receivable Report

(0) Share

Report

Posted on by thejulie

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Please check Report ID 109 and 10040

Thanks.

Was this reply helpful? Yes No
thejulie 5 on at

Like (0)

Report

Hi Nitin,

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

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.

Was this reply helpful? Yes No