Inventory Reconciliation

 

The Feed Inventory Reconciliation provides the details for all of the feed transactions in a specified period to determine the valuation. All transactions that relate to the feed will be listed in the inventory reconciliation to determine the quantity.

 

The reconciliation can be run for a specified date range, farm and product. Once the data is generated, the screen can be filtered and grouped as required to view more specific data.

 

 

Generate Feed Inventory Reconciliation

  1. In BMTS>BRIM>Transactions>Feed Inventories, select Inventory Reconciliation.
  2. In the Feed Inventory Reconciliation dialog box, enter the following parameters:
    1. Begin Date - enter the start date for the inventory reconciliation data. (Required)
    2. End Date - enter the end date for the inventory reconciliation data. (Required)
    3. Farm No - select the farm to  filter the reconciliation data for a specified farm. (Optional)
    4. Feed Type No - select the feed type to filter reconciliation data.. Note that this option should only be selected if the Feed Inventory Mode is set to Feed Type or Formula. (Optional)
    5. Formula No - select the formula to filter the reconciliation data. This option should only be utilized if the Feed Inventory Mode is set to Formula. (Optional)
  3. Click 'OK' and the feed product reconciliation data will load based on the selected criteria.
  4. Record Type indicates the source of the inventory detail. Options will be one of: Received, Usage or Physical.
  5. Trans Code determines the transaction type for the inventory record detail.

    6.  

    Record Type Trans Code
    Receiving
    • Beginning Inventory
    • Feed Trans Delivery
    • Transfer In
    • Transfer Out
    • Inventory Variance Credit
    • Variance Debit
    Usage
    • Field Trans Usage
    Physical
    • Physical Adjustment

     

  6. Inventory Date represents the date that the inventory was received or removed from inventory. If the Inventory Time Mode registry switch is set to 'Date Time', the record will be date and time stamped.
  7. Source Code represents the transaction that was used to create the valuation transaction.
  8. Source Ref No displays a unique reference number for the source transaction.
  9. Farm No indicates the farm where the inventory reconciliation is taking place.
  10. Farm Name displays the name of the farm.
  11. Formula No indicates the formula, if selected.
  12. Formula Name displays a description of the formula.
  13. Feed Type No identifies the type of feed that is being reconciled.
  14. Feed Type Name displays a description of the feed product.
  15. Quantity represents the quantity for the thread that is used to value the transaction.
  16. Post Status indicates whether the transactions are posted by global post. All transactions should be in posted status.
  17. Creation Date indicates the date the transaction was created.

Additional Reconciliation Fields

The fields described above are the typical fields used to analyze the inventory reconciliation data. The following fields are also available depending on the type of transaction that is being reviewed.

 

  • Begin Date
  • Remaining Unit Value
  • Thread Source Code
  • Beginning Quantity
  • Thread Beginning Quantity
  • Thread Trans Code
  • Beginning Unit Value
  • Thread Beginning Unit Value
  • Thread Unit Value
  • Beginning Value
  • Thread Beginning Value
  • Thread Value
  • Creation Date
  • Thread Creation Date
  • Trans Quantity
  • Expiration Date
  • Thread Record Type
  • Trans Unit Value
  • Farm Type
  • Thread Remaining Quantity
  • Trans Value
  • Post Status
  • Thread Remaining Unit Value
  • Unit Value
  • Remaining Quantity
  • Thread Remaining Value
  • Value