> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/documentation/guides/pricing-costs-and-charges/inventory_price_list.md). # Inventory Price List Maintain inventory price lists and pricing rules used for sales and reporting. The **Inventory Price List** brings together a number of item-related information in one list: Item attributes, sales, sales pricing, and inventory. Page factboxes display further information. {% hint style="warning" %} **Prerequisites** Items set up. Any items with a Type of Inventory must have the below fields populated. Unit Volume. Duty Code. {% endhint %} ### Setup A number of fields in the Inventory Price List can be configured by the User. There are three price-related fields and two inventory-related fields, you can specify what these display. Navigate to Bevica Setup and from the ribbon; **Related**, **Inventory Price List**, **Inventory Price List Setup**. **Inventory List Price Setup** fields: | Field | Note | | ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Prices/Costs UoM | Select if you want Bevica to look for prices in each item's Base or Sales unit of measure. If you select Base UOM, it will look for sales prices with a blank or base UoM, where the currency code is blank. If you select Sales UOM, it will look for sales prices where the UOM is the sales UoM and the currency code is blank. NB. It does not convert prices from one unit of measure to another. | | 3x Pricing columns | Select Sales Price filters | | Caption | Enter the caption users will see when viewing these columns. | | Sales Type | Pick the Sales Type for the prices you want to display. | | Sales Code | Pick the Sales Code for the prices you want to display. | | Duty Status | Select the duty status. If you select prices that include VAT, this field should not be set to Duty Free. | | Show Inventory | Select to either display Available or Projected inventory in the two Inventory fields. Available: receipted (Item Ledger Entry) stock less paid reserves and quantity on reservations against item ledger entries. Projected: receipted (Item Ledger Entry) and promised (Purchase Order line) stock less paid reserves and quantity on reservations. NB: The quantities shown in these columns are in Base UOM regardless of whether the Prices/Costs UOM field is set to Sales or Base UOM. | | 2x Inventory | Select Item Ledger Entry filters. | | Caption | Enter the caption users will see when viewing these columns. | | Location Filter | Set the location filter. To display stock in all Locations, leave the field blank, otherwise enter a Location Code. | | Duty Filter | Set the Duty filter. To display all stock available to sell Duty Paid, leave the Duty Filter field blank (it will include Duty Free stock that can be replenished to Duty Paid). | ### Populate Inventory Price List records This routine populates the Inventory Price list page. The routine can be found on both the Inventory Price List Setup and Inventory Price List pages. When run, it first deletes all existing records in the page and recreates them given the filters applied on the routine itself and the filters in Inventory Price List Setup. The routine does not apply any filters automatically, but suggests you apply these to improve performance. * Blocked = No * Sales Blocked = No * Type = Inventory * Inventory <> 0 {% hint style="success" %} The routine can be added to a **Job Queue** to be run overnight. Use report 70520 if you are using the New Price Experience, otherwise use report 70532. {% endhint %} {% hint style="info" %} If you receive the below error when populating the inventory price list, you have one or more items with a VAT Product Posting Group such as FULLVAT which is linked to a VAT posting setup record which is set as Full VAT. Items should not be linked to a VAT posting group which is setup as Full VAT. 'Type must be equal to 'G/L Account' in Sales Line: Document Type=Quote, Document No.=SALESORDERNO, Line No.=0. Current Value is 'Item'. {% endhint %} ### Inventory Price List Page The page is accessible by searching for it and from the Item Card and Item List pages. **Inventory List Price** fields | Field | Note | | ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 3x Sales Price fields |

• If you select Prices/Costs UOM as Base UOM, only Sales Prices in LCY and in Base or blank UoM are searched.

• If you select Prices/Costs UOM as Sales UOM, only Sales Prices in the sales case UOM in LCY are searched.

If no specific price is found, the software will display the price a customer will be charged, i.e. if the price is set to show Customer Price Group: WHOLESALE, but an item does not have a valid one assigned, it will display the All Customer price.

| | 3x Sales Price VAT fields |

These three fields will display the Caption entered in Inventory Price List Setup, with '(Incl. VAT)' added at the end. They denote if the respective price includes VAT or not. The fields are hidden by default.

Depending on the settings, this field may be displaying prices set in Base Unit of Measure or Sales Unit of Measure. See above.

Whether the price displayed includes or excludes VAT is determined by the Sales Type/Sales Code selected in the Inventory Price List Setup.

• If Sales Type = Customer, this will be determined by the Prices Including VAT flag on the customer selected in the Sales Code

• If Sales Type = Customer Price Group, this will be determined by the Price Includes VAT flag on the price group selected in the Sales Code

Note that All Customer and Campaign prices will always be excluding VAT.

| | Duty Paid Avg. Cost |

• If you select Prices/Costs UOM as Base UOM, the average duty paid cost is in the Base UOM

• If you select Prices/Costs UOM as Sales UOM, the average duty paid cost is in the Sales UOM.

| | Duty Free Avg. Cost |

• If you select Prices/Costs UOM as Base UOM, the average duty free cost is in the Base UOM

• If you select Prices/Costs UOM as Sales UOM, the average duty free cost is in the Sales UOM.

| | 3x Price Margin % fields | For each Sales Price field, calculates the Margin % given its respective Avg. Cost. If the price includes VAT, VAT is removed and then compares to the Avg. Cost. | | 3x Price 1 Cash Margin |

For each Sales Price field, calculates the Cash Margin given its respective Avg. Cost. If the price includes VAT, VAT is removed and then compares to the Avg. Cost.

Depending on the settings, this field may be displaying cash margin in Base Unit of Measure or Sales Unit of Measure.

• If you select Prices/Costs UOM as Base UOM, the cash margin is based on the Base UOM

• If you select Prices/Costs UOM as Sales UOM, the cash margin is based on the Sales UOM.

| | 2x Open Inventory fields | These two fields display Open Inventory: filtered to the Inventory Column 1 and Inventory Column 2 fields in Inventory Price List Setup and calculates open inventory less paid reserves. The fields are updated in real time as you move between records. The page may be slow to update if you try to scroll down/up multiple times quickly. The field's lookup gives you further information. NB: The quantities shown are in Base UOM regardless of whether the Prices/Costs UOM field is set to Base or Sales UOM. | | 2x Available Inventory fields | These two fields display Available Inventory: filtered to the Inventory Column 1 and Inventory Column 2 fields in Inventory Price List Setup and calculates open inventory less paid reserves less quantities on Reservation against Item Ledger Entries. The fields are updated in real time as you move between records. The page may be slow to update if you try to scroll down/up multiple times quickly. The field's lookup gives you further information. NB: The quantities shown are in Base UOM regardless of whether the Prices/Costs UOM field is set to Base or Sales UOM. | | Sales (Qty) | This figure displays sales quantities in base unit of measure. It can be changed by applying a Posting Date or Customer No. flowfilter. It is not recommended that you change any of the other existing flowfilters. | | Other fields... | All other fields are updated directly from the item when the Populate Inventory Price List routine is run. | **Open Inventory** = stock owned by the company **Available Inventory** = stock owned by the company not already committed to customers / other documents via Reservations. Quantities on Reservation against Item Ledger Entries, as well as sales order lines, can include quantities on reservation from the following document lines: * Transfer Orders * Requisition Worksheets * Item Journals * Production Orders * Assembly Orders * Service Orders * Job Journals --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://kb.bevica.com/documentation/guides/pricing-costs-and-charges/inventory_price_list.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.