Take on Values for a Jobs

Create a Sub Quote from the existing job with the closing balances of cost and selling completed to date.

 Create a new inventory custom item called XJOB/OB - X Job cost opening balance

 Use this item code on the quote line.

The lines on the quote can be divided into two, but using the same inventory code.

 1.Costs and sell of past invoiced documents todate on the job

2.Costs and sell based on the difference to the overall budget of the job.

 If the job is existing, then the above two plus the existing new values must equal the total sell and cost estimate of the job.

 Once that quote is created, and pushed to the job, managed the lines to register the costs and sell on the Job WIP reports.

 Create a customer invoice for that opening balance managed lines and process to register that the invoice has been done with no VAT / GST.

You can have the invoice prompt for post and change the ledger to go to the take on suspense account.

Balance the customer account with a customer journal transaction and balance the entry to the take on suspense account.

Allocation the journal and the invoice together.

 It may be a good idea to change the invoice reference to JOBOB with a number sequence starting off with 100.

This should be done outside of normal production time so as to aviod invoice processing using the take on numbers.

Change your invoice number sequence back to your normal invoice range.