Hi all,
On The General Ledger Entries view list (Table=G/L Entry ID 17), are there an OOTB way to show the Currency Code and Amount in foreign currency, in addition to the LCY Amount (Field #17)?
For example, could General Ledger Entries view list display the same information as the Bank Account Ledger Entries below? Thanks.
Kind regards,
if GLEntry."Document-Currency” = '' then begin
GetSetup();
GLEntry."Document-Currency”:= GLSetup."LCY Code";
end;
I am getting an error on the line highlighted above. Also, where should I add the below line of code?
[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnAfterInitGLEntry', '', false, false)]
I write new code unit in AL. Don't know how and where to call this? Can you please guide me on this? Thanks!
Hi ,
I totally agree with you to GL should capture FCY and have report option to show FCY.
It should also support Currency Revaluation on this account. Most ERP systems provide that to cater for FCY accruals , prepaid expense, investment (Balance Sheet accts).
My prospect always raise this as an issue.
Another issue is how come Bank acct currency revaluation exchange gain/loss is posted to realised accts?
The issue is that there is no reference via the GL entry to what the original transaction currency was, what that amount was and the rate used for that particular transaction. In most other ERP systems this is standard OTTB functionality, which is highly important to a multicurrency entity.
Hi,
this means that if you enter an entry in general journal line with a currency code different than your local currency (setup on the general ledger setup), after the posting you will have an amount in local currency in table GL Entry.
In my case I created General Journal entry (table 81) with 100 EUR. My local currency is GBP, the system automatically convert 100 EUR to 64.58 GBP
And now this 64.58 will be posted into my GL Entry table as this is the local currency.
Thanks Renato.
I am not sure that I understand all transactions are booked in LCY. On one hand, the GL Entry (Table: 17) do not have Currency Code field, transaction amount available.
But on the other hand, General Journal batch (Gen. Journal Line table ID: 81) do have Currency code, Amount and Amount LCY available. Do I missed anything here? Thank you.
Kind Regards,
Hi Josh,
This is a great suggestion and something I imagine would possibly be implemented in Dynamics GP to BC projects as the multi currency information is passed through to the GL tables as standard in Dynamics GP :)
Thanks
Gavin
OOTB the option Renato mentioned is there. This is a modification I’ve seen on a few projects.
A codeunit like below will help you. Note that two fields have been added to the gl entry table to be populated at the point a journal is posted - that works for all transactions through to the gl where a currency is used and you want to store the value. You will need to add the new fields to the page as well.
[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnAfterInitGLEntry', '', false, false)]
local procedure OnAfterInitGLEntry(var GLEntry: Record "G/L Entry"; GenJournalLine: Record "Gen. Journal Line")
begin
if GenJournalLine."Source Currency Code" <> '' then begin
GLEntry."Document-Currency” := GenJournalLine."Source Currency Code";
if GLEntry.Amount = GenJournalLine."VAT Amount" then
GLEntry."Document-Currency Amount” := GenJournalLine."Source Curr. VAT Amount"
else
GLEntry."Document-Currency Amount” := GenJournalLine."Source Curr. VAT Base Amount";
if GLEntry."Document-Currency Amount” = 0 then
GLEntry."Document-Currency Amount” := GenJournalLine."Source Currency Amount";
end else begin
GLEntry."Document-Currency”:= GenJournalLine."Currency Code";
GLEntry."Document-Currency Amount” := GenJournalLine.Amount;
end;
if GLEntry."Document-Currency” = '' then begin
GetSetup();
GLEntry."Document-Currency”:= GLSetup."LCY Code";
end;
end;
Hi,
there is no field Currency on table GL Entry so it is not possible to show transactions in transactional currency. Also, have in mind that all transactions are booked in local currency in GL.
What can be done is if you want to have one additional reporting currency but then you are limited to one docs.microsoft.com/.../finance-how-setup-additional-currencies
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
