Sales Tax Automation for Microsoft Dynamics GP and Dynamics AX

If you do business in several tax jurisdictions, or in complex states, it can easily become more than a full-time job just to keep up with the ever changing tax rates and product taxability rules. Not only is compliance difficult to maintain, but even the simplest of mistakes can cost you thousands of dollars if audited.

Although you, or Tridea Partners as a Dynamics partner, can configure Dynamics GP or Dynamics AX to handle complex tax tables, we recommend using one of the third party solutions that handles the tax updates automatically.

One of the leading solutions is by Avalara (www.avalara.com), the creator of AvaTax – a cloud-based system – to help address your unique sales tax challenges. With complete integration to Microsoft Dynamics GP and Dynamics AX, AvaTax removes the difficulty of managing sales tax compliance by helping to eliminate the tedious work and complexity that goes into calculating, reporting, filing and remitting taxes.

Sales tax automation software can help:

• Achieve full end-to-end sales tax compliance
• Automate manual processes involved with managing tax tables and updates
• Eliminate compliance holes associated with using a flat state rate or zip code-based systems
• Reduce your audit exposure through ‘bullet-proof’ compliance
• Outsource all of your sales tax filing requirements
• Automate the paperless collection and management of certificates

Managing sales tax can be complex and time consuming. Depending on your unique requirements, a sales tax software application may dramatically simplify things for your organization.

Recurring Batch Enhancements in Dynamics GP 2010

Many clients have asked us in the past if they can utilize recurring batches for cash receipts. This is a more simplistic and flexible way of achieving what can also be done through a scheduled payments transaction. Dynamics GP 2010 now offers this capability.

The batch can be setup just like a GL recurring batch by updating the drop down menu for the Frequency field (shown in the screenshot below). The amount in the Recurring Postings field (shown in the screenshot below) indicates how many times this batch will be available for posting. Each time the batch is posted, the transaction dates are updated, but the cash receipt transaction amounts within the batch stay the same. If utilizing the EFT module, EFT Cash Receipt transactions can also be entered in recurring batches.

Batch Enhancements

Furthermore, GL Recurring batches have been updated in Dynamics GP 2010 as well. The new feature that has been added enables the user to Clear Recurring Amounts for Recurring batches after posting. This can be accomplished by simply checking the checkbox next to Clear Recurring Amounts in the batch entry window (screenshot shown below). This feature is similar to Quick Journals, but is more customizable. This feature helps to decrease data entry errors by allowing common journal entries to be created with ease. In addition, this feature prevents a user from accidentally posting a recurring batch without making necessary changes as the batch will not post until the user updates the amounts for the journal entry.

Recurring batch for cash receipts

 

Using Navigation Lists in Dynamics GP

Navigation Lists provide an easy and effective way of searching Dynamics GP records across master and transaction data and allowing users to take action on the records retrieved.

The Navigation List can be easily modified to include search criteria relevant to the individual by changing or adding columns, as well as adding filters on the columns selected. Utilizing multiple filters, the resulting query delivers specific data for review and analysis. Once data is retrieved, the list can be easily exported to excel, emailed to a colleague and saved. These saved lists can also be made available to users assigned to a specific role or can they can be shared with just individual users.

The Navigation List contains an Action Pane from which the user can execute transactions related to a particular item in the list. Selecting a task from the Action Pane ribbon links the user to the corresponding transaction screen in Dynamics GP. A big benefit of using the Navigation List to carry out transactions is that the transaction screen will prepopulate with header data related to the selected customer, vendor, account, etc. information, saving time on data entry.

The Navigation List also includes an Information Pane which gives the user the ability to drill down on detail information for each of the selected items in the list, allowing users to quickly review data without having to navigate through various screens.

The Navigation List is a powerful search, data retrieval and workflow tool within all Dynamics GP Series and should be readily utilized. For those users who have completely embraced the usefulness of the Navigation Lists, Microsoft has introduced the Navigation List Builder tool in Dynamics GP 2010. This module serves to further customize and integrate the lists to include exactly the data that they want, whether it is from a table in Microsoft Dynamics GP or any 3rd party product, as well as external SQL tables and views.