Inventory Plan
This is the quantity of an item at a location. Future inventory is represented in terms of when it will be made available.
Creating an Inventory Plan
| Field | Description |
|---|---|
| Item | The identifier of the material for which the inventory numbers are defined. |
| LotOrderId | This is the identifier that is assigned to a specific manufactured or purchased item in a specific quantity and is used to track that grouping of items. The field identifiers LotOrderId - LotLineId is used to identify lots and subdivisions of lots. |
| LotLineId | This is the identifier that is assigned to a specific manufactured or purchased item in a specific quantity and is used to track that grouping of items. The field identifiers LotOrderId - LotLineId is used to identify lots and subdivisions of lots. |
| LocationId | The identifier of the location from where the inventory is reported. |
| QtyAllocated | The quantity of material that has been allocated to some order. This field cannot be edited. Allocated quantity is automatically generated whenever the inventory is pegged to some demand. |
| QtyAvailable | The on-hand inventory balance minus allocations, reservations, backorders and quantities held for quality problems. This is also called as beginning available balance. |
| AvailableDate | The date when the inventory becomes available. |
| ExpiryDate | The date when inventory is no more usable or reaches its expiry date. |
| SalesOrderId | If an inventory lot order needs to be pegged to specific sales order, then that particular SalesOrderId will be populated here. If the OrderType in SalesOrderLine is "Project" then populating only SalesOrderId is sufficient. |
| SalesLineId | If the OrderType in SalesOrderLine is "Order" then SalesLineId should be populated here. |
Validation
- Item, LotOrderId, LotLineId and LocationId combinations should be unique
Pegging
An inventory is a supply for some demand
Suppose OH feeds WO2, WO2 feeds WO1, WO1 feeds DO and DO feeds SO
In the above example, OH is a supply for WO2 demand. To view this pegging information, do as given below
- Select the lot order whose details are to be viewed.
- Place the mouse over the “Lot Order Id” field and right-click on the mouse.
- This will display an option “Pegged Info”
- Click on the option “Pegged Info”
Pegged info: Displays the demand for the selected lot order. In the above example, it will display the demand it gives to WO2.
Demand WorkOrders: Displays demand WOs details of the selected item.
Issuing Inventory
When the work order is released to the shop floor, the item which goes into this work order are issued. This will result in a decrease in inventory. Both QtyAvailable and QtyAllocated will be decreased by the issued quantity. This information can be entered from the pegged info.
- Get the pegged info
- Click on Edit and enter the QtyIssued and IssueDate
- Click on Save
