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.

Tuesday, November 29, 2016

Dynamics 365 for Ops - Customer Write-off Reason Codes

A new feature in Dynamics 365 is Customer Write-off Reason Codes, which allows you to specify write-off accounts by Reason code, effectively multiplying the number of write-off accounts you can configure in a legal entity.  Pretty cool, huh?

Credit and collections > Setup > Customer write-off reason codes

Thursday, August 11, 2016

Dynamics AX Number Sequence Gremlins

Sometimes number sequences do not advance as they should, especially when set to 'Continuous' under the General tab in Number Sequence setup.  I've seen this behavior with Journal Batch numbering more than any other number sequence type.  Here's how to resolve this quickly and easily if it occurs.

Navigate to Organization administration >> Number sequences >> Number sequences and select the offending Number sequence.  Then under Administration, select 'Status list'.  

Click image to enlarge

Delete any records that appear in this list.  No Edit or Delete button you say?  Not to fear - type Alt-F9 (the keyboard shortcut for Delete in AX).  Voila.  Problem solved.  Go back and try your journal again.

Wednesday, July 20, 2016

Microsoft Dynamics AX New Features: Workspaces

I'll be presenting a 30 minute webcast on July 27, 2016 at 12:30 PM EST on the new Workspaces in Dynamics AX.  Join us to learn how to use and customize Workspaces and gain some familiarity with the new AX user interface.  Click WORKSPACES to sign up.  Hope to see you there!

Tuesday, July 19, 2016

Dynamics AX Task Recorder Screenshots

I found out recently that Task Recorder in AX7 does not create screenshots by default when exporting a task recording as an MS Word document.  Oddly enough, one has to be running the Chrome browser and download and install an extension to Chrome to enable screenshot capture in Task Recorder.  Once this is enabled, screenshots will be captured in the Word doc, just as we've been accustomed to in previous AX versions.

Here's the link to the instructions and the extension download:

Thursday, October 15, 2015

Running a depreciation projection in AX

Wish you could project depreciation for the coming year for budget purposes?  While AX doesn't have a formal depreciation projection function, with a little creativity, we can create one.

Step 1 - Create a new Fixed Asset Proposal journal.  Give it a descriptive name and add 'DO NOT POST' to the description, just to be safe.  The last thing we want to post a year or more of depreciation inadvertently.

Step 2 - Click the Lines button, then Proposals>>Depreciation.  Set the 'To date' to the depreciation end date.  You can also filter the proposal by Fixed asset group and/or Value model.  Click OK and sit back and wait for the proposal to generate.

Step 3 - Once the Lines window is populated, press Ctrl-t to transfer the results to Excel.  At this point, you can also enter a Release date way in the future to be extra safe about not posting this journal.

Step 4 - Filter or Pivot the results in Excel to limit the periods in your projection to the desired result set and group the results as desired.


Voila - a depreciation projection for your enjoyment.