You’re offline. This is a read only version of the page.
127
Hello All,
I have this one requirement where I have to generate customer aging report from multiple companies. All the customer have same code and name in both of the companies. So, I want to develop the report where it displays the aging details from both of the companies irrespective of which company I run. Is there any suitable way to do this?
*This post is locked for comments
I have the same question (0)
Hi! You need to use CHANGECOMPANY function:
docs.microsoft.com/.../changecompany-function--record-
For example:
Share
Report
All responses (
Answers (
IF Company.FINDFIRST THEN REPEAT
Customer.CHANGECOMPANY(Company.Name);
CustomerLedgerEntry.CHANGECOMPANY(Company.Name);
IF Customer.FINDFIRST THEN REPEAT
CustomerLedgerEntry.SETRANGE("Customer No.", Customer."No.");
IF CustomerLedgerEntry.FINDSET THEN
....
UNTIL CustomerLedgerEntry.NEXT = 0;
UNTIL Customer.NEXT = 0;
UNTIL Company.NEXT = 0;
