FlowFields

david.weeks
david.weeks Member Posts: 96
edited 2004-08-25 in Navision Attain
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

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • david.weeks
    david.weeks Member Posts: 96
    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
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • PEzechiels
    PEzechiels Member Posts: 83
    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.

Categories