Factory Operations Platform

Green Lanka Factory App

Setup v6.44.98

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.

Selected factory Green Lanka Tea Factory Green Lanka Group
ENGINEERING · ROLLER CONE

Roller Cone Designer

Editable dimensioned drawing, saved designs and 360° brass model · Inches (in)
Standard cone heights6–9 inches · figures in inches
8 in high · 7 measurement stations
01 — Profile figures
7 points
#Height (in)Outside Ø (in)

The drawing passes through each measurement. Add points wherever the curve changes shape.

02 — Dimensions & shapeHEIGHT / WALL IN INCHES · Ø SELECTABLE
0.85 in

Drag right for a longer rounded shoulder; drag left for a sharper one. The top diameter stays exactly as entered.

All station heights are measured from the bottom. The top remains a small, flat circular cap with the entered top diameter. The shoulder slider rounds the transition into the cap.

03 — Casting & mould notesPreliminary only
Allowances are recorded but not applied to the finished section unless a separate, reviewed pattern drawing is prepared.
04 — Saved designsDatabase + local backup
Connecting to saved designs…
Cloud designs are shared within the selected factory. Previous browser designs are recoverable only from the browser/site where they were saved. Export JSON for a separate backup.
05 — Dimensioned drawing
FINISHED CASTING · Height in inches · Outside Ø in inches · Not to printed scale
Interactive 3D casting
360° drag to rotate
ROTATE 0° · TILT 0°
↔ Drag: rotate · ↕ Drag: tilt · Scroll: zoom
Studio spotlights

Move the light sliders to reveal the shoulder, belly and rim curves. Lighting changes affect the 3D preview only—not the casting dimensions.

Brass colour is a preview finish; the orientation stripe is not a cast feature.

Design summaryInches
Bottom outside Ø—
Top outside Ø—
Overall height—
Nominal wall—

Calculated metal volume: —

PRELIMINARY — Not a released foundry manufacturing drawing.
For casting, not sheet-metal fabrication. Shape sketches show approximate hollow geometry and do not define a production core or mould. Before pouring metal, the foundry must confirm actual inside-wall profile, metal shrinkage, machining allowances, fillets, draft, cores, gating/risers, distortion and tolerances. Outside profiles interpolate the measurement stations; measurements govern over displayed geometry.
Green Lanka factory aerial photograph
GREEN LANKA GROUP · FACTORY DASHBOARD

Green Lanka Tea Factory

Monthly factory operations at a glance

Green Lanka

Monthly Operations Summary

Loading factory overview…
🍃Made Tea This Month—kg · production records
↗Dispatched Net This Month—kg · official invoice incl. samples
▣Dispatched Bags—Completed dispatches this month
🚚Completed Dispatches—Consignments this month
♧Green Leaf This Month—kg · manufacturing records
%Net Outturn—Made tea ÷ green leaf
◷Undispatched Invoices—Current open balance · all dates
₨Receipts This Month—Contract + monthly VAT receipts · Rs.

Monthly Dispatch Summary

Completed only · official invoice quantities
Loading dispatch totals…
Loading dispatches…

Made Tea Trend

Six months ending with selected month

Recent Factory Operations

Production and dispatch records for the selected factory
Loading recent records…
ATTENDANCE & PAYROLL

Attendance Dashboard

Raw Hikvision punches stay unchanged. Daily attendance and payroll are calculated separately.

Daily report · Monthly editable register · Print / PDF
Payroll Employees0
Present Days0
Missing Checks0
OT Hours0.00
ConnectorNo sync

Monthly Attendance Summary

Select a month.

EmployeeStaff DepartmentEmploymentExpectedPresentPaid LeaveNo PayMissingWorked HrsOT Hrs
No attendance loaded.

Daily Attendance

Actual Hikvision punches are preserved. A punch inside the shift check-in window is credited as the exact shift start. OT is rounded down to the configured interval.

DateEmployeeShiftActual InPayroll InLast OutPunchesWorkedLate minEarly minOT hrsStatusAction
No daily attendance loaded.

Hikvision Connector Events

Employee events received from the connector for the selected month. Events marked Review are visible here but are not used for payroll until they qualify as an attendance punch.

Date / TimeEmployee No.EmployeeUseStatusVerifyMinorDevicePayroll Link
No connector employee events loaded.

Attendance Adjustment

Use only for approved leave, missing punch correction, no-pay or manual OT. Raw Hikvision events are never edited.

Payroll Employees

Assign each person to a staff department, Permanent/Casual employment type, salary method and OT rate profile. Face photos are synced from the Hikvision terminal by the Windows connector.

Loading employee count…
PhotoCodeEPF No.NICNameHikvisionDepartmentEmploymentShiftSalary TypeBasic / RateIncentiveOT ProfileStatusAction
No payroll employees.

Deleted Employees

Employees with saved payroll history are archived instead of destroying past payroll. You can restore an archived employee here.

CodeNameDepartmentDeletedAction
No deleted employees.

Employee Master

A clearer employee setup: link the Hikvision person, assign work details, then enter only the salary fields relevant to that employee. EPF/ETF comes automatically from Employment Type Setup.

No Photo
Hikvision Person Photo

Select the linked Hikvision person. Photos are synced from Person Management by the Windows connector.

1 · Employee & Hikvision

2 · Work Assignment

Select an employment type to see EPF / ETF eligibility and rates.

3 · Salary & Overtime

4 · Individual Sunday / Poya Rates & Attendance Bonus

Optional special rates for this employee. Leave a rate empty to use the Department + Employment Type rate configured in Setup. A saved individual rate takes priority only for this employee.

5 · Recurring Monthly Deductions

Welfare is configured per employee and deducted once each payroll month, regardless of worked Day Qty. The usual amount is Rs. 400.00; set 0.00 to disable. No existing employee is enrolled automatically.

6 · Bank Details

Permanent/Casual EPF and ETF rates are maintained once in Setup, not separately on every employee.
ATTENDANCE & PAYROLL · CONTRIBUTIONS

EPF C Form / ETF R4 Form

Create a single monthly contribution snapshot from saved Verified/Locked payroll. After Verify or Lock, reopen EPF C / ETF R4 automatically without loading payroll again. Follows your C and R4 A4 portrait print layouts.

