You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it possible to add a new filed in data model query of Payable Trial Balance seeded report?

Accepted answer


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. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!