FlowFields

david.weeks

Hello All

I have set up a new flow field for the item table/card.
This works fine when using the item card.

However, if I select the item from the item list from for example within a sales shipment, I get strange incorrect results for the flowfield.

I checked and I am getting the correct item number pulled through but am i missing any refresh command?

Ideas

Thanks

Luc_VanDyck

Are you sure there are no FlowFilters used that can influence your CalcFormula?

Post your CalcFormula here, so we can look at the calculation of your FlowField.

david.weeks

Hi,

I am using Sum of Invoiced Quantity within Item Ledger Entries.
The filters are:

Item No. Field No.
Entry Type Const Sale
Posting Date Field Date Filter

I am using SETRANGE within OnAfterGetRecord within the item card form to do the date so that the date filter is within the last 12 months only

Thanks

Luc_VanDyck

On the Item list form, click on the Drilldown-arrow of your new FlowField to see the entries. Now have a look at the Table Filter form (Ctrl-F7) and FlowFilter form (Shift-F7) to see what filters are set.

PEzechiels

if you want the correct results you need to put the setrange also in the form in which you want to see the flowfield.you could try to put it in the onaftervalidate trigger of item no.