By using this website, you agree to our Terms of Use (click here)
Good day I have a genetic query with invoice balance data
In a column I need the customer's balance even if it is repeated for each row
How can I have this data?
Thank you for your support!
Hi Osk
You will need to link your PX.Objects.AR.ARBalances table to the ARInvoice table with the CustomerID field as the linking field. Then the field you will use to view the balance is CurrentBal.
HI John
Thanks for your help
I still have a question and I hope you can help me.
This table has more than one record with the customer ID reference.
What line should I consider to be able to apply a filter in the GI?
Does this field / table obey some additional update process to match the customer's balance data and the result of this table?
Client balance does not match
I appreciate your support again
Greetings,
Oskar
@oskjeron Hi Oskar
The linking will be as follows:
Table links: ARCustomers (Left Join) ARBalances
BAccountID Equals CustomerID
The CurrentBal field is the one which reflects on the customer profile as 'Balance' which you have highlighted in green. The unrelease balance means that there are documents which are yet to be released linking to the customer. That value negative, I assume its a Payment/Credit Memo/Balance Write-Off.
Online Members
