I’m trying to make a GI that will show a customer’s balance owing. However, I cannot find what table to use.
I tried PX.Objects.AR.ARBalances, but found that some of the values were incorrect.
I tried PX.Objects.AR.CustomerMaint+CustomerBalanceSummary since it is what’s displayed on the customer page, but it seems that this table is not longer used.
Would appreciate any help with this!
Just find a report that gives you what you need and then have a look at the Schema Builder.
Perhaps AR Balance by Customer is what you need.
Hi
ARBalance is the correct one. And also we can get the Balance from the AR Register table also. I’ve attached the 2 sample GIs. Please review.
Hi,
The issue is that some of our customers have multiple locations, and the balance doesn’t reference the balance for the company as a whole but for each location. We want to be able to see that total balance for each customer. The field that we want to reference says its from CustomerBalanceSummary, but that doesn’t work anymore so I’m at a loss.
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.