Item bar Code

Hi All, I want to import the item master from Excel. They will gave bar code for item import. Bar code contains itemId+batchNo. Then i need to get item id from the bar code and release it for all companies. Can any help to this Thanks in Advance.

import excel in one table using the excel addins

now you have data in ax

use the class barcode**** to extract information from the barcode , you have to use the class on the basis of your barcode type

use the above link to create record in product master from your table