Hi I am trying to do a margin report based from the value entry table for invoiced quantity, sales amount, cost amount and Item charges. The problem i have is that quantity, salesamount and cost amount are filtered for entry type = sales whereas item charges must not have this filter on. Any ideas on how best to achieve this.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Gary90,
Here's an idea that may help you to find the correct filters in case you have NAV 4 or 5.
In Item Statistics you may find an option in the header called "Show as lines". Interesting options are Cost specification and Item charge specification for both purchases and sales.
Then in the matrix form below the header you could click one of the cells, use the drilldown button and then look at the Table filter. That should tell you exactly how NAV filters the Value entries on a specific costing topic.
Please let us know if and how this works for you. -
Jet Reports Historic Posts Thank you for your reply.
Thats what i did to get the filters but the isssue i am having is on the jet report.
Main function used - =NL("Rows=4","Value Entry","Main Product Group Code","Posting Date",Options!$D$5) (options id for date filter on posting date)
Group filtering - NL("Rows","Value Entry",,"+Item No.","*","Posting Date",Options!$D$5,"Main Product Group Code","@@"&$D6)
Then on the columns i am using the following filters - =NF($F6,"Cost Amount (Actual)","Item Ledger Entry Type","<>Revaluation","Entry Type","Sale")
Except for the item charges where no filter is required.
We are using Nav 4 Sp1 SQL 2005.
Can send the report if that helps.
Please sign in to leave a comment.