--- title: "Manage Imbalance on Debtors Control Notification" canonical: "https://kb.myframeworks.com.au/space/FRAM/28397728/Manage%20Imbalance%20on%20Debtors%20Control%20Notification" format: markdown --- # Overview To ensure financial accuracy, our **Debtors Control Account Notifications **provide a daily summary of key account movements from the previous day’s trade. By tracking discrepancies or imbalances in the Debtors control accounts, this notification helps identify potential issues early, ensuring smooth financial operations and better decision-making. > 📝 This article is intended to help investigate the reason behind an imbalance in the Debtors Control Account Notification task. # Prerequisite #### Debtors Control Audit To ensure there is debtor control data available to be reported on, you must run the **Debtors Control Audit** schedule task at the end of each day’s trade. This task totals up the Debtors subledger for a company and compares it to the GL balance for your Trade Debtors. To track any variances between these accounts, it's recommended to schedule this task to run daily at around 8 pm and set it to email the report to your accounts team. Your accounts team will be notified, via email, if the Debtor Control Audit from the day trade was Balanced or Imbalanced. #### Debtors Control Account Notifications In addition to scheduling the Debtors Control Audit task, we also recommend scheduling the **Debtors Control Account Notifications** report to run daily at 6 am and set the schedule to email the report to your accounts team. By default, the report is set to report on the last 60 days of Debtors Control Audits. > ⚠️ **Important:** The Debtors Control Account Notifications report can only display data starting from the date when the Debtors Control Audit scheduled task was first activated. > Macro (excerpt) > > # Steps to Manage Imbalance on Debtors Control Notification > > To manage the imbalance in Debtors Control Notification, open Frameworks and follow the steps below: > > > 📝 ## Quick Steps > > 📝 > > 📝 Here are quick instructions to help you manage imbalances on the Debtors Control Notification: > > 📝 > > 📝 1. **[Check the Debtors Control Audit Notification](#step1)** > > 📝 - Navigate to **System Administration > Task Scheduler > Task Scheduler Queue**.** ** > > 📝 - Find the **DebtorControlSched **task to view the notification. > > 📝 2. **[Run the Debtor Control Notifications report](#step2)** > > 📝 - Open the **Report Category List **and select **Debtors Control Account Notification** to identify the day the Debtors Control Account went out of balance. > > 📝 - If the **A/R Close Balance** matches the **Debtors Account Values**, no further action is required. If they don’t match, proceed with the next steps. > > 📝 3. **[Review Journals in the GL Dashboard](#step3)** > > 📝 - Open the **GL Dashboard** and search for the Trade Debtor Account. > > 📝 - Filter the account by the day or month the imbalance began. > > 📝 - Ensure no journals are posted to Control Accounts. > > 📝 - If journals are posted, investigate, reverse them, and resolve the issue. > > 📝 4. **[Run Additional Reports](#step4)** > > 📝 - If there are no GL Journals for that date/month, run the following reports: > > 📝 - **Till Reconciliation Summary**: Match this to the POS postings. > > 📝 - **Sales by Date**: Compare with transactions in the POS postings. > > 📝 - **Customer Payments by Date**: Verify against the Account Payment postings. > > 📝 5. **[Check Order Release Postings](#step5)** > > 📝 - If you still can’t find the imbalance, review the Order Release postings for discrepancies. > > 📝 6. **[Contact Support](#step6)** > > 📝 - If the imbalance cannot be found, contact the [Support Team](https://kb.myframeworks.com.au/page/support). ## Detailed Steps Here are detailed instructions to help you navigate the Debtors Control Notification: ### > Macro (anchor) 1. Check the Debtors Control Audit Notification If you missed the notification email or you just want to review the Debtors Control Audit Notification from the end of a particular day, there are two ways to check the Debtors Control Notification output from the **Task Scheduler Queue** screen. 1. Click the **Frameworks Menu** and enter **Task Scheduler Queue** in the **Search Box.** 2. Click the **Frameworks Menu **and navigate to **System Administration > Task Scheduler > Task Scheduler Queue** from the navigation tree. To view this report, perform the following steps: > ⚠️ **Note**: The Debtors Control Audit task needs to be run to see this report. 1. In the **Search **fields at the top, enter **Debtor **in the **Name** field and leave the **Created By** and **Scheduled** fields blank. 2. Click **Find** to filter and display the results. 3. From the Results Grid, click the **DebtorControlSched** link. 4. Go to the **Output** tab, then click on the hyperlink to download the report. 5. Open the **Generaterd Reprt**. 6. Check if the **A/R Close Balance** and **Debtors Account Values** match. > ℹ️ If the **A/R Close Balance** and **Debtors Account Values** match, there is no issue, and no further action is required. If there is a mismatch, proceed to the [next steps](#step2). --- ### > Macro (anchor) 2. Run the Debtor Control Notifications report The **Debtors Control Account Notifications** report extracts the details from the Debtors Control Audit Notification task, typically for the last 60 days. This allows for variances to be tracked to the particular day they started. To rerun this report, perform the following: 1. From the **Dashboard Icons** on the **Home **screen, select the **Report Category List** icon. 2. In the **Search **bar at the top of the grid, enter **Debtors Control** in the **Name** or **Description** column 3. In the **Report Name **column, click the **Debtors Control Account Notifications** hyperlink. 4. In the **Report Criteria** tab, enter the required parameters for the report you have chosen to run. 5. Click **Submit **to run the report as a once only report. 6. After running the report, the **Output **tab displays the results of the completed task and a link to download the selected report output under the **Generated Reports** section. 7. Open the report and determine when the control account became imbalanced. --- ### > Macro (anchor) 3. Review Journals in the GL Dashboard To further investigate the imbalance, check if there is an existing Journal. 1. From the **Dashboard Icons** at the top of the screen, click the **GL Dashboard **icon. 2. In the **Search** fields, search for your **Trade Debtor account**. > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397388](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397388) for more information on how to refine your search. > ℹ️ If it’s been renamed, go to **Company Maintenance** and copy the account number from the **Debtors Control** field. 3. Filter the account by the day or month the imbalance started and check for any Journal postings. > ⚠️ GL Journals should not be posted to Control Accounts. **If there are any Journals:** - Determine the reason they were posted to the Control account. - Reverse the Journal and fix the issue. **If there are no Journals, proceed to the ****[next step](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28397728#step4)**. --- ### > Macro (anchor) 4. Run Additional Reports To run a report from Report Category List Dashboard, perform the following: 1. Click the **Report Category List** **Dashboard** icon from the top middle section of the Frameworks screen. 2. Run the **Till Reconciliation Summary report**. 3. Compare the output values to the POS postings to verify if they match. - If the values don’t match, run the **Sales by Date** by Customer. - Compare the transactions output to the transactions in the POS posting and verify if they match. 4. **Check the Customer Payments by Date**. - Compare the output payments to the account payment postings to verify if they match. > ✅ Refer to [https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380010](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28380010) for more information about Report Category List Dashboard. --- ### > Macro (anchor) 5. Check Order Release Postings If there is still no sign of the imbalance, go through the **Order Release **postings and check if they match to the transaction.  --- ### > Macro (anchor) 6. Contact the Support Team Log a [support request](https://kb.myframeworks.com.au/page/support) to ask for assistance if the imbalance still cannot be found.