Lock a certain day from posting goods movements

[Former Member]

Hi, is it possible to lock a certain calendar day so that no goods movement can be posted on that day? Thanks in advance for any input.

yu

[ajaycwa1981 · Accepted solution]

Hi

I can tell you a wierd way of doing it, but it will work w/o any adverse affects

The Balance sheet accounts assigned in BSX (OBYC) - Remove the Auto Posting indicator from this GL Account in FS00 for one day and restore it the other day... System wont post any goods movement w/o this tick

Another option is to Ask your BASIS guys to lock all MM Transactions

br, Ajay M

[Former Member · Accepted solution]

I will also love to pen my weird thought

In transaction OB52, close the period for Account type M. You may use program RF_OPENPERIOD and create a batch job with specific variants. Schedule batch job on calendar days you need the postings blocked.

Alternatively assign specific authorization group to the account range for account type M in OB52 (auth object F_BKPF_BUP). Do this manually for the day you want to block the postings.

Regards

Subodh

[Former Member · Accepted solution]

Thank you Subodh but it seems program RF_OPENPERIOD does not exist in my ECC6 system?

[Former Member · Accepted solution]

Sorry I must have had too many beers...

Program is RFPERIOD_OPEN

Regards

Subodh

[Former Member · Accepted solution]

Hi Subodh

This program will lock the whole fiscal period, right? I just want to lock a few days in a period actually. Let me describe the story.

Saying one of our fiscal periods starts from 2011.12.24 and ends on 2011.01.20. We will have a financial inventory report for our local government with the figures on 2011.12.31. In that case we don't want anything posted back to 2011.12.24 - 2011.12.31 after 2012.01.01. But from time to time, for example COGI goods movement errors are still possible to be posted back to those sensitive days if they're generated at that time. That's why I want to lock those calendar days from goods movement postings after 2012.01.01.

yu

[Former Member · Accepted solution]

In that case you want to use auth group that I mentioned earlier. From Jan 20 through Jan 31 when you want to lock MM transactions but leave it open for COGS or other adjustment /correction postings, then you should define which group of people should have that access and assign auth group to inventory accounts as well as these users. You should activate auth group control only for such period. But remember such group of people will be able to do any inventory transaction. If you know they will be posting only to COGS then bring COGS account as well under same auth group and let them not post to any other GL accounts. You can still automate these changes using the program and batch job. Obviously OB52 will look complicated.

There is no way to establish date wise control if you are looking for it. You will have to work around one of these ways.

Regards

Subodh

[ajaycwa1981 · Accepted solution]

Hi

Authorization group is a better choice as compared to OB52...

Another option is to use a Validation in OB28... You can use a SET (GS01) for BUDAT (posting date) in your validation... Every time you just need to change the Dates in your set in GS02 and the validation will work smooth.. You dont need to change the validation at all

@ Subodh: What say about this wierd thought??

br, Ajay M

[Former Member · Accepted solution]

Thanks a lot Subodh. This solution looks far beyond my knowledge. I think I will have to stop here

[Former Member · Accepted solution]

Hi Ajay

I'm trying OB28. But I don't know how to use the tool. I do create a set with the dates I want to block. Can you please tell me a little more about validation? Thanks

yu

[ajaycwa1981 · Accepted solution]

Hi

Create a SET in GS01 called ZBUDAT using Table BKPF and Field BUDAT

Create a Validation in OB28 at doc header level i.e. Call up point = 1

Prerequisite:

BKPF-BUKRS = XXXX

Check:

BKPF-BUDAT NOT IN ZBUDAT

Error message: Create a Z error message here

br, Ajay M