How do I create a new Transfer Worksheet?

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 worksheets when logged in please see your onsite admin for additional permissions.*


  1. Navigate to Worksheets, select Transfer and Add



  1. Select Create New and choose Next 




  1. The Transfer Wizard will pop up



  1. Description: The description/name of the document 
  2. Extended Description: Space to additional information about these transfers 
  3. Warehouse Store: The store that will serve as the warehouse, and be listed as the From Store in the transfers 
  4. Transfer Store: The stores that will be receiving the product or the To Stores in the transfers
  5. Default Sorting: The ability to sort your items by SKU, Vendor, Description, Level, or the dimensions you have configured. 
  6. Exclude Items where the Warehouse on-hand is zero or less: Will exclude items from being included that have zero or less on hand unless the worksheet is being created based on requests. Then all the items on the request will be pulled in regardless of the warehouse on hand.
  7. Save as Template: If these will be transfers that you perform regularly, then the configuration can be saved as a template for quicker setup in the future. 
  8. Next: move the next portion of the Setup wizard. 


  1. If you are creating these Transfers based on Requests, then highlight the appropriate Request(s) and choose Select this Record, if you are creating them ad hoc select Skip this Step. 



  1. The Transfer editor will appear:



  1. Transfer Number: Transfer worksheet document number will auto generate
  2. Description: The description of the worksheet entered
  3. Status: Status indicating whether the worksheet as been committed or not. 
  4. From Store: Store that was selected to serve as the warehouse
  5. To Store(s): Stores selected as the recipients 
  6. Related Requests: If the worksheet was created based on requests, then those request document numbers will be listed here
  7. Sort By: Filters that allow you to sort the items in your worksheet by SKU, Vendor, Description, Level, or the dimensions you have configured.
  8. Hide: Will allow you to Hide items that have zero or less on hand, hide items that 0 qty in the Qty to Issue column or are above par already, and hide items that  
  9. Rounding Method: If quantities requested are a non-whole number there are a number of rounding methods to choose from
  10. Add: Will pull up the item lookup screen to view items
  11. Remove Selected Items: Will allow you to remove highlighted items from the worksheet
  12. Item History: Will generate an item history report for the highlighted item
  13. Add Items from: Will allow items to be added from several other locations/documents in the software
  14. Commit Worksheet: Will finalize worksheet and prompt the creation and issue of the transfers for each store selected. There is a setting in System Setup>Options>Global that will allow you to dictate whether transfers should be automatically accepted at the time the Worksheet is committed. 
  15. Fill Requests: Use this button to automatically populate the desired amount to the best of the warehouse’s ability in the Transfer & Qty To issue columns.  The warehouse will not fill requests if the on-hand does not meet the requested quantity unless that item is a 'Production Transfer Item'.  The amount to fill is determined by the Requested column multiplied by the Multiplier column.
  16. Set Multiplier: Will allow you to increase or decrease the qty to transfer without changing the requested amount. After setting the multiplier, using the Fill Requests button will update the quantities in the Qty to Issue column.
  17. Print Committed: Will allow you to print an itemized listed of the items transferred and their quantities. 



  1. Once all items have been added, and transfer quantities updated, select Commit In the bottom of the worksheet. This will prompt the transfers to be issued and depending on system configuration they will also be accepted. The Print committed will also become available. 

 



Tip: Transfer worksheets can also be created directly from the Requests Screen, if your organization primarily creates transfer worksheets based on Requests. Simply highlight the request(s) in question and select Create Transfer Worksheet. 





    • 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 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 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 ...
    • FAQs: What is Smart Maths in Replenishment Worksheets?

      Q: What is Smart Maths in Replenishment Worksheets? A: When you're using a replenishment worksheet and the warehouse does not have enough stock to fulfill all the requests from replenishment stores, Smart Math helps determine how to distribute the ...
    • How do I use the enhancements in Replenishment Worksheets?

      This video will demonstrate how to use the new replenishment features Replenishment Worksheet Enhancements We have introduced three Replenishment Worksheet enhancements. Exclude Items with No PARs Set Filter When creating a new Replenishment WS, this ...
    • Popular Articles

    • How To: Find Your Yellow Dog Inventory Version

      Understanding which version of Yellow Dog Inventory you're using is essential when exploring new features, as some enhancements and functionalities are specific to certain versions. All client types can benefit from knowing their Yellow Dog Inventory ...
    • How do I use Par & Re-Order Points?

      What is a Reorder Point? The minimum quantity you would like inventory of the item to be before ordering more. Items must go below this level to trigger reorder. Items set to 0 will not reorder until you go into negative stock. This is not ...
    • Tips & Tricks: How do I download and install drivers for my Zebra Printer?

      **As a note: Admin rights will be required to complete this task. If you do not have admin rights on your PC, please contact your IT for assistance** ZD410 Desktop Printer Support Site 1. Navigate to Drivers: 2. Select Zdesigner V. 5 Driver for ...
    • How To: Swap the On-Hand/Parent Size (Edit Base Unit)

      When managing items with multiple sizes, it’s essential to configure them correctly. The on-hand/parent size should always represent the base unit or smallest measurement, while additional sizes should be created for purchasing or counting sizes. If ...
    • Food and Beverage Core Features User Manual

      The Food & Beverage Core Functions User Manual is your key to understanding the potential of Yellow Dog. Whether you're a first-time user or a seasoned pro, this detailed manual will help you understand how to best utilize your Yellow Dog Inventory ...