Hi all, I have a problem, I want to show the balance(LCY) information of the customer in the sales order document. But this information is located in Customer table and my document uses only sales header and sales line. What can be done? Thanks
Here is the what you need to do. Add a text box to the sale document. Set sourceexp to Customer.“balance (LCY)” Create a global variable Customer type record subtype Customer Find the trigger OnAftergetrecord and type the following code Clear(Customer); if Customer.get(“Sell-to Customer No.”) then begin Customer.calcfields(“Balance (LCY)”); end;