Does anyone know how to create a Trade Creditors report based on the balance at a certain date, my formula is as follows, but obviously this only reports on the balance now.
I need the report so that I can do a balance sheet rec, as running the report on the last day of every month is not always possible due to weekends.
=NL("Rows","Vendor",,"Limit=",$C$11,"-Balance","<>0","DataSource=",$C$8,"Company=",$C$9)
Thank you
Date
Votes
1 comment
-
Jet Reports Historic Posts The definition of the Balance Flowfield shows that a date filter cannot be applied - you are right about that. Fortunately, the Vendor Table also has a Net change field which has the same definition as the Balance field + the Date filter!
Please let us know if this functions gives you what you are looking for:NL("Rows","Vendor",,"Limit=",$C$11,"-Net change","<>0","Date filter",CellWithDateFilter,"DataSource=",$C$8,"Company=",$C$9)
Please sign in to leave a comment.