on 2007 Dec 10 7:22 PM
My client uses standard cost and has one primary supplier. The supplier issues a new cost list the first of the year. The client receives a massive spreadsheet with 10000+ item changes.
Is there a way to import a batch of changes to Inventory Valuation as one does with the StockTaking destination for opening balances?
Cindy,
For changing the cost of an item you would use the DTW templates inside oMaterialRevaluation folder in DTW.
You have to remember couple of things before you do this.
If you already have inventory in stock for an item and their cost gets changed then, the Material Revaluation would post the difference to the Variance Account.
Is this what you would do? I am giving below the sample for the DTW.
MaterialRevaluation (Header template)
RecordKey....DocDate
1..................20071210
MaterialRevaluation_lines (Lines template)
RecordKey....ItemCode.....Price......Quantity....WarehouseCode
1......................PCB1........11.00............................01
1......................PCB1........11.00............................02
1......................ATG1........10.50............................01
...
...
NOTE: If you have the same item in mutiple warehouses then you will have to add a line for each warehouse
Please let me know
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi experts ,
Getting this error while try to import revaluation through DTW.
'1Created FailedInternal error (-5002) occurred Internal error (-5002) occurred65171'
Could you please help.
And yes items has FIFO layer.
many thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
9 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.