AX Notes

AX has standard Good received not invoiced report that is available only for United States and Canada. This report can be made available for other countries with little tweaks in the AOS. Go to /Menu Items/Output/VendAccruedPurchases_NA under AOT. Remove the value on the “CountryRegionCodes” properties. Save and compile the object. Go to /Procurement and sourcing/Reports/Status/Accrued purchases/ to open the report.

Rolling out entity (new company) in AX 2012 is more difficult than in 2009. There are some data that can’t be easily copied across. There are many ways of achieving this. But specifically in this article, we’re talking about copying the journal name. And yes, Journal Name can be copied across using the Standard AX Export Import binary file (not Data Import Export Framework). The only issue with copying the Journal Name using the above method is the number sequence for the voucher series still referred to the originating company. Though it’s still working when you create journal with this name, but the next number sequence used isn't from the entity itself. In above example, the voucher series is displayed correctly. We will find the anomaly when we perform right-click and view detail function. The company scope will be difference with the current company we working on. This is basically showing the data saved in the AOT as a result of an export import activity. The scrip...

I found that generating separate asset calendar in every new Fixed Asset implementation is rather important. There is a requirement to have all the years available for your migrated fixed asset  before you can upload the value model. Let's say you have the asset since 1990 in the register and this asset is included as part of the migration. This will require you to have the calendar since 1990 before you can upload the opening balance. Creating the calendar since 1990 can be a bit painful, especially if you have different environment such as Development, Training, Testing, and Production environment. It means that you have to populate the calendar since 1990 to years in the future in all server environment. I've created a script to help populate the calendar easily. You may need to change the calendar name in variable.     static void TI_PopulateFACalendar(Args _args)     {         AVIFiles         FiscalCalendar ...

AX 2012 R3 allows you to have penny difference during reconcile, when the difference is found, it will be posted according to the bank transaction type. Below is the details: The setup is found on the Bank Transaction Type Setup (Cash & Bank management/Setup/Bank transaction types)

We could easily use the load ledger transactions to retrieve transactions based on the "Journal Batch Number" in AX 2009. But that isn't the case in AX 2012. Some people found out that the Load Ledger Transactions function doesn't load anything when trying to retrieve transactions based on the journal batch number "Journal number" on above standard query doesn't refer to "Journal Batch Number". So that, the Journal batch number shouldn't be put on that field. Below shows you how to put the journal batch number query on the correct field. The field is available on the other table.