ingredients consignment transfers

Consignment purchases occur when a vendor supplies goods to a customer, however the vendor is not paid until the product is used. When the product is received, the product is received to consignment inventory. The Consignment Transfer moves the product from consignment inventory to ingredient inventory so that the product can be used as required throughout the process. The Consignment Transfer also creates the receiving transaction so that the vendor can be paid for the amount used. The pricing details default from the purchase order assigned to the consignment inventory. All prices and add-ons will be transferred from the purchase order to the consignment receiving transaction. Steps to create consignment inventory is outlined in Consignment Purchase Order.

Prior to creating a Consignment Transfer, the following items must be created:

• Consignment Purchase Order
• Ingredient Receiving

The following procedures are outlined in the Consignment Transfer document:

• Creating a Consignment Transfer
• Consignment Transfer Header
• Consignment Transfer Details
• Additional Details
• Posting a Consignment Transfer
• Journal Transaction

Create a Consignment Transfer

1. In FMTS>FMIM>Transactions>Ingredients, select Consignment Transfers.
2. In the Ingredients Consignment Transfers main index, select to create a new consignment transaction.
3. Click on the General tab.

Consignment Transfer Header

The header section contains the following components:

• General
• Amounts & Settings
• Derived

General

1. From the Feed Mill No drop-down menu, select the mill where the consignment inventory is stored.

2. In the PO Vendor No field, select the vendor that holds the consignment inventory was received to the feed mill

3. In the Trans Date Time field, enter the date and time of the transfer.

4. Ref No is an automatically-generated reference number that uniquely identifies the transfer transaction.
5. Suppler Ref No  is auto populated from the Purchase Order.
6. Location ID is an optional field and is used to enter the location of the detail vendor.
7. Driver No is an optional field used to identify the internal driver transferring the ingredients. Drivers must be set up prior to use in: Admin>Business>General>Definitions>Drivers.
8. External Driver is an optional field used to identify the external driver transferring the ingredients.
9. Vehicle No is an optional field used to identify the internal vehicle that is transferring the load. Vehicles must be set up prior to use in: Admin>Business>General>Definitions>Vehicles.
10. External Vehicle is an optional field used to identify the external vehicle that is transferring the load.
11. Trailer No is an optional field used to identify the internal trailer that is transferring the load. Trailers must be set up prior to use in: Admin>Business>General>Definitions>Vehicles.
12. Selecting the Void Flag will delete the transaction and all corresponding journal transactions.
13. In the Comments field, enter any additional details related to the transaction.
14. In the Reject Comments field, enter any addition details related to why the product was rejected.

Amounts & Settings

1. Enter the No of Receivings to indicate the number of receipts for the transfer transaction. A default of ‘0’ indicates a single receiving transaction.
2. Select the Scale No that is reading the weights. This must be set up prior to creating receiving transaction in: Admin>Business>General>Definitions>Weight Scales.
3. From Scale Operator No, select the scale operator number. Scale operators must be set up prior to creating the receiving transaction in: Admin>Business>FMTS>FMIM>Scale Operators.
4. In the Gross field, enter the gross weight of the vehicle. This field can be manually read or interfaced from a scale.
5. In the Tare field, enter the tare weight of the vehicle. This field can be manually entered or interfaced from a scale.
6. Net is the difference between gross and tare. This field can be manually entered or if weights are entered, it is calculated automatically.
7. Gross Wt Date Time displays the date and time that the gross weight was recorded at the scale.
8. Gross Wt Scale Ref No displays the reference number for the gross weight scale reading.
9. Tare Wt Date Time displays the date and time that the tare weight was recorded at the scale.
10. Tare Wt Scale Ref No displays the reference number for the tare weight scale reading.
11. Tare Auto Manual indicates the tare setting of Auto or Manual.
12. Gross Zero Weight Button is used if a zero weight is required.
13. Gross Zero Weight Date Time indicates date and time that zero weight was recorded.
14. Gross Zero Weight Scale Ref is a reference number generated from the scale for the zero weight.
15. Tare Zero Weight Button is used if a zero weight is required.
16. Tare Zero Wt Date Time indicates date and time that zero weight was recorded.
17. Tare Zero Wt Scale Ref is a reference number generated from the scale for the zero weight.
18. Total Amount  is a calculated total amount of the receiving transaction based on the amounts that are defined in the purchase order.

Derived

The information in the Derived fields automatically generates from the first two grids - General and Amounts and Settings. The fields are read-only and cannot be modified.

1. Feed Mill Name represents the feed mill where the consignment inventory is stored.
2. Vendor Name is derived from the Vendor No that supplied the product.
3. Location Name represents the name of the vendor location that sourced the product based on the selected Location ID.
4. Driver Name indicates the name of the driver that transferred the goods if applicable.
5. Vehicle Name represents the name of the vehicle that transferred the goods if applicable.
6. Trailer Name defines the trailer that transferred the goods if applicable.
7. Scale Operator Name is derived based on the selected Scale Operator No.
8. Purchase Trans Code will always be defined as Consignment Transfer.
9. Represents the Status of the transaction. Status will be one of No Weight, In Progress or Completed.

Consignment Transfer Line Details

The line details relate to the product that is being received from the vendor. In the child grid for the line item are the details related to add-ons and assays. These amounts will default as defined from the purchase order and cannot be modified at receiving. If there is freight assigned to the product, there will be two lines appearing in the line details for each product received. The first line will be related to the product details and amount, with the second line referencing the freight amounts.

1. Click on the Details grid.
2. Select to create a new Consignment PO Inventory screen.

3. Select the appropriate Consignment PO item and enter the number of inventory Units that are being transferred from consignment inventory to product inventory.
4. Optionally, a New Silo No can be selected, to identify the destination silo, which may or may not be different than the source silo.
5. Click the OK button to create the detail lines. The Details tab will appear with the base information relating to the purchase order.

