on 10-15-2008 1:39 PM
Dear Experts
I need your help for the error message "PL Stock in transit exceeded by 0.001 EA : 300183721 0428 10". and Message no. M7022
The details cycle is given below
the Article code's 300183721 units of measures is maintained as 1 EA = 24 CAR
Its a STO - stock moveing from one store to another store( site/plant )
Article stock 0.959 CAR is outwarded (VL02n) and when othere store is try to inward (MB0A) the same qty it is not allowed but its allowed us 0.958 car
but when we look at the in-transit stock again using MB5T, the same 0.001 CAR is appearing
Shall be grateful, if could kindly provide me a solution urgently to overcome this issue.
Thanks in advance
Kind Regards
Sudha
Done, by Adjustment posting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
as ur 1ea = 24 cars
then if ur sending 23 car the ea will be .958 and not .959
so correct it to .958 and try
regards
kunal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer to SAP note No.392205
Analysis of stock in transit/correction for split valuation
Note Language: English Version: 15 Validity: Valid from 13.06.2001
Summary
Symptom
SAP Support: Please read the remark to the note!
o Goods receipt for stock transport orders cannot be posted as the
system reports a deficit in the stock in transit (Message M7
021/022).
o Materials show stock in transit although there are no longer any
open stock transport orders.
Caution:This note only refers to real stock in transit and not to
virtual stock in transit in cross-company stock transport orders.
Counter-indications
The procedure in this note (movement types 557 nd 558) must not be followed
to "correct" genuine database inconsistencies in the stock in transit
which, for example, have arisen due to incorrect updates. Proceed as in
Note 32236.
Additional key words
Stock transport order, stock transfer, MARC-TRAME, MSSA-SATRA, MSSQ-SQTRA,
stock in transit, TRAME, M7021, M7022, MvT557, MvT558, 557, 558,
correction, MMINKON
Cause and prerequisites
The R/3 system is designed so that the stock in transit can only be posted
through stock transport orders (creation during goods issue, reduction
during goods receipt).
Purchase order and material master record can have different units of
measure. The purchase order is then closed when the goods issue quantity
and quantity of goods received are the same in order unit. However, in the
material master record, the stock in transit is managed in the base unit of
measure.
On account of system-dependent and program-internal rounding effects which
cannot be avoided, the open stock in transit quantities in order unit and
in base unit of measure might not balance to zero at the same time.
Example 1
Stock transport order over 100 pallets. Conversion factor 1 kg = 3
pallets.
Goods issue in one step: 33.333 kg are posted to the stock in
transit (quantity fields of the material master record have an
accuracy to three decimal places in R/3).
Partial goods receipt over 50 pallets. It reduces the stock in
transit by 16.667 kg.
A second partial goods receipt over the still outstanding 50
pallets fails as only 16.666 kg remained in the stock in transit
30.08.2008 Page 2 of 5
Note 392205 - Analysis of stock in transit/correction for split valuation
but 16.667 kg should be booked out again.
Example 2
Stock transport order over 1 pallet, conversion factor 1 pallet =
10000 pieces. In the material master record, an alternative unit of
measure 'Carton' is managed (conversion factor: 1 carton = 1234
pieces).
During goods issue, 1 carton is now entered. As there is a
conversion only from the carton unit of measure to the piece base
unit of measure, the system first converts to 1234 pieces. These
are then converted into order unit of 0.123 pallets via the factor
of the purchase order. The system now posts 0.123 pallets and 1234
pieces.
A goods receipt over 0.123 pallets (default quantity and unit) is
now executed over 1230 pieces and leaves 4 pieces in the stock in
transit.
Solution
Organizational solution
You can avoid the effect if you use the stock transport order according to
the business idea that it is based on. A corresponding goods receipt should
be posted for every goods issue.
Goods issues in N substeps and goods receipts in M substeps with N < > M or
non-corresponding quantities/units do not match the business process
intended for stock transport orders.
Correction of the stock in transit without purchase order
reference
Note 389484 makes movement types 557 and 558 available. These are derived
from the class of the scrapping movement types and can post the stock in
transit without purchase order reference. For actually visible
problems, excess stock in transit can be removed or missing stock in
transit can be created with this.
A report is attached to the current note; this report tries to explain the
stock in transit using the documents existing in the system.
Prerequisites
This report requires that program RM07APP1 exists in your system and date
"12.01.2001" is contained at the program start in the comment block. If
this is not the case, the program is to be updated by importing the
transport mentioned in Note 198596.
Notes on use of the analysis report
The analysis report uses the documents existing in the system (purchase
order history records and material documents) to explain the stock in
transit.
The data is displayed on four levels:
o Documents
Material documents which posted to the stock in transit. The
quantity is displayed in order unit and base unit of measure.
If you want adjustment documents to be taken into account on the
initial screen of the report, the system only displays the base
30.08.2008 Page 3 of 5
Note 392205 - Analysis of stock in transit/correction for split valuation
quantity for these.
o Purchase order item
The data of the purchase order item results through summation of
the material documents. Here, you find the open quantity in order
unit, the expected open quantity in stock in transit which results
from this by means of the item conversion factors as well as the
quantity actually posted in stock in transit.
Adjustment documents are allocated with purchase order number
'Correction'.
o Valuation type
The total of the expected open stock in transit quantity is
compared with the quantity actually posted; in the case of
differences these are displayed separately.
If these differences are the same as the differences which led to
the execution of the report, adjustment postings can now be
executed with movement types 557 and 558.
Quantities displayed as positive (green) indicate a surplus in the
stock in transit which should be booked out with 557. Apply
analogously "negative/red/558".
The correct valuation type is to be used for split valuated
materials during the correction (see below).
o Material/plant
Here, the stock in transit calculated through the documents is
compared with the stock in transit contained in the database in
order to check that the documents are sufficient to explain the
existing stock in transit.
On the initial screen of the report, you can choose up to which level the
list is displayed first. By double-click, a detailing of the summarized
display is possible.
There are direct jumps to the display of material documents (double-click
on material document number or item) and purchase orders (double-click on
purchase order number or item).
The report can recognize warning and error situations which are output in
column 'Status'. Every message is identified by an X in a different column.
The system outputs the messages in text format with explanations when you
click on the status column.
If documents were archived (purchase orders and/or material documents),
remaining stocks in the stock in transit which did not result through the
remaining documents can no longer be explained. In general, this has the
effect that the report shows an error concerning variances in stock in
transit on material level.
In the ideal case, it should only be possible to explain the stock in
transit through the open purchase orders which cannot be archived. Without
selection of the adjustment documents, the report only shows the situation
resulting from the open purchase orders. Then, adjustment postings cause a
change of the posted stock in transit on material level (as the adjustment
30.08.2008 Page 4 of 5
Note 392205 - Analysis of stock in transit/correction for split valuation
documents are not selected).
Conclusion: During analysis without adjustment documents, there should be
no differences between posted and existing stock in transit on material
level.
If batch-related quantity conversions are used (active ingredient
management and product units of measure), the expected stock in transit
which results from the open purchase order quantity cannot be calculated
correctly. The report uses the conversion stored in the purchase order item
which represents the planned factor.
Conclusion: If this procedure is used, the results of the report only make
sense if the purchase orders which are below a hierarchy level show all an
open quantity of zero in order unit.
It is not useful to execute the report periodically and to execute a blind
posting for the shown differences. The results must be checked for
plausibility.
Special features of movement types 557 and 558
o These movement types should only be used to correct the stock in
transit in specific cases. A regular use in order to achieve new
business processes is not wanted.
o The movement types must not be copied for technical reasons!
o Do no longer use the modified movement types Z05 and Z06 created
with Note 181297. However, do never delete the entry in
table T156M which was created for this note
(Recommendation was ZEU1).
CAUTION --- CAUTION --- CAUTION --- CAUTION
Due to historic reasons, the data model of R/3 is incomplete concerning
material with split valuation in the stock in transit (the stock in transit
is managed independent of valuation types but already belongs to the
valuated stock which is managed with the exact valuation type).
The direct posting of the stock in transit for material with split
valuation can cause database inconsistencies which cannot be checked during
the posting with movement types 557 and 558. For the time being, the use of
the movement types for split valuated material is not possible and leads to
error message M7048 (Use one-step procedure for transfer posting to mat.
subj. to valuation).
It is possible to deactivate this error message by entering message
category ' ' (blank character) in message Customizing of the inventory
management.
After you have executed the required corrections, the message has to be set
to category 'E' again to prevent end users from causing damage with the
movement types.
Regards
Merwyn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.