Billed = certified in closed RA Bills, Sales Invoices raised against SO.
M-Book = submitted M-Books queued for next RA Bill cycle, not yet invoiced.
Balance = BOQ qty โ Billed โ M-Book.
Clicking Detail opens the full billing trail for that item in the Billing Traceability tab.
Linked Sales Order
ERPNext native
SO-TN-2026-001
12 Jan 2026
Tata Advanced Systems Ltd.
โน3,84,41,400
Works Contract
To Bill
โน1,57,20,000 (41%)
โน2,27,21,400
How BOQ flows to Sales Order & Invoice
1
BOQ entered in Velantra
Each item: unique Item Code, Unit, Qty, Rate. This is the contract schedule of quantities agreed with the client.
2
Push BOQ to ERPNext Sales Order
Each BOQ line becomes an SO line item. Rate and Qty carried across. SO Total = Contract Value. GST type confirmed as Works Contract.
3
Pour Cards reference BOQ item codes
Rate auto-filled from BOQ master. No manual rate entry at pour creation or billing.
4
RA Bill aggregates certified M-Book quantities
RA Bill pulls M-Book quantities per BOQ item, applies contracted rate, calculates billing amount for the cycle. PM approves.
5
Sales Invoice raised โ SO line partially closed
Velantra creates a standard ERPNext Sales Invoice from the approved RA Bill. Each invoice line references the SO line item, progressively reducing the outstanding balance. GST (Works Contract 12%/18%) applied. SO billing status auto-updates.
BOQ โ SO Line Mapping
โ 24 of 24 matched
BOQ item
Description
Unit
BOQ qty
Rate (โน)
SO line ref
Billed so far (โน)
SO line status
RCC-COL-M25-BLKC
RCC Columns M25 โ Block C
mยณ
220.00
8,950
L-04
5,14,625
To Bill
RCC-SLAB-M30-FL03
RCC Slab M30 โ Floor 3
mยณ
410.00
9,350
L-07
7,48,000
To Bill
RCC-RAFT-M30
Raft Foundation M30
mยณ
320.00
8,750
L-02
28,00,000
Fully billed
FORM-SLAB-STD
Formwork โ Slab
mยฒ
2,400.00
745
L-12
3,57,600
To Bill
REBAR-FE500-COL
Reinforcement Fe500 โ Columns
MT
84.50
68,000
L-15
25,97,600
To Bill
Showing 5 of 24 items. All 24 matched. SO line references auto-assigned when BOQ is pushed to ERPNext. Unmatched items (Item Code not in ERPNext Item master) appear in red โ create the Item in ERPNext first.
Billing Traceability โ BOQ item โ M-Book โ RA Bill โ Sales Invoice
Revision rules: Each upload creates a new revision. Already-billed quantities are locked at the rate active at billing time. Rate changes only apply to future M-Books. Item codes are immutable โ add a new item instead of changing codes.
Revision History
Revision
Date
Items
Contract value
By
Status
Rev 3 ยท Current
18 Feb 2026
24
โน3,84,41,400
R. Suresh (QS)
Active
Rev 2
10 Feb 2026
22
โน3,71,20,000
R. Suresh (QS)
Superseded
Rev 1
12 Jan 2026
20
โน3,58,60,000
G. Kannan (PM)
Superseded
Rev 2 โ Rev 3 changes
Item
Change
Old
New
RCC-BEAM-M25-FL02
Item added
โ
185 mยณ @ โน9,100
REBAR-FE500-SLAB
Item added
โ
142 MT @ โน68,000
RCC-COL-M25-BLKC
Qty change
200.00 mยณ
220.00 mยณ
Previous revisions are read-only. RA Bills and Sales Invoices reference the revision active at the time of billing โ complete audit trail preserved for client disputes and statutory audits.