user filter on report.

madm

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

colingbradley

Why not put the filter on the Item?

madm

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

Looks like that report is in UK version only. I don't see it in US version.

colingbradley

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

madm

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

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]