Dear Expert,
I tried to create very simple report to view list of item ledger entry with Remaining Quantity > 0 or Open status is TRUE, but it took me more than 20 minutes to run.
I tried to follow the order of filtering based on keys in the table like this below statement but still very slow….
=NL("Rows","Item Ledger Entry",,"Item No.","*","Open","TRUE","Variant Code","*","Location Code","*","Item Tracking","*","Lot No.","*","Serial No.","*")
please find attachment for more detail information.
any suggestion how to improve the performance?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
What version of Jet and NAV are you using? Filters with a "*" do not affect what key Jet uses. If you actually want to specify a key, you can use the special filter with Key= as the field and an array of fields as the value.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I'm using version 9.2.10167.0
Actually, I only need to filter item which has remaining quantity (Open = true) + show the latest price. I don't need the others filter, but the report run terribly slow.
I tried to use ODBC, it's faster but the problem is that ODBC can't find the latest Sales Price from Sales Price table.
regards,
angelo -
Jet Reports Historic Posts Angelo,
You are on a very old version of Jet. There are actually optimizations in newer versions of Jet that would help your report run much faster. I would recommend upgrading to the latest version of Jet.
Regards,
Hughes
Please sign in to leave a comment.