Status of Journal Entry in Ageing (Letter)

Emanuele Croci

Hi,
I'm developing a new Ageing (Letter).
What kind of structure should I use to have the status of a Journal Entry in the detail section?
If I usa the:
Row("RowDocument.DocStatus") it is set to NULL, but in the OJDT table the BtfStatus is "O"
Or should I use the GetData("B1_Data.Row.RowDocument.DocStatus")?
What's the difference between the "Bands --> Row" structure and the "Data Sources --> B1_Data --> Row" structure?
Regards
Emanuele

Philipp Knecht

Hi Emanuele
If you pull the data via Band DBNull - Values will automtaically be translated in their default values.
You can also use Row.IsEmpty("MyField") to explicitly check for DBNull.
It's listed in the FAQ.

Emanuele Croci

Hi Philipp,
my problem is not to manage the null value.
The problem is that I have a JE with status "O" (open), but the Row("RowDocument.DocStatus") is Empty.
Perhaps, I'm using the wrong structure...
Should I use the GetData("B1_Data.Row.RowDocument.DocStatus")?
What's the difference between the "Bands --> Row" structure and the "Data Sources --> B1_Data --> Row" structure?
Regards,
Emanuele