Show TOC

Procedure documentationConsolidating Multiple Sales Orders for Purchasing Locate this document in the navigation structure


You can consolidate multiple sales orders into one single purchase order. This may be valuable, for example, if you receive several sales orders for certain items and you in turn want to purchase these items in one single item order from your vendor to save on shipping costs or obtain a quantity discount.


  • You have several sales orders for items that you want to order from a vendor.

  • You are authorized to create both sales and purchase orders.


  1. From the SAP Business One Main Menu, choose   Purchasing – A/P   Procurement Confirmation Wizard  .

    The Procurement Confirmation Wizard appears.

  2. In the Customer window, choose Add and specify the customers for whose sales orders you want to create a purchase order.

    To be able to create purchase orders for all open sales orders with unfulfilled purchase quantities for the selected business partners, select the Include All Open Sales Orders checkbox. If you do not select this checkbox, the only sales orders displayed are those for which the Procurement Document option was checked on the Logistics tab of the sales order or that use a drop-ship warehouse and have unfulfilled purchase quantities.

  3. Choose Next.

  4. Select the sales orders for which you want to purchase items.

  5. Choose Next.

    The Sales Order Line Items window appears, with purchase order selected as the target document. By default, the quantities for the selected items are the quantities from the sales order(s). If required, change the quantities for the purchase order.

    If an item has a preferred vendor assigned to it, this vendor is already entered in the line.

    • If required, change the vendor code.

    • For all items that do not have a vendor assigned to them yet, enter a vendor code.

    • To specify the same vendor for all items, enter the vendor code in the Vendor field of the wizard body.

    • To specify the vendor for each item individually, enter the vendor code in the Vendor or Vendor Name column of the table.

    To save the purchase order as a draft, select the Create Draft Document checkbox.

  6. Choose Next.

  7. In the Consolidations window, specify whether to consolidate several sales orders into one purchase order and which consolidation options to apply.

    To do the following:


    Create one purchase order per sales order

    No Consolidation

    The documents are grouped by vendor, that is, one purchase order is created per vendor.

    Consolidate several sales orders into one purchase order

    Consolidated by and select the relevant option:

    • Vendor (System Default)

      The documents are grouped by vendor, that is, one purchase order is created per vendor. This setting cannot be changed.

    • Warehouse (Split)

      The documents are grouped by the warehouse that is used to ship the items. That is, if items are sold from different warehouses, one purchase order is created per warehouse.

    • Other

      You can specify additional grouping criteria, such as the delivery date or shipping type.

  8. Specify the system response to errors that may occur in the document generation process. To do so, make a selection in the If an Error Occurs field and choose Next.

    The Preview Results window appears. It displays all purchase orders that will be created, grouped by vendor and the consolidations options you selected.

  9. To generate the documents, choose Next.

    The application creates the relevant documents and displays a summary report of all documents that were created and any errors that occurred.

More Information

Procurement Confirmation