Factory Operations Platform

Green Lanka Factory App

Setup

Database Not Configured

The database connection is set by the system administrator. Staff should only use the Login screen.

Admin setup required:

Set the Supabase Project URL and anon public key in supabase-config.js, then deploy again.

Login

Use the email and password you created in Supabase Authentication.

Selected factory Green Lanka Tea Factory Green Lanka Group
GREEN LANKA GROUP

Select the category you need

Only categories available to your role are shown. The app no longer opens Firewood automatically.

Current Balance
rounded stock yards
0.00 yd
Today Received
rounded stock yards
0.00 yd
Today Issued 0.00 yd
Vehicles Inside 0

Attention Needed

No pending vehicles.

Today Activity

Daily Production Data

Today Green Leaf
selected factory
0.00 kg
No green leaf records.

New Firewood Vehicle Entry

Firewood Measurement at Gate In *

Enter load length, width and height in feet and inches. The app calculates yards automatically.

Length
Width
Height
Calculated Firewood Quantity 0.00 yd 0.00 ft³ ÷ 27 = 0.00 yd
Loaded Vehicle Photo *

Photo must be taken using the camera.

Vehicles in Process

Issue Firewood for Usage

Stock Ledger

DateTypeReferenceStock InOutActual / PaymentRateAmountBalance

Reports

Green Leaf Daily Entry

Inputting user: -

Enter green leaf once per factory for the linked green leaf date and manufacturing date. Saving again updates the same daily record.

Withered Leaf Forecast

Roller Charge: 300.00 kg
Withered %Forecast Withered kgRoller Charge kgOptimum RollersAverage kg / Roller

Recent Green Leaf Entries

FactoryGreen Leaf DateManufacturing DateGreen Leaf kgRemarksEntered By

Withered Leaf Batch Entry

Enter withered leaf batch-wise. Production will take the daily total of all batches for the manufacturing date.

Withering Batches

FactoryManufacturing DateBatchTroughWithered kgFirst Roller Time

Daily Fired Tea / Production Outturn

Only one fired-tea entry per factory per manufacturing date. Dhool 1, Dhool 2 and Big Bulk are entered separately.

Recent Production

FactoryGreen Leaf DateManufacturing DateFired Tea kgMade Tea kgNet OTMade Tea / Hour

Dryer Time / Made Tea Per Hour

Enter dryer starting and finishing time for the selected manufacturing date. The system calculates dryer output as made tea kg per hour.

Tea Stock

Balance: 0.00 kg

Dispatch Tea

Return Tea

Physical Stock Taking

Tea Stock Ledger

DateFactoryTypeGradeReferenceIn kgOut kgBalance

Manufacturing Summary

Daily manufacturing summary for the selected factory/date.

Firewood Cost

This reads existing firewood issue records. It does not change firewood intake, issue, vehicle, or ledger data. Select one manufacturing date to see daily and month-to-date firewood cost per made tea kg.

Manufacturing Master Data

Admin only. Existing Green Lanka login users are kept. Assign tea factory access here.

Factories

User Factory Access

Daily Ledger

Monthly and financial-year summaries, made-tea balance, refuse-tea balance and the selected-month ledger.

Financial year: April 1 – March 31

Use Stock → Entry for Daily Production, Return Tea and Dispatch / Outgoing entries. Tea Dispatch Assignment integration will be added later.

Selected Month Summary

Month-to-date figures for the month selected above.

Financial Year Summary

Separate to-date totals for the selected financial year.

Opening Stock

Admin only

Detailed Dispatch Register

Historical detailed dispatch records for the selected financial year. Latest first. This reference register does not change the Daily Ledger.

0.000 kg
DateInvoiceBuyerGradeDispatch kgVehicleRemarks

Daily Stock Ledger — Selected Month

Only the selected month is shown below. Financial-year calculations and summaries still carry balances forward in date order.

DateOpening MadeGreen LeafFired TeaMade TeaReturn TeaRefuse TeaOut-turn %DispatchLocal SaleGratisMade OutgoingClosing MadeOpening RefuseRefuse OutClosing RefuseStatusActions

Factory Balance Report

Financial-year production, outgoing stock, expected balance and stock-taking variance.

Expected Closing Stock Trend

daily ledger balance

Green Leaf vs Made Tea

daily kilograms

Adjusted Monthly Out-turn

after applied stock-taking adjustments

Outgoing Stock

dispatch, local sale and gratis

Stock-taking Excess / Loss

physical stock against ledger on final green leaf date

Monthly Out-turn After Actual Stock Adjustment

Excess or loss is allocated by each month’s green-leaf share.

MonthGreen Leaf kgRecorded Made Tea kgAllocated Excess / Loss kgAdjusted Made Tea kgAdjusted Out-turn %
Physical Stock DateFinal Green Leaf DateSessionExpected Stock kgPhysical Stock kgExcess / Loss kgVariance %VerificationAdmin Action

Entry

Enter daily production, returned tea and independent dispatch / outgoing quantities.

Stock data entry

Dispatch is entered separately from Local Sale and Gratis. Tea Dispatch Assignment integration will be added later.

Daily Production Entry

Made Tea = Fired Tea less refuse tea, rounded to the nearest whole kilogram. Refuse Tea is kept as the balancing quantity.

