↑↓ selectEnter openEsc close

    1. Elbuz

    How to create purchase orders from customer orders

    21 min readUpdated

    Elbuz splits selected customer orders by supplier and creates a ready purchase order for each, with purchase prices — no compiling supplier lists by hand.

    When you need this:

    • You sell to order — a day's customer orders become purchase orders with one menu item.
    • Several customers ordered the same product — quantities go into one line; the note shows the order numbers.
    • Some products lack a supplier — they get a separate document instead of getting lost.
    • The goods have arrived — the same “Copy to” turns it into a purchase invoice.

    Where to start: “All documents” → select customer orders → “Copy to” → “Purchase order”.

    What a purchase order can do

    What this gives your business is covered separately: what it does for your store.

    How to create purchase orders from customer orders

    Documents window with two customer orders selected and the document type menu open, showing Purchase order
    1Selected customer orders
    2Purchase order
    1. Selected customer orders — the purchase is built from them.
    2. Purchase order — creates one document per supplier.
    1. Filter the customer orders you need to buy goods for. Filtering by date or status is convenient.
    2. Select the rows you need with checkboxes.
    3. Click “Copy to” in the bar at the bottom (the same menu is in the toolbar under the icon with the tooltip “Create a new document based on the selection”) and choose the “Purchase order” type.

    Done: the program creates as many documents as there are suppliers in the selected lines.

    When the document is created by hand

    The second way is the usual one: in the purchase orders list, click Add and collect the lines yourself. Use it when the purchase isn't tied to specific customer orders: restocking fast-moving items, a one-off purchase, ordering samples. The document itself is the same — only the source of the lines differs.

    Daily routine

    1. Open the customer orders for the period you need.
    2. Filter the ones you need to buy for: usually the “New” or “Confirmation” status.
    3. Select them and create purchase orders.
    4. Go through the created documents: check the quantities and fill in the expected delivery date.
    5. Send each supplier its document.

    How lines are split by supplier

    The supplier is taken from the product card, not from the customer order or the price list. It's a field in the card, and it decides whose order the line goes to.

    If several suppliers carry the same product, the card holds one — the one you work with for this item. To buy from another supplier, change the supplier in the card (this can be done in bulk too), and the next orders will go to them.

    Where a line goes depending on whether the card has a supplier. Both paths meet at the purchase invoice — “ownerless” products don't get lost
    YesNoCustomer orders selected →“Copy to” → “Purchase order”The supplier of each lineis taken from the product cardIs a supplierset in the card?That supplier's document.Identical products from differentordersin the same unitare added up into one lineSeparate document with no contact:“Products not found at any supplier”Set the supplier in the cardsand build again — or enterthe contact right in this documentGoods arrived: “Copy to” →“Purchase invoice”The receipt puts goods into stock,the customer order is readyfor a sales invoice
    • Action or result
    • Decision: the path depends on the answer

    Then two rules come into play that save the most time:

    • Identical products from different orders are added up. If three customers ordered two of the same product, the purchase order has one line for six. Only lines in the same unit are added up: if one order has the product in pieces and another in packs, the purchase order gets two lines.
    • Each line shows where it came from. The line note lists the numbers of the customer orders it was built from. If the supplier delivers less, you immediately see who will be short of what.

    The line gets the purchase price — the one in the product card, not the price you sell at. The document total is calculated from it. The currency is the account's base currency, at the exchange rate on the date of the new document.

    The customer orders themselves don't change: the link between documents is stored separately, so a purchase order always shows its source documents, and a customer order shows what has already been ordered for it.

    What happens to products with no supplier

    Some lines usually end up without a supplier: the product was added by hand, no supplier was set, or the supplier was deleted. These lines don't get lost — they go into a separate document with no contact and the note “Products not found at any supplier”.

    Order lines not linked to a catalog product end up here too, each carried over separately with its own name and quantity. A catalog product, though, is added up into one line in this document even if the orders use different units, so check the unit of that line by hand.

    This is a working “decide where to buy” list. You handle it in one of two ways: set the supplier in the product cards and create the orders again, or enter the contact right in this document and work with it like a normal order.

    A document with no contact is easy to miss: in the list it looks like a normal order with an empty supplier column. If you get one more document than you have suppliers, that's the one.

    What to check in the created document

    A purchase order works like other documents: a header with the contact, dates and total, a lines table, and tabs for delivery and payment. You can add or remove lines and change quantities by hand — what was built automatically is a draft, not a final verdict.

    Fill in the expected delivery date: the “Expected supply date has passed” signal relies on it. Such orders are highlighted in the document list until they are signed — that's your “the supplier promised and didn't deliver” list.

    A purchase order doesn't move stock or create a debt. It's an intention to buy, not a receipt of goods. Stock levels change with the purchase invoice.

    How to avoid an extra set of documents and remove it

    If you run “Copy to” again on the same orders

    The program doesn't check whether these customer orders already have purchase orders. Every run creates new documents from scratch: again one per supplier, again with the full quantity from the customer orders and the purchase price from the product card.

    • If you already edited quantities or prices in the earlier documents, those edits stay — a repeat run doesn't touch the old documents. But they aren't carried into the new ones either: a second set with the original figures appears next to them.
    • If some lines have already been ordered, a repeat run doesn't subtract them — the quantity in the new documents is taken from the customer orders in full.

    Once the documents are created, the checkboxes on the customer orders are cleared and the list refreshes. If you select the same orders again and click “Copy to” once more, you get a second set of documents. Before repeating, open the purchase orders list and check whether the documents are already there.

    What you see after clicking depends on whether anything was checked:

    • If at least one order is checked, you first get the “Duplicate documents” confirmation with the number selected. After it, the checkboxes are cleared, the list refreshes and the “Operation completed successfully” message appears; the document window doesn't open.
    • If nothing is checked, the order under the cursor is used, and after creation the last created document opens. If nothing was created, nothing opens and there is no message.
    Left branch — with checkboxes: there is a confirmation, but the document doesn't open. Right branch — without checkboxes: no confirmation, the last created document opens
    YesNoNoYesYesNo“Copy to” → “Purchase order”Are any orderschecked?“Duplicate documents” confirmationwith the number selected →“Create”Documents built from all checkedorders.Checkboxes cleared, list refreshed,“Operation completed successfully”.If none were created — “Operationfailed!”Is the cursoron a document?Message “Select a document!”Documents built from this orderwithout confirmationAt least onedocument created?The last created document opensNothing opens
    • Action or result
    • Decision: the path depends on the answer

    If the selected orders produce no documents at all — for example, they have no active lines — you get the red “Operation failed!” message, and the checkboxes stay in place.

    If you created them from the wrong orders

    Customer orders don't change during creation, so fixing this comes down to deleting the extra purchase orders:

    1. Open the purchase orders list. Documents from one run are created at the moment of the run, with you as the author. Their lines have the source customer order numbers in the note, and the document with no contact has the note “Products not found at any supplier”.
    2. Check the extra documents, click “Delete selected documents” and confirm “Do you want to delete the selected documents?”.
    3. Deleting removes the document together with its lines and its links to the customer orders. The customer orders themselves stay as they were.
    Bottom bar of selected documents with Copy to, Merge and the delete icon
    1Copy to
    2Merge
    3Delete selected documents
    1. Copy to — creates purchase orders from the selected documents.
    2. Merge — combines unposted documents of one contact into one.
    3. Trash icon — deletes the selected documents and skips posted ones.
    • If one of the selected documents is posted, it isn't deleted: you see the message “Posted documents were not deleted (N). Cancel the posting first.”, and its checkbox is cleared.
    • If you deleted the wrong thing, the “Documents deleted: N” message has an “Undo” link — it restores the whole batch. Later you can restore the batch from the “Document trash” menu item: it keeps deletions from the last 30 days.

    How many orders you can select at once

    There is no limit on the number of selected customer orders or lines. The whole split runs as one request while you wait — it doesn't go to the background queue. Each supplier's lines are written to the document in one go, and documents are created one after another: supplier documents first, the document with no contact last.

    How to receive goods when they arrive

    When the goods arrive, turn the order into a purchase invoice the same way: select the document, “Copy to” → “Purchase invoice”. Workspaces don't get in the way here: both types belong to inventory, so the item is also in the “Inventory” window. Lines and quantities carry over; check them against what arrived and post.

    Then the chain is the usual one: the receipt puts the goods into stock, and the customer order is shipped with a sales invoice.

    There is also the reverse path, when you buy to restock rather than for a customer order: in the price list products window, selected rows become a purchase invoice with one menu item.

    Scenarios

    Buy everything customers ordered today

    What to do: in “All documents”, filter the day's customer orders, check them, choose “Copy to” → “Purchase order” and click “Create” in the “Duplicate documents” confirmation.

    What you get: one document per supplier from the product cards. The same product from different orders in one unit is one line with summed quantities, the card's purchase price and the customer order numbers in the note. Canceled order lines aren't included.

    What won't happen: no document window opens — find the documents in the purchase orders list. Stock on hand isn't subtracted. The checkboxes on the customer orders are cleared; a second set appears only if you select the same orders again and click “Copy to” again.

    Order more for a single order

    What to do: with nothing checked, click the customer order row to put the cursor on it and choose “Copy to” → “Purchase order”.

    What you get: the documents are created without confirmation, and the last created one opens. With products lacking a supplier, the document with no contact opens, since it's created last.

    What won't happen: other suppliers' documents from this run don't open — they're in the list. If the cursor isn't on any row, you see “Select a document!” and nothing is created.

    Some products have no supplier yet

    What to do: create the orders as usual, then handle the no-contact document with the note “Products not found at any supplier” by hand: enter the contact, set prices.

    What you get: line prices and the document total are 0, because the purchase price isn't pulled in for it. Once you've entered the supplier, you can merge the document with another unposted order for the same supplier.

    What won't happen: if you set suppliers in the cards and run “Copy to” again instead, the repeat run also re-creates the supplier documents that already existed. Then delete the first set with “Delete selected documents”.

    Order from a supplier once every few days in one document

    What to do: create purchase orders daily; before sending, select one supplier's unposted orders and click “Merge” in the selection bar. In the “Merge documents” window, choose the document to add the rest to and confirm with “Merge”.

    What you get: the other documents' lines move to the chosen one. If it already has the same product at the same price, the quantity is added to that line; otherwise the line moves as a separate row. The others get a total of 0, the note “Merged into document …” and a link to the chosen one.

    What won't happen: posted documents and documents of different contacts aren't merged — you see “Only unposted documents of the same type and contact can be merged”. When a quantity is added to an existing line, its note keeps only the chosen document's customer order numbers, and the numbers from the merged line disappear.

    The two checks at the top filter out a wrong selection before the dialog. The bottom shows when lines are added up and when they move separately
    NoYesNoYesYesNoPurchase orders selected →“Merge” in the selection barTwo or moreselected?“Select at least two documentsto merge”All unposted, same typeand same contact?Refused: only unposted documentsof the same type and contactcan be mergedChoose the document to addthe rest to → “Merge”Does it already have the sameproductat the same price?The quantity is added to its lineThe line moves as a separate rowOther documents: total 0, note“Merged into document …”, link tothe chosen one
    • Action or result
    • Decision: the path depends on the answer

    Move a product to another supplier

    What to do: change the supplier in the product card and, if their price differs, the purchase price too.

    What you get: the next “Copy to” → “Purchase order” runs put this product into the new supplier's document at the card price.

    What won't happen: purchase orders already created aren't moved — the contact and price in them are fixed at creation. Delete the unneeded line in the old document by hand.

    What to do when the order comes out wrong

    What you seeWhyWhat to do
    One document was created instead of several all products in the selected orders come from one supplier that's expected
    A document with no supplier was created some products have no supplier in the card set the supplier in the cards or enter the contact in this document
    The quantity in a line is larger than in any single order identical products from different orders are added up the source order numbers are in the line note
    The same product appears in two lines the customer orders have it in different units, for example pieces and packs merge the lines by hand, or align the unit in the customer orders, delete the created documents and create the orders again
    Prices differ from the customer order the purchase price from the product card is used correct the price in the document or in the product card
    No order was created at all the selected orders have no active lines check whether the lines in the customer orders are canceled
    The “Copy to” menu doesn't have the type you need the “Orders” workspace is open, and it only offers the customer side open “All documents”
    Stock didn't change after creation a purchase order doesn't move stock create a purchase invoice when the goods arrive
    The document is highlighted with a warning the expected delivery date has passed and the document isn't signed contact the supplier or move the date

    FAQ

    How many documents will be created?

    One for each supplier found in the lines of the selected orders, plus one more for products with no supplier, if there are any.

    Does the program subtract what's already in stock?

    No. The purchase order gets the full quantity from the customer orders, even if some of the goods are in stock. Remove the excess in the document by hand.

    Can the program pick the supplier with the lowest price itself?

    No. The supplier is taken from the product card. To buy from another supplier, change it in the cards — this can be done in bulk too.

    Does a purchase order reserve goods?

    No. The document doesn't move stock and doesn't mark the lines in customer orders in any way.

    How do I send a purchase order to the supplier?

    The document isn't sent anywhere by itself: print it or send it by email right from the document card.

    Where to find it and who has access

    Menu
    Directories → Documents → “All documents”, type “Customer order”
    Other entry points
    “Inventory” — create a purchase order by hand, without customer orders
    Access right
    the “All documents” entry
    Prepare
    supplier and purchase price in the product cards

    There are several document windows, and it matters. Besides “All documents” there are separate workspaces: “Orders”, “Inventory”, “Finance”, “Deals”. Each shows and creates only its own types: “Orders” covers the customer side, while the purchase order belongs to inventory. So the “Orders” workspace won't have the menu item you need — open “All documents”.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free