I have a requirement where I need to access a table field in a table which is not included in the reports data item.
I have few options to do this.
- Create a Record variable of the sub-type which is the external table and access that variable and iterate through values with SETRANGE, SETFILTER etc.
- Create a temporary table write data to it and retrieve it from there
- Access the required field during the run-time.
What is the most recommended option?
I have to look for Vendor Invoice No in Purchase Order Table, But only Purchase Receipt Header and Purchase Receipt Line is used in the report.