Re: 3-Way Match Problem

This is your issue not System 21; enhancement perhaps.  The solution is
simple: if you don't want this to happen, stop changing your costs.
Otherwise, you must reconcile not only your unmatched accrued liability
account every month end, but Inventory, Scrap and Cost of Sales due to
changing costs if you are using standard costing for example.       

The Accrual report simply reports un-matched items at the inventory value
and is working as designed.  Accounting should post a ME reconciliation
entry.  
    
In my opinion, the only System 21 limitation is that manual changes in
Inventory cost (5/INM or 2/MDM) do not capture inventory "A" revaluation
movements (INP95/INP69) like Item Recost (1/MDC) for AFI to post.  As a
solution, we initiated a mod for this and locked down the option to a select
few.   


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Mant, Phil
Sent: Wednesday, December 06, 2006 12:45 PM
To: SYSTEM21@xxxxxxxxxxxx
Subject: [SYSTEM21] 3-Way Match Problem

Our accounting department came to me about a month ago because they were
having problems with their month end reconciliation process for our
20160 GL account, which has a description of stock accruals, 3 Way
Match. I eventually tracked the problem down to differences between
standard cost, order price and Invoice Price. The first thing I did was
to create a new accruals report based on standard cost instead of order
price. This allowed them to more easily reconcile between the report and
the GL account. Unfortunately this did not correct the problem
completely and I have now discovered a problem with the 3-way match
invoicing program which is created by the following scenario. 
 
1) 100 units of a part with a cost of $2 is received into Inventory.
When AFI is run inventory is debited by $200 and the accruals account is
credited by $200
2) It is discovered that the cost should have been $1 before the invoice
is received so the inventory is revalued to $1 by performing a purchase
item recost and transferring costs to inventory. When AFI is run
Inventory is credited by $100 and the revaluation account is debited by
$100.
3) The invoice is received for $100 and is matched to the receipt. The
resulting GL postings are the accruals account is debited by $100 and
the A/P trade account is credited by $100.

The net result is that the accruals account will show -$100 when there
are no invoices outstanding.

The desired postings would be 
A/P trade is credited by $100, the accruals account is debited by $200
and Price Variance account is credited by $100.
 
I logged this problem on Answerlink but the response was that this was
how it was designed to work and that I would either have to log it as an
enhancement or have it modified. 
 
Has anyone else experienced the same problem, have a workaround or have
had modifications to correct the problem? Maybe if enough companies log
this is a problem on Answerlink they might consider this as being a
program error instead of an enhancement.
 
Thanks,
Phil Mant
Williams Controls.


 
 
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.