Prevent Batch Stock to go Negative

Logistics : MM and its sub-modules (WM, IM, PO, LIS)

Moderators: Snowy, thx4allthefish, Ha Tran, svetja

Post Reply
cornea
Posts: 112
Joined: Fri Jan 24, 2003 7:09 am
Location: South Africa

Prevent Batch Stock to go Negative

Post by cornea » Tue Jul 29, 2014 12:29 am

Hi
Our materials are unvaluated and Batch Managed and we do not allow for negative stock in a Storage Location.

A user backdated a 261 for a specific batch (B123) 2 days prior. The Sloc had enough stock of the Material, but the Batch (B123) went negative. The user then transferred the Batch (B123) from another Sloc to the issue Sloc on the current date. This means that for two days the Batch (B123) had negative stock.

How can we prevent batch stock to go negative?

Thanx
Corne

Ha Tran
Posts: 28320
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia
Contact:

Re: Prevent Batch Stock to go Negative

Post by Ha Tran » Wed Jul 30, 2014 1:09 am

Hi,

Did you allow the non-batch material to go to negative stock level?

Cheers,
HT

cornea
Posts: 112
Joined: Fri Jan 24, 2003 7:09 am
Location: South Africa

Re: Prevent Batch Stock to go Negative

Post by cornea » Wed Jul 30, 2014 1:46 am

Hi
We don't use non-batch materials in this Sloc.

Regards
Corne

svetja
Posts: 13946
Joined: Mon Oct 21, 2002 1:42 am
Location: Germany

Re: Prevent Batch Stock to go Negative

Post by svetja » Wed Jul 30, 2014 5:15 pm

The batch was never physically negative, it is just negative by calculation considering the posting dates.
SAP does not do it this way, SAP only checks the periods, not single days. The current stock that is stored in various tables is just he current stock of this period, just right now, and those tables have as well a field for previous period. But you will not find a field for July 15 for example. This would need to be calculated like it is done with transaction MB5B. Now just imagine any goods movement would first need to calculate the stock level for a certain day, this would be a performance killer.
Search before posting: search.php

cornea
Posts: 112
Joined: Fri Jan 24, 2003 7:09 am
Location: South Africa

Re: Prevent Batch Stock to go Negative

Post by cornea » Thu Jul 31, 2014 2:37 am

Hi
We track our stock on batch level, and on every day. In this example, SAP allowed a 261 on the specific batch, although there was no stock for this batch at that time.
4002 R02F000260 311 X 4900534216 2 10.07.2014 10.07.2014 11:36:26 9,980 G
4002 R02F000260 261 4900534598 3 10.07.2014 10.07.2014 13:38:16 9,980- G
4002 R02F000260 261 4900557120 1 25.07.2014 28.07.2014 10:29:16 52,000- G
4002 R02F000260 262 4900557079 1 25.07.2014 28.07.2014 10:25:29 52,000 G
4002 R02F000260 261 4900556931 1 25.07.2014 27.07.2014 15:58:22 52,000- G
4002 R02F000260 311 X 4900556930 2 27.07.2014 27.07.2014 15:57:23 52,000 G

I don't want the system to allow the third movement, as there was no stock on that date!
Why do SAP allow this?
How can I prevent this?

Regards
Corne

svetja
Posts: 13946
Joined: Mon Oct 21, 2002 1:42 am
Location: Germany

Re: Prevent Batch Stock to go Negative

Post by svetja » Fri Aug 01, 2014 2:38 pm

your 3rd movement is not the third movement, check your sort sequence e.g. try it with sorting by material document number, or bei CPU date and CPU time
Search before posting: search.php

cornea
Posts: 112
Joined: Fri Jan 24, 2003 7:09 am
Location: South Africa

Re: Prevent Batch Stock to go Negative

Post by cornea » Mon Aug 04, 2014 5:48 am

Hi
I have sorted by Document and Date/Time Entered:
4002 R02F000260 311 X 4900556930 2 27.07.2014 27.07.2014 15:57:23 52,000
4002 R02F000260 261 4900556931 1 25.07.2014 27.07.2014 15:58:22 52,000-
4002 R02F000260 262 4900557079 1 25.07.2014 28.07.2014 10:25:29 52,000
4002 R02F000260 261 4900557120 1 25.07.2014 28.07.2014 10:29:16 52,000-

According to this, there was stock on the 27th.
I still think SAP should not allow the backdating posting on the 25th, as on that day there was no stock!

It seems that SAP allows negative stock when backdating if there is sufficient stock left on entered date.
This does not make sense to me.

Corne

cornea
Posts: 112
Joined: Fri Jan 24, 2003 7:09 am
Location: South Africa

Re: Prevent Batch Stock to go Negative

Post by cornea » Fri Aug 15, 2014 1:30 am

After an investigation I came to the following conclusion:
Even though negative stock is not allowed for an Sloc, if a movement is backdated, SAP only checks if there is enough stock on transaction date (to prevent going negative). Therefore, if there is stock today, I can backdate a posting from the Sloc for the current (transaction time) stock. This can then create a negative stock value on the backdated date (till transaction date if no other movements were done).

Hope someone finds this helpfull (I did :D ).
Cornea
QM

Post Reply