Topic Options
#7051 - 06/11/06 06:46 PM Payables: Clear History/DI Rebuild Problem
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 875
Loc: Christ Church, BARBADOS
Hello,

Version: AP 8.0A 05 11 22 (and I believe 06 03 30 as well)

In responding to a problem where a the GL AP control acct and the AP subledger did not balance I found the following (after much digging I might add ) :

<a> MC transaction applied to IN and CN transactions.
<b> CN only partially used leaving a balance on this CN trans.
<c> Period End with Clear Transaction History eventually purged the MC Transaction
<d> Subsequent DIC reported "Computed Bal. vs. Stored Bal." problem on the CN transaction
<e> Rebuild run and repaired errors believing the "Computed Bal." to be correct - It was not !!!
<f> Rebuild "forced" Stored Bal. to match incorrect Computed Bal.
<g> GL/AP ledgers now out of balance since "rebuild" passes no GL entry

While the above was created using the previous release of AP, I see no mention of a fix in the release notes of the current release and therefore suspect that the problem would still be present.

I guess the answer is to not let AP clear the MC (or any) trans. that are required to compute the difference in another transaction's Original vs. Current Amount even if its current amount is 0.00

However, food for thought: Should there be some warning when the methods used by the Rebuild process could cause an imbalance between the GL and its Sub-Ledgers ?

Regards, Peter

PS: You really need at least a [Print] button for the DIC window. Add an [eMail] button that automatically brings up their "support contact's email address" and that would be really cool BTW - we don't want to buy another module (DC) to do this
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top
#7052 - 06/11/06 09:26 PM Re: Payables: Clear History/DI Rebuild Problem
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
Hi Peter

I tested your sequence on sample data using AP 8.0A (060330)

You are correct that DIC erroneously reports a problem when a matching transaction to a partially paid current transaction is cleared from history.

This is an issue for Softrak's R&D department to research (that's why they put the R in R&D)

Steve Schwartz

Top
#7053 - 06/11/06 10:39 PM Re: Payables: Clear History/DI Rebuild Problem
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Thanks for the detailed analysis Peter, and the confirmation from Steve. R&D will take a look and try and address the issue in the next service pack.

FWIW - adjustments made by the DIC never make any general ledger adjustments. There's no way to know what they should be - so the "never" is a safer rule.
_________________________
Andrew Bates

Top


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