Skip links

Use gFM Business effectively and save time. Part 3: Article management

Save time with gFM-Business ERP software

Using gFM-Business effectively: Part 3After the first article in this series dealt with the CRM-module "Customer management" and the second article dealt with correspondence and the document archive, in the third part we now come to the management of articles and products, suppliers and stock.

The Enterprise software gFM-Business supports the entry of any number of material and service products, creation and import of EAN13 barcodes, calculation of different prices, any number of price groups and graduated prices, product categories, article attributes and options, any number of suppliers per article and any number of article stocks at different storage locations. With the optional online storeInterface products for Gambio GX2 online stores can be maintained offline and exported to the online store at the touch of a button. In this article we show how the Article management can be set up and used for daily work.

Setting up defaults in article management

Before item management can be used in practice, some master data and specifications should first be entered in order to be able to use product categories or price groups, for example. Defaults for item management can be set up under

Settings > Preferences > Articles

Settings: Preferences for article management

In this screen, you can set up the following defaults for item management:

  • Product categories - Any number of categories for all items. When using the optional online store interface, all categories can be imported from a Gambio GX2 online store in the online store area.
  • Product options and product option values - Product options and option values can be used to represent different variants of a product. For a computer in different configurations, for example, there would be the product option "hard disk" with the product option values "500GB", "1TB" and "2TB". These product options and option values can be entered in the product and provided with additional information such as surcharge, reduced price, additional or reduced weight. When using the optional interface for Gambio GX2 online stores, product options and option values can also be imported from the online store into gFM-Business.
  • Article revenue accounts - Here you can set up up to four different article revenue accounts with a name and account number.
  • Free selection, business areas and free fields - Each article contains a free selection field and four further free fields that can be defined here. Products can be assigned to a specific business area - define the Value list for business areas also in this mask.
  • Standard unit - Defines the default unit when entering a new item.

Entry of new products in gFM-Business

To create a new product in gFM-Business, open the product management and click on the icon [New].

Input dialog for new articles in the article master

A popover dialog then opens in which the most important key data of the new product can be maintained:

  • Article no. - Item number of the product
  • Designation - Article designation (short designation)
  • Business division - Assigned business area, see previous paragraph for specifications
  • Category - Assigned article category, see previous paragraph for specifications
  • Manufacturer - Manufacturer of the product (self-learning value list in the pop-up menu)
  • EAN code - EAN13 code assigned to the product
  • Sales net/VAT/gross - Net sales price, VAT rate and gross price. Prices can be entered either net or gross.
  • Description - Article description (long description)

After clicking on the button [New article] the new product will be Database and can now be entered in the [Article master] be supplemented with further data.

Prices and calculation

Prices and calculation, price groupsIn the area [Prices & calculation] the sales prices for all defined revenue account prices can be entered. Define revenue accounts and descriptions in the settings under [Specifications > Article].

The left-hand column shows the purchase price, which is the lowest purchase price of all the suppliers entered. A purchase price is therefore only displayed if at least one supplier with corresponding purchase conditions has been entered for the item.

Price groups and graduated prices

Price groups and graduated pricesUnder the tab [Price groups] any number of price groups and graduated prices can be entered for the item called up. If a price group has been entered in a document in the invoicing module, the prices and/or price scales maintained here are automatically taken into account. When using the optional online store interface, the price groups entered here are automatically taken into account when exporting items to the online store and exported to the Gambio GX2 online store as maintained customer groups. A price group consists of the following information:

  • Price group - Name of the price group
  • Quantity - Price applies from registered quantity (optional)
  • Net price - Net sales price
  • Gross price - Gross sales price

If no quantity is entered in a price group, the price always applies to any number of products.

Stock and minimum stock

At the bottom of the left-hand column, the stock levels in all maintained storage locations for the selected item are displayed. Product stocks can be viewed under

Articles > Article stock

must be entered separately for each item. A minimum stock level can also be entered in the article master, which must not be exceeded. If the stock level falls below the minimum stock level, the background of the field turns red.

Further article master data

