Inventory Price List

August 19, 2026 51 views admin

Inventory Price List — Complete User Guide — Two Accounts Web

Comprehensive guide for the Inventory Price List report — enabling, creating, reading, validating, and turning inventory sales prices into a sales quote

What Is the Inventory Price List Report?
Prerequisites — Enabling via the Customize Menu
Navigating to the Report
The Report List
Creating a Price List — Field-by-Field
Report Output Columns
How the Price List Is Built
Turning a Price List Into a Sales Quote
Sample Data and Report Output
Reporting and Accounting Impact
Accounting Regulation Validation
Common Notes and Best Practices

1. What Is the Inventory Price List Report?

The Inventory Price List report lists each inventory item (code and name) together with its default sales price, as configured on the inventory item. It gives you a quick, printable view of "what do we sell each item for" and allows you to optionally narrow the list by a custom-field value (for example, only a certain brand, category, or location).

The report is read-only and has one amount column (Sales Price). Crucially, it is interactive: a New Sales Quote button turns the whole price list into a pre-populated Sales Quote, so you can quickly produce a pricing document for a customer without re-entering each item and price.

The report appears under Reports only when the Inventory Items area is enabled for the business, and at least one inventory item has a default sales price set. Inventory Items is not shown by default in a brand-new company.

How to Enable

Open the Customize Menu from the navigation bar (the hamburger / menu icon).
Turn on the Inventory Items tab.
Create inventory items and set a Default Sales Price on each item you want on the list.
Once at least one item has a default sales price, the report is available under Reports → Inventory Items → Inventory Price List.

Visibility condition: If no inventory item has a non-zero default sales price, the report is hidden. Give at least one item a default sales price for the report to appear.

3. Navigating to the Report

From the main navigation bar:

Open Reports.
Go to the Inventory Items category.
Click Inventory Price List.

This opens the report list — every price list you have created (and saved) appears here, sorted by name.

4. The Report List

The list shows one row per saved price list, with two columns:

Column	Description
Name	The price list's name (e.g. "Standard Catalogue Price List").
Filter	Shown only when the price list is filtered by a custom field — the filter value (e.g. "Electronics"). Blank otherwise.

Each row is clickable:

Click the row to open the report output (the item price list).
Edit opens the price list form.

A New Report button at the top creates a fresh price list.

5. Creating a Price List — Field-by-Field

Click New Report to open the price list form. It contains these fields:

Field	Required?	What To Enter	Effect
Name	✅ Yes	A name for the price list (defaults to "Inventory Price List").	Displayed as the subtitle of the report output.
Filter by Custom Field	❌ Off by default	On or Off.	If On, the list is narrowed to items whose chosen custom field matches a value (fields below appear).
Custom Field	❌ Only if Filter by Custom Field is On	Select a custom field defined for inventory items (e.g. "Category").	The report only includes items that have this custom field.
Filter	❌ Only if Filter by Custom Field is On	Enter the value to match (e.g. "Electronics").	The report only includes items whose custom-field value equals this text.

Enter the price list Name.
Optionally turn on Filter by Custom Field and pick a Custom Field and Filter value.
Click Save.
The report opens showing the matching items and their sales prices.

6. Report Output Columns

The report opens with a subtitle:

{Price List Name}

One row is shown per included inventory item (ordered by item code/name), with a single amount column:

Column	Meaning	What To Look For
Sales Price	The item's default sales price per unit, as configured on the inventory item (bold).	Items with no default sales price are not included.

The row name is the item's Code — Name. There is no total row because prices are per-unit, not additive.

7. How the Price List Is Built

7.1 Which Items Are Included

The report considers every inventory item in the business and includes it when:

the item has a default sales price that is not zero, and
if the price list is filtered by a custom field, the item has that custom field set to the entered filter value.

7.2 The Sales Price Source

The Sales Price shown is the item's default sales unit price — the standard selling price configured on the inventory item. It is independent of the item's cost (which is driven by inventory valuation, e.g. FIFO/LIFO/Moving Average). The price list is a sales-pricing view, not a cost/valuation view.

7.3 Filtering by a Custom Field

When Filter by Custom Field is enabled, the report shows only items whose chosen custom field's value exactly equals the entered filter text. Items without that custom field, or with a different value, are excluded. This is useful for a segmented price sheet (e.g. a specific brand, a price-tier, or a category).

8. Turning a Price List Into a Sales Quote

The price list has a New Sales Quote button. Clicking it opens a new Sales Quote pre-populated from the price list:

one line per item on the price list (using the same filtering rules), with
Item = the inventory item,
Line Description = the item's default line description,
Sales Unit Price = the item's default sales price, and
Tax Code = the item's default tax code.

The quote opens with the total amount hidden, letting you add quantities and a customer, then fill in the final pricing. This turns the price list directly into a pricing document without retyping the items.

Workflow: Price list → (New Sales Quote) → Sales Quote → (customer acceptance) → Sales Order → Sales Invoice. The default sales price carried into the quote is the starting point; you can still adjust prices on the quote.

9. Sample Data and Report Output

9.1 Sample Setup

Item	Code	Default Sales Price (BDT)	Custom Field (Category)
Widget-X	WDG-001	500.00	Electronics
Gadget-Y	GDG-001	1,000.00	Electronics
Component-Z	CMP-001	800.00	Hardware

9.2 Report Output

Standard Catalogue Price List

Item	Sales Price
WDG-001 — Widget-X	500.00
GDG-001 — Gadget-Y	1,000.00
CMP-001 — Component-Z	800.00

9.3 Filtered Output Example

If a second price list is created with Filter by Custom Field = Category and Filter = Electronics, it shows only the electronic items:

Electronics Price List

Item	Sales Price
WDG-001 — Widget-X	500.00
GDG-001 — Gadget-Y	1,000.00

Component-Z (Category = Hardware) is excluded because its custom-field value does not match "Electronics".

9.4 Resulting Sales Quote

Clicking New Sales Quote on the "Standard Catalogue Price List" opens a Sales Quote with the following lines pre-filled:

Item	Line Description	Sales Unit Price	Tax Code
WDG-001 — Widget-X	(item default line description)	500.00	(item default tax code)
GDG-001 — Gadget-Y	(item default line description)	1,000.00	(item default tax code)
CMP-001 — Component-Z	(item default line description)	800.00	(item default tax code)

From here, select the customer, enter quantities, and complete the quote.

Verification: The list includes every inventory item with a non-zero default sales price, ordered by code/name, and shows that price in the Sales Price column. Widget-X (500), Gadget-Y (1,000), and Component-Z (800) are all priced items, so all three appear; a filtered list keeps only those whose custom-field value equals the filter text.

10. Reporting and Accounting Impact

The Inventory Price List itself posts nothing — it is a reference/pricing report. Its impact flows through what you do with it:

Sales Quotes / Orders / Invoices: The reported default sales price becomes the starting unit price when the item is added to sales documents (directly, or via the New Sales Quote button). Therefore it influences revenue on the Sales Invoice.
Profit & Loss (Revenue): Selling at the listed price generates the sales revenue recognized from the invoice.
Profit margin: Gross profit = Sales price − Cost of goods sold (the cost comes from inventory valuation — FIFO/LIFO/Moving Average — not from this report). The price list shows the selling side; the valuation reports show the cost side.
Sales-based reports: Sales by item/customer inherit the pricing of the items on the documents, which originate from these default sales prices.

Note: The Inventory Price List covers the selling price; inventory valuation reports cover the cost. Profit = Sales price (this report) − COGS (valuation reports).

11. Accounting Regulation Validation

Standard	Requirement	How the Report Complies
IAS 18 / IFRS 15 — Revenue recognition	Revenue is measured at the transaction price agreed with the customer.	The default sales price is the initial unit price carried into sales documents; the actual invoice price is what the customer is charged.
IAS 2 — Inventories	Inventories are carried at the lower of cost and net realisable value; selling price is distinct from cost.	The report presents the selling price separately from inventory cost (which is tracked by the valuation engine), supporting the distinction required for NRV assessment.
IAS 1 — Presentation	Transactions are recorded at their agreed amount.	The price list is a reference; revenue is recognised on the sales document at the agreed price.
Comparability / consistency	Pricing and recognition are applied consistently.	All priced items appear with their configured default sales price; the report is a consistent basis for preparing customer quotes.

Note: The Inventory Price List is a pricing reference, not a valuation or revenue report. It posts no General Ledger entries on its own; accounting impact arises only when the prices are used on sales documents.

12. Common Notes and Best Practices

Set default sales prices to make the report appear. The report is hidden until at least one item has a non-zero default sales price.
Understand the price source. The Sales Price comes from the item's default sales unit price, not its cost or a costing method.
Use the filter for segmented price sheets. Create multiple price lists filtered by a custom field (e.g. by brand or category) so you can generate targeted quotes/catalogues.
Use "New Sales Quote" to avoid re-entry. Generate a quote from the price list, then add the customer and quantities — the items, descriptions, prices, and tax codes are pre-filled.
The report posts nothing. It does not affect the General Ledger; only the sales documents that use the prices do.
Keep item prices current. Because documents inherit the default sales price, review items' prices periodically so new quotes start from the latest price.

End of Inventory Price List Guide