Return Tea Entry

Returned tea is added back to the expected made-tea balance.

Stock in

Dispatch / Outgoing Entry

Entered independently for now. Dispatch Assignment integration will be added later.

Separate entry

Stock Taking Dashboard

Latest Stock Taking Sessions

DateFactorySession NoFinal Stock kgStock Value

Stock Taking Session

Create or select a stock-taking session. All data is stored factory-wise. Non-admin users can only use their assigned factory.

Grade Entry

Grade Photo (Optional) Take the photo first. The grade entry cannot be saved without it.

Current Session Summary

GradeMarkGross kgBox Deduction kgNet Tea kgRefuse kgFinal Stock kgValuationValueAction

Stock Taking Reports

Final Stock by Grade

kg composition

Session Stock Trend

final stock over time

Deduction Impact

refuse kg by rate

Stock Value by Grade

valuation comparison

Box Type Usage

number of boxes recorded

Selling Mark Percentage

share of final stock

Average Price Contribution

grade contribution to weighted average

Grade Summary

GradeEntriesGross kgNet kgRefuse kgFinal Stock kgShare %Average Value/kgStock Value

Grade-to-Grade Comparison

MeasureGrade 1Grade 2Difference

Selling Mark Percentage Report

Selling MarkEntriesFinal Stock kgStock Share %Stock ValueValue Share %Average Price/kg

Grade Contribution to Average Stock Price

GradeFinal Stock kgWeight Share %Grade Average PriceContribution to Overall AverageContribution %

Session Comparison

DateFactorySessionGradesGross kgFinal Stock kgRefuse Tea Deduction %Stock Value

Grade Photo Evidence

Photo Compliance Report

GradeTotal EntriesWith PhotoMissing PhotoCompliance %

Detailed Stock Report

DateFactorySessionGradeMarkPhotoDeduction %Gross kgBox Deduction kgNet Tea kgRefuse kgFinal Stock kgValue

Stock Taking Master Data

Admin only

Factory Marks

Select a factory or use Edit below to change its main and second selling marks.

Grades

Deductions

Factory Box Types

Only the box types saved for the selected factory will appear in its calculator.

Leaf Quality Dashboard

Latest Bad Leaf Records

Date/TimeFactoryCustomerReasonPhotoAction

Bad Leaf Customer Entry

Type the supplier/customer Reg No. The customer name will appear automatically. Then select the poor-quality reason and add photo proof.

Bad Leaf Photo *

Take a photo of the leaf quality issue.

Leaf Quality Reports

Routes with most bad leaf

RouteRecordsCustomers

Bad leaf type summary

TypeRecordsCustomers

Customers with repetitive bad leaf

CustomerRouteRecordsMost Common TypeLast Record

Detailed Records

Date/TimeFactoryReg NoCustomerRouteReasonSeverityRemarksPhotoAction

Leaf Quality Master Data

Customers: Admin/Office Clerk · Reasons: Admin

Customer List

Bulk customer import

Upload PDF/CSV/TXT containing Reg No, Name, Telephone No and Route. The first column must be Reg No.

Reg NoNameTelephoneRoute
No import preview yet.

Poor Quality Reasons

Office Cashbook Dashboard

Selected Day Entries

DateFactoryTypeCategoryDescriptionAmountDiffBill

Recent Cashbook Entries

DateFactoryTypeCategoryDescriptionAmountDiffBill

Cashbook Entry

Bill photo required for expenses
Figure check: Enter cash amount and bill total.
Bill Photo

Take a clear photo of the bill/invoice. The app can read the total from the photo and cross-check it with the entered bill total.

Take bill photo, then click Read Amount From Photo.
OCR is an automatic check only. Very unclear bills may still need manual verification.

Cashbook Reports & Monthly Vouchers

Expense Category Summary

CategoryBillsCash AmountInvoice TotalDifference

Detailed Cashbook Records

DateFactoryTypeCategoryDescriptionAmountDiffBill

Cashbook Master Data

Expense categories

Expense Category

Category List

Tea Sale Proceeds Dashboard

Track net tea proceeds and VAT receipts separately. Over-advances and proceeds credits are automatically carried to the next Seller’s Contract for the same factory.

Outstanding settlements

Prompt dateFactory / MarkContractPrompt-date balanceCurrent proceeds balance / credit statusNon-BG VATBG VATStatus

Seller Tax Invoices

Upload the factory tax-invoice PDF issued to tea buyers. The app recognises both supplied layouts, reads every page, and links each invoice and lot to the Seller’s Contract.

Saved Seller Tax Invoices

Showing only the factory selected at the top. Original PDFs remain available by page number.

DateFactoryTax InvoiceBuyer / TINSeller ContractLotsTaxable ValueVATTotalMatch StatusPDFActions

Quarterly IRD VAT Schedules — 01, 02 and 04

Prepare Schedule 01 from Seller Tax Invoices plus Local Sales, Manure Sales, Refuse Tea, Coir Bags and other taxable output invoices. Schedule 02 and Schedule 04 follow the supplied IRD XLSM templates. CSV dates are written as quoted MM/DD/YYYY text. Serial and money columns are written as unquoted whole-number values with no decimal point.

