Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

I am using transaction import to import into budget maintenance. It completes with no errors but only the annual budget and period one populate. I matched all of my columns to the control file and find no issues.

Posted on by 185

Does anyone know how to fix this issue?

*This post is locked for comments

  • Sharon Moore Profile Picture
    Sharon Moore 185 on at
    Re: I am using transaction import to import into budget maintenance. It completes with no errors but only the annual budget and period one populate. I matched all of my columns to the control file and find no issues.

    I was using a simple macro.  I regenerated the macro using intelligent and it worked beautifully.  Thanks so much!

    Sharon

  • Verified answer
    Re: I am using transaction import to import into budget maintenance. It completes with no errors but only the annual budget and period one populate. I matched all of my columns to the control file and find no issues.

    Hi Sharon,

    I used your line of data except for changing the account and subaccount and it imported perfectly.  I am using an Intelligent Control Macro.  I unchecked the Run Minimized box .  In the Transaction Import screen, click Options.  I have Combined Edit and Update checked.  

    Also, are you testing the same account/sub over and over?  Try and test a different account/subaccount using the settings that I have above.

    Let me know how it goes.

  • Sharon Moore Profile Picture
    Sharon Moore 185 on at
    Re: I am using transaction import to import into budget maintenance. It completes with no errors but only the annual budget and period one populate. I matched all of my columns to the control file and find no issues.

    Hi Carolyn,

    It will work if I want to equally distribute it but if I try to but manual only picks up the first month.  Here is one line of data:

    Budget,52102,070000,Budget,2012,,9496,791,791,791,791,791,791,791,791,791,791,791,790,

    and here is the message I get

    'System Message 8000: Start Processing 09:02:47

    'System Message 8042: Transaction Import Processing Combine Edit and Update mode

    'System Message 8040: Database Name SIVAPPLICATION      

    'System Message 8011: ========Begin Processing of a Budget Data Line========

    'Budget,52102,070000,Budget,2012,,9496,791,791,791,791,791,791,791,791,791,791,791,790

    'System Message 8005: New Record Requested

    'System Message 8012: ========Successful Processing of a Budget Data Line========

    'System Message 38: Warning - Total of period does not equal annual amount.  Do you want to correct?

    'System Message 8029: Button CANCEL was pressed

    'System Message 8030: The Number of Errors detected was 0

    When I go to budget maintenance, the only items that show are the 9496 and 791 in January.

    Thanks

    Sharon

  • Re: I am using transaction import to import into budget maintenance. It completes with no errors but only the annual budget and period one populate. I matched all of my columns to the control file and find no issues.

    Hello Sharon,

    This is a sample line from a data file for the Budget Maintenance screen that works properly for me:

    BUDGET,3032,000000000000,BUDGET1,2011,,1201,101,100,100,100,100,100,100,100,100,100,100,100,

    Also, here is another if you are distributing equally;

    BUDGET,3032,000000000000,BUDGET1,2011,,1201,,,,,,,,,,,,,E

    Off hand I can't say what the issue is without looking at your data but perhaps the above two examples will help figure out what is wrong with your data file.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans