fmk4

calculating inventory total

Discussion created by fmk4 on May 21, 2014
Latest reply on May 26, 2014 by DanielShanahan

Hi,

 

I have an warehouse application that requires a report to show the total number of item for each stock types by date of entry

 

Inventory table

 

 

item descriptiondate of entryquantity
apple21/5

4

orange20/51
pear20/52
pineapple20/53
apple20/52
apple21/51
pear21/55

 

 

 

1. If I run the report for 21/5 I would like to get the following report

 

 

item decriptiondate of entryquantity
apple21/55
pear21/55

 

1. If I run the report for 20/5 I would like to get the following report

 

item descriptiondate of entryquantity
orange20/51
pear20/52
pineapple20/53
apple20/52

 

2. What is the best way to get the above report?

 

I tried using summary field but the result is calcuated real time and I cant use it for further calcuation of the summary field.

Outcomes