How do I create a Purchase Order Worksheet?

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 for, the stores that you wish to create these orders for, and the buyer (employee) that will appear as the creator of the Purchase Orders:

        



A new Purchase Order Worksheet will open and users can edit the details and add items.  



Purchase Order Number:  This number is auto populated in Yellow Dog and can be changed by users who have access.

Description:  The description is auto populated in Yellow Dog and can be changed by users who have access.

Vendor:  Displays the vendor that is selected for the purchase orders.

Vendor Terms:  Displays the vendor terms for this vendor.  This field will appear blank if no terms are set for the vendor.

To Stores:  Displays the stores selected for the purchase orders.

Buyer:  Displays the user selected as the buyer for these documents.

Created By:  Displays the user logged in creating the PO Worksheet.

Start Ship Date:  A date can be selected here to indicate when this PO should ship.

Cancel Ship Date:  A date can be selected here for users to cancel the PO if the order has not been shipped by this set date.

Instructions:  Optional field available for users to enter in any instructions for this order.  This will appear on the POs created by this document.

Notes:   Optional field available for users to enter in any notes for this order.  This will appear on the POs created by this document.


Select Add to Add items to the Worksheet


Select from the Options- Items, Matrices, or Items from:



The item Lookup screen will open to display all available items from the selected vendor that can be added to this worksheet.  Use the filters and search features just as you would in other areas of Yellow Dog.  Once you have selected the items you wish to add to the worksheet, choose the SELECT button.


Once items have been added, use the Order Sheet tab to specify quantities to be ordered for each store in the gold editable fields.  Highlight each item to see and select your item quantities.


Use the On Hands and On Order tabs to view current on hands and quantities on order for each location to assist in the ordering process.

                               

                                               

Once all items are added and the order is complete, select COMMIT PURCHASE ORDER WORKSHEET:





Once committed, a Purchase Order for each store on the worksheet will be created with the items and quantities selected on the worksheet.  Users from each store will be able to review and commit the Purchase Orders created.









    • Related Articles

    • How do I create & use replenishment worksheets?

      The Replenishment Worksheet is a tool that utilizes a designated warehouse store to generate requests or transfers for multiple locations on a single screen. This tool uses algorithms to decide which store’s requests get priority fulfillment based on ...
    • 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 ...
    • Reporting Explained: Purchase Order Summary

      Business Need: This report will provide an overview of all purchase orders for an organization summarized by document. How it Works: Users will filter to a specific date range and have the option to include or exclude certain Status’ as needed. The ...
    • How do I create Production Worksheets?

      Production worksheets effectively give users the ability to create prep lists, that can be based on Purchasing Requests or created ad hoc. This worksheet will pull in Recipes that can then be printed as summarized lists of recipes or itemized with ...
    • How do I Create and Approve a Purchase Order with Purchase Order Approvals?

      Purchase Orders Approvals Purchase Order Approvals are used when approval is required to place orders, i.e. purchasing amount restrictions. You can use the threshold method, which only requires one approver, or you can create Hierarchical Approvals ...
    • Recent Articles

    • Feature Overview: Password Recovery

      What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...
    • 377 Food & Beverage Webinar

      Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.
    • Feature Overview: Retail Price Fields

      Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...
    • Yellow Dog/Silverware Integration Overview

      This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...
    • Yellow Dog/Toast Integration Overview

      This document will provide an overview of the Yellow Dog Toast Integration Integration Approach This is a 1Way Integration – Pull sales only Sales – Pulled from the Toast API Items – Can be matched on SKU Item management best practices Yellow Dog ...