Microsoft Dynamics AX (Archived)

PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

(0) Share

Report

Posted on by krishna.rao@dax

3,002

Hi,

In our organisation.

1. Accounting currency,Reporting currency : AED.

2. Account payable parameters. Post Product receipt in Ledger - NO(un checked).

we are getting different accounting in PO Invoice based on the transaction currency.

Note : In both the cases Vendor,Item are same.

Case1:

Transaction currency for Purchase Order - AED.

In the invoice voucher accounting as below,

a. Credit(-5) - Vendor balance.

b. Debit(5) - Purchase, inventory receipt

c. zero(0) - Purchase expenditure for product

4503.Voucher-AED.png

Case2:

Transaction currency for Purchase Order - USD.

In the invoice voucher accounting as below,

a. Credit(-5) - Vendor balance.

b. Debit(5) - Purchase, inventory receipt

c. Credit(-5) - Purchase expenditure for product.

c. Debit(5) - Purchase expenditure for product.

2845.Voucher-USD.png

In case 2 two additional lines are coming for the posting type Purchase expenditure for product.

Is it the default behaviour in AX.

Anyone please explain why the accounting is different in the each case?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

krishna.rao@dax 3,002 on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Thank you so much for your time.

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

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Hi krishna.roa,

You need to discuss both cases with your customer.

For me case 2 looks "nicer" but at the end of the day you and your customer need to decide.

All the best,

Ludwig

Was this reply helpful? Yes No
krishna.rao@dax 3,002 on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Thanks for your direction.

I don't know much about accounting. I read article Accounting for stocked items on product receipts and vendor invoices.

I posted here for better exposure before doing any changes to the existing functionality.

when we Marked post product receipt in ledger parameter in AP. output will be as below.

Case1:

Case2:

thanks,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Hello krishna.roa,

I think there is nothing you can do about the way how AX creates the voucher. The behavior is standard AX and I would not recommend making an adjustment here as this would influence many other things in AX.

Maybe try activating the post product receipt in ledger parameter in AP and see if your customer likes and understands those postings better?!

All the best,

Ludwig

Was this reply helpful? Yes No
krishna.rao@dax 3,002 on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Experts,

Please expose your thoughts regarding this.

Thanks,

Was this reply helpful? Yes No
krishna.rao@dax 3,002 on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

@Ludwig :

Thanks for the reply.

Customer is not satisfied with this accounting as it seems it's repeated same transactions.

Is it really Ax created new 2 lines for only tracking inventory in Accounting currency.

As i thought Amount(AmountMst field in Table) column is for displaying value in accounting currency only.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Hi,

This is default this is because since in AX you can hold two reporting currency. So AX records the same purchase invoice both in Transaction and reporting currency

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: PO Accounting For Vendor Invoices based on Trans Cur AX2012 R3.

Hi,

The issue seems to be caused by the second line in your voucher which is in USD. For that reason, AX creates the additional two lines that do not make a difference from an accounting perspective. Yet, you have this additional line.

To me the underlying reason seems to be that AX tracks inventory only in the company's accounting currency but not in any other currency used e.g. when posting PO's.

Hope it helps,

Ludwig

Was this reply helpful? Yes No