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:
- It tracks outstanding receivables and payment collection promises directly against sales invoices.
- It facilitates rapid in-grid updates via interactive modal dialogs without full-page reloads.
- It supports bulk spreadsheet updates via structured Excel template import.
- 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).

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)β.- Click “Upload”:
- If template columns are incorrect, the system reports: “Please upload correct model.”
- If empty, the system warns: “Uploaded XL File does not contain any data.”
- On successful import, the system downloads
InvoiceCollectionStatusImportXL.xlsxcontaining row-by-row status feedback, and redirects back to the index.
- Click “Upload”:
5. Master Setup: Collection Status Master π·οΈ
Accessed via the “Collection Status” button on the transaction index page (/collectionstatusmstindex).
- Create New Status: Click “Create New” (
/collectionstatusmstcreate), enter a Status Name (up to 50 characters), and save. The system auto-assigns a unique 2-digit status code. - Table Capacity: The master table supports up to 99 status records. If full, the system warns: “This table can hold a maximum of 99 records… unable to save.”
- Deletion Protection: You cannot delete a status from the master if it is assigned to any invoice. The system checks usage and blocks deletion with: “Master Record is live. You may not delete it.”
6. Validations and Error Handling β οΈ
| Validation Type | What is checked? | Error Message / Action |
|---|---|---|
| Excel Upload Name | File name must be ImportInvoiceCollectionStatus.xlsx. | “Uploaded XL File Name must be ImportInvoiceCollectionStatus(with extension .xlsx)” |
| Excel Model Format | Template header structure matches expected schema. | “Please upload correct model.” |
| Excel Empty Check | Spreadsheet contains at least one data row. | “Uploaded XL File does not contain any data.” |
| Status Master Limit | Maximum allowed master statuses. | “This table can hold a maximum of 99 records only… unable to save.” |
| Status Master Length | Status Name character count. | “Status Name can be upto 50 characters only.” |
| Master Referential Check | Status 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.xlsxfrom 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.