Good Afternoon,
I am trying to write a Jet Report that will run every afternoon and pick up only the Purchase Orders that were raised that day.
I can get the report to run and show the details when I manually enter the date, but I would like to know what filter I can use that will work in the scheduler and only pick up the date the report runs.
We have several Companies, so I will have it set for each one, but it is escaping me how to set it to filter on that day.
Help Please! :)
Thanks,
Mark
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Mark,
Every PO has some fields wich you can use to generate the report you want
In the Purchase Header there are 2 fields, Made By and Made on.
I have a dutch translated tables in my Jet, so i will try to give you the correct NL function
=NL("rows";"Purchase header";;"0";"company name";"Made On";c2)
Where c2 is the date fields you wish to view or you can use =today()
to get the fields from the purchase header you can use the NF function.
Good luck.. -
Jet Reports Historic Posts Thank you very much for that.
I will try it, and let you know.
What I have done currently is set it up so it references a field with =TODAY() and it seems to update that automatically at the scheduled time.
Mark
Please sign in to leave a comment.