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:16] – [Opening 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 current | + | -**From the isolated |
| * In the filter for **G/L Accts Bal/Act**, select **Current/ | * 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. | * 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 | + | -**From the current |
| * Under the **Invoice Type** filter choose either Purchases or Sales. | * Under the **Invoice Type** filter choose either Purchases or Sales. | ||
| * Under **Balance** filter select **Opening Bal**. | * Under **Balance** filter select **Opening Bal**. | ||
| Line 58: | 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, | ||