Automated solutions that are available for the Financials series in Microsoft Dynamics GP


INTRODUCTION


This article describes the automated solutions that may be available for the Financials series in Microsoft Dynamics GP. All automated solutions are not available for all product versions. You can use automated solutions to simplify certain tasks that typically require the following things:
  • Knowledge of SQL
  • Access to SQL query tools
  • Access to Support Administrator Console

More Information


To obtain automated solutions for the Financials series in Microsoft Dynamics GP, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

PartnersCustomers

Automated solutions for the Financials series

The following automated solutions are available for the Financials series in Microsoft Dynamics GP.
ModuleAutomated solution nameDescription
Bank ReconciliationBank Reconciliation Reconcile ErrorThis automated solution checks the Cash Management Transactions table for entries that have more than two decimal places. Then, it reports the entries to the user.
Bank Reconciliation"Deposit is Being Edited by Another User" errorThis automated solution clears activity records that are not valid. These records may cause the following error message to occur: "Deposit is Being Edited by Another User."
General LedgerClear AF/GL 50000 tablesThis automated solution clears all the tables that begin with AF or that begin with GL. Additionally, this automated solution clears all the tables that are numbered from 50,000 to 59,999. This automated solution clears the tables for a specific database. These tables are repopulated as needed.
General LedgerCopy AFA setup informationThis automated solution copies the Advanced Financial Analysis reports from one company to another company.
General LedgerFind Missing Retained Earning AccountsThis automated solution reports the missing retained earnings accounts. These reports occur when the company is set up to close the financial year to divisional accounts.
General LedgerRebuild Account IndexThis automated solution recreates the GL00105 table (Account Index table) by using the appropriate accounts from the Account Master table. This automated solution does not have to perform the Check Links procedure on the Account Master table.
General LedgerGeneral Ledger Out of Balance This automated solution lets a user search for unbalanced journal entries in opened years and in closed years. The GL20000 table is the "opened years" table. The GL30000 table is the "closed years" table. This automated solution searches for journal entries that are in the originating currency. Unbalanced journal entries are reported to the user in an organized text format.
General LedgerMulticurrency Debit/Credit Not MatchingThis automated solution checks for instances in which the functional currency debits and the functional currency credits are unbalanced. This automated solution checks for these instances in the GL20000 table and in the GL30000 table.
General LedgerTrial Balance Out of BalanceThis automated solution checks the GL20000 table and the GL10001 table for instances in which there are more than two decimal places in a value. This automated solution searches the GL20000 table for instances in which the debit amount and the credit amount are unbalanced.
General LedgerYear End Close ChecklistThis automated solution performs basic checks on the accounting data to help you prepare to close the fiscal year.
Human ResourcesCopy Human Resources SetupThis automated solution copies the Human Resource Setup information from one company to another company.
Fixed AssetsClear FA40203This automated solution clears the Fixed Assets Depreciation Book Setup table (FA40203) in a company database. Then, you can reimport the asset depreciation information.
Fixed AssetsClear FA41900This automated solution clears the FA41900 table in a company database. This automated solution prevents errors in projections. It also prevents time-out problems.
Fixed Assets"Error 17" Fixed Asset Index errorThis automated solution clears the FAINDEX table. It also removes inactive sessions from the DEX_LOCK table and from the DEX_SSESSION table. These steps resolve the following error message: "Error 17." This error message occurs if you try to enter an index that is already being used.
Fixed AssetsCopy Fixed Assets SetupThis automated solution copies the Fixed Asset Setup information from one company to another company. After the information is copied, you must set up the corporate book, the corporate year, and the corporate quarters. These items must be set up in Fixed Assets.
Payables ManagementPayables Management DuplicatesThis automated solution checks for duplicate records in the Payables Management tables. Then, the automated solution reports duplicate records.
PayrollClear Payroll ActivityThis automated solution clears records that are not valid. These records are cleared from the Payroll Activity tables and from the Direct Deposit activity tables.
Receivables ManagementReceivables Management DuplicatesThis automated solution checks for duplicate records in the Receivables Management tables. Then, the automated solution reports the duplicate records.
Receivables Management"Cannot Complete Reconcile Process" errorThis automated solution resolves the following error message: "Cannot Complete Reconcile Process while Transactions are being edited by another user."