Collapse AllExpand All

7.7.  Inventory Availability by Customer Type

If sales order reservations are enabled at your site, this screen may be considered a useful workbench for processing sales order reservations. While other screens support this functionality, the inventory availability by customer type report consolidates several useful functions in one location.

To view inventory availability by customer type, go to Sales > Reports > Availability by Customer Type. The following screen will appear:

Inventory Availability by Customer Type

When displaying inventory availability by customer type, you are presented with the following options:

All Customer Types

Select to display inventory availability for all customer types.

Selected

Specify customer type whose inventory availability you want to display.

Pattern

Enter a customer type pattern to select a range of customer types. Refine your search using regular expressions.

Only Show Shortages

Select to only show inventory shortages in display. A shortage describes inventory quantity whose availability is negative.

Only Show Available to Ship

Select to include only inventory that is available to ship.

Use Reservation Netting

Select to show sales order reservations (if any) for the sales order items included in the display. When selected, the This Availability column will dynamically change to This Reservation and the quantity reserved for each sales order item (if any) will be shown. This option will not be visible if Sales Order Reservations are not enabled at your site.

Tip

To manipulate sales order reservations by line item, use the right-click options found on this screen.

Show W/O Supply

Select to include current work orders for the sales order items shown in the display. If current work orders exist, they will appear nested below each relevant sales order item.

Availability

Display lists inventory availability by customer type, using the specified parameters. If an available quantity value 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.

Note

The display features additional color-coding to help easily identify the sales order reservation status of individual orders and also line items. The following color conventions are used:

  • Green (line item level): Line item quantity is fully-reserved.

  • Green (Header level): Sales order has been added to the packing list batch.

  • Blue: Line item quantity is partially-reserved.

  • Black: Line item has no sales order reservations.