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

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 85,338 Super User 2025 Season 1 on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

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
Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

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
Suggested answer

JAngle 95 on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

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.
onplan 15 on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

yes we do
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

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

MahGah 15,445 on at

Like (0)

Report

RE: Can we get General ledger expanded with dimensionSetLines by currency

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.