Skip to main content

Available to Sell

Available to Sell (ATS) is an indicator that shows how many model serials can be sold right away. You can view a model's ATS in a column on the Serial Inventory Maintenance screen.

ATSSerialMaintenance

Why can't I see the ATS column in Serial Inventory Maintenance?

To view the ATS column in the Serial Inventory Maintenance screen, you need to add the ATS column AND select Show ATS in the Search options area. View Customizing Columns for help with adding the ATS column.

How ATS is Calculated

EPASS calculates ATS based on two key parameters: the Immediate Reserved Days and Immediate Ship.

Immediate Reserved Days

The default Immediate Reserved Days is set in the Invoicing Variables. It represents the average amount of turnaround time (in calendar days) it takes to receive product from your supplier.

ATSInvoiceVar

Immediate Reserved Days can also be entered in other areas, including:

Supplier MaintenanceATSSupplierMaintenance
Brand TableATSBrandTable
Model TableATSModel

If Immediate Reserved Days are entered in any of these areas, they override Invoicing Variables and each other. The order of override is as follows:

ATS_overrides

Example

The Immediate Reserved days on the Invoicing Variables is set to 45 days. This is the default value that the ATS calculation will factor in for all serials.

However, a supplier that is fulfilling an order of dishwashers has an Immediate Reserved Days set to 30 days in the Supplier table. The ATS will use this value instead for those dishwashers fulfilled by this supplier.

Another model of dishwasher that is also available from the same supplier is ordered as well. This model has an Immediate Reserved Days set to 60 days in the Model table. The ATS calculation will now use this amount when factoring the ATS for these dishwashers.

Immediate Ship

Immediate Ship is a setting that can be activated for a Serial Type, Location, or Job Status. If a serial belonging to a Serial Type, in a Location, or on an invoice with Job status that is Immediate Ship, it's included in the ATS calculation.

If Immediate Ship is activated...
Serial TypeThe ATS calculation will include all serial numbers that belong to that serial type code in the ATS calculation.
ATSModel
LocationThe ATS calculation will include all serial numbers within that location but ONLY if the model serial is marked ‘saleable.’ If a model serial is non-saleable (not available) within the same location it's not included in the ATS calculation until it is made saleable (available).
ATSLocation
Job StatusThe ATS calculation will include all serials on invoices with that job status in the count.
ATSJobStatusTable

ATS Formula

The formula to calculate the ATS is:

ATS = (Immediate QOH) - (Immediate Reserved)

Immediate QOH is the total available serials that are not Exclusive Reserved with Serial Type and Location marked as Immediate Ship.

Immediate Reserved is the total Reserved serials (Exclusive Reserved serials are not counted) on open invoices with a Delivery or Pickup date that is within the Immediate Reserved Days range1 AND Job Status marked as Immediate Ship.

Notes
  • Serials with the SOLD, TAKEN, or RETURNED status are not included in the Immediate QOH.
  • The Delivery or Pickup date AND Job Status of an invoice must qualify to have its serials included as part of the Immediate Reserved.
  • Serials on invoices that have a past Delivery or Pickup Date are included in the Immediate Reserved. Serials on invoices with a blank Delivery or Pickup Date are also included.
  • If a model is Active and Obsolete, all serials on invoices regardless of Delivery or Pickup date and Job Status are included in the Immediate Reserved.
  • When a model is Obsolete, all serials of that model on qualifying invoices are subtracted from the Immediate Reserved total. This is intended to prevent overselling the model.
  • If you use Inventory Divisions, EPASS Users will see ATS totals based only on serials within the divisions that they have security access to. For example, a user with access to a single division may see a lower ATS total than one with access to all divisions.
  • 1 Immediate Reserved Date range is ([Current Date] + [Immediate Reserved Days]).
Click to view two examples
Example #1

The QOH of a refrigerator model is 5 serials. The serials have a Serial Type that is marked as Immediate Ship, and the warehouse location is also marked as Immediate Ship. The Immediate Reserved Days that was entered for this model on the Model table is 30 days.

2 serials are reserved to invoices, and 1 is Exclusive Reserved. All the invoices have a pickup date within two weeks.

In this example:

The Immediate QOH is 4 (5 serials - 1 that is Exclusive Reserved)

The Immediate Reserved is 2 (3 serials are reserved - 1 that is Exclusive Reserved.)

The ATS for the fridge is 2

Example #2

The status of the refrigerator serials from Example #1 has changed. In total, 4 serials are reserved to invoices. 2 serials are now Exclusive Reserved. All serials are on invoices that are scheduled for next week's delivery, except for 1 serial that is reserved to an invoice that has a Pickup Date 6 months in the future.

In this example:

The Immediate QOH is 3 (5 serials - 2 that are Exclusive Reserved)

