Hi , I have to make a report that display accrued unpaid outstanding so i have to retrieve records from client ledger entry table where due date is before current date . I tried to fix it with nl function that filter on due date based on cell but doesn't work.
Cananyone help me please.
5 comments
-
Jet Reports Historic Posts Hello mehdi.souihli,
Can you attach a copy of your report so that we can see how it is constructed and what you are attempting to do?
I might be able to recommend how you can fix it to work in the way you desire.
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson,
This is how my report must looks like file:///C:/Users/mehdi.souihli/Desktop/Accured%20unpaid%20outstanding.bmp I have to load all records from cust Ledger Entry table where (Due Date <= Today). -
Jet Reports Historic Posts Hello mehdi.souihli,
Your screenshot was not posted correctly, so I am unable to see it.
The correct syntax for a less than or equal to today filter would look like this: "Posting Date","<="&TODAY()
e.g.
=NL("Table","G/L Entry",,"Posting Date","<="&TODAY())
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson,
Thank you for help it worked perfectly for me,but actually my report must display 3 curves, the first for the amount where due date is between today and past 30 days , the second 30days< Due date < 60days and the third one 90days<Due date<120 days. It seems possible with jet report essential license but i don't find solution with jet report express.
Have you some advice to me? and thank you again. -
Jet Reports Historic Posts Hello mehdi.souihli,
You are correct, this is something that you would need to utilize Jet Essentials to accomplish in the same report.
You could do this with Jet Express using certain FlowFields (e.g. Net Change) if they have a date filter available to them, but due date is not one of them.
Best regards,
MWilson