SAP Business One - master data

The correct use of master data is the most important condition in order to SAP Business One fully, long-term and scalable. In principle, the basis for all postings in SAP Business One has been maintained accordingly: The business partners divided into three groups (customers, suppliers and interested parties), articles that are stored in stock and possibly in warehouses, and ledger accountswhich are used when posting transactions. Each time a new document is created in the system or other actions take place, SAP B1 uses these entries to provide a large part of the required information.

Data that cannot be removed

Furthermore, if master data in SAP Business One is involved in an accounting or inventory transaction, it cannot be removed from the system. In addition, all partners and items associated with a sales order are also protected.

---

SAP Business One User Master Data

Each individual working with SAP Business One must be created as a user. The user is recognized as such in SAP Business One and can dial into the program using a user code and password and work with it. As a SAP customer, the so-called Named User Licenses purchased. This means that each individual user licence is assigned to an employee of the company in the master data. Among the users, there is also the super user, a type with special tasks in SAP Business One. This user has global authorisations and can, among other things, change the password of another user.
Otherwise, all details about the user are stored via the user settings, be it the affiliation to departments or groups or their password with corresponding rules.

---

SAP Business One business partners

Business partners are certainly the central master data in SAP Business One. These can have very different roles:

• legal entities
• Pursue
• organizations
• societies
• institutions
• authorities
• ...

Business partner categorisation

SAP Business One provides a basic categorization of prospects, customers, and suppliers for these business partners. The prospect (lead) describes a target customer. This data provides the basis for sales activities and marketing campaigns. As soon as the prospect makes the first purchase, SAP Business One transfers them to the “Customer” status. The “Customer” status applies when it comes to business partners with whom you work in the sale of products and services. The data of the suppliers are in turn connected to the persons and organizations from which products and services are purchased. You take part in the generation of documents in the context of purchasing, the receipt of deliveries and the processing of delivery annuity payments.

A business partner is almost always associated with a transaction in SAP Business One. As soon as this is the case, the associated business partner or partners can no longer be deleted.

Business objects with the most categories and input fields

The business partner master data is one of the business objects with the most categories and input fields.

• header data
  The basic data of the business partner such as name, type, group membership, etc.
  
• Generally
  Basic general data on the business partner, such as general connection data, industry affiliation, groupings, etc.
  
• Contact Person
  The various people of the business partner, with their connection data, profiles, task, detailed information, etc.
  
• AddressesBilling and delivery addresses with all necessary details
  
• terms of payment
  All data concerning the payment information of the business partner, including payment terms, credit limits, price listsdunning conditions, exposure limits, interest rates, etc.
  
• payment run
  The data required for the payment assistant in bank processing is entered here
  
• accounting
  There are two more tabs here: Under "General", you will find all the data relating to consolidation, reconciliation accounts, down payments and dunning etc. Under "Tax", you will find the corresponding tax status and the tax group of the business partner to be assigned
  
• Characteristics
  Here you have the option of describing and classifying the business partner in more detail using properties. The properties can then be used as a criterion in the different areas of SAP Business One.
  
• Remarks
  Here you can maintain long texts and comments and store image files.
  
• Attachments
  Files of any format can be attached here.

Triggerable actions

From the business partner master data in SAP Business One, a number of actions can be triggered in relation to the same. This includes:

• View related service calls
• View related activities
• View related opportunities
• View related recurring transactions
• Display associated sales blanket agreements
• View associated service contracts
• Create activity
• Create service call
• Create Opportunity
• Create offer
• Create sales order
• Create outgoing invoice
• Create outgoing credit
• Create return request

---

terms of payment

The terms of payment are managed in the master data object of the same name. They are made up of the actual payment period and the discount period. These are then put together to form the complete payment terms. You can also define a number of other conditions, which are then assigned to the business partner:

• Based on the due date (document or posting date)
• Time from which the payment period begins
• tolerance days
• installment payment ? number of installments
• Create incoming payment automatically
• Define discount
• discount periods

In principle, all terms of payment that are granted to customers or granted by suppliers must be created. This can be done in three different ways. The respective terms of payment can be overridden from level to level.:

• company master data
  You can use the administration to define a default value for each new business partner to be created for customers or suppliers.
• Business partner
• The default value from the master data is adopted when the business partner is created so that you can then change it there.
• receipt
  When you create a new document, the terms of payment for the business partner are copied to the document.

---

Activities in SAP Business One

You can document any interaction with any business partner as an activity. This can be a phone call, a meeting, a task or a note or a comment.
an internal activity. Activities can be created for or from specific objects in SAP Business One. The activities can then be called from the respective linked documents or, conversely, the documents can be called from the activities.
The activity can be assigned to an employee or a group. Activities can be provided with follow-up activities as required.

