Cause
Use of prepaid transactions: e.g., payment on an invoice is in the current FY, but the invoice date is in the next FY.
Overpayment transaction issues: If there is an overpayment transaction but there is no invoice attached to the overpayment transaction for that same customer. This scenario may occur if the customer name on an overpayment transaction is changed after it has been created under the original customer. Similar to point 1, if the overpayment transaction is not in the same period as the invoice, it can also cause a discrepancy. As in our system debtors are queried based on invoices first.
Note: If any of the above scenarios apply, this is the software working as intended to flag these debtor/creditor discrepancies, allowing the end user to address them in their source file.
Resolution
Open your binder and navigate to Settings > Binder Details. Verify that the dates on the binder align with the desired dates for creditor/debtor reports in your source file.
Next, in Settings > Edit Columns, ensure that the primary column dates also align with the creditor/debtor reports in your source file.
Refresh your trial balance in Active by clicking Reimport All Columns on the trial balance screen.
Then, open the debtor/creditor workpaper, press the three dots next to the debtor/creditor workpaper in the side panel, scroll down, and click Execute under the command section.
If the issue persists, please let us know, and we can give you a call to troubleshoot further.