EBM Code setup for the "Parts" – Harley-Davidson Setup Guide

1. General 

The "Parts" Report group's EBM Code setup, specifically for the Harley-Davidson pilot customer, required the use of the following Filter types: Item group EBM code, Accounting rule, and Order type.

Picking the right Code type is an important step in EBM code setup. The following Code types were used in the "Parts" section for the pilot client: 

• COS: "Cost"
  
• Sales, Turnover: "Amount" (see Image 1.1)

Image 1.1  

In the following paragraphs, we will dive into the details of setting up each type of filter. 

2. Parts: Item group EBM code 

Quick3 offers the capability to incorporate an EBM code for any Item group, simplifying the EBM code configuration process. This method streamlines the process because it replaces numerous lines of the code setup that would otherwise be required when using the Item group filter. This approach proves particularly advantageous when dealing with clients who have intricate and extensive Item group systems. For instance, our pilot client has numerous Item groups that encompass both clothing and accessories under "Klær og utstyr." When you set the EBM code for all Item groups containing Clothing and Accessories ("Klær og utstyr"), you can use the Item group EBM code filter to retrieve data from all the selected Item groups with a single action for EBM code setup. Although using a large number of Item groups is not recommended, it's advisable to optimize the process by reducing the number of Item groups to the necessary minimum. Nevertheless, the EBM code serves as an excellent solution to simplify the complex setup process for Item groups. 

In this context, Image 2.1 illustrates an example of setting up the EBM code "2 - P&A" for the Item group "31 Klær" (Clothes). You can create any EBM code simply by entering it in the EBM code field and saving it; after that, similarly, set the same EBM code for other necessary Item groups.

Image 2.1

Image 2.2 shows an example of how you can combine a collection of Item groups under a single EBM code for Clothing and Accessories. Ideally, these groups should be merged into a single Item group from the start. However, in situations where it's necessary to keep the existing operational routines intact, the EBM code can be a valuable tool for grouping them together.

Image 2.2

Afterward, you can easily retrieve data for collections of Item groups by employing the Item group EBM code filter during the setup process (see Image 2.3).

Image 2.3

3. Parts: Accounting rule

It is necessary to set the Accounting rule according to what type of sale is carried out for these items. For the pilot client, it is "Salg Eksternt" (Sales Externally) and "Salg Eksport" (Sales Export) (see Image 3.1).

Image 3.1

In order to choose only accessories that are sold with new bikes, it is necessary to set the Order type = "Kapitalvare" (Capital goods). In this case, all accessories that were ordered together with bikes will be included in this code.

You can find more examples and details about it in the previous article.  

4. Parts: Order type

The setting for the example shown in picture 4.1 was done using three filters:

• Item groups (here, all item groups containing accessories and parts have been selected) 
• Accounting rule (external sales and exported sales) 
• Order type:

- "Standard" (usually used to order parts and accessories)

- "Nettbutikk" (used to order parts and accessories from Webshop) 

- "Verksted" (used to order parts and accessories from Workshop)

- "Kasse" (used to order/buy parts and accessories from the point of sale)

Image 4.1 

To exclusively acquire Parts and Accessories that are sold independently from bikes, it should be set all Order types associated with this code, with the exception of "Kapitalvare" (Capital goods). By following this strategy, you are specifically omitting the "Kapitalvare" Order type, which encompasses the bundled sale of Accessories and Parts alongside bikes.

In the previous article, you can find another example showing the application of the Order type filter.

5. Parts: Switching to the Report group Finance

As mentioned in the previous article, switching between Report groups provides a simple option for customization when you need to access other Filter types. A similar approach has been applied to some of the codes in the "Parts" section for the pilot customer (see Image 5.1).

- - - - - - -

Example. Image 5.1 shows an example of switching to the Finance Report group for the "Parts" section. As a result, it made accessible the GL account filter, which was necessary for this code. To obtain the value of Total staff salaries in this line, we need to sum up all the accounts related to the salary and bonuses for employees. To narrow down the data to the salaries of the Parts staff, it is necessary to set: Dimension = Department ("Avdeling"), Dimension value = 2 ("Delelager" - Parts stock). It is important to remember to set the Dimension Department because Accounts 5000, 5400, and 5405 represent the total for all departments, while we require data specifically for Parts staff salaries. Check a similar example in the previous article.

- - - - - - - 

Image 5.1

Review the following articles about the settings of other Report groups: 

EBM Code setup for the "Sales" – Harley-Davidson Setup Guide

EBM Code setup for the "Stock" – Harley-Davidson Setup Guide

EBM Code setup for the "Service" – Harley-Davidson Setup Guide

EBM Code setup for the "Finance" – Harley-Davidson Setup Guide