on 06-23-2011 6:33 AM
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
HI Apsara ,
You should use
SELECT 'D'+ ${OINV.DOCNUM}
Use [ in place of {
TRY THIS
Thanks
--
Ashish
Edited by: ASHISH RANJAN on Jun 23, 2011 11:12 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Apsara,
When referring to a value on the Main Window on a Formatted Search Query linked to a user defined field you need to use the Prefix minus
This should work
SELECT 'D'+$[$-8.0.0]
All the best
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello malhaar ,
Both answer working properly i think you have any other issue.
Are you check condition on sql query window Or SAP ?
in SQL it will show error.
Thanks
Manvendra Singh Niranjan
Edited by: Manvendra Singh Niranjan on Jun 23, 2011 3:01 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this:
SELECT 'D' + $[OINV.DocNum.0]
Thanks,
Neetu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try This
select 'D' + $[$8.1.number]
Thanks
Malhaar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.