Printed form details — registered company name, contact and remittance
DRAFTVerify once to freeze both EPF C and ETF R4. Lock when final. Admins may return a month to Draft for audited corrections; saved historic snapshots are retained.
Choose a month to check for an existing saved snapshot.
Load saved payroll to display contribution figures.
Draft contribution amounts are loaded once from saved Verified/Locked payroll runs, not attendance. Verify saves a permanent factory/month snapshot; Lock finalizes it. Both EPF C / ETF R4 and ETF TXT reuse this snapshot with no recalculation. An Admin can return a Verified/Locked month to Draft with a reason; this archives the old snapshot before corrections. Correct NIC/member numbers and employer registration before Verify. Confirm the receiving bank/ETF file specification before submission.
ATTENDANCE & PAYROLL · MONTHLY CONSOLIDATION

Monthly Employee Salary Summary

All employees, grouped by payroll category and employment type. Read only from saved Verified / Locked payroll snapshots. Gross and net amounts match the underlying ledgers.

Select a factory and payroll month, then load the saved payroll.
#Employee No.Employee NameDepartmentEmploymentGross Salary (Rs.)Net Payable (Rs.)EPF 8% EmployeeEPF 12% EmployerTotal EPFETF 3%Total EPF + ETF
Load a month to view employee salary figures.

Amounts are taken from saved payroll values (not recalculated from attendance). EPF/ETF appear as saved and may be zero for Casual or non-eligible employees. If any payroll scope is still Draft, the summary is marked incomplete.

ATTENDANCE & PAYROLL

Opening Balances

Enter Previous Debt and Coin B/F for existing employees, including Office Staff. Factory-authorised administrators and Office Clerks may edit while the employee’s payroll scope remains Draft.

Select an employee to enter opening balances.

Saved Opening Balances

Select Edit to change an existing employee's balance. Entries with zero amounts are also shown.

0 employees
Employee No.NameDepartmentPrevious DebtCoin B/FAction
Load balances to begin.
ATTENDANCE & PAYROLL

Advance Entry

Compact keyboard entry. After every save the cursor returns to Date. Press Enter on Date to move to Employee, then continue the entry.

-
?
Select employee

The Hikvision face photo appears here for confirmation.

Advance Entries - Selected Month

Every advance keeps its transaction date, employee, amount, user and timestamp in the payroll database.

DateEmployeeAmountNote
No advance entries.
ATTENDANCE & PAYROLL

Tea Entry

Compact tea deduction entry. After every save the cursor returns to Date. Tea Item Master rate calculates the deduction automatically.

-
?
Select employee

Face photo is shown before the entry is saved.

Tea Entries - Selected Month

0 packets · Rs. 0.00

DateEmployeeTea ItemPacketsRateAmount
No tea entries.
ATTENDANCE & PAYROLL

Employee Loan

Enter the loan once. Its normal installment is calculated and automatically deducted from each eligible future Daily-Wage Payroll month until the balance is cleared. Older repayments are preserved.

-
?
Select employee

Confirm the employee by face before creating the loan.

Loan Register

Principal, installment plan and remaining balance.

EmployeeLoan DateStartPrincipalInstallmentsNormal Inst.BalanceStatus
No employee loans.

Loan Installments - Selected Month

DateEmployeeAmountNote
No loan installments.
ATTENDANCE & PAYROLL

Other Deductions

Compact entry for deductions other than Advance, Tea or Loan. Date and reason are mandatory; after Save the cursor returns to Date.

-
?
Select employee

Confirm the employee before saving the deduction.

Other Deductions - Selected Month

DateEmployeeReasonAmount
No other deductions.
ATTENDANCE & PAYROLL

Sunday Ledger

Sunday and Poya day payments for Department + Employment scopes configured to pay separately from Transport / Travelling Incentive.

Departments
Factory setting

Sunday Ledger is loading…

Employees0
Sunday Qty0.00
Poya Qty0.00
Total PaymentRs. 0.00
Employee No.EmployeeSunday QtyPoya QtyOT HrsSunday PayPoya PayTotal PaymentSignature
Select the month and click Load Sunday Ledger.
Admin changes save directly. Other users submit proposed changes for Admin verification.
ATTENDANCE & PAYROLL

Attendance Reports & Monthly Register

Filter by month, department and employment type. Employee rows are always ordered by employee number.

Daily Attendance Report

Select a date.

Employee No.EmployeeDepartmentEmploymentShiftActual InPayroll InOutDay QtyOT QtyStatus
No daily attendance report loaded.

Editable Monthly Attendance Register

Each square shows In, Out, Day Qty and OT Qty. Click a square to edit the approved payroll values.

Manual Attendance Entry

Choose the date first, search an employee, then use Enter for fast In → Out → Calculate → Save entry.

READY
Day Qty—OT Hrs—Select date and employee.
Keyboard: Date → Employee Search → Enter → In Time → Enter → Out Time → Enter calculates Day Qty/OT. Press Enter again to save. After saving, the date stays selected and focus returns to Employee Search.
ATTENDANCE & PAYROLL

Attendance Verification

Admin approval of pending Monthly Register, Daily Attendance and Manual Attendance changes. Original punch records are preserved.

Submit Attendance Correction

Office Clerk and other authorized attendance users may request a correction. Admin approval is required before it takes effect.
Choose a factory to see requests.
For non-admin users, proposed changes appear here without altering attendance. The Admin can approve or reject each change. Verified or Locked scopes must be returned to Draft first. Request history cannot be deleted from this page.
Employee / DateProposed Change & ReasonStatusBefore / AfterAdmin Review
Select a factory and click Refresh Requests.

Attendance / Payroll Setup

Admin-only device token, shifts, staff departments, OT rate profiles and holidays.

Hikvision Connector

SerialDeviceFactoryLast Event SyncPeople SyncStatus
No registered attendance device.

Shift Master

Example: 07:30 start with 10 minutes before/after means a first punch from 07:20 through 07:40 is credited as exactly 07:30. OT starts after shift end and is rounded down to complete intervals. Day Qty 1.00 requires 8 working hours plus the shift break minutes. Day Qty 0.50 uses the Half-Day Minimum Hours configured for that shift (default 4.00 hours).

ShiftTimeCheck-in RuleBreakHoursHalf DayEarly GraceOT RuleDaysAction
No shifts.

Staff Department Master

Create factory staff groups such as Workers, Staff, Driver, Security and any other department you need.

DepartmentOrderStatusAction
No staff departments.

Employment Type · EPF / ETF

Permanent employees are statutory-eligible. Set the Employee EPF, Employer EPF and ETF percentages here once for the whole factory. Casual employees are automatically excluded from EPF/ETF.

Permanent: eligible for EPF/ETF. Casual: not eligible; all statutory rates are forced to 0.
Employment TypeEPF / ETF EligibilityEmployee EPF %Employer EPF %ETF %StatusAction
Run the v6.41.89 SQL migration to create employment type rates.

