Skip to main content

Does anyone know of a way to show the applied payment total (including prepayments) on the SO Invoice printed form report (SO643000.rpx)?  The field appears on the SO303000 screen and the total is correct, however that field (ARInvoice.CuryPaymentTotal) is not available to choose in the Report Designer.  It seems like this would be a common requirement, so hopefully we are just missing something obvious here.  This is for 2020 R2.  Thanks in advance!

 

Laura, 
Using the Build Schema, you can Load Schema & refresh the ARInvoice table & the field will show.

We have also done a calculation to get the payments. ARInvoice.CuryOrigDocAmt- ARinvoice.CuryDocBal. we then multiple by -1 to display a negative number.
Here is a screenshot of the refresh & the Payment Calculation.
 

 

@wfilipiak67  Thank you!!!! The refresh on the ARInvoice table from Build Schema did the trick.  The missing fields appeared in the schema and I was able to add CuryPaymentTotal as well as CuryUnpaidBalance onto the report.  Thanks again!

Laura

 

Reply


Terms & ConditionsCookie settings