• From: UK
  • Registered: 10/02/2012
  • Posts: 146

Topic: Wrong Inventory Costing

Hi

I have serious issue with inventory cost update. FA has automatically update item cost to negative as below. Because the cost is negative, i can't post item adjustment entries. The stock valuation report is also showing wrong stock value. Can somebody help me on how to rectify this.

stock_id                    mb_flag     material_cost
DalMuth-150Gms          M        -6,260.86
DalMuth-150Gmsx12     M    -75,130.00
DalMuth-250Gms         M           -10,434.79
DalMuth-300Gms         M          -12,521.75
DalMuth-325Gms         M          -13,565.24
DalMuth-550Gms         M          -22,956.58
PunjabMix-150Gms         M          -1,845.84
PunjabMix-150Gmsx12    M    -22,149.86
PunjabMix-250Gms         M          -6,153.17

Thanks

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Wrong Inventory Costing

Items and Inventory -> Standard Costs

1. select item
2. Standard Material Cost Per Unit is shown
3. if you want to adjust the standard cost enter it in the field and click Update

apmuthu's Website

  • From: UK
  • Registered: 10/02/2012
  • Posts: 146

Re: Wrong Inventory Costing

Hi

These are my BoM items.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Wrong Inventory Costing

What was the sequence of operations that led to this state of the db?

Please make a fresh test instance of FA (take the latest patches on board) and make a set of operations that will result in one set of negative values. Then we can decipher what went wrong.

Also, make a comparison between a backup sql (where the entries were positive) and a current (negative) sql dump and see what tables and records are affected.

apmuthu's Website