Planster + Sage 100
Sage 100 keeps the records. Planster writes the plan.
What Sage 100 is best at
- Sage 100’s Inventory Requirements Planning calculates requirements from your sales order lines, work ticket materials and current inventory. Source (2026-10-01)
- It counts supply already on the way — work tickets being made and incoming purchase orders — before recommending what to buy or make. Source (2026-10-01)
Where Sage 100’s planning stops
Inventory Requirements Planning builds requirements from the orders and inventory you already have, plus demand you enter by hand.
- Future demand beyond open orders comes from projected demands entered manually in Maintain Projected Demands. Source (2026-10-01)
- Reorder points and minimum order quantities are inputs you maintain. Source (2026-10-01)
- Requirements are calculated from an IRP data file that you generate. Source (2026-10-01)
What Planster adds
- A forecasting model chosen for each SKU — Prophet, ETS, SARIMA or linear regression — and re-picked when that SKU’s pattern changes.
- Safety stock sized from each SKU’s demand variability and your service-level target, with reorder points and order-by dates that account for lead times and MOQs.
- Separate forecasts for retail, wholesale, DTC and Amazon, combined into one plan.
- Scenario planning that shows the purchase orders and cash a promotion or launch commits before anyone approves it.
- Retail deals planned as demand, with the date you have to order by to make the launch.
- A ranked list every morning of what needs a decision, with the purchase orders already drafted.
- Bills of materials that show which production runs are coming and what each one consumes, so shared components are bought once.
Running Sage 100 and Planster together
| Sage 100 | Planster |
|---|---|
| Records posted invoices, sales orders and receipts | Forecasts demand from invoice history, for every SKU and channel |
| Holds items, warehouses and vendors | Sets reorder points, safety stock and order-by dates |
| Runs purchase orders and work tickets | Drafts the purchase orders for your team to approve |
| Stays the system of record | Reads only — nothing is written back to Sage 100 |
A typical week
- Sage 100 posts the day’s invoices and receipts.
- Planster syncs overnight from the Sage 100 database.
- The morning list ranks what needs a decision.
- Your planner approves the drafted purchase orders in Planster.
- Your buyer enters them in Sage 100.
What Planster reads from Sage 100
- Products
- Warehouses
- On-hand inventory by warehouse
- Sales history from posted invoices
- Open purchase orders, where you map them
- Sage 100 Premium (SQL Server edition); synced nightly; read-only
Sage 100 and Planster: common questions
Which Sage 100 editions does Planster connect to?
Sage 100 Premium, the SQL Server edition. Planster reads its database directly, with the tables, filters and field mappings set up for your company. Sage 100 Standard and Advanced are not connectable today.
Does Planster replace Inventory Requirements Planning?
Planster forecasts future demand statistically for every SKU instead of relying on projected demands entered by hand, sizes safety stock from demand variability, and drafts the purchase orders. Sage 100 stays your system of record, and your team still enters orders there.
Does Planster write data back to Sage 100?
No. Planster reads Sage 100 data every night and writes nothing back.
Ready to optimize your Sage 100 inventory?
Connect Sage 100 and Planster forecasts every SKU, tells you what to reorder and when, and drafts the purchase orders for you to approve.