Report Set Up
Upload Reports
If these dataset's are not available to you please let me know and I will send a script for you to add these.
- Layer Flock Management Report (Main Report) = House Dataset
- Performance Stats Sub = House Dataset
- Egg Grades Sub = Egg Revenue Dataset
- P&L Sub = Expense Summary Dataset
- Financial Graph = Expense Summary Dataset
Set Sub-Reports
Once you have uploaded these reports, you will need to set these sub reports to the main report.
Right click on report, edit report, click on each sub-report (grey box) and select the blue box in the corner.
Then click on the Report Source URL drop down and find the sub report that should be in that location. Do for each sub-report.
Adding Sub Report Joins
Right click on each sub report, select sub report joins and set the following joins for each report:
- Egg Grades Sub
- Performance Stats Sub
- P&L Sub
- Financial Graph
Layer Management Report
- Producer Address is getting the producer assigned to the farms address. If this is not correct and it should be the farm address, please let us know and we can change it.
- Grading STN is pulling the farms default egg processing plant. To set up egg processing plants see Plants and Mills
- Salesman pulls from the sales person set on the flock form, details tab. Salespersons can be added under System – Personnel
Performance Stats
Weekly Mortality, Egg Production and Egg Shipments can be entered through the batch form for ease of data entry.
Egg Grades
To utilize this section you will need to set up
Egg Size Types
Equipment: House Equipment: Set up Grader Machines used at the egg Processing Plant
Egg Processing Plant - Set Up Plant and assign equipment to the plant. See Plants and Mills
New Revenue Codes called EGG and EFP. Please make sure to use the same code as this is referenced in the report
You can then utilize the egg grade out batcher and pricing process. See: Egg Grade-Out Valuation Process
Income
To utilize this section you will need to set up:
New Expense Codes (if they dont already exist) called LOAD, Truck, Ins, SEINS, Fees
The report also utilizes FC= Feed, FMD=Feed Meds, and CC = Birds expense codes but these should already exist.
Expenses entered on the expense form for the flock will show up in this section
Running the Report
Dates
Set your dates for a 4 week time frame. Make sure that your weeks start and end appropriately to include the whole week.