Inventory Average Cost

SUGGESTED

We have a number of inventory items which utilize standard cost as the valuation method.  Due to a number of reasons, the average cost fields in the CI_Item and IM_ItemCost tables are way off.  The system utilizes the standard cost when posting to the GL, but the tables show extended valuation at the quantity times the average cost. 

 

How do we reset average cost and is there a utility to run monthly to clear this problem out?

Parents
  • 0

    If the Item has a valuation of Standard then the values you see in Average Cost if informational only.

  • 0 in reply to BigLouie

    I agree from a pure accounting standpoint, these numbers are not used for anything.  But the tables are incorrect, and currently hold numbers that are huge.  Average costs into the billions of dollars.  It looks weird when one views an item in inquiry and if we try to utilize these fields in a crystal report nothing will match.  Informational or not, Sage should have a fix to make the table correct.

    Is there any utility that I can run to correct these fields?

Reply
  • 0 in reply to BigLouie

    I agree from a pure accounting standpoint, these numbers are not used for anything.  But the tables are incorrect, and currently hold numbers that are huge.  Average costs into the billions of dollars.  It looks weird when one views an item in inquiry and if we try to utilize these fields in a crystal report nothing will match.  Informational or not, Sage should have a fix to make the table correct.

    Is there any utility that I can run to correct these fields?

Children