Transaction Reconciliation

 

Transaction Reconciliation screen is view-only. Transaction reconciles where the cost of a specific transaction is derived based on the transaction details entered in the system.  The screen is viewed based upon a beginning and ending date as well as farm and product. Each transaction that affects  the inventory will be displayed.

Generate Feed Transaction Reconciliation

  1. In BMTS>BRIM>Transactions>Feed Inventories, select Transaction Reconciliation.
  2. In the Feed Inventory Reconciliation dialog box, enter the following parameters:
    1. Begin Date - enter the start date of the transactions for reconciliation
    2. End Date - enter the end date of the transactions for the reconciliation.
    3. Farm No - can be entered to filter the reconciliation data for a specified farm.
    4. Feed Type No - may be selected if the reconciliation data is being generated for a specified feed. This option can only be utilized if the Feed Inventory Mode is set to Feed Type or Formula.
    5. Formula No - select the formula to filter the transactions for a specific formula. This option can only be utilized if the Feed Formula Mode is set to Formula..
  3. Click 'OK' and the transaction reconciliation data will load based on the selected criteria.
  4. Record Type indicates the source of the transaction detail. Options will be one of: Received, Usage or Physical.
  5. Trans Code determines the transaction type for the transaction 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. Trans Date represents the date that of the source transaction.
  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 transaction 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 transaction reconciliation data. The following fields are also available depending on the type of transaction that is being reviewed.

  • Begin Receive Date
  • Creation User ID
  • Remaining Unit Value
  • Beginning Quantity
  • Expiration Date
  • Unit Value
  • Beginning Unit Value
  • Farm Type
  • Value
  • Beginning Value
  • IRN

 
  • Creation Date
  • Remaining Quantity