This is a part of the Purchase Orders feature in the Smart Ops Release. Click here to learn more about the Smart Ops.


A Purchase Order can be created either manually or from a template with a pre-defined set of terms arranged in a specific order. Once created, the quantities to order from a Vendor can either be suggested by R365 or manually entered as needed.


Click here for a printable guide on Purchase Orders.


This article covers the following topics




Create a Purchase Order


To create a new Purchase Order, navigate to the Orders page; click the + Create button in the top, right corner above the listing; and select Purchase Order.




Users can also create a new Purchase Order from the Home page by clicking the plus icon and then selecting the desired Template or Shopping List or creating a new Purchase Order from scratch.


Either option will open the New Purchase Order sidesheet. 




Enter a Purchase Order

A Purchase Order can be entered from either a newly-created Purchase Order form or by clicking into a scheduled Purchase Order Template displayed on the Orders' tab of the Orders page.


From this New Purchase Order sidesheet, enter in the necessary details and then ensure to save the sidesheet.





FieldDescription
General Information TabThis tab contains all Purchase Order details.
Attachments TabOnce a PO has been saved, users can upload and add attachments to the Purchase Order from this tab.

Template SelectorUsers can select a Purchase Order Template from this selector, which will autofill the PO fields based on the template.

PO NumberThis number is auto-generated based on the settings in the Autonumbering section of the administration menu in the Accounting module. For each new PO, the previous PO Number is aggregated by 1 and can be edited as needed. Duplicate PO numbers are not allowed.

LocationThe location that will receive the order. This field is set to list the default location but can be easily updated as needed. Click the source linknext to the selected location to open its Location Record.

VendorA listing of all Vendors, where the user selects the vendor that will receive an email with the purchase order. Click the source linknext to the selected vendor to open its Vendor Record.

Order DateThe date that the order is placed. This is defaulted to today's date but can be updated by clicking the calendar icon.
Delivery DateThe date the order is expected to arrive at the selected Location. This is defaulted to tomorrow's date but can be updated by clicking the calendar icon.
StatusThe status of the Purchase Order: In Progress, Sent, or Completed.
CommentThis field provides the space for any notes about the Purchase Order. These comments will appear on the purchase order when it is sent to the vendor.
AddressThis is auto-filled based on the location's address entered on its Location record. This can be easily updated if needed by clicking the edit icon.
Expand/CollapseClick to collapse or expand the general information section, if needed. 
Details TabThis tab is where all vendor items for this order can be selected and quantities can be entered for review.
Review TabThis tab is where the reviewer will be able to see any discrepancy in quantities and finalize the order. Click here to learn how to review a purchase order.
Search BarThis will search the Item and Vendor Item columns for the string of characters entered.
 Add ItemsClick to add items in bulk. Users will be able to select between All Primary Items or All Vendor Items.
Click Add All Primary Items to add all vendor items associated with this vendor that have been marked as Primary on the Vendor Item Record.

Click Add All Vendor Items to add all vendor items associated with the selected vendor. 
 Suggest QtyThis button will run a built-in algorithm to determine the quantity of each item in the order below it. When selected, a modal will first be displayed asking the User to select the Consumption and Buffer Days before recommending the Suggested Quantity.
  • Note: Consumption Days are the days that the product arriving on weekday will be used. Buffer Days add extra days of sales to the Suggest Qty calculation to account for unforeseen spikes in Sales or longer preparation (i.e. a frozen product that must be thawed, then marinated)
Applying the Suggested Quantity will then allow the user to hover over the quantity suggested to view the details of the calculation in a tooltip
  • Note: Suggestions require the following before giving an accurate quantity:
    • Forecasted Sales for all Consumption/Buffer Days chosen
    • Approved invoices and transfers between counts
    • At least 2 Inventory Counts*
      • *The system will be as accurate as possible to get 90 days of usage between the 2 Inventory Counts, so the 2 Inventory Counts used will be the most recent Count and the Count closest to 90 days before the most recent Count. The system will only look for Counts that have occurred over the past 365 days
+Add ItemClick to add an individual item to the order. 
TotalThe total price of the order. This updates as items are added to the order. 
Qty TotalThe total quantity of Items on the Purchase Order. This field allows Users to be aware of Order quantities in case there are vendor quantity thresholds.