OT Rate Profiles

Configure separate hourly OT rates for normal workdays, off days/Sundays and holidays. Assign a profile to each employee.

ProfileNormal / HrOff Day / HrHoliday / HrStatusAction
No OT rate profiles.

Holiday Calendar

DateHolidayPaidAction
No holidays.
GREEN LANKA TEA FACTORY

Agent Transport Summary

Monthly transport calculation by route and agent. Total = Factory Incentive + Sup. Trans. Chg. + Fertilizer Transport.

Total Kilograms0.00 kg
Factory IncentiveRs. 0.00
Sup. Trans. Chg.Rs. 0.00
Fertilizer TransportRs. 0.00
TotalRs. 0.00

Monthly Agent Transport

No saved month selected.

RouteAgentNormal kgSuper kgTotal kgAgent kgRuleRateFactory IncentiveSup. Trans. Chg.Fertilizer TransportTotal
No Agent Transport month saved yet.
MONTHLY PDF IMPORT

Upload Route Incentive Sheet

Reads Route, Normal kg, Super kg, Total Net kg, the source incentive and Sup. Trans. Chg. from the Green Lanka monthly sheet. Rotated PDF rows are reconstructed and reconciled before any data is accepted. Factory Incentive is then recalculated from Master Data.

Green Lanka only
Choose the monthly Agent Incentive PDF and press Read PDF.
FERTILIZER TRANSPORT

Upload Fertilizer Transport Report

Reads the Green Lanka Listing of Deductions/Issues PDF. The importer uses each Total Recovery : Route amount as that route's Fertilizer Transport deduction and adds it to the saved monthly Agent Transport calculation.

PDF import ready
Monthly formula:

Factory Incentive + Sup. Trans. Chg. + Fertilizer Transport = Total. Routes not listed in the uploaded fertilizer report are set to Rs. 0.00 for that month. The report grand total must reconcile before it can be applied.

Choose the fertilizer report PDF and press Read PDF.
AGENT SUMMARY

Agent Summary

Choose an Agent and month to see OFFICIAL Payment Ledger Net Pay; archived account entries and receipts are shown separately below.

Official Monthly Payment Ledger — Agent Reconciliation

The figures here come from the exact saved Verified/Locked snapshot or Draft payroll preview, NOT old payment receipts. Use this when comparing Agent Summary with the Monthly Payment Ledger.

Choose an Agent and click Load Official Month.
Historical savings register: select Agent and Load Official Month.

For v6.44.15 and later, use Agent Payment Ledger for the official monthly Net Pay, Debt C/F and Savings Balance. The account entries below remain historical and do not record new payment-slip printing.

Archived Non-Payment Account Activity — click to expand

Current & Previous Months — Official Payment Ledger

Uses Draft ledger calculations or frozen monthly snapshots. Historical Payment / Settlement is not a deduction or brought-forward payable balance. Payment Made remains a separate deduction.

Select an Agent to view monthly summaries.

Account Ledger

Select an agent.

AGENT TRANSPORT

Agent Deductions

Payroll-style entry. Transaction Date and Effective Month are recorded separately; Effective Month determines the agent-account period.

Effective-month accounting
Draft — deductions editable

Enter Deduction

Deduction subcategory

Agent Account Summary

Choose an agentEffective Month: —
Official Debt B/F (owed to factory)Rs. 0.00
Transport Earnings — Selected MonthRs. 0.00
Other Credits — Selected MonthRs. 0.00
Existing Deductions — Selected MonthRs. 0.00
Official Net Pay — Selected MonthRs. 0.00
Estimated Net Pay After Proposed DeductionRs. 0.00

Deduction breakdown — Selected Month

Official Net Pay is the printable payable amount. Only Debt C/F and Coin C/F carry forward; previously issued historical settlements are not deducted. Proposed figures are estimates until saved and recalculated in the Payment Ledger.

Loan Installments · Skip / Partial

Select Agent and Effective Month above. Shows outstanding scheduled installments from that month onward; admin actions affect this entire loan's future schedule.

Only a Draft month may be adjusted. Run the v6.44.93 Agent Loan SQL before use.

Due MonthLoan / InstallmentOpening PrincipalPrincipalInterestDeductionRemainingAction
Select an agent to view loan schedules.

Skip / Partial History

MonthActionOld DuePaidReasonRecorded At
No actions recorded.

Saved Deductions — Effective Month

Shows only the selected Agent and Effective Month. Edit manual deductions; delete whole loan schedules together.

Txn DateEffective MonthAgentTypeDetailsAmountAction
No deductions loaded.
AGENT TRANSPORT · PARTIAL PAYMENTS

Payment Made

Record actual payments already given to an agent, separately from Advance. The amount reduces this month's payable Net Pay. Print All Payment Slips never records a payment.

DRAFT

Run the v6.44.17 and v6.44.22 SQL migrations before recording Payment Made.

Record Payment Made

Only allowed while the entire Effective Month ledger is Draft. Existing payment receipts are not changed or duplicated.

Available to pay: Rs. 0.00

Available amount is based on the live Draft Payment Ledger after all deductions and earlier payments.

Payment Made History

Includes reversed transactions for audit. Reversal requires a reason and the entire month in Draft.

DateAgentMethodReference / NotesPaid (Rs.)StatusAction
Load an Effective Month to see payments.
AGENT TRANSPORT · MONTHLY PAYROLL

Agent Payment Ledger

One ledger for every Agent in Agent Master, even with zero KG and zero Net Pay. Verify and Lock the entire ledger once. Net Pay is the printable payment amount; printing does not post any payment.

DRAFT

Run v6.44.15 SQL, then v6.44.16 Agent List SQL before loading Monthly Agent Payment Ledger.

Coin carry is configured for the selected factory and Effective Month. New Draft months default to Rs. 100. Save before Verify; Verified/Locked months cannot be edited. Coin C/F transfers to Coin B/F only after the previous month is Locked.

Coin C/F for this month: Rs. 0.00 · Only Net Pay is printed as cash payable.

Agents0
Gross Pay0.00
Total Deductions0.00
NET PAY0.00

Monthly Agent Payment Ledger

Agents are rows. Each earning and deduction has its own column; totals appear at the bottom. Historical receipts remain in audit history and do not reduce Draft Net Pay.

Monthly Savings Cut Check

Load the Agent Ledger to compare expected and saved Savings Cut amounts by current Agent Group.

AgentRoute(s)Monthly KGSavings Rate / KGExpected CutSaved CutStatus
Load the Ledger.

