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

    • Yellow Dog/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...
    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...
    • Yellow Dog/Shopify Integration Overview

      This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...
    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...
    • Yellow Dog/NCR Silver Integration Overview

      This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...