V9 - Price book


 

Use case

The Price book (Operations > Reports > Sales > Price book) provides pricing information about items, along with the price tier, customer, quantity, and sales price of items sold.

 

While the basics for running any report in SOS Inventory are covered in Reporting introduction and Running a report, the filters, options, and columns specific to the Price book are explained below.

 

Filters

Category. Select All or individual categories. All is the default. Multiple individual categories can be selected. To use this filter, categories must be defined in SOS Inventory.

 

Item name contains. Type all or part of an item name to display matching items.

 

Customer. Choose a desired customer from the dropdown.

 

Price tier. Choose a desired price tier from the dropdown.

 

Options

Header. Enter header text for the report, if desired. The header appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet.

 

Footer. Enter footer text for the report, if desired. The footer appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the footer will appear only if you print your spreadsheet and will show above the system-generated text, Report Generated [date] [timestamp].

 

Columns

The default columns for the Price book are Customer, Price Tier, Item, Quantity, Sales Price, and Description. Thirteen SOS column options are available, as well as any custom fields you have defined for items.

 

Columns on the report are sortable.

 

Sample Price book

This sample Price book has the Item name contains filter set for Gang Nails. The default columns (Customer, Price Tier, Item, Quantity, Sales Price, and Description), as well as Purchase Cost, are displayed.

 

The report returned two items, Gang Nails 4 inch and Gang Nails 9 inch, each of which has three price tiers: Wholesale, Distributor, and Discount for Sale. In the Customer column, the rows that show All reflect the sales price in the item definition.

 

A sample Price book report for Gang Nails.

 

Notes

If you have selected a customer, the report will only show the price tier assigned in the customer definition.