Hi all,
I'm new to jet reports and to dynamics nav 2009. I'm trying to create a report that summarizes items by their Vendor No. where certain filters are met. If the Vendor No. doesn't contain any items with values from the filter I don't want them to show.. seems simple but I can't get it to work for the life of me. I've already spent hours on this and i'm beginning to think it's just something stupid I didn't do so I need help at this point.
I also want to further filter the list based on "Location Code" to turn this into a stock profile report so we can see how many items are on sales orders and what we need to order in to each warehouse etc.. Could you guys help me get started on this as well? Thanks so much to whoever can lend a hand!
Date
Votes
3 comments
-
Jet Reports Historic Posts Well I figured out the first part. Just had to extend my hide conditionals to all relevant rows and change the logic a little. Works great now except I need to add in the location code part. Still hoping to get some help on that
Edit: lol nevermind guys I got it all working -
Jet Reports Historic Posts I have one more concern about my report. Does anyone know if the "Item" - "Qty. on Sales Order" field only includes "Released" orders? That is a requirement for this report but I can't find any kind of filter where I can set Released as criteria. Attached updated sheet
-
Jet Reports Historic Posts Hi,
The Qty. on Sales Order field by default only filters on Document Type, Type and No. and get this from the sales line table.
The Status is stored on the Sales Order Header so you would have to link back to the header using the Document No. to check the Status.
To answer your question here - it does not look at the status of the document.
Regards
Tom
Please sign in to leave a comment.