Aging Inconsistency - Adagio Accounting | Technical Support Forums

You are not logged in. [Log In] Adagio Home Page » Forums » General Discussion » Technical Support » Aging Inconsistency

Topic Options

#16385 - 03/19/09 03:45 PM Aging Inconsistency
re_turner_jr Casual Registered: 01/26/09 Posts: 13 Loc: AR, USA	I am again having problem with posting negative balance invoices. As recommended last, I am now posting negative balance invoices as Credit Notes. However, there is an inconsistency in the overdue receivables report. The customer in question is a balance forward account, who pays in advance. The current transactions are as follows ################################################################ Type - DocDate -- DueDate -- Document - CurrentAmt - OriginalAmt CA --- 12/22/08 - 12/22/08 - 1017546 -- (898.25) --- (1,168.69) IN --- 02/26/09 - 03/25/09 - 870839 ---- 0.00 ------- 8.69 CN --- 02/27/09 - 02/27/09 - 870946 ---- 0.00 ------ (2.68) IN --- 03/04/09 - 03/25/09 - 871371 ---- 0.00 ------- 5.55 ################################################################ The CN (870946) has a current amt. of 0.00 and has been applied to the CA (1017546). If I click the 'Calc Aging' button on the customer profile, Transaction tab, the entire credit amount of -898.25 appears in the Current field. However, on the Overdue Receivables report under the Current column is the amount -895.57 and under the Over92 column is the amount of the CN, -2.68. This should be the same for both. Why is there an inconsistency in the two figures? Is there any way I can correct this?
Top

#16387 - 03/19/09 03:55 PM Re: Aging Inconsistency [Re: re_turner_jr]
Retired_Guy Adagio Master Registered: 03/16/99 Posts: 10504 Loc: Canada	Hello re_turner_jr, If you change the customer from Balance Forward to Open Item, does the account aging make more sense? My guess is that the credit note is aging with the invoice that it is applied to, and the unapplied cash is always "current". _________________________ Andrew Bates
Top

#16418 - 03/21/09 09:15 AM Re: Aging Inconsistency [Re: Retired_Guy]
re_turner_jr Casual Registered: 01/26/09 Posts: 13 Loc: AR, USA	Yes, the unapplied cash is showing as current, this is document(CA 1017546). The detials of the CN shows that it is applied to CA 1017546, yet, it does not age with the CA 1017546 document in the current column. Code: Type - DocDate - DueDate - Document - CurrentAmt - OriginalAmt CA - 12/22/08 - 12/22/08 - 1017546 - (898.25) - (1,168.69) <--this -------<-\| IN - 02/26/09 - 03/25/09 - 870839 - 0.00 - 8.69 \| CN - 02/27/09 - 02/27/09 - 870946 - 0.00 - (2.68) <-This applied to >-\| IN - 03/04/09 - 03/25/09 - 871371 - 0.00 - 5.55 -RT Edited by re_turner_jr (03/21/09 09:16 AM)
Top

#16419 - 03/21/09 05:22 PM Re: Aging Inconsistency [Re: re_turner_jr]
Retired_Guy Adagio Master Registered: 03/16/99 Posts: 10504 Loc: Canada	Hello RT, Is the concern in the difference in showing the aging between the report and the on-screen inquiry? In Adagio, unapplied cash is always "current". While this is a change from the way Accpac Plus did its aging, we believe it is more "correct". Both reports are correct in some sense. The on-screen inquiry would likely be used when you are on the phone with the customer. Note that the aging would be appear more "correct" if you had applied the credit note to an invoice and then just applied the cash to the invoice (rather than to both the invoice and the credit note). _________________________ Andrew Bates
Top

View All Topics

Moderator: Christa_Meissner

0 registered (), 72 Guests and 1 Spider online.

Key: Admin, Global Mod, Mod

Forum Stats

1865 Members
5 Forums
14484 Topics
70731 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