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

Customer Receivable report

(0) Share

Report

Posted on by Eva2020

Hello Experts,

I am creating a report as below:

Customer No Remaining Balance Customer Balance

Opening Bal 1000

Cust A 100 1100

Cust B 50 1150

Cust C -200 950

=============================================

Total 2400

I am unable to add Customer Balance.

I Created one variable: CustBalance

CustBalance:=openening bal + Remaining balance

It doesn't give the correct result.

Kindly help.

Eva

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (1)

Report
Copy link

Link copied!

A little hard to help you with this unless you share the code for your report so we can see what approach you have used and at what stage in your code you do the different calculation.

Maybe you can share the code here?

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report
Copy link

Link copied!

I just added one data item that is Customer ledger entry and below is the code:

OnAfterGetRecord Trigger

OpenBal:=0;

//CustBal:=0;

CustLedgerEntry.RESET;

CustLedgerEntry.SETFILTER("Posting Date",'%1',"Cust. Ledger Entry"."Posting Date"-1);

IF CustLedgerEntry.FINDSET THEN

REPEAT

CustLedgerEntry.CALCFIELDS("Remaining Amount");

OpenBal:=OpenBal+CustLedgerEntry."Remaining Amount";

UNTIL

CustLedgerEntry.NEXT=0;

CustBal:=OpenBal+"Cust. Ledger Entry"."Remaining Amount";

CustBal2:=CustBal;

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report
Copy link

Link copied!

Hello Inge,

I have pasted the code below. Any help will be appriciated

Eva

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is the CustLedgerEntry variable you use in the trigger the same as the one you are using as your dataitem.

It would be easier if you shared the whole report object and not only the trigger. Then i can try to run it myself here.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As per my understanding, Customer Balance in your report is Running Balance. So we can not do the total of Customer Balance or Running Balance as per the above reports and its logic.

Regards

Amit Sharma

www.erpconsultors.com

linkedin.com/in/amit-sharma-94542440/

Please press Yes if info is useful.

Was this reply helpful? Yes No
Eva2020 10 on at

Like (0)

Report
Copy link

Link copied!

Hello Inge

where i can send you the object. I am not getting any option to attach the object here.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can either go to rich formatting and insert code or you can use the e-mail i sent you in a message.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Customer Receivable report

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

Customer Receivable report

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates