
Table of contents
- Invoice: Delivery address from another customer
- Billing: New functions and fields in line items
- Billing document: document discount as gross amount and language selection
- Correspondence: Customer selection with search function
- Optional automatic assignment of article numbers
- Customer selection with search function in gFM-Business free/Basic
- iPad user interface updated and optimized
- Improvements and bug fixes
- Version history of gFM-Business 5.3.0
Invoice: Delivery address from another customer
In the invoice, an additional customer number can now be entered for the delivery address in all document types, on the basis of which the delivery address can then be selected. When creating a new document from the CRM-module Customers out, the delivery address field is automatically filled with the customer number of the document. When converting a document to another document type, the customer number of the delivery address is transferred to the new document.
The customer number for the delivery address can be entered in the same way as the document customer number with popover window and full text search. Detailed information on the customer of the delivery address can be displayed in the info popover to the left of the field. In the field Address number all address numbers are added to the customer number in the Delivery address is displayed for selection.
Billing: New functions and fields in line items
In the module Invoice the line items in all document types have been expanded to include additional functions and fields. All new functions and fields can be found in the item detail popover, which is displayed when you click on the item price.
Calculate quantity with formula or measurement
The quantity of a line item can now be calculated using a formula or a measurement. To do this, enter the following at the top in the Formula/measurement a formula such as "5x5x5" is entered, the field Quantity the value 125 is automatically calculated. The field Formula/measurement is automatically transferred to the next document when the document is converted.
The following new field is available in the tables of all document items (offer items, order items, delivery note items, invoice items, credit note items, reminder items and order items):
- Formula_measurement (Contains formula according to which the number (quantity) of an item is calculated)
New print layouts "Measurement list" for quotation and order confirmation
In the modules [Offer] and [Order confirmation] new print layouts are now available for a measurement list. The measurement list contains a list with the following fields from the document items:
- Position (serial number or own serial number)
- Room (New field in gFM-Business 5.3)
- Description (article description)
- Remarks (New field in gFM-Business 5.3)
- Formula/measurement (New field in gFM-Business 5.3)
- Quantity (number)
A measurement list can only be generated if the "Room" field has been maintained in the document items and contains all items in which this field contains a value.
Price surcharge for a line item
In addition to the fields for an item-related discount, gFM-Business 5.3 now also contains corresponding fields for a price surcharge for the document item. The value can be entered as a percentage, as a net value or as a gross value. For a better overview, the discount fields are now highlighted in red, the surcharge fields in green. All price surcharge fields are automatically transferred to the next document when the document is converted.
The following new fields are available in the tables of all document items (offer items, order items, delivery note items, invoice items, credit note items, reminder items and order items):
- Surcharge_percent (percentage value of the surcharge amount)
- Surcharge_Net (net value of the surcharge amount)
- Surcharge_Gross (gross value of the surcharge amount)
- Price_single_net_discount_surcharge (Calculated field, contains net price incl. discount and surcharge)
New "Room" field and new free fields per document item
A new "Room" field and five freely definable fields are now available in all document types. The designations for the free fields can be changed under [Settings > Preferences > Fields 2] in the area "Positions" and are identical for all document types. All free fields are automatically transferred to the next document when the document is converted.
The following new fields are available in the tables of all document items (offer items, order items, delivery note items, invoice items, credit note items, reminder items and order items):
- Room (Can contain the text of a room and be used on measurement lists etc.)
- Open field_01 (free field, labeling can be defined in settings)
- Open field_02 (free field, labeling can be defined in settings)
- Open field_03 (free field, labeling can be defined in settings)
- Open field_04 (free field, labeling can be defined in settings)
- Open space_05 (free field, labeling can be defined in settings)
Billing document: document discount as gross amount and language selection
In the module Invoice the document discount can now be entered not only as a net price but also as a gross price. If the gross price is entered, the net price is calculated automatically.
In gFM-Business 5.3, the language selection of a document has been improved. If the document language is switched, all article texts in the selected language, if available, are entered in the document items. If no item texts are available in the selected language, the item text is retained.
Correspondence: Customer selection with search function
As in the invoicing module, the correspondence module now also contains the new customer selection popover with search function. Clicking on the customer number in the document called up opens a popover window in which the customer can be searched for and selected.
Optional automatic assignment of article numbers
In the Article management an automatic entry via a separate number range can now be activated in the "Article number" field. The corresponding number range can be found under [Settings > Preferences > Billing] in popover [Number ranges] be defined.
As with all number ranges, an individual prefix, the difference to be counted and the number of digits with leading zeros can be specified for the automatic article number range. If the fields for the article number range are left empty, the article number is not assigned automatically and the function is then inactive.
Customer selection with search function in gFM-Business free/Basic
The updated version 5.3 of gFM-Business free and Basic now also includes the convenient customer selection with search function in all document types of the billing module as well as in the correspondence module.
iPad user interface updated and optimized
In gFM-Business 5.3, the iPad layouts have been revised in some modules and new functions have also been integrated into the iPad layouts. The following iPad layouts have been revised in the current version:
- Article master: Transfer all functions from the desktop screen to the iPad screen
- Invoice: Display error in dialog popovers "New position" fixed, new fields [Purchase price], [Proceeds] and [Span] added
- Invoice: Added customer selection in popover window with search in all document types
- Invoice: Additional customer added as delivery address in all document types, selection of address numbers optimized
- Invoice: All new item fields added, item popover extended in all document types
- Invoice: Added entry of gross discount in grand total popover in all document types
- Invoice: Item numbering with popover and reset function added to all document types
- Correspondence: Customer selection in popover window with search added
- Correspondence > Archive: Function button added
- Customers > Details: Fields [Supplier no.] and [Language] added
- Customers > Events > Archive: Function button added
- Company > Personnel: Transfer complete submodule from desktop version to iPad layout
- Settings > Preferences: Client management added with display of client-related master data
Improvements and bug fixes
- In the settings in the module [User > Main menu] An error in the "Transfer GUI to user" function has been fixed.
- In the billing module [Orders] corrected an error where the item description display in the item dialog was not updated.
- In the Print layout "Letter layout" and "Fax layout", all texts have been converted to clients.
- The Table "Print file" now contains a field "_fk_language_ID", which contains the language of the saved printout.
Version history of gFM-Business 5.3.0
- Main menu: Display of company name extended to "Name/First name" if company is not maintained
- Article management: Article numbers assigned automatically
- Print layoutsClient in letter layout and fax layout
- Print layoutsNew print layout "Quotation measurement list"
- Print layoutsNew print layout "Order measurement list"
- Print layouts: Saving the language ID in the print file
- InvoiceSwitch document language optimized
- Invoice: Entry in the "Document discount" field also possible as a gross value
- InvoiceFixed error when adding order items
- InvoiceCalculation of the quantity using formula/measurement in line items
- Invoice: Customer selection in popover with search function in gFM-Business free/Basic
- Invoice: Delivery addresses from other contacts possible
- InvoiceSurcharges in all line items equivalent to discounts
- Correspondence: Customer selection with search in popover
- Correspondence > Archive: Function menu added to the data portal
- Customers > Events > Archive: Function menu added to the data portal
- Settings > Preferences: Client management added to iPad layout
- Settings > UserError in function Transfer navigation fixed
- iPad user interface revised in the customer, correspondence, invoice, article master and company modules

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.






![iPad: Customer selection in the [Billing] and [Correspondence] modules](https://gofilemaker.de/wp-content/uploads/iPad-Faktura-Kundenauswahl.jpg)

