Running Total but for receiving invenotry

Topic Labels: Extensions
683 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

We are looking for a script similar to Running Total, except instead of adding the previous record to the one below it, etc it would add a Units Received field to a Total Received field everytime the Units Received field is updated.

How would I go about something like this?

2 Replies 2
7 - App Architect
7 - App Architect

One way would be to have a table called e.g. “deliveries” with “units received” field. It would be linked to products table which would use a Roll-up type field: Total Received. This field would use the SUM(Values) function.

Do you need a running total across multiple rows? Or is only a final total okay?

If you need a running total, you can adapt the running total script. Add the units received to the total received from the previous record to get the new total received. Continue down the rows.

If you only need the final total, go with Matt’s suggestion of linked records and a rollup field.