Select a factory, year and quarter. Every CSV date is exported as MM/DD/YYYY with leading zeros. Version 6.21 keeps IRD money columns as raw integers and fixes VAT Summary grouping. All XLSM fields are mandatory; invoice numbers cannot contain spaces; TINs must contain exactly 9 digits.

CSV format: Dates are exported as MM/DD/YYYY with leading zeros. Monetary columns are exported as raw integers without .00 or any decimal point. Do not open and re-save the IRD upload CSV in Excel because Excel can visually reformat dates.
Schedule 01 coverage: Tea buyer invoices and all saved Other VAT Output invoices are included. Do not upload a Colombo Tea Auction invoice again when the broker's RAMIS Web API transmission already succeeded.

IRD Schedule 01 — Output Tax Invoices

#Invoice DateTax Invoice No.Supplier / TINPurchaser / TINSource / ContractDescriptionTaxable ValueVATTotalIRD Validation
Select a factory, year and quarter, then search.

IRD Schedule 02 — Purchase / Input Tax Invoices

#Invoice DateTax Invoice No.Supplier TINSupplier NameDescriptionValue of PurchaseVATDisallowed VATAllowable VATIRD Validation
Select a factory, year and quarter, then search.

IRD Schedule 04 — Tax Credit / Debit Notes

#TIN No.Invoice DateInvoice No.Credit / DebitNote DateNote No.ValueVATIssued By MeIRD Validation
Select a factory, year and quarter, then search.

Bank Receipts

Record proceeds and VAT deposits into their respective bank accounts. Partial receipts are supported.

Select a seller contract and receipt type. The outstanding amount will be filled automatically and can be edited.

Receipt history

Use Edit to correct a saved receipt. Financial balances and carried credit are recalculated after saving.

DateContractTypePurposeBank accountAmountReferenceRemarkEntered byActions

Allocate advances received before sale

Link all or part of a pre-sale advance to the relevant Seller’s Contract. The original received date is used when calculating the balance before prompt date. Any excess automatically carries to the next contract of the same factory.

Select a saved pre-sale advance. Allocate it to the first relevant contract; any excess will automatically pass to the next contract of the same factory.
Advance dateFactoryAdvance / UnallocatedAllocated contractAllocation dateAllocated amountRemarkActions

Bank Account Master

Create separate receiving bank accounts for each factory. Bank Receipts will show only the accounts belonging to the selected factory.

Saved bank accounts

FactoryBankAccount nameLast 4TypeStatusActions

Proceeds Adjustments

Record manual adjustments after the Seller’s Contract, including advance interest and other additions or deductions. Interest is entered as a manual amount for now.

Saved adjustments

DateContractFactory / MarkCategoryTypeAmountRemarkActions

Tea Sale Reports & Statements

Open only the report you need. Weekly and monthly sales reports, bank statements and accounts statements are kept in separate workspaces.

Weekly / Monthly Tea Sale Report

Weekly reports use the sale date. Monthly reports use the Report Month saved with each Seller’s Contract.

Select the period and click Search Sales Report.

VAT Management

Open only the VAT area you need. The working paper uses Auction Sale VAT by sale date, other VAT Output, Purchase Bills, Tax Credit/Debit Notes and VAT Payments.

Monthly VAT Working Paper

Select the factory and VAT month, then search. Use VAT Summary PDF for a one-page management summary. Use Detailed VAT PDF for transaction schedules, reconciliation, Purchase Bills, Seller Tax Invoices and Tax Credit/Debit Notes with larger fonts.

Select a factory and month. Auction Sale VAT uses the Seller Contract sale date.

VAT Output – Gross, Credit Notes and Net

CategorySale with VATVAT 18%Sale without VAT

VAT Input – Gross, Credit Notes and Net

CategoryTotal amountInput VATTaxable value

Tax Credit Notes Applied in This VAT Period

Purchase Credit Notes reduce VAT Input. Sales Credit Notes reduce VAT Output. They are shown separately and are never hidden inside the sales or purchase totals.

DateTypeSupplier / CustomerCredit NoteTaxable ValueVATTotal

VAT Summary Details

DateInput / OutputCategoryDescriptionReferenceValueVATTotal

Master Data

Firewood master data is factory-wise. Green Lanka existing master records remain under Green Lanka. Select the factory at the top before adding suppliers, owners, vehicles, or pricing.

Supplier / Customer List

Owner List

Vehicle List

Pricing List

GREEN LANKA CENTRAL STORES

Main Stock, Ordering & VAT Distribution

Bulk purchases are received into Green Lanka main stock. Items issued to group factories are posted through VAT invoices and deducted from stock automatically.

Low Stock / Reorder Items

CodeItemUnitBalanceReorder Level

Pending Purchase Activity

Items, Suppliers & Factory Accounts

Maintain the stock catalogue and parties used for purchase orders, goods receipts and VAT invoices.

Item Master

Supplier Master

Group Factory VAT Account

Items

CodeItemCategoryUnitBalanceReorderSell PriceAction

Suppliers

NameVAT No.PhoneAction

Factory Accounts

FactoryVAT No.ContactAction

Purchase Requisitions

Request items before supplier ordering. Admin can approve submitted requisitions.

ItemQtyEstimated CostNote

