A specific customer was invoiced yesterday and we are not seeing the customer display in the AR Aged Receivables Report. Is there anything to check why it’s not showing up in the report?
Examine the invoice with Invoice Tracker. Double check the Invoice date, and that it is posted.
1 Like
I checked in AR Invoice Tracker and it shows the correct invoice date of 1/30/20 and is posted.
Invoice total is greater than 0, and no open Credit Memos?
Total is greater than zero. How do I check if there are any open credit memos?
In the Invoice Tracker, search for invoices, and enter the customer number. Search and then select all. Then scroll through them.
Once I select all and scroll through them, what is it that I am looking for?
It is the only invoice since 2006 for that customer.
Lets backup and run the Customer Statement Report, for just this customer. It will show all invoices and credits applied (Cancellation Invoices, Credit Memos, and Payments)
I ran it for a tighter date range but the invoice did show up in the statement of account with the balance under “current” and a balance due.
I’d suggest running the Aging report again, and double check the settings.
Maybe play around with the dates to see if any changes make it appear.
I re-ran it Aging report specifically for that customer and it came up with a blank row. I would have expected the report to error out in system monitor. I think something has to do with that blank row.
When I run the stock Aged Recvbls report with a customer with no open invoice, I get the “No records selected” error in Sys Monitor
Hmmm… that makes me wonder about odd characters in the raw data. i.e. similar to weird uppper/lower case issues in some other reports.
Wonder what you’re Sales Analysis or Sales Gross Margin reports look like?
He said they appear on the Customer Statement report
hello my friend
the due data did not updated properly in the data base, kindly update the due date/pay terms in posted invoice update or update in the data base for the invoice alone with correct due date and run the report.
1 Like
Hello,
We are experiencing almost the same issue. We have one invoice missing on the Aged AR. Cust has multiple invoices billed on the same day however one invoice is not pulling through Aged AR. That missing invoice is showing on the customer statement. Also, when i ran an Aged AR specific for that customer with the date range of the invoice date the missing invoice is on the report.
We ran into this yesterday. I am a total novice at this specific report, so I was schooled by another employee today.
The issue as others have implied, is that the invoice had no due date on it.
A way around this is to run aging by invoice date not apply date.
And the other solution would seem to be this one, which I didn’t even think of:
But, um, I can’t endorse this 
: