Are You Prepared for Sales Tax Auditors?

Due to the recession, most states are facing major budget deficits and state auditors are looking to sales tax as a way to help generate more revenue.  This can be a scary thought for businesses that manage sales tax compliance manually because even the simplest of mistakes can cost thousands of dollars in the event of an audit.

One of the first things to understand when it comes to audit risk is how nexus affects your business. Nexus in general terms means a connection. In the tax world it describes a situation in which a business has a “nexus” or presence in a state that makes them subject to collecting and remitting taxes for sales within that state.  Seems pretty straightforward, right?  Not exactly.

Most states used to define nexus as an office, warehouse or employee living in that state.  Fast forward to the present and it is not as cut and dry.  With states trying to generate more revenue, the lines have grayed over the years and states have broadened their definition of nexus.  Believe it or not, if you meet one or more of the following scenarios, you could be responsible for nexus in some states:

  • – Trade show attendance
  • – If a company has an associated business that shares a trademark or a substantially similar name
  • – If an affiliate runs “click-through” sites on behalf of Internet retailers and receives compensation for sales made as a result of that activity.  (If the affiliate lives in a particular state, then the sales taxes will need to be collected and remitted by the Internet retailer that received the click-through).
  • – If repair, installation or maintenance service is performed by your employees or a third party
  • – If your company ships a returnable containers into a specific state
  • – If a company has representatives regularly visit customers in a particular state
  • – If a company is using a company-owned vehicle that crosses state lines to deliver products

As you can see, it is now more important than ever to review the laws in each state where you conduct business to ensure that you are in compliance.  Often times, businesses do not even realize that they are out of compliance until they are audited, so the best defense against being audited is automation!

To learn more about the current “Amazon Laws” and about tips to navigate through the aggressive auditors targeting out-of-state retailers, please join Tridea Partners and Avalara on May 2nd at 10 AM PST for the educational webinar, Main Street vs. the Internet – How Online Sales Tax Affects Every BusinessRegister today!

Tridea Partners has partnered with Avalara, the leading provider of sales tax automation to help businesses from all industries address the complex challenges that businesses face when calculating sales tax rates, managing exemption certificates, filing returns and remitting payments. We look forward to helping you make sales tax management less taxing for your business!

Reconciling a Bank Account in Dynamics AX 2012

Reconciling a bank statement with all the bank account transactions created in a period can be a daunting and cumbersome task. Microsoft Dynamics AX 2012 provides easy to use functionality which makes reconciling a bank account a quick and painless exercise.

To reconcile a bank account, begin in the Cash and Bank Management functional area by following navigation path:

Cash and bank management > Common > Bank accounts

Select the bank account and click the Account Reconciliation button to open the Bank statement form.


Enter a Bank statement date, a Bank statement name and the ending balance of the bank account as it appears on the statement received from the bank.

Click the Transactions button to open the Account Reconciliation form.

The top portion of the Account reconciliation form lists the transactions which have not yet been reconciled.

Mark each of the transactions on the bank statement in AX by clicking the Cleared checkbox on each transaction line.

As you mark the transactions as ‘cleared’, the bottom portion of the form shows the sum of the transactions selected grouped by Bank transaction group.

The Unreconciled field also adjusts automatically as you mark transactions as cleared and shows the remaining amount to be reconciled.

If you wish to select the Cleared checkbox for all of the lines within an interval of check numbers on the bank statement, click the Mark check interval button. Select the first check number and last check number in the sequence. All of the lines associated with this check sequence will then be selected as ‘Cleared’.




Dynamics GP Journal Entry pasted from Excel with free Add-in

Ever find it a little to tedious when inputing jounral entries in Dynamics GP? Well, developers listened and created a free add-in to simplify the task. By downloading the tool, you will be able to save time and increase your efficiency.

Check out how this works


To get started, simply download the tool from the link below and place the DLLs in your AddIns folder.

Then, create an excel view like the following:

Dynamics GP Journal Entry

Highlight and copy the data in this excel table

Navigate back to the Transaction Entry window of Dynamics GP and select additional>>Paste from Excel (or CTRL + F for shortcut)

Next, spend the extra time you saved checking out the rest of the GP tips on Tridea Partners’ blog!

Convergence 2013

The first day back in the office after an exciting week in New Orleans for Microsoft’s Convergence 2013, was a long one. Tridea’s Sales and Marketing team took the 1,800 mile trip from Solana Beach to the Big Easy to participate in Microsoft’s largest Convergence conference yet. The experience was filled with client meetings, Microsoft Dynamics product sessions, a large expo hall, and lots of networking. New Orleans did a great job hosting the 11,500 attendees; even lending Convergence its Audubon Aquarium for the closing ceremony. From the New Orleans renowned seafood gumbo to closing keynote speaker Kofi Annan, Convergence proved to be nothing less than spectacular.

Convergence 2013
Andy Collins, Emily Norausky, Brent Garduno

Posting to a Closed Year in Microsoft Dynamics GP

Recently, we received the question of whether a user could enter a journal entry for an adjustment to a closed year in Dynamics GP.  The answer is that, this is possible depending on how far back you need to post. The rule follows that you cannot post to more than one closed year.  So if I have closed 2012, I can only post back to 2011 and no further.  As such, when closing the current year, it is a good idea to verify that all closing entries and adjustments to the previous year have been made.

Let’s say you are ready to close 2012 but need to post a JE adjustment for 2011.  To do this, you will need to reopen the fiscal period in which you will be posting by navigating to the Fiscal Periods Setup window.  Go to Microsoft Dynamics GP > Setup > Company > Fiscal Periods.

Select the year that needs to be reopened.  Then, deselect the appropriate checkbox corresponding to the period and module you need to reopen. In my case, I have deselected the Financial module for December of 2011 because I need to make a journal entry adjustment to December 2011

General Ledger post to a prior fiscal year in Dynamics GP

Next, you will need to verify that you are allowed to post to history.  Verify that the Allow Posting to History option in the General Ledger Setup window is selected. Go to Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger.

General Ledger

Now, you are ready to create and post your transaction entry for the closed year.  Once you are finished, go back to the General Ledger setup and unmark the Allow Posting to History option (you may leave it marked if that is the default setup), and close the same fiscal period that was opened earlier, using the Fiscal Periods Setup window.

Navigation Paths:
General Ledger Setup – Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger
Fiscal Periods Setup – Microsoft Dynamics GP > Setup > Company > Fiscal Periods

If you do need to post to more than one closed year, Microsoft does offer a service to achieve this.  For more information, please contact