F130: Prices and Discounts
Version: 2025R1
Category: Finance
How to Use This Course
This course introduces the pricing and discounting functionality in Acumatica ERP. By completing the course activities, you will learn how to configure various types of sales prices and customer discounts, as well as how to calculate and update sales prices by using a sales price worksheet. You will get an understanding of how sales prices are automatically suggested and how customer discounts are automatically applied in sales orders and AR invoices. You will also learn how to update sales prices and customer discounts and how to analyze the GL batches the system creates when documents with discounts are posted. The course also walks you through the process of uploading vendor price lists to the system by using a vendor price worksheet. The course consists of three parts, each providing a set of activities that illustrate the basic configuration of prices and discounts in a midsize company. Part 1 deals with the process of defining, maintaining, and applying sales prices in the system. Part 2 covers multiple types of customer discounts and their application to financial documents. Part 3 touches upon the uploading and updating of vendor prices.
What Is in This Guide
The guide includes the Company Story topic and process activities. The Company Story topic explains the organizational structure of the company that has been preconfigured in the U100 dataset, as well as the company's business processes and requirements. Each of the process activities of the course is dedicated to a particular user scenario and consists of processing steps that you complete.
Which Training Environment You Should Use
All lessons of the course should be completed in an instance of Acumatica ERP 2025 R1 with the U100 training dataset preloaded; this dataset provides the predefined settings and entities you will need as you complete the activities of this course. You or your system administrator should prepare an instance of Acumatica ERP 2025 R1, as described in the How to Create a Tenant with the U100 Dataset section below.
What Is in a Lesson
Each lesson provides a story describing a particular user scenario and an overview of the relevant features that have been enabled in the system; configuration settings that are related to the described scenario are also listed. The lesson provides a brief overview of the process that should be performed to complete the described scenario, and instructions that guide you through the process in Acumatica ERP.
The lessons are independent and can be completed in any order. However, depending on the
sequence in which you complete the course lessons, the settings in the screenshots may differ from
the settings in the system.
What Are the Additional Materials
In the Additional Materials chapter, you can find the following information related to the processes and scenarios covered in the corresponding parts of the guide:
- Additional information about sales prices, such as the following:
- An implementation checklist
- Information about the effective period of prices, the price adjustment multiplier, the minimum markup validation in sales orders, and price lists with alternate IDs
- Details about the application of external discounts, discount calculation for multiple units of measure, and discount application in sales orders How to Use This Course | 6
What the Documentation Resources Are
Acumatica ERP provides a wide variety of documentation resources, which you can access from this course, from the system, or from the Help portal. Links to related information are provided at relevant places throughout the course. The complete Acumatica ERP documentation is available on https://help.acumatica.com/ and is included in the Acumatica ERP instance. While viewing any form used in the course (or any other Acumatica ERP form), you can click the Open Help button in the top pane to bring up a form-specific Help menu; you can use the links on this menu to quickly access form- related concepts and activities and to open a reference topic with detailed descriptions of the form elements.
How to Create a Tenant with the U100 Dataset Before you complete this course, you need to add a tenant with the U100 dataset to an existing Acumatica ERP instance. You will then prepare the tenant for completing the activities. To complete this preparation, perform the following instructions:
- Go to Amazon Storage.
- Open the folder that corresponds to the version of your Acumatica ERP instance.
- In this folder, open the Snapshots folder and download the u100.zip file.
- Launch the Acumatica ERP instance and sign in.
- Open the Tenants (SM203520) form and click Add New Record on the form toolbar.
- In the Login Name box, type the name to be used for the tenant.
- On the form toolbar, click Save.
When you create a system tenant, you may be signed out aer its creation, depending on how many non-System tenants your Acumatica ERP instance already had:
- If you started with one non-System tenant (to which you are signed in) and you create a new one, the system signs you out to switch from single-tenant mode to multitenant mode.
- If the instance had multiple non-System tenants and you create another, it is already in multitenant mode. Instead of being signed out, you wait until the system completes the operation and then proceed.
- On the Snapshots tab, click Import Snapshot.
- In the Upload Snapshot Package dialog box, select the u100.zip file, which you have downloaded, and click Upload. The system uploads the snapshot and lists it on the Snapshots tab of the Tenants form. 10.Open the Apply Updates (SM203510) form and click Schedule Lockout. 11.In the Schedule Lockout dialog box, click OK. 12.Open the Tenants form again. 13.On the form toolbar, click Restore Snapshot. 14.If the Warning dialog box appears, click Yes. 15.In the Restore Snapshot dialog box, make sure that the correct snapshot package is being uploaded and click OK. The system will restore the snapshot and sign you out. 16.Sign in to the tenant that you have just created. 17.Open the Apply Updates form again. 18.On the form toolbar, click Stop Lockout. How to Use This Course | 7
Which Credentials You Should Use
To complete the lessons, sign in as the following users:
- Part 1: johnson
- Part 2: johnson, chubb
- Part 3: johnson
The password for each user is 123.
Which License You Should Use
For the educational purposes of this course, you use Acumatica ERP under the trial license, which does not require activation and provides all available features. For the production use of this functionality, you have to activate the license your organization has purchased. Each particular feature may be subject to additional licensing; please consult the Acumatica ERP licensing policy for details. Company Story | 8
Company Story
This topic explains the organizational structure and operational activities of the company you will work with during this training.
Company Structure
The SweetLife Fruits & Jams company is a midsize company located in New York City. The company consists of the following branches:
- SweetLife Head Office and Wholesale Center: This branch of the company consists of a jam factory and a large warehouse where the company stores fruit (purchased from wholesale vendors) and the jam it produces. Warehouse workers perform warehouse operations by using barcode scanners or mobile devices with barcode scanning support.
- SweetLife Store: This branch has a retail shop with a small warehouse to which the goods to be sold are distributed from the company's main warehouse. This branch is also planning on selling goods via a website created on an e-commerce platform to accept orders online. The e-commerce integration project is underway.
- SweetLife Service and Equipment Sales Center: This branch is a service center with a small warehouse where juicers are stored. This branch assembles, sells, installs, and services juicers, in addition to training customers' employees to operate juicers.
Operational Activity
The company has been operating starting in the 01-2024 financial period. In November 2024, the company started using Acumatica ERP as an ERP and CRM system and migrated all data of the main office and retail store to Acumatica ERP. The equipment center began its operations in 01-2025 in response to the company's growth. The base currency of the company and its subsidiaries is the US dollar (USD). All amounts in documents and reports are expressed in US dollars unless otherwise indicated.
SweetLife Company Sales and Services
Each SweetLife company's branch has its own business processes, as follows:
- SweetLife Head Office and Wholesale Center: In this branch, jams and fruit are sold to wholesale customers, such as restaurants and cafes. The company also conducts home canning training at the customer's location and webinars on the company's website.
- SweetLife Store: In the store, retail customers purchase fresh fruit, berries, and jams, or pick up the goods they have ordered on the website. Some of the goods listed in the website catalog are not stored in the retail warehouse, such as tropical fruits (which are purchased on demand) and tea (which is drop-shipped from a third-party vendor).
- SweetLife Service and Equipment Sales Center: This branch assembles juicers, sells juicers, provides training on equipment use, and offers equipment installation, including site review and maintenance services. The branch performs short-term service provision. The company has local and international customers. The ordered items are delivered by drivers using the company's own vehicle. Customers can pay for orders by using various payment methods (cash, checks, or credit cards).
Company Purchases
The company purchases fruits and spices from large fruit vendors for sale and for jam production. For producing jams and packing jams and fruits, the company purchases jars, labels, and paper bags from various vendors. For Company Story | 9
the internal needs of the main office and store, the company purchases stationery (printing paper, pens, and pencils), computers, and computer accessories from various vendors. The company also purchases juicers and juicer parts from large juicer vendors, and it either purchases the installation service for the juicers or provides the installation service on its own, depending on the complexity of the installation. Part 1: Sales Prices | 10
Course Structure
Part 3: Vendor Prices............................................................................................................................ 91
Part 1: Sales Prices
- Lesson 1.1: Reviewing Sales Prices and Exploring Price Selection
- Lesson 1.2: Uploading a Sales Price List
- Lesson 1.3: Recalculating Existing Sales Prices in Bulk
Part 2: Customer Discounts
- Lesson 2.1: Application of Manual Discounts
- Lesson 2.2: Application of Automatic Discounts
- Lesson 2.3: Application of Multiple Discounts
- Lesson 2.4: Creation of a Sales Invoice for Sales Orders with Discounts
- Lesson 2.5: Creation of a Sales Invoice with Automatic and Manual Discounts