Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Posted dollars are incorrect after UOM conversion.

Status
Not open for further replies.

tjbennett

MIS
Feb 8, 2005
95
US
When a part is received that is purchased in a unit of measure (UOM)different than the stocking UOM, the quantity received in inventory is correct (the purchased UOM is converted to the stocking UOM).

However, the dollars posted are incorrect. The $ posting to inventory (11XX)is calculated by multiplying the purchased qty received by the stocking standard cost, instead of multiplying the stocking quantity received by the stocking standard cost.

The $ posted to the purchase price variance account (7045) is calculated by multiplying the purchased qty received by the difference between the purchase order unit cost divided by the UOM conversion and the stocking standard cost, instead of multiplying the stocking quantity received by the
difference between the purchase order unit cost converted to the stocking unit cost and the stocking standard cost.

The $ posted to the receiving accrual account (3200) is calculated by multiplying the purchased qty received by the purchase order stocking UOM cost, instead of multiplying the stocking quantity received by the stocking standard cost.
 
What version of Macola? What platform, Pervasive or MS SQL?

Did you change the UOM after the PO was entered?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
 
We have 7.6.100 running on Pervasive 2000i, we recently upgraded our server and reinstalled Macola. After looking into it a little bit I found that we used to be on 7.6.100a, do you think this could cause the problem?

No the UOM didn't get changed after the PO was entered.
 
Doubtful that 76100a vs 76100 is the problem, but who knows. Why such an old version?

At any rate, please post some examples of your item master and stocking UOM, purchasing UOM and UOM ratios, along with the std costs and the expected and actual posting results.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top