For renamed agents such as Samantha on Umagathenna, first verify the Savings Rate in Agent Transport → Master Data → Agent Account Master. Only Draft months can be reconciled; saved Verified/Locked snapshots and receipts are never modified.

Historical Savings Cut — March / April / May 2026

These amounts were ALREADY withheld before the Agent Transport system began in June. Record them as savings held, NOT as a new deduction, payment, or release. June-onward savings are retained unchanged.

A separate historical savings record. Frozen Verified/Locked payment snapshots are never overwritten. Amounts will be included in Draft savings balances and available for subsequent legitimate Savings Release.

Historical Savings Entries — Audit

Original MonthAgentSavings Added (Rs.)Reference / NotesStatus / Action
Load monthly ledger.

Savings Held — Reconciled Balance as of Selected Ledger Month

Includes March–May imports, posted savings cuts through this month and any actual Savings Releases. For Verified/Locked months, this is a separate updated savings register; frozen payment figures do not change.

AgentMarchAprilMayImported TotalRecorded CutsReleasedSavings Held
Load monthly ledger.

Release Previous Savings

Add part of an Agent's savings deducted in earlier months to this month's Gross Pay. The Agent appears even with zero current-month KG. Cannot release more than the held prior savings.

AgentReleased (Rs.)NoteAction
No releases.
AGENT TRANSPORT

Payment — Agent Balance

Verify the selected Agent Effective Month, pay all or part of the available balance, and issue an official receipt with its additions and deductions. Lock closes further payments.

Issue Balance Payment

Balance Statement / Debt Receipt

For agents with a debit balance, or whenever no cash is paid. Prints the verified monthly account details and remaining debt; does not post a payment or clear debt.

Verified Agent Account

Status: DRAFT
Previous Balance B/F0.00
Monthly Earnings / Additions0.00
Monthly Deductions (historical)0.00
Balance Available0.00
Historical Balance After Payment0.00

Verify the Agent month before issuing a receipt.

Issued Receipts & Balance Statements

Paid receipts and no-payment balance statements are permanent. Reprint any time, including after Lock.

Receipt No.DateMethod / TypePaidBalance C/FAction
No payment receipts.
AGENT TRANSPORT

Agent Reports

Effective-month Agent Route reports: deductions by type, or outstanding debt by agent. Factory Lines are excluded from agent financial reports.

A4 PDF

Deductions — Effective Month / Type

Filter the saved deductions by month, type, agent and optional transaction-date range.

Records0
AdvanceRs. 0.00
LoanRs. 0.00
TeaRs. 0.00
DieselRs. 0.00
OtherRs. 0.00
Grand TotalRs. 0.00

Totals by Deduction Type

TypeEntriesTotal (Rs.)
Load the report to see type-wise totals.
Transaction DateEffective MonthAgentTypeReference / DetailsAmount
Choose filters and load the report.
ADMIN MASTER DATA

Agent Transport Master

Maintain kilogram ranges, map each Route to its Agent, identify Factory Lines, and choose Range Based, Special Rate or No Incentive.

Admin

Range Values

From kgTo kgRate / kg

Route & Agent Master

Combined route kilograms:

Select the same Agent for all routes belonging to that agent. Their kilograms are added only to select the range rate; each Route keeps its own kilograms. Mark a Route as Factory Line when the factory runs the line; Factory Incentive is then always 0.00.

RouteAgentLine TypeRuleSpecial Rate
Default range values in this version:

1–4,999 kg = Rs. 10.50/kg · 5,000–9,999 kg = Rs. 11.00/kg · 10,000–14,999 kg = Rs. 12.00/kg. Add or edit further ranges here. Routes marked Special use their own rate; routes marked No Incentive receive 0.00. Factory Lines always receive 0.00 Factory Incentive.

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. Green Lanka: only Orthodox dispatches are deducted; CTC dispatches are excluded.

Financial year: April 1 – March 31

Dispatch kilograms are now read directly from completed Tea Dispatch records. Production is entered from the Production category. Dispatch kilograms continue to come automatically from completed Tea Dispatch records; Stock → Entry is used for Return Tea, Local Sale, Gratis, refuse outgoings and permitted adjustments.

Selected Month Summary

Month-to-date figures for the selected month. Verification and locking are performed here for the whole month.

Pending verification

A locked month cannot be changed until an administrator unlocks it.

Financial Year Summary

Separate to-date totals for the selected financial year.

Opening Stock

Admin only

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 RefuseActions

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

Applied stock-taking rows are frozen at the Expected Stock, Physical Stock and Excess/Loss values saved when the adjustment was added. Later ledger activity will not recalculate historical applied sessions.

Physical Stock DateFinal Green Leaf DateSessionExpected Stock kgPhysical Stock kgExcess / Loss kgVariance %VerificationAdmin Action
FACTORY PRODUCTION

Daily Production Entry

Enter the physical production figures once. Fired Tea, Withered Leaf %, out-turn and firewood cost are calculated automatically.

Keyboard: press Enter to move to the next production entry field; Enter on Firewood for Firing saves the entry.

Fired Tea = 1st Dhools + 2nd Dhools + Big Bulk
Saving this entry automatically creates separate Withering and Firing firewood issues. Their combined yards are deducted from Firewood stock; do not enter the same issue again in Firewood.

Recent Production Entries

Firewood cost uses the current weighted average firewood intake rate available to the app.

DateGreen LeafWitheredWithered %1st Dhools2nd DhoolsBig BulkFired TeaMade TeaRefuseFW WitheringFW FiringFW TotalFW CostAction

Entry

Enter returned tea and stock outgoings. Daily Production has moved to the separate Production category. Dispatch kilograms are read automatically from Tea Dispatch.

Stock data entry

Production is entered only from the Production category. Dispatch is automatic from completed Tea Dispatch records; Local Sale and Gratis remain separate Stock entries.

Return Tea Entry

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

Stock in

Outgoing Entry

Dispatch is read directly from Tea Dispatch. Enter only the additional Stock outgoings shown below.

Direct Dispatch source
FACTORY STOCK CONTROL

Stock Balancing

Maintain Fertilizer in bags, Tea Packets in packets, Diesel in liters and Paper Sacks in sacks. Every movement is factory-wise.

Stock Movement

Use this for opening stock, receipts, issues and corrections for the four stock categories.

Pump Diesel for Vehicle

This entry automatically deducts the pumped liters from Diesel stock.

3 photos required
Vehicle Photo *
Odometer Photo *
Pump Photo *

Stock Movement History

Running stock movements for the selected factory.

