Small and medium business | Business Central, N...

Can we get General ledger expanded with dimensionSetLines by currency

(0) Share

Report

Posted on by onplan

I have two currencies in my company that is USD and CAD. When I am hitting general ledger api I am getting amount in CAD but I also want same report in USD. How can I do that ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

What is your LCY (Local Currency Value) I believe in Revenue and AR G/L all currency store as LCY (Check your General Ledger Setup). If you want both LCY and other currency you need to check "Customer Ledger Entries" which you can find both.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Do you have Additional Reporting Currency setup for your general ledger accounts?

Was this reply helpful? Yes No
onplan 15 on at

Like (0)

Report

yes we do

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

Not with the standard api endpoint for gl entries. I don’t see a benefit in the reporting currency as that is only one more currency. The sub ledgers for customer/vendor/bank hold the currency detail you may want to use. I’d suggest using those instead. Publish web services for the mentioned ledger entries. No api endpoints but you could have them created.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

If you want the additional report currency in a API you need to customize the API.

You can see how you develop custom API's here:

docs.microsoft.com/.../devenv-develop-custom-api

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Because the standard API page cannot be extended by creating a page extension object.

So there are generally two ways.

1. Create a new Page, publish it to the Web Service, and use Odata to access the data
2. Create a new API page.

Hope this helps as well.

Thansk.

ZHU

Was this reply helpful? Yes No