Saved Requisitions

No.DateRequiredDepartmentStatusItemsAction

Purchase Orders & Supplier Ordering

Create a PO directly or load an approved requisition. The PO can be printed and sent to the supplier.

ItemQtyUnit PriceTaxableVATTotal

Purchase Orders

PODateSupplierExpectedStatusTotalAction

Goods Receipt & Bulk Stock Intake

Receive supplier deliveries against a purchase order. Posting the GRN increases Green Lanka main stock and can add the supplier invoice to VAT Input.

ItemOrderedAlready ReceivedReceive NowUnit CostVAT %

Goods Receipts

Admin can delete a GRN when sufficient stock remains. Deletion reverses stock, PO received quantities and the linked VAT Purchase Bill.

GRNDatePOSupplier InvoiceStatusTotalActions

VAT Invoice — Stock Sale to Group Factory

Green Lanka sells or issues stock to another factory under VAT. Posting the invoice deducts stock and adds the output to the VAT working paper.

ItemAvailableQtyUnit PriceTaxableVATTotal

Saved VAT Invoices

InvoiceDateFactoryVAT No.StatusTaxableVATTotalAction

Central Stores Stock Ledger

Green Lanka is the main stock location. All posted goods receipts and VAT invoices appear here.

Current Stock Balance

CodeItemCategoryUnitReceivedIssuedBalanceStock Value

Stock Movements

DateItemTypeReferenceCounterpartyInOutUnit Cost

Settings

Database Connection

The Supabase connection is fixed by the administrator in supabase-config.js.

MADE TEA MOVEMENT CONTROL

Tea Dispatch Control Centre

Create controlled invoices, assign them to broker dispatches and verify every bag weight before departure.

Open Invoices0
Ready Dispatches0
Items Awaiting Weight0
Dispatched Net Weight0.000 kg

Tea Dispatch Subcategory Summary

Open any section directly. Counts use the currently selected factory.

Recent Dispatch Activity

Live status from invoice creation through final weighing.

DispatchSaleDateBrokerLorryDriverInvoicesBagsWeightStatus
AUCTION CALENDAR CONTROL

Sale Arrangements

Create the official sale number and calendar once, then assign every dispatch to the correct sale.

Financial year not selected

Create / Edit Sale Arrangement

The current factory financial year is applied automatically. The complete official auction calendar can be stored, including buyer and seller prompt dates, levy dates, VAT dates and TIN collection dates.

Official Sale Calendar

The v6.39.33 migration loads official CTTA Sales 01–13 for Q1 2026 under FY 2025/2026 and Sales 14–24 for Q2 2026 under FY 2026/2027. The earlier Q3 migration provides Sales 25–38. NIL dates stay blank, while the Sale 13 10% payment is retained as NA.

Sale / FYDate of SaleCatalogue ClosePrompt BuyerPrompt Seller10% PaymentE-Platform BuyerE-Platform SellerVAT SummaryVAT BuyerVAT SellerBuyer TIN DeliveryTIN CollectionStatus

Create Tea Invoice

Invoice numbers are unique within the factory financial year.

Financial year not selected

Enter only the net tea weight inside each pack. The grade sample is additional tea, is added to the invoice total, and must be weighed separately. Sack tare is checked only for normal bags.

Packed Tea 0.000 kgSample Added + 0.000 kgTotal Expected Net Tea 0.000 kg

Saved Invoices

Private invoices remain visible here with a PRIVATE label but are handled only in the separate Private Sales page.

InvoiceSale TypeEffective Financial YearSelling MarkGradePacksSackNet / PackSampleExpected NetMfg DateValuationMoistureStatus
SEPARATE NON-AUCTION WORKFLOW

Private Sales

Register private-sale invoices and their supporting documents separately. These invoices never enter public acknowledgements, broker valuations, Seller Contracts, catalogue attempts, Sale +3, unsold, shutout or violation processing.

PRIVATE ONLY
Private Sales0
Total Packages0
Total Sale Weight0.000 kg
Total Sale ValueRs. 0.00
Average PriceRs. 0.00

Create / Edit Private Sale

First mark the tea invoice as Private Sale in Invoicing, then select it here. Invoice details are loaded automatically and may be corrected for the private-sale document.

No document selected.

Private Sale Register

This register is independent from the public auction and Seller Contract workflow.

DateInvoiceReferenceBuyerMark / GradePackagesNet + SampleSale WeightPrice / kgTotal ValueDocumentRemarksActions
No private sales saved.

Import Previous Dispatch PDFs

Upload one or more Tea Estate Invoice PDFs. Files for the same factory, date, broker, lorry and driver are combined into one completed historical dispatch.

Admin only
No PDF preview loaded.
PDFSelling MarkInvoiceM/F DateGradePacksNet / PackSamplePDF Total NetMoisture
No previous dispatch PDF preview.

Missing selling marks, grades, pack options, sack types, brokers, lorries and drivers are created automatically. Existing invoice numbers in the current financial year are skipped.

Create / Edit Dispatch

Assign one or more prepared invoices to the lorry, driver and broker. Administrators can edit or permanently delete incorrect open and completed dispatches. A deletion reason and full audit snapshot are retained.

Dispatch Register

