inventory reconciliation

 

The Product Inventory Reconciliation provides the details for all of the transactions in a specified period to determine the valuation. All transactions that relate to the product will be listed in the inventory reconciliation to determine the quantity and valuation of the product. The transactions will be valued based on FIFO or Average Cost as defined in the feed mill registry.

 

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

 

 

Generate Ingredient Inventory Reconciliation

  1. In General>Warehouse, select Inventory Reconciliation.
  1. In the Product Reconciliation dialog box, enter the required date range in the Begin Date and End Date fields. The period is usually a weekly or fiscal period, but can be defined for any date range.
  2. Optionally, the Cost Center No can be entered to filter the reconciliation data for a specified warehouse.
  3. The Product No can be selected if the reconciliation data is being generated for a specified product.
  4. Click 'OK' and the product reconciliation data will load based on the selected criteria.

    5.  

     

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

     

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

 

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