Posts

how to install windows identity in windows 10

Image
when you wants to install ax 2012 client on windows 10, you have to install all prerequisite first you’ll see on the picture above, we have windows identity foundations missing how to install windows identity foundation? in earlier windows version, you can install windows identity foundation using “Windows6.1-KB974405-x64 (Windows Identity Foundation).msu” (type KB974405 in google to download the msu file) but this wont works in windows 10,

clustered AOS for Load Balancer

Image
what is Load Balancer, If you do have more than 2 AOS license, you could use Load Balancer for ax balancing, this is tutorial to set the balancer 1. Go to System administration –> Setup –> System –> Server Configuration see on the top picture, I have 3 AOS license, I will set the 03@PH-SVR33 as Load Balancer

Inventory Closing – EN

Image
this article is talking about inventory calculation Inventory Closing Why You should Closed the Inventory All Ax Inventory transaction, recorded the transaction in average by default, so if the company did not use average costing instead using FIFO/LIFO Costing, every period they must recalculate the inventory so the inventory cost will change to FIFO/LIFO before they doing the financial closing. but in progress, the recalculation always start from the last closing inventory date, it means that if we do not closed the inventory, the recalculation will recalculate from old past period, for example, if the last inventory closing do on 2013, so recalculation starts calculate from early 2013. while we do the recalculation, the current inventory transaction will also recalculate the Cost (COGS), and if the recalculation periods start from past year, it will take an ax slow while doing inventory transactions such as receive good, picking list, packing slip and not forgot to ...

Inventory Calculation – BAHASA

Image
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...

notexists join in ax 2012 x++

Image
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.

AX Report Designer – Duplicate – Paper Print not same

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:

ax 2012 screen problem in windows 10 (X)

Image
lets call the day off while we change/upgrading the client platform from windows 7/8/2008 to window 10 (x) and all life goes on then when something different happens in using ax 2012 client you think your eyes getting problem. see the 2 picture below, (for internal reason, i had to filter the aos name) if you noticed well, we can see the different screen font while you’re not using window 10 (x). the font and the screen suddenly seems not good to see this happen because the setting of DPI scale how to solve it: