Entity: Houzs Century Sdn Bhd
Derivation Rules
Glass-box configuration. Values here drive calculated columns on every report.
| Key | Display Name | Type | Value | Applies To | Notes | Last Updated | |
|---|---|---|---|---|---|---|---|
| GL_590_SKIP_DE_DESC | Skip GL 590-0000 when DE Acc Desc equals | FORMULA | CUSTOMER | ACTUAL_PL | Transport Income (590-0000) excludes rows where DE Acc Desc is CUSTOMER (Apps Script parseGL special case). | 2026-06-02 06:15:06 | |
| SEP_2025_OPENING_STOCK_MYR | Opening Stock seed (Sep 2025) | AMOUNT | 2038919.62 | ACTUAL_PL | First-month opening stock before any Closing Stock snapshot exists. From Apps Script SEP_OPENING_STOCK. | 2026-06-02 06:15:06 | |
| MERCHANT_FEE_PCT | Merchant Fee % | PCT | 2.00% | PERFORMANCE_PL | Credit card merchant fee applied to event sales (default 2%). | 2026-06-02 06:15:06 | |
| NP_FORMULA | Net Profit formula | FORMULA | sales - cost - rental - transport - set_up - commission - merchant_fee - transport_absorb | PERFORMANCE_PL | Used by Performance P&L to compute NP column. | 2026-06-02 06:15:06 | |
| SPONSORSHIP_PCT | Sponsorship % (AKEMI cost) | PCT | 20.00% | PERFORMANCE_PL | Sponsorship = AKEMI mattress/sofa cost x 20%. | 2026-06-02 08:10:17 | |
| TERMINAL_INT_PCT | Terminal Interest % | PCT | 2.00% | PERFORMANCE_PL | Terminal interest = event sales x 2%. | 2026-06-02 08:10:17 | |
| TRANSPORT_ABSORB_PCT | Transport Absorb % | PCT | 4.00% | PERFORMANCE_PL | Transport cost allocated as % of sales (default 4%). | 2026-06-02 06:15:06 |