Topic Options
#51379 - 10/27/16 03:11 PM Receivables customer balance not cleared
Braedon Offline
Adagio Graduate

Registered: 09/16/16
Posts: 41
Loc: BC
We have a customer in our AR who has a zero balance outstandting but the statements and AR Aging show a balance due.
Somehow when we imported our customer data to Adagio in 2014 a 2001 customer was imported with a 2001 invoice still outstanding. An adjustment for the same customer was also imported which cleared this invoice but somehow that adjustment is dated 2020.

Therefore now we have a zero balance for this customer but it still shows the items as not cleared as they won't clear until the system thinks it is 2020 and applied the adjustment. Therefore when we print statements or look at aged customers this shows as outstanding unless we print the report as at 2020.

This causes our AR listings to be off from GL totals and other issues which we would rather fix now than wait until 2020 for the issue to clear itself.
Is there a way to change the date on the other adjustment so that it clears correctly?

Top
#51381 - 10/27/16 04:25 PM Re: Receivables customer balance not cleared [Re: Braedon]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Hi Braedon

There is a way, using Adagio GridView ReadWrite, a module you almost certainly don't own. And even if you owned it, it is not a straightforward operation.

Show this to your Adagio consultant. Most consultants own a copy of GV ReadWrite and will do this for you (as a billable service).

Steve

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Lauren Stief), 146 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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