Freight Products

 

Freight products are created, and then the option is available in the purchasing process to assign the freight to the products. Freight can be included in the inventory cost of the product or optionally expensed to a separate freight account.

 

Prior to creating a Freight Product, the following items should be created.

 

The following features are outlined in this document:

Create a Freight Product

The Freight Products screen has several tabs that must be completed in the creation process.

General

The General tab contains the base data for the product.

 

  1. In General>General>Products>, select Freight.

  2. In the Freight Products index, click to create a new freight product.

  3. Click on the General tab.

 

 

  1. Enter the Product No to identify the product within the system (alphanumeric, max 50 characters).

  2. Enter the Product Name as a description for the product (alphanumeric, max 100 characters).

  3. Category is an optional field where the product an be assigned to a category. The categories must be pre-defined before being assigned to the product, in Admin>Business>General>Definitions>Product Categories.

  4. Freight Type defines how the  freight is calculated. Options are:

    1. Calculated: Amount is calculated based on a unit of measure (Example: Rate per ton).

    2. Distance: Amount is calculated based on a rate per mile or km. Currently, this option is only available for internal freight charges when the distance is defined on the farms.

    3. Load: Amount is calculated and allocated on a per load basis.

    4. Order: amount is calculated and allocated on a per order basis

  5. The Active flag will default as selected. If the product is no longer utilized, the active flag is required to be unchecked.

  6. Products can be Color coded for easy view for planning purposes. If desired, choose the color from the color grid.  

Accounts

The Accounts tab defines the account segments that will be used in each journal process throughout the system. The Account tab for freight defaults with all segments being blank, which means that the freight charges will assume all of the products of the account that it is assigned to in the purchase order. If the freight order is required to go to different accounts, then this needs to be specified on the accounts screen. Alternatively, freight accounts can be added if required. If an account is added, the new account must be created within the Chart of Accounts for the transactions to be processed.

 

Vendors

Before freight can be used in the purchasing process, the vendor/product relationship must be established. A vendor sku must be created for every vendor that charges the defined type of freight. A vendor must have the Transport Vendor flag checked before it can be used as a freight vendor. This option allows the user to define the unit of measure and any additional costs or discounts associated with the freight.  

.

 

  1. Vendor No contains a list of previously defined vendors. Select the vendor where the freight is purchased from.

  2. Vendor Name displays the name of the selected vendor.

  3. In the Vendor SKU No field, enter the code that is used when ordering the freight from the vendor (alphanumeric, max 50 characters).  
    * This is optional and can be the same as the product code; however the vendor SKU must be unique to the vendor.

  4. In the Vendor SKU Name field, enter a description of the freight that is being purchased. The field will be displayed on purchase orders (alphanumeric, max 100 characters).

  5. In the Unit Description No field, select the required unit of measure in which the freight will be purchased. The Unit Description No must be predefined in Admin>Business>General>Definitions>Units of Measure prior to being selected on the Vendors tab. This field is generally only used for calculated freight types where the amount is calculated on a per unit rate.

  6. The Unit Description Name will default based on the selected Unit Description No.

  7. Inventory Units indicates the number of units that will be added to inventory when the vendor unit is received. Distance, Load and Order freight products will all have inventory units of 1.00. Calculated freight must have the units defined. For example, if the freight product is calculated on a per ton basis, the user would enter "1000" for metric ton or "2000" for imperial ton. This will calculate the proper freight rate based on the product units received.

  8.  

     

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

  10. The system will default the vendor SKU as Active. If the product is no longer purchased from the vendor, de-select the option.

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

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

  13. Payment Term No displays the payment terms and defaults from the vendor, with an option to select by product.

  14. Currency No defaults from the vendor and displays the code for the currency, with an option to modify by product.

  15. HS Code represents Harmonized System Code, which is used for international shipments. Enter the code based on the international defined code.

  16. Product Specification is a text field to enter details related to the product vendor SKU.

  17. Product Remarks is a text field to enter any other details specific to the vendor sku.

Additional Vendor Options

In the child grid within the Vendor No, 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. Depending on how the add-ons are configured, the cost of the add-on can be included or excluded from inventory cost of the product. 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.

 

Vendor Premium/Discount Add-Ons

There are two types of add-ons:

 

 

  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 only used for 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 a 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 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. Rate is an optional field to enter a default rate for the add-on. The rate will default to contracts and purchase orders for the vendor, and can be modified as required.

  8. Taxable identifies if the item is taxable or non-taxable when the item is purchased. Tax codes must be assigned to the sales order for the taxes to be calculated.

Tax Codes

If the freight and/or add-ons are taxable, the tax codes can optionally be defined at the vendor sku. It is recommended that the tax codes are only entered on the vendor sku if that vendor only delivers within the same state or province, as different tax rate can be applied depending on the destination. Tax codes must be previously defined. Rates will default to the purchase order based on the rate that is in effect on the purchase order date.

 

 

  1. Tax No is selected from the predefined in Admin>Business>General>Definitions>Tax Codes. The tax code will default to purchase contracts and purchase orders for the vendor sku.

  2. Tax Name defaults from the selected Tax No.

 

Freight Product Options

There are three options available for freight products:

 

Reset Default Accounts

The Reset Default Accounts sets the Product>Accounts tab back to the system defined default accounts. This process can be initiated from the index list or directly within the product.

 

  1. Click on the required product from the index or edit the required product.
  2. From the toolbar, select Options>Reset Default Accounts.
  3. The process will reset the accounts to the system defined default accounts. Note that the default system accounts for freight are undefined, so all accounts will be cleared from the Accounts tab.

 

Modify Vendor SKU Add-on Prices

The Modify Vendor SKU Add-on Prices option allows the user to modify the add-on prices from a single data entry screen rather than having to access each product to modify the prices. The feature can be initiated from the product type index to only change add-ons for that specific product type or from General>Products>Master to change the add-on prices for all product types in one screen.

 

  1. From the product index, select Options>Modify Vendor SKU Add-on Prices.
  2. In the Add Ons grid, select the add-on that is required to be modified.
  3. The Modify Product Vendor AddOn Rates will display all of the vendor skus for the selected add-on.
  4. Enter the modified rates on the required vendor sku.
  5. Click OK to update the rate on the vendor sku. This rate will be used for all new purchase orders, but will not be modified on posted purchase orders.

 

 

Auto Refresh

The Auto Refresh option is selected by default. This option updates the index immediately when changes are made to the products. If the auto refresh option is not required, de-select the option and the index must be manually refreshed by the user.

 

  1. From the product index, select Options>Auto Refresh.
  2. If the option is checked, the auto refresh feature is turned on.
  3. Click on the Auto Refresh option to turn the feature off.