basic purchase orders

 

The following document outlines the process to create a basic purchase order for a product. To create a specific type of purchase order, click on any of the following options to view the details.

 

 

The following options are outlined in the Basis Purchase Order document:

Create a Basic Purchase Order

  1. In General>Purchases, select Orders.

  2. In the Purchase Orders index, click to create a new purchase order.

  3. Click on the Purchase Order tab.

 

 

 

Purchase Order Header

The contract header contains the base data to outline the purchase order. The header is divided into two sections to group the data that is entered in the purchase order.

Purchase Order

The Purchase Order tab contains the base data for the purchase order.

  1. In the PO No field, the purchase order number will auto-generate. The user can override the PO No if required.
  2. In the PO Date field, the current date will default as this field represents the date that purchase order was created.
  3. From Buyer No, select the buyer that is assigned to the purchase order. Buyers are created in: Admin>Business>Definitions>Buyers.
  4. From Vendor No, select the vendor that will supply the products on the purchase order.
  5. Location Id is used if the vendor has multiple locations that ship products. Use the drop-down menu to select the appropriate location. Locations are defined in General>Master Data>Vendors.
  6. From Broker No, select the broker that is assigned to the purchase order. Brokers are created in: Admin> Business> Definitions> Brokers
  7. From Dest Cost Center No, select the cost center that will receive the products identified on the purchase order.
  8. In the Supplier Ref No field, enter the reference number that the vendor supplied in regards to the purchase order. An example may the vendor's order number generated from the purchase order.
  9. Pickup Cost Center No is only defined for Freight Only purchase orders which are created for internal facility transfers.  

  10. In the Comments field, enter any additional information related to the purchase order.

  11. In the Attachment field, any type of file can be attached (Example: Word document, picture, music or video clip.

  12. Select the Void Flag to nullify the purchase order.

Derived

The fields in the Derived tab will automatically generate  based on the selections in the Purchase Order tab. The Derived fields cannot be modified.

  1. Buyer Name displays the name of the buyer that is responsible for the purchase order.

  2. Vendor Name displays the name of the vendor from which the products are being purchased.

  3. Broker Name displays the name of the broker assigned to the purchase order.

  4. Dest Cost Center Name displays the name of the cost center that will receive the product.

  5. Pickup Cost Center Name displays the name of the cost center from which the products will be picked up.

  6. Freight Term Name displays the description of the freight term associated with the purchase order.

  7. Location Name displays the location that the product will be shipped from if the vendor has more than one facility. Locations are defined in General>Master Data>Vendors.

  8. Vendor Address displays the address of the selected vendor.

  9. Vendor City No displays the city code for which the selected vendor is located.

  10. Vendor City Name displays the name of the city in which the selected vendor is located.

  11. Vendor State No displays the state code for which the selected vendor is located.

  12. Vendor State Name displays the name of the state in which the selected vendor is located.

  13. Vendor County No displays the county code for which the selected vendor is located.

  14. Vendor County Name displays the name of the county in which the selected vendor is located.

  15. Vendor Country No displays the country code for which the selected vendor is located.

  16. Vendor Country Name displays the name of the country in which the selected vendor is located.

  17. Vendor Zip displays the zip code of the selected vendor.

  18. Vendor Telephone displays the telephone number of the selected vendor.

  19. Vendor Fax displays the fax number of the selected vendor.

  20. Vendor Email displays the Email address of the selected vendor (if applicable).

  21. Vendor Website displays the website address of the selected vendor (if applicable).

  22. Creation Date indicates the date the purchase order was created.

  23. Last Mod Date indicates the date the purchase order was last modified.

Line Item Order Details

After completing the header of the order, there are several fields and tabs in the Purchase Order (PO) Line Items grid that also must be completed in the creation process. There are many fields in the details, however they can be sorted or removed to accommodate the user requirements. For this document, they have been divided into different parts in order to show a screenshot of each tab. The PO Line No tab also contains a child grid with additional tabs that must be created.

  1. Click on the PO Line Items grid.
  2. Click to create a new purchase order detail line.

 

 

  1. PO Line No indicates the order of the lines.

  2. The Dest Cost Center No and Dest Cost Center Name will default from the header but can be modified if required. It is possible for each line in the purchase order to be received to a different cost center.

  3. Farm No can optionally be used to select the destination farm. Farm Name will default in.

  4. Contract No will default in if the order is linked to a contract.

  5. Price Mode determines where in the process the price can be changed. Select the required Price Mode. Available options are:

  1. PO State refers to the form of the silo certificate and determines whether the product is available for trading or if it is confirmed for purchase. Select the PO state for the product from one of the following options: Actual, Electronic, Folio, and In Control. The general concept is that Actual and  Electronic can be traded, but Folio and In Control cannot be traded, however there is no additional logic to address these options and the field is used only for information.

  2. Basis Price is an optional field to enter the base price of the purchase item.

  3. Select the Price Basis Mode. Available options are Received Date or Shipped Date.

  4. The Consignment flag should be selected if the purchase order is a Consignment Purchase Order.

  5. Complex Market No is used for Market Price Purchase Orders.

  6. Payment Term No defaults from the selected vendor. Payment terms can be modified if required.

  7. Select the Prepaid Multi Receiving flag if the purchase order is a Prepaid Purchase Order.

  8. Select the Haulage Vendor No for the transaction. Only vendors with the Transport Vendor flag marked can be selected in this field.

  9. Freight Term No determines the freight terms for the purchase order. Freight terms default from the vendor but can be modified if necessary. Some common examples of freight terms are: FOB, CIF.

  10. Freight Term Name will default in from Freight Term No.

  11. Currency No defaults based on the currency assigned to the product vendor. Select from the list to change the currency.

  12. Currency Name displays the currency rate that has been selected for the order.

 

  1. Currency Exchange Rate automatically sets to the current exchange rate if the Currency No is changed. The currency rate can be manually entered if there is a guaranteed exchange rate related to the purchase order. Otherwise, the rate will be determined based on the rate that is in effect on the date that the product is received. The rate will also be adjusted at purchase invoice with the difference in rate between receive date and invoice date being coded to the foreign exchange gain/loss account.
  2. Select the Vendor SKU No from the list of available products for the selected vendor.
  3. Vendor SKU Name will automatically default from the selected Vendor SKU No.
  4. Product No will be derived based on the selected vendor sku and indicates the product number.
  5. Product Name will default from Product No and displays a description of the product.

  6. Unit Description displays a description of the vendor units being purchased.

  7. Product Name Override is...

  8. Product Type defaults from the selected vendor sku and identifies the type of product that is being purchased.

  9. Select the Freight Type. For a basic purchase order without freight, the type is generally `Included.`
  10. Enter the number of Vendor Units. The units are entered based on how the products are being purchased from the vendor. For example, if the product is supplied in boxes, enter the number of boxes that are being purchased. The system will automatically convert the received boxes to inventory units based on the vendor sku definition.

  11. In the Vendor Unit Price field, enter the purchase price that will be paid for each vendor unit. (Example: Enter the price per box)
  12. Free Units indicates the number of free units that are allocated to the purchase order line. The free quantity is defined as a premium add-on and must be assigned to the vendor sku if applicable.
  13. Total Units is a calculated field that represents the total units to be received. Total Units = Units + Free Units.
  14. Total Add On Price indicates the total amount of premium add-ons for the product. The add-on details are defined on the Premium Add-Ons tab of the child grid.
  15. Total Discounts indicates the total amount of discount add-ons for the product. The add-on details are defined on the Discount Add-Ons tab of the child grid.
  16. Total Tax indicates the total amount of tax for the product and add-ons. The tax codes must be added on the Taxes tab in order for taxes to be calculated. Taxes are estimated at the tie of the purchase order and determined at receipt.
  17. Price is the amount converted to corresponding inventory units.
  18. Total Price represents the total amount of the purchase, including the product, premiums, discounts, and taxes.
  19. If the product is Taxable, the flag must be checked to calculate taxes on the product. The tax code can be optionally added to the Vendor SKU, but must be added to the purchase order for taxes to be calculated.
  20. Pay Basis determines if the vendor is paid based on received units or shipped units. The default is set to Received, but it can be modified..
  21. Select to assign a Freight line if the purchase order product line has Freight Type set to Excluded or Delayed.
  22. From Transport Type, select the method of transportation for the product. Options are: Ground Pickup, Rail, Air, Water, or Ground Delivery. The default is set to Ground Delivery.
  23. Enter the required number of loads In No of Receivings if there is a specified number of loads to deliver the product. Otherwise, if only a single load is required, leave the default value of "0".
  24. In the Begin Receive Date field, enter the earliest date the product can be received. The date will default to the PO date and can be modified as required.
  25. In the End Receive Date field, enter the last date the product can be received. If the period is indefinite, leave the default value.
  26. When the Closed flag is marked, the purchase order can no longer be received, even if the defined quantity has not yet been received. If the Closed flag is checked, the purchase order quantity will no longer appear on the PO Inventory.
  27. In the Comments field, enter any additional comments related to the purchase order.
  28. In the Contract Attachment field, any type of accompanying file can be attached. (Example:Word document, picture, music, or video clip).
  29. Adjustments Units displays a value only if the purchase order has been adjusted using Purchases> Orders> Order Adjustments.
  30. Adjustments Vendor Units displays a value only if the purchase order has been adjusted using Purchases> Orders> Order Adjustments.
  31. Approval Status indicates if the purchase order has been approved.
Additional Purchase Order Details

Within the PO Line No tab, there is a child grid with additional tabs that must be created. The details in the child grid will default from the vendor sku with the option to modify. Click  to display the child grid for the PO Line No.

 

Taxes

Taxes must be added to the purchase order if the taxable flag is marked on the vendor sku or any of the attached premium or discount add-ons. The tax codes can be defined on the vendor sku if the product is only purchased within a single tax district. Otherwise, the taxes can be established on the purchase order. There is validation on the posting of the purchase order to ensure that taxes have been applied to taxable products. The purchase order will not post if the Taxes tab has not been completed for a taxable product or add-on.

  1. Select the Taxes tab.

  2. Tax codes will default from the vendor sku if defined. If not previously defined, click to add tax codes.


  3. Tax No identifies the tax code to be applied to the product and add-ons for the selected line item. The Taxable flag must be selected in the product and add-ons for taxes to calculate.

  4. Tax Name describes the selected tax code.

  5. The Rate will display the tax rate percentage that is in effect on the date that the purchase order is created. The receiving transaction will be recorded based on the tax rate that is in effect on the receiving date. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.

Product Assurance

Product Assurance relates to the assays that will be assigned to the purchase order. Assays are currently only applicable to ingredient products and will default based on the configuration of the ingredient. If the assays have been determined based on Ingredient Versions, then the assay will default from the ingredient version. If the purchase order is assigned to a contract, the assays will be as defined by the contract.

 

 

  1. Assurance No is the code defined for the assay. The assays will default from the product. Any assays that are not required for the purchase order can be deleted.
  2. Assurance Name is a description for the assay that will usually appear on reports and forms.
  3. Testing Location  indicates where the testing process is to be performed. Options are: At Receiving or Lab.
  4. In the Min Value field, enter the minimum acceptable value for the assay. The value will default from the product or ingredient version, but can modified in the purchase order for values specific to the defined agreement.  The type of value is dependent on how the assay is tested such as an acceptable percentage.
  5. In the Max Value field, enter the maximum acceptable value for the assay. The value will default from the product or ingredient version, but can modified in the purchase order for values specific to the defined agreement. The type of value is dependent on how the assay is tested such as an acceptable percentage.
Premium/Discount Add-Ons

In the child grid, there is the option to define the add-ons related to the product. The add-ons must be pre-defined in General>Products>AddOns prior to adding to the vendor sku. The add-ons can be configured to be included in the cost of the product or alternatively, be coded to an entirely different account which is not included in the product cost. Add-ons must be defined on the vendor sku to transfer to the purchase order. If necessary, add-ons can be deleted from the purchase order if not required. Rates can also be modified.

 

 

  1. In the Product No field, select from a list of previously defined add-ons codes. The add-ons will transfer to purchase orders created for the vendor SKU. Add-ons can be found in: General>Products>AddOns
  2. Product Name is a read-only field that displays the description of the add-on product type.
  3. Transaction Basis is a read-only field that defaults from the selected add-on and determines how the add-on is calculated. Options are: Per Unit, Percentage, Flat Rate, or Free Percentage. Free Percentage is currently only used in poultry products.

  4. Payment Type determines when the add-on payment is made.

  5. The Payee Type field is optional. If the add-on is to be processed by an alternative source, select the source type for the add-on. Options are: Customer, Vendor, Employee, or Cost Center. If the field is left blank, it assumes the vendor sku for the payment of the add-ons.

  6. Transaction Entity ID is a required field if a different Payee Type is selected. Select the appropriate vendor or cost center.

  7. Pay Calculation Type determines the base amount of the add-on calculation.  
  8. Vendor Calculation Type determines if the payment is calculated based on the base add-on logic using Transaction basis or if the add-on amount is only deducted from the vendor payment.
  9. The Rate will default as defined on the vendor sku. Modify the rate as required. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.
  10. Taxable identifies if the item is taxable or non-taxable when the item is purchased. Tax codes must be assigned to the purchase order for the taxes to be calculated. Select the flag if the item is taxable.
  11. Currency No defaults in US dollars. Select from the list to change the currency.
  12. Currency Name displays the currency rate that has been selected for the order.
Receivings

The Receiving screen displays the receiving transactions entered for the purchase order. The view is read-only for information purposes only.

 


Invoices

The Invoices screen displays the receiving transactions entered for the purchase order. The view is read-only for information purposes only.

 

Post a Purchase Order

The purchase order must be saved and posted for the product to be received. Posting will also prevent a purchase order from being modified. With proper permissions, a purchase order can be un-posted and posted as many times as required until a receiving transaction has been entered for the purchase order. Once a receiving transaction has been entered, the purchase order can no longer be un-posted.

  1. Click to save the purchase order.
  2. Close the purchase order. If the purchase order has not been saved, the user will be prompted to save the purchase order.
  3. In the Purchase Order index, locate the required purchase order and right-click to select 'Post'. Multiple purchase orders can be posted at the same time by highlighting the required purchase orders and right-click to select 'Post'.
  4. If a purchase order has no planned receivings or receiving transactions, the purchase order can be unposted by selecting the order and right-clicking to select UnPost.

View Purchase Order Inventory

The Purchase Order can be viewed either from the Purchase Order index or from directly within the purchase order. The difference between the two options is that the index will display the inventory for all purchase orders while the option from within the purchase order will only display the inventory for the current purchase order.

 

  1. From the file menu, select Options>Purchase Order Inventory.
  2.  

     

  3. The date prompt will appear with the current date defaulted. The inventory date can be modified as required.
  4. The Purchase Orders Inventory screen appears displaying the quantities available for the selected date. The screen can be filtered and grouped as required.