DateStock ItemMovementQuantityReferenceRemarksSourceAction

Diesel Pumping History

Vehicle, odometer and three-photo evidence for every diesel issue.

Date / TimeVehicleOdometerLitersVehicle PhotoOdometer PhotoPump PhotoRemarks

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) Optional. If a photo upload fails, you can retry or explicitly save the weighing entry without a photo.

Current Session Summary

GradeMarkGross kgBox Deduction kgNet Tea kgRefuse kgFinal Stock kgValuationValueAction
STOCK TAKING MANAGEMENT SUMMARY

Stock Summary

Last stock-taking position, financial-year main figures and month-wise stock movement with the adjusted out-turn after actual stock adjustment.

Last Stock Taking - Main Stats

Latest physical stock-taking session in the selected financial year. Applied sessions use the frozen reconciliation values saved when the adjustment was added.

Financial Year Main Stats

Main made-tea stock and adjusted production position for the selected financial year.

Month-wise Stock Summary + Monthly Out-turn After Actual Stock Adjustment

The stock-taking excess/loss is shown when it was applied. For adjusted out-turn, that variance is allocated across the production period by each month’s green-leaf share.

Month Starting Balance kg Green Leaf kg Recorded Made Tea kg Stock Taking Excess / Loss kg Allocated Adj. for Out-turn kg Adjusted Made Tea kg Adjusted Out-turn % Dispatch kg Local Sale kg Gratis kg Final Balance kg

Stock-taking Reconciliation History

Physical stock compared with expected stock. Applied historical sessions remain frozen.

Physical Stock DateFinal Green Leaf DateSessionExpected Stock kgPhysical Stock kgExcess / Loss kgVariance %VerificationAdjustment

Stock Taking Reports

Simple A4 reports with larger figures and grade comparisons. Photo report uses compressed images to keep the PDF smaller.

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.

No image selected

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

Route Leaf CSV Generator

Generate and save one complete calendar month for Gomadiya, Pattigala and Horagala. Export any required date range later without changing the saved month.

Not saved
Monthly rules: Customer monthly Net Kilos cannot exceed the selected cap (default 140 kg). The same customer must have at least 6 calendar days between supply dates. Excluded receiving days never receive generated rows.
Output columns: Customer No · Date · Bags · Gross Weight · Bag Weight · Water Deduction · Course Leaf Deduction · Net Weight · Normal Flag (1).

Exclude Receiving Days for the Month

0 excluded

Tick any date that must not contain a supply. The generated month will remain fixed after Save & Lock.

Adjust Daily Route Kilos

Fix the exact net kg on selected dates. The remaining kg are redistributed across dates that have not been fixed, while preserving each route's full-month total and customer limits.

Month total unchanged
Select a generated route to edit its daily net kilograms.
DateOriginal kgCurrent kgFixed Net kgAdjustment
Generate or load a month to edit daily totals.

Leave “Fixed Net kg” empty to let that date adjust automatically. Fixed dates will stay exactly as entered. Changes are kept with the saved month when you click Save & Lock Month. A locked month requires Admin Unlock first. Dates without generated supply rows cannot be given a new positive total here.

Export Saved / Generated Data

This range only filters the CSV export. It does not regenerate or alter the full-month data.

Separate export range
No CSV generated or loaded yet.
Customer NoDateBagsGross WeightBag WeightWater DeductionCourse Leaf DeductionNet WeightNormal
Generate or load a month to preview its CSV rows.

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

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 Public Auction or Private Sale tax invoices issued by the factory to tea buyers. Select the sale type first so matching is restricted to the correct Seller’s Contracts.

Saved Seller Tax Invoices

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

DateFactoryTax InvoiceSale TypeBuyer / TINSeller ContractLotsTaxable ValueVATTotalMatch StatusPDFActions

Quarterly VAT Summary

Three-month VAT control report for one factory, calculated from saved Output VAT, allowable Input VAT, sales and purchase credit/debit notes, and VAT payments. Uses the same month allocation rules as the Monthly VAT Working Paper.

Select a factory, year and quarter to load the three monthly totals. Nothing is saved or changed by this report.

Month-by-Month VAT Summary

Amounts in Sri Lankan Rupees (Rs.). Credit Notes are deducted; Debit Notes are added. Negative VAT position means VAT credit. Grand Total adds the three months, without previous-period balances.

VAT ComponentMonth 1Month 2Month 3Grand Total
Select a factory and quarter, then click Prepare Quarterly VAT Summary.

Reconciliation and Coverage

No quarter loaded. Sale Contract VAT is counted by sale date; other output by transaction date; purchases and tax notes by effective VAT month; payments by VAT period. Seller Tax Invoices are reference documents and are not counted again.

Quarterly VAT Schedules

Prepare and review IRD Schedules 01, 02 and 04 from the selected factory’s saved VAT records.

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.
IRD / VAT CONTROL · READ ONLY

RAMIS ↔ Tea Sales Reconciliation

Cross-check every Web API reported tea-sale invoice in the RAMIS Schedule 1 CSV against your factory's saved Seller Tax Invoices.

1 — RAMIS CSV & Reconciliation Scope

Imports the exact columns in the RAMIS export, including purchaser TIN, invoice number/date, sale description, taxable value, VAT, submission mode and created date. Quarter is detected automatically from the file's Tax Period Code (e.g. 2630 = Q3 2026). Only signed-in factory permissions apply.

Choose the RAMIS Schedule 1 CSV export, then compare it against saved factory invoices.

2 — Summary & Exceptions

Invoice-by-invoice reconciliation
Result / DifferencesTax Invoice No.RAMIS DateFactory DateRAMIS TINFactory TINPurchaserSale DescriptionRAMIS ValueFactory ValueRAMIS VATFactory VATMode / API Created
Import the RAMIS CSV and compare it with saved factory tax invoices.

This report compares an exported RAMIS Schedule 1 snapshot with saved Seller Tax Invoices in the app; it does not contact or modify IRD, RAMIS or broker Web APIs. A row present in only one source is flagged for investigation, not automatically treated as an incorrect tax return. RAMIS serial, created date and submission mode are displayed as source metadata, not assumed to exist in the factory database. CSV contents remain in this browser tab and are never stored by this feature.

VAT Proceed

Monthly VAT reconciliation. Sales explain the expected amount; receipts belong to the selected month, not to individual sales.

Choose a factory and month. Monthly VAT receipts are separate from individual sales.

1. VAT expected from sales

Bank Guarantee and Non-Bank Guarantee VAT are shown separately for each sale and in the expected monthly totals. Receipts are not allocated to either category.

Choose a month to view the relevant sales.

2. Monthly VAT reconciliation

One combined VAT expected, received and balance for the entire selected sale month. No guarantee-type allocation is needed.

3. Record VAT received

Record against the whole selected sale month. No sale or Seller’s Contract is required, even when payment arrives in a later month.

Shows the remaining VAT for the whole month, regardless of guarantee type.

4. Monthly VAT receipt history

Edit or Delete new monthly VAT receipts here. Earlier contract-linked receipts remain editable from Bank Receipts, preserving their original contract links. All corrections are audited.

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 or Delete to correct saved receipts. Deleting requires a reason, retains an audit snapshot, and is blocked for advance-allocated or bank-reconciled receipts until unlinked.

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 CONTROL CENTRE

VAT Management

Manage VAT separately from Tea Sale Proceeds. Work through Output VAT, Input VAT / Purchase Bills, credit and debit notes, payments, then prepare the monthly VAT working paper and use the Quarterly VAT Schedules and RAMIS Reconciliation tabs.

Working factorySelected factoryChange the factory from the selector at the top.
1Output VAT
2Input VAT
3Adjustments
4Payments
5Summary

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 — Selected Factory & Month Only

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 GROUP · INTER-FACTORY PROCUREMENT

Factory Purchase Orders & Incoming VAT Invoices

Other factories request stock from Green Lanka Central Stores. Central Stores approves the PO and creates the official VAT invoice, which deducts stock through the existing invoice system.

Submit a Purchase Order for your assigned factory. Your order does not change stock or VAT until Central Stores posts its invoice. Confirm physical receipt after delivery.

New Purchase Order to Central Stores

Items and estimated prices come from the Central Stores item master.

ItemQtyEst. Unit RateTaxableVAT
Add items.
Rs. 0.00

Factory Orders & VAT Invoice Register

VAT shown here is from posted Central Stores invoices. It is not automatically duplicated as factory Input VAT.

PO / DateBuyer FactoryRequiredStatusItemsEst. TotalIssued VAT InvoiceActions
Loading orders…
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

Sales Control Centre

Manage acknowledgements, valuations, seller contracts, returns, reports and auction follow-up after operational dispatch preparation.

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

Sales 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
OPTIONAL HYBRID PREPARATION

Dispatch Plan · Bag Barcode Labels

Enter bag count and net weight per bag; total kilos are calculated automatically with the dispatch sample. No vehicle planning. Labels are 60 × 40 mm. Keep using existing Invoicing, Dispatch Assignment and Manual Weighing while this rollout is tested.

HYBRID · v6.44.37

Plan an Invoice

Next 10 Available Invoice Numbers

Click a number to use it in the plan. Green Lanka has separate Orthodox (1–1199) and CTC (1200–1400) sequences. Select the lowest unused numbers first, including gaps. Used official invoice numbers and non-void planned numbers are excluded.

Select factory and financial year.

Enter bag count and net weight per bag to calculate total including the sample.

Active Planned Invoices

0 invoices
InvoiceMark NameGradeBagsNet/Bag (kg)Total + Sample (kg)Label StatusActions
Open Dispatch Plan to load invoices.

Dispatched invoices automatically disappear from this active list, but remain in Invoicing, Dispatch Register and history. Plan printing first prints two copies of the original dispatch invoice label, then one barcode label per bag. Any change to invoice number, mark, grade, kilograms or bag totals requires printing every label again and confirming physical label replacement. Official invoices remain separate until saved in Invoicing.

Create Tea Invoice

Invoice numbers are unique within the factory financial year.

Financial year not selected
Fast EntryPress Enter to move to the next field.

Entry order: Selling Mark → Invoice Number → Grade → Packs → Sack → Net Weight → Manufacture Date → Valuation → Moisture → Sale Type → Save. Sample weight is calculated automatically from the grade.

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

Saved Invoices

Open invoices are shown by default. Use Status to review Assigned or Dispatched invoices; financial year, invoice order and sale type can be filtered independently.

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

Private Sales

Register private-sale invoices separately from the public auction workflow. Private Seller Contracts can now be uploaded here and feed Tea Sale Proceeds, VAT Output, deductions, outstanding balances and invoice history without entering acknowledgements, broker valuations, catalogue attempts, Sale +3, unsold, shutout or violation processing.

PRIVATE ONLY

Upload Private Seller Contract

Upload the broker Private Seller Contract once. The app extracts contract, invoice, buyer, VAT, price, proceeds, deductions and prompt date, then opens the review screen before anything is saved.

PDF → REVIEW → SAVE
VAT treatment
Buyer VAT from the private sale is included in VAT Output after the contract is confirmed. Broker VAT charged on deductions is stored as a broker deduction; claimable Input VAT still comes from the broker Tax Invoice because the Seller Contract itself is not a Tax Invoice.
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. Private Sale sample weight is manual and may be 0.000 when no sample is dispatched.

No document selected.

Private Sale Register

Private Seller Contract imports are linked here automatically when the matching invoice is marked Private Sale. Manual Private Sale entry remains available.

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.

PUBLIC DISPATCH

Create / Edit Public Dispatch Assignment

Public invoices are assigned only to their selected Public Sale Arrangement. Private invoices are handled separately below.

PUBLIC
PRIVATE DISPATCH

Create / Edit Private Dispatch Assignment

Private Sale invoices use a separate physical Dispatch Assignment. Sale access starts from Sale 39 and defaults to the current / next available sale week.

SALE 39+

Dispatch Register

Active assignments are shown by default. Completed dispatches are available from monthly history. Actions are arranged in dispatch workflow order.

ACTIVE DISPATCHES Open / loading assignments only

Removed Invoice History

Audit trail for invoices removed from Dispatch Assignment, including removals by another authorized user when a vehicle had no remaining space.

AUDITED
RemovedDispatchInvoiceReasonRemoved BySaved WeightsType
Loading removal history…

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 Acknowledgement — Reconcile

Upload once. Review only exceptions. Confirm without changing official dispatch data.

1 · Upload2 · Review3 · Confirm

Comparison includes current-sale dispatch assignments and eligible carried-forward lots. No missing invoice is created automatically.

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

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
INDEPENDENT SOURCE DOCUMENT

Broker Valuations

Upload the Broker Valuation whenever it arrives. An Acknowledgement is optional. The document is filed under its factory and sale first; Document Chain then compares it with any Acknowledgement and Seller Contract already available.

Independent upload

Upload Broker Valuation

Select the factory and sale to file the document. If an Acknowledgement already exists you may select it, but a difference never blocks saving; it becomes a Document Chain exception for review.