Open a dispatch to continue bag weighing. Use Dispatch PDF for the Tea Estate Invoice layout; dispatch deletion is available only to administrators.

DispatchSaleDateBrokerLorryDriverInvoicesPacksExpected NetWeighedStatusAcknowledgementBroker ValuationSMS

Previous Unsold Carry-Forward Items

Seller Contract-confirmed unsold lots are brought to Dispatch Assignment at Sale +3 and are automatically included when reading the acknowledgement.

Invoice / MarkSource SaleAcknowledgement SaleSampleExpected QtyStatus
BROKER CATALOGUE RECEIPT

Acknowledgements

Upload the broker acknowledgement and tally every invoice against the combined Dispatch Assignment: completed physical dispatches plus previous-unsold Sale +3 carry-forward invoices.

PDF linked to dispatches

Upload & Link Acknowledgement

The system reads the sale, lot and invoice details, refreshes previous-unsold carry-forward items, and matches the PDF against physical dispatches plus Sale +3 unsold invoices.

No acknowledgement PDF preview loaded.

Saved Acknowledgements

One acknowledgement can cover several dispatches and selling marks under the same sale. Use Report to print or save the full acknowledgement reconciliation.

SaleCatalogue Sale DatePDFMarksInvoices / LotsLinked Dispatches / Carry-ForwardBroker ValuationActions
BROKER QUALITY & PRICE REVIEW

Broker Valuations

Upload a valuation only after its acknowledgement has been saved. The valuation is linked to the acknowledgement and therefore to all covered dispatches.

Acknowledgement required

Upload Broker Valuation

The system checks the sale number, estate marks and invoice numbers against the selected acknowledgement before saving.

No broker valuation PDF preview loaded.

Saved Broker Valuations

Each valuation opens from its acknowledgement and inherits the acknowledgement's dispatch links. Use Report to print or save valuation details and the invoice tally.

SaleAcknowledgementPrinted DatePDFMarksInvoicesProjected ProceedsDispatchesActions
BROKER SALE OUTCOME CAPTURE

Seller Contracts

Upload Seller Contracts immediately after Broker Valuation and link sold, unsold or withdrawn lots to the original Tea Dispatch invoices.

After Broker Valuation

Upload / Edit Seller Contract

Upload the broker PDF, verify every lot and save it directly inside the Tea Dispatch workflow.

Broker deduction categories

These are extracted from the Seller’s Contract and can be corrected before saving.

Deduction categoryAmount

Lot details

Sold, not-sold and withdrawn lots are stored separately. Only SOLD lots contribute to proceeds, VAT, kilos and averages.

BuyerBuyer VATLotInvoiceFYGradeBagsGross kgSampleNet kgPrice/kgProceedsVAT 18%Total + VATBank guaranteeStatus

Saved contracts

Showing only the factory selected at the top.

Sale / Prompt / Report monthFactory / MarkContractLotsGross proceedsContract netAdjusted netCurrent outstanding / credit statusNon-BG VATBG VATSeller Tax InvoicesPDFActions
READ-ONLY SOURCE DOCUMENT AUDIT

Invoice Document Chain

Compare Dispatch, Acknowledgement, Broker Valuation and sold-status source rows directly for each invoice and sale. This register does not rewrite historical linkage records.

Audit Filters

Each sale is checked separately. A source document is counted when its own invoice, sale and estate-mark evidence exists; old catalogue-attempt pointers are not used to decide whether the document was found.

Evidence rule: MF1562 / SUDUGAHAHENA and MF1562A / WICKRAMS remain separate. REVIEW is shown only for a genuine source-data conflict, such as different lot numbers inside the same sale—not for a missing historical pointer.
Invoices0
Dispatch Found0
Acknowledgement Found0
Valuation Found0
Sold Status Found0
Complete Evidence Chain0

Invoice Linkage Register

The header row and Invoice column remain frozen. Evidence is calculated directly from saved source documents. Sold Status is read from the extracted Seller Contract lot source register and linked through the invoice financial year.

0 invoices
InvoiceFYSelling Mark / GradeDispatchAcknowledgementBroker ValuationSold StatusOverall
Open this tab to load invoice linkages.
INVOICE-LEVEL AUCTION HISTORY

Invoice Catalogue Attempts

Track partial acknowledgements, Shutout/Violated transfers, valuation and Seller Contract links, Unsold Sale +3 recataloguing and Withdrawn decisions.

InvoiceDispatchAttempt / SaleSourceMark / GradePrevious QtySampleExpected QtyAck QtyLotStatus / OutcomeLinksAction
Run the v6.39.17 SQL migration and refresh.
MANUAL SALE TRANSFER QUEUE

Acknowledgement Holding Bin

Hold acknowledged Dispatch Assignment invoices safely and transfer them to any selected sale later. Quantity and sample history are retained.

Held Invoices0Held Quantity0.000 kg

Invoices Awaiting Manual Sale Transfer

Use Transfer to Sale when the required future sale is known, or Withdraw to end the catalogue workflow.

InvoiceMark / GradeHeld From SalePrevious QtyExisting SampleRemaining QtyReasonAction
No held invoices.
LIVE UNSOLD INVENTORY

Unsold Bin

