Good morning - I am trying to create a Jet Report that will allow me to create an Accounts Payable aging by my global dimension 1 (which is location). I am able to create a aging but whenever i try to filter it by the dimension 1 it errors out. I am very new to Jet Reports and could use your help.
=NL("Sum","Vendor","Balance Due ($)","Date Filter",$C$3,"Global Dimension 1 Filter",K$11,"No.",$E13)
Thank you
Gretchen
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Gretchen,
Global Dimension 1 Filter is a flow filter field and Balance Due ($) is a flow field. I'm guessing you are trying to use some sort of wildcard character such as * or ? in your filter for Global Dimension 1 Filter which is not allowed (by NAV). If you look at the definition of the Balance Due ($) field in NAV, you can see that the flow field is actually getting its information from the Detailed Vendor Ledg. Entry table. It's summing the Amount ($) field from that table. So if you change your formula to sum that from that table and field, you can replace your Date Filter with Posting Date and the Global Dimension 1 Filter with Initial Entry Global Dim. 1 and No. with Vendor No. and you should be good. The formula would look something like this:=NL("Sum","Detailed Vendor Ledg. Entry","Amount ($)","Posting Date",$C$3,"Initial Entry Global Dim. 1",K$11,"Vendor No.",$E13)
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hughes - Thank you very much. The new formula you gave me works perfectly. I appreciate your help in this matter.
Gretchen
Please sign in to leave a comment.