Stock Transfer Order process with GST

There are number of STO process are available in the SAP Material Management. Here we are sharing the process of Stock Transfer Order with Delivery via Shipping after GST includes basic configuration settings.
For Intrastate STO transaction with same GST identification number, no GST is applicable. And for Intrastate with different GST identification number or Interstate STO transaction, GST is applicable.

STO Configuration for GST:

1. Define Shipping Data for Plants
2. Assign Delivery Type and Checking Rule
3. Assign Document Type,  One-Step Procedure, Underdelivery Tolerance
4. Define New Billing Type for Outbound Invoice
5. SD Pricing Procedure for STO Billing Document
6. Copy Control of Delivery to Billing
7. Classify SD Condition Type
8. Classify MM Condition Type
9. Maintenance of Business Place wise GL Determination

1. Define Shipping Data for Plants 
Path: SPRO -> Materials Management -> Purchasing -> Purchase Order -> Set up Stock Transport Order -> Define Shipping Data for Plants
Maintain Customer no-Plant, Sales Org, Dist. Channel, Division for Receiving Plant

2. Assign Delivery Type and Checking Rule
Path: SPRO -> Materials Management -> Purchasing -> Purchase Order -> Set up Stock Transport Order -> Assign Delivery Type and Checking Rule
Maintain PO Type – UB, Supplying Plant, Delivery Type – NL and checking rule for Availability Check.
Here we define the PO Type - UB and Delivery Type - NL (Replenishment delivery) is provided for intra-company-code stock transfers and PO Type - NB and Delivery Type - NLCC (Replenishment delivery cross company) for cross-company-code stock transfers.

3. Assign Document Type,  One-Step Procedure, Underdelivery Tolerance
Path: SPRO -> Materials Management -> Purchasing -> Purchase Order -> Set up Stock Transport Order -> Assign Document Type, One-Step Procedure, Underdelivery Tolerance
Here we define the Supplying Plant and Receiving Plant, PO Type UB or NB, Single Step - Blank

4. Define New Billing Type for Outbound Invoice
Go to Transaction – VOFA and copy Doc. Type F2 to ZGST (ZGST document type is for reference)

5. SD Pricing Procedure for STO Billing Document
Go to Transaction – V/08, define new pricing procedure ZINSTO for STO process for GST.
Define Price Condition and maintain Account key ZST and define STO G/L here, which will post the price in this G/L instead of sales revenue account. New Routine 900 is also define and assigned in the Pricing Procedure against GST Condition Type
Add GST Condition Type – JOCG, JOSG and JOIG, new Routine 900 and account key JIC, JIS and JII of it.

6. Copy Control of Delivery to Billing
Set the “Delivery to Billing” copy control, use the Transaction – VTFL and copy from Billing Type – F2 and Delivery – LF to ZGST

7. Classify SD Condition Type
SPRO > Logistics-General > Tax on Goods Movements > India > Basic Settings > Determination of Excise Duty > Condition-Based Excise Determination > Classify Condition Types (J_1IEXCDEFN table)
Define Pricing ZINSTO, Condition Type JOCG, JOSG, JOIG and Condition Name – CGSTAR, SGSTAR and IGSTAR.
And also do same with Tax Procedure TAXINN

8. Classify MM Condition Type
SPRO > Logistics-General > Tax on Goods Movements > India > Basic Settings > Determination of Excise Duty > Condition-Based Excise Determination > Classify Condition Types (J_1IEXCDEFN table)
Define Tax Procedure TAXINN, Condition Type JICG, JISG, JIIG and Condition Name – CGSTSOFFAP, SGSTOFFAP, IGSTOFFAF

9. Maintenance of Business Place wise GL Determination
Maintain the entries in the view J_1IT030K_V for all relevant business places and tax codes combinations needed for your business
Tax Code, Business Place 1000 and G/L Account
Maintain the entries of same dummy GL in OB40 for all the tax codes which has been used above.
Chart of Account 1000, Transaction JIC, JIS, JII, Tax Code and G/L Account.

STO Process step by step:

