We are into Construction Industry, and we use valuated project stock.
How to handle Materials that are not consumed by the project but used in some operations for eg: Turn Buckle, Shuttering Plate, Shuttering & Staging System, MS Pier Shutter, instruments etc.
No GI is done for these stock as quantity needs to be tracked , these are always in the inventory and has value. These materials are also given to Sub Contractors, they use it and return back after the use.
We have 2 storage locations
1. Main Store.
2. Reusable Store
GR is done for Main Store.
To track the quantity of material given to sub contractor or some other company department, the store transfer the material from Main store to Reusable store and after use when the material is returned back the store person transfer back from Reusable store to main store.
As there is no Goods Issue for these materials, inventory value goes on increasing as new purchases are made. The accounting department expenses out the value based on some percentage of the reusable store directly through FI module with no impact on MM Inventory. This has created a mess in the system.
Is there a way to solve this.