Warehouse transaction reconciliation

 

Transaction Reconciliation is a view only screen that 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 warehouse and product. Each transaction that affects  the inventory will be displayed.

Generate Ingredient Transaction Reconciliation

  1. In General>Warehouse, 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 Warehouse No can be entered to filter the reconciliation data for a specified warehouse.
  4. The Product No can be selected if the reconciliation data is being generated for a specified product.
  5. Click 'OK' and the transaction reconciliation data will load based on the selected criteria.

    6.  

     

  6. Record Type indicates the source of the transaction detail. Options will be one of: Received, Usage or Physical.
  7. 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

     

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

 

  • Begin Receive Date
  • PO No
  • Trans Unit Value
  • Beginning Quantity
  • Purchase Complex PO No
  • Trans Value
  • Beginning Unit Value
  • Purchase Ref No
  • Transfer Destination Location No
  • Beginning Value
  • Remaining Quantity
  • Transfer Destination Lot No
  • Closed Flag
  • Remaining Unit Value
  • Transfer Destination Product No/Name
  • Consignment Complex PO No
  • Remaining Value
  • Transfer Destination Ref No
  • Consignment Flag
  • Supplier Ref No
  • Transfer Destination Ref No
  • Consignment Transfer Complex PO No
  • Thread Beginning Quantity
  • Transfer Destination Transaction Entity ID
  • Consignment Transfer Ref No
  • Thread Beginning Unit Value
  • Transfer Destination Transaction Entity Name
  • Cost Center No/Name
  • Thread Beginning Value
  • Transfer Destination Warehouse Type
  • Creation Date
  • Thread Creation Date
  • Transfer Source Location No
  • End Receive Date
  • Thread Date
  • Transfer Source Lot No
  • Expiration Date
  • Thread Quantity
  • Transfer Source Product No/Name
  • External Cost Center Facility Type
  • Thread Record Type
  • Transfer Source Warehouse Type
  • External Cost Center No/Name
  • Thread Ref No
  • Unit Description
  • Farm No/Name
  • Thread Remaining Quantity
  • Unit Value
  • Farm Type
  • Thread Remaining Unit Value
  • Units Per
  • Inactive Date
  • Thread Remaining Value
  • Vendor No/ Name
  • IRN
  • Thread Source Code
  • Vendor SKU No/Name
  • No of Receivings
  • Thread Trans Code
  • Warehouse Type
  • Pay Basis
  • Thread Unit Value
  
  • Payment Term No/Name
  • Thread Value
  
  • PO Line No
  • Trans Quantity