1. Create Customer Master for Receiving Plant(T. Code –XD01)
2. Create Vendor Master  for Supplying Plant (T. Code – XK01)
3. Extend Sales Views of Material Master in Receiving Plant (T. Code – MM01)
4. Create Info Record (T. Code – ME11)
5. Create Stock Transfer Order (T. Code - ME21N)
6. Create Outbound Delivery and Post Goods Issue (T. Code – VL10B and VL02N)
7. Create GST Outbound Invoice (T. Code – VF01)
8. Post Goods Receipt (T. Code – MIGO)
9. Create GST Inbound Invoice (T. Code – J_1IG_INV)

1. Create Customer Master through T. Code  – XD01 for a Receiving Plant, maintain GSTIN in Tax number 3 in Control Data view

2. Extend the Sales view of the Material Master through T. Code – MM01 to be transferred for the Supplying Plant

3. Create Vendor Master through T. Code – XK01 for a Receiving Plant, maintain GSTIN Number in Tax Number 3 in Control view and assign Supplying Plant in the Extra – Additional Purchasing Data

4. Create Info Record through T. Code – ME11 for Receiving Plant, vendor and Material and maintained the GST Tax code. This tax code is required during GST Inbound Invoice creation for posting G/L account

5. Create STO Purchase Order through T. Code - ME21N using PO Type UB, and Item Category “U – Stock Transfer”, maintain the supplying plant, material, receiving plant. In Shipping data tab check the Delivery Type – NL, Customer and Sales org. data automatically flow here. There is no Invoice Tab for Tax code to enter; it will refer from the Info Record.

6. Create Outbound Delivery through T. Code – VL10B or VL10D. Enter the STO PO and execute. Then select the items and click on Background, the system will automatically create the Outbound Delivery

7. Post Goods Issue; Go to Change Outbound Delivery T. Code – VL02N, enter the Outbound Delivery and  pick the quantity and then click on Post goods issue to Issue material from Supplying Plant
Accounting Entries:
Receiving Plant RM Stock A/C Dr.
Supplying Plant RM Stock A/C Cr.

8. Create GST Outbound Invoice with reference to Outbound Delivery through T. Code – VF01 using Billing Type ZGST.  GST STO pricing procedure will be same as we define in the Configuration Step. The tax value will be zero if it is Intra state with same GSTIN number and taxes value will be there in the case of Intrastate with different GSTIN number and Interstate. Save the Document.
Accounting Entries:
Inter Plant Sales A/C  Dr. (This is Inter Plant Customer (Receiving) A/c)
GST Control A/C Cr.( Our Assumption is it will be in the nature of Balance Sheet A/c)
IGST / CGST/ SGST Payable A/C       Cr.

9. Post Goods Receipt in the Receiving Plant with reference to Outbound Delivery through T. Code – MIGO. The system will automatically fetch all data from the Outbound Delivery.

10. Create GST Inbound Invoice through T. Code – J_1IG_INV by choosing any options GST Invoice or Stock Transfer Order. Provide the details as required and execute the transaction. Then select the desired items and click on Create to create Inbound Invoice (this is a FI Document). This will update the GST Inbound Invoice column and by double clicking on this will display the accounting entries.
Accounting Entries:
GST Control A/C        Dr. .( Our Assumption is it will be in the nature of Balance Sheet A/c)
IGST Input   A/C        Dr.
Inter Plant Sales A/C Cr.(This is Inter Plant vendor (Supplying) A/c)

Price Control for Material Types - Valuation and Account Assignment

Define Price Control for Material Types

There are two types of Price control in the SAP R/3 system:

- V Moving average price/ periodic unit price: price that changes periodically as a result of goods movement and invoice entries. It is calculated by dividing the value of the material by the quantity of the material in inventory. It references the base unit of measure and price unit in the material master records
- S Standard price: constant price at which a material is valuated without taking goods movement and invoices into account

For each material, you must specify the price control indicator in the material master record in Accounting1 view according to which the material is to be valuated.

Standard Setting in the Material Master

Price control is preset as follows in the standard SAP R/3 system:

- Moving average for materials procured externally
- Standard for in-house produced materials

SAP recommends using the presetting for each material type.

Configuration:
IMG Menu :- SPRO - SAP Ref. IMG - Materials Management - Valuation and Account Assignment - Define Price Control for Material Types
Transcation Code :- OMW1

In this setting, we define the default price control for the Material Types:

Material Type	Material Type Desc.	Price Control	Price control Mandatory
FERT	Finished Material	S
ROH	Raw materials	V
SERV	Service Product	S	X
HALB	Semifinished Product	S

