+8Does 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!
Best answer by wfilipiak67
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.
+3Laura,
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.
+8Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
