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 Configuration
Egg Size Types
- These need to be set up exactly as they are in the report so we get the correct values back. Run the following script against the user database to set up the egg size types used:

update userbusinesstype
set sortorder = 20.00
where objectid = 77

update userbusinesstype
set BusinessTypeCode = 'Bs', BusinessTypeName = 'Bs', IsUserMod = 1, SortOrder = 7
where BusinessTypeID = 310

update userbusinesstype
set BusinessTypeCode = 'CRACKS', BusinessTypeName = 'CRACKS', IsUserMod = 1, SortOrder = 8
where BusinessTypeID = 311

update userbusinesstype
set BusinessTypeCode = 'REJECTS', BusinessTypeName = 'REJECTS', IsUserMod = 1, SortOrder = 9
where BusinessTypeID = 314

update userbusinesstype
set BusinessTypeCode = 'JUMBO', BusinessTypeName = 'JUMBO', IsUserMod = 1, SortOrder = 1
where BusinessTypeID = 293
update userbusinesstype
set BusinessTypeCode = 'X-LARGE', BusinessTypeName = 'X-LARGE', IsUserMod = 1, SortOrder = 2
where BusinessTypeID = 294
update userbusinesstype
set BusinessTypeCode = 'LARGE', BusinessTypeName = 'LARGE', IsUserMod = 1, SortOrder = 3
where BusinessTypeID = 295
update userbusinesstype
set BusinessTypeCode = 'MEDIUM', BusinessTypeName = 'MEDIUM', IsUserMod = 1, SortOrder = 4
where BusinessTypeID = 296
update userbusinesstype
set BusinessTypeCode = 'SMALL', BusinessTypeName = 'SMALL', IsUserMod = 1, SortOrder = 5
where BusinessTypeID = 297
update userbusinesstype
set BusinessTypeCode = 'PEEWEE', BusinessTypeName = 'PEEWEE', IsUserMod = 1, SortOrder = 6
where BusinessTypeID = 298

Egg Size Matrix Configuration
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
Valuation Configurations
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.