Purchase Contracts

Contracts are optional in the purchasing process. Contracts are agreements between the company and the vendor to supply the product at an agreed quantity and price. Contracts are product-specific, which means that only one product can be defined on the contract. As quantities are released to purchase orders, contract inventory levels are maintained until all of the quantity has been used.  All details related to the product default from the vendor sku defined on the product. A contract must be in 'posted' status to be available for purchase orders. Contracts cannot be received unless a purchase order is derived from the contract.

 

Prior to creating a Purchase Contract, the following items should be created.

 

The following procedures are outlined related to contracts:

Create a Purchase Contract

  1. In General>Purchases, select Contracts.

  2. In the Purchase Contracts index, click to create a new purchase contract.

  3. Click on the General tab.

Contract Header

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

 

General

The General tab contains the base data for the purchase contract.

 

  1. Contract No is an auto-assigned unique number that identifies the contract.  

  2. Supplier Ref No is an optional field that can be used to identify the vendor agreement number.

  3. Select the Contract Date from the drop-down calendar to identify the date the contract was initiated.

  4. Select the Delivery Date to identify the date the order will be delivered.

  5. Select the Expiration Date to identify the last date that the contract can be used. Purchase orders cannot be created after the expiration date, even if there are quantities left on the contract . The expiration date defaults to one year from the contract date.

  6. Select the Contract Type to indicate the type of contract being created. Contract pricing is generally used in commodities. This selected option is used only for filtering and reporting and does not have any additional associated logic. Options available are Futures or Producers.

  7. Payment Mode indicates whether the contract is paid for based on purchase order transactions or if there is a pre-defined payment schedule. Options are: Purchase Order or Payment Schedule. The logic is currently not implemented for this option.

  8. Price Mode determines where in the purchase process the price can be modified. Available options are:

    1. Contract Price: Will only allow the price to be changed on the contract.

    2. PO Price: Defaults the contract price to the purchase order, but allows the user to change the price on the purchase order

    3. Invoice Price: Allows the user to modify the amount on the contract, purchase order or purchase invoice.

    4. Market Price: Establishes the price based on the selected market price table and effective rate on the receive date.

  9. From Vendor No, select the Vendor that is assigned to the contract.

  10. Vendor SKU No indicates the product that will be purchased. A list of vendor skus assigned to the vendor will be displayed in the list. Vendor skus must be created on the applicable product before being purchased.

  11. In the Vendor Units field, enter the contract quantity in the vendor unit of measure. For example, if the vendor sku is in tons, enter the number of tons.

  12. In the Vendor Unit Price field, enter the price assigned to the contract that is to be paid for each vendor unit. This field is only applicable if Price Mode is set to Contract Price, PO Price or Invoice Price. If Price Mode is set to Market Price, then the price will be displayed as 0.00 and valued on the effective price based on the receiving date.

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

  14. Currency No defaults in US dollars. Select from the list to change the currency.

  15. 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 contract. 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.

  16. Select the Buyer that is assigned to the contract. Buyers are created in: Admin>Business>General>Definitions>Buyers.

  17. From the Broker drop-down menu, select the broker that is assigned to the contract. Brokers are created in: Admin>Business>General>Definitions>Broker.

  18. 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.

  19. Pay Basis determines if the vendor is paid based on received units or shipped units. Select the required pay basis type.

  20. Complex Market No sets the market price table and futures table for the contract. Complex Market No can only be set if  Price Mode is set to Market Price.

  21. Basis Price is used with Market Price Mode, and sets the basis price for the contract. The received price will be the market price +/- the pay basis.

  22. Price Mode Override is an option used for Market Price Mode. If this option is selected, then the basis point can be modified by selecting  an alternative market price table in the purchase order.

  23. In the Comments field, enter any additional comments related to the contract (alphanumeric, max 2000 characters).

  24. Price Basis Mode is used for Market Price Mode to indicates whether the market price is established based on received date or shipped date.

  25. Select Void to nullify the contract.

  26. Select Closed  to manually close the contract if required. The contract will automatically expire when the date expires or the quantity of the purchase contract is at zero. If the contract is required to be closed prior to either this, click the Closed flag to complete the contract.

  27. In the Attachment field, any type of file can be attached (I.e. Word document, picture, music or video clip).

Freight

The Freight section of the header contains the freight details for the contract if applicable.

 

  1. Freight Type determines how the freight cost is allocated to the contract. Options are:
      1. Included: Indicates that the sales unit includes the cost of the freight, or there are no additional freight charges.

      2. Excluded: Indicates that there will be additional freight charge. The haulage vendor and rate is known when the purchase contract is created.

      3. Delayed: Indicates that there will be additional freight charges. The haulage vendor and the rate is not confirmed at the time the purchase contract is created.

  2. The  Freight Price Mode determines where in the process the freight price can be changed. This is independent of the product price mode.

      1. Contract Price: Will only allow the price to be changed on the contract.
      2. PO Price: Defaults the contract price to the purchase order, but allows the user to change the price on the purchase order
      3. Invoice Price: Allows the user to modify the amount on the contract, purchase order or purchase invoice.
  3. Click the drop-down in Freight Vendor No to select  from a list of previously defined haulage vendors. Vendors must be previously defined in General> Master Data> Vendors and also must have the Transport flag selected on the vendor master record to indicate that is it a transport vendor.

  4. Enter the Freight Vendor SKU No to identify the freight product for the contract. The vendor must be assigned to the freight product in Products>Freight prior to selecting in contracts.

  5. Freight Vendor SKU Name will automatically default from the selected Freight Vendor SKU No

  6. In the Freight Price field, enter the freight rate based on the Freight Type defined for the freight product.

  7. Freight Unit Description will automatically default based on the selected vendor sku.

  8. Freight Payment Term will default based on the selected haulage vendor. The user can optionally modify the payment terms for the contract.