Invoices enter this bin automatically when the latest Seller Contract result is Unsold. When a later Seller Contract records the invoice as Sold, it moves automatically to Sold from Unsold Bin.

Unsold Bin Filters

Results are read from catalogue attempts and Seller Contracts. No manual movement is required.

Currently Unsold0
Current Unsold Quantity0.000 kg
Sold after Unsold0
Sold Quantity0.000 kg

Currently Unsold

The latest confirmed Seller Contract result is Unsold. Sale +3 recatalogue details are shown when available.

0 invoices
InvoiceFYSelling MarkGradeLast Unsold SaleLotUnsold QtyUnsold TimesNext SaleNext Catalogue QtyCurrent Status
No unsold invoices.

Sold from Unsold Bin

Invoices that were Unsold one or more times and were later confirmed Sold automatically appear here.

0 invoices
InvoiceFYSelling MarkGradeUnsold Sale HistorySold SaleSold DateLotSold QtyBuyerPrice / kgContract
No invoices sold after being unsold.
WITHDRAWN TEA FACTORY RETURN CONTROL

Withdrawn Teas to Be Brought Back to the Factory

Withdrawn Seller Contract lots are excluded from catalogue matching and remain here until the full quantity is physically received back at the factory.

Pending Lots0
Pending Quantity0.000 kg
Received Quantity0.000 kg
Fully Returned0

Record Factory Receipt

Partial receipts are allowed. The balance remains pending until the complete withdrawn quantity is received.

Select a withdrawn Seller Contract lot.

Withdrawn Tea Return Register

Shows pending, partially returned and fully returned withdrawn teas separately from buyer rejected returns.

Invoice / LotSale / ContractGradeWithdrawn QtyReceivedBalanceStatusReceipt DetailsAction
No withdrawn teas.
NON-CATALOGUED TEA RETURN CONTROL

Broker Returns to the Factory

Invoices shown as Not Catalogued, Shutout, Violated or Pending Clarification can be physically returned from the broker. Partial receipts remain open until the complete broker-held quantity is received at the factory.

Pending Invoices0
Pending Quantity0.000 kg
Received Quantity0.000 kg
Fully Returned0

Record Broker Return Receipt

Select the exact non-catalogued sale attempt. Repeated invoice numbers remain separate by sale and attempt number.

Select a non-catalogued invoice attempt.

Broker Return Register

Tracks each non-catalogued sale attempt independently and shows pending, partially returned and fully returned quantities.

Invoice / FYSale / AttemptMark / GradeReasonReturn DueReceivedBalanceStatusReceipt DetailsAction
No broker-return invoices.
SOLD TEA RETURN CONTROL

Buyer Rejected / Return Tea

Buyer rejection remains SOLD in the Seller Contract. Record rejection, To Be Returned, partial return and final return details separately.

Invoice / LotSale / ContractBuyerSoldRejectedReturnedBalanceStatusReturn DetailsAction
No buyer rejections.

Bag & Sample Weighing

Choose a remaining bag or the sample. Saved items disappear from the dropdown while the dispatch, invoice and Sri Lanka date remain selected after synchronization.

Selected ItemSelect itemNet Tea0.000 kgSack Tare0.000 kgExpected Scale Weight0.000 kgMaximum Allowed0.000 kgInvoice Sample0.000 kg
Manual weight entry · connected-scale interface ready
Select an unweighed bag or the sample.
Weighed Items 0 / 0Actual Scale Gross 0.000 kgExpected Scale Gross 0.000 kgGross Variance 0.000 kg

Recorded Bags & Sample

ItemActual ScaleExpectedDifferenceCheckScale / SourceSri Lanka Date / TimeRemark
LOCAL WEIGHING SCALE CONNECTION

Scale Settings & Local Bridge

Connect the digital scale attached to this computer. These settings stay on this browser and do not change another factory computer.

Bridge not tested
BridgeOffline
Serial PortNot selected
Latest Stable Weight
Reading ModeManual

Browser Connection

The app talks only to the bridge address below. Use 127.0.0.1 when the scale is connected to this same computer.

Install and start the Local Scale Bridge, then press Test Bridge.

Serial Scale Configuration

These values are sent to the bridge and saved on this computer. Start with 9600 / 8 / None / 1 unless the scale manual states otherwise.

No serial configuration loaded.

Live Reading Test

Place a known test weight on the scale. A stable reading must be shown before production use.

No readingRaw scale text will appear here.

Local Bridge Installation

On the Windows computer connected to the scale, open the included local_scale_bridge folder and run INSTALL_SCALE_BRIDGE.bat as Administrator. The bridge starts invisibly with Windows and listens on this computer only.

No Supabase SQL is required for this update. Connected readings continue to save the device ID, raw reading and reading source with each bag or sample weight.

INVOICE 1–1500 WORKFLOW MAP

Invoice Register

Select the factory and effective financial year to see every invoice number from 1 to 1500 in ascending order. Click any coloured invoice to open its complete movement from dispatch through catalogue and Seller Contract outcome.

Select period

Register Period

The financial year is the main period. Month and sale are optional additional filters; all 1–1500 buttons remain visible.

Dispatched Catalogued Sold Unsold Private Sale Not used in period
Dispatched0
Catalogued0
Sold0
Unsold0
Private0
Unused1500

