Skip to Content
0

How to display the exchange rate of the source document in a jorunal entri print layout in CR

Dec 01, 2016 at 06:05 PM

27

avatar image
Former Member

Hi Experts,

Ineed in a crystal report print layout of the journal entry display the exchange rate of the source document, but in the journal entry table doesnt exist to map it. I´ve tried to calculate it but it does not apper correct.

Has enyone done this or has any idea o query how to do it?

i hope your support.

Regards

NANCY

10 |10000 characters needed characters left characters exceeded

Hi Nancy,

Could you share your query?

Kind Regards,

Diego Lother

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

DIEGO LOTHER Dec 01, 2016 at 06:39 PM
0

Hi Nancy,

A simple way would be this:

SELECT 
	Debit, 
	FCDebit,
	Credit, 
	FCCredit,
	ROUND(CASE 
		WHEN FCDebit <> 0 THEN Debit / FCDebit 
		WHEN FCCredit <> 0 THEN Credit / FCCredit
	ELSE
		1
	END, 2) AS Rate
FROM 
	JDT1

But you can get wrong values by rounding.

Hope it helps.

Kind Regards,

Diego Lother

Share
10 |10000 characters needed characters left characters exceeded