Stock Data Of Serial Number Not Suitable For Movement Sap
Posted : admin On 15.01.2020I'm trying to figure out how to perform the task in object.I want to get serial numbers from range A (internal) when i perform GR (101, 501) in storage location X. After quality checks, materials are transfered to storage location B via 311. After the 311 movement i want to change serials and get the new ones from another range (external)I already defined ranges and i'm already posting GR with serials from range A.
- Stock Data Of Serial Number Not Suitable For Movement Sapphire
- Stock Data Of Serial Number Not Suitable For Movement Message No. Io231
I have to figure out how to tell to SAP to get serials from the second range after posting the 311.Thank you very much for your advice. Serial numbers are assigned in popup dialog during goods movement, otherwise you should go to special dialog Goto-Serial Number.
PurposeThe purpose of this page is to present the main steps of Physical Inventory Process, also highlighting Tables, Transactions, Customizing Settings and Examples. General. 1.1 Description. 1.2 Physical Inventory Processes.
1.3 Tables and PI Indicators. 1.4 Warehouse Management. 2. Main Physical Inventory.
2.1 Online transactions. 2.1.1 Create physical inventory document (MI01). 2.1.2 Entering the Physical Inventory Count (MI04). 2.1.3 Post inventory differences (MI07).
2.1.4 Change and delete PI documents (MI02). 2.1.4.1 Changing PI documents. 2.1.4.2 Delete PI document. 2.1.5 Others. 2.1.6 Customizing.
Stock Data Of Serial Number Not Suitable For Movement Sapphire
2.2 Batch-Input. 2.2.1 General.
2.3 PI reporting. 2.4 PI archiving. 2.5 Others. 3. Cycle Counting. 3.1 General Procedure.
3.1.1 General Steps Required for Cycle Counting. 3.2 RMCBIN00 (transaction MIBC): ABC Analysis for Cycle Counting. 3.3 RM07ICN1 (transaction MICN): Batch Input 'Create Phys. Inventory sampling. 4.1 Inventory sampling processes. 4.1.1 Select stock management level. 4.1.2 Stock population.
4.1.3 Stratification. 4.1.4 Random selection. 4.1.5 Creation of PI documents. 4.1.6 Update. 4.1.7 Extrapolation. 4.2 Example.
4.3 Notes. 5. Physical Inventory - Special features. 5.1 Serial Numbers1. GeneralThe Physical Inventory (PI) as a whole is divided into three parts, from which one includes the main PI process, another is the cycle-counting process and the third is the inventory sampling process. The cycle-counting and the inventory sampling processes are only special ways to create PI documents, afterwards the main PI processes are used.
1.1 DescriptionEvery company must carry out a physical inventory of its warehouse stocks at least once per fiscal year to balance its inventory. Various procedures can be implemented for this.The SAP System supports the following physical inventory procedures:. periodic inventory: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. continuous inventory:With 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: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. inventory sampling:In 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.A PI document can only be created for the current FI year and for the previous FI year. The criterion in which FI year the PI document will be created depends on the (planned) count date. Please note, that as with a usual material posting, the PI difference for the previous FI year can only be posted until the first period of the new FI year. 1.2 Physical Inventory Processes. Create physical inventory document. Entering the Physical Inventory Count. Recount.
Post inventory differences1.3 Tables and PI indicatorsThe related database tables for the PI documents are. SPERRPhysical inventory blocking indicator:' 'No physical inventory defined for material'X'Due to phys. Inv., material is blocked for movements'A'Physical inventory not yet completed for material- No physical inventory possible, if SPERR = 'X' or 'A'.KZILLPhysical inventory indicator for whse stock in current yearKZILQPhys. Inventory ind.
Stock in qual. In current yearKZILEPhysical inventory indicator for restricted-use stockKZILSPhysical inventory indicator for blocked stockKZVLLPhysical inventory indicator for stock in previous yearKZVLQPhys. Inventory ind. Stock in qual. PeriodKZVLEPhysical inventory ind. For restricted-use stock, prev.pdKZVLSPhys.
Inventory indicator for blocked stock in prev. Period.DLINLDate of last physical inventory for unrestricted-use stock.MDJINFiscal year of current physical inventory indicatorFor all these fields:If the physical inventory still has to be taken in the current year:. Physical inventory still has to be taken:. Physical inventory still has to be completed: X. Posting block is set in active document: X If the physical inv. Has already been taken in the current year:.
Physical inventory has been taken: X. Physical inventory is active again: X X. Posting block is set in active document: X X X- No physical inventory possible, if ' X' 'XX' 'XX' or 'XXX' 1.3 Warehouse ManagementThe PI process in the warehouse management is totally different from the PI process in materials management. Also a MM PI document can not be created for a storage location for which one the warehouse management is active.With transaction LI21 (Clearing of differences in inventory management), the PI differences in warehouse management will be posted with our function 'MBCREATEGOODSMOVEMENT' (before release 4.5 with call transaction MB11). The movement types 711 - 718 will be used to post the differences.In the customizing for the movement types (table T156-XINVB) you can set an indicator, that during the posting an PI document will be created in the background.Attention: This indicator will only work for the movement types 711-718 and should not be used for other movement types. Main Physical InventoryThe main PI can also be divided into. the online transactions to create and process PI documents.
the batch-input transactions to create PI documents. the PI reporting2.1 Online transactions. MI08Post Count and differences (MI04 + MI07)MI09Enter count without reference to a document (MI01 + MI04)MI10Post document, Count and Differences(MI01 + MI04 + MI07)MI11Recount2.1.1 Create physical inventory document (MI01). Physical inventory can be carried out both for a company's own stock and for special stock. Inventory for a company's stock and for special stocks (such as, consignment stock at customer, external consignment stock from vendor or returnable packaging) must be taken separately (in different physical inventory documents). Physical inventory takes place at storage location level.
A separate physical inventory document is created for every storage location. If no storage location segment exists for a material, this means that no goods movement has ever taken place for the material in the storage location. The material, therefore, has never had any stock at the storage location and does not exist at stock management level in the storage location. It is therefore not possible to carry out a physical inventory for the material in this storage location.
A material for which a goods movement has taken place and for which the stock balance is currently zero. A physical inventory must be carried out in this case. Posting block: Indicates that no goods movements involving the materials listed in the physical inventory document can be posted until the count results are posted. Freeze book inventory: This indicator has the effect that the current book inventory balance is recorded in the physical inventory document. The system compares the counted stock with the frozen book inventory balance to determine any inventory differences. The program reads the actual warehouse stock (table MARD, MCHB, MSKU.) and writes this in ISEG-BUCHM.
a physical inventory can be carried out for the following stock types:. 1 unrestricted-use stock in the warehouse. 2 quality inspection stock. 4 blocked stockIf you want to create a physical inventory document for a material, the system checks the PI indicators. Example: Physical inventory for a (non batch management) material - system analysis storage location data in table MARD.
No physical inventory possible, if ' X' 'XX' 'XX' or 'XXX'. 2.1.2 Entering the Physical Inventory Count (MI04)You have to enter the count results for each item in a physical inventory document. The posting block is automatically cancelled when you post the counting results for the physical inventory document. If there was no 'Freeze book inventory' before, the system calculates the current book quantity and updates ISEG-BUCHM with this quantity. Physical inventory difference = ISEG-MENGE - ISEG-BUCHM. Physical inventory indicator will be updated: Example: Create a physical inventory document MARD-SPERR = 'X' MARD-KZILL = 'XX' Count the material: MARD-SPERR = 'A' MARD-KZILL = ' X'.
After entering the count results: You are able to post goods movements for this material. (no posting block)Determination of the PI difference - note 202834 Determ. Of book quantity within physical inventory 2.1.3 Post inventory differences (MI07).
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. Movement types in material document:701: GR phys.inv.: unrestricted stock ( stock type 1) (positive phys.inv. For unrestricted stock) 702: GI phys.inv.: unrestricted stock ( stock type 1) (negative phys.inv. For unrestricted stock) 703: GR phys.inv.: quality insp. ( stock type 2) (positive phys.inv. For quality insp.) 704: GI phys.inv.: quality insp.
( stock type 2) (negative phys.inv. For quality insp.) 707: GR phys.inv.: blocked stock ( stock type 4)(positive phys.inv. For blocked stock) 708: GI phys.inv.: blocked stock ( stock type 4)(negative phys.inv. MI08Post Count and differences(MI04 + MI07)MI09Enter count without reference to a document(MI01 + MI04)MI10Post document, Count and Differences(MI01 + MI04 + MI07)instead of MI01, MI04 and MI07. 2.1.6 CustomizingTransaction SPRO: Materials Management Inventory Management and Physical Inventory- Physical Inventory:.
Field selection for physical inventory: Field ISEG-GRUND (Reason for inventory diff.) can be changed to: Input, required, display, hide, highlighted. Default values for physical inventory: Default values (at plant level) for stock type, batch in background, alternative unit of measure, reason for difference. Settings for physical inventory. Activate 'Change document'. Adjust book inv. Balance. When the indicator 'Adjust book inventory balance' is set, the system checks whether the goods movement would have affected the book inventory balance if the goods movement had been posted earlier.
If this is the case, the book inventory balance in the physical inventory document and the inventory difference are adjusted by the amount of the goods movement. Example: Material XYZ, plant 1000, storage location 0001. 1. Receive or Issue quantity to maintain a balance of 1000 PCs. 2. Transaction MI01 - Create a physical inventory document with 'Freeze' book inventory.
3. Transaction MI04 - Enter a 'Count' quantity of 80 PCs. 4. Transaction MI03 - Display the item details - You should see 920 PCs (Diff.
Quantity) = 1000 PCs (Book quantity) - 80 PCs (Count quantity). 5. Transaction MB1A - Post date = Count date - 2 days, quantity = 900 PCs. You will see message M7 145.
Enter to continue. Post the goods issue. 6.
Transaction MI03 - Display the item details - You should see 20 PCs (Diff. Quantity) = 100 PCs (Book quantity) - 80 PCs (Count quantity) The 'book quantity' was automatically adjusted in the physical inventory document. Serial numbers. Whether existing serial numbers should be displayed as input help in the dialog box for entering serial numbers, when entering an inventory count: Indicator Display serial numbers. Whether, and with how many lines, serial numbers should be printed, when printing physical inventory documents. Indicator Inventory document printout with serial numbers.
How many lines should be printed for serial numbers per physical inventory document item when printing physical inventory documents. Indicator Number of printed serial numbers lines. Default values for batch input. Maintain copy rules for reference documents. You can decide whether the positions in MI07 are pre-selected or not. Allow freezing for book inventory balanced in storage location. Define tolerances for physical inventory differencesInternal tablesDuring debugging you will find information in these tables.
YISEGphysical inventory document segments (for checks)XISEGphysical inventory document segments (filled with data from YISEG. Used to update the physical inv.doc. On database).IKPFphysical inventory headerYDM07IFields: Dialog Control for Module Pool SAPMM07I (physical inventory)YVM07IFields for Update Control of Module Pool SAPMM07I (physical inventory)Breakpoints. MM07IFB0: In form 'belegbuchen' you can set a breakpoint to see how the system will create/update the inventory document and material document.FORM BELEGBUCHEN. IF DIFFERENZ = X.
MI31(Batch Input: Create Physical Inventory Document without Special Stock)MIK1(Batch Input: Create Physical Inventory Documents for Vendor Consignment)MIE1(Batch Input: Create Physical Inventory Documents for Sales Order)MIQ1(Batch Input: Create Physical Inventory Documents for Project)MIM1(Batch Input: Create Physical Inventory Documents for Ret. Pack.)MIW1(Batch Input: Create Physical Inventory Documents for Consignment at Customer)MIV1(Batch Input: Create Physical Inventory Documents for Ret. At Customer)MIO1(Batch Input: Create Physical Inventory Documents for Mat. MI9AAnalyze archived phy. DocsMI9RArchive phys. DocumentsMIADDelete Phys. DocumentsMIALInventory Documents: Read ArchiveMIARArchive Phys.
DocumentsMIAVManage Phys. Archive2.5 OthersAlso PI documents can be handled with BAPI's, please refer to the general documentation for the PI BAPI's (transaction BAPI). Cycle CountingCycle 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. Cycle Counting allows fast-moving items to be counted more frequently than slow-moving items, for example.
Stock Data Of Serial Number Not Suitable For Movement Message No. Io231
3.1 General ProcedureMark 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).
The time intervals at which the materials are counted are defined for each category.You can mark the materials as follows:. manually in the material master record (storage data). automatically using ABC analysisTo perform an ABC analysis, use program RMCBIN00. 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 can be updated automatically while the ABC analysis is run. For the planning of cycle counting, run program RM07ICN1 at regular intervals.
This program checks all cycle counting materials to determine whether a physical inventory is due to be carried out. If a material needs to be counted, use the program to create a batch input session for creating physical inventory documents. 3.1.1 General Steps Required for Cycle Counting.
Marking Materials for Cycle Counting: In the material master record (storage data), maintain the cycle counting indicator for all materials to be included in cycle counting. Physical inventory indicator for cycle counting: MARC-ABCIN Indicates that the given material is subject to the cycle counting method of inventory. CC fixed: MARC-CCFIX.
Specifies that the cycle counting indicator cannot be changed for cycle counting by an ABC analysis.TIP: Both fields are in table MARC (- you set CC on plant level). To display all Materials for CC, you have to use SE16 for table MARC and select all entries with MARC-ABCIN not equal ' '.Customizing (Transaction OMCO): Table T159C.
Define the allowed cycle counting indicators in the plant. Number of physical inventories per fiscal year: At least one physical inventory count per year has to be performed. Float time (workdays): Number of workdays by which the planned count date may vary from current date. Example: for a plant the float time is 5 days. A physical inventory has been planned for a material for June, 1.
On expiration of the float time (after June, 6) the physical inventory has not been carried out. The material will be included in the log in the next cycle counting run. Percentage of performance measure for cycle counting indicator.3.2 RMCBIN00 (transaction MIBC): ABC Analysis for Cycle CountingThe analysis takes into account the consumption (usage) or the requirements values of the selected materials for the desired time period. MIS1Create Inventory Sampling - R/3MIS2Change Inventory SamplingMIS3Display Inventory SamplingMIS4Create Inventory Sampling - R/2MIS5Create Inventory Sampling - Other systemsReport RM07SBTC can be used to process the inventory sampling in the background.Main program: SAPMM07S.The statistical parameters are (default values):Probable degree of certainty 95,00% max. Deviation allowed 2,00% max.
Error allowed 1,00%The SAP Inventory sampling process use the mean-value estimation. 4.1 Inventory sampling processes. Select stock management level.
Stock population. Stratification. Random selection. Creation of PI documents. Update. Extrapolation4.1.1 Select stock management levelIn this step, the stock management levels (plant and storage location or storage number and storage type), for which the inventory sampling will be created are selected.
The table SBSE (Stock Mngmt Levels for Inventory Sampling) will be filled with this information. 4.1.2 Stock population(Form S1LAGERGESAMTHEIT) In this step, the materials or storage bins that are participating in the inventory sampling process will be determined. The table SLGH (Elements of Stock Population) will be filled. 4.1.3 Stratification(Form P2SCHICHTEINTEILUNG) Depending on the value, the participating elements will be sorted into classes and strati. The table SSCH (Strata of Inventory Sampling) will be populated.
4.1.4 Random selection(Form P3ZUFALLSAUSWAHL) With a randomizer, the elements that have to be counted will be determined. These elements will be marked in table SLGH. XSPEL stands for sampling element, XVERR stands for element in the complete count area.
4.1.5 Creation of PI documentsThe PI documents will be created and are processed in the same manner as other PI documents. 4.1.6 Update(Form P4AKTUALISIERUNG) Counted and difference posted PI documents will be detected and stored in table SLGH. Probably subsequent random selection has to be made (P4NACHERHEBUNG). 4.1.7 Extrapolation(Form P5HOCHRECHNUNG and P5GESAMTFEHLERBERECHNEN) With the parameters and the posted PI differences, the systems determines, if the status of the inventory sampling is successful.
4.2 ExampleA simple example for the functionality:There are 10 materials for which you want to perform an inventory sampling. XSPELNew ValueStratus 1:11 -X12263 -X47485 -X4Stratus 2:667788 -X8991010 -X6- Mean value of the random selected materials:Stratus 1 - 3 Stratus 2 - 7 Total - 5The maximal rel. Deviation is 5,5 5 - 9%The inventory sampling is not successful. 4.3 NotesThe SAP inventory sampling process is testified by Arthur Andersen. Important notes describing the functionality of the inventory sampling process are:086111 General note on the inventory sampling procedure 205519 Extrapolation and relative statistical error 216372 Inventory sampling in WM:Special features/document 336896 Certification of the inventory sampling 351013 Stratum to which stock element belongs not clear 5. Physical Inventory - Special features 5.1 Serial numbersFrom Release 4.6A, you can enter serial numbers during physical inventory for materials with serial number requirement, immediately when entering the inventory count. This is possible for the following transactions:.
When entering the inventory count (MI04). When entering the inventory count without reference to a document (MI09). When posting the count and differences in one step (MI08). When creating an inventory document, entering the count and posting differences in one step (MI10). When changing the inventory count (MI05)When you enter or change an inventory count, you can edit the serial numbers entered for each item from the collective processing or overview screen by choosing Edit - Change serial number. Position your cursor on the line number whose serial numbers you want to change.
You can display the serial numbers when displaying a physical inventory document item. To do this, choose Goto - Serial number.Note the following:. It is not possible to first enter the serial numbers and then to derive the counted stock from their number. The inspection lot comparison (stock type 2) with serial numbers is not supported.Serial number inventory is performed for all materials with serial number requirement. Counted serial numbersSerial numbers in ERP stock11423A material document will be created, because a negative physical inventory difference exits (- -1 PC). Moreover serial numbers 2 and 3 have to be unassigned to material 4711, while serial number 4 has to be assigned to material 4711.
ProgramDatabase tables As you saw in the example the system has to save the counted serial numbers and the serial numbers in the R/3-stock. We use table SER07 to save this information: Table SER07 belongs to application 'serial number management'.