cancel
Showing results for 
Search instead for 
Did you mean: 

DTW OBCD Bar Codes

Former Member

Hi

I need to import through DTW of the articles, they are associated with more barcodes.

The first barcode him back in the field CodeBars in the table OITM.

Other barcode wanted to import these tables OBCD through DTW.

Could you tell me the templates to use to do the import?

My versions is SAP 9.0 PL 01.

Thanks

MissN

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member

Working with Multiple UoM Barcodes in SAP Business One ver 9.0

Question:

We have barcodes for items with multipple UoMs. How do we import them to SAP Busines one ver 9.0 using DTW ?

Answer:

Lets say you have a item X1001 with multiple UoMs and their barcodes.

For example:

Item          Barcode          Barcode Type              Qty in Each Uom

X1001     0123456789       Single Barcode                        1

X1001     1012345678       Pack Barcode                          6

X1001     2012345678       Case Barcode                         48

Basic Understanding of OITM and OBCD tables

In OITM (Item Master table) barcode are recorded in the field [codebars] for the inventory Unit of Measure only. When you enter the barcode using Item Master Data form, it also creates an entry in OBCD table.

To perform the above task you have to do the operation in 2 steps.

Step 1: Import barcodes for Inventory UoM Barcodes using OITM template.

Prerequisites: Make sure that UoM Groups defined in OUGP, and relevant entries for each UoM Groups is defined in UGP1. Items exists in item master table.

create a new template of OITM and add only Itemcode and Barcode of Inventory UoM  by selecting  Update Records from DTW,  NOT Add New Records.

Step 2: Once all the barcodes for Inventory UoM are imported then import other UoM Barcodes only using the method below

Use OBCD template as shown below:

ParentKeyLineNumAbsEntryUoMEntryBarcodeFreeText
ItemCodeLineNumBcdEntryUomEntryBcdCodeBcdName
X1001208321012345678Pack Barcode
X1001208432012345678Case Barcode

Parentkey = Itemcode

LineNum = leave it blank

AbsEntry = Query OBCD and look at the last number of [bcdentry] field, and add one for the next record. for example if [bcdentry] is 2082 then you will use 2083 in your OBCD template and next record will have 2084 and so on.

UoMEntry = this is the value of [uomentry] field from the OUOM table

Barcode = actual barcode of the item for that UoM

FreeText = optional to define the type of barcode

I hope this will help others as I found this easy method for updating 18,000 x 3 barcodes for each item.

Former Member
0 Kudos

Hi Khizer Hayat

What you explain works great

However, I realized that when I try to create N barcodes for an especific item (not following what you said), I get an error that the object does not exist or that the item number does not exist. I realized this is because the DTW maps it incorrectly, something like:

And it should be something like:

So your explanatins is great in order to understand how barcodes really work in SAP, but in my specific case I just wanted to have 1 itemCode associated with N barcodes so I guess this other way to go would also be useful.

KennedyT21
Active Contributor
0 Kudos

Hi Miss..

It is Not Possible by the default system behavior

Hope helpful

Regards

Kennedy

Former Member
0 Kudos

Ok .... the templates for OBCD however exist.


I need to import about 10 barcode for each item (about 8,000 items), so if I can not with the DTW I have to find another method.


Thanks

Miss N

Former Member
0 Kudos

Hi

I have same problem, did you have a solution ?

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

You can use OITM template to add bar code.

Few problems already reported for the subject to SAP. Please refer SAP notes  1880807 1890506

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi

if I use the templates of the table OITM (only the columns ItemCode and CodeBars) I do not add new barcode but I always overwrites the first.

I tried the path:

MasterData-> AddNewData-> Inventory-> ItemMasterData-> Items

For example I have item number "AA3" associated with these barcode

0795626006313

0795626006306

0795626006238

Thanks!!

MissN

Former Member
0 Kudos

OITM can only hold one barcode. If you need assign multiple barcode, it may not be available through DTW.

Former Member
0 Kudos

I found a template for barcode with the following columns:

AbsEntryItemNoUoMEntryBarcodeFreeText
AbsEntryItemNoUoMEntryBarcodeFreeText

And under the heading Inevntory in DTW I find the voice BarCode.

That's why I thought you could do.

MissN

Former Member
0 Kudos

That is the right template. Have you tried?

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

How did you add same item code with different barcode in template? Whiile importing DTW throws an error message.

So, you need to add one item with single barcode while updating.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

In fact if I use OITM, with 3 records with the same itemcode sovrascive them.

With templates I posted I tried in this way (assuming you have entered the barcode 0795626006238
  in the classic templates OITM:disappointed_face:



AbsEntryItemNoUoMEntryBarcodeFreeText
AbsEntryItemNoUoMEntryBarcodeFreeText
AA AUR3AA AUR3-10795626006306
AA AUR3AA AUR3-10795626006313

The error that returns the DTW is the following:
System.Object does not contain a DEFINITION for BcdCode 65171
and
Already 1250000133 Exclusive queues exist

If I change the column Barcode in BcdCode I get the error:

barcode can not be empty

Former Member
0 Kudos

OITM can only allow one barcode. It is not possible to DTW multiple barcodes.

Former Member
0 Kudos

Hi,

To DTW barcode to OITM codebars, you just need OITM template. I am not sure there is template for OBCD.

Thanks,

Gordon