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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / financial dimensions i...
Microsoft Dynamics AX (Archived)

financial dimensions in ledgerjournalTrans

(0) ShareShare
ReportReport
Posted on by E. R. 739

Dears,

Please note than I am not able to import financial dimensions through DIXF. I am using entity opening balance.

lines are imported but w/o financial dimensions.

can anyone help?

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Can you provide some details on how and where you want to import financial dimensions? Do you want to create some ledger journals with financial dimension values or do you want to do something else?

    Best regards

    Ludwig

  • E. R. Profile Picture
    E. R. 739 on at

    Hi Ludwig,

    Yes I want to import from excel some ledger journals with financial dimension. I am using Data import export framework but the financial dimension is not working.

    this I a sample of what I am trying to import:

    JournalNum TransDate Voucher AccountType LedgerDimension Txt AmountCurCredit AmountCurDebit OffsetAccountType OffsetLedgerDimension TransactionType ExchRate CurrencyCode LineNum

    XXX-009999 3/31/2018 GJ-003333 0 YYYYYYYY 2018 Tax balances transfer 999 0 YYYYYYYY 1500 USD 1

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    What is your ledger dimension? Does it have a dash included that might prevent the correct identification?

    What might help in addition is the following post if you have not already checked it

    connect.justwifi.pl/.../sgu;cid=81485878&cp=1

    Best regards

    Ludwig

  • E. R. Profile Picture
    E. R. 739 on at

    my ledger dimension doesn't have a dash in my source file but I need to insert dimension in account field. for example the dimension is V3000 which is vendor 3000.

  • E. R. Profile Picture
    E. R. 739 on at

    I am not using a code yet to use AOT job. I am still trying to import them through DIXF.

  • Verified answer
    E. R. Profile Picture
    E. R. 739 on at

    Guys, I solved the issue. it were in source data formats since in the dimensions values I have - so I changed the delimiter. also I added transaction type column to the source file (excel file).

    the import done successfully and the financial dimensions are imported as is in LedgerDimension field.

  • Sam D. Profile Picture
    Sam D. 150 on at

    Hi Elie Rostom,

    I a trying to import or export the opening balance using DIXF , but i got some error , could you please suggest me , what should I do ?

    when i select excel source format and trying to generate mapping and doing save it , it showing me an error

    "Excel sheet lookup value is mandatory"

    and if i select csv file and trying to preview Source file it , it is showing an error

    "The DIXF service is unavailable. Please contact the system administrator."

    and

    "System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Unable to find the application configuration file C:\Program Files\Microsoft Dynamics AX\60\Server\161\Bin\Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.dll.config. Ensure that the assembly containing the specific service client type has an application configuration source file present. Paths below were inspected:

    C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy\v4.0_6.3.0.0__31bf3856ad364e35\Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.dll.config

    C:\Program Files\Microsoft Dynamics AX\60\Server\161\Bin\Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.dll.config

      at Microsoft.Dynamics.IntegrationFramework.ServiceReference.GetConfigFilePath(Type serviceClientType, String configFileHintPath)

      --- End of inner exception stack trace ---

      at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

      at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

      at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

      at Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrStaticMethod(ClrBridgeImpl* , Char* pszClassName, Char* pszMethodName, Char* assemblyName, Int32 argsLength, ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)"

  • Martin Dráb Profile Picture
    Martin Dráb 237,882 Most Valuable Professional on at

    Sam D. , your question is off-topic here. You also already have a thread for your question - please continue the discussion there. Notice that I replied there yesterday.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans