cancel
Showing results for 
Search instead for 
Did you mean: 

How to count Physical inventory by MI34 ?

Former Member
0 Kudos

Hi,

I have created Physical inventory document by MI31. Now I want count it by MI34. In MI34 i got default logical file name 'MMIM_PHYSICAL_INVENTORY_DOCUMENTS', after executing with tick on Issue log and Test data i got warning 'Sequential file phyinv34_38 overwritten with test data'.

Can anybody tell me in details how to process for mass physical inventory counting by MI34? I have gone through all threads of SDN but there is no step by step and detailed info available .

Thanks,

Pradeep

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Pradeep,

Pls find below the steps.

Mi31 - Create Physical inv doc (w/o special stk-vendors)

Points to be taken note:

1. If you select " Generate batch Input" - no P I doc will be created

2. If you select "create dcmt's directly" P I doc will be created depends on the input you have provided

3. "max no of items/ Doc will decide the no of item lines in the doc (inclusive of different batches)

4. Acc to STCK > select Only materials w/o zero stock

5. Select stock type either QI or UNrest or BLKD

6. Select "include materials subj to PI & Batches subject to PI. This means that the materials & batches that are already subj to PI will be included.

7. Select FReeze or Posting blk depends upon ur need ( Posting block will restrict any transaction for the materials & batches taht are in the PI doc)

Mi34 / Mi04 - Where you can enter the actual physical count for the above created PI doc.

Mi07 / Mi37- Where you post the counted physical inv doc

other Useful t-codes

Mi21 - Print P I doc

Mi24 - Physical inv list- ** using this t-code you can enter inv count, change inv count & post inv count **

Mi20 - will give you the list of differences

Mi02 - where you can delete the created PI doc

Once the doc is posted you will not be able to retrieve back.

Mvt types -

701- Postive PI ( Un res stk)

702 - Negative PI(un res stk)

703 - Postive PI ( QI stk)

704 - Negative PI (QI stk)

707 - Postive PI ( Blk stk)

708 - Negative PI ( Blk stk)

regards,

S.S.Kumar

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks for information

Former Member
0 Kudos

Hi All

I'm wondering how to use the transaction MI05 as a batch input, for example MI04 --- MI34, I tried to use MI34, I changed the value of the field TCODE (MI04 -> MI05) of the structure biseg ( txt file), but without success.

thanx for advance

Efrain

JL23
Active Contributor
0 Kudos

Compare MI04 with MI05 online, then you should see that these 2 transaction are quite different and serving different purposes.

MI04 is for entering a count, MI05 is to change an existing count.

Thats like MM02 and MM01. you cannot do MM02 for a material that does not exist.

Former Member
0 Kudos

Exactly, that I want to do is a batch input of the MI05 ( Exist a transaction for that ¿?), i know that is a recount process, I have a several PI documents I try to modified them in a batch input process... I created them with the MI34 tRX.

Thanx in advance..

JL23
Active Contributor
0 Kudos

If you want recount, then create a recount document and then you can use MI34 to post the count.

MI05 is changing a count, this is not a mass transaction that needs to be done by batch input. Its purpose is to correct a single entry error, to correct a typo of a user.

Former Member
0 Kudos

null

Edited by: senthil kumar on Aug 4, 2009 6:28 PM

Edited by: senthil kumar on Aug 4, 2009 6:28 PM

Former Member
0 Kudos

Hi,

See if this helps

1. What I did was to create a text file phyinv34_38.txt (fixed width) with a structure following table BISEG -- (i used microsoft access for this).

2. In transaction FILE for logical file MMIM_PHYSICAL_INVENTORY_DOCUMENTS, i made data format DAT and changed physical file to phyinv34_38.txt and assigned logical path LOCAL_TEMPORARY_FILES

3. I had basis place my text file (From step 1) in the server's C:\temp drive

4. mi34

Regards,

Ankush

Former Member
0 Kudos

Follow the steps below

MI31 - Step 1A - Create Inventory Count Sheets - Warehouse Stock

MIO1 - Step 1B - Create Inventory Count Sheets - Stock Provided to Vendor.

MI21 - Step 2 - Print Inventory Count Sheets

MI04 - Step 3A - Enter Inventory Counts

MI05 - Step 3B - Change Inventory Counts

MI20 - Step 4 - List Inventory Differences

MI07 - Step 5 - Post Inventory Results