No broker valuation PDF preview loaded.

Saved Broker Valuations

Valuations are retained as independent source documents. Acknowledgement linkage is optional and may be attached later. Use Document Chain to review field-level differences.

SaleAcknowledgementPrinted DatePDFMarksInvoicesProjected ProceedsDispatchesActions
INDEPENDENT SALE OUTCOME DOCUMENT

Seller Contracts

Upload a Public Auction Seller Contract as soon as it is received, even when the Acknowledgement or Broker Valuation has not arrived. The contract is immediately available for Tea Sale Proceeds, VAT, deductions and settlements; Document Chain reconciles later documents when they appear.

Upload anytime

Upload / Edit Seller Contract

Upload the broker PDF, choose Public Auction or Private Sale, verify every extracted row and save only after review.

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
DOCUMENT CHAIN & LATE RECONCILIATION

Invoice Document Chain

Documents are saved independently. The chain compares only fields shared by the relevant stages and creates review exceptions instead of blocking uploads or silently changing source data.

Chain Filters

Each invoice and sale is evaluated separately. Seller Contracts and Broker Valuations may exist before or after the other documents.

Comparison rules: Dispatch ↔ Acknowledgement checks invoice identity, selling mark, grade, bags and weight per bag. Acknowledgement ↔ Valuation checks invoice, lot, mark, grade, bags and net kilos. Valuation ↔ Seller Contract checks invoice, lot, mark, grade, bags and net kilos. Price and buyer are not compared unless a future source legitimately contains them.
Sale Chains0
Complete0
Incomplete0
Review Required0
Resolved Exceptions0
Open Differences0

Document Chain Register

A missing document is INCOMPLETE, not invalid. A field difference is REVIEW REQUIRED. Resolutions never rewrite the original PDF extraction.

0 chains
Invoice / SaleFY / Mark / GradeDispatchAcknowledgementBroker ValuationSeller ContractOverallDifferencesAction
Open this tab to load the document chain.

Document Chain Exceptions

Shows exact field values from each source document. Only administrators can resolve or reopen an exception.

0 exceptions
Invoice / SaleLinkFieldSource ASource BStatusResolutionAction
No chain exceptions.
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

Reference only: scale weighment figures do not change official Dispatch, Stock, Sales, valuation, catalogue, report or SMS quantities. 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

Barcode Scanner · Optional Hybrid Input

60 × 40 mm labels
Existing manual Bag Sequence buttons and dropdown remain available at all times.

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

Only invoices and Seller Contract outcomes belonging to the selected financial year are loaded. Status priority is Sold → Unsold → Catalogued → Dispatched.

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.
60 MM × 40 MM · 1-UP

Sale & Dispatch Labels

Select a Sale Number to print the two approved sale summary labels — large Sale Number and Sale Details — together with the existing completed-dispatch invoice labels.

Select sale number

Sale Label Batch

Only completed Tea Dispatch records are included. Total Kilos is packed tea only: Bags × Net Weight per Bag. Dispatch sample weight is not added.

Selected Sale Summary Labels

Two separate 60 mm × 40 mm labels for the selected sale: a large Sale Number label and a Sale Details label. Number of Samples is the number of completed dispatch invoices in the selected sale.

Select sale number
Label 1 · Sale Number
Select a sale number.
Label 2 · Sale Details
Select a sale number.

Invoice Label Preview

Each preview below represents one physical 60 mm × 40 mm dispatch invoice label. Browser print opens one label per page.

0 selected
Select a sale number to load labels.
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.

Report source check loads on Search.
Dispatches0
Invoices0
Total Dispatched Bags0
Total Sold Bags0
Dispatched Net0.000 kg
Sold Net0.000 kg
Sold Gross (Incl. Current Sample)0.000 kg
Sold Gross (Incl. All Sample History)0.000 kg
Net Sales Average-
Gross Sale Average (Current)-
Gross Sale Average (Incl. All Samples)-
Broker Tax Invoice Deductions (Incl. VAT)0.00
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 Net kgSold Gross kg
(Incl. Current Sample)
Sold Gross kg
(Incl. Previous Unsold Samples)
Net Sales Avg
Rs./kg
Gross Sale Avg
Current
Gross Sale Avg
Incl. Unsold Samples
Unsold kgWithdrawn kgPending

Sale-wise Summary

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

SaleSelling DateDispatchesInvoicesDispatch Net kgCatalogue kgShutout / Violation kgSold Net kgSold Gross kg
(Incl. Current Sample)
Sold Gross kg
(Incl. Previous Unsold Samples)
Net Sales Avg
Rs./kg
Gross Sale Avg
Current
Gross Sale Avg
Incl. Unsold Samples
Unsold kgWithdrawn kgPendingFactory Valuation AvgReport

Broker Tax Invoice Deductions by Category

Uses only relevant saved Broker Tax Invoices. Seller Contract reference is matched first; otherwise the app matches Sale Number + Broker. Category amounts come from the explicit Broker Tax Invoice charge fields; VAT from the same matched tax invoices is included as its own category. The Broker Deductions total therefore follows the matched Broker Tax Invoice total including VAT.

Deduction CategoryBroker Tax InvoicesBrokersAmount% of Broker Deductions
Run Search to load category breakdown.

Uploaded Broker Tax Invoices — Deduction Reconciliation

Saved amounts are included in the report even when no SOLD lot has been linked. Unallocated amounts are not assigned to individual sale lots until the source evidence matches.

Source not loaded
Tax InvoiceBrokerSaleContract ReferenceReport MonthInvoice Total Incl. VATAllocated to SOLD LotsNot AllocatedStatus
Search to load saved Broker Tax Invoices.

Sale Factory Valuation

Uses completed dispatch invoices only. Factory Valuation is weighted using full-bag tea only; the separate sample weight is excluded. Every invoice must have a Factory Valuation.

Select one sale
Invoices-
Valuation Net (Excl. Sample)-
Valuation Amount-
Weighted Factory Average-
No.DispatchInvoiceSelling MarkGradePacksValuation Net kg
(Excl. Sample)
Factory Valuation Rs./kgValuation Amount Rs.
Select one sale to prepare the valuation report.

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. Sold Gross includes the Seller Contract sample weight. Net Sales Average = sold proceeds ÷ sold net kg; Gross Sale Average = sold proceeds ÷ sold gross kg.

