Project & Profit Centers

[Former Member]

Hi All,

1) I m searching ways to make Project Code & Dist. Rule Mandatory in all documnets.

I came to know i'll be able to do that through SBO_TransactionNotification, need help on how to write my code. I did some R&D with the following code but does not work.

If @transaction_type = N'A' AND @Object_type = N'8'

begin

if exists (SELECT T0.TransId FROM [dbo].[OJDT] T0 INNER

JOIN [dbo].[JDT1] T1 ON T1.Project =

T0.Project

WHERE t0.Project is null

and T0.TransId = @list_of_cols_val_tab_del)

select @Error = 1, @error_message =

'Select the project code'

end

2) I need to put an approval procedure on outgoing payments if its an On Account Payment.

Thanking you all in advance.

Regards

PR

[Former Member · Accepted solution]

using sbo tran should work.

I would start with a sales order (not a journal entry).

check the @list_of_cols_val_tab_del against the docentry - check project for null or ''

from what I can see you cannot use approvals against payments.

you can use it against a/p -- a/r downpayments though.