cancel
Showing results for 
Search instead for 
Did you mean: 

Can't import Item with Quantities, Serial Number and ItemCost

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Gordon Du,

999999 is opening balance account. My account system is non-segmentation. As I know, the format of _SYS00000000xxx is in segmentation account system.

Thanks,

Son.

former_member583013
Active Contributor
0 Kudos

So where does your import process stand now? Nothing imported or Everything imported with no price or whats it?

Former Member
0 Kudos

Hi Suda,

As my above posts, I used oInventoryGenEntry template to import. Everything is imported except no price added. That's my problem.

Please, help me.

Thanks,

Son.

former_member583013
Active Contributor
0 Kudos

Son,

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

Former Member
0 Kudos

Hi Suda,

Thank you for your help. It works.

That's great!

With best regards,

Son.

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

former_member583013
Active Contributor
0 Kudos

Please take a look at this thread and let me know if you have questions or if you are having problems with the error details

Suda

Former Member
0 Kudos

Hi Suda,

I read the threads and tried to import several times but still failed. The import process is successful but itemcost was not added to Item at last.

I don't know what reason make me fail in importing.

Thank you for your response.

Regards,

Son.

Former Member
0 Kudos

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&note_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&note_numm=814215]

Edited by: Sridharan T on Sep 9, 2008 7:44 PM

0 Kudos

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

Former Member
0 Kudos

Dear Marcella Rivi,

The valuation method is FIFO.

I think that the valuation method will not affect for creating JE when import process be done . I mean that a JE must be created at least.

What's happen and How to solve it.

Regards,

Son.