on 07-30-2009 7:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for information
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
null
Edited by: senthil kumar on Aug 4, 2009 6:28 PM
Edited by: senthil kumar on Aug 4, 2009 6:28 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.