In more details:

Moving Average Price :
- Goods Receipt are posted at the goods receipt value
- The price in the material master is adjusted to the delivered price
- Price differences occurs only in exceptional case
- Manual price changes are usually unnecessary. However, they are possible.

If the material is assigned a moving average price (V), the price is automatically adjusted in the material master record when price variance occur. If goods movement or invoice receipts are posted using a price that differs from the moving average price, the difference are posted in the stock account; as a result, the value of the moving average price and the value of the stock change.

The moving average price displayed in the material master record is rounded off. For valuation calculation, the system always uses the exact price (stock value/ stock quantity)

Standard Price:
- All inventory postings are carried out at the standard price
- variance are posted at the price difference account
- variances are updated
- price change can be monitored

If a material is assigned to standard price (S), the value of the material is always calculated at this price. If goods movement or invoice receipts contain a price that differs from the standard price., the differences are posted to a price difference account. The variance is not taken into account in valuation.

Changing the Type of Price control
Under certain conditions, you can change the price control:

From Standard Price to Moving Average Price
You can make this changes any time. The moving average price (which until now has been updated for information purpose only) replaces the standard price and is used for valuation from now.

From Moving Average Price to Standard Price
You cannot make changes in the following two cases:
- If the material master record is set up as a valuation header record for a material subject to split valuation.
- If the standard price comes from costing and is not equal to the moving average price
If the change is possible, the moving average price becomes the standard price, which is then used for valuation.
You change the type of price control by overwriting the price control indicator in the material master record with the new indicator.
Changing the type of price control for a material does not change the value of the material stock, since in both cases the current price becomes the new price.

Physical Inventory in SAP MM

What is Physical Inventory?

Physical inventory is the process of counting the material stock physically in the warehouse with the stock present in the SAP system.
The process of counting physical inventory, posting corresponding document and posting the difference is called Physical Inventory.
It is mandatory for legal reasons; every company must carry out a physical inventory of its warehouse stocks at least once per fiscal year to balance its inventory for Balance Sheet purpose.

Why we do physical inventory?

1. To know the correct stock in hand. Due to some inconvenience (like some materials have been stolen or broken) it may happen that the stock reflecting in sap system differs from the actual stock in storage location. Physical inventory is then carried out to synchronize the stock in hand with the stock reflecting in SAP system.
2. In many countries there is a law that Company have to do physical inventory to check the current stock in hand and that stock or assets is taken into consideration in Company’s financial statement.

In SAP, physical inventory can be carried out both for a company’s own stock and for special stock.
Note that the blocked stock returns and the stock in transfer cannot be inventoried. If these stocks are still to be counted in a physical inventory, you must transfer post these stocks to other stocks capable of inclusion in a physical inventory.

The stock in a warehouse can be divided into stock types. In the standard system, a physical inventory can be carried out for the following stock types:
• Unrestricted-use stock in the warehouse
• Quality inspection stock
• Blocked stock


The following physical inventory procedures can be used in SAP system:
• Periodic inventory
• Continuous inventory
• Cycle counting
• Inventory sampling

Periodic inventory: Most of the time companies use this kind of inventory. In most cases, it is done once a year, and this kind of inventory is called annual physical inventory. That means that material stock is counted once a year. Most of the times at the end of the year or after the season ends (in seasonal industries).

In a periodic inventory, all stocks of the company are physically counted on the balance sheet key date. In this case, every material must be counted. During counting, the entire warehouse must be blocked for material movements.

Continuous inventory: All materials are counted at some point in the year, but that can be at any day appointed for. So we can count some material in February, others in April and so on. A single material can be counted on a single date. This type of inventory is mainly utilized in warehouse management based warehouses, but it can be done in inventory management too.

In the continuous inventory procedure, stocks are counted continuously during the entire fiscal year. In this case, it is important to ensure that every material is physically counted at least once during the year. You can use the same transactions for 'continuous inventory' as for 'periodic inventory'. The only difference is that you count a material more than one time per fiscal year.

Cycle counting: This type of inventory allows us to set a period for regular intervals for physical inventory on the material level. So a fast moving and high value material can be counted four times a year while slow moving and low value material can be counted once a year. The indicator for this is set in material master in the Plant/Storage Location 1 View, in the field

