How to Flag Customer Orders Above Historical Demand in QuickBooks Desktop Enterprise

The question

A manufacturer of commercial cleaning and janitorial products in central New Jersey, USA, runs QuickBooks Desktop Enterprise and sent us this through our contact form:

"AI tool that will read customer POs and determine if any line item is being ordered at rate greater than that customer's historical demand"— A manufacturer of commercial cleaning and janitorial products in central New Jersey, USA

A similar request reached us in August, and we described the demand check then. It's now live. This post covers what QuickBooks Desktop Enterprise can do on its own, exactly how the live check decides, and what happens to a flagged order.

Why a manufacturer watches this

When a manufacturer sells through distributors, each distributor tends to reorder the same items in similar amounts. A line well above that pattern can be a large one-off job, buying ahead of a price change, or a typo that turned 10 cases into 100. Whatever the reason, someone should look before it ships.

What QuickBooks Desktop Enterprise can do on its own

QuickBooks Desktop shows the history in reports. Intuit's suggested way to see how many of each item one customer bought:

1. 1Go to Reports, then Sales, then Sales by Item Summary.
2. 2Select Customize Report, open the Filters tab, choose Name and pick the customer.
3. 3Set the date range one month at a time to see monthly quantities, or export the report to Excel to lay the months side by side.
4. 4Memorize the report so the settings are saved.

Enterprise adds Advanced Reporting for more flexible reports. But a report is something a person runs and reads: Intuit's help describes reports for this, not a check that runs when a sales order is entered. At dozens of orders a day, running a report for every line of every order isn't realistic.

Sources: Intuit's QuickBooks Desktop help on reports and on customizing reports, and an Intuit answer on Sales by Item Summary for one customer, checked 21 Oct 2026.

How Logistify's demand check decides

The check runs on every line of a sales order before Logistify sends it to QuickBooks Desktop Enterprise. It works per customer and per item:

An example: a distributor usually takes 100 cases of mop buckets a week, so its allowance is 115. It ordered 70 on Monday. On Wednesday a purchase order arrives for 60. This week's total would be 130, so the line is flagged: 15 cases over, with a suggested quantity of 45. On its own, an order for 60 would look routine; the check catches it because it counts the whole week.

What happens to a flagged order

• It isn't sent to QuickBooks Desktop Enterprise. Sending is paused until a person approves the order.
• A warning naming the items that are over is sent by email and shows in the app.
• A person can approve it, and must give a reason, which is recorded on the order. Or they change the quantity, and the check runs again.
• Editing an approved order clears the approval, so the changed order is checked again.
• If an earlier order in the same period is cancelled or changed, later orders not yet sent to QuickBooks are checked again.
• If the history can't be read, orders wait rather than going to QuickBooks unchecked.

What the check doesn't do

• An item a customer hasn't ordered in the lookback has no history, so it isn't flagged. New customers and new items pass.
• The history comes from QuickBooks Desktop sales orders. If your team invoices without creating sales orders, there's no history to compare against, so tell us before switching it on.
• The tolerance and the period apply company-wide, not per customer or per item.
• It compares quantities with the customer's own history, not with stock on hand.

How orders reach QuickBooks Desktop Enterprise

Logistify reads purchase orders from email messages, PDF, Word, Excel and CSV attachments, EDI, WhatsApp, SMS and voicemail, and matches each line to your QuickBooks items. Orders that pass the demand check, and any other checks, go into QuickBooks Desktop Enterprise as sales orders through the QuickBooks Web Connector. It doesn't read faxed orders.

How to start

1. 1Send a few weeks of real purchase orders, and tell us which customers' ordering patterns matter most.
2. 2Logistify connects to QuickBooks Desktop Enterprise through the Web Connector and imports your sales order history.
3. 3Choose the period and the tolerance; the defaults are weekly and 15%.
4. 4Run the 30-day pilot ($1,000, up to 150 completed tasks). It's credited if you sign an annual Core or Business plan within 14 days of the pilot ending.