Skip to main content

From the Microsoft Dynamics AX Blogs: Hiding Docs from Reconciliation Worksheet; Free Gift Cards in R3; Email Profiles; Text Translations

by Linda Rosencrance
Contributing Writer, MSDW

A selection of the latest insight from the Dynamics AX blogs:

  • Hiding Open Bank Documents from the Bank Reconciliation Worksheet
  • Issue Gift card for Free in Microsoft Dynamics AX 2012 R3
  • Every Time An E-Mail Is Sent Through Outlook from AX, You Are Prompted with "Choose Profile"
  • Adding Text Translations to Entities Using X++

Hiding Open Bank Documents from the Bank Reconciliation Worksheet

On the Microsoft Dynamics AX Support Team blog, Bertrand Desmarest explained that the bank reconciliation worksheet is used to reconcile transactions from a previously imported bank statement with bank document transactions that are received or posted in Dynamics AX 2012. However, the form is only for matching transactions and it can't be modified.

"In the event of a bank error, there may be two bank statement lines listed in the imported bank statement and the lines must be reconciled. This can be achieved using Matching rules with "Clear reversal statement lines" actions as explained here."

For example, if a Dynamics AX user posted a vendor payment journal in error, the only way to revert the transaction is to post another vendor payment journal, reversing the amount. Still, the transactions can't ever be reconciled and that means they'll continue to appear in the bank reconciliation worksheet, and the reconciliation process will become more difficult as time goes on.

You can learn how to identify the transactions that do not need to be reconciled

About Linda Rosencrance

Linda Rosencrance is a freelance writer/editor in the Boston area. Rosencrance has over 25 years experience as an reporter/investigative reporter, writing for many newspapers in the metropolitan Boston area. Rosencrance has been writing about information technology for the past 16 years.

She has covered a variety of IT subjects, including Microsoft Dynamics, mobile security issues such as data loss prevention, network management, secure mobile app development, privacy, cloud computing, BI, big data, analytics, HR, CRM, ERP, and enterprise IT.

Rosencrance is the author of six true crime books for Kensington Publishing Corp.