Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 01, 2016 at 06:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded