| No. | Record No. | DraftBill | Date | Sector | BRU | Date Period | Crew | Supv. Engr | Billed Amount | Collected Amount | Balance | Pay. Ref. No. | Classification | Action | |
|
|
|||||||||||||||
| {{ x.RowNo }} | {{ x.RecordNo }} | {{ x.DraftBillNo }} | {{ DateStyle(x.Date,'C') }} | {{ x.Sector }} | {{ x.BRU }} | {{ x.PeriodCovered }} | {{ x.Crew }} | {{ x.SupvEngr }} | {{ NumberStyle(x.BilledAmount,'WC')}} | {{ NumberStyle(x.CollectedAmount,'WC') }} | {{ NumberStyle(x.Balance,'WC') }} | {{ x.PayRefNo }} | {{ x.Classification }} | ||
| Record No. | DraftBill No. | |||
| Sector | Date |
|
||
| BRU Name | Supervising Engr |
|
||
| Crew |
|
Period Covered |
| Date | Job Details | CAPEX/OPEX | Charge Account | Amount |
| W.O. No. | Labor Amount | ||
| Customer Name | Vehicle Amount | ||
| Pay. Ref. No. | Total Amount | ||
| Job Classification |
|
Add:12% VAT | |
| Gross | |||
| Less:2% EWT | |||
| Due |
| DraftBill No. | |
| Search P.O. No./W.O.No. | |
| Department |
| DraftBill Amount | |
| Total Charge Amount | |
| Balance |
| W.O. No. | P.O. No. | G.R. No. | Inv. No. | PO Amount | Remaining Amount | Payment Amount | Action |
| {{x.WONo}} | {{x.PONo}} | {{x.GRNo}} | {{x.InvNo}} | {{NumberStyle(x.POAmount,"WC")}} | {{NumberStyle(x.RemainingAmount,"WC")}} | {{x.PaymentAmount}} | {{ x.Action }} |
| W.O. No. | P.O. No. | G.R. No. | Inv. No. | PO Amount | Paid Amount | Run. Balance | Action |
| {{x.WONo}} | {{x.PONo}} | {{x.GRNo}} | {{x.InvNo}} | {{NumberStyle(x.POAmount,"WC")}} | {{NumberStyle(x.PaidAmount,"WC")}} | {{NumberStyle(x.RunningBalance,"WC")}} |
| Record No | DraftBill No | W.O. No. | P.O. No. | PO Amount | Remaining Amount | Paid Amount | Pay. Ref. No. |
| {{ x.RecordNo }} | {{ x.DraftBillNo }} | {{ x.WONo }} | {{ x.PONo }} | {{ NumberStyle(x.POAmount,"WCB") }} | {{ NumberStyle(x.RemainingAmount,"WCB") }} | {{ NumberStyle(x.PaidAmount,"WCB") }} | {{ x.PayRefNo }} |
| Total | {{ NumberStyle(SumCol(NC1D34_FindResult,"PaidAmount"),"WCB") }} | ||||||
| Work Order | PO | GR | Amount | Sector | Department | # |
| {{ x.WO }} | {{ x.POWLine }} | {{ x.GR }} | {{ NumberStyle(x.Amount,"WCB") }} | {{ x.Sector }} | {{ x.Department }} | |
| Total | {{ NumberStyle(SumCol(NC2D1_FindResult,"Amount"),"WCB") }} | |||||
| Total Selected | {{ NumberStyle(SumColIfs(NC2D1_FindResult,'Amount',item=>item.Selected==true),"WCB") }} | |||||
| PO | Amount |
| {{ x }} | {{ NumberStyle(SumColIfs(NC2D1_FindResult,'Amount',item=>item.Selected==true && item.PO==x),"WCB")}} |