Inventory Management

[codylgibbs]

I am attempting the create an inventory management and production report my work in the poultry industry. I have several farms that I have to record information on such as mortality and egg production. We track our production weekly (Sun-Sat). 

I have created two tables:

1. Flock Placement Information (How many birds were placed on each farm)
2. Report criteria (The information that needs to be reported on)

I want to create a report that will track the age of the birds & total birds on farm at week-end (Sat) minus weekly mortality. What I am having trouble with is telling the report how many birds are placed, then having it subtract off the mortality weekly. 

Example

Placed: 1000
Week 1: -3 = 997
Week 2: -5 = 992
And so on... 

[Tubby]

On 6/18/2022 at 12:56 PM, codylgibbs said:

I am attempting the create an inventory management and production report my work in the poultry industry. I have several farms that I have to record information on such as mortality and egg production. We track our production weekly (Sun-Sat). 

I have created two tables:

1. Flock Placement Information (How many birds were placed on each farm)
2. Report criteria (The information that needs to be reported on)

I want to create a report that will track the age of the birds & total birds on farm at week-end (Sat) minus weekly mortality. What I am having trouble with is telling the report how many birds are placed, then having it subtract off the mortality weekly. 

Example

Placed: 1000
Week 1: -3 = 997
Week 2: -5 = 992
And so on... 

Can you maybe provide a sample or a screenshot of you table design?  Also how do you log the mortalities? Does it have its own table or is it in Report Criteria? Sounds to me that you can use Triggered Actions for this one to automate your workflow so you can log how many mortalities do you have for the week and it will automatically update the values in your Flock Placement or wherever the count of birds are placed. That is assuming your plan includes triggers.

[telly]

Hi @codylgibbs,

If you just need to show the mortalities on a report, you may use calculated field/values to show the value.

Calculated: https://howto.caspio.com/datapages/datapage-components/calculated-values/
Function reference: https://howto.caspio.com/function-reference/

If you want to automatically able to get the mortalities daily, you may use Application Task.

Application Task: https://howto.caspio.com/tasks/