Cycle counting is a method of physical inventory where inventory is counted at regular intervals within a fiscal year. These intervals (or cycles) depend on the cycle counting indicator set for the materials.
The Cycle Counting Method of Physical Inventory allows fast-moving items to be counted more frequently than slow-moving items.

CC phys. Inv. Ind. Inventory sampling: Only a number of randomly selected materials are counted on the balance sheet key date, and if those materials show small enough differences, the other materials can also be considered to have a correct stock level. Not really used that often, as it is essentially an approximation, but in some cases it can be used if material and warehouse structure imply that.

In MM Inventory Sampling, randomly selected stocks of the company are physically counted on the balance sheet key date. If the variances between the result of the count and the book inventory balance are small enough, it is presumed that the book inventory balances for the other stocks are correct.

Restrictions
The posting of physical inventory differences is subject to certain time constraints:

• The posting period is automatically set during counting. Therefore, the inventory difference must be posted to the same period or - if postings to the previous period are allowed - in the following period.
• The fiscal year is set by specifying a planned count date when creating a physical inventory document. All subsequent postings to this document must take place in this fiscal year and/or in the first period of the following fiscal year, if postings to the previous period are allowed.

Physical Inventory Process

The process of physical inventory can be divided into three phases:

1. Physical Inventory Preparation
• Create a physical inventory document.
• Blocking Materials for Posting
• Print and distribute the physical inventory document.
2. Physical Inventory Count
• Counting stocks
• Entering the result of the count on the physical inventory document printout
3. Physical Inventory Analysis
• Entering the result of the count into the system
• Initiating a recount, if necessary
• Posting inventory differences

The physical inventory procedure is carried out in three steps:
1. Creating a Physical Inventory Document
2. Entering the Physical Inventory Count
3. Posting inventory differences

You can also group together individual phases and carry them out in a single step, as follows:
• posting the physical inventory count without reference to a physical inventory document
In this step, the following are combined:
- a physical inventory document is created.
- the count is posted.
• posting the physical inventory count and inventory differences
If a physical inventory document exists, the following are combined in this step:
- the count is posted.
- any inventory differences are posted.
• posting the physical inventory count without reference to a physical inventory document
In this step, the following are combined:
- a physical inventory document is created
- the count is posted
- any inventory differences are posted

Physical Inventory Preparation

To ensure that the physical inventory count goes smoothly, you have to carry out a number of steps in preparation.

Process Flow
1. Create a physical inventory document.
A physical inventory document contains, among other things, the following data:
- the plant and storage location in which the count is to take place
- when the count is to take place
- which materials are to be counted
- for material handled in batches: which batches are to be counted
- in the case of split valuation: which sub-stocks are to be counted
- which stock types are to be counted

2. Blocking Materials for Posting
Due to the delay between a material movement and the posting of that movement, there is a short-term discrepancy between actual warehouse stock and book inventory. To avoid such a discrepancy during physical inventory, it is recommended that you block the materials for posting during the physical inventory. You can set a posting block two ways:
- You block the relevant materials when you enter the physical inventory document. This is recommended if you create the physical inventory document immediately before the count.
- You block the relevant materials later by changing the posted physical inventory document. This is recommended if you do not create the physical inventory document immediately before the count.
The posting block is automatically cancelled when you post the counting results for the physical inventory document.

3. Print and distribute the physical inventory document.
You must print out the physical inventory document for the physical inventory count and pass it on to the people responsible for doing the counting.

Physical Inventory Count

During the inventory count, all the materials being inventoried are counted and entered physically.

Process Flow
1. The stocks are counted for individually for the materials in a physical inventory document.
2. The count results are written on the printout of the physical inventory document.
3. The printout is then directed back to the person responsible, so that he or she can enter the count into the system and analyze it.

Physical Inventory Analysis

During the physical inventory analysis,
- enter the count results in the system
- determine whether a recount is necessary if there are any discrepancies
- post the inventory differences.

Process Flow

1. Entering the count results in the system
After the count has been taken, you must enter the results of the count into the system. You enter the counted stocks for every item of a physical inventory document.
If non-SAP programs are used to carry out the inventory count, you can import the count data into the R/3 System using the following functions:
- Using batch input for entering count results
- Transfer PDC (Portable Data Capture) inventory count data

