Loading...
Sales Orders.
| Item | Description | Lot Number | Date Received | Expiration Date | Lot Qty | Total Item Qty | U/M | Months to Exp | Status |
|---|---|---|---|---|---|---|---|---|---|
| Upload a file to begin. | |||||||||
| Item | Description | QuickBooks Qty On Hand | U/M | Qty on SO | Total Available | Status | Produced | Sold | Last Produced | MIA | Qty OH | PP | Qty on PO | ETA | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload a file to begin. | |||||||||||||||
| Item | Description | Sold Qty | Lot Number |
|---|---|---|---|
| Upload a file to begin. | |||
| Item | Description | IOH | Note | Last Updated | Actions |
|---|---|---|---|---|---|
| No item notes yet. Add notes from Item Totals. | |||||
| Item | Description | Qty On Hand | Qty Ordered | Qty Sold | Lotes with expiration dates available | Weeks Since Last Purchase | Notes |
|---|---|---|---|---|---|---|---|
| Upload Inventory List.xlsx first, then upload a Sales Order or start a Manual Order. | |||||||
| Order Number | QBs ID / DBA | Order Date | Total Items | Total Amount | Actions |
|---|---|---|---|---|---|
| No saved orders yet. | |||||
| Item | Description | Item Type | U/M | Total Item Qty | Produced | Sold | Last Produced |
|---|---|---|---|---|---|---|---|
| Upload a file to begin. | |||||||
Data comes from the Inventory List uploaded in Setup (Lots / Expiration sheet).
Upload Inventory List.xlsx with the sheets QBDATA, Lot and Expirations, Purchase by item detail, and SalesItemDetail.
Tabs that accumulate — data is kept and merged on every upload (identical records are not duplicated, only new ones are added): Lots / Expiration and Cycle Count (from Lot and Expirations), the Produced / Sold history in Item Totals (from Purchase by item detail and SalesItemDetail), Weeks Since Last Purchase in SO Picking List (from SalesItemDetail), and Package Sales History (ready-to-sell stock and invoices — never cleared by inventory upload).
Tabs that reset — replaced with the latest file on every upload: the QuickBooks values shown in Item Totals and Lots / Expiration such as Qty On Hand, Qty on SO, price, description, Status and ETA (from QBDATA, ACTvrsINA and OpenPOs). SO Picking List → Saved Orders are also cleared on each inventory upload. Package Sales History is not cleared.
For Email in Saved Orders: click Email with Outlook open — a new message goes to the salesman's registered address with the PDF attached. No .bat file needed. Works from Netlify too.
Add login users for this app. Choose Admin for full access, or User and pick which tabs they can open. Passwords are stored securely (hashed).
| Username | Role | Access | Actions |
|---|---|---|---|
| No users configured yet. The app is open to everyone until you add one. | |||
Add each salesman and their discount percentage. When a Sales Order is loaded, the matching salesman applies the Price Level automatically in SO Picking List.
| Route No | Salesman | DBA | QBs ID | LaceUp ID | Price Level | Phone | Address | Actions | |
|---|---|---|---|---|---|---|---|---|---|
| No salesmen configured yet. | |||||||||
Add shipping methods here. They appear as a dropdown in SO Picking List.
| Ship Via | Actions |
|---|---|
| No Ship Via options configured yet. | |
Add clients and the addresses (City, State) used by the DSD Sales tab. When you create an order there, Client and Ship To appear as dropdowns with this information.
| Client | Addresses | Actions |
|---|---|---|
| No clients yet. | ||
Add package stock from FG items (C#### → P####). U/M is always Pk. Only positive qty items are listed as ready to sell. Sales invoices stay saved for traceability.
| Item | Description | U/M | Qty | Pack Price | Lot Number | Expiration | Line Value | Actions |
|---|---|---|---|---|---|---|---|---|
| No package items ready to sell yet. Click Add Item. | ||||||||
| Invoice # | Date | Customer | Items | Lots | Total Amount | Actions |
|---|---|---|---|---|---|---|
| No package sales saved yet. | ||||||
Loading workbook...
Large files can take 1–2 minutes. Please wait.
Select a salesman. The order number is generated automatically.
Select a salesman. The invoice number is generated automatically.
Enter one item ID per line to check its Qty on PO.