on 09-09-2008 9:38 AM
Hi all,
This is my template:
Header:
RecordKey...DocCurrency DocDate DocDueDate
1...VND 20071231 20071231
Lines:
RecordKey LineNum AccountCode ...ItemCode...Price...Quantity
1 0 999999 PIPE01 225912 1
1 1 999999 PIPE02 132413 1
Serial Number:
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.
Thank you.
With best regards,
Son.
Edited by: Son Tran Van on Sep 9, 2008 3:38 PM
A question: Is it true value that 999999 in your example code for account code?
All system account numbers look like _SYS00000000xxx.
Please check if you put in the right account code for your DTW.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Son
Are you trying to import an opening stock balance, hence looking for a JE (journal entry). This cannot be done by importing using the Items templates in DTW it has to be done using the stock taking template. We use standard costing so we can import prices into OITM [AvePrice]. I think that you you would have to create a price list and then import the opening stock balances and select the required pricelist when using the stock posting window. I am going to be doing this in the next few days for a new company and I think that this is the correct sequence of events. The last time I did this was 2 years ago so I hope I have remembered correctly. I do not know how to handle the serial number issue.
Best regards
Stewart Clark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Stewart Clark,
Thank you for your response.
I imported successfully the opening stock balance using the stocktaking template for several times.
There have some threads, notes about importing item with serial numbers using oInventoryGenEntry. But I fail to import .
I don't know what could I miss in template or some things else?
Regards,
Son.
Hi
Check if the following SAP Note would help you:
SAP Note : 841270 - How to import serial numbers correctly via the DTW
[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=841270]
SAP Note : 814215 - How can I assign serial/batch numbers to initial quantities
[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E¬e_numm=814215]
Edited by: Sridharan T on Sep 9, 2008 7:44 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Son,
What kind of valuation method did you choose for the items?
If they are FIFO or Moving Averagethe system will calculate it according to the information added in Business One.
Kind Regards,
Marcella Rivi
SAP Business One Forums Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.