The Immediate Reserved is 1 (4 serials are reserved - 1 serial on an Invoice with a Pickup date outside of the Immediate Reserved days range - 2 that are Exclusive Reserved)

The ATS for the dishwasher is 2

Altering the ATS Calculation

There are three options that alter the ATS calculation.

Using Immediate Unreserved QOH

The default ATS calculation is ATS = (Immediate QOH - Immediate Reserved).

As an alternative, the formula can be simplified by taking the Immediate QOH LESS all serials reserved to an invoice (Immediate Ship and Immediate Reserved Days are ignored.) The total is the Immediate Unreserved QOH.

Click to see an example.
Example

The QOH of a refrigerator model is 5 serials. 1 is Exclusive Reserved to an invoice.

The Immediate QOH is 4.

2 serials are reserved to invoices. The Job Status and the scheduled dates are ignored in the calculation.

The ATS total is 2.

To Enable the Option

  1. Go to Tools > System Maintenance and click the Variables tab.

  2. Click Serial Inventory, and then click Open.

  3. On the General tab near the bottom, select ATS = Immediate Unreserved QOH.

  4. Click OK and restart EPASS.

Using Requested Date Instead of Pickup/Delivery Date

By default, the ATS looks at an invoice's Pickup or Delivery date when determining if serials qualify to be included in the calculation. Optionally, you can have the ATS use the Requested Date instead.

To Enable the Option

  1. Go to Tools > System Maintenance and click the Variables tab.

  2. Click Invoicing, and then click Open.

  3. On the General tab, select Use Requested Date For ATS.

  4. Click OK and restart EPASS.

When calculating the Immediate Reserved, EPASS will count serials on invoices with a qualifying Request Date instead of the Pickup or Delivery date.

Showing ATS as a Negative Amount

By default, the ATS can sometimes calculate and show a negative amount. This occurs when there are a greater amount of serials reserved to invoices than there are on order. To simplify this, you can enable an option that displays all negative values as '0' in the ATS field.

To Enable the Option

  1. Go to Tools > System Maintenance and click the Variables tab.

  2. Click Invoicing, and then click Open.

  3. On the General tab, select Include Negative Qty Reserve for ATS.

  4. Click OK and restart EPASS.

Now when the ATS calculates and there is a negative amount, '0' is displayed in the ATS field instead.

Setting Up ATS

Follow these steps to set up and start using ATS.

  1. Enter the Immediate Reserved Days in Invoicing Variables.

    • Go to Tools > System Maintenance > Variables > Invoicing.

    • On the General tab, enter your average supplier turnaround time (in calendar days) in the Immediate Reserved Days field. This is the default value that the ATS calculation will use.

      ATS_Calculation_2

  2. Enter the Immediate Reserved Days for Suppliers, Brands, and Models.

    • You only have to enter these values if they are different than the default Immediate Reserved Days entered in Invoicing Variables.

    • Suppliers:

      • Go to AP > Supplier > Maintenance.

      • Search for the Supplier and Edit their record.

      • On the General tab, enter the turnaround time for this supplier (in calendar days) in Immediate Reserved Days.

        ATS_Calculation_3

    • Brands:

      • Go to Tools > System Maintenance > Tables > Brand.

      • Select a brand in the list, and then click Edit.

      • On the Settings 1 tab, enter the turnaround time (in calendar days) for this brand in Immediate Reserved Days.

        ATS_Calculation_4

    • Models:

      • Go to Serial Inventory > Maintenance.

      • Search for a model and Edit its record.

      • On the Model tab, enter the turnaround time for this model (in calendar days) in Reserved Days.

        ATS_Calculation_5

        info

        To update a large quantity of models with Immediate Reserved Days, use a Price List Template import.

  3. Activate Immediate Ship for Serial Types, Locations, and Job Statuses.

    • Serial Types:

      • Go to Tools > System Maintenance > Tables > Serial Type.

      • Select a Serial Type from the list, and then click Edit.

      • Select the Immediate Ship checkbox.

        ATS_Calculation_6

    • Locations:

      • Go to Tools > System Maintenance > Tables > Location.

      • Select a Location from the list, and then click Edit.

      • Select the Immediate Ship checkbox.

        ATS_Calculation_7

    • Job Statuses:

      • Go to Tools > System Maintenance > Tables > Job Status.

      • Select a Job Status from the list, and then click Edit.

      • Select the Immediate Ship checkbox.

        ATS_Calculation_8

  4. Add the ATS column to the Serial Inventory Maintenance screen.

    • Refer to Customizing Columns for instructions.

    • Remember to select Show ATS when searching to view the ATS amounts.

      ATS_Calculation_9

See Also

Updated

June 19, 2025