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