0

Trade Creditors Report

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

1 comment

Please sign in to leave a comment.