Field Products

Field products are products that are utilized at the farm such as medications, vaccinations and other miscellaneous supplies. Field products can be purchased and received to any facility or farm. There are two types of field products that are utilized. The process for setting up the products is the same with the exception of the inventory flag to determine if the product is maintain in inventory or not.

 

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

 

The following features are outlined in this document:

Create a Field Product

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

General

The General tab defines the basics about the product.

 

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

  2. In the Field Products index, click to create a new field product.

  3. Click on the General tab.

 

  1. Enter the Product Type. This option will default in the proper account codes for the selected product type. Options are: Field Products, Medication, or Vaccinations.

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

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

  4. The Active flag will be selected by default. If the product is no longer utilized, de-select the Active flag.

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

  6. If the product is an Inventory product, check the box. Field products can be defined as either inventory or non-inventory products.

  7. The Requisition flag determines if the product is available for the Material Resource Planning (MRP) process.

  8. Field products can be defined as Medicated. If the medicated option is selected, there must be a prescription created for the farms or entities that are using the medicated product.

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

  10. The Manufacturer field is optional and can be used to assign the manufacturer of the product. This is generally used for medications and vaccinations, and manufacturers must be pre-defined before selection.

  11. Usage Method is used to define how the product is used (Example: Oral or Injected). This field is optional, and usage methods must be pre-defined in Admin>Business>General>Definitions>Usage Methods before selection.

  12. WD Days is an optional field used to determine the number of days before processing that the product must be withdrawn.

  13. In the Notes field, enter additional comments related to the product.

  14. Active Ingredients is an optional field used to identify the active ingredients for the product.

  15. Purchases Max % Over is used when the product has a tolerance percentage for the receiving transaction. (Example: The purchase order has 100 units. Max % Over is defined as 5%, which means the receiving transaction will allow up to an including 5 additional units).

  16. Purchases Allow Any % Over can be selected if there is no limit and the purchaser can receive any quantity over the product units.

  17. Sales Max % Over is used when the product has a tolerance sales amount for the receiving transaction. (Example: The sale order has 100 units and the Sales Max % Order is defined as 10%, which means the shipment transaction will allow for an additional 10 units to be shipped).

  18. Sales Allow Any % Over is selected when there is no limit of shipping product units over what the customer has ordered.

  19. Hand Held is selected if the product is used with FlockTrack which are handheld devices used to transfer data from the field to MTech.

Animal Usage

The Animal Usage tab provides the option to define the modules and stages that utilize the field product. At least one option must be selected for this tab before the product can be saved.

 

 

  1. Click on the Selected flag to indicate the stages where the field products are used. At least one stage must be selected for the product to be saved.

Accounts

The default accounts established for the products are defined on the accounts tab. These will be displayed when the product is created.  These accounts can be configured as required although it is recommended that only the Cost Element and User Element be modified. Non-inventory products may require additional accounts to be added depending on how the expense for the product is to be recorded.

 

Depending on the product type selected in the general screen, the Debit Element and Credit Element will be defined as follows:

 

 

Vendors

Before a product can be purchased, the vendor/product relationship must be established. This option allows the user to define the unit of measure and any additional costs or discounts associated with the product. If the product is purchased from the same vendor in different units, a vendor sku must be created for each unit.

 

 

  1. Vendor No contains a list of previously defined vendors. Select the vendor where the product 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 products 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 product 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 product 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. Examples: tons, lbs, drum, box, dose, etc.

  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. (Example: If a box of 20 units is purchased from the vendor, the user will receive 1 box and the inventory will be increased by 20 units). This value defaults based on the selected Unit Description No.

 

 

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

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

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

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

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

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

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

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

  9. 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. AddOns 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, and Flat Rate. There is a Free Percentage option also available, however that option is only used in poultry products.

  4. Payment Type determines when the add-on payment is made. Options available are:

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

Tax Codes

If the product 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.

Sales

If the product is sold to external sources, a sales sku must be created prior to creating a sales order.

 

 

  1. In the Sales SKU No field,enter a unique code that will be used in creating sales contracts, orders, and price lists (alphanumeric, max 50 characters). This is optional and can be the same as the product code, however the sales sku must be unique within the Sales tab.

  2. In the Sales SKU Name field, enter a description for the sales SKU. This will normally print on orders and invoices (alphanumeric, max 100 characters).

  3. In the Unit Description No field, select the required unit of measure that the product will be shipped. The Unit Description No must be predefined in Admin>Business>General>Definitions>Units of Measure prior to being selected on the Sales tab.

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

  5. Inventory Units indicates the number of units that will be removed from inventory when the sales sku is shipped. (Example: If a box of 20 units is shipped, the user will enter 1 box, and the inventory will be decreased by 20 units). This value defaults based on the selected Unit Description No.

  6. New sales skus' will default as Active. If the sales sku is no longer required, de-select the Active flag.

  7. If the product is Taxable, the flag must be checked in order for taxes to calculate on the product. Tax codes must be entered on the price list, sales code, sales contract, or sales order for the taxes to be calculated.

 

