on 10-25-2013 3:57 PM
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
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:
| ParentKey | LineNum | AbsEntry | UoMEntry | Barcode | FreeText |
| ItemCode | LineNum | BcdEntry | UomEntry | BcdCode | BcdName |
| X1001 | 2083 | 2 | 1012345678 | Pack Barcode | |
| X1001 | 2084 | 3 | 2012345678 | Case 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Hi Miss..
It is Not Possible by the default system behavior
Hope helpful
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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![]()
| AbsEntry | ItemNo | UoMEntry | Barcode | FreeText |
| AbsEntry | ItemNo | UoMEntry | Barcode | FreeText |
| AA AUR3 | AA AUR3 | -1 | 0795626006306 | |
| AA AUR3 | AA AUR3 | -1 | 0795626006313 |
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
Hi,
To DTW barcode to OITM codebars, you just need OITM template. I am not sure there is template for OBCD.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.