Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?
Summary:
We have a requirement to get Supplier name in Arabic in Payable Trial Balance report. User don't want to customize the seeded report as they are using same report for other markets so they wanted us to create a New custom report which exactly gives same output as seeded Payable trial balance report but with Supplier name should be Arabic.
To fulfil this requirement , i copied seeded data model of Payable Trial Balance report and created a custom report with seeded template. Now i am trying to add new filed vendor_name_alt from poz_suppliers_v as it is storing supplier name in Arabic language. After added new table and field to the data set query clicked on Ok. now it is asking for data to Lexical parameters. if i some dummy data it is throwing syntax error. screenshots are given in attached document.