Open topic with navigation

Select Inventory Management Reports menu > Inventory Sales History Report.

Use Inventory Sales History Report to list details of the quantity sold, dollars sold, and gross profit percentage for a single year or range of years for up to 13 separate inventory periods. Transactions are posted to inventory based on the accounting date of the source module, including future-period or future-year transactions. The sales history information can be printed by item only, by item with warehouse detail, or by item with customer detail.

When sales kits are exploded during invoice data entry, the following events occur:

• The Inventory Sales History Report will not display a quantity-sold amount for the component items.

• The report will display a quantity-sold amount for the parent item only.

• A sales kit component item is considered to be a quantity issued and will appear on the Inventory Issue History Report.

• The Customer Sales History by Item report will not match the Inventory Sales History Report.

• The Sales Order Customer Sales History Report will match the Inventory Sales History Report.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, warehouses, bin locations, customer numbers, year-to-date dollars sold, user-defined categories (if descriptions have been entered in Inventory Management Options), and user-defined fields (UDFs) to print. You can select to print only items with a change in quantity sold over the last period using the % Change in Qty Sold Prior Period selection. Only the items with a change in quantity sold from the prior period based on the percentage or range of percentages entered are printed.

Note This report prints the item's primary vendor information and does not include other vendors associated with the item.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks