Can't import Item with Quantities, Serial Number and ItemCost
This is my template:
RecordKey...DocCurrency DocDate DocDueDate
1...VND 20071231 20071231
RecordKey LineNum AccountCode ...ItemCode...Price...Quantity
1 0 999999 PIPE01 225912 1
1 1 999999 PIPE02 132413 1
RecordKey BaseLineNumber InternalSerialNumber SystemSerialNumber
1 0 2007PIPE01 2007PIPE01
1 1 2007PIPE02 2007PIPE02
It worked. However, I just see quantity and Serial Number in SAP B1. The import process don't create any manual JE to reflect item cost of each imported item.
May I miss somethings ?
Please give me advice how to solve this issues.
With best regards,
Edited by: Son Tran Van on Sep 9, 2008 3:38 PM
Please go to Administration > System Initialization > Document Settings and check the settings as described below
CHECK BOX: Calculate the row total using the unit price
Is it Checked, Please Uncheck and try the import