This chapter contains these topics:
When you review performance information for an item, you can review the current quantities for items in your inventory, previous sales activity, and open purchase orders. This information is useful in helping you to plan for your inventory needs.
See Also:
Locating Quantity Information for the types of quantity calculations that the system can perform
From Inventory Management (G41), choose Inventory Inquiries
From Inventory Inquiries (G41112), choose Buyer's Information
You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Choose Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).
You can review item and quantity information to plan for your current and future inventory needs.
To review inventory quantities
On Buyer's Information
Complete the following fields:
Item Number
Brn/Plt
Input U/M
Press Enter.
Review the following fields:
Day/Avail
On Hand
Comm
Avail
Avail/Rec (Available on Receipt)
On PO Reor Pt
EOQ (Quantity-Economic Order)
Cumulative Sales-This Yr
Field | Explanation |
---|---|
Input U/M | A user-defined code (system 00/type UM) that identifies the unit of measure in which you usually purchase the item.
Form-specific information If you leave this field blank, the system uses the purchasing unit of measure. |
Day/Avail | A number that indicates how many days of inventory are available. This number of days is calculated by dividing the total number of units sold during the previous two months by the number of working days in a two-month period (43.5). The system divides the number of days by the current quantity available.
Example: Current Period is 11 Period 9 (150 sales) + Period 10 (140 sales) = 290 cumulative sales for two periods Divide by 43.5 Average working days within two months = 6.6666667 Quantity Available = 610 Divide by 6.6666667 Days Available = 91.5 |
On Hand | The number of units that are physically in stock. The quantity on-hand displays in the primary unit of measure.
Form-specific information The total number of items (counted in the primary unit of measure) that are stored in both the primary and secondary locations of a particular cost center. This information is stored in the Item Location Information table (F41021). The total number of items (counted in the primary unit of measure) that are stored in both the primary and secondary locations of a particular cost center. This information is stored in the Item Location Information table (F41021). |
On PO | The number of units specified on the purchase order, in primary units of measure.
Form-specific information The system retrieves this number from the Item Location table (F41021) for the primary and all secondary locations of the item in the specified branch/plant. |
Avail/Rec | The number of units that are currently available (in the primary unit of measure) plus the quantity on purchase or work orders. |
Reor Pt | A quantity for an item that specifies when replenishment occurs. Typically, this occurs when the total quantity on-hand plus the quantity on order equal or do not meet a specified quantity. You can enter this quantity or the system can calculate it if there is sufficient sales history.
If there is no safety stock quantity defined, the system first calculates the safety stock by multiplying the square root of the average leadtime quantity. Then, the system adds the calculated safety stock quantity to the average leadtime quantity to determine the reorder point. |
EOQ | A fixed order quantity for an item that the system calculates to minimize the combined costs of acquiring and carrying inventory. The system calculates this number based on an economic analysis of the cost of placing an order and carrying the inventory. |
From Inventory Management (G41), choose Inventory Inquiries
From Inventory Inquiries (G41112), choose Buyer's Information
You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Choose Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).
You can use sales history information to determine previous and projected sales. For example, you can review the cumulative sales to date and the projected sales for the remainder of the year. You can also compare item sales for different fiscal periods.
On Buyer's Information
Complete the following fields:
Item Number
Brn/Plt
Input U/M
Press Enter.
Review the following fields:
ABC RK (ABC Ranking)
Per End
Cumulative Sales-This Yr
Cumulative Sales-Last Yr
12 PD (Quantity Projected-Total)
Trd (Trend Percent)
Reor Pt
Lst Cst
Avg Cst
Lst Rec
Field | Explanation |
---|---|
ABC Rk | A grade that indicates the level of sales activity for a customer or inventory item. This code documents the 80/20 principle (80% of the significant results is attributable to 20% of the business effort). The possible grades are A (best) to F (worst). |
Cumulative Sales | The number of units, in primary units of measure, that you sold during a prior month. The system maintains the units history for a period of twenty-five months. |
12PD> | The total projected sales quantity for the next 12 months, i.e., the current month and the next 11 months.
Note: The Buyer's Inquiry (V41150) itemizes projections for only the current month and the next nine months. Projections are designated by the symbol > next to the name of the month. The total projected sales quantity for the current month and the next 11 months, for a total of 12 months. |
From Inventory Management (G41), choose Inventory Inquiries
From Inventory Inquiries (G41112), choose Buyer's Information
You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Select Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).
If your Inventory Management system is set up to work in conjunction with the Procurement system, you can review all of the open purchase orders that meet the following criteria:
Do not have an open quantity that is equal to zero
Do not have a next status that is below 900
To review open purchase orders
On Buyer's Information
Complete the following fields:
Item Number
Brn/Plt
Input U/M
Press Enter.
Review the following fields:
Type
Number
Line
Supplier Name
Quantity
Date