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.

Partners

https://mbs.microsoft.com/partnersource/support/selfsupport/automatedsolutions/automatedsolutions.htm

Customers

https://mbs.microsoft.com/customersource/support/selfsupport/automatedsolutions

Automated solutions for the Financials series

The following automated solutions are available for the Financials series in Microsoft Dynamics GP.

Module

Automated solution name

Description

Bank Reconciliation

Bank Reconciliation Reconcile Error

This 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" error

This 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 Ledger

Clear AF/GL 50000 tables

This 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 Ledger

Copy AFA setup information

This automated solution copies the Advanced Financial Analysis reports from one company to another company.

General Ledger

Find Missing Retained Earning Accounts

This 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 Ledger

Rebuild Account Index

This 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 Ledger

General 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 Ledger

Multicurrency Debit/Credit Not Matching

This 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 Ledger

Trial Balance Out of Balance

This 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 Ledger

Year End Close Checklist

This automated solution performs basic checks on the accounting data to help you prepare to close the fiscal year.

Human Resources

Copy Human Resources Setup

This automated solution copies the Human Resource Setup information from one company to another company.

Fixed Assets

Clear FA40203

This automated solution clears the Fixed Assets Depreciation Book Setup table (FA40203) in a company database. Then, you can reimport the asset depreciation information.

Fixed Assets

Clear FA41900

This 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 error

This 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 Assets

Copy Fixed Assets Setup

This 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 Management

Payables Management Duplicates

This automated solution checks for duplicate records in the Payables Management tables. Then, the automated solution reports duplicate records.

Payroll

Clear Payroll Activity

This 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 Management

Receivables Management Duplicates

This 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" error

This automated solution resolves the following error message: "Cannot Complete Reconcile Process while Transactions are being edited by another user."

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×