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

Using non LCY currency code in the cash receipt journal

(1) Share

Report

Posted on by Perrett2311

Hi everyone,

I have a scenario where I am attempting to reconcile a Stripe payout directly in a cash receipt journal in BC.

Company LCY - GBP

Stripe Payout currency - EUR

BC Invoice total - 1250.00 GBP

Stripe Payout total - 1463.43 EUR

I want to create 2 journal lines, one to debit the bank and one to credit the customer, as follows:

As you can see above, the currency exchange rate between BC and Stripe differs hence in BC, 1463.43 =/ 1250.00 but instead according to BC it equals 1249.99.

I would like to post 1250.00 to remove the remaining amount in the invoice while also registering 1250.00 as that is what the customer paid for the invoice.

How can I even out the above while also maintaining a 0 balance in the remaining amount of the invoice?

Any help is much appreciated!

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 74,148 Super User 2024 Season 2 on at

Like (1)

Report

Using non LCY currency code in the cash receipt journal

I think there is no good way, you need another account to handle the difference, 0.01.

For example, Gains Acc. or Losses Acc.

Hope this can give you some hints as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,961 Super User 2024 Season 2 on at

Like (2)

Report

Using non LCY currency code in the cash receipt journal

I agree with gdrenteria, you can change the exchange rate used by BC on each journal line.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Jun Wang 7,454 Super User 2024 Season 2 on at

Like (1)

Report

Using non LCY currency code in the cash receipt journal

you could set up the rounding on the currency card to be round up with the rounding precision as needed.
gdrenteria 12,546 Most Valuable Professional on at

Like (1)

Report

Using non LCY currency code in the cash receipt journal

Hi

Could you change and adjust the exchange rate in the transaction?

Dynamics 365 Business Central – Making sense of the Currency Exchange Rates Page when setting Exchange Rates

Best

GR