Microsoft Dynamics AX (Archived)

Financial Dimension on Sales Invoice

(0) Share

Report

Posted on by Dexin

452

Hi,

I encounter the issue below

I inserted my financial dimension in my sales order lines (different from SO header). However when i posted my sales invoice, i found that the debit account and credit account captured different financial dimension.

Please see below my scenario:

In my sales order header, i tag my financial dimension for my project dimension as "Project A", but in my SO line, i tag my project value as "Project-waste"

When i posted my Sales invoice

I found that:

1. "Project A" value goes to my customer balance account

2. "Project Waste" value goes to my revenue account

I was expected both customer balance and revenue account also capture the project-waste

I tried posted the transaction by using the Free Text Invoice, i got the expected result. Both the customer balance and revenue account also capture the financial value from Free Text Invoice line

How to resolve the issue in SO invoice?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

In the GL parameters form there is a specific parameter that defines from where financial dimensions are used. What is setup in your case for this parameter?

Do you have default financial dimension values setup at the customer, project contract or project level?

Best regards

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dexin,

As the values on multiple lines can be different and there is only one customer balance ledger transaction, it will take this one from the header. This is by design. If you need the dimension be taken from the (individual) lines, it would be a customization which I would try to prevent. Would it be an idea to have a sales order per IntercoProject?

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Hi Ludwig,

The parameter you mentioned is called "Values use for summary account".

I set to "Accounting distributions" by right the dimension value will take from SO line.

I tried in Purchase Order, i purposely put the PO header and PO line is different dimension value, when i post the Purchase Invoice, i notices the vendor balance summary account dimension is posted from the PO line. This the the expected result.

In Sales Order, it;s not the same. The customer balance summary account is always take from SO header.

Wonder why is it so.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Dexin,

Can you check LCS and whether a hotfix is available for your system version? I would consider this a big. Can you also double check whether you can replicate the issue in a different demo/test system?

Best regards

Ludwig

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Ok will try that.

Thank you

Was this reply helpful? Yes No
Guillaume 80 on at

Like (0)

Report

Hello Dexin

I have the same issue you described here.

Did you solve it ?

If yes, could you share your solution please.

Thanks in advance

Guillaume

Was this reply helpful? Yes No