Dynamics AX 2012 : Quick Way to Copy or Reverse a Journal

There are a couple of ways to reverse a journal in Microsoft Dynamics AX. One is to use the “Reverse transaction” option from the GL inquiry screens.  This is a quick and easy way to reverse entries, but there are many entries which cannot be reversed, and when transactions are reversed, they are automatically posted without being processed by a workflow or an approval group which is a problem for many organizations.

The other option is to use the “Load ledger balances” functionality in the journal screen to load a journal that has already been posted. This is really a copy function that can be used to copy a prior journal with reversed transactions which can then be routed through an approval process.

To copy a journal:
  1. Create a general journal as you normally would and click Linesax 2012
  2. In the lines form, click on Functions and then select Load ledger balances.ax 2012
  3. On the Load ledger transactions form:
    • Verify the voucher is set to New voucher number per voucher.
    • Click the Invert sign check box if you would like to reverse the journal.
    • Click Selectax 2012
  4. On the Select screen, enter the Journal number that you would like to reverse or copy and click OKax 2012
  5. You are now back on the Load ledger transactions screen, click OK.ax 2012
  6. Upon clicking OK, AX will load a copy or reversal of the journal you selected in the current journal form. Notice in the case of a reversal, AX inserts the description of Void and the voucher number.ax 2012
  7. You can now submit your journal through the review and approval process and post!

This post was written by Matthew Caffrey, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider.


Boston Dynamics Networking Event

Tridea Partners had a successful Networking Event in Boston two weeks ago. We wanted to thank everyone who came out to our event! The Frost Ice Bar was a great venue to have our first event in Boston, MA. We wanted to share some pictures from our successful event! Cheers to more growth!




2016 Dynamics Customer Event

Come network with your peers and enjoy Ballast Point’s freshly brewed beer and appetizers at the 2016 Dynamics Customer Event! See what’s available in the latest releases of Dynamics AX, Dynamics GP and Dynamics CRM.
What else will I see at the event?

  • Roadmap and newest product releases for Dynamics
  • Introductions to Avalara and Solver
  • Microsoft Device Bar
  • Appetizers, wine and beer!

Interact with Microsoft and Tridea Partners as you learn how you can extend your Dynamics Solutions.

Dynamics AX: Verify W-9 Received from 1099 Vendors

Microsoft Dynamics AX 2012 R3 has many features that will make your life easier! If you work in the accounts payable department processing invoices, you may want to verify that a 1099 vendor has provided their W-9 form before any invoices are posted for that vendor. AX 2012 R3 has a helpful feature which will automatically generate an infolog to alert you that a W-9 has not yet been received from a 1099 reportable vendor when an invoice is being created.

To enable the ‘Check for W-9 form’ functionality in AX 2012 R3, follow these steps:

On the Accounts payable parameters form, enable the ‘Check for W-9 form’ checkbox on the Invoice tab.

By selecting this checkbox, any newly created vendor record will automatically have the ‘Check for W-9’ checkbox enabled by default. The AP clerk who maintains vendors then has the option to deselect the field for each vendor if the infolog warning is not necessary for a particular vendor.

1099 Vendors

On the vendor record, the ‘Check for W-9’ checkbox will default as selected on the Tax 1099 tab. If the vendor has provided a W-9 form, click the ‘W-9 received’ checkbox to record it. You can attach the W-9 document to the vendor record using the Document handling functionality by clicking the ‘Attachments’ button on the Action pane.

Vendor 1099

For our example, we have not yet received a W-9 from our 1099 vendor and want an infolog generated to warn the AP clerk. We will leave the ‘W-9 received’ checkbox cleared and the ‘Check for W-9’ checkbox enabled.

Vendor 1099

Now when the AP clerk creates an invoice for a purchase order or a non-purchase order invoice journal for our 1099 vendor, an infolog is generated which warning the user that a W-9 form has not yet been received for that vendor. The AP clerk can still post the invoice or place the invoice on hold until the W-9 is received from the vendor.

1099 Vendor

For more information – check out our Webinar on 1099 Report Processing

This post was written by Robin Ellsworth, AX Application Consultant at Tridea Partners. Tridea is a leading Microsoft Dynamics provider.


New Dynamics AX: Personalize Grid Views

On March 9, 2016, Microsoft officially launched the New Dynamics AX (formerly referred to as AX 7). The new release is fully hosted in the cloud on Azure and sports a brand new HTML 5 user interface. This allows access to the application from just about any device using most of the leading web browsers.

One of the most widely used user interface features in previous versions of AX was the ability to add additional columns of data to the grid view of a particular form. This functionality has been retained in the NEW AX, but the way you access it is a little different.

Read the full article on the ERP SoftwareBlog