Solved

How to show a prepayment total on the SO Invoice printed form (SO643000)?

  • 12 March 2021
  • 2 replies
  • 271 views
lauraj46
Rank
Userlevel 7
Badge +7

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!

 

icon

Best answer by wfilipiak67 12 March 2021, 17:58

View original
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

2 replies

wfilipiak67
Rank
Userlevel 5
Badge +2

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.
 

 

lauraj46
Rank
Userlevel 7
Badge +7

@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

 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved