Dear all,
I have created 1 UDF (named as InvoiceNo).
This invoice should be same as Docunum, only prefix & suffix should be assigned to that udf.
For Eg:
If Docnum is 1 & current financial year is 2011-12 then
My invoice no should be equal to: 0001/11-12
How i can achive this by using Stored procedure.
Plz give me some advice.