Physical inventroy

[Former Member]

Hi All,

Iis it possible to create LSMW for physical inventroy since the materials are in thousand. Also let me know is there any single transaction for same and any alternative fastest method.

Thks

[Former Member]

You can use batch inputs, below are the revelent physical inventory t-codes

MI00 Physical Inventory)

MI01 Create Physical Inventory Document

MI02 Change Physical Inventory Document

MI03 Display Physical Inventory Document

MI04 Enter Inventory Count with Document

MI05 Change Inventory Count

MI06 Display Inventory Count

MI07 Process List of Differences

MI08 Create List of Differences with Doc

MI09 Enter Inventory Count without Document

MI10 Create List of Differences without Document

MI11 Recount Physical Inventory Document

MI12 Display changes

MI20 Print List of Differences

MI21 Print physical inventory document

MI22 Display Phys Inv Docs f Material

MI23 Disp Phys Inv Data for Material

MI24 Physical Inventory List

MI31 Batch Input: Create Phys Inv Document

MI32 Batch Input: Block Material

MI33 Batch Input: Freeze Book Inv Balance

MI34 Batch Input: Enter Count

MI35 Batch Input: Post Zero Stock Balance

MI37 Batch Input: Post Differences

MI38 Batch Input: Count and Differences

MI39 Batch Input: Document and Count

MI40 Batch Input: Document; Count and Diff

And Yes, you can use LSMW/ BDC as well if you want.

Edited by: m_n_novice on Sep 2, 2009 12:26 PM

[Former Member]

Hi Priyanka, M_N,

Please let me know how to process these batch sesstion. Please give me your valuable inputs.

[Former Member]

RB :

Batch Input is A sequence of transactions supplied with user data by a program. The SAP System stores these transactions in a stack until you decide to process them online. No database updates are performed until the session has been processed. Using this technique, you can transfer large amounts of data to the SAP System in a short time.

About MI31 :

When it checks the physical inventory indicator, the system checks for each material whether the last physical inventory took place in the current period or in a previous period. If the last physical inventory has not been carried out in the current period, the system includes the material in the output list.

On the initial screen, you can hide selection criteria (selection by stock and stock type and selection by grouping criteria) via pushbuttons if you do not have to change the standard settings.

From the initial screen, you can create batch input sessions and physical inventory documents directly for the selected materials without having to display the output list.

In the output list, you can select the materials for which you want to create a batch input session or physical inventory documents directly. You can display and process the created batch input sessions from the output list. In an overview list, you can display the physical inventory documents you have created.

Rest please give some time to explore and try various options available to suit your requirement

[JL23]

how do you physically perfrom the count?

Usually physical counts last much longer than entering the count to SAP.

For an upload with any function, you have to have the count entered into a computer readable file.

Entering into Excel will not be quicker than entering into SAP directly.

So the question is still: how do you count?

[former_member581212]

hi,

Please check the link it may be usefull for you...

http://help.sap.com/erp2005_ehp_04/helpdata/EN/a7/d78498b2c311d3b7cc0000e82de955/frameset.htm

Regards

Priyanka.P

[former_member581212]

hi,

SAP has already provided the BATCH PI doc generation facility via Tcodes...

MI37/38/39/40...

These are session transactions...

Regards

Priyanka.P

[Former Member]

Hi,

Physical Inventory:

Physical Inventory is a business process in which physical stock is matched with book (system) stock. It is legal requirement to carry out physical inventory at least once in a year.

Physical inventory can be carried out both for a companyu2019s own stock (Unrestricted, Quality, Blocked Stock) and for special stocks (Customer Consignment stock, Vendor consignment stock from vendor, Returnable packaging). This inventory is carried out saperately for both type of stocks.

Physical Inventory Processes:

Several inventory processes available for physical inventory which includes as follow:

1. Periodic Physical Inventory

o All stocks of the company are physically counted on the balance sheet key date

o Every material must be counted

o Entire warehouse must be blocked for material movements during count.

2. Continuous Physical Inventory

o Stocks are counted continuously during the entire fiscal year.

