Get Financial Dimension available combinations according to Account Structure and Advanced Rules

(0) Share

Report

Posted on by Community Member

Dear all;

I've a requirement for export all FD available combinations for external system;
My customer needs to obtain all available values from 3 dimensions regardless of mainAccount,

and I'll export it to csv file.

I'll appreciate your help.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi opozo,

What I got from your post is that your customer want's to use the available financial dimension combinations that you setup in AX and use them in another system/application to verify whether the transactions that are recorded there are correct. Is my understanding right?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig;
Yes, you're right; they need to know all available combinations between 3 dimensions for Travel expenses management on external app (...)
But they are not stored in DimensionAttributeValueCombination table because there are no records for this combinations yet, and they don't
need the mainAccount. There are no restrictions for main account in Account Structure, but yes for the other 3 dimensions.
I've arrived from DimensionHierarchy until DimensionConstraintNode table and I've the restrictions from - to , but I'm not able to retrieve all the
values. I need something similar to the behavior of segmented entry control, to get the available values for these dimensions.
Thanks for your fast reply.

Regards.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi opozo,

I'm not sure whether this approach makes sense. Imagine something is changed with the account structures in AX, then you have to make sure that your external system that should follow the same accounting rules is in sync with those changes. I can't imagine how this should work with an Excel export of the AX account structures. Maybe you could explain a bit more about the planned integration between the different systems. I believe it would help to get valuable feedback from community members. Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi ,

i have a similar requirement where I need to get all the financial dimension combinations via inbound services. In my context, external systems will be in sync and follow the same accounting rules.

I couldn't find any inbound service to retrieve those valid combinations :(

Any help is appreciated

Was this reply helpful? Yes No
Sagnik Majumder 792 on at

Like (1)

Report

Hi Opozo,

Have you got any solution to your requirement? I am also in need of similar scenario.

Was this reply helpful? Yes No