I want a user defined coloumn in a new Query for Report and also it should prompt for user defined values.
In a report for stock status ( Qty, rate , Total etc.) i need a new column " Forex Rate" which should prompt user to put exchange value manually as on the date of running this report anytime i.e this new column has variable input.
Since the items are purchased from various sources, the report has to display the value in respective purchase currency. The value on report generation date is based on input of exhange rate as explained. This should prompt before running the report.
I just need the query part for creation of such column and user prompt. Will integrate that into rest of query.