Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information - Acumatica Generic Inquiries & Pivot Tables https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/ Acumatica User Group Forums en-US Thu, 12 Mar 2026 21:21:20 +0000 wpForo 60 RE: Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-8558 Thu, 01 Apr 2021 03:45:02 +0000 @susank17 Here's a related Discussion Topic:

https://www.augforums.com/forums/acumatica-report-designer/add-payment-amount-to-so-invoice-form

 

You are probably only getting the first Payment record right now. The Subreport would allow you to total all Payments.

]]> Acumatica Generic Inquiries & Pivot Tables Tim Rodman https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-8558 RE: Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-8229 Tue, 09 Feb 2021 19:57:33 +0000 I tried to use this on the Sales Order form and it appeared to work for a month or so.  Then two payments were made and the form didn't total both payments, so it looked like the customer did not pay in full.  

I am getting confused on how payments work on an open sales order.  On the Sales Order screen (SO301000) I added the SOOrder CuryPaymentTotal and it displays correctly.  When I go to the Report Designer Sales Order Form and choose the same field it displays as zero.  When I check the SQL table the field doesn't exist in the SOOrder table.

2127 2128

Anyone know how I can have the following on my Sales Order form:

Total:             xxxx.xx

Payment:       xxxx.xx

Balance Due:  xxxx.xx  (I set it up as curyordertotal - curypaymenttotal)

Thank-you.

]]> Acumatica Generic Inquiries & Pivot Tables SusanK17 https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-8229 RE: Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7931 Mon, 21 Dec 2020 16:58:00 +0000 Perfect.  Thank-you very much.  Never thought to look at adjustments for a payment link.

]]> Acumatica Generic Inquiries & Pivot Tables SusanK17 https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7931 RE: Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7930 Mon, 21 Dec 2020 15:22:43 +0000 Hi @susank17,

The table you want is SOAdjust.  AdjdOrderType, AdjdOrderNbr are the Adjusted Order and AdjgDocType, AdjgRefNbr are the Adjusting payment.  AdjAmt is how much is remaining to be applied to the Sales Order, and AdjBilledAmt is how much was Transfered to Invoice.

]]> Acumatica Generic Inquiries & Pivot Tables Wyatt.ERP https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7930 Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7917 Fri, 18 Dec 2020 17:32:18 +0000 I am trying to get the payment applied to the sales order before it is invoiced.  I can find the information on invoiced orders, but on open orders I can't make the links work.

I found the payment in ARPayment table.  I have not found a way to connect SOOrder to ARPayment.  I cannot find the payment ref number or the external ref number in the SOOrder data.  I have no idea what the missing link is, does anyone know?

 

Thank-you.

 

 

]]> Acumatica Generic Inquiries & Pivot Tables SusanK17 https://www.augforums.com/forums/acumatica-generic-inquiries/show-payment-applied-to-order-to-sales-order-in-a-generic-inquiry-that-has-the-soorder-information/#post-7917