== STATIC: api/mcp_tools.php + api/mcp_tools_vb.php == PASS No inp_vdate (value date) anywhere PASS No raw inc_lineTotal outside uno_net_line_sql() PASS No "date <= ?" (drops the last day) — use < DATEADD(day,1,CAST(? AS date)) PASS Every vwInvoice/vwJV/vwStockListRpt query is company-scoped PASS uno_net_line_sql() applies global discount + POS VAT strip PASS uno_sales_types() = ['SA','SL','DN','CS','SD'] (SD = delivered invoice, UNO sums it with SA/SL) PASS movement-based on-hand rebuilds exclude YF/YX restatement documents PASS No COUNT/GROUP BY InvoiceCode (not unique) — use inp_id PASS FC conversion multiplies by inp_rateFC (UNO), never divides PASS No ThirdPartyName LIKE '%POS%'/'%Cash%' heuristics (use POS_ID / thirdparty_type) PASS GL helpers uno_pl_excl() + uno_ob_join() present == DB RECONCILIATION on company Golden Pharm == PASS sales curr 03: Σ net lines = Σ(inp_gtotal − inp_vat) lines 2034361.11 vs header 2034361.11 (0.0000%, 96 docs) PASS sales curr 02: Σ net lines = Σ(inp_gtotal − inp_vat) lines 10798186.34 vs header 10798186.34 (0.0000%, 77 docs) PASS purchases curr 03: Σ net lines = Σ(inp_gtotal − inp_vat) lines 1426263.61 vs header 1426263.61 (0.0000%, 57 docs) PASS purchases curr 02: Σ net lines = Σ(inp_gtotal − inp_vat) lines 7066007.40 vs header 7066007.40 (0.0000%, 73 docs) PASS sales_returns curr 02: Σ net lines = Σ(inp_gtotal − inp_vat) lines 1524500.15 vs header 1524500.15 (0.0000%, 5 docs) PASS sales_returns curr 03: Σ net lines = Σ(inp_gtotal − inp_vat) lines 212364.47 vs header 212364.47 (0.0000%, 15 docs) PASS purchase_returns curr 02: Σ net lines = Σ(inp_gtotal − inp_vat) lines 1000407.00 vs header 1000407.00 (0.0000%, 3 docs) PASS Single-day period from=to=2024-06-26 returns that day's invoices tool 4 vs DB 4 PASS GL single-day sales_summary from=to=2024-12-31 = direct vwJV 70/71 net tool 3596047439.50 vs GL 3596047439.50 PASS inventory_value = Σ qun_onhand × stk_Cost_LL (vwStockListRpt) tool 8591873607.42 vs direct 8591873607.42 PASS FC purchase lines: Σ converted net = Σ qty × frozen inc_cost_LL ours 101316750517.92 vs frozen 101444310454.09 (0.13%, 151 lines) PASS sales_summary on closing date 2025-12-31 ignores the CL voucher tool 0.00 vs direct-noCL 0.00 PASS account_balance(138000-00001 as of 2026-12-31) = UNO year-begin (OB + year movements) tool -229817117896.83 vs UNO -229817117896.83 PASS purchases_summary total = Σ purchases − Σ purchase returns tool 614624330152.51 vs direct 614624330152.50 PASS customer_profitability names no cash/bank account as a customer == 26 PASS / 0 FAIL ==