on 04-05-2017 6:28 PM
Hi everyone, my boss ask me to make some fields as mandatories in the Project Management window.
I made some mandatory fields in another windows like invoices, payment and business partners with 'transaction notification', using the well known code
IF (@object_type = '1') AND (@transaction_type IN ('A','U')).......
But I can´t find the object type for the Project window, and I don´t know if there´s another way to do this.
So, someone has made this type of lock in a Project window´s field?
Thanks and best regards!
Hi Anderson..
The object id for the project management "OPMG" is'234000021'
Cheers!
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yup, that´s the object but my code is not working. Someone could help me with this? this is my code
IF (@object_type = '234000021') AND (@transaction_type IN ('A','U'))
declare @proy nvarchar(100)
declare @contact nvarchar (100)
set @proy=(Select top 1 isnull(I.fiproject,'') From OPMG I
Where I.CARDCODE=@list_of_cols_val_tab_del )
set @contact = (select isnull(t0.contact,'') from OPMG t0 where t0.AbsEntry=@list_of_cols_val_tab_del and t0.CONTACT is null)
BEGIN
If exists (Select top 1 isnull(I.fiproject,1) From OPMG I
Where I.CARDCODE=@list_of_cols_val_tab_del )
set @error = 111
set @error_message = 'project missing'
--if @contact = ''
--set @error = 112
--set @error_message = ' contact missing'
End
it´s not blocking anything, not the project nor the contact. I tried with different codes, this one is just an example to see what I´m trying to block
Hi Anderson,
The variable @list_of_cols_val_tab_del returns the value of the AbsEntry of OPMG. So, on your where clauses try to use the following:
I.AbsEntry = @list_of_cols_val_tab_del
Hope it helps.
Kind Regards,
Diego Lother
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How did you get 711 object code? I can't find such code SDK help file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check object types under C:\Program Files (x86)\sap\SAP Business One SDK\Help-REFDI If not stated here, then no object type for project management.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
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.