Invoice Collection Status

Invoice Collection Status

Invoice Collection Status Module - User Guide

1. Introduction πŸ“

The Invoice Collection Status module (/invoicecollectionstatusindex) is a sales and accounts receivable utility that allows teams to monitor, update, and manage the collection lifecycle of sales invoices. Rather than navigating through multi-step screens, users can quickly update payment statuses directly within the grid or batch-update hundreds of invoices using Excel.

ℹ️

In the overall business flow:

  1. It tracks outstanding receivables and payment collection promises directly against sales invoices.
  2. It facilitates rapid in-grid updates via interactive modal dialogs without full-page reloads.
  3. It supports bulk spreadsheet updates via structured Excel template import.
  4. It connects to the Collection Status Master to define standardized status codes.

Typically, this module is managed by Credit Controllers, Accounts Receivable Executives, and Sales Coordinators.


2. Getting Started with Invoice Collection Status πŸš€

Accessing the Module

Navigate to Sales > Transactions > Collection Status (/invoicecollectionstatusindex).

Collection Status Index

The Module Overview

The index screen displays all sales invoices along with their current collection tracking state:

  • Invoice No & Date: Sales invoice identification.
  • Party Name: Customer short name.
  • Status: Current collection milestone (e.g., Promised, Dispute, Cheque Received).
  • Modify: Quick-edit action button.
  • Delete: Removes the collection status tracking entry from the invoice.

3. Features ✨

  • ⚑ In-Grid Modal Quick-Edit: Update an invoice’s collection status in seconds using a modal dropdown dialog without leaving the page.
  • πŸ“ Bulk Excel Import: Export, review, and import collection statuses across hundreds of invoices at once.
  • πŸ“₯ Built-in Model Template: One-click download of the exact Excel import model (ImportInvoiceCollectionStatus_Model.xlsx).
  • 🏷️ Direct Master Access: Quick navigation button to Collection Status Master (collectionstatusmstindex) to configure or adjust collection categories.
  • πŸ›‘οΈ Referential Integrity: Status master records in use across invoices are protected against accidental deletion.

4. Complete Flow πŸ”„

Review Invoice Collections

  • Open /invoicecollectionstatusindex.
  • Filter or search by Party Name, Invoice No, or current Status using the built-in column filters.

Quick Status Update (Single Invoice)

  • In the grid, click the Edit (Pencil) icon in the Modify column for the target invoice.
  • A modal dialog (Modify Invoice Collection Status) will open with a dropdown list of all active collection statuses.
  • Select the updated status and click Modify.
  • The grid immediately updates with the new status without a page reload.

Remove Collection Status

  • Click the Delete (Trash) icon in the Delete column.
  • Confirm the prompt in the dialog (“Do you really want to delete this record permanently?”).
  • The collection tracking entry is cleared from that invoice.

Bulk Import via Excel

  • Click “Import” on the index page to navigate to /invoicecollectionstatusimport.

  • If you do not have the template, click “Download Model” to save ImportInvoiceCollectionStatus_Model.xlsx.

  • Fill out the required invoice numbers and corresponding collection status codes.

  • ⚠️
    Strict Excel File Naming:

The uploaded Excel file name MUST be exactly ImportInvoiceCollectionStatus.xlsx (case-insensitive extension .xlsx). If named otherwise, the upload is rejected with: β€œUploaded XL File Name must be ImportInvoiceCollectionStatus(with extension .xlsx)”.


5. Master Setup: Collection Status Master 🏷️

Accessed via the “Collection Status” button on the transaction index page (/collectionstatusmstindex).


6. Validations and Error Handling ⚠️

Validation TypeWhat is checked?Error Message / Action
Excel Upload NameFile name must be ImportInvoiceCollectionStatus.xlsx.“Uploaded XL File Name must be ImportInvoiceCollectionStatus(with extension .xlsx)”
Excel Model FormatTemplate header structure matches expected schema.“Please upload correct model.”
Excel Empty CheckSpreadsheet contains at least one data row.“Uploaded XL File does not contain any data.”
Status Master LimitMaximum allowed master statuses.“This table can hold a maximum of 99 records only… unable to save.”
Status Master LengthStatus Name character count.“Status Name can be upto 50 characters only.”
Master Referential CheckStatus is currently linked to one or more invoices.“Master Record is live. You may not delete it.”

7. Best Practices / Tips πŸ’‘

ℹ️
  • Use Download Model: Always download ImportInvoiceCollectionStatus_Model.xlsx from the import screen before bulk uploads to prevent column misalignment.
  • Quick Updates: For day-to-day call follow-ups, use the in-grid edit dialog rather than re-importing Excel sheets.
  • Master Deletion Hygiene: Before attempting to delete obsolete statuses in the Collection Status Master, reassign any live invoices to an active status.
Export InvoiceMarketing Activity