Automatic GR/IR Clearing with "diff too large"

Remember to run F.13 - automatic GR/IR Clearing with "include tolerance" option.
Also, make sure the following settings are set through SPRO
1.Define Tolerance Groups for G/L Accounts
2.Define Tolerance Groups for Employees
3.Assign Users to Tolerance Groups
4.Create Accounts for Clearing Differences
5. Prepare Automatic Clearing(based on assignment number/ PO+PO_item needed to be clear.)

And assign the tolerance group to G/L account related GR/IR Clearing via FS00.

Configuring Availability check

There are three types of availability checks –
A. Check on basis of ATP quantities.
B. Check against product allocation.
C. Check against planning.

Configuring Availability check through Checking Groups
1. The checking group + checking rule determine how the availability check is to be performed.

2. The checking group determines whether and how the system checks the stock availability and generates requirements for material planning. The checking group defines what type of requirements will be passed on i.e. summarized requirements (daily/weekly) or individual requirements for each sales order.

3. The checking rule applies to how the availability check is to be carried out at the transaction level. Note that you must define checking rules for each individual application such as for production orders for example. In Sales and Distribution, the checking rule is specified internally within the system and cannot be changed.

4. The checking rule, in conjunction with the checking group, determines the scope of the availability check for every business operation; that is, which stocks, receipts and issues are to be included in the availability check and whether the check is to be carried out with or without the replenishment lead time.

5. Briefly explaining the above – checking group determines which type of requirement to be passed on to MRP whether it be individual or summarized and checking rule which is at the transaction level and can be configured independently for each application module, determines which stocks, receipts and issues to be taken into account. For performing an availability check checking group has to work in conjunction with checking rule.

6. Advantages of individual processing over summarized processing –Backorder processing is possible.You can access (MD04) order, line and schedule line individually which gives a greater control on available stock and requirements placed on stock.The system automatically uses individual requirements in case of special stock items.

7. Required data for the Availability check to be carried out –The Availability check must be switched on at the requirement class level.The Availability check must be set at the schedule line level.A requirements type must exist by which the requirements class can be found.A plant must be defined in the sales order for each schedule line item (in other words plant must be defined for every material in MMR). A checking group must be defined in the material master record in the MRP3 screen in the availability check field.

8. Configuring Availability check and defining Checking Groups –Checking groups are introduced into the sales order based on the setting in the material master record.SAP standard checking groups are
01 – summarized requirements and
02 – individual requirements or you can create your own by copying the standard ones.
Total sales and total deliveries columns are there to configure a checking rule to sum up requirements to post to MRP either individually or by day or week.Block quantity required can be set if you want several users to be able to process the material simultaneously in different transactions without blocking each other.The no check indicator is CHECKED when you DO NOT want the system to carry out ATP check.

9. Defining material block for other users – the block check box is an indicator that enables you to block material master records of a particular material during the availability check and restrict other users from accessing same master record and reserve the material. If the block is not set, two users can confirm the same material at the same time for two different orders, not knowing if the stock is available or not. If you select this field, the material is blocked during the availability check and other users cannot:
a) Make changes in the material master record.
b) Create purchase orders for the material.
C) Create orders for the material.

10.Defining default values for checking groups - Checking groups are introduced into the sales order based on the setting in the material master record. However if there is no entry present in the material master record for the checking group, a default value can be set here, depending on material type and plant.This default value will be used by the system depending on the material type mentioned in MMR and plant in sales order.If an entry exists, this default value is over written by MMR.

11.Controlling Availability Check – in this section, you tell the system what stock on hand and what inward and outward movements of stock it must take into account when performing the availability check in addition to whether or not to consider the replenishment lead time.

12.These settings are based on the checking group that is assigned to the material master record and the checking rule that is predefined and assigned to the sales and distribution transaction.

13.These settings carry out control both for sales order and delivery as well. This is due to the fact that you may want to include specific stock or incoming stock for the sales order, yet at the time of the delivery only include physical stock on hand waiting to be shipped.

14.It is possible to indicate to the system that you would like the availability check NOT TO CHECK the stock at the storage location level. This indicator is used to set the scope of the availability check.

15.It is used to switch off the check at storage location level. You create a reservation for a particular storage location. However, the scope of the availability check is set in such a way as to exclude the storage location. In this case, the system carries out the check at plant level only and does not take the storage location into account that is specified in the reservation.

16.Should you not want the system to automatically check RLT, you may indicate so here. RLT is the time taken for a material to become available. It is only used when doing an ATP check and is taken from MMR.

17.defining the elements in the availability check entirely depends on the business needs, but a few tips are given under –When controlling the Availability check at the time of the sales order, a purchase requisition does not necessarily indicate by it is going to come into the plant.A shipping notification on the other hand - a confirmed purchase order – is a good indicator of receiving stock on a specified date.It is always recommended not to select the shipping notifications for the delivery requirements type as you may not actually receive the stock into plant or warehouse for which you are creating a delivery.

Availability check

1. Availability check is an integral part of the business process that determines if the required delivery quantity can be met on a required delivery date. For this purpose the system takes into account pre-delivery activities such as scheduling for picking or packing times and the time taken to produce or obtain the material. It also performs several background functions such as
Backorder processing, rescheduling and ATP quantities.

2. Backorder processing: processing of a sales order that has not been fully confirmed or not confirmed at a certain delivery date.

3. Rescheduling: is a proposal of how – confirmed quantities already assigned to a sales order can be reassigned to other sales orders that have a higher priority.

4. Available to promise (ATP): is a process of checking the available quantities of a material. The ATP quantity consists of warehouse stock + planned receipts (incoming stock) – planned issues (outgoing stock). to examine stock on hand (CO09) proceed to logistics – sales & distribution – sales – environment – availability overview.

