SAP FI-MM Integration

Material Management is the Costing unit for Org, they spent money so each and every activity which spent money should be captured by the Finance People.

1. Movement Types: 

Used to enable the system to find the predefined posting rules determining how the accounts of financial accounting system are to be posted & to update the stock fields in the material master data. (Goods Receipt, Goods Issue, etc)

All Material Movements in MM happens with respect to a Movement type.

Goods Receipt – Movement type-101

Goods issue to production Order- Movement Type-261

Scrapping of Goods- Movement Type-551

Goods Delivered to the customer- Movement Type-601

Initial Upload to Stock- Movement Type-561

Material Master-Valuation class- Movement type-Transaction key

2. Valuation Class:

Every Material will have a Valuation Class field. Valuation class could be finished goods, Semi-finished Goods and Raw Materials etc. Combination of Valuation class + The Movement types determines the GL accounts.

Type of Valuation Class:

3000 – Raw Materials

7900 – Semi finished Goods

7920 – Finished Goods

Raw material procures with Valuation Class 3000 and go for processing , converted to semi-finished product with Valuation Class 7900 and finally Finished products converted  with Valuation Class 7920 which you can sale Finished products by creating a sale order (VA01).

3. Transaction key: 

Used to control the storage or filing of documents & assignment of documents. Used to differentiate b/w various transactions such as goods movement that occur in inventory.

BSX – Stock Posting / Inventory Posting

PRD – Price difference

GBB – Offsetting entry for stock posting

WRX – GR/IR Clearing

FRI – Freight Clearing

4. Valuation Modifier: Valuation modifier is also called as valuation grouping code. Use OMWM to activate Valuation Grouping code.

OMWD– Assign Valuation Grouping code to Valuation area.

Valuation grouping code is used to group the valuation area to minimize the effort, In SAP using two types of valuation area

1. Company Code, 2. Plant,  But the SAP recommends you to use the valuation area at plant level, because valuation will be differ from one plant to another, if need we can maintain the valuation area at company level also, The valuation grouping code makes it easier to set automatic account determination. Within the chart of accounts, based on our requirement to define individual account determination for certain valuation areas or, to define common account determination for several valuation areas

We can maintain the valuation group code in OMWD for the valuation area as Plant or Company within the chart of account

Note: It is mandatory to maintain Valuation Modifier. As Valuation area cannot be assigned directly to account determinations. Even if you have only one valuation area, it should be assigned to a Valuation Modifier.

5. Material Type:

Each material should assign material type in Material master record used to update whether changes made in Quantity are updated in material master record & change in value also updated in stock account.

FI-MM: The integration between FI-MM happens in T-code OBYC. 

Step1: First you send a Purchase Order to the Vendor.

Here there won’t be any accounting entry as this is simply like telling the Vendor what goods you want, its quantity and the date of delivery etc.,

Step 2: When GR is posted.

When you receive Goods you CAN NOT make the following entry

Inventory A/c Dr

To Vendor A/c

 

Because, some of the goods you have received may be damaged or may not be up to the mark or for any other reason goods may reject, so before posting it to Vendor A/c we keep it in separate place till we verify the goods. And the actual entry will be:

Inventory A/c Dr (Transaction Key BSX @ OBYC)

To GR/IR A/c (Transaction Key WRX @ OBYC)

Here the goods received is Debited to inventory and Credited to a temporary A/c i.e., GR/IR a/c

Step 3: You will post an Invoice to the Goods received.

Here you will post the invoice after you are satisfied with the goods received, the entry will be

GR/IR A/c Dr

To Vendor A/c

Now the goods are moved from GR/IR A/c and Vendor is credited. Now you got the final entry of Goods to Vendor Account i.e.

Inventory A/c Dr

To Vendor A/c

i.e., Inventory A/c was debited and Vendor A/c was Credit and GR/IR A/c is Dr and also credited hence its balance became ‘Zero’, and it has to be Zero always.

Step 4: Payment to Vendor.

Vendor A/c Dr

To Bank Clearing A/c

Step 5: At the time of Bank Statement upload:

Bank Clearing A/c Dr

   To Bank Main A/c