Ability Financials™ – Import and Edit Functionality

Import vendor information from your current order management system into Microsoft Dynamics GP™ (formerly Great Plains) software.

Benefit: Saves time and eliminates data entry errors by taking your current vendor information and creating vendor cards in Microsoft Dynamics GP.

Import General Ledger transactions from your order management system.

Benefit: Imports quickly into Microsoft Dynamics GP and reconciles the import to your order management system with the Transaction Code Analysis report. The import also will add general ledger accounts that did not already exist in Microsoft Dynamics GP and let the user know the account was added and that it now needs to be properly maintained. Validates that debits equal credits too.

Import Accounts Payable transactions from your order management system.

Benefit: Imports quickly into Microsoft Dynamics GP. The import also adds vendor cards for vendors that did not already exist in the software and lets the user know that the vendor was added and now needs to be properly maintained. Validates that the vendor must be in an active status. Validates that debits equal credits too.

Import and view additional General Ledger detail records from your order management system to provide capability for additional analysis. These records are unique to Ability Financials and include fields such as reason codes, offers, payment methods, and customer types.

Benefit: Importing Offer/Use information enables you to analyze on a source code level the financial results of posted financials...not just demand. Importing reason codes allows you to verify that general ledger accounts tie directly to the reason code for which they are intended. The additional fields of data may be imported into the SmartList tables, in which data queries can be created and stored for future analysis.

Add or edit the Ability Financials additional General Ledger detail records in transactions native to Microsoft Dynamics GP as needed.

Benefit: You can correct erroneous imported transactions by voiding them and then adding a new transaction directly in Microsoft Dynamics GP, but still get the additional GL detail records as desired. (Rather than voiding the whole import, correct the problem in your order management system and rerun the import).

Import and view purchase order detail information for Accounts Payable invoices. Detail information includes fields such as item, vendor and purchase order numbers.

Benefit: Query or analyze purchase order detail information posted from your Accounts Payable imports without having to go back to your order management system. Save using a precious license seat allowing for better interdepartmental information sharing since any manager, etc. can be given selective access to Microsoft Dynamics GP to view it. Since Microsoft Dynamics GP is Windows-based, it's easier to learn than most order management systems, cutting down on the learning curve by eliminating the need to learn how to pull data out of your order management system.

Import Accounts Receivable refund check information from your order management system into the Microsoft Dynamics GP Bank Reconciliation module for editing and posting.

Benefit: Seamlessly update the bank reconciliation module whereby the cash account your checks were written against may be reconciled and audited. Eliminate the need to manually key checks written out of your order management system into your Bank Reconciliation module.