Invoice Numbers 1–1500

Status priority is Sold → Unsold → Catalogued → Dispatched. A later final Seller Contract result therefore replaces the earlier workflow colour.

1500 invoices
Select a financial year and load the register.

Invoice Detail

Click an invoice number to view the full dispatch-to-sale history.

No invoice selected.
DISPATCH TO SALE TRACEABILITY

Tea Dispatch & Sold Reports

Review month-wise and sale-wise movement, detailed dispatches, Seller Contract outcomes and the live status of any invoice.

All records

Report Filters

Financial year comes from the Tea Dispatch Master assigned to each invoice. Month uses dispatch date for dispatch reports and sale date for sold reports.

Dispatches0
Invoices0
Dispatched Net0.000 kg
Sold Net0.000 kg
Unsold / Withdrawn0.000 kg
Pending Final Outcome0

Documents To Upload

One row per invoice and sale attempt. The register shows the next missing document in order: Dispatch Assignment → Acknowledgement → Broker Valuation → Seller Contract.

0 pending
Dispatch Assignment0Invoices not assigned to a dispatch
Acknowledgement0Dispatched / attempted invoices without acknowledgement evidence
Broker Valuation0Acknowledged invoices without valuation evidence
Seller Contract0Valued invoices without sold-status source rows
InvoiceFYSale / AttemptSelling MarkGradeDispatch AssignmentAcknowledgementBroker ValuationSeller ContractNext UploadOpen
Search reports to calculate missing documents.

Invoice Current Status

Select an invoice above to see its complete movement from creation to final sale outcome.

No invoice selected.

Month-wise Summary

Dispatch and Seller Contract outcomes grouped by calendar month.

MonthSalesDispatchesInvoicesPacksDispatch Net kgSold kgUnsold kgWithdrawn kgPending

Sale-wise Summary

Compare quantities dispatched, acknowledged, sold, unsold and withdrawn for each auction sale.

SaleSelling DateDispatchesInvoicesDispatch Net kgCatalogue kgShutout / Violation kgSold kgUnsold kgWithdrawn kgPending

Monthly Grade Dispatch Report

Select a month above. Invoice numbers are grouped under each grade. Packed tea, dispatch samples and the complete dispatched weight are totalled separately.

Select month
Invoice NumbersGrade NameInvoicesPacksPacked Tea kgDispatch Sample kgTotal Dispatched kg
Select a month to create the grade dispatch report.

Dispatch Report

One row per Tea Dispatch invoice with acknowledgement, catalogue and final outcome status.

FYDispatchSaleDateInvoiceSelling MarkGradePacksDispatch Net kgBrokerLorryAcknowledgementCatalogueCurrent Status

Sold Report

Seller Contract lot results for dispatched invoices, including buyer, price and rejection/return status.

SaleSale DateSeller ContractLotInvoiceFYGradeBuyerOutcomeNet kgPrice / kgProceedsBuyer Return Status
TEA BOARD MONTHLY RETURN

TC5 - Monthly Tea Production & Dispatch

Prepare the official bilingual Sinhala-English TC5 return as a fully typed, sharp vector form without handwriting or scanned backgrounds. Auction packed tea and dispatch samples are linked directly from the Monthly Grade Dispatch Report.

New return

Return Month

