× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


 
 

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.