JEM International

Buyer Sheet Desk

Sign in

Your password is checked against Acumatica and kept only in server memory for this session. It is never saved.

Inventory data: checking…

Preset Filters

Presets carry their own filter logic (built from your Acumatica filters). They use the options below on THIS tab only.

Options for presets

Filters

Options for custom sheet

Item Lookup

Aged Inventory — on-hand qty & cost aged by receipt date (FIFO: stock on the shelf is matched to the newest receipts)

First run pulls 24 months of purchase receipts (~a minute); after that it's cached for 2 hours.

Acumatica Agent — tell it what to do in Acumatica; it looks up, updates, releases holds, approves, and reports back with every step shown.

📎 Attach POs, quote sheets, photos of samples, or an Excel — the agent reads them and follows the instructions inside or in your message. It acts with YOUR Acumatica login. Order creation stays in the Order Entry tab; destructive actions (cancel/delete) are confirmed with you first.

Admin — user access

Usernames must match each person's Acumatica login — they sign in with their own Acumatica password, so Acumatica's own security decides what data they can pull. This panel decides which tabs they see and can use (enforced on the server, not just hidden). Anyone with a valid Acumatica login who is not listed here keeps full tab access — add them with fewer tabs to restrict them.

Admin — backup & migrate

The backup zip holds everything on this service's disk: saved views & schedules, presets, user access grants, the style # registry with its images, the ship-to cross-reference, and the creation log. Download it here, and restore it onto a fresh copy of the app (new Render account / server) to move without losing anything.

⬇ Download full backup (zip)

Freight & Duty — Landed Cost Comparison

Program Costing

Math per line (matches the costing sheet): Net = Cost − discount · First Sale = Net − commission · Duty & Extra Tariff on First Sale · Freight = (container $ + drayage) ÷ pcs/40HQ · LANDED = Net + Duty + Tariff + Freight + Extra − Factory Disc · an LDP $ is an alternative all-in price: margins and extended cost use it instead of the build-up (nothing added on top) · royalty off Sell.

Style # Creation

Numbers are always 7 digits: 7xxxxxx Baby · 5xxxxxx Home · 2xxxxxx Kids. Each new number continues after the highest already used in Acumatica or this registry, so nothing ever collides.

Reserved style numbers
Download registry (Excel)

Order Entry — files to Sales Orders (on hold)

Drop PO + Distribution files here ⬇ Creation log (Excel) or click to choose (multiple allowed)
Each PO usually has two files: the PO itself and its Routing & Distribution Instructions. PDF, Excel, CSV, or photos — 12 MB each.

Commissions & Royalties

Notes

Pick or create a notebook on the left.

Buy Sheets

Open (not completed) orders only. Choose the customer and any buyer / item-class filters, then Fetch. Print gives one landscape page per Customer PO; fetched sheets can be saved by name and downloaded later.

fill one for before/after, both for between

Saved buy sheets

Loading…

Supplier Deposits — new request

Enter the vendor PO, set the deposit, then walk it through: Request (Excel / email) → Create in Acumatica (Checks → Prepayment, on hold) → Approve → Wire. Every step is stamped with who did it and when.

Deposit tracker

Loading…

Deposit Desk — accounting

New and pending deposits to set up, plus everything posted — matched back to Acumatica automatically (a prepayment deleted or voided there shows up here). Auto-refreshes every minute while open.

⏳ To set up (new & pending)

Loading…

⚙ Posted — live in Acumatica

3PL Warehouses

Send Acumatica shipments and purchase receipts to an outside warehouse, then bring back what they shipped (quantities, boxes, tracking, PRO/BOL) and received. One setup per warehouse.

Purchase Order Lookup

Sales Order Lookup

Purchase Receipt Review

Find receipts by FOB point — only ITS statuses Booking Confirmed and NEW are shown
Or load by receipt number
Report manifestIN PROGRESS
Starting…
⬇ Download Excel

My views

Recent reports

No reports yet.

Setup tools

Field Inspector — show the exact column names a Generic Inquiry returns
Allocation Probe — raw allocation details (IN402000) for one item