Tridea Partners’ Microsoft Dynamics GP 2013 SD Launch Event

Corporate CFO’s, Controllers, Accounting Managers and IT professionals alike gathered in the mezzanine of Stone Brewing Co. last night to view demonstrations highlighting the new features of Microsoft Dynamics GP 2013. This was the third year that Tridea Partners has hosted a product launch event, and 7th customer event hosted at the local brewery, and Tridea client.

The night kicked off with hors d’oeuvres and drinks, and a networking session where industry professionals were able to socialize with peers from all industries.

Craig Crescas gave a Dynamic presentation on GP 2013, and had his audience on their feet about the new product launch. The night was an overall success, leaving attendees excited about GP 2013’s innovative new Web Client, and features like document attach, dashboards, enhanced integration to Excel and hundreds of new functionality features – to name a few.

For a more extensive Dynamics GP 2013 overview, click here.

If you were unable to attend the event and would like to request a demonstration or consultation on Dynamics GP 2013, please contact


Expedite the Procurement Process in Dynamics AX 2012

Microsoft Dynamics AX 2012 offers multiple ways to simplify and expedite the procurement process. One of the many helpful features included in the procurement and sourcing module is the ability for purchase orders to be created automatically upon purchase requisition approval.

Two options are offered in the creation of a purchase order from a purchase requisition: manual or automatic. For a purchase order to be created manually, the purchase requisition must first move through the purchase requisition workflow approval process. This process varies from business to business. Once the purchase requisition has been approved, the purchasing agent navigates to the ‘Release approved purchase requisitions’ form, chooses the approved purchase requisition, and selects the ‘New Purchase Order’ button. This process can be time-consuming if your business handles numerous purchase requests.

Automatic creation of purchase orders is set up by navigating to the Procurement and Sourcing Purchasing Policies form.

Expedite the Procurement Process in Dynamics AX 2012
Procurement and Sourcing Purchasing Policies form

Use navigation path: Procurement and Sourcing>Setup>Policies>Purchasing policies

-Edit the current purchasing policy or create a new purchasing policy

-Under Policy rule type, choose Purchase order creation and demand consolidation

Procurement Process

-Select an existing policy rule (by double-clicking on the policy rule line) or create a new policy rule (by clicking on the ‘Create policy rule’ button)

This opens the Purchase order creation and demand consolidation rule form:

Automatic PO from Purchase Requistion Approval in AX 2012


-Choose Manual purchase order creation

-Click the ‘Automatically create purchase orders’ radio button to select it


Spell Checker for Dynamics CRM 2011

One of the biggest complaints from clients has been that Dynamics CRM does not have a built in spell checker like other Microsoft applications. However, with the release of an Internet Explorer add-on called Speckie, you can now spell check fields and web emails in Dynamics CRM.   The add-on is free for personal use, but has a small fee for commercial use; please review the licensing agreement at

Once you have downloaded and installed Speckie.

  1. Open Internet Explorer
  2. Click on Tools
  3. Select Speckie Settings
  4. Check the box: “Enable spell check in single line edit fields”
  5. Click  “Apply” at the bottom of the page

Dynamics CRM 2011

Now you are ready to use Speckie with Dynamics CRM in an IE web browser.  Fields on forms and web emails will have the distinct red wavy line (this option can be changed in Speckie Settings) if Speckie believes a word is misspelled.  This can be a bit of a nuisance for names and places but can be a life saver for email correspondence or in notes/description sections.

Spell Checker for Dynamics CRM 2011




Balance Sheet Reporting Without Closing YTD in Dynamics GP

It’s almost that time again. Soon it will be time to complete another year-end close in GP. Since GP will only allow adjusting entries to the SINGLE LAST closed year in GP, it can sometimes be a scary process for users. Due to ongoing audits or other various factors, it may be inevitable that adjustments will be needed for more than just one historical year. Without closing a year, the amounts for balance sheet accounts will not roll over as beginning balances for the next year. For those instances, here is a little trick that will allow for accurate balance sheet reporting, without having to complete the official year-end process in GP.

Below is an example of a Management Reporter column definition. In this example, column B is mapped to pull YTD data from the last month of the last fiscal year. Column C is mapped to pull YTD information for the current fiscal year. Both columns B and C are configured as “non-printing” columns. Finally, column D is a calculation that adds columns B and C. Voila! Accurate balances without closing the year in GP.


balance sheet reporting

Multicurrency Reporting in Microsoft Dynamics AX 2012

Reporting in multicurrency in Microsoft Dynamics AX 2012 is achieved through the use of currency translation within the consolidations function.  For example, a subsidiary operating in functional and reporting currency of EUR for local statutory requirements, but required to report in USD for its parent company in the US.

First a consolidation legal entity must be created with functional and reporting currency of USD:

a)      Navigate to Organization administration>Setup>Legal Entity: check “Use for financial consolidation process”

b)      Navigate to General Ledger>Setup>Ledger to configure the Ledger for the consolidation company;

  •  Assign the same COA and calendar as that of the subsidiary, assign USD for functional and reporting currencies.

c)      Navigate to General Ledger>Setup>Posting>Accounts for automatic transactions

  •  Define the main account for the transaction types “Profit and loss account for consolidations differences and “Balance account for consolidation differences.” These are the accounts where the exchange rate adjustment will be posted.

Exchange rate types for average, period end, and historical rates must be defined between USD and EUR:

d)      Navigate to General Ledger >Setup>Currency>Exchange rate types

  • Create rate types of average, period end and historical. Enter the related exchange rates for each type by selecting the “Exchange rate” button. These exchange rate types are assigned to a range of main accounts in consolidation for balance sheet, income statement and equity in order to achieve currency conversion results in accordance with GAAP.

With the consolidation company created, the consolidation and currency translation process must be configured.

e)      Navigate to General Ledger>Periodic>Consolidate>Consolidate [Online]

    1. Criteria Tab> select  the account range for all main accounts to be translated and consolidated, the period , check      include actuals and include budgets if budgets exist.Multicurrency Reporting
    2. Financials Dimension Tab> select the financial dimensions to be consolidated
    3. Legal Entities Tab> Select the subsidiary EUR and which account, Balance or P&L, for the exchange rate adjustment. This correlates to the setup from step c) aboveconsolidate-balance
    4. Description tab> this description will be the default text  for the voucher created in the consolidation
    5. Elimination tab is utilized for the processing of eliminating transactions which is not a requirement for currency translation in consolidation and can be left blank
    6. Currency translation tab> define which currency exchange rates will be utilizes with various main accounts.
          1. Enter the subsidiary name (source legal entity name), the functional currency (source accounting currency) the main account range (from account /to account) and the associated exchange rate type to be applied to the local currency during the consolidation process (Exchange rate type).
          2. For each account range in 1 above, select the Exchange rate date which indicates if the exchange rate should be based on the transaction date or the date of the consolidation.
          3. A specific rate can also be used by entering the specific exchange rate in the Exchange rate field. This will override all other rate selections.

Consolidate EUR

Run consolidation by selecting “Ok”.

To view the consolidation results navigate to General Ledger>Inquiries>Consolidations. Select “Transactions” to view the voucher entries created by the consolidation. Results can also be reviewed through the numerous general ledger standard reports such as the trial balance and ledger transaction list.