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 15: | Line 15: | ||
* 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, |