You’re offline. This is a read only version of the page.
Announcements
20
Hi,
Newbie lonely developer here.
SSRS_Report_LedgerBalanceTotalAndBalance show us the amount of balance total on local currency(AmountMST).
Now I hope to add a field indicating the total balance of the foreign currency transaction amount in addition to the original field.
Because we also need to know how much the transaction amount is.
First I think maybe the DP of SSRS_Report_LedgerBalanceTotalAndBalance will be the resolution, so I take the Class_LedgerBalaceMainAccountAmountByCurrency for help.
But the result is the same as the Class_LedgerBalaceMainAccountAmount..
Now I know the amount is from Class_LedgerBalanceQueryGeneralJournal, then try to extends a new class base on LedgerBalaceMainAccount.
somehow the method getTransactionCurrencyCreditBalance is gone and cannot be used.
Try referencing to SSRS_Report_AccountStatementByCurrencyReport (LedgerAccountStatementPerCurrency), but the business logic is another way.
I don't know the relation about MainAccount, GeneralJournalEntry And GeneralJournalAccountEntry.
This issue got me so hard, still don't know these things well.
More research, makes me more confuse..
Any suggestion?
Best Regard.
Ludwig,George :
Thank you for your careful answers and guidance on this question.
My area of responsibility lies in SSRS reports based on RDP, and they let me do what I can do.
After I proposed the solutions suggested by you two and discussed them with my team and customers, they think the out-of-the-box MR solution did not satisfy them.
Thankfully, after studying the structure of the SSRS_Report_AccountStatementByCurrencyReport and referring to the recommended financial reporting, I came up with the following path to obtain the desired data, but I don’t know if it is correct. It has been submitted to the project team for testing. If you have any further suggestion, please correct me.
MainAccount >> GeneralJournalAccountEntry >> GeneralJournalEntry
Thank you again for your dedicated response. I have always believed that this community has vitality and enthusiasm, and I look forward to the ability to contribute to this community in the future.
Good morning Leon,
Just wanted to follow up on this one and ask whether there is anything else the community can help you with?
Best regards,
Ludwig
Hi Leon,
Welcome to our Microsoft Dynamics Community forums!
I agree with Ludwig's assessment. It could be much easier to create such a report using Management Reporter.
To get you started, please allow me to share the following documentations:
Hi,
I would recommend using the management reporter for this purpose.
That is because calculating a foreign currency balance requires a translation, i.e. application of a exchange rate.
For those translations different rules exists e.g depending on whether you translate a balance sheet account balance or a P&L account balance.
With the MR you can do that out of the box.
If you create a SSRS report yourself you have to code all of those rules if you want to use if for accounting purposes and not simply show a simply summary of foreign currency amounts.
Best regards,
Ludwig
#1
André Arnaud de Cal...
294,165
Super User 2025 Season 1
#2
Martin Dráb
232,964
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
