Importing beginning item costs

I need to import beginning inventory costs. I found thread () which points to some helpful links, but nothing about how beginning costs get imported. Can somebody please assist? I don't want my inventory being sold at 0 cost. Thanks

SAP Managed Tags:
SAP Business One

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Please check SAP Note Number: 841270 & 814125 to find right format and complete templates set.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks Gordon, but those 2 notes you mentioned only give direction on the creation of the LineNumbers and Serial Numbers files. How about the actual Documents file? I've reviewed the documents.csv file in the oInventoryGenEntry folder, but I really don't see the point of it. I'm trying to import using it now, but i only populate the RecordKey field in row 1 with a "1".

Since the oInventoryGenEntry DTW import requires the Documents file before you can specify the Line Number and Serial Number files it seems to be required.

I am now getting this error..."01689BERR cannot be released from stock without a full serial/batch no. 'Application-defined or object-defined erroroInventoryGenEntry."

I have serial number specified for each item in my import.

How many files have you prepared? It has to be 3. And also the file format will be better by Tab Delimited Text.

yes, 3 files, tab delimited. Documents ony has "1" under recordkey in row one. The other 2 files are prepped according to notes 814215 and 841270.

I think my problem is the systemserialnumber field. I can't find this field on the document lines template under oInventoryGenEntry folder. Looks like its a required field for importing according to note 814215, but what field do I populate with this data????

You should have SystemSerialNumber in the SerialNumbers file, don't you?

I am using the oInventoryGenEntry template called Document_Lines template for both my Document lines and serial number file import. Should I just disregard this template for the serial number import and create my own using just the 5 fields mentioned in note 814215? The Document_Lines template only has one serial number field and its called "SerialNum".

You have to check that note carefully and use the exact files and fields to upload. There are attached files under the notes could be downloaded to save your time.

i don't see a serial numbers file anywhere. I looked in oInventoryGenEntry and oItems. I don't see any oSerialNumbers folder so I don't know where else to look.

In the templates folder, you will see a separate template under oInventory for serial numbers. In the database, the field Serial Numbers at document line level is informational only and does not related to the required table for serial numbers.

You should upload three sheets - Documets, Document Lines and Serial Numbers

lemme ck the attachments at get back to you.

I have downloaded the serial number templates and i STILL get an error "You should use existing serial/batch numbers for this document type".

I don't understand why the error is instructing me to use existing serial numbers. If I am uploading beginning inventory quantities, costs and serial numbers then DTW should not be instructing me to use existing serial numbers. Is there some way to load serial numbers into SAP without any associated items????

What is confusing is that Note 814215 instructs the population of the InternalSerialNumber field in the serial number file, but Note 841270 leaves this field blank in its serial number file. I have tried both ways and get the same error above.

I figured this out by simply looking at the OSRI table and reviewing the records for serial numbered transactions i had entered manually. It became clear that the sysserial number field simply increases by a value of 1 for every item/serial number combination entered in a transaction. I also noticed that the IntrSerial stores the value of the actual serial numbers.

Once I switched my serial numbers over to the InternalSerialNumber field and left my SystemSerialNumber field empty my import was successful.

This being the facts I have no idea why notes 841270 and 814215 indicate that the serial numbers should be stored in the systemserial number field. It's misleading and cost me hours of time.

If you use oInventoryGenEntry to DTW initial on hand, you would get item Last Purchase Price updated. In that way, item cost can be calculated.

Thanks,

Gordon

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Does your suggestion change at all if I have both serial number tracked and non serial tracked items? thanks

Hi ! Robert Eppele

I belive u r taking about Initial Quantity Loading. There is no option in SAP B1 to load Initial Quantity.

As an Workaround u can do this.

1. Create a User Table with fields (Type and legth should be as in SAP B1 Master), itemcode,warehousecode,price

2.Import this deatils through DTW. (Generate template from DTW) or

Go to SQL, open the user table and paste the values straight away.

3.write formmated search in Initial Quantity window on Price field.(compare itemode and warehousename

with user table)

4.Refresh the query on Opening balance offset account.

5. If account change, it acctomatically load the price column in "Initial Quantity Window".

6.Click Add to Post.

Please check this in your Test System and Do in Live. I have Loaded Initail Quantity like this only for my customer.

Regards,

Thanga Raj.K

09710445987

In your posting, or Go to SQL, open the user table and paste the values straight away. That is not allowed by SAP support policy. That action will make you at risk loosing SAP support. Be careful in your suggestion.

Thanks for the suggestion Thanga, but it looks a little too tricky for me to attempt as I'm not an advanced SBO user.

Gordon, your suggestion is something more what I was looking for. Just a DTW import template is the answer I was hoping to find. However, I can't find the oMaterialGenEntry import you mentioned in the list of templates. I don't even see such an option to choose as an import option. Can you provide some more help?

I can't believe there's not a simple means of importing beginning inventory quantities and costs. And to do so without hitting the GL.

Hi,

Actually its oInventoryGenEntry.You can also find the examples to fill the template in the path 'C:\Program Files\SAP\Data Transfer Workbench\Templates\Data preparation examples'.

(If you have installed in the default path)

Hope this is helpful.

Rgds,

Sundar

Sorry. It should be oInventoryGenEntry. I just used oMaterialRevaluation too much and miss typed.

Ok, thanks i did find the oInventoryGenEntry templates and filled out the Documents and DocumentLines files, but I'm getting errors on the oInventoryGenEntry import. Below is the data in my files.

Documents (3 rows same data in each field)

RecordKey = 1

DocumentDate = 20090401

Document Lines (3 rows of data)

RecordKey = 1,1,1

LineNum = 0,1,2

AccountCode = _SYS000000003, _SYS000000003, SYS000000003

ItemCode = 01689BERR, 01689COFF, 01689CHOC

LineTotal = 100, 120, 280

Price = 50, 60, 70

Quantity = 2, 2, 4

SerialNum = 9999, 8888, 7777

Below are the 3 errors I am getting in sequence.

Data cannot be empty in one of the tables, Doc1, Doc3, Doc10, [IGN1.LineNum][line:0]Application-defined or object-defined error oInventoryGenEntry

[IGN1.ItemCode][line:1], 'VR - 01689BERR' Application - defined Object - defined error oInventoryGenEntry

Data cannot be empty in one of the tables, Doc1, Doc3, Doc10, [IGN1.LineNum][line:0]Application-defined or object-defined error oInventoryGenEntry

Ask a Question

Top Q&A Solution Author

User

Count

100