Select the factory and calendar month. The full auction dispatch quantity, including its dispatch sample, is placed under Colombo Auction. Gifts / Others is reserved for genuine gift or other disposals entered separately. Generated TC5 input values print in larger written blue (#00308F).

Opening Made Tea0.000 kg
Monthly Production0.000 kg
Colombo Auction0.000 kg
Dispatch Samples0.000 kg
Total Disposals0.000 kg
Closing Made Tea0.000 kg

1. Factory Particulars

Saved particulars are carried forward automatically to the next month.

Average Green Tea Leaf Standard (enter two digits)

2. Production and Stock Position of Orthodox Made Tea

Monthly made tea and refuse production are read from Stock → Daily Ledger. All made tea defaults to From Bought Leaf, but the source columns remain editable.

Not loaded
Opening StockFrom Own LeafFrom Leaf of Other EstatesFrom Bought LeafMade by Other FactoriesMisc. ReceiptsTotal AvailableDisposalsClosing Stock

Load a month to calculate the return.

8. Details of Disposals of Made Tea

Automatic rows come from the Monthly Grade Dispatch Report: packed tea is Colombo Auction and sample weight is Gifts / Others.

0 grades
Invoice Nos.GradeColombo AuctionPrivate SalesForward ContractsEx-factoryDirect ExportGifts / OthersReturned to Other EstatesDirect SalesTotal kg
Load TC5 data to link monthly dispatches.

Other Disposal Details

Add only disposals not already included in Tea Dispatch. Private and direct-sale rows also populate the detailed TC5 sections.

0 rows
CategoryMarkInvoiceGradeBuyerSale DatePanel DatePrice / kgWeight kgAction
No additional disposals.

5. Refuse Tea

Manufactured refuse is linked from monthly production. Opening balance is carried from the previous saved TC5 return.

Opening StockManufacturedQuantity SoldUsed as ManureOther DisposalsBalance Stock

6-7. Broker and Selling Marks

Monthly brokers and active Tea Dispatch selling marks are loaded automatically; edit when required.

Declaration

These details appear on page 2 of the generated TC5 return.

Tea Dispatch Master Data

Financial year, selling marks, grades, sample allowance, pack options, sacks, lorries, drivers and brokers.

Financial Years

Saving a year makes it the current financial year for the selected factory.

Grades & Sample

Selling Marks

Pack Options

Sack Types

Lorries

Drivers

Brokers

Dispatch SMS Notifications

Each factory can save its own Dialog eSMS URL message key, username, password, mask, recipients and message template. Dispatch messages now identify the Selling Mark and show the month-to-date dispatched weight under that mark; Dispatch Code is not included. Historical PDF-imported dispatches can be sent manually from the Dispatch Register by an administrator; they are never sent automatically. To add telephone numbers later, leave the secret fields blank—the saved login is retained and only the recipient list is updated.

ADMIN SETTINGS
Advanced API parameter names
Select a factory to load its encrypted SMS provider settings.

Dialog eSMS defaults: GET request; message key field esmsqk; username username; password password; mask source_address; recipient list; message message. Available message fields: {factory}, {dispatch_date}, {dispatch_time}, {dispatch_datetime}, {sale}, {sale_date}, {broker}, {vehicle}, {driver}, {driver_phone}, {invoice_count}, {bags}, {net_kg}, {selling_mark}, {mark_dispatch_kg}, {mark_dispatch_bags}, {sale_mark_kg}, {sale_mark_bags}, {month_mark_kg}, {month_mark_bags}, {month_dispatch_count}, {mark_summary}, {month_name}. Line breaks are preserved. Dispatch Code is intentionally excluded. Administrators can use Resend SMS to deliberately send another copy.

Deploy dispatch-sms-v64007 once. Provider credentials are then managed separately for every factory from this screen.
DispatchRecipientStatusSent / UpdatedError
No SMS log loaded.
MONTHLY FINANCIAL CONTROL

Factory Profit & Loss

Combines captured factory data with approved monthly adjustments and calculates cost of production.

Total IncomeRs. 0.00
Total ExpensesRs. 0.00
Profit / (Loss)Rs. 0.00
Made Tea0.000 kg
COP without Financial ChargesRs. 0.00/kg
COP including Financial ChargesRs. 0.00/kg

Monthly P&L Summary

Auto values come from existing app modules. Manual entries are added separately and remain fully traceable.

SectionDescriptionSourceAutoManualTotalCOP
Select a factory and month.

Transaction Drill-down

Select a P&L line to see the exact source records and manual adjustments behind the total.

Click any P&L line in the summary.
DateSourceReference / DescriptionAmountRouting
No line selected.

Automatic Source Checks

SourceRecordsAmountStatus / Note
No source data loaded.
SMART ACCOUNTING INBOX

Review, Route & Reconcile

Every source transaction appears once, with an automatic destination suggestion, duplicate protection and a complete audit trail.

Needs Review0
Routed0
Excluded / Duplicate0
Data Quality Score0%

Source Transactions

Change the P&L destination at any time. Linked bank credits are marked and excluded by default to prevent double counting.

DateModuleReference / DescriptionAmountSuggested / Current DestinationConfidenceStatusAction
Load a month to review transactions.

Month Control

Closing a month locks P&L routes and manual adjustments. Reopen only with a recorded reason.

Current StatusOPEN
Unmapped Transactions0
Source Errors0
Made Tea0 kg

Monthly Operational Inputs

Made tea and green leaf are read automatically where available. Enter an override only when the official month-end figure differs.

Manual P&L Entry / Adjustment

Use this for payroll, electricity, bought leaf payments and any cost or income not captured automatically.

Saved Monthly Entries

DateSectionDescriptionReference / NoteUnitsRateAmountAction
No entries.

Monthly Profit & Loss Report

Structured from the supplied factory P&L workbook with live source values, manual adjustments and COP.

SectionDescriptionSourceAutoManualTotal Cost / IncomeCOP / kg
Prepare a report first.

P&L Master Lines & Source Mapping

Edit the workbook line names and decide whether a line is manual or linked to an existing app source.

Configured Lines

OrderSectionLineTypeSourceMatchIncludedStatusAction
No P&L lines.
ADMINISTRATION

User Control Centre

Manage every Supabase login's app role, active status, factory assignments and visible categories from one dedicated page.

Total Supabase Users0
Active App Users0
Inactive / No Role0
Unconfirmed Emails0

Access Overview

All Supabase Users & App Access

Every account from Supabase Authentication is shown here, including accounts without an app role. Select a user to manage role, status, factories and category visibility. Password reset emails can also be sent from this page.

Category Access

Choose which home-page categories this user can see. The selected role remains the maximum database permission level.

Email / Auth Status Name Role Factories Category Access Created / Last Sign-in Action
No users loaded.
Total Timer Records 0
Completed 0
Stopped 0
Latest Device -

Timer Records

ESP32 timer records uploaded to Supabase. Use filters to check by date, device, and status.

Device Start Time End Time Total Min Actual Min Intervals Status Uploaded At
No timer records loaded.

Take Photo

Camera permission is required. On mobile, use HTTPS or install as app for best results.