Hi all,
I am new to Jet and initially trying to use it to manage production orders for large scale projects. I have built a base table using the browser functionality drawing the data from the production order table. Now I would like to add additional fields to this report, such as items consumed (being drawn from the item ledger entries table) and hours booked (being drawn from the capacity ledger entries.) How do I "link" this information based on the Production order no.?
There must be a simple way, that I just don't see.
Thanks in advance!
Lisa
Jet Essentials
NAV 2013 R2
Date
Votes
3 comments
-
Jet Reports Historic Posts You could do this using the Link= feature: http://kb.jetreports.com/article/AA-00723/0/
Probably easier than that though, the Table Builder allows you link multiple tables together to create a new Excel table.
http://kb.jetreports.com/article/AA-00731/#tablebuilder
Hope that helps point you in the right direction. -
Jet Reports Historic Posts Thank you. I have been using table builder today, and have learned a couple of new things. The most valuable has been how to retrieve and edit a previously saved table.
I have successfully pulled in data from the capacity ledger entries and the item ledger entries, and run into my next challenge.
How can I change the negative value that comes from the item ledger entries table to a positive number?
=NL("LinkSum","Item Ledger Entry","Cost Amount (Actual)")
Thanks again for you help!
Lisa -
Jet Reports Historic Posts You should be able to just add a negative before the NL or you could multiply the whole thing by -1.
=-NL("LinkSum","Item Ledger Entry","Cost Amount (Actual)")=NL("LinkSum","Item Ledger Entry","Cost Amount (Actual)")*(-1)
Please sign in to leave a comment.