DTW for Material Revaluation

[Former Member]

Can anyone help me on how to import data for material revaluation. I encounter error "The field is too small to accept the data65171. Hope you can help me on this. Thank you.

[Former Member]

Below is the header

RecordKey Docentry Comments Docdate JournalMemo Reference2 Revaltype

RecordKey Docentry Comments Docdate Journal Memo Reference2 Revaltype

1 01/29/2009 P

RevaluationExpenseAccount RevaluationIncomeAccount Series Taxdate

RevaluationExpenseAccount RevaluationIncomeAccount Series Taxdate

01/29/2009

Lines

RecordKey LineNum DebitCredit Itemcode Price Quantity RevaluationDecrementAccount

RecordKey LineNum DebitCredit Itemcode Price Quantity RevaluationDecrementAccount

1 0 20 D-100-165-A0 25.00

RevaluationIncrementAccount WarehouseCode

RevaluationIncrementAccount WarehouseCode

WHSE-FG

[Former Member]

There are few problems in your file:

1. Date format should be YYYYMMDD

2. Account Code is mandatory for those 2 counts in Line file.

3. You would be better to omit other fields without entry

Thanks,

Gordon

[Former Member]

In the accountcode it should be in _sys format? Also what is the use of the debitcredit column?

Edited by: Michael Litiatco on Jan 30, 2009 1:33 AM

[Former Member]

That is right. It should be _SYS if you use segregated account. Those accounts are needed for booking the increase or decrease of inventory value. You can assign one account for both.

[Former Member]

Hi Gordon,

What is the template of Inventory Revaluation in SAP? I already used the Material Revaluation but no document was created but the import was successful.

Thanks

Michael

[Former Member]

Hi Gordon

My mistake the dtw was in a test run so it was not posted in the inventory revaluation. Can i know was is the used of debitcredit column?

Thanks,

Michael

[Former Member]

Those are needed for booking the increase or decrease of inventory value

[former_member583013]

If you would like to increase / decrease a fixed amount from the Inventory Stock value without updating the quantity, you use the Revaluation Type Inventory DebitCredit.

In such cases you will use this column to enter the amount

Suda