Opening Outstanding

Opening Outstanding Master - User Guide

1. Introduction 📝

The Opening Outstanding Master is designed for bill-by-bill financial tracking. While the Opening Balance records an aggregate account balance, Opening Outstanding records every individual unpaid sales invoice, purchase bill, and advance from previous years. This enables the ERP to track which specific bills remain unpaid and compute exact debt aging (Aging Analysis).

â„šī¸

Key Objectives of Opening Outstanding:

  1. Bill-by-Bill Settlement: Enables future payments and receipts to settle against specific legacy invoices.
  2. Aging Accuracy: Feeds credit control and overdue aging analysis using original invoice dates and payment terms.
  3. Audit Trail Continuity: Preserves open invoice references when migrating from legacy accounting systems.

This module is restricted to Accounts Receivable (AR) Leads, Accounts Payable (AP) Leads, and Finance Managers.


2. Core Structure & Classification 📋

Each opening outstanding record tracks:

  • Doc Type & Ref Doc: Identifies whether the item is a Sales Invoice (SI), Purchase Bill (PB), Advance (AD), or On-Account (OA) entry.
  • Ref No & Ref Date: The original invoice/bill number and date from your legacy system.
  • Due Date: The contractual payment due date, used to compute overdue days.
  • Party & Account Mapping: The Main Account and Sub-Account codes linking the outstanding amount to a specific Customer or Supplier.
  • Division & Unit: Allocation to the operational plant or branch office.
  • Amount & Debit/Credit (D/C): The unpaid monetary value.

3. Bulk Import Workflow (Excel) đŸ“Ĩ

Migrating hundreds or thousands of unpaid customer and supplier bills is performed via the bulk Excel upload tool:

  1. Download Model: Click Download Model to obtain the standardized 14-column spreadsheet.
  2. Strict File Naming: The file must strictly be named ImportOpgOs.xlsx. Uploading under any other name will be rejected.
  3. Data Preparation: Enter Party Codes, Branch Codes, Document Types, Bill Numbers, and Dates (in dd-MMM-yy format).
  4. Upload & Execute: Upload ImportOpgOs.xlsx to process validations and post records.

4. Import Validations & Error Codes đŸ›Ąī¸

The upload engine validates both spreadsheet structure (Z-Codes) and accounting business logic (Codes A–P). If any validation fails, the system generates an error workbook detailing the offending rows:

Structural Checks (Z-Codes)

  • Codes Z1–Z9: Enforces that all mandatory columns are populated, dates conform to valid date formats, amounts are positive numbers, and Debit/Credit flags are strictly D or C.

Business Logic Validations (Codes A–P)

  • Party Existence: Verifies that the Party and Branch exist and are active in the Party Master.
  • Date Chronology:
    • Doc Date & Ref Date: Must be on or before the starting date of the active financial year.
    • Ref Date Rule: Ref Date cannot be later than Doc Date.
    • Due Date Rule: Due Date cannot be earlier than Ref Date.
  • Party Type Constraints:
    • Customer Accounts (CL): Can only be linked to Sales Invoices (SI), Advances (AD), or On-Account (OA) records.
    • Supplier Accounts (VL): Can only be linked to Purchase Bills (PB), Advances (AD), or On-Account (OA) records.
  • Code P (Audit Trail Lockout): The import is strictly blocked if Audit Trail is active (AuditTrail == 'Y'). Once corporate audit trail compliance is enabled, opening outstanding records cannot be modified or re-imported via Excel to protect historical integrity.

5. Daily Usage & Reporting 🔄

  • Receivable / Payable Aging Reports: The data entered in this master directly fuels the 0–30, 31–60, 61–90, and 360+ Days aging buckets.
  • Voucher Settlement: When recording new receipt or payment vouchers, opening outstanding invoices are available for selection and line-item settlement.
  • Visual Match-Off: Opening invoices can be paired and matched against on-account legacy credits.

6. Guidelines and Best Practices âš ī¸

  • Reconcile with Opening Balance: Ensure that the sum of all individual unpaid bills for a customer or vendor exactly matches their Opening Balance in the Opening Balance Master. Any variance will appear as an “Unallocated Balance” in aging reports.
  • File Name: Ensure your spreadsheet is saved strictly as ImportOpgOs.xlsx.
  • Settlement Lock: Once an opening outstanding invoice is partially or fully settled in a Voucher or Journal, it becomes locked and cannot be deleted or re-imported without reversing the voucher first.