
The Grace Period for gFM-Business 6.0 begins with gFM-Business 5.6: Every new license of the gFM-Business ERP software purchased from 07.02.2022 includes a free upgrade to version 6.0.
Table of contents
In the freeware version gFM-Business free and in gFM-Business Basic, the Quick search optimized. All other functional enhancements concern gFM-Business Light and Professional as well as gFM-Business Custom Professional and the open license of gFM-Business Professional.
Customer-related discounts in customer management
The customer management of the new version 5.6 contains the new area "Discounts and surcharges" in the overview screen under the [Details] tab, in which customer-related discounts or surcharges can be preset for individual articles or for article categories.
If one of these articles or categories is entered as an item in a document, the discounts or surcharges entered here are automatically entered in the item and taken into account in the document. A validity period can also be entered for a discount or surcharge, within which the discount is to be taken into account in the billing document.
Entry of a new customer-related discount or surcharge
A new item or a new item category for a discount or surcharge can be created by clicking on the [+] symbol at the top right-hand edge of the Table and a popover will open for data entry:
In the first field, select whether you want to enter a discount or surcharge for an individual item or an item category. In the second field, select the corresponding item number or category. Optionally, you can enter a validity period. In the fourth field, select whether you want to enter a discount or surcharge and enter the corresponding percentage value in the last field.
Clicking on the [New] button creates a new data record for a customer-related discount or surcharge, which is automatically taken into account when creating new line items in the invoice for the customer called up.
Enter discounts and surcharges in the invoice
In the billing document, discounts and surcharges can be entered in the detail popover of a line item in all document types.
If an item is selected in a document that or whose category has been entered as a discount or surcharge in the associated customer, the discount or surcharge is automatically entered when the item is added.
New management of free spaces
In gFM-Business 5.6, the management of user-defined fields has been fundamentally renewed. All user-defined fields from all tables can now be managed under [Settings > Preferences > Fields] gFM-Business Custom Professional and the open license now also offer the option of creating new fields in all tables of the gFM-Business ERP software and managing them in this mask.
At the top of the field list, the list can be filtered according to the table or any search term. By default, this list contains all free fields that are available in the standard version:
- Article master (15 free fields)
- Invoice - Offers (15 free fields)
- Invoice - Offer items (5 free fields)
- Invoice - Orders (15 free fields)
- Billing document - order items (5 free fields)
- Invoice - Orders (15 free fields)
- Invoice - Order items (5 free fields)
- Invoice - Credit notes (15 free fields)
- Billing document - credit memo items (5 free fields)
- Invoice - delivery bills (15 free fields)
- Invoice - delivery note items (5 free fields)
- Invoice - Reminders (15 free fields)
- Billing document - dunning items (5 free fields)
- Invoice - Invoices (15 free fields)
- Invoice - Invoice items (5 free fields)
- Contacts - Addresses (14 free fields)
- Contacts - Customers (20 free fields)
- Company - Inventory (5 free fields)
- Company - Personnel - (10 free fields)
- Company - Projects (5 free fields)
The following information can be saved for each free field:
- File - Indicates the file in which the free field table is located
- Table - Contains the name of the table in which the field is located
- Field name - Must not contain mathematical characters and should not contain spaces
- Data type - Text, number, date, time, timestamp or container
- Input type - Applies to all integrated free fields, can optionally be used with own free fields
- Labeling - Applies to all integrated free fields, can optionally be used with own free fields
- Value list - Applies to all integrated free fields, can optionally be used with own free fields
Internal user-defined fields are identified by a light grey field background, while the entire line of custom user-defined fields has a white field background. The "Input type", "Label" and "Value list" fields are used in all integrated user-defined fields. For new custom user-defined fields, these fields are optional and do not have to be used, as the input type, label and value list can also be entered directly in the FileMaker Layout mode can be assigned.
Creation of new free fields in gFM-Business
gFM-Business Custom Professional and the open license also allow you to create new custom fields on this screen. To create a new custom field, click with the mouse on the [+] symbol in the upper right corner of the field list, whereupon a popover dialog for entering the field data opens.
- FileSelect the desired file in which the desired data table for the new free field should be located (gFM-Business, e-mail, article, invoice, contacts, correspondence or master data).
- TableData table in which the new free field should be located. After selecting the file, all tables of the file selected under point 1 are displayed in the list.
- Field nameFreely definable field name, must not contain any mathematical characters and should not contain any special characters or spaces.
- Data typeType of free field (text, number, date, time, timestamp or container)
- Labeling, input type and Value list (optional): Only to be used if fields are placed identically to internal free fields on the layouts.
Available tables for creating new free fields
The following data tables are available for creating new fields:
[table id=11 /]
Resubmissions in the billing document and with color coding
In gFM Business 5.6, a resubmission date can now be entered in all actions. Resubmissions can therefore have different data references and originate, for example, from a customer data record, a quotation or an invoice. We have therefore colored the field background of actions depending on the data reference.
If a promotion with a resubmission has a quotation or another document type from the billing document as a data reference, the resubmissions in the list are colored red according to the module color of the billing document.
Improvements and bug fixes
gFM-Business 5.6 contains some bug fixes in all modules.
Improved master-detail layouts
The functionality of master-detail layouts has been improved by correcting some incorrect layout jumps. This mainly affected the "Duplicate data record" and "Delete data record" functions in the modules [Customers], [Correspondence], [Invoice], [Articles], [Batches], [Projects], [Inventory] and [Staff] and the document history bar in the invoice.
Incorrect texts in dialogs with several open windows corrected
When working with multiple windows, it could happen that texts in dialog windows were not updated and therefore displayed incorrectly when manually switching from one window to another. This error has been corrected in all modules.
Further corrections in gFM-Business 5.6
The data references for the data record fields in the info area have been corrected system-wide on all layouts.
An error was corrected in the invoice where the total amount was not updated after entering a percentage value for a document discount. The error could be avoided by entering an absolute value and has been corrected in gFM-Business 5.6. The calculated summary of the delivery address in the field [xCal_delivery_address] has been corrected in several document types in the billing document. An error in the function [Find payment] under [Invoice > Invoices] has been fixed. When using the field [Shipping costs] the VAT was included in the total amount but not shown as VAT, this error has been corrected.
Sorting has been optimized in the item selection dialog for adding several new items in the invoice. Sorting now only takes place if the selection field for the sort sequence is filled, which can increase performance when the dialog is called up if no sorting is required.
In the module [Company > Tasks] the function menu has been corrected and the "New task" function has been added and the data record info area on the screen has been removed.
Under [Settings > Preferences > Devices] the labeling for the WIA scan options button has been corrected. In the user administration under the tab [Main menu] optimized the handling of the buttons for the visibility settings.
The performance of the REST APIInterface for Shopware-Online stores have been improved in "Automatic import" mode.
When transferring data from a previous version, the transfer of your own language texts in the language table for layouts and print layouts has been optimized. When importing data in the main menu, the user can now select whether the language records should be transferred from the old version. This function can only be used if the old version is at least 5.5.0.
Version history of gFM-Business 5.6.0
- New administration for own fields. gFM-Business Custom Professional and open license with the possibility to create new custom fields in all tables.
- Customer discounts and surcharges. Possibility to save customer-related discounts for individual articles or article groups, which are automatically taken into account when creating billing documents.
- InvoiceAdded the option to enter a resubmission date in actions. Resubmissions in lists with color coding.
- InvoiceSorting has been optimized in the item selection dialog for adding several new items in the invoice. Sorting now only takes place if the selection field for the sort sequence is filled, which can increase performance when the dialog is called up if no sorting is required.
- InvoiceCalculation of the occupancy discount corrected after entering a percentage value.
- InvoiceCalculation in field "xCal_Delivery_Address" corrected.
- InvoiceFixed an error in the "Find payment" function.
- InvoiceFixed an error when creating an order when using clients for which no order ID was entered.
- InvoiceWhen using the "Shipping costs" field, the VAT was included in the total amount, but not shown as VAT.
- Company > TasksFunction menu corrected and function "New task" added, data record info area removed.
- Data record info area corrected. On some layouts, the data references of the data record fields in the data record info area have been corrected.
- Master-Detail-Layouts: Layout jumps corrected in functions "Delete data record" and "Duplicate data record" in all modules and in the document history bar of the invoice.
- Several open windows: Display of texts in dialog boxes corrected
- User administrationFunction sequence of the button for visibility settings optimized.
- Online store interfacePerformance of the Shopware interface in "Automatic import" mode improved.
- Data transfer from previous versionTransfer of language records to layouts and print layouts optimized.
- Settings: Labeling of the button for settings of Windows WIA scanners corrected.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.







