Finished Feed facility transfers

 

Facility transfers are used to transfer feed formulas from mill to mill. The source mill will be credited at the defined feed formula price and adjusted to actual cost at global post. The destination mill will be debited at the defined feed formula price with no adjustment to actual cost. Internal add-ons can be defined for expenses such as storage or internal delivery. External freight can be added to the transaction using a purchase order. Weights are incorporated into the transaction so that scales can be used at source and destination mills. Silo and lot tracking can be used in facility transfers. The Facility Transfer involves two transactions. First the feed formula must be transferred out of the source mill and then transferred into the receiving mill. There is a registry switch in Product Type that allows the receiving transaction to be automatically created rather than manually having to create the receiving transaction.

 

A Finished Feed Receiving transaction must be created and posted before a Finished Feed Facility Transfer can be created.

 

The following procedures are outlined in the Facility Transfer document:

Create a Facility Transfer

The first stage in the process is to create the transfer out from the source to the destination facility.

Facility Transfer Header

The first step in the facility transfer process is to create the transfer-out facility transfer. The transfer header in this transfer record contains the base data to outline the facility transfer. The header is divided into three sections to group the data:

 

  1. In FMIM>Transactions>Feed Production, select Facility Transfers.
  2. In the Facility Transfers main index, click to create a new facility transfer transaction.

 

 

General

  1. Click on the General tab.
  2. In the Transfer Date Time field, enter the date and time the product will transfer out from the feed mill.
  3. From Src. Feed Mill No, select the feed mill from where the product will be transferred from.
  4. From Dest. Feed Mill No, select the feed mill that will be receiving the product.
  5. Ref No is an automatically generated unique reference number used to identify the transfer-out transaction.
  6. From Haulage Vendor No, enter or select the haulage vendor. This field is optional and is only used if an external vendor is used to transfer the product between facilities. A Freight-Only Purchase Order must first be created.
  7. Complex PO No is only used if  an external vendor is used to transfer the product between facilities and displays the selected freight purchase order. Purchase orders must be in 'Posted' status for the freight PO to be selected.
  8. If a haulage vendor is selected, click on the Select Haulage PO flag. From the Freight Only PO dialog box, select the required purchase order and then click 'OK'. The process will populate the Complex PO No field.
  9. If applicable, from Driver No, enter or select the driver who will be transferring the feed formula. The driver must be assigned as a transfer driver and be set up prior in: Admin>Business>General>Definitions>Drivers.
  10. If applicable, from Vehicle No, enter or select the vehicle that will be used to transfer the product. Vehicles must be set up prior in: Admin>Business>General>Definitions>Vehicles.
  11. If applicable, from Trailer No, enter or select the trailer that will be used to transfer the product. Trailers must be set up prior in: Admin>Business>General>Definitions>Trailers.
  12. External Vehicle is an optional field to identify an external vehicle that will transfer the product. This is a text field with no validation.
  13. External Driver is an optional field to identify an external driver that will transfer the product. This is a text field with no validation.
  14. In the Comments field, enter any additional information related to the transfer-out transaction.
  15. Selecting the Void flag will cancel the transfer transaction.

Amounts

The fields in the Amounts tab are optional and only populated if the weigh scale is used in the Facility Transfer transaction.

 

  1. Scale No is an optional field to enter the scale on which the truck was weighed. Select the scale from the drop-down menu, if desired. Scales are defined in: Admin>Business>General>Definitions>Weight Scales.
  2. Scale Operator No identifies the user that recorded the scale weights. Scale operators must be previously defined in: Admin> Business> FMTS> FMIM> Scale Operators.
  3. Gross is the total weight of the vehicle and the product. The button is used if there are scales integrated to the transfer process.  This field can be manually entered or interfaced from a scale.
  4. Tare is the tare weight of the vehicle. The button is used if there are scales integrated to the transfer process. This field can be manually entered or interfaced from a scale.
  5. Net is the difference between gross and tare. This field can be manually entered or, if weights are entered, it is calculated automatically.
  6. Gross Weight Date Time displays the date and time that the gross weight was recorded at the scale.
  7. Gross Weight Scale Ref displays the reference number for the gross weight scale reading.

  8. Tare Weight Date Time displays the date and time that the tare weight was recorded at the scale.

  9. Tare Weight Scale Ref displays the reference number for the tare weight scale reading.

  10. Gross Auto Manual determines if the gross scale readings are Auto or Manual.

  11. Tare Auto Manual determines if the tare scale readings are Auto or Manual.

  12. Gross Zero Weight is used if a zero weight is required.
  13. Gross Zero Weight Date Time indicates the date and time that the gross zero weight was recorded.

  14. Gross Zero Weight Scale Ref is a reference number generated from the scale for the gross zero weight.

  15. Tare Zero/Tare Zero Weight Button is used if a tare zero weight is required.

  16. Tare Zero Weight Date Time displays the date and time that the tare zero weight was recorded at the scale.

  17. Tare Zero Weight Scale Ref is a reference number generated from the scale for the tare zero weight.

  18. Bill-To Customer No identifies the bill-to customer.

  19. Ship-To Customer No identifies the ship-to customer.

  20. Deliver-To Customer No identifies the deliver-to customer.

  21. Customer PO No identifies the customer purchase order.

