Thursday, July 20, 2017

Beware the Penny Difference

If you're using Project Management & Accounting and Accounts Receivable in AX (D365 for Ops) and you have a Maximum penny difference and Maximum over/underpayment value set here in A/R Parameters>>Settlement -



Any Project invoice for an amount less than or equal to the Maximum over/under payment tolerance will transfer automatically to the general ledger account you have specified here -


When you post the Project invoice, it will post and offer this message -



And here are the journal vouchers created upon posting, indicating the write off from A/R account to the Rounding account.



Strange but true!

Friday, June 23, 2017

Posting Vendor invoices during Period close

Another filing in 'things learned along the way'.  In D365 for Operations, if the Purchasing module is On hold for the period and you try to post a vendor invoice with a date that falls in the On hold period, D365 gives you the option to post into the next open period.  I think that is a pretty cool feature.


Thursday, June 22, 2017

Importing Chart of Accounts with Exchange Rate Type field populated

I file this under 'things learned along the way'.  I just discovered this tonight when importing Main accounts into a GOLD environment with the 'Exchange rate type' field populated in the source file. There must exist at least one Exchange rate in the Exchange rate table for each Exchange rate type imported.


Without one Exchange rate setup, the DIXF job will throw this error for each record that has that Exchange rate type assigned to it.


Note that 'Foreign currency revaluation exchange rate type' = Exchange rate type in the Main account form.