Bills Receivable/Payable are not fully adjusted.. Continue with Report Creation

YouTube: Error in Dues/Ageing report

Error in Dues/Ageing report

In this tutorial, we’ll cover how to resolve a common error that may occur while generating the Dues and Aging Report in Logic ERP. This error typically appears when there are pending or unadjusted entries associated with bills receivable or payable.

---

Root Cause of the Error

• Error Message: “Bills Receivable/Payable are not fully adjusted. Continue with Report Creation?”

• Cause: Occurs when payment or receipt entries are not fully adjusted against a bill.

• This results in a mismatch between the Dues and Aging Report and the Ledger balance.

---

When and Where the Error Appears

• Navigate to Reports and Queries from the Main Menu.

• Expand Financial Reports.

• Click on Dues and Aging Analysis.

• Select Configuration and Account:

  • Choose the desired Outstanding Report Configuration.

  • Search and select the required account from the list.

  • Click Create Report.

• Error Message Appears:

  • The system displays an error indicating unadjusted bills.

• You can either:

  • Click No to cancel report generation.

  • Click Yes to proceed, but the report will show inaccurate due amounts.

• Review Running Balance:

  • Identify unadjusted entries (e.g., a ₹5,000 payment not matched with a bill).

  • Note that the Ledger running balance (₹2,500) does not match the Dues and Aging Report.

    • Note: To open the ledger Report "Navigate to Reports/Queries\Financial Reports and click on Ledger".

---

Fixing the Issue via Adjustment Utility

• Navigate to Adjustments:

  • Go to Account Vouchers from the Main Menu.

  • Click on Adjust Bill Receivable/Payable.

• Adjust the Bill:

  • Search and select the relevant account.

  • The system displays:

    • The bill with pending amount.

    • Associated payment/receipt entries.

• Perform Adjustment:

  • Select the bill row to adjust.

  • Choose the unadjusted entry.

  • Click on Adjust Entry.

• Post-Adjustment Check:

  • Pending amount is now reduced (e.g., from ₹5,000 to ₹2,500).

  • Ledger balance and Dues & Aging Report are now in sync.

---

Verify the Report After Adjustment

1. Go back to the Dues and Aging Report.

2. Re-select the same account and configuration.

3. Click Create Report again.

4. The report will now:

   • Generate successfully, without error.

   • Reflect the correct due amount.

---

Still Facing Issues?

• If the error persists even after adjustments:

  • Submit a support ticket.

  • Our team will reach out to assist you at the earliest.