Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
| 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." |
Keywords: kbnosurvey, kbnoloc, kbexpertiseinter, kbexpertisebeginner, kbinfo, kbmbspartner, atdownload, kbmbsmigrate, kb