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:14] – 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. | + | |
| - | -**Also 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 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. | ||
| Line 36: | Line 29: | ||
| -**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 64: | 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, | ||