I am trying to execute a query provided in 'How to define and use user-defined fields' doc under How to guides for SBO 8.8 but it is giving me error "incorrect syntax near...."
The Sample query i m trying to execute, which is for adding 20 in the posting date of current active sales document (not stored in database), is : Select $[$10.0.Date] + 20
This query will be used in Due date to automatically retrieve a date which 20 days forward from the posting date.
When I am executing the above query it is give me error: SQL native client "incorrect syntax near '+' and user-defined value could be created.
Please help resolving this issue. I am using SAP Business one 8.8 SP0 PL09