Skip to Content
0
Former Member
Nov 02, 2012 at 05:33 AM

Avoid Wrong Journal Entry With Sigmentation

25 Views

Dear All,

My one client(SBO 8.81 PL 09) using Account segmentation in current company and segmentation for Zone(North,East,West and South)

and every transaction going correct sales ,purchase and banking using default account mapped with warehouse.

But main issue some time he/she select wrong zone CASH account and made entries.

So Now i Have a question that we can stop for such type of wrong entries in SAP ?

if yes then share with form.

I tried to block with SP_Notification but it is not working

--------JE for same Region-------------------------------------------------


IF @transaction_type IN ('A') AND @object_type = '30'

BEGIN

Declare @Count as numeric(10)


SET @Count = ( SELECT Distinct count(U_Region) FROM OJDT INNER JOIN JDT1 ON OJDT.TransId = JDT1.TransId

where OJDT.TransId =@list_of_cols_val_tab_del )


If exists (SELECT Count(U_Region) FROM JDT1 T0 where ( T0.TransId=@list_of_cols_val_tab_del) having @Count > 1)


begin

SET @error = 10

SET @error_message = N'Please select all same zone ledger'

end

End

------------------------

Try to help me on same