web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

DIXF: Importing Budget Register Data with Ledger Dimension

(0) ShareShare
ReportReport
Posted on by 309

Hi all,

I'm using AX 2012 R3 and want to upload my data which is Budget register entry. At the line there is field Ledger dimension which the value should be main account - cost center (for example : 61000101-SALES)

On my DMF - Source Data Format, in tab Application, I have selected (checked) Cost center in Dimension Code while Chart of account delimiter is default '-'

At the processing group I included the field LedgerDimension and in my csv I put 6100101-SALES.

But it return error saying "Dimension string separator is not formatted correctly. Check the parameter settings."

Can anyone help ?

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Sangram Shinde Profile Picture
    2,114 on at

    Hi Axel,

    You can try doing one thing if your setting is correct - create a single budget register entry manually and export that record using entity, you will get the exact format in 'Ledger dimension' field and then check import.

    Thanks,

    Sangram

  • Suggested answer
    Mahmoud Masadeh Profile Picture
    10 on at

    go to DIXF module -setup-source data format- select source data, on the right hand you see application, in the field chart of account delimiter change it to be not similar to your data (select under score or |) then chnage in you excel data format the separator.

    That's all :)  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans