How do I create a Purchase Order Worksheet?

How do I create a Purchase Order Worksheet?

This video will demonstrate how to create a Purchase Order Worksheet


Purchase Order Worksheet

The Purchase Order worksheet assists in generating POs for multiple stores within a single screen. 

From the Purchase Order Worksheet list, use the Add button, then select the parameters to create the Purchase Order: Vendor, Buyer and Receiving stores. Click OK to open the Purchase Order Worksheet editor. 


Yellow Dog will auto populate a Purchase Order Number and Description. This can be changed with certain user permissions. 


Fill out the Start and Cancel Ship Dates as well any Instructions or Notes for this order. Use the +/- to the left of “Worksheet Details” and “Additional Worksheet Details” to see the full worksheet if your screen resolution requires it. 



Next, add items from:


  • inventory items
  • matrices
  • store specific lists
  • location
  • pars
  • sales
  • count sheets
  • physical inventory
  • sessions



Just like in Purchase Orders, only items that are assigned to the selected Vendor will be available to bring into the worksheet. 

Additional information on the item can be viewed by selecting the Choose Columns hyperlink on the right-hand side. Items can be removed by highlighting and selecting “Remove”.

Once items have been added, use the Order Sheet grid to specify the quantities to be ordered for each store. Use the On Hands and On Order tabs to view both current on hands and on order for each store to assist in this process.

Once the order is complete, commit the Purchase Order Worksheet to generate a Purchase Order for each store on the worksheet with the specified items and quantities. Users from each of the stores will then be able to review and commit the POs in the system. 

    • Related Articles

    • How do I create a Purchase Order Worksheet?

      Purchase Order Worksheets are a tool that assist in generating POs for multiple stores on a single screen. To create a new Purchase Order Worksheet, select the button “Add”: In the pop up that appears, select the vendor your purchase orders will be ...
    • How do I create a Purchase Order?

      This video will demonstrate how to create a Purchase Order Purchase Orders Purchase Orders are used when placing orders for stock that you need from a particular vendor. You might send this directly to your vendor or to your purchasing department.   ...
    • How do I create a Full Physical Inventory with a PA520?

      This video will demonstrate how to create Full Physical Physical Inventory Physical Inventory Yellow Dog Inventory gives you the ability to periodically check actual on-hand counts against the counts as reported by Yellow Dog Inventory, and then ...
    • How do I create an Invoice?

      This video will demonstrate how to create an Invoice Invoice Records Invoices are usually received after or accompanying your products’ delivery. Invoices will contain your freight, handling, discounts, etc.   Convert a Receipt or Purchase Order into ...
    • How do I create a new Transfer Worksheet?

      Transfer worksheets allow users with warehouse locations that transfer product to additional locations to easily create those transfers based on requests, or ad hoc. *As a note: Worksheets visibility is based on permissions, and if you cannot see ...
    • Recent Articles

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...