AX Notes

If you’ve been wondering on how sometimes the GST (sales tax) amount in total doesn’t exactly turn out to be 10 percent (in this case GST in Australia). Or in the other words, the GST total amount has discrepancy than the given percentage. In summary, AX GST Total calculation works as following Ax will look at the total net amount of your tax invoice then multiply by 10%. The GST Total will then be distributed to each line based on the weighted average of net amount AX natively records the currency amount in 4 decimal places. And in your case the currency amount will be rounded in 2 decimal places. Your GST Total is supposed to be 9.91 (if you calculate it per line), however after doing the step 2 (distributing to each line based on the weighted average of net amount) and did the round of the GST Amount per each line. It will end up by having 9.89 My colleagues has created very good excel simulation in his blog, you can ...

Microsoft documentation for AX 2012 doesn’t provide clear steps on how to create new bank transaction based on the Marked new transaction in bank statement lines. These following steps can be followed to create the new bank transaction based on the bank statement line(s): During reconciliation process (under bank reconciliation worksheet), mark the statement line(s) that is indicated as a new transaction in the bank document. Or this step can be automated by using matching rules. Once marked as new transaction, open the related bank statement. Go to the line marked as new transaction and click ‘ Distribute amount ’ button. Put the ledger dimension string on Ledger account field. If you need to post into several accounts/dimensions you can utilise Split button. Close the Accounting distribution form and click post on the bank statement. This should help to create the new bank transaction automatically. Dynamics 365 Finance and Operations have the similar...