Using barcodes...

(0) Share

Report

Posted on by Sartor

225

I am looking for a setup for integrating barcodes with AX purchase and sales orders, i.e. using a USB scanner to enter all the information about a particular item into the order.

1. I've made the needed setups under Basic -> Setup -> Bar code setups

2. I've assigned barcodes to an item under Item master -> Setup -> Bar Codes. I've made all the configurations there including allowable for scanning and printing, etc.

3. Finally I create a sales order, and under Other tab of the lines of the sales order, I scan the bar code in the Bar Code field.

However, the information is not retrieved from the DB for the item that is associated with the barcode - including item dimensions, item ID, etc... nothing is retrieved.

Using Item ID for a bar-code IS NOT an option. So is it possible to retrieve the item information by scanning the barcode into the barcode field of a sales/purchase order line? Am I missing any setup?

*This post is locked for comments

All responses (10)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Using barcodes...

[quote user="---"]

Hi,

Did you resolve your issue?

I have read on the internet a bit and it states that what you have setup should do the trick. I did however not succeed either. I did not connect a barcode scanner, but just copy-pasted the EAN code in the item field as described in some post. However, no success. So I investigated a bit the source code, but I have not been able to set a good breakpoint to find out what code is executed. I might expect some lookup on itemid which involved the barcode table as well.

J.

[/quote]

so how 's the result after looking up on itemid
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Using barcodes...

Sartor, The barcode field on the Sales form is just there for reference. The best way to enable what you want to do is to modify the validate method of the ItemID field. Here is a post that shows you how:

discoverax.blogspot.com/.../entering-sales-orders-by-barcode-gtin.html

Hope this helps.
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Pending: Smart solution enter barcode in search field

Refer link below for details.
http://microsoft-axapta.blogspot.com/2010/05/setting-up-bar-code-in-ax-2009.html
Hope this helps.
Regards,
AbdulAleem
user5555 7,435 on at

Like (0)

Report

Re: Re: Re: Pending: Smart solution enter barcode in search field

Hi,

I tried to find some entries in code where the barcode is looked up. but no success. I came across this piece of documentation: http://blogs.msdn.com/b/dynamicsaxscm/archive/2009/05/17/changes-in-sales-and-transfer-order-picking-from-microsoft-dynamics-ax-4-0-to-dynamics-ax-2009.aspx. Maybe those people can help. The article states something about barcode in the picking list registration of WMS II. Not exactly sure what they mean.

J.
user5555 7,435 on at

Like (0)

Report

Re: Re: Pending: Smart solution enter barcode in search field

Hi,

I believe we talk about 2 different things. The initBarcode you mention does store the barcode in the sales line (or look it up based on the itemid and inventdim). I am not sure why the sales line would need to store the barcode and its type

server void initBarcode(InventDim _inventDim = this.inventDim())
{
    InventItemBarcode   inventItemBarcode = InventItemBarcode::findSalesBarcodeDimension(this.ItemId, _inventDim);
    ;
    this.BarCode        = inventItemBarcode.ItemBarCode;
    this.BarCodeType    = inventItemBarcode.BarcodeSetupId;
}

I guess that what we are looking for is a barcode search in the table InventItemBarcode so that the itemId and inventDim is automatically filled in the salesorderline, purchaseorder line or transtables for posting updates. So creating a sales order by scanning the barcode and thus inserting new sales lines to a sales order. Or receiving goods from a PO and thus scanning the quantities received.

Something matching throughout the whole application at:

public server static InventItemBarcode findInputBarcode(ItemBarCode itemBarCode, BarcodeSetupId barcodeSetupId = '', boolean _update = false)
{
    return InventItemBarcode::findBarcode(strltrim(itemBarCode), false, true, barcodeSetupId, _update);
}

I do however not find any trigger. From the sales documentation it looks like default barcodes and rfid can be used. Though it looks like a half fabricate and some work still needs to be done. Not sure, but this is the feeling I have.

J.
Khaled Ahmed 2,467 on at

Like (0)

Report

Re: Pending: Smart solution enter barcode in search field

Dear ,

Kindly help me to find the three lines of code and where we can put it.

BR
Community Member Microsoft Employee on at

Like (0)

Report

Re: Using barcodes...

Hi Sartor,
If you look at the salesline you will have the following method. This method initializes the barcode from the item and dimension.
\Data Dictionary\Tables\SalesLine\Methods\initBarcode
What you are looking for is viceversa. So you have to write and invoke it on the barcode modified method to get it working....
user5555 7,435 on at

Like (0)

Report

Pending: Smart solution enter barcode in search field

@Khaled,

Indeed a smart work around to get at least something running. This makes the search field for what it is intented useless. So that is why I believe the best solution is to find out how to activate the barcodes. I think 3 lines of code would also be a work around (look up the barcode table based on an itemid). This code should be placed correctly and only once so that it is triggered for all forms etc. This will avoid modifying all forms. The code could also reference a dll for more sophisticated scanners.

I believe there must be somewhere an entry. It takes just some time to find out.

J.
Khaled Ahmed 2,467 on at

Like (0)

Report

Smart solution

Dear …,
I have a seam issue, but I made easy and good solution.What is it? I put the barcode of item in the search name of item it will be fetch the item automatically. Try it then tell me .
BR
user5555 7,435 on at

Like (0)

Report

Re: Using barcodes...

Hi,

Did you resolve your issue?

I have read on the internet a bit and it states that what you have setup should do the trick. I did however not succeed either. I did not connect a barcode scanner, but just copy-pasted the EAN code in the item field as described in some post. However, no success. So I investigated a bit the source code, but I have not been able to set a good breakpoint to find out what code is executed. I might expect some lookup on itemid which involved the barcode table as well.

J.