Copy Sales SKU No

There is also functionality included so that the sales SKU number can be duplicated to create more sales SKU lines.

  1. Select the Sales SKU No line, right-click and select `Copy Sales SKU`.
  2. The product will appear as a `Duplicate` line.

 

Additional Sales Options

In the child grid within the sales sku, there is the option to define additional details such as added charges, discounts or commissions on the product.

Sales Premium / Discount AddOns

The add-ons must be pre-defined before adding to the sales sku. The add-ons can be configured to be included in the revenue of the product or alternatively, be coded to an entirely different account which is not included in the product revenue.

 

 

 

  1. In the Product No field, select from a list of previously defined premium add-on codes. AddOns must be selected on the sales sku before being transferred to a contract, price list, or order. AddOns must be predefined in General>Products>AddOns.

  2.  Product Name displays the description of the selected add-on as defined.

  3. The 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:

  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 customer for the add-ons.

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

  7. Taxable Flag 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.

  8. Select Print on Invoice if the add-on is to be printed on the default system invoice. If the add-on is not to be printed on the invoice, the option should not be selected. This option can be further defined in price lists.

Commissions

Commissions are a type of add-on that is typically used to pay employees or other parties based on a percentage or per unit amount.

 

  1. In the Product No field, select from a list of previously defined premium add-on codes. AddOns must be selected on the sales sku before being transferred to a contract, price list, or order. AddOns must be predefined in General>Products>AddOns.

  2.  Product Name displays the description of the selected addon as defined.

  3. The Transaction Basis is a read-only field that defaults from the selected addon and determines how the addon is calculated. Options are: Per Unit, Percentage, Flat Rate, or Free Percentage.

  4. Payment Type determines when the add-on payment is made. Options available are:

  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 customer for the add-ons.

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

  7. Taxable Flag 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.

Bill of Materials

The Bill of Materials tab is used to determine the products that must be used to ship the field product. Based on the products that are entered in this tab, the system will create automatic usage transactions for the products required to ship the field product

 

 

  1. Product Type determines the type of product that will be used in the Bill of Materials. Any inventory product type can be selected.

  2. Based on the selected product type, a list of available products will be available. Select the Product No that is required for the product to be shipped.

  3. Product Name will default based on the selected product.

  4. Inventory Units determines how many product units are required for each Bill of Material product. For example, in the first Cardboard Box example above, one small cardboard box will be required for every 25 units. Therefore, if 5 boxes are shipped, 125 product units  will be used.

Instructions

Instructions are default comments that are applicable to the product. These instructions are predefined in Admin>Business>General>Definitions>Instructions. Instructions are generally used to print on specific documents such as sales confirmations, invoices and hatchery work orders.

 

 

  1. From Instruction No, select the instruction for the product that. Instructions are predefined in Admin>Business>General>Definitions>Instructions.

  2. Instruction Name displays the description of the selected Instruction No. The Instruction Name will be the text that prints on the various forms or reports.

  3. If the instruction is to print on the default system invoice, select the Print On Invoice option. If the instruction is not required to print on the default invoice, the option is not selected. These options can also be used in custom reports.

Internal AddOns

Internal add-ons are used when transferring products between facilities.  The add-on must be defined on this tab before the pricing is established in Internal Pricing.

 

 

  1. From Add-On Type, select whether the internal add-on is a premium or discount add-on. Premium will increase the cost to the destination cost center while the discount will reduce the cost to the destination cost center.

  2. In the Product No field, click the box to select from a list of previously defined premium or discounts add-ons.   

  3. Product Name displays the description of the selected add-on as defined.

  4. The 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.

  5. Payment Type determines when the add-on cost is recorded. Options available are:

  6. The Payee Type field is only required if the Payment Type is set to Internal. If this is the case, then the Payee Type should be set to Cost Center.

  7. Transaction Entity ID is a required field if a Cost Center is selected as the Payee Type. Select the cost center that will receive the debit or credit for the add-on amount.

  8. If the Rate is standard for all transactions, enter the rate in this field. If the rate is defined by cost center, then rates must be applied in Internal Pricing.  

  9. Accrual is selected if the amount of the add-on is reversed at period end with the internal price of the product. There is a separate period end task that will reverse any add-ons with the accrual option selected. If the option is not selected, the cost of the add-on will not be reversed at period end.

Internal Mappings

Internal mappings are not used when creating a field products.

Cost Centers

The system has the ability to identify which cost centers the product applies to. If none of the options are checked, then the product can be supplied to all facilities. If one or more cost centers are selected, then the product can only be utilized at that facility.

 

 

  1. In the Selected field, select the cost center (s) for which the product will be required.

 

Field Product Options

There are three options available for field 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.

 

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.