5 Tests Series Raw Moving Average Price
5.3 Invoice Verification Postings .1 Minor Invoice Differences
Test Description
Automatic posting of small differences at invoice receipt. Small differences are a function of the tolerance key bd TOLSL. transaction code OMR6.
Moving Average Price 11.75
Standard Price 0
Total Stock 177
Event
PO 10 EA @ MVP
IR Amt: $((10 * PO price) + 0.01) for Amt: $(10 * PO price) Qty: 10 EA (Hint. You can use the adjustment function so that vendor is posted 1 cent more than the GR/IR account)
Postings Transaction Code MRHR
Itm PK Acc/mat/asset/vend PO number Item Quantity Amount Name 001 31 11 0.000 117.51- PCC vendor name line 1 002 86 TT-RAW-V 100011 00010 10.000 117.50 TT-RAW-V Moving Ave. Price Raw Material
Itm Account Allocation Description Amount in USD 001 11 PCC vendor name line 1 117.51- 002 2050 000010001100010 Goods rcvd/inv rcvd 117.50 003 5720 0000000160 Small price diff/var 0.01 New M. Ave. Price no change
New Total Stock 177
5.3.2 Exchange Rate Rounding Differences
Test Description
Enter an invoice with exchange rate rounding differences.
Tester Comments
Does not involve a material. Only need to be tested test once. See earlier test series.
5.4 Valuation Postings 5.4.1 Price change 5.4.1.1 to higher price
Test Description
Change material price to a higher price.
Moving Average Price 11.75
Standard Price 0
Total Stock 177
Event
new price = MVP + $15
Postings Transaction Code MR21
Itm Material ValA Val. type New price Text --- 001 TT-RAW-V 1 26.75 TT-RAW-V Moving Ave. Price Raw Material
Itm Account Allocation Description Amount in USD 001 1300 Raw material inv. 2,655.00 002 5500 0000000160 Gain/Loss revaluat. 2,655.00- New M. Ave. Price 26.75
New Standard Price no change New Total Stock no change
5.4.1.2 to lower price
Test Description
Change material price to a lower price.
Moving Average Price 26.75
Standard Price 0
Total Stock 177
Event
new price = MVP less $10
Postings Transaction Code MR21
Itm Material ValA Val. type New price Text --- 001 TT-RAW-V 1 16.75 TT-RAW-V Moving Ave. Price Raw Material
Itm Account Allocation Description Amount in USD 001 1300 Raw material inv. 1,770.00- 002 5500 0000000160 Gain/Loss revaluat. 1,770.00 New M. Ave. Price 16.75
New Standard Price no change New Total Stock no change
5.5 Purchase Order Planned Delivery Costs (Freight & Customs Conditions)
Test Description
PO, GR, IR a purchase order with freight and customs conditions in the PO pricing Moving Average Price 16.75
Standard Price 0
Total Stock 177
Event
PO 100 EA @ $10 with the following conditions :
FRA1 Freight % 1.000 % FRA2 Freight % 2.000 % FRB1 Freight (Value) 3.00 USD FRB2 Freight (Value) 4.00 USD FRC1 Freight/Quantity 5.00 USD 1 EA FRC2 Freight/Quantity 6.00 USD 1 EA ZOA1 Customs % 7.000 % ZOB1 Customs (Value) 8.00 USD ZOC1 Customs/Quantity 9.00 USD 1 EA GR 100 EA with 101 Goods receipt for purchase order into warehouse/stores
Postings Transaction Code MB01
Item Quantity UnE Material Plnt SLoc PO number Item S DCI Un Material description Batch R MvT S T
1 100 EA TT-RAW-V 1 1 100012 10
IR (goods only) w reference to PO Amt: $1000 for Qty 100 EA.
Postings Transaction Code MRHR
IR (all the planned delivery costs) to a different vendor. (Hint : on Enter Invoice: Initial Screen enter the vendor. On the Enter Invoice: Document Overview in USD screen, Edit | Delivery costs | Planned | By purchase order.)
Postings Transaction Code MRHR
TT-RAW-V Moving Ave. Price Raw Material
Test foreign currency PO with different exchange rates used at GR and at IR.
Moving Average Price 21.91
Standard Price 0
Total Stock 377
Event
PO 100 EA @ 10 DEM (Hint: enter currency DEM in the PO header. Do not fix.)
GR 100 EA. Record the exchange rate used at GR time (which comes from table TCURR key {m dem usd}, not from the PO).
Postings Transaction Code MB01
Item Quantity UnE Material Plnt SLoc PO number Item S DCI Un Material description Batch R MvT S T 1 100 EA TT-RAW-V 1 1 100014 10 TT-RAW-V Moving Ave. Price Ra 101 +
Itm Account Allocation Description Amount in USD 001 1300 Raw material inv. 700.00 002 2050 000010001400010 Goods rcvd/inv rcvd 700.00- GR Exchange Rate 0.70000 USD / DEM
New M. Ave. Price 18.78 New Total Stock 477 Event
IR Amt: DEM 1000 for Qty: 100, at GR rate + 25%. (Hint: On Enter Invoice: Initial Screen do not forget to set fields Currency and Exchange rate).
Postings Transaction Code MRHR
Itm PK Acc/mat/asset/vend PO number Item Quantity Amount Name 001 31 11 0 1,000.00- PCC vendor name line 1 002 86 TT-RAW-V 100014 00010 100 1,000.00 TT-RAW-V Moving Ave. Price Raw Material
Display of invoice postings in DEM …
Itm Account Allocation Description Amount in DEM 001 11 PCC vendor name line 1 1,000.00- 002 2050 000010001400010 Goods rcvd/inv rcvd 800.00 003 1300 Raw material inv. 200.00
… and in USD.
Itm Account Allocation Description Amount in USD 001 11 PCC vendor name line 1 875.00- 002 2050 000010001400010 Goods rcvd/inv rcvd 700.00 003 1300 Raw material inv. 175.00 IR Exchange Rate 0.875
New M. Ave. Price 19.15 New Total Stock no change
5.7 Subcontracting Purchase Order
Comments
Additional quantity to track is the Mat. prov. to vendor at plant level, displayed (when such material exists) in the Stock overview: Basic list MMBE.
5.7.1 as material being ordered
Test Description
PO, GT, GR, RR, IR of a subcontracting order. Test material is being ordered.
Material Being Ordered Moving Average Price 19.15
Standard Price 0
Total Stock 477
Component Material
Material Type RAW
Valuation Class 3000
Price Control V
Moving Average Price 1.00
Standard Price 0
Total Stock 250
Mat. prov. to vendor 0 Event
PO 100 EA @ $10, with 200 EA components (set item category flag I = L)
GT 200 EA components with 541 Tfr. pstg. to stock with subcontractor from unrestr.-use st.
Postings Transaction Code MB1B or ME2O
Item Quantity UnE Material Plnt SLoc Batch Re MvT S S Un Material description Reserv.no. Itm FIs 1 200 EA TT-RAW-V0 1 1 541 - TT-RAW-V0 short desc.
2 200 EA TT-RAW-V0 1 541 O + TT-RAW-V0 short desc.
Material document 49000044 does not include an accounting document Material Being Ordered
New M. Ave. Price no change New Total Stock no change Component Material New M. Ave. Price no change New Total Stock no change Mat. prov. to vendor 200
Event
RR 10 EA with 102 Goods receipt for purchase order into warehouse - reversal
Postings Transaction Code MB01
Item 1 / 6 Debit/credit 240.00 Material Being Ordered
New M. Ave. Price 18.02 New Total Stock 567
Component Material New M. Ave. Price no change New Total Stock 70 Mat. prov. to vendor 20 Event
IR Amt: $900 for Qty 90 EA.
Postings Transaction Code MRHR
Itm PK Acc/mat/asset/vend PO number Item Quantity Amount Name 001 31 11 0 900.00- PCC vendor name line 1 002 86 TT-RAW-V 100015 00010 90 900.00 TT-RAW-V Moving Ave. Price Raw Material
Itm Account Allocation Description Amount in USD 001 11 PCC vendor name line 1 900.00- 002 2050 000010001500010 Goods rcvd/inv rcvd 900.00 New M. Ave. Price no change
New Total Stock no change
5.7.2 with incidental costs (freight)
Test Description
PO with freight conditions, GT, GR, RR, IR of a subcontracting order. Test material is being ordered.
Material Being Ordered Moving Average Price 18.02
Standard Price 0
Total Stock 567
Component Material
Material Type RAW
Valuation Class 3000
Price Control V
Moving Average Price 1
Standard Price 0
Total Stock 70
Mat. prov. to vendor 20
Event
PO 3 EA @ $10, with 6 EA components (set item category flag I = L), conditions FRB1 = $50 GT 6 EA components with 541 Tfr. pstg. to stock with subcontractor from unrestr.-use st.
Postings Transaction Code MB1B or ME2O
Component Material New M. Ave. Price no change New Total Stock 64 Mat. prov. to vendor 20 Event
RR 1 EA with 102 Goods receipt for purchase order into warehouse - reversal
Postings Transaction Code MB01
Itm Account Allocation Description Amount in USD 001 11 PCC vendor name line 1 30.00- 002 2050 000010001600010 Goods rcvd/inv rcvd 30.00 New M. Ave. Price no change
New Total Stock no change Event
IR $50 for freight to a different vendor. (Hint : on Enter Invoice: Initial Screen enter the vendor. On the Enter Invoice:
Document Overview in USD screen, Edit | Delivery costs | Planned | By purchase order.)
Postings Transaction Code MRHR
Itm PK Acc/mat/asset/vend PO number Item Quantity Amount Name 001 31 10 0 50.00- Computer Pro 002 40 TT-RAW-V 100016 00010 3 50.00 TT-RAW-V Moving Ave. Price Raw Material
Itm Account Allocation Description Amount in USD 001 10 Computer Pro 50.00- 002 2500 000010001600010 Freight clearing 50.00 New M. Ave. Price no change
New Total Stock no change
5.8 Vendor Consignment Postings
Comments
The additional quantity to record in this section, Unrestr. consignment RMMG3 KLABS, can be found in the material master Display Material: Plant/storage location stock screen, under the heading Plant stocks in current period.
5.8.1 GR, GI, GT, Settlement 101 / 102 / 201 k / 202 k / 403 / 404
Test Description
GR for PO of vendor consignment stock + reversal.
GI to cost center of vendor consignment stock + reversal.
GT from consignment stock to own stock + reversal Settle vendor consignment liability.
Moving Average Price 11.5
Standard Price 0
Total Stock 70
Consignment Qty 0
Event
Create vendor consignment (MSK1) with price = MVP + 2.
PO 100 EA (set item category flag I = k)
GR 100 EA with 101 Goods receipt for purchase order into warehouse/stores
Postings Transaction Code MB01
Item Quantity UnE Material Plnt SLoc PO number Item S DCI Un Material description Batch R MvT S T 1 100 EA TT-RAW-V 1 1 100009 10 K TT-RAW-V Moving Ave. Price Ra 101 +
Material document 50000016 does not include an accounting document New M. Ave. Price no change
New Total Stock no change New Consignment Qty 100 Event
RR 10 EA with 102 Goods receipt for purchase order into warehouse - reversal
Postings Transaction Code MB01
Item Quantity UnE Material Plnt SLoc PO number Item S DCI Un Material description Batch R MvT S T 1 10 EA TT-RAW-V 1 1 100009 10 K TT-RAW-V Moving Ave. Price Ra 102 -
Material document 50000017 does not include an accounting document New M. Ave. Price no change
New Total Stock no change New Consignment Qty 90 Event
GI 40 EA with 201 K Consumption for cost center from consignment stores. (Set Special stock = k on initial screen).
Postings Transaction Code MB1A
Item Quantity UnE Material Plnt SLoc Batch Re MvT S S Un Material description Reserv.no. Itm FIs 1 40 EA TT-RAW-V 1 1 201 K - TT-RAW-V Moving Ave. Price Raw
Itm Account Allocation Description Amount in USD 001 2005 050000000011 AP consignment 540.00- 002 5100 0000000140 Consumption Raw.Mat. 540.00 New M. Ave. Price no change
New Total Stock no change New Consignment Qty 50 Event
RI 5 EA with 202 K Consumption for cost center from consignment - reversal. (Set Special stock = k on initial screen).
RT 20 EA with 404 Transfer posting to own stock from consignment - reversal
Postings Transaction Code MB1B
New Total Stock 80 New Consignment Qty 45 Event
Settle consignment liability (select by vendor on initial screen).
Postings Transaction Code MRKO
Itm PK Acc/mat/asset/vend PO number Item Quantity Amount Name 001 31 11 0.000 607.50- PCC vendor name line 1 002 40 2005 0.000 540.00 Accounts payable consignment 003 50 2005 0.000 67.50- Accounts payable consignment 004 40 2005 0.000 405.00 Accounts payable consignment 005 50 2005 0.000 270.00- Accounts payable consignment
Itm Account Allocation Description Amount in USD 001 11 PCC vendor name line 1 607.50- 002 2005 050000000011 AP consignment 540.00 003 2005 050000000011 AP consignment 67.50- 004 2005 050000000011 AP consignment 405.00 005 2005 050000000011 AP consignment 270.00- Item 1 / 5 Debit/credit 945.00 New M. Ave. Price no change
New Total Stock no change New Consignment Qty no change
5.9 Sales and Distribution Postings
5.9.1 GI to Sales Order, GR Customer Returns 601 / 651
Test Description
GI for sales order within SD
GR process customer returns within SD Comments
The additional quantity to record in this section, Returns RMMG3-RETME, can be found in the material master Display Material:
Plant/storage location stock screen, under the heading Plant stocks in current period.
Tester Comments Test Not Applicable.
Material master records for material type RAW does not allow SD views, so can not create sales order.