Import operations

Order & Container Workboard

Track PO, container, customs, delivery and warehouse receipt in one internal web tool.

General access

FDA HOLD

NOA received → LOT submitted → FDA sampling → Release. Record dates and LOT numbers directly on each item row.

Right-click a row for actions · Shift+F10 for keyboard · FDA HOLD applies to selected items

Tasks

Shared team to-do board. Assign a task to a teammate and they get reminded in the app. Drag a card to another column to update progress; click a card to edit it.

Log in to see the team task board.

Daily Sheet Migration

Upload the current Daily Sheet workbook. Leave replace mode off for normal incremental updates.


            

Supplier Shipping Plan

Step 1 — export a blank template per supplier (their At Source POs, last known dates pre-filled in grey, reference columns locked). Send each file to the supplier to fill in.

Step 2 — upload a supplier's weekly plan workbook (columns: PO, planned ETD, planned ETA, Note). Rows are matched by PO and compared with last period — delay and earlier are highlighted. Nothing is saved until you confirm, and only ETD(origin)/ETA(origin) change.


            

Demand Planning Sheet

Upload this week's Demand Planning Details workbook to refresh Coverage. Nothing is saved until you confirm — accounting junk rows are filtered, and the sheet's On Order is checked against open POs to catch a unit mismatch.


            

Open PO Check

Upload the ERP "Open Purchase Orders" export (.csv or .xlsx). Every Document Number is matched against the Workboard — active loads and received history. Read-only: nothing is saved. POs that are in the file but missing from the Workboard are the ones not yet uploaded.


            

Preset Reports

Summary reports across active orders — At source, In transit, Arriving. Received orders are excluded.

Archive Reports

Summaries over the full purchase and receiving history.

Plan History

Per Load and PO deviation from the original plan: how many times the supplier pushed the ETD, total slip in days, and whether they reported a different destination. Click a row to see its weekly timeline.

Loading plan history...

Coverage

No demand sheet uploaded yet

Global default —

Global default safety band (months)

Applies across all categories. Classification filters only change this view.

About coverage

How coverage works

Coverage = available stock ÷ (full forecast ÷ 9 months). Each SKU uses its effective safety band.

Status counts reflect the selected product and customer categories. Choose a status to filter the table; choose it again to show all.

Click a column header to sort, a SKU to open its projection, or a PO count for orders and ETAs.

Upload the weekly Demand Planning sheet on the Import tab to refresh the source.

No demand sheet uploaded yet

Audit Log

Every change is recorded here: who did what, and when. Deletions stay traceable even after a load is gone.

Loading audit log...

Admin

Manage team users, roles and system monitoring.

Users & Roles

Create team accounts and choose what each can do. Admin = full access. Operation = edit the Workboard; no import or admin. Visitor = view, search and reports only.

A Microsoft email is pre-approved only for this user and role. The first verified sign-in links the stable Entra identity.

Log in as an admin to manage users.

Field Dictionary

Review imported archive columns, canonical names, and detected data types.

Pack Size and automatic totals

Enter the pack explicitly. Applying a nonempty Pack Size enables NW = Qty × Net LB/MC and Amount = NW × Cost/LB. Editing NW switches weight to manual. Editing Amount switches Amount to manual. Apply the same pack again to restore both automatic calculations.