Showing results for 
Search instead for 
Did you mean: 
Established Member

Adding Location to Customer Overpayments/Credit on Account

Hi there,

We use locations and run A/R Aging Summary reports filtered for location every month. We have several customers with over-payments leading to credits on their account. These credits don't show up on the A/R Aging report because you can't assign a location to the payment. Does anyone have a work around or suggestion on how to get the over-payments to display on the appropriate A/R Aging Summary report?

Thanks for your help.

1 Comment

Re: Adding Location to Customer Overpayments/Credit on Account

Hi RHurley1113,


One way to record over-payments is by using the Credit Memo transaction in the Plus menu. It lets you also assign a location. 


If you've been recording the credits this way, there is no need to add locations for them in the A/R Aging Details/Summary Report.



Otherwise, there's no option to customize the reports to show the location & credits.


However, you can customize the Transaction List by Customer report instead. Let's filter the information to show the location column for the credits. 

  1. Go to Reports.
  2. Enter Transaction List by Customer in the search field.
  3. Click on Customize.
  4. Check the Date, Transaction Type, Num, Account, Amount, Location, Split, and Open Balance boxes,
  5. Click on Run report.

In the sample screenshot below, the Payment transaction is the over-payment. The credit is placed in the Open Balance column and the location is already added. 

Customizing the reports also helps you to filter other information that you want to see.


Keep us posted if you have more questions about the reports or anything else. Have a great day!