Skip to main content
Answer

Transaction details of customers. Payments and which invoices setoff the payments.

  • November 10, 2025
  • 2 replies
  • 33 views

I want to get the payments details of a specific customer reagarding the payments he did for this year from Jan 2025 to Current and the invoice details that were set off thorugh those payments.

It can be a report or anything.

Thank you

Best answer by Manikanta Dhulipudi

@sandaruwadanamby42 

ChatGPT said:

This report provides the details required for the financial period. Adding an additional filter, such as From – To Period, would be helpful.https://community.acumatica.com/financials-7/payments-for-a-given-period-17700

2 replies

nickcerri32
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • November 10, 2025

@sandaruwadanamby42 - Out of the box you may be able to use the AR Register Detailed (AR622000) if you play with the Doc. Type and Filters.  But this may be best handled by a GI that sets the Application History tab (DAC = ARTranPostBal) of the Payments and Applications (AR302000) screen as the parent table and link it to ARTran or ARInvoice to pull in the corresponding Invoice or Memo data.  

Alternatively, you can set ARTran as the parent table and link it to ARTranPostBal and only show those ARTran details that correspond to a record in ARTranPostBal (there’s other ways to convey this, too), since that would indicate that the ARTran details are part of an application on a payment.

 

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

@sandaruwadanamby42 

ChatGPT said:

This report provides the details required for the financial period. Adding an additional filter, such as From – To Period, would be helpful.https://community.acumatica.com/financials-7/payments-for-a-given-period-17700