Derived

The fields in the Derived tab are automatically generated and cannot be modified.

 

  1. Trans Code displays the type of transfer. This will automatically default to 'Transfer Out'.
  2. Src Feed Mill Name displays the name of the feed mill that is transferring out the product.
  3. Dest Feed Mill Name displays the name of the feed mill that will be receiving the product.
  4. Haulage Vendor Name displays the name of the haulage vendor, if applicable.
  5. Driver Name displays the name of the driver who will be delivering the product, if applicable.
  6. Vehicle Name displays the vehicle that will be used to deliver the product, if applicable.
  7. Trailer Name displays the trailer that will be used to deliver the product, if applicable.
  8. Scale Name displays the scale on which the truck was weighed.
  9. Scale Operator Name displays the name of the operator that weighed the vehicle.
  10. Status is automatically set in the process when the vehicle is weighed. Options are: No Weight, In  Process, and Complete.
  11. Distance is calculated if there is a freight charge by distance. This option is not available for feed mill facility transfers.
  12. Freight Pay Basis indicates if the freight is paid based on received weight or shipped weight, and is derived on the freight product assigned to the purchase order, if applicable.
  13. Freight Type determines how the freight is calculated. Options are: by Load, Calculated, or Per Unit.
  14. Price displays the total feed formula amount. Price = Units Transferred x Unit Price.

  15. Add On Price displays the total price of the internal add-ons as defined in Feed Formula Prices.

  16. Freight Units indicates the freight units that are charged. For example, if the freight is charged by load, the value would be 1 load.

  17. Freight Unit Price displays the amount of freight per unit.

  18. Freight Price displays the base price of the freight and indicates the total freight charges before add-ons and taxes.

  19. Freight Premium Add Ons displays the amount of premium freight add-ons on the transaction.

  20. Freight Discount Add Ons displays the amount of discount freight add-ons on the transaction.

  21. Freight Tax Price displays the price of tax on the freight.

  22. Freight Total Price displays the total price of the freight including add-ons and taxes.

  23. Total Price displays the total price of the transaction including add-ons and freight.

  24. Bill-To Customer Name displays the name of the bill-to customer.

  25. Ship-To Customer Name displays the name of the ship-to customer.

  26. Deliver-To Customer Name displays the name of the deliver-to customer.

  27. Selecting the Void flag will cancel the transfer transaction.
  28. Creation Date indicates the date the transaction was created.
  29. Last Mod Date indicates the date the transaction was last modified.

Facility Transfer Details

After completing the header of the transfer, the Details tab also must be completed in the creation process. The Details section has several tabs:

  1. Click on the Details tab and select   to create a new line detail.
  2. The Transfer Out Destination screen will display all feed formulas for the source feed mill.
  1. Select the Feed Formula to be transferred out.
  2. Click 'OK'. This will automatically create the transfer-out line detail. Any internal add-ons as defined in Feed Formula Prices will also appear in the child grid.

Details

 

  1. Formula No displays the unique pre-defined number of the feed formula that is being transferred.
  2. Formula Name defaults from Formula No and displays a description of the feed formula.
  3. Storage Mode indicates the method of storage, and will default in according to the Formula No  selected.
  4. Enter the Silo No where the feed formula is located if silo tracking in used by the source feed mill.
  5. The Silo Name will default based on the selected silo.
  6. Lot No is a unique identification number for the feed formula.
  7. Enter the Weight in inventory units that are being transferred. If the feed formula is a bagged feed, then the weight will be automatically calculated based on the number of bags entered in the Bags field.
  8. Unit Value is the per inventory feed formula price established for the feed formula. The source mill will be valued at feed formula price until global post is run to adjust the source mill to actual cost. The destination mill will remain at feed formula price with the difference going to an overhead variance account at the source mill.
  9. The number of Bags required can be entered if the storage mode is Bagged.
  10. The Bagged Unit Value will be calculated based on the Price/Bags.
  11. Price is a calculated field representing the feed formula amount prior to add-ons and taxes. Price = Quantity x Unit Value.
  12. Add On Price is the total price of the add-ons as defined in Feed Formula Prices.
  13. Freight Price is the total price of the freight. The freight will be either based on the freight cost assigned to the feed formula price for the transferred feed formula or the purchase order.
  14. Total Price displays the total price of the transaction including add-ons.
  15. Complex PO No can be used to select the complex purchase order.
  16. Sales SKU No can be used to selected the sales sku product.
  17. Sales SKU Name will default in from Sales SKU No.
  18. Sales SKU Unit Description No and Name will default in from the selected product.
  19. Sales SKU Units Per displays the number of units per sales sku product.
