G Gaia

Switch factory

CYTO-11 — Balakong Jaya CTSB CYTO-29 CTSB CYTOWELL-54 — Taming Jaya PIC/S CTWSB CYTOCNGZ-602 — Guangzhou CTCNGZ

Only factories you are granted appear here (Filament tenant menu).

Leo Lim

leo@navi.my · Owner / Admin

Profile settings Change password

Theme

Sign out
RetailSellR&DMakeBuyStockPlanItemsGMPAdminInsights
Sales CRM Shipments Customers Price lists Returns
← Retail sales / July consolidation (preview)

July 2026 consolidated summary

NVMSB · B2C retail · one consolidated e-invoice
Open — posts at month end consolidation_runs · preview
One consolidated summary → one consolidated e-invoice: B2C retail sales are e-invoiced once a month, not per sale. QBO stays the accounting system — Gaia never talks to MyInvois directly. B2B-flagged sales are excluded and export individually.
Period
01–31 Jul 2026
Entity
NVMSB (RS- series)
Sales in run
4 — so far, month still open
Gross B2C
544.20 MYR
Refund adjustments
−16.80 MYR
Net consolidated total
527.40 MYR
Excluded B2B
1 sale · 793.20 MYR
Previous run
June 2026 — Posted ✓ 01 Jul

Sales in this run

4 confirmed B2C sales · month(sold_at)=2026-07 · b2b_einvoice=false
Sale # Date Customer Items Payment Total
RS-26-041 2026-07-07 Aunty Mei Double Root Coffee ×24 @ 8.00 Cash 192.00 MYR
RS-26-040 2026-07-06 Kedai Pak Din Kopi Cik Abang ×36 @ 3.20 Transfer 115.20 MYR
RS-26-039 2026-07-05 Walk-in JuicyPop ×10 @ 4.50 Cash 45.00 MYR
RS-26-037 2026-07-02 Aunty Mei Double Root Coffee ×24 @ 8.00 Cash 192.00 MYR
Gross B2C 544.20 MYR

Adjustments — cash refunds this month

retail_returns · resolution = refund_cash · in period
Return # Date Customer Items Resolution Adjustment
RRET-26-012 2026-07-03 Kedai Pak Din Kopi Cik Abang 6 box · lot KCA-2603-08 Refund cash −16.80 MYR
RRET-26-014 Exchange — posts a zero-value replacement, no adjustment to the consolidation total.
Net consolidated e-invoice total 527.40 MYR

Excluded from this run

RS-26-038 Herbs & Health PJ 793.20 MYR B2B — own e-invoice exports individually to QBO → MyInvois

544.20 (B2C, consolidates) + 793.20 (B2B, individual) = 1,337.40 MYR — the “July open sales” total shown on the Retail sales list.

Previous runs

one run per month per entity
June 2026 Posted ✓ 01 Jul consolidated B2C e-invoice entered in QBO (includes RS-26-035, RS-26-036) amount —

Project Gaia — static mockup in Filament v3 idiom. No backend. Retail module; B2C retail sales are e-invoiced once a month as one consolidated summary. QBO stays the accounting system of record — Gaia never talks to MyInvois directly. Previewed mid-month; the run posts at month end.

Consolidation preview — field manifest

FieldFilament componentTypeSourceFK target
Run headerConsolidationRunResource ViewRecord + Infolistdocstored: consolidation_runs (period, entity, status open/posted, gross_b2c, refund_total, net_total, posted_at, qbo_ref) — one run per month per entitytenants
Sales in runRelationManager, derived membershipderived rowsretail_sales WHERE month(sold_at)=period AND b2b_einvoice=false AND confirmed — membership is computed, not stored, until the run postsretail_sales
AdjustmentsRelationManager, derivedderived rowsrefund_total from retail_returns WHERE resolution=refund_cash in period; exchanges post a zero-value replacement (no adjustment)retail_returns
Excluded B2BInfolist stripderivedretail_sales in period WHERE b2b_einvoice=true — exports individually to QBO/MyInvois, never joins the runretail_sales
Post actionAction (disabled until 31 Jul)enum + boolposting writes consolidation_runs.status=posted, posted_at, qbo_ref, and ONE consolidated B2C e-invoice in QBO → MyInvois; flips member sales' e-invoice badge to '{month} consolidated ✓'consolidation_runs

Engine notes

  • Posting flips every member sale's e-invoice badge from '→ July consolidated' to 'July consolidated ✓' and stamps the run's qbo_ref.
  • Refunds deduct from the gross: gross open incl. B2B is 1,337.40; the B2C consolidation nets 544.20 − 16.80 = 527.40. The 793.20 B2B sale is carried out separately.
  • One run per month per entity (NVMSB). Membership is a live query until the run posts; posting freezes it into the consolidation_runs row.
  • LHDN permits a consolidated B2C e-invoice — Gaia produces one summary per month. B2B-flagged customers (channel=both) always get a per-sale e-invoice instead and are excluded here.