Skip to main content

Bill and Credit Note Counter & Department-wise Separate Bill Counter Settings

This document provides an overview of the bill counter mechanisms across modules within the system. The counters help track total bills, reference numbers, credit notes, and module-specific transactions.

Configuration: Departmental Separate Serial vs. Single Counter

Bill counters can be configured either as a single global sequence or as separate sequences per department. This setting is found in the API configuration file:

"BillCounter": "1",
"_comment_for_bill_counter": "Add 1 for Single Counter & 2 for Counter based on outlet, fo separately.",

  • "BillCounter": "1" → Single counter (all departments share one continuous sequence).

  • "BillCounter": "2" → Separate counters (each department maintains its own serial sequence).

1. Global Bill Counter (Application Level)

  • Name: Bill Counter (Not Reference)

  • Description:
    Tracks the total number of bills generated from the company. This represents the actual bill number, not a reference number.

  • Table Source:

SELECT * FROM app.tbl_counter_bill_number

2. Front Office Module Bill Counters

2.A. Front Office Reference Number Counter

  • Description: Tracks the total reference counter specific to Front Office bills. Represents the count of reference numbers generated for FO bills.

  • Table Source:

SELECT * FROM fo.tbl_counter_reference

2.B. Front Office External Bill Reference Number Counter

  • Description: Tracks external bill counters in the Front Office module.

    • External (EXT) bill means: A VAT bill generated from POS that is later transferred to the Front Office. These bills are then cleared in FO using the EXT counter.

  • Table Source:

SELECT * FROM fo.tbl_counter_extra_bill

3. Point of Sale (POS) Bill Counters

As the VAT bill number is centrally maintained in app.tbl_counter_bill_number, POS also maintains additional counters.

3.A. Reference Number for Outlet

  • Description: Tracks the total reference counters per outlet.

    • A reference number is an outlet-wise unique bill count.

    • Helps track bills specific to each POS outlet.

  • Table Source:

SELECT * FROM pos.tbl_counter_outlet_reference_number where bill_counter_for = 'outlet_reference';

3.B. Outlet-wise Charge Transfer Bill Counter

  • Description: Tracks the count of charge transfer bills (not VAT bills) for each outlet.

    • These represent transfers (e.g., to room or account) rather than VAT bills.

  • Table Source:

SELECT * FROM pos.tbl_counter_outlet_reference_number WHERE bill_counter_for = 'regular';
SELECT * FROM pos.tbl_counter_charge_transfer_reference_number

4. Credit Note Number Counters

  • Description:
    Tracks the total credit note serial counter for whole module

  • Table Source:

SELECT * FROM app.tbl_counter_credit_note_number;

5. Account Bill Counters

  • Description:
    Tracks VAT bills issued from the Accounts module.

    • Counter is maintained from the VAT bill’s reference number.

  • Table Source:

SELECT * FROM ac.tbl_counter_bill_reference_number

Documented By - Sundar Mishra.

Back to top