Hello,
I am trying to get a report for my warehouse supervisor that will help them determine how much duty should have been paid for customs. They provided the format and I am inserting the jet functions below. All information is provided on the sheet for me to work off of.
I figure there are two ways I could do the report:
1) use a rows function from the sales invoice line table to get the items and filter off the sales invoice header and item table or
2) use a rows fuction from the item table and filter off the sales invoice line and header tables
I think the problem I am having is that the filter is too long or complex for JET to be able to calculate it. I know basic jet functions but don't know how to join or link tables. If anyone can provide any help as to why this formula for the quantity isn't working or what a better approach to creating the report would be it would be a great help. Thanks in advance!
Here is my work so far:
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I think your NL Filter is already correct. Just reference it in the NL Sum column should do it.
But I think I found some fundamental errors in your design that you need to fix to get your report going. I made the comment directly in the spreadsheet. Go and try it.
Andy
Please sign in to leave a comment.