F300

Intercompany Transactions

View:
2025R223 lessons 8 parts

F300: Intercompany Transactions

Version: 2025R2
Category: Finance

How to Use This Course

This course introduces the types of organizational structures that can be configured in Acumatica ERP, the configuration of interbranch balancing transactions, the processing of interbranch transactions, intercompany sales, and GL consolidations. The course consists of lessons that guide you step by step through the examples and explanations of the configuration and business process workflow in Acumatica ERP.

What Is in This Guide

The guide includes the Company Story topic and process activities. Company Story explains the organizational structure of the company 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

Lessons 1.1 and 1.2 should be completed in an instance of Acumatica ERP 2025 R2. For these lessons, you will use the out-of-the-box tenant that is ready for the creation of new companies. You or your system administrator should first prepare an Acumatica ERP instance and add a tenant as described in the How to Create a Tenant with an Out-of- the-Box Company section below. All other lessons of the course should be completed in an instance 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 Acumatica ERP instance, 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 completion of a lesson depends on the steps performed in the previous lessons. We recommend
          that you complete the lessons in the listed order.

What Is in a Configuration Lesson

A configuration lesson—that is, a lesson dedicated to the configuration of system settings and entities—provides a brief overview of the required system configuration and a description of other settings that could affect the configuration workflow. Each configuration lesson includes at least one implementation activity that you have to complete in your Acumatica ERP instance to configure the core system settings or to prepare system entities.

What Is in a Process Lesson

A process lesson—that is, a lesson dedicated to the performing of a particular business process—includes a brief user scenario and a description of the process workflow. It can also include process diagrams that illustrate the user scenario supported by this process. The lesson also provides a brief overview of the settings that need to be specified and the entities that need to be prepared in the system before you start to perform this business process. Each process lesson includes at least one process activity that you have to complete in your Acumatica ERP instance to learn how to perform the described business process. How to Use This Course | 7

What the Documentation Resources Are

The complete Acumatica ERP documentation is available at https://help.acumatica.com/ and is included in the Acumatica ERP instance. While viewing any form used in the course, you can click the Open Help button in the top pane of the Acumatica ERP screen to bring up the form-specific Help menu. You can use the links on this menu to quickly access form- related information and activities and to open a reference topic with detailed descriptions of the form elements.

How to Create a Tenant with an Out-of-the-Box Company To add to an existing Acumatica ERP instance a tenant with an out-of-the-box company, perform the following instructions:

  1. Launch the Acumatica ERP instance and sign in.
  2. Open the Tenants (SM203520) form, and click Add New Record on the form toolbar.
  3. In the Login Name box, type a name to be used for the tenant.
  4. On the form toolbar, click Save. The system creates the tenant.
  5. Sign out of the current tenant. You are now on the Welcome page and you can sign in to the tenant you have just created.

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’ll then prepare the tenant for completing the activities. To complete this preparation, perform the following instructions:

  1. Go to Amazon Storage.
  2. Open the folder that corresponds to the version of your Acumatica ERP instance.
  3. In this folder, open the Snapshots folder and download the u100.zip file.
  4. Launch the Acumatica ERP instance and sign in.
  5. Open the Tenants (SM203520) form and click Add New Record on the form toolbar.
  6. In the Login Name box, type the name to be used for the tenant.
  7. On the form toolbar, click Save.
                  When you create a system tenant, you may be signed out aer its creation, depending on how
              many non-System tenants your Acumatica ERP instance already had:
  • One non-System tenant (to which you are signed in): Aer you create a new one, the system signs you out to switch from single-tenant mode to multitenant mode.
  • Multiple non-System tenants: When you create another tenant, it is already in multitenant mode. Instead of being signed out, you wait until the system completes the operation and then proceed.
  1. On the Snapshots tab, click Import Snapshot.
  2. 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. How to Use This Course | 8
    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.

Which License You Should Use

For this course, you’ll use Acumatica ERP under a trial license, which doesn’t require activation and provides all available features. For the production use of this functionality, you have to activate the license your organization has purchased. Some features are subject to additional licensing; consult the Acumatica ERP licensing policy for details. Company Story | 9

Company Story

This topic explains the organizational structure and operational activity 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 is made up 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. The branch assembles, sells, installs, and services juicers, in addition to training customers' employees to operate juicers. The Muffins & Cakes company is a subsidiary SweetLife Fruits & Jams company. Muffins & Cakes—which is located in Denver, Colorado—consists of the following branches:
  • Muffins Head Office and Wholesale Center: This branch owns a bakery and a wholesale warehouse where products are stored.
  • Muffins Retail Shop: This branch, which sells products to retail customers, has a retail shop with a small warehouse.

Operational Activity

The company has been operating starting in the 01-2025 financial period. In November 2025, 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 has begun its operations in 01-2026 in response to the company's growth. The Muffins & Cakes company was established in January 2025 and started using Acumatica ERP at the end of the 01-2026 financial period. In October 2025, the company received an investment and opened a subsidiary company for construction (ToadGreen). In February 2026, the company started its first construction project. 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:

  • 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). Company Story | 10
  • 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).

Muffins & Cakes Company Sales and Services The Muffins & Cakes branches have the following business processes:

  • Muffins Head Office & Wholesale Center: In this branch, baked goods and products for baking are sold to wholesale customers, such as restaurants and cafes. The company also conducts baking classes at customer locations.
  • Muffins Store: In the store, small retail customers purchase baked goods, or pick the goods ordered on the website.

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 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 either purchases the installation service for the juicers or provides the installation service on its own, depending on the complexity of the installation. The Muffins & Cakes company also purchases stationery (printing paper, pens, and pencils) and advertising services. Models of Organization | 11

Models of Organization

In Acumatica ERP, multiple companies can be configured within one tenant. Usually, a company represents a legal entity with an independent balance sheet and separate tax reporting. Companies have to use the same base currency (if the Multiple Base Currencies feature is disabled on the Enable/Disable Features (CS100000) form), chart of accounts, and preferences. One company may have no branches, or it may consist of multiple branches, each being a separate office or a point of sale.

Types of Multibranch Companies

Acumatica ERP supports multibranch functionality, which provides the ability to represent the most typical organizational structures within Acumatica ERP. In this course, the following types of multibranch companies are used:

  • Organization with centralized accounting This type of organization is a legal entity and consists of multiple branches, each branch representing a company office. The management does not need to have a separate balance sheet for each branch; however, profits and losses should be analyzed by branches. In an organization of this type, balancing entries are not required for transactions that involve two or more company branches. The branches use one posting ledger of the Actual type. The SweetLife Fruits & Jams company, which has been created for this course, is an organization that uses centralized accounting.
  • Organization with autonomous branches This type of organization has a number of branches with separate accounting. For each branch, the management needs to have a separate balance sheet along with a separate profit and loss statement. In an organization of this type, automatic balancing entries are required for transactions that involve two or more company branches. These autonomous branches share the same ledger of the Actual type, and interbranch transactions in this company require balancing entries. The Muffins & Cakes company that you will use in this course has autonomous branches. Part 1: Configuring Companies and Branches | 12

Course Structure

Part 3: Processing Intercompany Sales................................................................................................... 53

Part 4: Performing GL Consolidation...................................................................................................... 83

Part 5: Configuring and Using Multiple Base Currencies......................................................................... 102

Part 1: Configuring Companies and Branches

Part 2: Processing Documents Involving Several Branches

Part 3: Processing Intercompany Sales

Part 4: Performing GL Consolidation

Part 5: Configuring and Using Multiple Base Currencies