cats:analytics:glandinventory

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
cats:analytics:glandinventory [2019/04/17 16:09] – [Current Balance Issues] amandacats:analytics:glandinventory [2019/04/18 14:04] (current) – [Causes of Discrepancies] amanda
Line 12: Line 12:
 Follow these steps to attempt to find the cause. Follow these steps to attempt to find the cause.
 ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Opening balances in the Current area=== ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Opening balances in the Current area===
 +  -**From the isolated area, print a Trial Balance.**
 +      * In the filter for **G/L Accts Bal/Act**, select **Current/Opn Bal**.
 +      * Choose columns for **Opening Balance**, **Period 11 Balance**, **Period 12 amount**, and **Period 12 balance** (or **Current Balance**) - or whichever period is the one you need to balance.
   -**From the current area, print a summary report of open invoices.**    -**From the current area, print a summary report of open invoices.** 
     * Under the **Invoice Type** filter choose either Purchases or Sales.      * Under the **Invoice Type** filter choose either Purchases or Sales. 
Line 18: Line 21:
     * On **Screen 5**, choose **Summary**.     * On **Screen 5**, choose **Summary**.
     * On the **Select Order** screen, order and subtotal by **Account**.     * On the **Select Order** screen, order and subtotal by **Account**.
-    * Print the report and note the bottom total.  +    * Print the report and note the bottom total.   
-  -**From the fiscal year-end isolated area, print a summary report of open invoices.**  +
-      * Under the **Invoice Type** filter choose either Purchases or Sales.  +
-      * Under **Balance** filter select **Balance All**.  +
-      * Select one G/L account, for either the GL_AP or GL_AR system account. +
-      * On **Screen 5**, choose **Summary**. +
-      * On the **Select Order** screen, order and subtotal by **Account**. +
-      * Print the report and note the bottom total.+
   -**From the isolated area, print a G/L Statement.**   -**From the isolated area, print a G/L Statement.**
     * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP.     * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP.
     * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).     * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).
 +    * On **Screen 5**, choose **Summary**.
 +    * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.
   -**Compare the totals for each report to one another.**      -**Compare the totals for each report to one another.**   
     * Once you find a discrepancy, narrow down the issue to one account (if possible).     * Once you find a discrepancy, narrow down the issue to one account (if possible).
-    * Print the invoices just for that counterparty account code using the **Account Range** on the reports. +    * Print the detailed list of invoices just for that counterparty account code using the **Account Range** on the reports.  
 +    * Do the same with the G/L statement. 
     * Then, you can determine which invoices have balance discrepancies.     * Then, you can determine which invoices have balance discrepancies.
 ====Current Balance Issues==== ====Current Balance Issues====
Line 37: Line 36:
 ===Search for incorrect entries in the GL_AP and GL_AR accounts.=== ===Search for incorrect entries in the GL_AP and GL_AR accounts.===
   - **Run the Accounting Recalculation with default options.**\\ ++Click here to see the default Accounting Recalculation options | {{:cats:questions:accounting:accountingrecalc_optionsscreen.png|Accounting Recalculation default options}}++   - **Run the Accounting Recalculation with default options.**\\ ++Click here to see the default Accounting Recalculation options | {{:cats:questions:accounting:accountingrecalc_optionsscreen.png|Accounting Recalculation default options}}++
-  - **Review the report and look for errors related to "Non-invoice transaction posted to GL_AR" on the printout.**\\ ++Click here to see an example of these errors. | {{:cats:analytics:matchinginventory_accountingrecalcwitherrors.png|}}+++  - **Review the report and look for errors related to "Non-invoice transaction posted to GL_AR"  or "G/L number is NOT GL_AP" on the printout.**\\ ++Click here to see an example of these errors. | {{:cats:analytics:matchinginventory_accountingrecalcwitherrors.png|}}++
   - **Fix these transactions.**    - **Fix these transactions.** 
-      * [[:cats:procedures:accounting:transactions:modifydelete#reversing_voiding_a_posted_transaction|Reverse them]] **//OR//**  +      * [[:cats:procedures:accounting:transactions:modifydelete#reversing_voiding_a_posted_transaction|Follow these steps to reverse them]] **//OR//**  
-      * [[cats:questions:accounting:readaccountrecalc#reading_and_correcting_errors_on_the_report|Correct these errors]].+      * [[cats:questions:accounting:readaccountrecalc#reading_and_correcting_errors_on_the_report|Correct these errors by entering an alternate G/L number for these transactions]].
 ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Report of Open Invoices=== ===Compare the Ending balances in the end-of-fiscal-year Isolated area to the Report of Open Invoices===
   - **From the current or an isolated area, print a summary report of open invoices.**    - **From the current or an isolated area, print a summary report of open invoices.** 
Line 49: Line 48:
       * On the **Select Order** screen, order and subtotal by **Account** then order by **Invoice Number**.       * On the **Select Order** screen, order and subtotal by **Account** then order by **Invoice Number**.
       * Print the report and note the bottom total.        * Print the report and note the bottom total. 
-  - **Also from the isolated area, print a Trial Balance.** +  - **From the isolated area, print a G/L Statement.** 
-      * In the filter for **G/L Accts Bal/Act**, select **Current/Opn Bal**. +      * In the filter for **G/L Account Range**, select the G/L account for GL_AR or GL_AP. 
-      * Choose columns for **Opening Balance**, **Period 11 Balance**, **Period 12 amount**, and **Period 12 balance** (or **Current Balance**) - or whichever period is the one you need to balance.+      * Choose columns for **Opening Balance**, **Debit**, **Credit**, and **Current Balance** (or whichever period is the one you need to balance, such as **Period 12 balance**).
       * On **Screen 5**, choose **Summary**.       * On **Screen 5**, choose **Summary**.
       * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.       * On the **Select Order** screen, order and subtotal by **Account**, then order by **Invoice Number**.
Line 59: Line 58:
       * Print the invoices just for that counterparty account code using the **Account Range** on the reports.        * Print the invoices just for that counterparty account code using the **Account Range** on the reports. 
       * Then, you can determine which invoices have balance discrepancies.       * Then, you can determine which invoices have balance discrepancies.
 +
 +====Causes of Discrepancies====
 +Here are some of the most common causes of balance discrepancies on invoices in CATS.\\ 
 +  - Incorrect postings to GL_AP and GL_AR accounts.
 +  - Changes to invoices in isolated areas that were not done in the current area.  
 +      * Invoices unposted/deleted from isolated areas that are in the current area (or vice versa).
 +      * Modifications to invoices in isolated areas that were not carried to the current area, including changing G/L number or changing amounts.
 +  - Failure to re-isolate correctly after making changes to the current area that affect the isolated area. 
 +
 +Once you have determined the cause of the discrepancy, and which invoices were affected, you can fix the inventory mismatch.
  • cats/analytics/glandinventory.1555517392.txt.gz
  • Last modified: 2019/04/17 16:09
  • by amanda