Hey
I just start to use Jet.
I want a report with information of 2 tables of NAV: the item-table and the the purchace price-table.
item-table:
*no
*description
*unit price
purchace price:
* direct unit cost
I just want to get the last direct unit cost of the item.
what I do:
=NL("Link";"Purchase Price";"";"Item No.";"=No.";)
But this gives me the oldest direct unit cost (the first record).
Since a new record in the Purchase Price-table is automaticaly created each time our accountant books a purchase invoice,
only the starting date-field contains a value (the date the purchase invoice has been booked), but the ending date-field is always empty.
So there is no way to put an extra filter on the purchase price-table to only get the record with ending date=''.
Is there a way to sort the linked table?
If I could sort the starting-date field in descending instead of ascending order, then the first record would be ok.
I've already tried this =NL("Link";"Purchase Price";"";"Item No.";"=No.";"-Starting Date";"*"),
but this doesn't work.
(I know that the field Last Direct Cost exists in the Item-table, but I don't want to use that field
since a the purchase departement can also register a price in the Purchase Price-table that has not already been used in a sales order)
Hopfully my question is not to complicated.
Best regards
Tom
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Tom,
Unfortunately the Table Builder doesn't allow for this type of functionality. Right now the "Link" function only returns the first matching record. It sounds like you want something that would link to the last matching record. I've noted this as possible feature addition in the future.
Our Jet Essentials product does have additional features that could allow you to create a report like this.
Steve -
Jet Reports Historic Posts Hey Steve
Thank you for adding this on your roadmap.
I use the express edition to evaluate your product.
Since most tables in a DBMS have one-to-many-relationships, this seems to me to be a basic functionality.
So I don't think that this express-edition is very functional to test.
Best regards
Tom -
Jet Reports Historic Posts Jet Express and Jet Essentials are two different products serving two different purposes.
I would not recommend using Jet Express as a test of Jet Essentials capabilities.
If you would like to try out Jet Essentials, you can contact Jet Reports (sales.us@jetreports.com),for an evaluation of Jet Essentials.
Or, contact our regional sales offices if outside the US, http://www.jetreports.com/contact/corporate-and-global-locations.php -
Jet Reports Historic Posts Thank you for your response Joel.
Right now, I'm focusing on another project.
When we reprioritize the BI/reporting-project,
I'll contact your sales departement.
I think it's not usefull to do it now,
since the evaluationversion will have a timelimit.
Best regards
Tom
Please sign in to leave a comment.