Get the balance with CHANGECOMPANY Function

ams79

Hello,

How can I Get the balance from a vendor with the CHANGECOMPANY function.

Thanks!!

kriki

You cannot work with the flowfields of the Vendor-card, because they still refer to your current company. You have to do this:

recDetailedVendorLedgEntry.CHANGECOMPANY('Some Company'):
recDetailedVendorLedgEntry.RESET;
recDetailedVendorLedgEntry.SETCURRENTKEY("Vendor No.");
recDetailedVendorLedgEntry.SETRANGE("Vendor No.",codMyVendorNo);
recDetailedVendorLedgEntry.CALCSUMS("Amount (LCY)");
MESSAGE('Amount=%1',recDetailedVendorLedgEntry."Amount (LCY)");