Details Grid


The details grid has the following columns:



FieldDescription
ItemThe name of the purchased item. Click to open the associated Purchased Item Record in a new tab. 
Vendor ItemThe vendor item number. 
Unit of MeasureThe purchase unit of measure associated with the vendor item.
QuantityThe amount of the item to order. 
Each AmtThe cost per unit of the item.
TotalThe total cost of the item. 
On HandThe amount of the item on hand as of the order date.

Upon creation, this field will display the theoretical on hand value based on the item's usage per $1000 of sales. When needed, this field can be edited to include the actual on hand value.

Theoretical on hand values will appear in grey font.
When the on hand value is edited, the number will change to black font. Hovering over a manually updated field will show the original theo on hand value.
Par QtyPar amount from Shopping List used to generate the order. If the order was not created from a Shopping List, par amount will default to 0.
Last Order AmtThe average amount ordered on the previous order.

When the item is added using a template, this value will reference the last order amount from the last time the same template was used.

When the item is added without using a template, this value will reference the last date that the item was ordered. 
Last 4 Avg QtyThe average amount of the item ordered on the last 4 orders.

When the item is added using a template, this value will reference the last order amounts from the previous 4 times the same template was used.

When the item is added without using a template, this value will reference the last 4 times that this item was ordered.
In Transit QtyThe item quantity of any orders that are currently in progress (in transit). This field will have a value when the delivery date on any previous order is after the date of the current order.
  • Note: If the deliver date of any previous order is equal to or before the date of the current order, this field will show 0.

Storage Location The storage location for the purchased item.




Add Vendor Items


Once a Vendor is selected, the + Add Item button will be enabled.




To add Items to the Purchase Order, follow these steps:

  1.  Navigate to the Items grid
  2.  Click the + Add Item button. A line will appear where details can be entered about the item.
  3.  Enter the name of the purchase item or the identifying number assigned to the purchase item in the Item selector field or the vendor item number in the Vendor Item field. 
  4.  Select the desired Item from the drop-down listing that appears
  5.  Once an item is added, details about the Item will auto-populate the boxes in the line. The majority of these fields can be updated if needed.
    • Note: Each Amt costs reference the Unit of Measure and Vendor based on the pricing information available. The 'Each Amt' will populate the first available cost as follows:
      1. Contract Price on the Vendor Item Record
      2. Price of the Vendor Item from the last Invoice
      3. Vendor Item Price for the selected Location

  6.  Enter the quantity of the item, then add more Items if needed.


Users can navigate between boxes by pressing Tab on their keyboard. If all Items are added and the Quantity fields are updated, users can enter a quantity and then press Enter to navigate down the Quantity row. This functionality will work on other columns as well.


Once the Purchase Order is complete, click Save



Submit Without Review


Orders that have been initially saved will have a Submit button present, as shown below. Users with the correct security access can then submit the order without review, unless told otherwise by your Restaurant Management Team. Click here to view the security access needed for this feature.

  • Note: If submitting orders via EDI, all Units of Measure must be set to Case or have a Split UofM correlated to a Case. If not, the Vendor will assume the quantity entered is per case, causing a larger shipment than expected.



It is extremely valuable to have two sets of eyes on a Purchase Order before submitting it to a Vendor, but Purchase Orders can be submitted after they are initially saved. A Purchase Order can be submitted either with or without sending the Vender the Purchase Order via email:

  • Submitting the Order and Sending the PO - To send an email with the PO to the email address entered on the Vendor record, click the Submit button in the header
  • Submitting the Order Without Sending the PO - To update the PO's status without sending the PO via email to the Vendor, click the Status drop-down selector in the header and select Submit



Required Template Permission


Users whose permissions include the Require Template When Creating Purchase Orders permission are required to use a purchase order template to complete a purchase order. 

 

When a new purchase order is created, users with this permission will be unable to select a vendor. Instead, they will be prompted to 'Choose a Purchase Order Template to continue.'




After selecting the template, users will be able to edit item quantities. However, users will be unable to add or delete items from the order. This permission also restricts users from editing consumption or buffer days