Skip to Content
0
Former Member
Jun 23, 2011 at 05:33 AM

Modify query

16 Views

Hi all

I have set up a UDF call 'invoice number' on the AR invoice document header to automatically populate the invoice number. Below is the query i have used

SELECT $[$8.0.0]

I need to modify this query so that it puts a letter eg: D infront of the number

eg invoice number on the AR invoice doc is 5000. On the UDF of the document the invoice number needs to populate as D5000

With the above query it just put 5000

can someone please help me with this query

Thanks

Regards

Apsara