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 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 ...
    • 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 ...