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&DMakeBuyStockPlanItemsGMPOpsAdminInsights
Sales CRM Shipments Customers Price lists
← 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
final consolidated e-invoice total — retail returns removed, no refund adjustment
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 STC30 ×36 @ 3.20 Transfer 115.20 MYR
RS-26-039 2026-07-05 Coach Rizal STC30 ×15 @ 3.00 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

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.

Shopee channel sales are EXCLUDED — the marketplace issues its own e-invoice; Gaia posts them as a monthly channel entry (stock only).

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, posted_at, qbo_ref) — one run per month per entity; gross_b2c IS the e-invoice total (retail returns removed, no refund adjustment)tenants
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
Excluded B2BInfolist stripderivedretail_sales in period WHERE b2b_einvoice=true — exports individually to QBO/MyInvois, never joins the runretail_sales
Excluded — ShopeeInfolist stripderivedchannel_entries WHERE channel=shopee in period — a separate monthly stock-only posting (type channel_sale movements), no customer, never joins this run because Shopee issues its own e-invoicechannel_entries
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.
  • Gross B2C is the final consolidated total — retail returns are not supported in v1 (a confirmed sale is final): gross open incl. B2B is 1,337.40; the B2C consolidation is 544.20 and the 793.20 B2B sale is carried out separately.
  • Shopee (marketplace) sales never appear here: they post through a monthly channel_entries record instead — stock movement only (type channel_sale), because the marketplace issues its own e-invoice.
  • 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.