0
Wed 13 May
SnapshotStaffF&BSpaActivitiesEventsInventorySuppliersCatalog cleanup

Joy Electronics & Electric

← Back to vendors
$341
Gross spend
$326
Net amount
2
Lines
2
Accounts
1
Classes
2
Active periods

Activity window

First txn
2026-03-27
Last txn
2026-04-11
Span
15d
Currency (guess)
USD

Account split · 2 period × account combos

PeriodAccountUSALI deptSubcategoryLinesGross $ ▼Net $FirstLast
2026-03MAINTENANCE - VEHICLE614121UndistributedPOM1$334$3342026-03-272026-03-27
2026-04LOSS EXCHANGE RATE663100UndistributedFX Gain/Loss1$7−$72026-04-112026-04-11

Anomalies · 1 flagged

AccountGross $% of vendor spend ▼
LOSS EXCHANGE RATE663100$72%

Transactions · last 2 (cap 500)

Date ▼TypeQB #AccountUSALIMemoNativeUSD
2026-04-11Bill Payment (Cheque)780LOSS EXCHANGE RATE663100FX Gain/LossExchange Gain Or Loss—−$7
2026-03-27Bill2026/010128MAINTENANCE - VEHICLE614121POMChange Battery Scooter 2Unit + Labor fee—$334
Data lineage
Vendor name = raw gl.gl_entries.customer_name (QB transaction Name field). Aggregates: gl.v_supplier_overview. Splits: gl.v_supplier_vendor_account. Anomalies: gl.v_supplier_account_anomalies. Lines: gl.v_supplier_transactions (last 500 by date). No gl.vendors master join (it's empty). Curated attributes (contacts/terms/lead time) → suppliers.* Phase 2.5b.