2. Initiating a recount
It is possible to initiate recounts for individual items on a physical inventory document. This is recommended if you suspect that an error was made during counting. When you initiate a recount, a new physical inventory document is created.

3. Posting inventory differences
If the physical inventory is different from the book inventory, you must correct the book inventory balance by posting the differences. This step ends the physical inventory.

Result
When you post the physical inventory difference, the system creates a material document that records the adjusted stock balances and an accounting document that contains the necessary account activities.

Creating Physical Inventory Documents

Use
There are two methods of creating a physical inventory document, as follows:
 - Creating Single Documents
In this case, you explicitly specify the materials to be counted. This method is recommended if you want to take inventory of only a few materials.
 - Creating Sessions
In this case, you enter the criteria that should determine which materials are to be inventoried in which plants and storage locations. The system then creates a physical inventory document for each plant and storage location with the materials that fulfill the criteria. This method is recommended if you want to take inventory of a lot of materials

Changing Physical Inventory Documents

You can make the following changes to a physical inventory document:
 In the document header
- change the planned count date
- set or remove the posting block
- freeze the book inventory balance
- create or change the physical inventory number
 In an item still to be counted
- change the stock type
- change the count unit of measure
- set the deletion indicator
- Enter new items, provided no count has taken place
- Delete the document

Please note when deleting:
- If you set the deletion indicator for an item, the item remains in the document but cannot be processed. This will unblock the material.
- If you delete a document, it is physically deleted if there are no inventory difference postings for its items. If a difference has been posted, the document is proof of the posting. Therefore, it is simply flagged for deletion. This means it can then be displayed, but no longer processed. The document is physically deleted when the next reorganization program is run.

Blocking Materials for Posting

There are two ways to block materials for posting for the duration of the physical inventory count:
 - Blocking when Creating
 - Blocking Later

Blocking when Creating
To block the materials of a physical inventory document when you create the document, do the following:
When creating an individual physical inventory document, select the Posting block field on the initial screen.
When creating a session, select the Posting block field on the selection screen.

Blocking Later
You can block materials later either for an individual physical inventory document or (using sessions) for several physical inventory documents. To do this, proceed as follows:
- individual processing
a. From the inventory screen, select Physical inventory document Change. The initial screen appears.
b. On the initial screen, enter the number of the physical inventory document. Since the posting block is specified in the document header, select GoTo Header from the menu. The header data screen appears.
c. On the header data screen, select the Posting block field.
d. Post the document by selecting Physical inventory document Post from the menu.

- session processing
a. From the Physical Inventory menu, select Sessions Block material. The criterion screen appears.
b. On the criterion screen, enter the number of the physical inventory document (or a range of physical inventory document numbers), and select the Posting block field.
c. Select Program Execute from the menu. The system creates a session. A list appears with all of the physical inventory documents that are to be blocked according to your selection. The system displays a message with the name of the session.

Printing Physical Inventory Documents

To print physical inventory documents, proceed as follows
From the inventory screen, select Document Print. The criterion screen appears. Give SAP Printer and Print

Entering the Physical Inventory Count

After the count has been performed, you must enter the results of the count into the system.
There is also a provision in the R/3 System to enter the result of the count for a material for which no physical inventory document has been created. In this case, a physical inventory document is automatically created upon entry of the result of the count.

Thus, there are two methods for entering a physical inventory count, as follows:
- entering the count with reference to a physical inventory document
- entering the count without reference to a physical inventory document
Furthermore, it is possible to change an already entered physical inventory count.

Freezing the Book Inventory Balance

If you have not completed your inventory count, you can freeze the book inventory balance in the physical inventory document. This is to prevent the book inventory balance, which is relevant for physical inventory, from being changed by any movements. These could otherwise lead to incorrect inventory differences.
From the Physical Inventory menu, you can freeze the book inventory balance using the following functions:
- Physical inventory document Create (initial screen)
- Inventory count Change (Header)

Setting Zero Count

If a quantity of zero was counted for an item, enter this by selecting the ZC (zero count) column.
It is not sufficient to enter 0 in the Quantity in column, because the system interprets a zero as "not yet counted."
Setting Zero Count Automatically
When entering inventory counts with reference to a physical inventory document which contains many items with a stock balance of zero, it is possible to set “zero count” automatically for all items not counted.
Consequently, you only need to enter the quantity counted for inventory items with stock. You no longer need to set the indicator Zero count for every single item with zero stock.

