Think i'm loosing my mind..
options page:
Date Range- 01/01/07..01/30/08
can't get filter to work
<>01/01/07..01/30/08 (meaning- Not equal to)
I've tried using $ $ but still not working.. help… lol maybe it's just too late to think
Date
Votes
4 comments
-
Jet Reports Historic Posts How about "..12/31/06|01/31/08.."? Which is to be read as "up until december 31 2006 OR January 31 2008 and later".
-
Jet Reports Historic Posts the pipe symbol in navision is for seperate items. we use it a lot when entering serial numbers. just trying to get an excel filter to find the items not equal to the date supplied..
-
Jet Reports Historic Posts Maybe I don't get you right, but the pipe symbol is a filter operator that can be used in any part of NAV. It's not Items specific. The NAV Help will help you to learn more about this and other NAV filter operators.
Regarding the quantity received… the Purchases (Qty.) field on the Item table is a Flowfield which calculates the invoiced quantity. Close, but no cigar :)
So you may need a link to the Item ledger entry Table: NL("Count","Item Ledger Entry",,"Entry Type","Purchase","Item No.",CellRefToItemNo,"Posting Date",CellRefToDatefilter010107..01308,"Quantity","<>0").
If the count is zero, that particular item was not received during the given period. -
Jet Reports Historic Posts here is what i have so far.
Cell D2: 01/01/06..01/31/08 (this is the date from the options page
Cell B5-D5: =NL("Rows","Item Ledger Entry",,"Entry type","Sale","Posting Date",D2)
Cell E5: Item No.
Filters in place-
FilterField1: "Entry Type"
Filter1: "Sale"
FilterField2: "Posting Date"
Filter2: D2 (This is where I can't seem to get it to give me the correct results)
My main goal is to get a list of Items that have "Not Been Sold" in the date date range of D2
I did attempt to use =DATE(YEAR(C4), MONTH(C4)-6, DAY(C4)) in the options page, but i didn't think it through all the way.
Please sign in to leave a comment.