6. Complex Po No indicates the consignment purchase order that is being transferred.
7. The Product No represents the ingredient that is being transferred from consignment to product inventory.
8. Product Name defaults from Product No and displays the name of the product being purchased.
9. Lot No is an optional field to record the lot number for the ingredient being received. The lot number will follow the ingredient through to the production process.
10. Silo No and Silo Name will default in if the silo has been specified, to identify the silo location from which the product is being received.
11. Dest. Lot No identifies the lot number for the destination where the ingredient is being received.
12. Dest. Silo No indicates the destination silo number where the product is being received. This will default in from the Silo No selected in the Consignment PO Inventory screen.
13. Dest. Silo Name displays a description of the destination silo.
14. Pay Basis defaults from the purchase order and indicates if the payment to the vendor is being determined based on the received weight or the shipped weight. Consignment inventory is normally based on received units or weight.
15. Received Weight indicates the weight that is being received. This amount will default from the net weight in the contract header. Depending on a setup switch that determines whether the receiving transactions are recorded based on inventory units or vendor units, this field may be automatically calculated.
16. Received Vendor Units indicates the number of vendor units that are being received. For example, the received weight is in pounds, but the product was purchased from the vendor in tons. Depending on a setup switch that determines whether the receiving transactions are recorded based on inventory units or vendor units, this field may be automatically calculated.
17. Shipped Weight is an optional field to enter the shipped weight if the vendor is being paid based on shipped weight. Depending on a setup switch that determines whether the receiving transactions are recorded based on inventory units or vendor units, this field may be automatically calculated. Shipped weight is not generally used for consignment inventory as the product was sent in advance to the usage.
18. Shipped Vendor Units is an optional field to enter the shipped vendor units if the vendor is being paid based on shipped weight. Depending on a setup switch that determines whether the receiving transactions are recorded based on inventory units or vendor units, this field may be automatically calculated. Shipped units are not generally used for consignment inventory as the product was sent in advance to the usage.
19. Net Payment Weight is a calculated field that is used when the assay result modifies the weight that the vendor will be paid for the product. In the assay definition in Global Assays or Ingredient Versions, the Scan Comparison value is set to Weight Adjustment.
20. Net Payment Vendor Units is a calculated field the will be calculated then Net Payment Weight option is used. The units will be based on the weight adjusted and in inventory units for each vendor unit.

21. Unit Description is derived from the PO, displaying  the unit of measure from which the product was purchased from the vendor.
22. Units Per derived data from PO  indicating  the number of units in each vendor unit.
23. Amount is a calculated field for the Received/Shipped Vendor Units x Unit Price.
24. The Unit Price defaults from the PO with no option to modify at transfer.
25. Total Add-ons is a calculated total amount of premium add-ons that will be added to the vendor payment based on the amounts defined in the purchase order. Details are located in child grid.
26. Total Discounts is a calculated total amount of discount add-ons that will be deducted from the vendor payment based on the amounts defined in the purchase order. Details are located in child grid.
27. Total Taxes is a calculated amount based on the taxable product and/or add-ons as defined in the purchase order. Details are located in the child grid.
28. Total Amount is a calculated total amount of the receiving transaction based on the amounts that are defined in the purchase order.
29. Bill of Lading is a location to enter the bill of lading reference for the receiving line.

Additional Line Details

Within the Complex Po No field, there is a child grid containing additional details relating to the ingredients receiving.

• Taxes
• Add-Ons

Taxes

Tax codes as defined on the purchase order will default to the receiving transaction. The amount will be calculated based on the rate that is in effect on the receiving date. There are two types of taxes.

• Accrual Taxes: Will record the tax accrual and record the journal transaction at time of receipt.
• Invoice Taxes: Will calculate the tax at time of receipt, however the journal transaction is not created until the purchase invoice is processed. Invoice taxes are generally used for federal taxes that are reimbursed to the company by the government and cannot be actually recorded until the vendor invoice is received.

1. Tax No identifies the tax code.
2. Tax Name displays a description of the tax code.
3. Amount displays the total amount of taxes.

Premium/Discount Add-Ons

Premium and discount add-ons default from the purchase order. Amounts will be calculated based on the amounts defined on the purchase order and the number of units transferred from consignment. All amounts will be accrued and recorded at transfer, however only add-ons with the Payment Type=Transaction will be transferred to the vendor invoice for payment.

1. Product No displays the code of the selected add-on.

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

3. Payment TypeTransaction: Processed with the sales invoice.
   
   Rebate: Processed at a date later than the invoice..
   
   Internal: An internal transaction is a transaction that is not invoiced to an external source  (Example: There is an internal haulage department that gets a credit for hauling products). is a read-only field that derives from the purchase order and determines when the add-on payment is made.

4. Payee Type is an optional field that indicates the source type for the premium or discount add-on.

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. Taxable identifies if the item is taxable or non-taxable when the add-on is purchased. The flag will be selected if the item is taxable.

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

Post a Consignment Transfer

Once the consignment transfer has been created and saved, the transfer needs to be posted. The posting process locks the consignment transfer to prevent edits, and creates the journal transaction to record the liability. The UnPost option unlocks the transfer and reverses the journal transactions. Once the consignment transfer has been posted, the purchase invoice can be processed to pay the vendor.

1. In the Ingredients Consignment Transfer index, select the required transfer transaction and right-click to select 'Post'. Alternatively, click the green check mark in the top menu bar and select 'Post'. Posting the record will move the product from consignment to mill inventory. Once this transaction is complete, the product can be used as required throughout the process.
2. To un-post a receiving, select the required receiving 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 will record the product to inventory and create the accounts payable accrual.