Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Excel Budget import

Posted on by 340

When importing a 9 MB file (1.3 MM data points, it took over 50 hours to complete the import. At the end of the process, there were a few lines with minor variances. Small amounts, but no reason for them to be there.

Are there limitations on the size of a budget import file? I don't find any mention of maximum file size or number of transactions.

  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Excel Budget import

    Hello Mike,

    Regarding your Budget File, this is extremely large and likely the cause of your issue. I had a case previously where a 35,000 line budget was failing the import with the following error.

    We found a problem with some content in [file name]. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

    This file has 35,000 lines and is only 35 K. Your file you are saying is 9 MB. GP itself can hold a maximum of 37,767 in our temp tables. I am actually surprised that your 9 MB is not erroring and allowing the process to actually complete.

    What i would recommend you do to further test this is break up Excel Budget that you are importing into smaller files and import them to determine if each individual file comes in without the problem. This way you know it is the file size.

    I hope this helps!

    Microsoft Support Engineer | Brandon Jarrett

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans