customer balance(LCY) in sales order

zzz458

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

ara3n

Hello
I saw your post also on navision.net. I answered that one and here is another solution.
Here is another solution.
Create a new field on Sales Header. Balancy (LCY). Make it a flowfield to cust. ledger entry Amount (LCY) field. and set the filter sell-to customer no. = customer no.
Add the field to Sales Order.

hansfousert

In standard Navision you will get the Balance (LCY) information if you open the Statistics window in de sales document. To be precise: on the customer tab!