Incoming Products by Month is a Stimulsoft operations report that lists the Products still on the way from your released Purchase Orders, grouped by the month they are expected to arrive. It answers a single question for your buyers and warehouse team: what is coming, and roughly when? Use it to plan receiving, follow up with suppliers, and anticipate stock arrivals.
Open Analytics > Operations Reports, select the Purchasing category, and choose Incoming Products by Month. Click Preview to open it in the report viewer, where you can print or export to PDF and Excel.
The report does not require you to type an expected date on every purchase order. Instead it estimates each line's arrival as:
Expected arrival = purchase order date + the vendor's Lead Time (days)
Lead Time is a field on each vendor record and defaults to 60 days. Set a realistic lead time per vendor and the report's arrival months become accurate. See Vendors to set it.
Each product line still pending receipt appears once, grouped under the month it is expected to arrive:
| Column | Description |
|---|---|
| Code | The product SKU |
| Product | The product description |
| Vendor | The supplier the order was placed with |
| PO | The purchase order number |
| Arrives | The estimated arrival date (order date plus the vendor's lead time) |
| Pending | The quantity still to be received |
| Pending Value | The value of the pending quantity |
Each month group ends with a Month total of pending quantity and value. The tiles at the top summarize the whole report: total incoming lines, total pending quantity, and total pending value.
The report lists only Purchase Orders that are:
Orders that are fully received, closed, or archived drop off automatically. A product appears once per open order line, so the same product ordered on two Purchase Orders shows as two rows.
Related: Vendors · Purchase Orders · Purchasing Dashboard
Was this page helpful?