Incrementing fields

June 1, 200124 yr

A script would be the best choice.

Chuck

June 1, 200124 yr

quote:

Originally posted by lgaray:

Hello everyone:

Today my question is how do you increment in a calculation field.

For example, if I have the following equation:

Quantity_in_stock = Quantity_in_stock + Quantity_received

How do I define this in a calculation field (without getting a circular definition)?, or, do I have to use a script?

Thanks for your help!

Larisa.

Hello Larisa,

while a script may freezes the result in each record, a summary (based on portal or on a self-join) gives you the ability to instantly do a recalculation.

Consider the possibility to delete one or more recs: a frozen situation does not reflect the reality !!

For dynamics situations the right way is to choose dynamic calculations.

Regards

[ June 01, 2001: Message edited by: JPaul ]

June 1, 200124 yr

On of the better ways to deal with inventory totals is not to keep net inventory quantity as a single number in a field, but as a total of related records for that inventory item by number in a TRANSACTIONS file. The number in inventory is the sum of all related transactions. Transaction types can include an initial stock transaction, draw transactions, stocking transactions, and adjustments. When you sum all the transactions for one inventory number, you get the net inventory quantity. The advantage of this approach is that you can always reconstruct the inventory quantity, one bad entry can't wipe out the entire quantity history.

The downside is that for large inventories, the live summation of transactions can be too slow. In this case, a working number for the day can be updated by summing up transactions as an offline process that runs every night. The mid day number can be off, but will be corrected the next day.

-bd