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.

Prerequisites

Items set up.

Any items with a Type of Inventory must have the below fields populated.

Unit Volume.

Duty Code.

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

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.

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'.

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