o It is important to ensure that every material is physically counted at least once during the year.

3. Cycle Counting

o In this method of physical inventory, inventory is counted at regular intervals within a fiscal year.

o These intervals (or cycles) depend on the cycle counting indicator set for the material in Material Master record as CC indicator in plant view data.

o With this Cycle Counting Method of Physical Inventory allows fast-moving items to be counted more frequently than slow-moving items.

4. Inventory Sampling

o Randomly selected stocks of the company are physically counted on the balance sheet key date.

o If found not much variance between the counted stock and the book book stock, it is presumed that the book inventory balances for the other stocks are correct.

Physical Inventory Process Cycle Flow

1. Creation of physical inventory document

- Physical inventory document(s) is created individually or using the batch program, click for more information

- The transaction codes for creation physical inventory are as follow

• Individual Inventory documentation creation

MI01 - Individual physical inventory creation

MIS1 - Inventory Sampling document creation

MICN - Cycle count inventory document creation

• Collective Inventory document creation

MI31 - Own stock without special stock

MIK1 - Vendor consignment

MIQ1 - Project stock

MIM1 - Returnable Transpiration material

MIW1 - Customer Consignment stock

MIV1 - Returnable material with customer

MIO1 - Material provided to Vendor (Subcontracting material)

2. Print physical inventory document

- Physical Inventory document can be printed based on the physical inventory document status and or item status

- Transaction code MI21 is used to print the inventory document where print default value can be populated

3. Count the physical stock

- Based on the inventory document printout, the warehouse person will check the stock of material physically and note that on print out. This is completely physical process.

4. Enter count in system

- On completion of physical count, the count result is needs to be entered in the system. This can be with reference (using Tcode MI04) or without reference (using Tcode MI04) to the physical inventory document.

- If count quantity for that material is ZERO then select ZC (zero count) column instead of putting 0 in qty field. If 0 is used for zero count then systm will consider that as "not counted"

5. Analyze difference

- Once count is posted in the system, difference analysis can be carried out using transaction MI20

- The output gives information based on the input criteria i.e. physical inventory document, plant, material etc.

- The output gives information about the book quantity, Counted quantity, difference in quantity and value.

- From this output list, you can carry out further process ie initiate recount, change count quantity, post difference

6. Initiate recount and follow the steps 3,4,5

- If found unacceptable difference, recount is initiated using directly from difference analysis list (transaction code MI20) or using transaction code MI11.

- New inventory document will be created for selected items or for entire document

- The original document items will be deactivated once recount is initiated so original document will not be available for further process.

- On initiating recount, you need to process same as for new count document.

7. Post the difference

- Several options are available for posting difference

- Post difference after count is posted using transaction code MI07

- Posting the count and inventory differences using transaction code MI08, here you have created physical inventory but not counted so with this you can count and post difference in sinle step.

- Entering the count without a document reference using trasnaction code MI10, with this you can create inventory document, enter the count and post difference in single step.

some more points for posting difference

- Posting period must be open to post inventory difference.

- The fiscal year is set by specifying a planned count date when creating a physical inventory document.

- Tolerence to crear difference per user group can be set in customization.

- The system will generate material document for the difference qty and post the value to appropriate account (for valuated stock)

- The movement type in material document will be 701 or 702 based on gain or loss of material.

Serial Numbers in Physical Inventory

If material is managed with serial number then it is possible to carry out physical inventory for material with serial number. There are some pre-requisite before you carry out physical inventory for serialized materials.

- Serial number profile must be maintained in the material master.

- the serialization procedure MMSL (maintaining goods receipt and goods issue documents) has to be assigned to serial number profile.

- The stock check indicator in the serial number profile should be configured.

- Maintain basic settings for the serial numbers in customization for Serial Number Profile.

- Configure serial number management for physical inventory in the Settings for Physical Inventory step in Customizing for Inventory Management.

Blocked Stock Returns are the stock which is return stock from Customer or the stock which can be return back to vendor. To restrict the usage of this stock mostly business do transfer posting for this mateial as BLOCKED stock

Rajesh