Tarjeeh
Start a project

How should an ERP count stock bought by the carton and sold by the piece?

Follow a carton through purchasing, receiving, sales and returns to check whether your inventory balances in the unit your team actually counts.

ERP Development2 min read

Choose one unit for the stock balance, then record how many of those units come in each supplier pack. For a shop that opens cartons and sells individual filters, the piece is a practical choice. A buyer can still order cartons. The receiving team should see both the pack description on the delivery note and the number of pieces it expects to put away.

Write a conversion that two people can check

Put a real supplier label beside the product record. Read out the product code, the pack size and the unit used for the quoted price. A description such as “filter box” leaves two questions unanswered. Is the box itself the item being sold, and how many filters does this supplier put inside? Record “carton of 12 filters” wherever a buyer selects the purchase unit. Odoo documents automatic conversion between purchase and inventory units. Ask your implementation team to demonstrate the equivalent behaviour in your chosen system using your sample label.

Receive a short shipment on paper first

Suppose you order three cartons of twelve. You expect thirty-six pieces. Two sealed cartons and ten loose filters arrive. If all thirty-four pieces are accepted, the receipt should add thirty-four and leave the difference of two visible for follow-up. Have the storekeeper explain how to enter this delivery without pretending the last carton was full. Then ask purchasing what happens to the remaining two pieces. A backorder and a supplier cancellation can produce the same physical count today while creating different expectations for tomorrow.

Trace a sale and a return to the shelf

Starting from those thirty-four pieces, sell five and accept one unopened filter back into available stock. The expected balance is thirty. Repeat the return with a damaged filter that goes into a separate inspection location. In that version, twenty-nine should be available for sale and one should be awaiting inspection. Compare the available balance on the sales screen with a count at the shelf. A total across all locations can look correct while the sales team is still offering a damaged item.

Keep old receipts readable when packs change

If the supplier starts shipping ten filters per carton, introduce a dated pack definition or a new purchase unit. Reopen the earlier receipt and confirm that its quantities still make sense. Before importing the rest of the catalogue, give the buyer and the storekeeper this one worked example and ask each to reproduce it independently. Their answers will show which labels, conversion rules and return locations still need clarification.

Sources and further reading

Prepared with AI assistance and checked against the sources listed above. Planning examples are illustrative; your project scope is agreed separately.