reconciliation

Egg Room Reconciliation provides the details for all of the transactions in a specified period to determine the valuation. The transactions will be valued based on FIFO or Average Cost as defined in the feed mill registry.

Within Reconciliation, it is also possible to create a new report. Details on this process can be found in the Reports section.

Generate an Egg Room Reconciliation

1. In BMTS>BIM>Transactions>Egg Room, select Reconciliation.
   
   
   
2. In the Egg Inventory Recon dialog box, in the Begin Date and End Date fields, enter the required date range.
3. Optionally, Farm No can be used to filter the reconciliation data for a specified farm.
4. The Complex Entity No can be selected if the reconciliation data is being filtered for a specific entity.
5. Click 'OK' and the fields in the Egg Room Reconciliation screen will default in.

6. Record Type identifies the transaction record type, and will be either Received or Usage.
7. Egg Trans Code identifies the egg transaction type. Available options are: Received, Granularity Change, Debit Adjustment, Repack, Regrade, Transfer Out, Disposal, or Packaging..
8. Inventory Date displays the last date that inventory was taken.
9. Farm No identifies the farm where the eggs were produced.
10. Farm Name displays the name of the farm that produced the eggs.
11. Complex Entity No indicates the entity that produced the eggs.
12. Product No indicates the egg product in the transaction.
13. Product Name displays a description of the egg product.
14. Tracking No displays a unique reference number to identify the group of eggs in the transaction.
15. Prod Date indicates the date that the eggs were produced, to determine egg age.
16. Buggy No indicates the buggy used if the eggs were loaded directly onto a buggy.
17. Buggy Name displays the name of the buggy, if applicable.
18. Quantity displays the relative (+/-) quantity for the transaction.
19. Ref No displays an optionally entered unique reference number to identify the transaction.

20. Breed No is a derived field based on the selected entity, and is used to identify the breed code of the eggs.
21. Breed Name displays a description of the breed code.
22. Trans Quantity displays the quantity for the transaction, but is not presented as relative (+/-).
23. Source Code identifies the origin of where the transaction took place. Example: Transfer or Purchase, etc.
24. Source Egg Trans Code represents how the eggs were originally recorded to the hatchery – received, purchased, transferred, adjusted, repacked, regraded.
25. Source Date displays the date of the original transaction.
26. Source Quantity displays the quantity of the original transaction.
27. Source Remaining Quantity displays the number of eggs remaining in inventory from the original transaction.
28. Source Purchase Ref No displays the reference number, if the product was purchased.
29. Complex PO No indicates the purchase order number, if the product was purchase.

30. Set Date displays the date that the eggs were set.
31. Setter No indicates the setter in which the eggs were set.
32. Setter Name displays a description of the setter.
33. Complex Order No displays the order number if the product was sold.
34. Ship To Customer No indicates the customer who received the eggs.
35. Ship To Customer Name displays the name of the customer who received the eggs.
36. Set Reject No indicates the reasons for rejected set eggs.
37. Set Reject Name displays a description of the reason for rejection.
38. The Consignment flag will be selected if the eggs were purchased using a Consignment Purchase Order.

View Existing Reports

This option will display all current existing reconciliation reports.

1. In the Egg Room Reconciliation screen, click and select 'View Existing Reports'.
2. Click 'OK'.
3. The Egg Room Reconciliation screen will show all existing reports based on the selection criteria.

4. Report Name displays a description of the reconciliation report.
5. Layout Name displays the name of the report structure.
6. Layout Description displays a description of the layout.
7. Report Layout Type indicates the layout type of the report.
8. Preview contains a snapshot of the report.
9. Creation User ID indicates the person who created the report.
10. Last Run Date indicates the date the report was last ran or generated.
11. The Group Definition flag will be selected if the layout was generated from Group Definition.
12. The System Flag will be selected if the report is a system report, and will make it available for all to use.
13. The Print Trackable flag will be selected if there is a counter that increments every time the report is printed.
14. Report ID is a unique identification number used to identify the report.
15. Layout ID is a unique identification number used to identify the layout.