80
We are currently entering beginning balances for open Projects. For Example, project A has the following:
|
Contract Billings |
$ 1,666,551.00 |
Budgeted cost |
1,243,845.28 |
|
Billings TO DATE |
$ 1,629,873.47 |
Cost to Date |
1,213,328.42 |
|
Remaining Billings |
$ 36,677.53 |
Remaining Cost |
$ 30,516.86 |
How do we get the Billings to date and Cost to date in the system as opening balances for this job?
Thanks SO MUCH!!
Basically what we did was raised invoiced on each job from the jobs module. But to have no financial impact we just add a line to the invoice to zero out the invoice. We made sure that new line was not linked to the job or it would reflect.
So there was zero financial impact but the job showed it was billed and the WIP routine. It was a bit of hard labour but with 4-5 people raising these invoices it did not take that long.
You will need a customization in order to create invoice for several jobs in one batch job. Or you can check if there is something available on AppSource for this.
Thanks!
For the invoice, I am looking to do this on mass. I have about 150 jobs to move in. Any idea where to start? How to create 150 invoices?
Also if I want to preserve the data in relation to the items invoiced? i.e. So my team can look at the job and then see what lines have been invoiced and what has not. Any idea how to do this.
You can enter a summary by project in terms of cost and invoiced. For this you can create a job tasks and change the WIP method = '' so the WIP calculation will ignore these tasks. Now for the cost you enter GL Type planning line and a job journal (no GL impact). For invoiced amounts, create an invoice and enter a manual negative line to off set the amounts on the un posted invoice
Hi!
Do you have any details instructions?
For my clients, we are trying to import the billings for each job that was previously invoiced from another accounting system.
We have looked and it appears the only way is to actually create an invoice for each invoice that was posted to have it marked as invoiced for each line.
Thanks,
Melissa,
Sadly, if you want to show beginning balances of a Job when transitioning to BC their is no simple method or field to populate the amounts. This is what I did for a customer once (yes once since others mainly enter the balance unbilled and cost not posted).
I can take the Billing to Date and Cost to Date and enter against a GL Account. I can produce the Jobs Invoice. Since all these amounts have been previously posted I will prepare a Credit Memo to the Customer and reverse the Balance and entries to the GL Accounts and make sure the credit DOES NOT effect the Job. Now the GL is corrected and the Job reflects the opening balances.
Another idea might be to have your Partner add a few fields to the Job Header and Statistics so you can enter the Billing to Date and Cost to Date, pre-BC.
Hope this helps.
Thanks,
Steve
Thanks so much for the help!!
It is actually the billings to date. When we put this in it is invoicing it against wip again. :)
To put budget for job you should use Job Planning line
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
