Skip to Content
0
Jan 06, 2012 at 06:56 AM

Giving Prefix & suffix to Docunum in AR invoice

132 Views

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.