EDI 846 Inventory Inquiry Advice: How to Calculate a Stock Snapshot That Won't Oversell

We had a client, a home-storage brand selling on its own site and on marketplaces, that moved its fulfillment to a 3PL in California ahead of peak season. At signing, the 3PL promised the full EDI set, daily 846s, total inventory transparency. Then the first big promotion hit. At ten in the morning the website was still taking orders. By afternoon the warehouse said the hero SKU was gone. Dozens of orders had to be cancelled, customer service was swamped, and the brand team spent the night in a group chat asking whether the 3PL had lost their stock. Nobody lost anything. The problem was the math inside the 846 snapshot. This is edi 846 inventory inquiry advice from the side of the table that actually signs these contracts: how you calculate the snapshot decides whether you oversell.

Start with what the 846 is. In ANSI X12 it is the Inventory Inquiry/Advice transaction, and it runs both ways: a retailer can send an inquiry asking how much stock is left, and a supplier can send advice reporting that stock has changed. The payload is practical stuff — SKU, UPC or GTIN, quantity on hand, quantity available, committed and allocated quantities, quantities on order, in transit, and on backorder, plus restock dates and discontinued notices, broken out by warehouse and location. Drop-ship and eCommerce brands lean on it hardest, because the website sells a number and the warehouse holds the physical goods, and the 846 is the bridge between them. Build the bridge wrong and the better you sell, the harder you fall.

What EDI 846 Actually Carries, and Which Number You Can Sell

That home-storage mess came down to one confusion. The 3PL's 846 showed more than 800 units on hand, and the storefront treated every one of them as sellable. But part of that 800 was already promised to other channels' unshipped orders. Part of it was damaged stock waiting on inspection. Part of it sat in a staging area, counted in the system but not yet pickable on a shelf. When orders poured in, barely half the number was actually pickable. Sales saw gross stock. The warehouse faced net stock. The gap between them was the oversell.

First-time buyers of 846 service make the same mistake over and over: they treat on-hand as available. It is like counting the line outside a restaurant and assuming there are tables free inside. What you can actually sell is whatever survives after allocated orders, frozen stock, and inspection holds are subtracted. Sometimes the 3PL is not trying to mislead you. Its WMS simply defaults to on-hand, and the 846 goes out carrying the system default with no explanation attached. That is why the first question in any negotiation should be: how exactly do you calculate the available quantity in your 846? That single definition question is the most valuable piece of edi 846 inventory inquiry advice in this whole article. If the answer is a shrug, or "the system does it automatically," keep your hand on your wallet.

The Math Behind an EDI 846 Snapshot

The arithmetic is simple. Getting everyone to use the same definitions is the hard part. Take one SKU:

Two lines in that table start the most arguments. The first is allocated. Do wholesale orders, drop-ship orders, and stock reserved for a big account count as allocated? Some 3PLs count only picked orders. Others count everything ordered but unshipped. The difference can be a full day of sales. The second is inbound stock. Goods still on a truck or on the water — can you sell them early? My rule is no, unless the contract says in writing that inbound stock may be pre-sold and spells out who eats the cost when the truck runs late. Selling inbound stock is gambling that logistics will run on time. Win the bet and you sell a few extra units. Lose it and you are cancelling orders in bulk.

Then there is frequency. A typical 846 goes out daily, or several times a day. People assume more frequent means more accurate, and that is only half true. A snapshot is a photograph of one moment, not a live feed. On a promotion day, a snapshot taken at ten in the morning can be worthless by two in the afternoon. If your hero product can burn through half a day of safety stock in an hour, a once-daily 846 is yesterday's map for today's road. The fix is not simply to push frequency from daily to hourly. First get the definition right, then talk about frequency. A snapshot with the wrong definition, sent more often, just gets you to the wrong answer faster.

We had another client, a beauty brand with two warehouses, one in California and one on the East Coast. The 3PL's 846 rolled both buildings into one combined total. The website showed stock, a shopper ordered, and the order routed to the East Coast building — whose units were already committed to another channel. Combined, the inventory looked comfortable. Split by building, every location had holes. An 846 has to break out available quantity, inbound stock, and restock dates by warehouse. A combined total makes the report look nice and does nothing else.

One more distinction worth nailing down in the contract: the 846 is about stock levels, not movement. The 852, Product Activity Data, reports sales and movement. Mix the two up and you will be forecasting off the wrong document. And the quantity that matters most — available-to-promise — is on-hand minus allocated, stated per location, at a stated time. If your 846 does not show that number cleanly, it is decoration.

The Three Questions to Ask Before You Sign

In most 3PL contracts, the EDI terms get half a page. Brands treat them as a technical detail for IT to sort out later. In my experience, that half page is what decides whether peak season blows up. The valuable thing in a negotiation is not the promise "we support 846." It is getting the definition, the frequency, and the exception handling written down.

Next time you are at the table, ask these three questions. First: does your 846 available quantity equal on-hand minus allocated, and does allocated include ordered-but-unpicked orders, frozen stock, and inspection holds? Second: what time is the snapshot taken, how many times a day does it go out, and can the frequency increase during promotions — and who carries the cost of the gap between snapshot time and real stock? Third: are discontinuations, stockouts, and restock delays communicated early through the 846's discontinued notices and restock dates, or do we find out when an order fails to ship?

If the other side answers all three precisely, and the definitions make it into a contract exhibit, you will sleep better through peak season. If the answers come back vague, do not let a low rate rush you into signing. The money you save on warehousing will not cover the cancelled orders and the customers who never come back. A stock snapshot is not an IT file-format question. It is a negotiation between you and your 3PL over what "in stock" actually means. Settle that first, and whatever you sell, you will sell with your eyes open.

By Susan, 3PL Sales Director