Jump to content
  • 0

Inventory Management


codylgibbs
 Share

Question

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... 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

  • 0

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/

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...