Material Revaluation

[Former Member]

Can Item Revaluation be done using DTW in SBO 2007A

[former_member200818 · Accepted solution]

Try using oMaterialRevaluation object of DTW.

-

---

I tried importing using DTW in SBO 2007A

MaterialRevaluation Template is filled with following sample values

RecordKey 1

DocDate 20080825

RevalType P

RevaluationExpenseAccount 130000

RevaluationIncomeAccount 130000

Series 1026

TaxDate 20080825

MaterialRevaluation_Lines Template is filled with following sample values:

RecordKey 1

ItemCode A1016

Price 18

RevaluationDecrementAccount 130000

RevaluationIncrementAccount 130000

WarehouseCode 01

Hope the information is helpful.

Regards

Satish

[Former Member · Accepted solution]

Hello Satish

I have tried the following example. but get this error : Update Failed. Cannot find this object in B1 application-defined or object-defined error oMaterialRevaluation.

here's my input :

RecordKey :1

DocEntry

Comments : WL Inventory Revaluation

DocDate : 26/08/08

JournalMemo : Inventory Revaluation

RevalType : P

RevaluationExpenseAccount : 6165-01-MNF

RevaluationIncomeAccount : 6165-01-MNF

Series : 22

TaxDate : 26/08/08

RecordKey :1

LineNum : 0

ItemCode : Test

Price : 100

RevaluationDecrementAccount : 6165-01-MNF

RevaluationIncrementAccount : 6165-01-MNF

WarehouseCode : JB01

RecordKey :1

LineNum : 1

ItemCode : Test

Price : 100

RevaluationDecrementAccount : 6165-01-MNF

RevaluationIncrementAccount : 6165-01-MNF

WarehouseCode : JB02

[Former Member · Accepted solution]

Hi Janice,

From your sample data, at least the date is in wrong format. You can check the sample data by Satish above. To make the first successful DTW, you would better put as less as possible in the available fields. When you have got first pass, adding field one by one.

Thanks,

Gordon

[former_member583013 · Accepted solution]

Hi Janice,

This is my finding by looking at your example

The Journal Memo should probably be left blank, the date format should be in yyyymmdd.

The columns RevaluationExpenseAccount and RevaluationIncomeAccount on the header should be left blank and the values for the same columns on the lines template should be taken from the AcctCode column in the OACT table.

LineNum on the lines template should be blank as it is used only during UPDATE

Please run this query SELECT T0.ACCTCODE, T0.ACCTNAME FROM [dbo\].[OACT\] T0 and use the values in the ACCTCODE column.

RecordKey :1

DocEntry

Comments : WL Inventory Revaluation

DocDate : 20080826

JournalMemo :

RevalType : P

RevaluationExpenseAccount :

RevaluationIncomeAccount :

Series : 22

TaxDate : 20080826

RecordKey :1

LineNum :

ItemCode : Test

Price : 100

RevaluationDecrementAccount : 6165-01-MNF

RevaluationIncrementAccount : 6165-01-MNF

WarehouseCode : JB01

[Former Member]

Hi Janice,

You can check this thread to have a reference:

Thanks,

Grodon