So i'm trying to get a value of the "Remaining Amount" field on a posted sales invoice since i want to use that value in a report.
Now a customer i am developing this for, that field is filled in with a certain amount on each document but i was wondering where that value comes from since i am developing on my OnPrem to later publish it on their SaaS. Now in my OnPrem the "Remaining Amount" field is always equal to 0 so when testing the report on my OnPrem that column is always empty.
Would be thankful if someone can elaborate this.
EDIT:
Turns out there is no difference between my OnPrem and their Saas BUT, still the field on both the posted sales invoice pages are equal to 0 but if i look in the list of those posted sales invoices, where they are all listed, then the "remaining amount" field is filled in...
Hi,
It looks like you are search for Remaining Amount value in the wrong place.
Goto Customer Ledger Entries, filter by Document No. which is equal to Posted Sales Invoice No. and then find the remaining amount using CALCFIELDS.
Let me know if you need further help.