Changing a Physical Inventory Count

To change a physical inventory count, you proceed exactly as you would for entering a physical inventory count, with one difference. On the item screen, the Quantity in column is already filled.
Overtype the entry with the corrected quantity, then post the document.
If you have initiated a recount for an item, you can no longer change the physical inventory count. The quantity determined during recounting can only be entered in the physical inventory document for the recount.

Initiating a Recount

Enter the physical inventory document for which you want to initiate a recount. By specifying a threshold value, you can limit the number of items in the recount to only those which display a larger difference than the threshold value.
A new physical inventory document is created that contains the selected items. The system confirms the posting and displays the number of the physical inventory document.
The recounted items are deactivated in the original document and can no longer be processed via this document.

Posting Inventory Differences

There are various options for posting inventory differences depending on the processing status of the physical inventory transaction.
- Posting differences after the count has been posted
A physical inventory document has already been created, and the count has already been posted. You only have to post the inventory differences.
- Posting the count and inventory differences simultaneously after the physical inventory document has been created
A physical inventory document has been created, but the count has not yet been posted.
The count results are available. You enter the count and post the differences in one step.
- Entering the count without a document reference
You have a count result without reference; that is, no physical inventory document has yet been created for this physical inventory transaction. You create a physical inventory document, enter the count, and post the differences in one step.

Posting Differences After the Count Has Been Posted - MI07
Posting the Count and Differences Simultaneously - MI08
Entering the Count Without a Document Reference - MI10

After the inventory differences have been posted successfully, the system issues the message:
Diff. for I-document ----- posted with M-document -----.
When you post the physical inventory difference, the system creates a material document that records the adjusted stock balances and an accounting document that contains the necessary account activities.

Serial Numbers in Physical Inventory

When carrying out a physical inventory for materials that have serial numbers, you can enter the serial numbers while you are entering the results of the physical inventory count.
This is possible for the following transactions/events:
- Entering the physical inventory count (MI04)
- Entering the physical inventory count without reference to a document (MI09)
- Entering the count and posting differences in one step (MI08)
- Creating a physical inventory document, entering the count, and posting differences in one step (MI10)
- Changing the physical inventory count (MI05)

Physical inventory with serial numbers is carried out for all materials that require serial numbers.
Inspection lot comparison (stock type 2) with serial numbers is not supported.

Account Activity During Posting of Inventory Differences

The account activity during posting of the inventory differences depends on which stock was inventoried:
- company’s own stock
- consignment stock from vendor

Inventory Differences in Company’s Own Stock

When you post inventory differences, the material master record is changed, total stock is automatically adjusted to the counted quantity. From the accounting point of view, this corresponds to a goods receipt or goods issue, meaning that when the inventory difference is posted, the stock account is debited or credited:
- If the counted quantity is smaller than the book inventory balance, the stock account is credited with the following value, inventory difference x price. The offsetting entry is made in the "Expense from physical inventory" account.
- If the counted quantity is greater than the book inventory balance, the stock account is debited with the value of the inventory difference x price. The offsetting entry is made to the "Income from physical inventory" account.
Since the amount posted is calculated on the basis of the current standard or moving average price, posting inventory differences does not lead to a price change.

Cycle Counting Method of Physical Inventory

Cycle counting is a method of physical inventory whereby inventory is counted at regular intervals within a fiscal year. These intervals depend on the cycle counting indicator set for the material.
Cycle Counting allows you to count fast-moving items more frequently than slow-moving items, for example.
Mark all materials that are to be included in cycle counting with a cycle counting indicator in the material master record (storage data). The cycle counting indicator is used to group the materials together into various cycle counting categories (for example, A , B , C, and D). In Customizing for Inventory Management, you can define for each category the time intervals at which the materials are to be counted.
You can use the program ABC Cycle Counting Analysis to perform an analysis. In this analysis, the system assigns the materials to the individual categories according to consumption or requirements. You can also specify whether this analysis is to consider only the materials with cycle counting indicator or all materials. The cycle counting indicator in the material master records can be updated automatically by this program.
For the planning of cycle counting, run the program Create physical inventory documents for cycle counting. This program checks all cycle counting materials to determine whether a physical inventory is due to be carried out.