🔶 Overview

NPS Sales Price Inventory Value allows you to create and post retail calculations for legal entities primarily engaged in retail. When items are transferred from the wholesale to the retail warehouse, Business Central will automatically generate and post the retail calculation. Additionally, inventory can be directly procured at the retail location, with the retail calculation being generated during the posting of the procurement. This process can be tracked through value entries and general ledger entries. Retail prices are defined in sales price lists, where you have the option to make adjustments when prices change. We recommend creating a new price list for every retail price change to maintain a history of changes and to keep an overview of previous prices. The calculation will be generated for each sale if the sales invoice includes an item from the retail location whose price is defined in the active price list.

🔶 Settings

To obtain postings to the general ledger for retail calculations, you need to set up the Margins Account and Calc. VAT Account on the Inventory Posting Setup page.

Enter Location in the search to get a list of created locations. Clicking on this will create a new location.

At the location, it is necessary to assign a No. Series for adjustments and mark it as a retail location. For each retail location, you need to indicate the following in the Retail section:

1. Retail Location - Specifies wheather Location is used for Retail.
2. Posted Sales Price Invt. Adj. Nos. - Specifies the Nos. Code linked to Sales Price Inventory Adjustment Report that are posted from a Price List.

🔶 Sales Price List

The Sales Price List page shows all price lists that are in Active and Inactive status. Inactive price lists contain prices that were valid before the activation of a new price list for the given retail location. Each retail location can have only one active price list. Business Central always uses prices from the active price list, while prices from inactive price lists are not taken into account. Price List No. are set up on the Sales and Receivables Setup page.

Price List No. are set up on the Sales and Receivables Setup page.

When you click New on the Sales Price Lists page, a price list opens where you fill in the following fields:

Code– Assigned from the configured number series.

Description– Specifies the description of the price list.

Assign-to Type - always use the Customer Price Group. Which is also added to the customer card, as shown in the picture.

Assign-to No - It determines the code of the customer price group.

VAT Bus. Posting Gr. (Price) - Specifies the default VAT business posting group code

Price Includes VAT - Specifies the if prices include VAT.

View Columns for- It uses price, price, and discount. That's the type of price list.

Status- Indicates the current state of the price list. It can be in one of the following phases: draft, allowing editing; inactive, where editing or usage is not possible; or active, where editing can be enabled, and the price list is used for price calculations.

Currency Code - Determines the currency code of the price list.

Starting Date - Specifies the date from which the price list is valid.

Ending Date - Specifies the last date until which the price list is valid.

Allow Invoice Discount - Determines whether the invoice discount is allowed. You can change this value in the lines.

Allow Line Discount - Determines whether line discounts are allowed. You can change this value in the lines.

Retail Location - Specifies the retail location for which the price list is used. A retail location cannot have more than one active price list.

Note: We recommend that each customer price group be associated with a single location. Although a customer price group from one location can be used for other locations, Business Central recognizes the price in the price list based on the location and the customer price group. It is important to know that a customer price group assigned to another location does not contain the same items. Otherwise, Business Central will report an error if this rule is violated.

🔹 Price Change - Copy Lines

For every price change, you need to create a new price list. Creating a new price list allows you to preserve the history of all previous prices and price lists. Each price list has its own active period. When you want to activate a new price list, in addition to filling out the General tab, you can use the Copy Lines action to fill in the lines. While creating a new price list, its status is always set to Draft.

Note: The validity dates of price lists at the same location must not overlap. The end date of the previous price list is 31.05.2024, and the start date of the new price list is 01.06.2024

The Copy Lines function opens a new window where you select the price list from which lines will be copied. This will transfer items and prices to the lines of the new price list. This function allows you to expedite the process of entering new prices. Since the lines also copy prices from the selected price list, you can change prices.

After copying and modifying prices, the status of the price list is changed to active. Every activation of a price list requires a Price Inventory Adjustment.

If you change the price in an active price list, you will receive a notification at the top of the price list, as shown in the image below.

🔹 Apply Sales Price Inventory Adjustment

Apply Sales Price Inventory Adjustment - calculates the retail price calculation for changes in item prices and is located on the sales price lists. Initiating the Apply Sales Price Inventory Adjustment function opens a new page.

The new page provides the Sales Price Inventory number that will be posted and takes the code of the price list. When unchecked, the Post option offers a preview of both G/L entry and Value Entry.

When the Post option is enabled, the posting will be executed.

🔶 KEPU Report

The KEPU is a form mandated by regulations, depicting the financial representation of goods entering, exiting, and remaining in the warehouse. Business Central automatically generates this form based on data from sales price inventory adjustment, sales invoices, sales credit memos, and other documents. To search, enter the KEPU Report.

It is necessary to enter the retail location and filter the posting date.

Clicking on Preview will provide access to the Book keeping Operations and Services, as depicted in the image below.