5. Replenishment lead time (RLT): is the time taken for the material to become available either internally (in house production) or externally (from a vendor). The most important things to consider during an external procurement are purchasing and MRP2 (procurement) views of MMR where the processing time for purchasing, planned delivery time and goods receipt processing time are taken into account. On the other hand internal procurement is based on in house production time (MRP 2 view) goods receipt processing time or alternatively RLT time, which is found on MRP 3 view.

6. RLT (Replenishment Lead Time) is the time taken for the material to become available. RLT is only used when doing an ATP check (Available To Promise). The value of RLT for a material is specified on material master record.

Information Structure

We can make use of information structure as transaction data table to do various custom made
The information structure started with S03X is related to inventory controlling.

For examples, S031- Stock Movement. All key figures relating to material movements involving current valuated stock are updated to this information structure.

1) S031 Movements
2) S032 Stocks
3) S033 Movements (individual records)
4) S034 Movements (Batches)
5) S035 Stocks (Batches)
6) S039 Planning
If you wish to fill the information structure S039 with actual data, then you can use the report RMCBS039.
7) S094 Stock/Requirements Analysis

It is referenced from http://help.sap.com/saphelp_di46c2/helpdata/EN/c1/37551e449a11d188fe0000e8322f96/content.htm

Archive price change documents

To archive price change documents (MR21), use archiving tool SARA and type the object CO_ML_BEL

Common Tables used by MM

Below are few important Common Tables used in Materials Management Modules:
EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MAST Material to BOM Link
MBEW Material Valuation
MKPF Header- Material Document
MSEG Document Segment- Material
MVER Material Consumption
MVKE Sales Data for materials
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
MOFF Lists what views have not been created
A501 Plant/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
IKPF Header- Physical Inventory Document
ISEG Physical Inventory Document Items
LFA1 Vendor Master (General section)
LFB1 Vendor Master (Company Code)
NRIV Number range intervals
RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types

Relevant MM T-Codes

Purchase Order Requisition-ME51N
RFQ to Vendor ----------------- ME41
Raising Quotation ------------- ME47
Comparison of Price ----------ME49
Vendor Evaluation -------------ME61
Creation of PO ------------------ME21N
Goods Receipt with PO ------MIGO
Goods Receipt without PO --MBIC
Invoice Verification -------------MIRO
Goods Issue --------------------- MB1A
Physical Inventory -------------- MI01( Create doc) MI04 (Enter Count) MI07 (Post)

SD Process Flow

1. Inquiry (VA11)
2. Quotation / Contracts / Scheduling Agreements (VA21)
3. Sales Order (VA01)
4. Delivery
a) Create Delivery (VL01N)
b) Picking (LT03)
c) Picking Confirmation (LT12)
d) Packing (Optional in VL02N)
e) Post Goods issue (VL02N)
5. Billing(=Invoice) (VF01)
6. Post Incoming Payment (F-28)

MM Process Flow

PR (Purchase Requisition) > Release the PR > RFQ (Request for Qotation) > Quotation > Quotation Comparison > PO > Release the PO > GR (Goods Receiving) > Invoice Verification

The typical procurement cycle for a service or material consists of the following phases:
1. Determination of Requirements
Materials requirements are identified either in the user departments or via materials planning and control. (This can cover both MRP proper and the demand-based approach to inventory control. The regular checking of stock levels of materials defined by master records, use of the order-point method, and forecasting on the basis of past usage are important aspects of the latter.) You can enter purchase requisitions yourself, or they can be generated automatically by the materials planning and control system.

2. Source Determination
The Purchasing component helps you identify potential sources of supply based on past orders and existing longer-term purchase agreements. This speeds the process of creating requests for quotation (RFQs), which can be sent to vendors electronically via SAP EDI, if desired.

3. Vendor Selection and Comparison of Quotations
The system is capable of simulating pricing scenarios, allowing you to compare a number of different quotations. Rejection letters can be sent automatically.

4. Purchase Order Processing
The Purchasing system adopts information from the requisition and the quotation to help you create a purchase order. As with purchase requisitions, you can generate Pos yourself or have the system generate them automatically. Vendor scheduling agreements and contracts (in the SAP System, types of longer-term purchase agreement) are also supported.

5. Purchase Order Follow-Up
The system checks the reminder periods you have specified and - if necessary - automatically prints reminders or expediters at the predefined intervals. It also provides you with an up-to-date status of all purchase requisitions, quotations, and purchase orders.

6. Goods Receiving and Inventory Management
Goods Receiving personnel can confirm the receipt of goods simply by entering the Po number. By specifying permissible tolerances, buyers can limit over- and underdeliveries of ordered goods.7. Invoice VerificationThe system supports the checking and matching of invoices. The accounts payable clerk is notified of quantity and price variances because the system has access to PO and goods receipt data. This speeds the process of auditing and clearing invoices for payment.

How to configure the Sales Account Determination?

To define the General Leger posting :
IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts
With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing.
User will not be able to Release the billing document to Accounting if this is not setup.
If you happend to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment.
* Transaction code VKOA

Backorder Processing

Backorder processing is a functionality in SAP where you can change the committments and over-ride the blockage of stocks marked against sales documents/deliveries.
For examples; you receive an order from a very important customer for material "material A" but the entire quantity of "material A" is committed to another customer via earlier sales orders and this is where BACKORDER processing helps you to change the committment and shift stock due for B to A. This is the benefit of this funtionality.

T-codes for above process:
OMIH - Checking rule for updating backorders
OPJL - Define new checking rule
OPJJ - Define scope of check
V_RA - Backorder Processing