Ability Dynamic Integration™ is a software solution that facilitates the flow of data between your order management system and Microsoft Dynamics™ GP (formerly Great Plains)—getting you the information you need, where you need it.

Certified by Microsoft

Ability Dynamic Integration™ is the only Microsoft Dynamics™ GP certified integration software designed to meet the specific reporting needs of multichannel retailers. As Microsoft Certified Gold Partners, our expertise helps you make the most of your Microsoft Dynamics™ GP investment.

How Does Ability Dynamic Integration™ Improve Cash Flow?

Ability Dynamic Integration™ improves cash flow with real-time financials. Perform advanced financial analysis on your current order management data so you can plan vendor payments to take maximum advantage of vendor discounts. Instantly highlight discrepancies with out-of-the-box GL reconciliation and analysis reports.

How Does it Eliminate Errors and Expedite Data?

Ability Dynamic Integration™ eliminates errors with a host of tools for automatically updating, importing and exporting information between Microsoft Dynamics™ GP and your order management system (OMS), eliminating the need for dual entry and reducing manual data entry. Update GP General Ledger and Payables directly from your OMS.

Import Data from your OMS directly into GP

1. Import Vendor Information from your OMS directly into Microsoft Dynamics™ GP --saving time and eliminating data entry errors.
2. Import General Ledger transactions quickly from your OMS into GP and reconcile the import to your OMS with the Transaction Code Analysis report. Automatically validates that debits equal credits and automatically prompts you to add general ledger accounts that did previously exist in GP.
3. Import Accounts Payable transactions from your OMS into GP. Automatically validates that vendors are active and that voucher totals equal distribution totals. One-click add prompts you to add vendor cards for vendors that did not previously exist in GP.
4. Import Additional General Ledger Detail Records from your OMS to provide capability for additional analysis. These records are unique to Ability Dynamic Integration™ and include fields such as reason codes, offers, payment methods and customer types.
5. Import Offer/Use Information from the General Ledger(GL) in your OMS into GP Smartlist tables. This feature enables you to analyze on a source code level the financial results of posted financials.
6. Import Reason Codes from the GL in your OMS into GP, allowing you to verify that general ledger accounts tie directly to the reason code they are intended for.
7. Add or Edit Information in the Ability Dynamic Integration™ Smartlist Tables within GP. Correct erroneous transactions by voiding them and then just adding a new transaction in GP, rather than having to void the import, correct the problem and reimport. You still get all the additional GL detail records as desired.
8. Import Purchase Order Detail Information from OMS into GP for Accounts Payable Invoices-- including fields such as item, vendor and purchase order numbers. This facilitates interdepartmental communication. Any manager can be given selective access to query or analyze PO detail information posted from AP imports.
9. Import Accounts Receivable Refund Check Information from your OMS into GP’s Bank Reconciliation module for editing and posting. Seamlessly updates the bank reconciliation module, so the cash account the checks were written against may be reconciled and audited. Eliminate the need to manually key checks written out of your OMS into your Bank Reconciliation module.

Automatically Updates your OMS with Changes Made in GP

1. Maintain Vendors in GP changes update in your OMS automatically—eliminating the need for dual entry and reducing errors.
2. Maintain General Ledger accounts in GP changes update automatically in your OMS.
3. Split an Accounts Payable Transaction into multiple invoices to create separate invoices for payment schedules—whether the transaction is posted or unposted. Automatically splits invoices, amounts and designates due dates without manual entry.

Reports for Analysis & Queries

Analyze and query information imported from your OMS inside of GP with Ability Dynamic Integration™’s exclusive SmartList Tables.

Custom General Ledger Reconciliation Reports

1. GL Import Reconciliation Essential report for GL Import interface reconciliation
2. History Reconciliation Essential report for GL history import interface reconciliation

Custom General Ledger Analysis Reports

1. Transaction Code Analysis Essential report for posting reconciliation. (Trancode = action taken on a trx/order)
2. Offer Code Analysis Analyze summarized posted Offer Sales, Returns and Margins. (Offer = catalog, special, promo)
3. Source Code Analysis Analyze posted Source Code Sales, Returns, and Margins in general ledger account detail. (Source = offer + use)
4. Reason Code Analysis Allows you to verify that posted general ledger accounts/amounts tie directly to the reason code they are intended. (Reason = why product returned, adjusted)
5. Reason Code Reclassification Allows you to verify that un-posted general ledger accounts/amounts tie directly to the reason code they are intended. Make correcting journal entries prior to posting.
6. Accounts Payable Vendor Activity Review current vendor activity in detail for a real-time updated look at your outstanding position with your vendors/vendor classes.