on 05-26-2013 11:22 AM
Hi
I want to check during Add or Update of Business Partner if user has selected group "Customer" B.P Code first character should be "C" . If user has selected group "Vendor" B.P Code first character should be "V" , if user has selected group "Leads" B.P Code first character should be "L" . How it can be done using Stored Procedure Notification.
Thanks
Hi sunny,
Goto
Administration --> System Initialization --> Document Numbering
then you have the following window
press ctrl+double click on business partner vendor/customer.
Here right click on first row select add row then define your series.
if you want 'V' is your vendor starting letter then put 'v' at prefix.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny Brar,
Try this:
If @object_type = '2' and @transaction_type in ('A','U')
BEGIN
declare @t char(1)
set @t=(Select p.CardType from OCRD p
where p.cardcode=@list_of_cols_val_tab_del)
if @list_of_cols_val_tab_del !=
(Select case @t
When 'S' then 'V'
When 'C' then 'C'
When 'L' then 'L' end
+isnull(substring(str(100000+max(right(p.CardCode,5))+1,6),2,5),
'00001')
From OCRD p
Where p.CardCode like '%[0-9][0-9][0-9][0-9][0-9]'
and p.CardType=@t
and p.cardcode!=@list_of_cols_val_tab_del)
Select @error =1,
@error_message = 'Partner code invalid !'
END
Hope helpful.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.