Microsoft Dynamics AX (Archived)

PO lines Journal financial dimension summarized

(0) Share

Report

Posted on by agus

1,174

Dear Expert

in my PO lines, contains financial dimension as below :

7827.PO.png

once i posted invoice PO, the result of invoice voucher journal was become summarized :

5270.result.png

is there any way the result of financial dimension is in detail (not in summarized) ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

can you check this parameter in GL parameters?

for more information about this parameter check this link

blogs.msdn.microsoft.com/.../source-document-or-accounting-distribution

Was this reply helpful? Yes No
Nathan Clouse AX 140 on at

Like (0)

Report

Hey Agus,

Not that I am aware of. Values will be summarized by posting main account then use financial dimensions based on the article that Mahmoud posted. Main account selection is driven by Item Group and Posting Profile.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Hi Nathan Clouse

if I understand your issue::

this article says "In summary

If you select the value ‘Source document’ in the parameter, the summary account posting will always take the dimension from the Vendor Master

If you select the value ‘Accounting distribution in the parameter, the summary account posting will always take the dimension from the Purchase order lines "

so if you use Source document, system will summarize based on vendor dimension, not po lines dimensions

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

dear hakim,

I've tested 2 options on GL parameter, it was only impact to posting profile = Vendor balance (using findim on PO line or using findim on vendor master).

what i want to expect the result is, financial dimension in PO line detail will have same result once i posted invoice vendor.

example PO lines created :

line 1 = using procurement category "cleaning" net amount $ 100 (main account + BU = 001)

line 2 = using procurement category "cleaning" net amount $ 200 (main account + BU = 001)

line 1 = using procurement category "cleaning" net amount $ 400 (main account + BU = 002)

when vendor invoice posted, the expected journal result :

main account + BU = 001 - debit $100

main account + BU = 001 - debit $200

main account + BU = 002 - debit $400

Vendor balance - credit $700

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

if I understand you, for your scenario , you must use Accounting distribution

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

if use accounting distribution,

the result is below :

main account 618900-001 is still summarized ($700). my expected is :

618900-001 $ 600

618900-001 $ 100

618900-003 $ 300

not

618900-001 $ 700

618900-003 $ 300

is there any missing setup ? or this is ax behavior ?

thanks in advance

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you are miss summary at this point, the system calculates as the expected

the summary will be for every dimension in po lines, not vendor dimension

for example /for the same po

in document sourcing

if you assign business unit 001 in Vendor dimension

you will find 618900-001 only

in the account distribution will summarize per business unit as you see

618900-001 $ 700

618900-003 $ 300

so if you need to achieve your requirements, just make the item as a finincail dimension to prevent the system from summarizing per business unit only

Was this reply helpful? Yes No
agus 1,174 on at

Like (0)

Report

dear hakim,

base on your statement "so if you need to achieve your requirements, just make the item as a finincail dimension"==> what should i do to get my result as below ?

618900-001 $ 600

618900-001 $ 100

618900-003 $ 300

sorry i still don't get the point. :)

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

just create new financial dimension for items from GL / setup/financial dimension

and activate this financial dimension for this accounts from account structure.

so every po line will contain item as a financial dimension and business unit also.

Was this reply helpful? Yes No