xTuple ERP Reference Guide

Enter the item number of the item whose inventory availability you want to display.

Inventory unit of measure (UOM).

Show availability using one of the following criteria:

Display lists inventory availability by item, using the specified parameters. If planned availability displays in the color orange, this means the actual or projected quantity on hand (QOH) is at or below the reorder level. If the color is red, the current or projected QOH is below zero.

Specify site whose running availability you want to display.

Select to show planned orders in the display. Planned orders will display in blue type.

Quantity available immediately to satisfy work order and sales order demand.

Quantity that is allowed to be used for inventory planning purposes (i.e., MRP).

Displays the reorder level, which specifies the minimum QOH allowed before an item must be reordered. The reorder level is maintained in the Item Site master.

Indicates the quantity level that MRP planned replenishment orders will order up to.

Displays the order multiple, which specifies the increments the item must be ordered in. The order multiple is maintained in the Item Site master.

Display lists running availability for the selected item, using the specified parameters. Red lettering indicates the due date has passed or running availability has dropped below zero. The color orange means the actual or projected QOH is at or below the reorder level.

Select to display detailed location/lot/serial number information for all sites.

Specify site whose detailed location/lot/serial number information you want to display.

Display lists location/lot/serial number detail, using the specified parameters. Items will display in red type if the quantity in question has expired.

Select to display inventory availability for all sites.

Specify site whose inventory availability you want to display.

Select if you want to view all purchase orders for the item.

Select if you only want to view purchase orders with open items.

Select if you only want to view purchase orders with closed items.

Select if you do not want to filter on purchasing agents.

Select if you only want to see purchase orders for a single purchasing agent. You will then need to select an agent from the drop-down menu.

Display lists purchase orders for the item according to the selected criteria.

Enter the earliest order date you want to include in the report. By default, the starting order date will be -30 days from the current date.

Enter the latest order date you want to include in the report.

Display lists sales orders for the item according to the selected date range.

Enter the earliest quote date you want to include in the report.

Enter the latest quote date you want to include in the report.

Select to include quotes that have been converted to sales orders.

Display lists quotes for the item according to the specified selections.

Enter the customer number of the customer whose item prices you want to view. The lookup feature located to the right of the field leads to a searchable customers list. You may also access this list using the keyboard shortcut CTRL + L. Once a customer number is entered, the customer name and billing address will display. Click on the magnifying glass or $ symbol and select Open to view customer information for the specified customer. If a customer's credit is good, the button will feature a black question mark (?) icon. If the customer is on credit warning, the icon will turn into an orange dollar sign ($). A red dollar sign ($) indicates the customer is on credit hold.

Select to display expired prices.

Select to display future prices.

Select to show costs and margins using one of the following costing parameters:

Display lists item prices for the specified customer. Cost and margin columns will also appear if the Show Costs and Margins parameter is selected. If the margin is negative, the value will display in red type.

Refine your search using the available filter options.

Display lists inventory history by item, using the specified parameters.

Select to display inventory availability for all sites.

Specify site whose inventory availability you want to display.

Select to view all purchase orders for the item.

Select to include all purchasing agents in the display.

Select if you only want to see purchase orders for a single purchasing agent.

Specify the purchasing agent. This option will not be available if the All Purchasing Agents option is selected.

Enter the earliest date for which you want to see receiving history.

Enter the latest date for which you want to see receiving history.

Display lists receiving history for the item according to the selected date range.

If revision control is enabled at your site, specify the BOM revision number you want to view. If none exists, simply enter a value to create one. The status of the revision will also be displayed. The following statuses apply to revisions:

Select to cause expired components to be listed in the Bill of Materials display.

Select to cause future components to be listed in the Bill of Materials display.

Display lists single level BOM components, using the specified parameters.

Enter the revision number for the costed indented BOM you want to display. The status (active or inactive) will be displayed beneath the revision number.

Select to display standard costs for component items in the specified item's BOM. Both the unit cost and extended cost for each component item, expressed in terms of standard cost, will be displayed—assuming standard costs have been defined for each component item.

Select to display actual costs for component items in the specified item's BOM. Both the unit cost and extended cost for each component item, expressed in terms of actual cost, will be displayed—assuming actual costs have been defined for each component item.

Display lists costed indented BOM components, using the specified parameters. The difference between the indented view and the single level view is that the indented view displays all subcomponents if there is a manufactured component listed on the BOM. Actual cost and standard cost will be calculated automatically at the bottom of the display.

Enter the effective date.

Display lists single level BOM components, using the effective date specified.

Displays sales volume for the item by month.