Dimensions to flow into intercompany journal

(0) Share

Report

Posted on by Community Member

When dimension rules (account structure ) are in place and posting an intercompany journal, dimensions are not flowing into inter-company accounts on posting a multi line voucher scenario.

Eg:

Expense Dr (Entity ABC)

Expense Dr (Entity XYZ)

Vendor A Cr (Entity ABC)

Regards

Setty

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Setty,

Have you specified the legal entity in the journal that use used for recording the second line?

In which Journal did you record and post the Transaction? (GL Journal, ...)

Can you show a screenshot of the general tab of that journal for the second line recorded?

Moderator: removed the suggested answer as it contains only questions, no possible solution.

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

I am using GL journal (journal type 'Daily').

If i enter an inter-company voucher in one line (debit and offset credit in the same line) it is posting but, when i split the same voucher in 2 different lines, say, debit account in one line and credit account in the second line then it is giving dimension rule error.

I am not sure how screenshot is attached. Will the above info help you understand my issues? If the below scenario works then making compound entry (multiple debits and credits) in single voucher will work.

Example: Vendor A Credit (Legal entity USRT) and Expense Debit (Legal entity USMF).

Regards

Setty

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Setty,

I just recorded a test transaction between my demf and frsi companies by entering the voucher in separate lines and AX posted this transaction without any error.

Does your journal look similar?

Ludwig

P.S. By selecting the rich text formatting option just below the text box you can paste photos/screenshots.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

Here is the screenshot. Entered the same voucher in 2 different ways.

1 Voucher ENV-GJ-0000062 is posted.

2. Voucher ENV-GJ-0000063 is not posted and giving account structure error.

3. Vendor 10001 of BSC entity has BU and department different from ENV legal entity offset account in both the scenarios.

Regards

Setty

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ludwig

Ignore the previous email. The screenshot that i gave you are incorrect. I will update it with the correct scenario.

Regards

Setty

Was this reply helpful? Yes No
Suggested answer

Kristi Slininger 66 on at

Like (0)

Report

Hi Setty,

The functionality you are seeing is by design. The example you are entering is fairly simple, but an intercompany journal with multiple lines can get much more complex. In these complex IC transactions, AX wouldn't be able to determine which dimensions should default onto each due to/due from that is created. For example, let's say you entered these four lines:

Expense - Dept A 25.00 DR (Company A)

Expense - Dept B 75.00 DR (Company B)

Vendor - Dept 100 10.00 CR (Company C)

Vendor - Dept C 90.00 CR (Company D)

AX allows this type of entry, and there is no way AX can determine your intentions for how to split the dimensions between the Due to/Due from entries that need to be created.

This is why AX will default the dimensions appropriately when you enter the transaction on one line, because then it knows which offset account corresponds to the Account.

Thanks

Kristi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Setty,

I agree with Kristi that the automatic dimensions defaulting won't work in this case.

Yet, by entering them manually you should be still able to get the second voucher No. 63 posted.

I tested even including 3 different companies and things worked without an error message.

If entering the default dimension values is not an option for you then you can probably prepare and upload your voucher via the Excel add-in.

With some minor code adjustments you can then even post vendor, customer, fixed asset, etc. Transactions.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Kristi, Ludwig

Kristi has rightly identified my problem. I guess in order to address this scenario we will have to make code changes.

Thanks again, appreciate your help.

Harsha

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

Like (0)

Report

Hi Harsha,

Agree :-) Would you be so kind and verify Krisits finding as verified to let also other users know and easily find the answer. Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Guys, there is a conceptual issue in the Inter-company analysis who ever did this. It's not a problem, but gap.

Was this reply helpful? Yes No