Recurring Activities

A repetition can be specified for activities of the corresponding type. A repeat interval can be selected from a drop-down list so that the activity is repeated daily, weekly, monthly or yearly.

overviews and reports

Activities can be displayed in lists as an overview and filtered in the SAP Business One calendar.
In addition, these activities can also be transferred to MS Outlook via Outlook integration.

---

Article master data in SAP Business One

All goods and services that are bought and sold in the course of operational business are recorded in the item master data. The item master data is used in a variety of modules in SAP Business One. This includes purchasing, sales, service, material requirements planning and much more.

Data in master data Article

In the article, all data is recorded that is used in the most diverse contexts and tasks of the article in SAP Business One. These include, among others:

• item number
  Number with up to 50 digits that must be unique. . Once used in a transaction, it cannot be modified or deleted.
• article number series
  Series for the automatic numbering of items
• description
  Description of the item with up to 100 characters
• Foreign language name
  Description of the item in another language
• item type
  Is mainly relevant for the service module in SAP Business One and provides the categorization into items, work and travel
• item group
  Rough classification of articles into categories for the purpose of segmenting the articles in order to use them in evaluation and statistics.
• ME group
  Units of measure group that can be used to manage units of measure for the items
• EAN Code
  Field for a European article number (EAN). You can create several barcodes per unit of measure group. The EAN 13 and Code 39 formats are supported.
• price list
  Selection field for the previously created price lists to be applied to the item.
• item type
  Selection fields for the typing of articles. You can define stock items, sales items and purchase items.
• Manufacturer
  Information about the manufacturer of the item in SAP Business One
• shipping method
  Selection field for the type of shipping of the article in SAP Business One
• Manage items by (series or batches)
  Field used to determine whether an item should be managed by serial number or lot number.
• Management method (serial or batch)
  It is possible to track the use of serial or batch numbers either only when the item is issued (when it leaves the warehouse) or when the item is posted.
• warranty template
  Serial number items that are used in the "Service" module can be stored with a warranty template
• active
  Here you can specify the period for which an item should be active, i.e. available for processing.
• Inactive
  Here you can specify the period for which an item should be active, i.e. available for processing.
• Here you can specify the period during which an item should not be active, i.e. not available for processing.
• Preferred supplier
  Selection list of the preferred supplier for an item. The system then suggests this supplier for orders.
• delivery method catalog number
  It is the supplier's article number for the corresponding article in SAP Business One
• Name PurchasingUnit of measure
  Purchase quantity unit and smallest possible unit for purchasing the item
• Item per purchase unit
  Piece containing a purchase unit of measure
• Name packaging unit
  such as box, package, barrel, crate etc.
• quantity per pack
  Purchase units per packaging unit
• customs group
  applies to the import of the article from a third country
• »Length«, »Width«, »Height«, »Volume« and »Weight«
  Dimensions of the purchase unit
• tax code
  Tax code that must be used for domestic purchases.
• In stock
  Number of relevant articles that are stored
• Confirmed
  Number of affected items claimed by sales orders
• Ordered
  Number of relevant items ordered from suppliers.
• Accessible
  Number of relevant items that have been ordered from suppliers and are in stock
• item cost
  average cost of the item

---

Document numbering in SAP Business One

Defining the numbering of documents is an activity that can be carried out at the system
initialisation, i.e. before SAP Business One is put into operation. With the help of period indicators, you can use the same document numbers in different financial years.

SAP Business One provides two scenarios for numbering documents. However, once you have decided in favour of one of these scenarios, you can no longer change it once it has been implemented. Only one or more than one document type per numbering series is permitted.

You can also link a numbering series to a group via the master data, determine the digits of each number in the series or cancel the availabilities. In a document, you can also link a numbering series to a time period or a group.

---

company master data

Similar to the article or business partner master data in SAP Business One, you also enter the data of your own company. First of all, your own contact details as well as the country and foreign languages are given. In addition, the following information can be stored:

• UID number
  The VAT number of the company for which the tenant is operated in SAP Business One.
• Additional tax number
  The tax office can use this number to identify the company as part of a group
• tax office administration number
  Number of the tax office that is responsible for your advance sales tax return (UVA).
• public holidays
  Selection field for the corresponding public holiday calendar
• DVR number
  seven-digit registration number of the data protection authority
• Advanced tax reports
  Checkbox which, when ticked, activates the selection of the period type (year, quarter, month and period).
• SEPA Creditor ID
  Creditor ID from the central bank. Required if you process electronic payment transactions using the SEPA standard (= Single European Payment Area) via the payment wizard in SAP Business One