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 Product Transaction Reconciliation

  1. In LMTS>LIM>Transactions>Products>Transaction Reconciliaiton, select Transaction Reconciliation.
  2. In the Product Reconciliation dialog box, enter the required date range in the Begin Date and End Date fields. The period is usually a global post period, but can be defined for any date range.
  3. Optionally, the Farm No can be entered to filter the reconciliation data for a specified farm.
  4. The Product No can be selected if the reconciliation data is being generated for a specified product.

 

  1. Click 'OK' and the transaction reconciliation data will load based on the selected criteria.
  1. Record Type indicates the source of the transaction detail. Options will be one of: Received, Usage or Physical.
  2. Trans Code determines the transaction type for the transaction record detail.

     

    Record Type Trans Code
    Receiving
    • Beginning Inventory
    • Receiving
    • Transfer In
    • Transfer Out
    • Inventory Variance Credit
    • Variance Debit
    Usage
    • Disposal
    • Sale
    • Usage
    • Consignment Usage
    Physical
    • Physical Adjustment

     

  3. 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.
  4. Ref No displays a unique reference number for the transaction.
  5. Transaction Entity ID identifies the entity where the transaction took place.
  6. Transaction Entity Name displays the name of the entity.
  7. Product No defines the product utilized for the transaction.
  8. Product Name displays a description of the product.
  9. Product Type identifies the type of product. Available options include: Field Products, Vaccination and Medication.
  10. Lot No is optionally used and references the lot number stored for the transaction. The cost will be maintained within the lot.
  11. Location No identifies the location where the product is stored.
  12. Quantity represents the quantity for the thread that is used to value the transaction.
  13. The Value represents the value from the thread that is used to value the transaction.
  14. Post Status indicates whether the transactions are posted by global post. All transactions should be in posted status.
  15. Source Code represents the transaction that was used to create the valuation transaction.

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
  • PO No
  • Vendor SKU No/Name
  • Beginning Quantity
  • Purchase Complex PO No
  • Warehouse Type
  • Beginning Unit Value
  • Purchase Ref No

 
  • Beginning Value
  • Remaining Quantity

 
  • Closed Flag
  • Remaining Unit Value

 
  • Consignment Complex PO No
  • Supplier Ref No
  
  • Consignment Flag
  • Transfer Destination Location No

 
  • Consignment Transfer Complex PO No
  • Transfer Destination Lot No

 
  • Consignment Transfer Ref No
  • Transfer Destination Product No/Name
  
  • Cost Center No/Name
  • Transfer Destination Ref No

 
  • Creation Date
  • Transfer Destination Transaction Entity ID

 
  • End Receive Date
  • Transfer Destination Warehouse Type

 
  • Expiration Date
  • Transfer Source Location No

 
  • External Cost Center Facility Type
  • Transfer Source Lot No

 
  • External Cost Center No/Name
  • Transfer Source Product No/Name

 
  • Farm No/Name
  • Transfer Source Ref No
  
  • Farm Type
  • Transfer Source Transaction Entity ID

 
  • Inactive Date
  • Transfer Source Warehouse Type

 
  • IRN
  • Unit Description
  
  • No of Receivings
  • Unit Value
  
  • Pay Basis
  • Units Per
  
  • Payment Term No/Name
  • Vendor No/ Name