Layer Flock Management Report

Owned by Amanda Thomas
Last updated: May 10, 2019
4 min read



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







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.