FrontAccounting forum — Wrong Inventory Costing

Re: Wrong Inventory Costing

null@example.com (apmuthu) — Sat, 23 Mar 2013 02:00:28 +0000

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.

Re: Wrong Inventory Costing

null@example.com (dvarsani) — Fri, 22 Mar 2013 17:11:21 +0000

These are my BoM items.

Re: Wrong Inventory Costing

null@example.com (apmuthu) — Fri, 22 Mar 2013 15:57:54 +0000

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

Wrong Inventory Costing

null@example.com (dvarsani) — Fri, 22 Mar 2013 10:34:36 +0000

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