125
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
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;
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
