Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
cats:analytics:glandinventory [2019/04/17 16:13] – [Current Balance Issues] amanda | cats: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/ | ||
+ | * 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**, | ||
-**Compare the totals for each report to one another.** | -**Compare the totals for each report to one another.** | ||
* Once you find a discrepancy, | * Once you find a discrepancy, | ||
- | * 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 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/ | ||
+ | * 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, |