Skip to main content
Solved

Importing on Mass Live Projects opening balances & maintaining proforma invoice no. sequence


Forum|alt.badge.img

Implementation questions

 

What is the simple most effective way to import 100s of Live projects into our customers new environment? Is it import scenarios and then some manual work project by project for balances etc?  

 

Is it possible to bring over projects which are midway complete into Acumatica? I.e., a project 6 months into 12-month schedule and on claim (proforma invoice) no.6 - How do we import and indicate or make the project start in Acumatica from that same reference no.6?

Best answer by Laura02

Hello,

There are two articles in this community that provide the steps. There is a customization (as of 2022 R1 it is still a customization -- I don’t know about migrating construction projects in 2022 R2 yet) that provides migration mode in Construction module, migration mode used to link each AIA to the related AR Invoice. Import Scenarios provided by Acumatica.

 

https://community.acumatica.com/project-accounting-126/how-to-import-progress-billing-balances-step-by-step-guide-3990

 

https://community.acumatica.com/construction-128/how-to-import-progress-billing-balances-general-information-3932

It’s an arduous project to migrate open projects with AIA, but if I can do it, you can do it!  My recommendation is to start practicing the process of pulling data out of the old system and importing it.  Before Go Live you’ll want to have the spreadsheet format and import scenarios perfected & practiced. 

@Heidi Dempsey taught me:  Dates, reference numbers, order of documents is crucial when migrating your history.

In summary, this is the order of migration:

  1. Customers
  2. Projects
  3. Tasks 
  4. (Cost Codes - optional)
  5. Revenue Budgets
  6. Cost Budgets
  7. Change Orders
  8. Open AR Invoices and paid AR Invoices that have Retainage open
  9. Proformas with links to invoices from step 6.
  10. Project Actuals - project to date historical totals via Project Transactions screen
  11. Validate Project Balances
View original
Did this topic help you find an answer to your question?

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 30, 2022

Hello,

There are two articles in this community that provide the steps. There is a customization (as of 2022 R1 it is still a customization -- I don’t know about migrating construction projects in 2022 R2 yet) that provides migration mode in Construction module, migration mode used to link each AIA to the related AR Invoice. Import Scenarios provided by Acumatica.

 

https://community.acumatica.com/project-accounting-126/how-to-import-progress-billing-balances-step-by-step-guide-3990

 

https://community.acumatica.com/construction-128/how-to-import-progress-billing-balances-general-information-3932

It’s an arduous project to migrate open projects with AIA, but if I can do it, you can do it!  My recommendation is to start practicing the process of pulling data out of the old system and importing it.  Before Go Live you’ll want to have the spreadsheet format and import scenarios perfected & practiced. 

@Heidi Dempsey taught me:  Dates, reference numbers, order of documents is crucial when migrating your history.

In summary, this is the order of migration:

  1. Customers
  2. Projects
  3. Tasks 
  4. (Cost Codes - optional)
  5. Revenue Budgets
  6. Cost Budgets
  7. Change Orders
  8. Open AR Invoices and paid AR Invoices that have Retainage open
  9. Proformas with links to invoices from step 6.
  10. Project Actuals - project to date historical totals via Project Transactions screen
  11. Validate Project Balances

Forum|alt.badge.img
  • Freshman I
  • December 18, 2022

Hey Laura,


Those links to those two articles don’t work for me… Do you know how I am able to request access to them?

 

Thanks,
​​​​​​​Kurt


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • December 23, 2022

Hi @kemery - your community access is as registered guest so you won’t have access to KBs. you may want to work with your partner to supply them.


joelhoffman
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • December 28, 2022

Hi Everyone,

I wanted to add some information to this post.  We are adding the ability to import Pro Forma Initial Balances with our 2023 R1 Release.  We have incorporated what was previously available with customization, updated and included with our general release.

Look for the release notes and details to come.

Thanks.

 


Forum|alt.badge.img
  • Freshman I
  • July 14, 2023

@Chris Hackett Hey Chris, we are the partner (still quite new) but we are down here in Australia (MYOB Adv) …

 

We are really keen to see this article as we are solely construction dedicated and our clients have project balances to bring over efficiently…. 


Forum|alt.badge.img
  • Freshman I
  • July 14, 2023
joelhoffman wrote:

Hi Everyone,

I wanted to add some information to this post.  We are adding the ability to import Pro Forma Initial Balances with our 2023 R1 Release.  We have incorporated what was previously available with customization, updated and included with our general release.

Look for the release notes and details to come.

Thanks.

 

Hi Joel,

Is there somewhere I can look for those release notes? Thanks in advance


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 14, 2023

Hi @kemery - I'm afraid the community platform doesn't control access to these areas. That is controlled by your role access in your business account. @joelhoffman - do you know how an MYOB partner gets this information? Thanks!


joelhoffman
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • July 14, 2023

Hi @kemery , here is a link to the 2023 R1 Release page, which has the software downloads and release notes.  One item to mention, MYOB typically trails Acumatica releases by 1.  Meaning the MYOB fall release would be compatible with our R1 version each year, and the spring release is compatible with our R2 version.  As this is in Acumatica 2023 R1, it would be in the MYOB Fall 2023 Release.

https://community.acumatica.com/supported-releases-67/acumatica-2023-r1-downloads-and-release-notes-15514

 


Forum|alt.badge.img
  • Freshman I
  • July 16, 2023
joelhoffman wrote:

Hi @kemery , here is a link to the 2023 R1 Release page, which has the software downloads and release notes.  One item to mention, MYOB typically trails Acumatica releases by 1.  Meaning the MYOB fall release would be compatible with our R1 version each year, and the spring release is compatible with our R2 version.  As this is in Acumatica 2023 R1, it would be in the MYOB Fall 2023 Release.

https://community.acumatica.com/supported-releases-67/acumatica-2023-r1-downloads-and-release-notes-15514

 

Thanks Joel, this is another one that is locked unable for us to access….

 

We do know where to find the release info with MYOB (1 season behind as you mentioned) but as Construction is only a more recent MYOB focal point we are lagging Acumatica with the depth of knowledge specific to construction in these releases… Would be massive if I could get access to these locked articles somehow ... 


patrickcolgan94
Freshman I
Forum|alt.badge.img

Has the cutover process to take a client live been changed or improved with the 24 R1 version release?  Just trying to stay current with the latest best practices.


Forum|alt.badge.img

Practice is key here! If you can export data from your system you just need to find someone that is excel savy, power query, or other software at transforming / aggregating this data.

 

Start with 1 project, review in TONS of detail with various members of your team. As an example, we had about 25 iterations before out team felt confident in the upload.

 

Then once uploaded in Test environment, try uploading all at once. Utilize the reporting on budgets and actuals in acumatica and old system to validate for accuracy. We got everything to about 97% accuracy and decided that was close enough. 

 

There is almost no way around this being painful in my opinion because every companies data is stored and managed differently. You have to create a 1 to 1 translation between the systems. Feel free to reach out to me and i’m happy to share our experience and any lessons learned. Send me a PM on here.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings