Ax, this is another corner

this article is talking about inventory calculation I wrote this in Bahasa (english version will at next posting) Inventory Closing Alasan dilakukan Inventory Closing berkala Agar tidak memberatkan perhitungan recalculation inventory pada masing-masing entity di AX, karena perhitungan recalculation dilakukan pada periode setelah inventory closing terakhir. Akibatnya jika inventory closing dilakukan dalam periode yang lama, recalculation akan semakin lama, dan berpengaruh kepada load aplikasi axnya sendiri ketika menjalankan transaksi yang berhubungan dengan inventory, seperti receive good, picking list, packing slip, sales invoice Secara default, nilai COGS di trans...

you have 2 tables, the first table contains ‘123’ record and the second table do not the question: how to view table in first table that not contains record in second table case: I want to know, what item that is not in sales in basic sql: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 declare @ dataareaid varchar ( 4 ); set @ dataareaid = 'Tes' ; select distinct a.itemid from inventtable a left join salesline b on a.dataareaid = b.dataareaid and a.itemid = b.itemid where a.dataareaid =@ dataareaid and b.itemid is null order by a.ITEMID so, the record will show the item that are not in sales line.

when you create a report designer in ax,and creating a duplicate from the other reports, sometimes, the paper size isn’t same from the report source while you trying to print the reports the problem is because aos did not detect the setting of paper print, check it by look the report properties, and field “changed by”, “change times” how to solve this problem: