LCY on the report - navision 3.60

Need help: trying to display LCY in the header of a report

Under C/AL globals I deifned GenLedSetup as record from table General Ledger Setup

In the report sections I put text box with source GenLedSetup.“LCY Code”. However, when I run the report, LCY is blank. What am I doing wrong?

Help anyone :slight_smile:

Hi Iggy,

Welcome to the Dynamics User Group!

You need to get the record first … use GenLedSetup.GET;

what is your data item if “General Ledger Setup” is not your data item then you need to get the record from General Ledger Setup and the display;

place the below code at OnPreSection() of your report header

General Ledger Setup.reset; --YThis code will reset the table

General Ledger Setup.get(’’); – This will get record based on Primary Key

now place a text box and change its source expression to General Ledger Setup.“LCY Code”

Thanks

Jerome Marshal.J

Oh, worked like a charm :slight_smile:

Cheers guys :wink: