Example:The Master Job Bid Item Status Report shows all ordered materials, both lot item and stock, and identifies whether they have shipped to the customer. Lot item materials are shown at the same level as non-lot items, and are sorted by their Tag Type and SubType.
To run the Master Job Bid Item Status Report:
From the Orders > Queues menu, select Master Job Bid Review Queue to display the Master Job Bid Review Queue screen.
This screen is also available from the Maintenance > Job Bid menu.
Note: If prompted, log on to the character-based system.
Position the cursor on the MJB for which to run the report and use the Item Report hot key to display the Master Job Bid Item Status Report screen.
Note: You can also access this report from the Files > Job Bid menu by selecting Master Job Bid Item Status Report.
In the Master Job Bid field, enter the master job bid's sales order ID number, if needed.
If you are running the report from the Master Job Bid Review Queue screen, the system populates this field with the sales order number for the MJB you selected in step 3.
In the Internal/External field, select one of the following values:
External – Shows the quantity of the item (lot item material or stock item) ordered on the master job bid, the quantity invoiced to date, and the amount yet to be invoiced.
Internal – In addition to the information in the External version, shows the sum of the ordered quantity of the item on the junior order, and the difference between the ordered quantity on the master job bid and the quantity on the junior order. It also shows the links between items on the master job bid and those same items on the junior orders.
Each item on the master job bid is given an "address", such as .1.1., which follows the master job bid order number. The item with that identifier may be distributed among several junior orders, but you can find it by looking for the .1.1 following the junior order number. Lot item materials are identified with two numbers, the first being the lot item and the second being the material on that lot item. Stock items are identified with one number only.
The Master Job Bid Item Status Report shows the following information:
Column | Description |
Description | The lot item material or stock item ordered. Lot item materials are identified with an asterisk (*). |
Tag Type | A user-defined code that identifies the group to which the product belongs. |
SubType | A user-defined code that identifies the type of item within the Tag Type. |
Vendor | The company which either shipped or will ship the product to the customer. *STOCK* identifies items that will ship from your warehouse, *NOT ASSIGNED* identifies items that have a status of Bid, and *N/A* identifies any items that have not been launched from the master job bid to a junior order. |
Ord Qty | The quantity of the item ordered on the master job bid. |
InvQtys | The quantity of the item invoiced on the junior order, which identifies what has been delivered to date. |
ToInv | The amount yet to be invoiced. |
JrQtys* | The sum of the ordered quantity on all of the junior orders for the selected item. |
RemQtys* | The difference between the quantity in the Ord Qty field and the JrQtys field. |
Juniors | Identifies the junior order on which the item exists. In the internal version, also includes the item's "address". See explanation in step 4 above. |
Master Order* | Identifies the master job bid "address" for the item. See explanation in step 4 above. |
* Internal version only