hello every body
i'm trying to make reference filed at AR transaction to be auto numbering , to create the number automatically depending on maximum value of that filed i tried to make it through personalization but didn't work
any one have any idea for this case
my steps attached, you can check .
Hi
Can you remove your condition and then let me know if it is working?
Best Regards,
Bharat
ok , i have removed the condition but still have the same problem , the problem here is related to sql code that didn't return the filed
Hi
Your query looks incorrect as you are checking max from table but checking max of the field
Remove colon from the query.
It should be directly from table and column, do not use any local form field.
Best Regards,
Bharat
ok , thanks a lot m but did you know how to get the column of filed , specifically reference filed in ar transaction form
You need to pick reference from database table and not from column, so you can run the sql and check from sql developer.
Best Regards,
Bharat