Additional

The fields in the Additional tab will automatically generate  based on the selections in the previous two tabs - General and Freight. The Additional fields cannot be modified.

 

  1. Vendor SKU Name displays the product name for the selected vendor sku.

  2. Unit Description displays the units that the vendor sku is purchased in. Examples: Tons, Tonnes, Boxes, lbs, kgs, etc.

  3. Product Name represents the product type of the selected vendor sku. Examples: Ingredients, Field Products, Feed, Eggs, etc.

  4. Buyer Name displays the name of the selected buyer.

  5. Vendor Name displays the name of the vendor that is assigned to the contract.

  6. Currency Name displays the currency rate that has been selected for the contract.

  7. Price represents the Vendor Units x Unit Price. This will be the product cost before any add-ons, discounts, or taxes.

  8. Free Quantity displays the amount of any applicable free quantity that is allocated to the contract. This field generally applies to chick products. Free Quantity is calculated using a premium add-on with Transaction Basis set to Free Percentage.

  9. Total Quantity represents Vendor Units + Free Units.

  10. Total Premiums calculates the total premium add-ons assigned to the vendor sku. Add-ons must be defined on the product vendor sku to be available on the contract.

  11. Total Taxes represents the total calculated taxes if taxes are assigned to the contract. Taxes are optional at the contract level.

  12. Total Price represents the total value of the contract and = Price + Premium Add-Ons - Discount Add-Ons + Taxes.

Contract Details

After completing the header of the contract, there are several tabs in the Purchase Contract screen that also must be  completed in the creation process. The majority of the data defaults from the vendor sku with the option to modify. It is important to note that add-ons cannot be added in the contract screen. The add-on must be assigned to the vendor sku to be used in the contract.

 

Add-Ons

Premium and discount add-ons default from the vendor sku. Add-ons must be defined on the vendor sku to transfer to the contract. If necessary, add-ons can be deleted from the contract if not required. Rates can also be modified.

 

 

  1. In the Product No field, the add-ons will default from the selected vendor sku. The add-ons will transfer to purchase contracts 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. Options available are:

    1. Transaction: Processed at time of receiving and will be included in the vendor payment.

    2. Rebate: Will record accrual amount at time of receiving but will not transfer to the invoice. Payment/invoice will be processed at a later date.

    3. Internal: An internal transaction that is not invoiced to an external source  (Example: There is an internal haulage department that gets a credit for hauling products).

  5. The Payee Type field is optional. If the add-on is to be processed by an alternative sources, 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 defaults from the vendor sku and determines the base amount of the add-on calculation.
    1. Product Amount - the add-on is calculated based on only the product amount and does not include any other add-on in the calculation of the amount.

    2. Net Amount - the add-ons is calculated based on the net amount of the transaction based on the product amount including other add-on amounts, but excluding taxes.

  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.
      1. Normal - the add-on is calculated based on the rules established by Transaction Basis and the Payment Type defined in the vendor SKU and sales SKU.

      2. Deduction Only - the add-on is calculated based on the rules established by Transaction Basis, however the add-on is only deducted from the vendor payment.

  9. 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.
  10. The Rate will default as defined on the vendor sku. Modify rate as required. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.
Taxes

Taxes can be optionally added to the contract. Taxes should only be added to the contract if the supply is being distributed to cost centers within the same tax zones. The taxable flag needs to be selected on the vendor sku for the taxes to be applied.

 

 

  1. Click on the Taxes grid and then select to select the Tax No for the applicable tax.
  2. Tax Name will default based on the selected Tax No.
  3. Amount will default based on the rate that is in effect when the contract is created. The rate will be automatically updated at purchase order and receiving if the rate changes.
Product Assurance

Product Assurance relates to the assays that will be assigned to the contract. Assays are currently only used for ingredient products.  The assays will default from the ingredient version if defined or from the ingredient if there are no assays defined on the ingredient version. The user has the option of selecting and defining the assay parameters for the contract.

 

 

  1. The assays defined on the product will default as defined on the ingredient product. If there are additional assays for the current contract, click on the Selected flag. The assay must be added to the Products>Ingredients>Assays prior to being available on the contract.
  2. Enter the acceptable Min Value and Max Value for the contract if the value is different from the default.
Delivery Schedules

The Delivery Schedule allows the contract quantity to be assigned to cost centers and defined by a delivery date schedule. If a Delivery Schedule is defined, the purchase orders for the contract will be automatically created when the contract is posted.

 

 

  1. From Cost Center No, select the cost center that will be receiving the product.

  2. Cost Centers Name displays the description of the selected cost centers.

  3. Enter the number of vendor Units to be received for the product.   The units entered in Delivery Schedules must equal the total units in the contract.

  4. The Begin Receive Date, will default from the header value. The date can be modified if required.

  5. The End Receive Date, will default from the header value. The date can be modified if required.

  6. Enter the Number of Receivings to define the number of receiving transactions for the delivery schedule. If not defined, the default value of "0" will apply.

Receivings

The Receivings tab will display all of the receiving transactions for the contract.

 

 

Posting Purchase Contracts

Once the contract has been entered and the data verified, the contract can be posted. Posting the contract will complete the following tasks:

 

There are two options available to post the contracts.

 

  1. In the Purchase Contract index, click on the contract to be posted. Optionally, several contracts can be selected to be posted at the same time by highlighting the required contract using the Shift or Ctrl options on the keyboard.
  2. Select the appropriate post option to complete the process.
  3.  

    • Select and then select Post Record(s)
     
    • Right-click and select Post
     

     

  4. Once the contract is posted, the contract is available in Contract Inventory and purchase orders may be created using the contract.