FYDispatchSaleDateInvoiceSelling MarkGradePacksDispatch Net kgSold Net kgSold Gross kg
(Current Sample)
Sold Gross kg
(Incl. Previous Unsold Samples)
Net Sales Avg
Rs./kg
Gross Sale Avg
Current
Gross Sale Avg
Incl. Unsold Samples
BrokerLorryDriverAcknowledgementCatalogueCurrent Status

Sold Report

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

SaleSale DateSeller ContractLotInvoiceFYGradeBuyerOutcomeNet kgCurrent Sample kgPrior Unsold Sample kgGross kg
(Current Sample)
Gross kg
(Incl. Unsold Samples)
Net Sales Avg
Rs./kg
Gross Sale Avg
Current
Gross Sale Avg
Incl. Unsold Samples
Price / kgProceedsBuyer Return Status
MONTHLY DISPATCH BOOK

Dispatch Summary

Digital version of the factory dispatch summary register with separate Orthodox and CTC public-dispatch accounts plus Private Sale details. Completed Tea Dispatch invoices feed grade, invoice, bag and selling-mark quantities automatically; Private Sales come from the saved Private Sales register; Local Sale, Gratis, Stock and Refuse Tea figures come from the Stock ledger.

Select month

Summary Month

Only completed Tea Dispatch records are counted. “Previously” means the same financial year before the selected month; “To-Date” is financial-year-to-date through the selected month.

Public Dispatch Invoices0
Public Dispatch Bags0
Grand Tea Dispatch to Colombo0 kg
Local Sale (LTS)0 kg
Gratis0 kg
Private Sale Weight0 kg
Private Sale ValueRs. 0.00
Balance in Factory0 kg
ORTHODOX

Orthodox Grand Tea Despatched Account

Orthodox dispatches are kept completely separate from CTC. Inside each grade, the invoice number is shown above its kilograms. No. of Bags is the total Orthodox bags in that completed dispatch. Grand Tea kilograms use the official saved invoice dispatch quantity, including the official dispatch sample quantity. Scale/weighment readings are reference-only and are not used in this account.

0 bags · 0 kgNot calculated
Load a month to prepare the Orthodox register.
CTC

CTC Grand Tea Despatched Account

CTC dispatches are shown in their own register. Green Lanka follows the existing TC5 split rule: BP1 and selling marks containing CTC are treated as CTC; all other dispatch invoices remain Orthodox. Grand Tea kilograms use the official saved invoice dispatch quantity, including the official dispatch sample quantity. Scale/weighment readings are reference-only and are not used in this account.

0 bags · 0 kg
Load a month to prepare the CTC register.
PRIVATE SALE

Private Sale Details

Saved Private Sale records for the selected month. These are shown separately from public Colombo dispatches. Process is identified as Orthodox or CTC using the same rule as the dispatch registers; stock movement remains controlled by the Stock ledger so quantities are not double-counted.

0 bags · 0 kg
DateInvoiceProcessBagsGradeSelling MarkkgBuyerContract / RefPrice / kgSale Value
Load a month to show Private Sale details.

Factory Disposals — LTS / Gratis

The Stock ledger currently stores Local Sale and Gratis as factory totals without a CTC / Orthodox process tag, so these are shown once here instead of being duplicated into either register.

DateLTSGratisTotal

Summary

Monthly factory stock reconciliation.

Refuse Tea

Balance brought forward, collection and monthly outgoings.

Register Sign-off

Names are saved on this device and printed on the monthly register.

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}, {factory_valuation}, {valuation_summary}. 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.
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. Admins can securely set a new password for any selected user. No password-reset email or Forgot Password flow is used.

Factory & Category Access

Assign categories separately for each factory. A factory is available to the user only when at least one category is selected for that factory. Existing role and database policies remain the maximum permission level.

Email / Auth Status Name Role Factories Category Access Created / Last Sign-in Action
No users loaded.

VAT Management — Recent Audit Records

Admin-only. Server-recorded inserts, edits, deletions and supplier-match approvals; full before/after values stay in Supabase.

WhenUserFactoryRecord typeActionChanged fields

Trough & Dryer Temperature Monitoring

Live factory temperature data in Fahrenheit (°F). Hygrometer: dry- and wet-bulb; dryers: temperature. Blank cells indicate no reading in that upload.

Active Equipment0
Troughs0
Dryers0
Live Sensors (2 min)0 live

Waiting for temperature readings

Factory Temperature Table — All Troughs & Dryers

One table per factory. Each upload creates a row with one server-generated Upload Time. Eight trough slots (A–H), each Dry/Wet, and DryerA/DryerB in °F.

Database table: — · 0 uploads
Waiting for readings

Upload Time is generated by Supabase when the full factory-reading row arrives. No other time columns or sensor-times JSON are stored in the new factory tables. Previously stored legacy Celsius histories are preserved separately.

Individual Sensors & Equipment Diagnostics

Trough Hygrometers

Dry-bulb, wet-bulb and difference in °F.

TroughDry °FWet °FDry − WetLast ReadingStatusConfigure
No trough readings loaded.

Dryer Temperature

Each dryer is independent, including factories with two dryers.

DryerTemperature °FLast ReadingStatusConfigure
No dryer readings loaded.

Sensor History Export

Download earlier per-sensor history in °F, or use the wide factory-table CSV above. Device upload tokens are issued using the equipment settings.

Upload path: Supabase RPC glg_hygrometer_upload_v64473. Send one factory-wide JSON object in °F; the database adds the single uploaded_at timestamp. Legacy Arduino Test and sensor readings remain stored separately.

Latest Test Value -
Last Received -
Rows Loaded 0
Supabase Status Waiting for Data

Arduino → Supabase Test

Reads the latest data from the three-column arduino_test table.

Recent Test Data

ID Test Value Received At
No Arduino test data loaded.
Timer Devices0
Online Now0
Running / Alarm0
SD Rows Pending0
Combined History0

Timer Monitoring

Live ESP32 status, Supabase events, completed runs and historical records recovered from each timer SD card.

Live Timer Status

Online = heartbeat received within the last 15 minutes (Rev K low-I/O heartbeat).
No timer devices loaded.

SD Card Sync Status

Existing /timer_log_v2.csv remains on the SD card and is never deleted by sync.
DeviceFactory / RollerSD RowsSyncedPendingProgressLast Heartbeat
No SD sync status loaded.

Timer Runs

Current and historical runs created from live timer events.
RunDeviceFactory / RollerProgramStartEndStatusLast Event
No timer runs loaded.

Combined Event History

Live events plus unmatched SD history. A live event also found on SD is labelled LIVE + SD instead of being counted twice.
TimeSourceDeviceFactory / RollerProgramIntervalEventRemaining
No timer events loaded.

Take Photo

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