user filter on report.

madm
madm Member Posts: 92
edited 2006-09-14 in Navision Attain
Report 10540 stock received not invoiced.

We wish to be able to filter on the inventory posting group so the report can be used to select different categories.

The IPG is available on the Value Entries, filterning on this does not work (due to it being the 2nd data item?)

I thought about putting a lookup to the IPG table on the options tab, and allowing the user to select the group from there. How, would then allow the filtering, so that the report only shows the selected IPG?

Thanks

Comments

  • colingbradley
    colingbradley Member Posts: 162
    Why not put the filter on the Item?
    Experience is what you get when you hoped to get money
  • madm
    madm Member Posts: 92
    colingbradley wrote:
    Why not put the filter on the Item?

    The item table isnt in the report. The report uses Item Ledger Entry and Value Entry. The IPG is within the value entry, but when Ive tried using this, the filter doesnt do anything?
  • ara3n
    ara3n Member Posts: 9,258
    Looks like that report is in UK version only. I don't see it in US version.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • colingbradley
    colingbradley Member Posts: 162
    This is what the V4 version of that report looks like to me.
    UK only possibly.

    DataItem Name
    Item <Item>
    Item Ledger Entry <Item Ledger Entry>
    Value Entry <Value Entry>
    Integer ItemTotal
    Experience is what you get when you hoped to get money
  • madm
    madm Member Posts: 92
    colingbradley wrote:
    This is what the V4 version of that report looks like to me.
    UK only possibly.

    DataItem Name
    Item <Item>
    Item Ledger Entry <Item Ledger Entry>
    Value Entry <Value Entry>
    Integer ItemTotal

    version 3.01 is just item ledger / value entry, integer?

    so will it be as simple as addng the item data entry and indenting the other items in one level?

    also, on the report there is a counter. I cant remember the full details, but basically it is counter := counter + 1

    in the itemtotal, there is a if counter <= 1 then exit, and i was finding that the first line of the report was always being omitted, although the totals are correct.
  • colingbradley
    colingbradley Member Posts: 162
    I would suggest getting the V4 version and fixing up anything not appropriate for 3.01. Just as a starting point anyway.
    If you have a problem with that, send me your email addr. and I can send a text version, just change the report number and import.
    [/url]
    Experience is what you get when you hoped to get money

Categories