HI All,
I want to find list of all items for which barcodes are not defined. Could you help with x++ code for retrieving data in AX 2012.
Thank you in advance.
*This post is locked for comments
This job may be helpful
while select InventTable
notexists join InventItemBarcode
where InventItemBarcode.itemId == InventItemBarcode.itemId
{
info(InventTable.ItemId);
}
HI Amir,
Thank you for reply.
I require data individual wise as well
for example item is 1001 and sales uom is AAA, purch UOM is BBB, Invent UOM is CCC
and barcode details as mentioned only for
1001 SalesUOM AAA axapb(barcode details)
now my result should be like
1001 Purch UOM BBB
1001 Invent UOM CCC
Hope you understood my requirement, Thank you.
Add one more join with InventTableModule. it has field ModuleInventPurchSales which determine the respected type of this record which can be sales, purchase or Inventory.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Community Member 2
Nayyar Siddiqi 2
