AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

Finally Done Importing

June 10, 2013 by Tim Rodman

I finally finished the data migration portion of the F100 Hands-On Financials (V4.0) course. Data migration is my least favorite portion of any implementation because:

  1. I think it’s boring
  2. It always takes much longer than you think it will

It took me a few late nights to finally get through this. There was some bad data in some of the import files that I had to cleanup in order for the import to go through successfully. When you import AP and AR open bills/invoices, the system automatically makes a journal entry which you then manually have to enter a reversing entry for. Also, the dollar amount of the imported items was $.02 different than what was in the Excel file which must have been due to rounding. I’m assuming that Acumatica put the errors in the import files intentionally so I could get some practice.

The next step is to schedule an appointment with an Acumatica instructor in order to review the setup configuration and data that I imported into the test company on my laptop. I sent an email to learning@acumatica.com requesting an appointment. We’ll see how long it takes for a response.

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Data Import, Acumatica Training, Acumatica University, F100

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • acuCONNECT 2025 – Visualizing Inventory Balance $ and Service Level % TOGETHER September 19, 2025
  • EP 157: acuCONNECT 2025 Preparation – Part 4 (Podcast) September 16, 2025
  • EP 156: acuCONNECT 2025 Preparation – Part 3 (Podcast) September 6, 2025
  • EP 155: Chris Hackett – Update on Acumatica User Groups (Podcast) August 26, 2025
  • EP 154: acuCONNECT 2025 Preparation – Part 2 (Podcast) August 5, 2025

Recent Forum Posts

  • Travis

    RE: Pick List report suddenly not splitting on Shipment

    I never found a solution initially - here I am 3 years ...

    By Travis , 2 weeks ago

  • ToonSix

    RE: Feeling Stuck on Making a Sandbox of our Database

    Delete as many snapshots as possible before making a ne...

    By ToonSix , 2 weeks ago

  • Retha

    RE: Printing Product Labels from Purchase Receipt

    I have read the article on the How to print multiple pr...

    By Retha , 3 weeks ago

  • Paul Lambert

    RE: Generic Inquiry into Business Event to monitor Import Scenarios

    An idea I've been brainstorming and haven't yet tested ...

    By Paul Lambert , 3 weeks ago

  • Jacky Mao

    How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)

    Hi everyone, I’m trying to create a Business Event fo...

    By Jacky Mao , 3 weeks ago

  • Lunar Windbloom

    Feeling Stuck on Making a Sandbox of our Database

    Hi all! Hope your day is going well! It's finally the...

    By Lunar Windbloom , 1 month ago

  • Tim Laird

    RE: [SOOrder.Status] = 'Open' always returns false

    @russ Customer Classes are user maintained, so you setu...

    By Tim Laird , 1 month ago

  • Tim Laird

    RE: What Triggers a Customization to need a Restart?

    OK, one more update. This creeped up again this weeken...

    By Tim Laird , 1 month ago

  • russ

    RE: [SOOrder.Status] = 'Open' always returns false

    This trick doesn't seem to work anymore. At least not ...

    By russ , 1 month ago

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.