Topic Options
#15311 - 12/05/08 05:44 PM A/R Historical balances
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
We've just ended our year (Oct 31) and performed the close functions in A/R, however, there is now current year data showing up under the historical tab in the customer transaction enquiry screen. Also in our first current year month (Nov), the aging shows some of the current transactions, dated after October 31st in the over 90 day column. Any ideas on how we can fix this, or what may be causing the problem?

Top
#15312 - 12/05/08 06:37 PM Re: A/R Historical balances [Re: Holiday]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Holiday,

The close year function should have been run prior to invoicing any data in the new year. It assumes that it is being run on the last day of your year, so fully paid transactions from November would have been moved to the history and "prior year" bucket.

There's a document describing the various period end functions on our web site.
_________________________
Andrew Bates

Top
#15313 - 12/05/08 06:50 PM Re: A/R Historical balances [Re: Holiday]
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 876
Loc: Christ Church, BARBADOS
Hi Holiday,

When you say "current year data" is now showing up in the historical area - do you mean current year transactions that still have outstanding amounts (current amount is not zero)? Or are the current amounts of the questionable historical transactions = 0 ?

With respect to the aging, I'm sure that you would have checked that not only the month and day of the transactions are correct but also the year. In terms of invoice transactions, are the due dates (as opposed to the invoice dates) also correct ? Some aging is done by Due Date rather than Invoice Date. Is the aging incorrect on both the Inquiry window as well as on the Aged Receivables reports ?

Pete
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top
#15314 - 12/05/08 08:01 PM Re: A/R Historical balances [Re: BAMPH]
doswalt Offline
Adagio Specialist

Registered: 11/10/06
Posts: 319
Loc: AL
I'm getting confused...in A/R the historical tab under customer transactions is all FULLY paid transactions and has nothing to do with the year in my mind.

Top
#15317 - 12/07/08 11:08 AM Re: A/R Historical balances [Re: doswalt]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi David,

You're right. Transactions are moved to history when they are fully paid. It is not related to Year End.
_________________________
Andrew Bates

Top
#15325 - 12/08/08 05:47 PM Re: A/R Historical balances [Re: Retired_Guy]
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 876
Loc: Christ Church, BARBADOS
It's only related in that the Year End function (like the Period End function) can actually do the moving/clearing by allowing the user to choose to clear the fully paid transactions to history and if so a date on which to base the clearing process.

BTW - at the risk of stating the obvious, "fully paid" really means any and all transaction types whose current (or outstanding) amount is zero. It does not just relate to invoices that have been fully paid by cash payments.
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14485 Topics
70732 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