75
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
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.
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.
This job may be helpful
while select InventTable
notexists join InventItemBarcode
where InventItemBarcode.itemId == InventItemBarcode.itemId
{
info(InventTable.ItemId);
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (