Finance | Project Operations, Human Resources, ...

Vendor invoice posted without subledger due to missing transaction currency

(0) Share

Report

Posted on by Satheesh Kumar

Vendor invoice posted without vouchers. Tried to transfer the subledger manually by using transfer now on "Subledger not yet transferred" form but popped up an error "A transaction currency code must be specified for the transaction".

Question : Is there a way to update the subledger transaction currency manually in front end/ any forms.

All responses (4)

Answers (0)

Kevin Huo on at

Like (0)

Report

RE: Vendor invoice posted without subledger due to missing transaction currency

Such issue need update TRANSACTIONCURRENCY from table SUBLEDGERJOURNALACCOUNTENTRY for the transactions by the expected currency code.

you can't update it from UI side. it needs update from database side, you can try update in UAT/TEST firstly by below query:

UPDATE SUBLEDGERJOURNALACCOUNTENTRY
SET TRANSACTIONCURRENCY = '###' --change ### to correct transaction currency
WHERE RECID = ‘######' --Change ###### to recId which has this issue.

if in D365 online PROD environment, please create a support ticket to ask update data in PROD.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor invoice posted without subledger due to missing transaction currency

Hi Satheesh,

I don't think that you can fix this through the UI but rather need the help of a developer to 'repair' that record.

Best regards,

Ludwig
Satheesh Kumar 15 on at

Like (0)

Report

RE: Vendor invoice posted without subledger due to missing transaction currency

Hi Ludwig,

Thanks for the immediate response. Unable to reproduce the issue and couldn't find the steps how it happened.

Would be better to know the solution to resolve via front end.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor invoice posted without subledger due to missing transaction currency

Hi Satheesh Kumar,

How did the transaction made it into the subledger not yet transferred form if the currency was missing?

Has somebody 'manipulated' the record?

Best regards,

Ludwig