In the right half of the mask [Article master] the following additional master data can be entered for the item called up:

  • Article no. Supplier (left column) - Enter the supplier's article number here. This is used for the selection of articles in an order under [Invoicing > Purchasing] required.
  • EAN code (EAN13) - An EAN13 code entered here automatically generates a corresponding barcode that can be used on print layouts and in lists.
  • Manufacturer - manufacturer of the product, is already maintained via the entry dialog.
  • Manufacturer MPN - Original article number of the manufacturer (Manufacturers Part Number)
  • Price RRP - Recommended retail price
  • VAT rate - VAT rate of the item when sold. The rate entered here is automatically used when creating new line items in the invoicing module.
  • Free fields - Three freely definable fields, see "Setting up defaults"
  • Time recording - Marks the item as a service item so that the item is available in the time recording product selection in the CRM module
  • Article image - Insert any article image here
  • Article URL - Internet address of the article at the manufacturer
  • Data sheet - Internet address of the data sheet for the article
  • Keywords - Keywords for the article are also transferred to the online store as keywords when using the optional online store interface
  • Brief description - Brief description of the article
  • Description - (long) item description, can be enlarged in the tab [Description] be processed.
  • [Preview] (only with online store interface) - displays an HTML item description in a preview.
  • [Online store] - (only with online store interface) - further online shop-specific information on the item called up
  • [Additional images] - (only with online store interface) - contains the option to enter any number of additional product images that can be exported to the online store.

Item attributes and product options

Under [Article > Article attributes] any number of article attributes and product options can be entered for the article called up. The attributes and options to be used must first be entered under [Settings > Preferences > Articles] can be defined, see chapter "Setting up defaults". An article attribute entered in the article contains details of the product option and associated option values.

Product options and article attributes

To enter a new article attribute in the article called up, click on the icon in the toolbar [New] or select the main function [Add attribute] and a popover dialog for entering the following fields will appear:

  • Sort sequence - Important for the presentation in an online store: Sort sequence within the product attributes.
  • Article option - Select the desired item option here, e.g. "Hard disk"
  • Option value - Select the desired option value, e.g. "500 GB"
  • Stock (optional) - Stock of the item with the entered item attribute
  • Weight (optional) - Overweight or underweight in grams
  • Price (optional) - additional or reduced price

If the optional online store interface is used, all article attributes contained in an article are automatically taken into account when exporting articles to the online store and are also available in the online store after export.

Enter suppliers for the article

Any number of suppliers can be entered for each item in gFM Business. When selecting suppliers, all contacts that have been marked as suppliers in the CRM module "Customers" are taken into account.

Enter suppliers of an article

To enter a new supplier for the item called up, click in the [Article > Suppliers] on the symbol [New] or select the function [New supplier] in any mask of the article management. The following details can be entered in the database for each supplier:

  • Supplier - Customer no. and name of the supplier
  • Net equity - Standard purchase price net
  • Price scale 1-3 - Quantity and net purchase price for price scales 1-3
  • Remarks - Free comments on the supplier

Item stock at various storage locations

Under [Article > Article stock] any number of stocks can be entered at any storage location for the item called up. Storage locations can be defined under [Settings > Company master data > Locations]. All locations and branches entered there are available as storage locations for entering an item stock.

Add article stock

Click on the symbol [New] under [Article > Stock] or selection of the function [Add stock] In any mask of the article management, a corresponding popover dialog opens for entering the following information:

  • Article stock - Number of items in stock
  • Branch - Location where the item is available from stock
  • Supplier - Supplier of the items in stock (optional)
  • Re. no. Supplier - Invoice number of the delivered items (optional)
  • Serial number(s) - Serial numbers of the items. If there are several items, the serial numbers entered are each separated by a line break (optional).
  • Remarks - Free comments on stock

If the item stock for an item is booked out when posting a sales document in the invoicing module, the stock level at the corresponding storage location changes. When booking out in the invoicing module, both the storage location and one or more serial number(s) can be specified in order to be able to book out the correct items at the respective storage location.

Event log for articles

In gFM-Business, every change to the database and every field change is saved in an event log. Under [Article > Events] all events relating to the article called up are displayed. This makes it easy to track all changes made to the article in the past.

Part 4: Invoicing and vouchers

This was the third part of our article series "Working effectively with gFM-Business and saving time" on the subject of article management. In the fourth part, we will look at the invoicing module and the creation of quotations, order confirmations, delivery bills, invoices, credit notes and reminders. We will also explain how the [Purchase] orders for goods can be recorded.

This is followed by the fifth part, which also deals with the module [Invoicing] and we are dealing with the Cash bookDATEV, bank bookings and account statements, direct debits, SEPA transfers and SEPA mandate management.

Buy gFM-Business in the online store

Maintenance: gFM-Business 1.8 and higher includes free upgrade to gFM-Business 2.0.
Benefit now from the low prices of the previous version!

All articles in the series

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: How to use the article management in gFM-Business effectively.