Skip to main content
Skip table of contents

Item Usage (table)

Item Usage is a summary view of item transactions by Inventory Period Type (By Month, or By Week) as defined by Demand Planning Setup.

Field Label

Field Level Help

Adjusted Sales

Sales Qty. - Sales Adj. Qty.
This field is used to calculate the best fit model and sales forecasts.

Best Fit Model

Defaults to the model in this order:

  • Locked Best Fit Model on the SKU.

  • Locked Best Fit Model on the Demand Planning Setup.

  • Calculated Best Fit Model on the Item Usage. 

Calculated Best Fit Model

Calculated by running the Supply Plan Daily Routine.

Daily Sales Qty.

Adjusted Sales / No of Days

Ending Date

The period ending date of the Item Usage record.

ILE Adjustment Qty.

The accumulated total of the Item Ledger Entries where the Document Type = Adjustment. Information-purpose only.

ILE Consumption Qty.

The accumulated total of the Item Ledger Entries where the Document Type = Consumption. Information-purpose only.

ILE Shipment Qty.

The accumulated total of the Item Ledger Entries where the Document Type = Shipment. Information-purpose only. It should be the same as Sales Qty.

ILE Transfer Qty.

The accumulated total of the Item Ledger Entries with the Document Type = Transfer. Information-purpose only.

Item

The Item for this Item Usage record.

No. of Days

The Number of Days between the Starting Date and the Ending Date.

Sales Adj. Qty.

A Roll-up Summary of Item Usage Adjustments.  Adjustment quantities can be entered with reasons for each of the Item Usage Entries to account for abnormal sales activities or exclusions.

Sales Qty.

The accumulated total for all sales shipments, including returns.

Sales Usage Hits

Incremented by 1 for each outbound sales shipment.

Starting Date

The period starting date of the Item Usage record.

Warehouse

The warehouse for this Item Usage record.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.