Inventory Card, inventory, date filter.

Phenno

In table Item, there is a field Inventory

But...

it is flowfield and in its sum formula, it doesn't have reference to Date Filter.


To simplifie, inventory value does not change if you change date filter.

Does anybody knows why is this setted in this way? I notice that there is a field in customer, vendor and some other tables with similar fields. All of them are important fields to customer (e.g. balance) and they have no Date Filter in sum formulas too.


:roll:

jm

Hi,

in the table item you can try the field "Net Change", it does have reference to Date Filter.

br
Josef Metz

kine

Because Inventory is "Actual inventory". If you need inventory to date, you must use the field "Net Change" with date filter like ..010205

Phenno

ups...

8-[

Thanx to both of you