Additional Details

Within the Details tab, there is a child grid with additional details relating to the transfer add-ons. Any add-ons must be previously defined in Feed Formula Prices.

 

 

  1. Click on the feed formula No  to display the child grid.
  2. Add On Type displays the type of add-on. Options are: Premium or Discount.
  3. Product No displays the code for the type of add-on product
  4. Product Name defaults from Product No and displays a description of the add-on.
  5. 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 or Flat Rate.
  6. Payee Type is an optional field that indicates the source type for the add-on. The only option available for internal add-ons is 'Internal' which will allow the add-on to be debited or credited to another cost center within the system. This field must be defined in Feed Formula Prices for the feed formula.
  7. Transaction Entity ID is a required field if a different Payee Type is selected, and is defined on Feed Formula Prices. The Transaction Entity ID will contain the cost center that is debited or credited for the add-on amount.

  8. Rate is the add-on price entered based on the Transaction Basis. Per Unit will be a rate per inventory unit. Percentage will be a percentage of the Price field. Flat Rate will be a defined amount that is charged.

  9. Price is the total price of the add-on and calculated based on the transaction basis and the assigned rate.

Freight Premium/Discount Add-Ons

The add-ons in this screen will default based on the values defined in the Freight Only Purchase order that was assigned to the transfer. These fields will not be populated if there is not an external haulage vendor associated with the transaction.

 

 

  1. Product No displays the add-on product that has been assigned to the freight vendor sku.
  2. Product Name defaults from Product No and displays a description of the add-on.
  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 or Flat Rate.
  4. Payee Type is an optional field that indicates the source type for the add-on. Optionally, the add-on can be charged to a separate vendor or cost center.
  5. Transaction Entity ID is a required field if a different Payee Type is selected. If Payee Type is set, the selected  vendor or cost center name will appear in this field.

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

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

  2. Taxable identifies if the item is taxable or non-taxable when the add-on is purchased.

  3. Currency No defaults based on the currency assigned to the freight-only purchase order, with no option to modify. Currency Name defaults from Currency No and displays a description of the currency type.

  4. Amount displays the total cost of the add-on.

Freight Taxes

If the product or add-ons are taxable, the tax code must be assigned on the Taxes tab. The tax amount will then be calculated based on the taxable order amounts.

  1. Tax No identifies the tax code to be applied to the product and premiums/discounts for the selected line item. The Taxable flag must be selected in the feed formula and premiums/discounts for taxes to calculate.

  2. Tax Name describes the selected tax code.

  3. Amount is the total amount of tax applicable on the feed formula.

  4. Click to save the transfer transaction, and then close the transaction.

Create a Transfer-In Facility Transfer

After the Transfer-Out Facility Transfer has been created, the Transfer-In Facility Transfer needs to be completed. There is an option in Registry> Product Type> Facility Receiving Transfer Mode which will automatically create the Transfer In transaction if selected.

 

  1. Select the required transfer-out transaction, right-click, and select 'Receive'. Alternatively,  if the Switch is set to ‘Automatic’, it is not necessary to right-click, as the transfer-in transaction will be automatically created. Selecting 'Receive' is only required if automatic switch is not selected in set-up.


  2. This process will create the transfer-out facility (Receiving transaction). All details in the header and details will derive from the transfer-in transaction.

  3. Save the transaction.

 

Post a Facility Transfer

Once the facility transfer has been created and saved, the transfer needs to be posted. The posting process locks the transaction to prevent edits, and creates the journal transaction to record the transfer of costs from one mill to the other. The UnPost option unlocks the transactions and reverses the journal transactions. Feed Formula Facility Transfers can only be posted in if the Global Post period is Active or Reversed.

 

  1. In the Facility Transfer index, select the required transfer-out facility transfer and right-click to select 'Post'.
  2. To un-post a transaction, select the required transaction and right-click to select 'UnPost' or select Options>UnPost. This process will set the transaction status to Reversed which allows the transaction to be edited. The unposting process will also reverse the journal transaction created in the post process.

Journal Transaction

The posting process creates the journal transaction. The journal process will credit the source feed mill inventory and debit the destination feed mill inventory. The initial journal will credit the source mill for the feed formula at the defined feed formula price and debit the destination mill.

 

Debit Destination Feed Mill Finished Feed Inventory @ Feed Formula Price
Credit Source Feed Mill Finished Feed Inventory @ Feed Formula Price

 

 

Global post will adjust the source mill for the actual feed formula cost in the period. The destination mill will remain valued at the feed formula price. The only exception to this is feed depots, where there is validation in global post that the feed depots are valued at the end of the global post process allowing the destination transaction to be valued at actual price.

 

Debit/Credit Source Feed Mill Finished Feed  Inventory
Credit/Debit Source Feed Mill Feed Mill Variance-Transfer Adjustment