Topic Options
#42774 - 08/21/14 08:58 AM Customer not in the receivables report
Lynn1 Offline
Acctg

Registered: 09/19/12
Posts: 25
Loc: Québec, Canada
Hi,
In looking over our receivables report to verify with the cash receipt I noticed that there is a customer that doesn't appear in the listing but is active and owes us money. Why is that? This customer was set up like all the others.
Thanks!

Top
#42775 - 08/21/14 09:42 AM Re: Customer not in the receivables report [Re: Lynn1]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
There's lots of options on the Aged Receivables, Overdue Receivables and Customer Transactions reports. Which report and which options are you choosing?
_________________________
Andrew Bates

Top
#42777 - 08/21/14 10:39 AM Re: Customer not in the receivables report [Re: Retired_Guy]
Lynn1 Offline
Acctg

Registered: 09/19/12
Posts: 25
Loc: Québec, Canada
I'm using the overdue receivables and that's the report the accounts want to look at when year end comes around. Also this causes a problem because receivables amount on the trial balance doesn't balance with the total of the receivables report.

Top
#42779 - 08/21/14 11:27 AM Re: Customer not in the receivables report [Re: Lynn1]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
The Overdue Receivables report is not the report your accountants should be looking at - they should be looking at the "Aged Trial Balance" with the option "Calculated as of" to tie back to the general ledger. The Overdue Receivables ages by Invoice Due date, not the Invoice Date.
_________________________
Andrew Bates

Top
#42789 - 08/21/14 01:26 PM Re: Customer not in the receivables report [Re: Retired_Guy]
Lynn1 Offline
Acctg

Registered: 09/19/12
Posts: 25
Loc: Québec, Canada
They do look at the aged trial balance but we still need to have a receivables report, which if also like to work with.
And anyways, this particular customer doesn't even appear on the aged trial balance.


Edited by Lynn1 (08/21/14 01:31 PM)

Top
#42790 - 08/21/14 01:49 PM Re: Customer not in the receivables report [Re: Lynn1]
Douglas Dickie Online   content
Adagio God

Registered: 06/02/99
Posts: 4419
Loc: Vancouver, BC
Lynn:

There has to be a reason. Is the Data Integrity Check clean? Is there a post dated transaction applied to the invoice?

This may be one of those problems where you will need to get your Adagio Consultant to take a look.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 70 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14477 Topics
70707 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31