Business Central Jobs Beginning Balances import for Project Jobs

(0) Share

Report

Posted on by Melissa Peavler

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!!

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Bilal Haider 408 on at

Like (1)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

Hi,

By billing to date and cost to date what I understand is what actually has been invoiced and what is actual cost incurred. So to post actual cost and sale you can use Job Journal. If you want G/L also linked then you can use Job G/L journal.

Was this reply helpful? Yes No
Melissa Peavler 80 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

Hello,

Thank you guys so much!! I think I am doing something wrong. When I enter a job journal for the Budgeted Cost of $1,629,873.47 the system does not show that it was already invoiced. It tries to make me invoice this amount again.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 408 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

To put budget for job you should use Job Planning line

Was this reply helpful? Yes No
Verified answer

Melissa Peavler 80 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

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. :)

Was this reply helpful? Yes No
tlhgolfer 23 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

I have the same question did you ever get an answer?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

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

Was this reply helpful? Yes No
BCMASTER123 40 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

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,

Was this reply helpful? Yes No
Samantha73 3,213 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

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

Was this reply helpful? Yes No
BCMASTER123 40 on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

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.

Was this reply helpful? Yes No
kjjson on at

Like (0)

Report

RE: Business Central Jobs Beginning Balances import for Project Jobs

BCMASTER123, did you ever come up with how to do this, or what did you end up doing for this situation as I am facing the same need? Anyone else have an idea?

Thanks,

KJ

Was this reply helpful? Yes No