Report Set Up
Upload Reports
If these data set's are not available to you please let me know and I will send a script for you to add these.
- Pullet Flock Report Master (Main Report) = Transaction Detail
- Operating Result Sub = Transaction Detail
- Expense Summary Sub = Expense Summary (Period)
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:
- Operating Results Sub
- Expense Summary Sub
Flock Information Section
Grown At: Currently the Farm Code
AR Account: These will need to be set up as a Flock Attribute and then the Account can be entered for each Flock.
GL Account: These will need to be set up as a Flock Attribute and then the Account can be entered for each Flock.
Attributes
System → Settings → Flock Attributes Tab
Flock Form → Attributes Tab
Add Attribute Calculation To Report
Once the Attribute is created then you can apply your specific Attribute to the report.
The field will be created with a prefix of "GroupAttribute" and will be found under the TransRpt Section
General information on Flock Attributes
Operation Results Sub
Revenue per Transfer Out
Added the ability to add revenue costs to individual transfer out records.
The transfer out revenue on the report will sum the total revenue expenses entered for that transfer out.
If the Transfer outs have an SEINS Revenue Code applied, it will sum all those up at the bottom.
SEINS - Create the SEINS revenue code
Trucking Charge
We added a column to the transfer out record to be able to record a trucking charge at time of transfer out. If you do not see this column, please reset your transfer out grid.
Expense Summary Sub
Any expenses applied to the flock will show up listed except for any expenses with the expense code "HST"
HST - This expense code will need to be created if it does not already exist. (Please let us know if you have something created but named differently and we can modify report)
Food Statistics
We did not add the row Cost of Feed Per Bird Sold Under Stevens Form (we do not have this information)
Running the Report
Dates
You do not need to set any dates. You should run for the life of the flock and this report will only show the operating results section once the flock has been transferred out to a destination flock.