Jump to content

2 Q's. Invoice Statements


johnnysalt

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello, I'm hoping that somebody can help me out. I have spent the last 2 days trawling through this resource and others looking for the answer with no result.

I have produced a fm system for my my graphic design business. Its fantastic (the software that is, not necessarily my system) and has eased up the workload considerbly. However there is one area that needs attention, namely sales invoice statements.

Basically I want to produce sales invoice statements for my clients that display the total of: 'Invoices that are Over 30 days due, Over 60 days due, Over 120 days due.

The invoices at the moment capture the 'Total' and 'Issue Date'. I think that I should be able to produce 3 calculation fields that will work out which files have a greater difference between the Currentdate and the date off issue of 30 (60, 120 etc), then get a summary of the running total (I have a summary field set up capturing the running total of the invoice total. I have tried but so far nothing is working, any ideas?

The other problem was that at the moment I perform a find for all Unpaid invoices, then I have to record (with a pen and paper, sorry) the clients and then perform another find for the client name and status = unpaid. I would love to be able to run a script that found all unpaid invoices, then grouped by the client name and printed out a statement list (showing the 3 fields above of course).

Hopefully somebody can help me out,

Cheers

Johnny

Link to comment
Share on other sites

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.