I am trying to create a GI to compare a customer sales order totals to the open order value from the Customer Financial Tab. Is it possible to use the DAC CustomerBalanceSummary in a GI linked to Customer ID in Sale Orders?
Answer
Customer Order Balance
+1Best answer by YasasWithanage76
Hello
Unfortunately, you can't get values from CustomerMaint.CustomerBalanceSummary DAC. Because this is a virtual/ Nonexistent in DB (like a database view) DAC. The OpenOrdersBalance is a calculated field.
As per my understanding, this amount is calculated from the PX.Objects.SO.SOOrder DAC. The Open Orders Balance is a total of unbilledOrderTotal in the SOOrder DAC. That is how it is calculated.
Maybe you can try below KB article, to get the drill down of the customer Open Orders Balance from SO tables.
+4Hello
Unfortunately, you can't get values from CustomerMaint.CustomerBalanceSummary DAC. Because this is a virtual/ Nonexistent in DB (like a database view) DAC. The OpenOrdersBalance is a calculated field.
As per my understanding, this amount is calculated from the PX.Objects.SO.SOOrder DAC. The Open Orders Balance is a total of unbilledOrderTotal in the SOOrder DAC. That is how it is calculated.
Maybe you can try below KB article, to get the drill down of the customer Open Orders Balance from SO tables.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.