Microsoft Dynamics AX (Archived)

How to get Accumulated and Total Vendor Account Statement Report in Transaction Currency

(0) Share

Report

Posted on by Safeer PS

507

Dear All,

I need to get Accumulated amount and Sum of total Transaction amount as it is calculating for Company Currency .

Please see attached image.

You can see company set currency' s Total and accumulated Balance amount shown in report. I would like to get Transaction Currency amount like that.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Safeer PS,

Does this make sense?

Let's assume you have a vendor with Transactions in USD, EUR, GBP.

Do you want to have those amounts than added up?

Best regards,

Ludwig

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

Generally If we are default currency of vendor as USD, OR GBP. Also Accounts should know amount given as USD to supplier not only company currency amount.

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

Like (0)

Report
Copy link

Link copied!

Hi Safeer PS,

I got your point.

What report have you run above? Is this the vendor account statement report?

Best regards,

Ludwig

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

Yes Above pic shows the result. They need Transaction currency(GBP) total amount and accumulated totals

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

CustVendTransData Class >> Amoutn MST method is there .

I think Sum(RemainingAmtCur) will give total GBP transaction amount .

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

Same Issue posted earleir :

community.dynamics.com/.../172985

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Safeer PS,

For this purpose you need to customize the report, that is also mentioned in the related thread.

When doing that you have to be careful with the design especially if you have vendors that have invoices in multiple currencies (USD, GBP, EUR, AUD...). I would assume that you can't fit all currencies next to each other in columns on a single report page, which might require a complete overhaul of the standard design of the account statement. Probably talk with your development colleagues first whether it might be easier creating a completely new report rather than trying to modify the standard one.

Best regards,

Ludwig

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

Please see second atatched pic. I just need total of transaction currency and accumulated balance. For that I can edit desgn of report - Vend AccountStetementIntRPt

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

Like (0)

Report
Copy link

Link copied!

Hi Safeer PS,

If you have only two currencies involved modifying the report calculation will work; you simply need to copy/modify the calculation expression from the column that has the amount MST field included.

Yet, before doing that can you record another invoice let's say in GBP? Then your transaction currency column will show GBP and SAR invoices mixed (assuming that USD is your accounting currency) and calculating those values in different currencies won't work anymore.

Best regards,

Ludwig

Was this reply helpful? Yes No
Safeer PS 507 on at

Like (0)

Report
Copy link

Link copied!

Let me Try

Was this reply helpful? Yes No