cancel
Showing results for 
Search instead for 
Did you mean: 

Mass inventory revaluation with standard cost

Former Member
0 Kudos
1,111

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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

former_member309532
Participant
0 Kudos

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