I am a relatively new user conversant primarily with the Table Builder feature of JET. I have been asked a question which would involve checking the value of our shipments in a time window and comparing to the value of invoices in the same window. I thought I could answer the question by linking the Shipment Line table with the Sales Invoice Line tables however I notice JET has not automatically suggested a link to the two tables in Table Builder. Upon reviewing the two tables manually I cannot see an obvious field to link myself. Can anyone suggest if this can be done directly or if there is more to it - e.g. introducing another table?
Date
Votes
2 comments
-
Jet Reports Historic Posts They are most likely linked by Order No.
You may need to look at the Header table instead of the Line table.
On each shipment, there is a field in the header – Order No.
On each posted invoice, there is a field in the header – Order No.
The order itself is gone if fully shipped but the order number should link it all.
Hope that helps. -
Jet Reports Historic Posts Thanks for the response on this, the problem we face is that we can have multiple shipments per Sales Order No. Therefore a Sales Order No reference may not in itself be unique link to a given Sales Invoice or Sales Shipment. A work around I'm looking at is to concatenate Sales Order No with a date reference, the result of which should generally be unique but I'm still wondering how Navision/JET does this for itself, surely it too requires a unique identifier to avoid this very issue?
Thanks,
Chris
Please sign in to leave a comment.