Project & Profit Centers
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'
if exists (SELECT T0.TransId FROM [dbo].[OJDT] T0 INNER
JOIN [dbo].[JDT1] T1 ON T1.Project =
WHERE t0.Project is null
and T0.TransId = @list_of_cols_val_tab_del)
select @Error = 1, @error_message =
'Select the project code'
2) I need to put an approval procedure on outgoing payments if its an On Account Payment.
Thanking you all in advance.
John ONeill replied
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.