BLOCK BACK DATE POSTING

[Former Member]

Hai,

Is there any option to block back date posting(Goods Receipt PO) in sap business one, If so... kindly let me know please........

Regards,

Pushpa Damodaran

[former_member541807 · Accepted solution]

hi,

yes it is possible. goto Administration -->> System Initialization -->> Document Settings -->> General Tab -->> check the check box "B&lock documents with earlier Posting Date". this action will not allow backdate in GRPO as well as in other docs.

regards,

Fidel

[Former Member]

Hi,

Anybody having store procedure to block goods receipt po

Regards,

Pushpa

[former_member186095]

Here you are:

IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'20')

begin

if exists (SELECT T0.BaseEntry, SUM(T0.Quantity) FROM [dbo].[PDN1] T0 INNER

JOIN [dbo].[POR1] T1 ON T1.DOCENTRY =

T0.BASEENTRY

WHERE T0.BaseType = 22 AND T0.ItemCode = T1.ItemCode AND T0.BaseLine = T1.LineNum

and T0.DOCENTRY = @list_of_cols_val_tab_del

GROUP BY T0.BaseEntry

HAVING (SUM(T0.Quantity) > SUM(T1.Quantity)) or sum(t0.quantity) > sum(t0.BaseOpnQty))

begin

select @Error = 10, @error_message = 'GRPO quantity is over PO quantity'

end

end

Use the above SP as reference or base to customize your own SP for GRPO.

[Former Member]

Hi,

This store procedure has to block the back date entry also?

[former_member186095]

Hi,

No. The above SP is only to  block GRPO of its quantity exceeding the PO quantity.

You must modify the SP to have the validation block GRPO with backdate posting.

Can you explain the sample of back date posting ? is it the posting date that before today's date, this perioed's date or what.

Thx and Rgds,

[Former Member]

hi

I need to put grpo only current date not for yesterday's date

Regards,

Pushpa

[former_member186095]

It is easy. Try this following SP:

IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'20')

begin

if not exists (SELECT T0.BaseEntry, SUM(T0.Quantity) FROM [dbo].[OPDN] T0 INNER

JOIN [dbo].[PDN1] T1 ON T1.DOCENTRY =

T0.DOCENTRY

WHERE T0.docdate = getdate()

and T0.DOCENTRY = @list_of_cols_val_tab_del

)

begin

select @Error = 10, @error_message = 'Posting date must be current date'

end

end

Rgds,

JimM

[Former Member]

Hi,

You can use validation(OB28) for this purpose, you can control back dated posting at document header level by using system date as key to check.

Regards,

mohdsams

[Former Member]

Hi Pushpa....

Simply locking Posting Period does it not serve your purpose?

If not then you may go for SP Transnotification to block Backdated GRPOs.....

Regards,

Rahul