SageForum for UK versions of Sage 50- Help and support.

I'm just wondering if anybody knows a way or an add-on to Sage which would stop previous posted invoices updating if you print them again?

I've just started at a new Company which create invoices via Excel, uploads them via batch to Sage and manually posts/emails them to clients, so in a bid to streamline this process and make it more efficient I am looking into invoicing via Sage.

Invoices are sent in stages of job completion so effectively project based which means we can use the projects section of Sage 50 to record the total project cost and invoice against the project.

Their invoices need to show 'total job cost', 'total invoiced to date', 'remaining to be invoiced' and then details of what we're invoicing for, getting this information isn't a problem and I've managed to replicate their existing Excel invoices but where the problem comes in is when we go back to a previous invoice it is effectively recreating and updating the project information meaning that the 'project invoiced to date' and 'remaining to be invoice' are incorrect based on the original invoice.

I know we could always print off a copy or save a copy on the network but I'd rather not add a stage to the process so really I need a way to 'hard copy' invoices to Sage when we update the ledger so if we need to print a copy invoice for the client or for the auditors it is a true copy.

Any knowledge or ideas would be massively appreciated

Printing and invoice in Sage does not update it, so I am guessing something else is happening and it is a not clear.

Sage does not allow importing invoices into the invoicing module form excel so I am wondering if you are using an add on of some sort.

brucedenney wrote:Printing and invoice in Sage does not update it, so I am guessing something else is happening and it is a not clear.

Sage does not allow importing invoices into the invoicing module form excel so I am wondering if you are using an add on of some sort.

Because it is looking at live field in projects i.e. total billed to date, which is changing every time we reference an invoice to it - when I print preview, say, invoice 1 from a 5 invoice stage project, it would show the total amount billed to date from the 5 invoices rather than what it was at the stage 1 invoice.

Sorry, maybe I didn't explain properly, invoices are currently being done manually on Excel, I am looking into invoicing directly on Sage which is why this problem has come up.

Having just spoken to Sage, apparently, there isn't anything I can do other than taking a copy via PDF unless we upgrade to Sage 200 which has the ability to effectively 'hard copy' an invoice at the stage of creation. Does anybody know an add-on which would help with our issue?

Well, I still don't understand.

If you raise the invoice in sage, it can't be updated to the ledgers more than once.