FileMaker add-on documentation

ABCinvoice.eu FileMaker Add-on Change Log (this change log can also be found as a script in the Private scripts folder)

# version 1.1.5 - 2025-12-18

    - new

        - multi-entity. Main changes:

            - new field in settings: idInvoicingEntity (foreign key to your invoicing entities table) (if you use multiple entites, delete the field preventCreation)

            - new field in RINV (received invoices): entityId

            - new field in ABCinvoice_invoice_example: ΩABCinvoicingEntityId

        - delivery address in the invoice JSON

        - new supported attributes for the invoice: contractNumber, customerContactPerson, remittanceInformation

        - received invoice state can now be modified from the list and form layouts (change is reflected on ABCinvoice.eu)

        - columns on the received invoices list are now sortable

        - "no attachment" is displayed on the Create invoice button if no attachment is linked

        - links: new button to open the online app: app.abcinvoice.eu

    - changed

        - received invoices fields related to counterpart are now named "supplier" instead of "client"

        - Export this… (PDF, UBL…) scripts now allow to open automatically (Export field contents)

        - Export all… (PDF, UBL…) includes the download of missing files

        - Refactored the Create invoice script code

    - fixed

        - an issue on invoice creation when using the predefined payment terms value list

        - supports non ascii characters in the invoice primary key field name (was causing an issue when uploading attachments)

        - get PDF, UBL… now correctly return an error when the API returns an error (used to store the error as the content of the file)

        - retrieve received invoices: limit of 500 invoices

# version 1.1.4 - 2025-12-02

    - fixed

        - parsing of received invoices dates and due dates was incorrect

Note: to manually fix this in 1.1.3 without upgrading to 1.1.4, do the following:

in the following scripts:

• ABCinvoice_GetReceivedInvoices - Scheduled script
  • line 55
  • line 56
• ABCinvoice_GetReceivedInvoicesDetails
  • line 30
  • line 31

Inverse "month" and "day"

The calculation must be:

Let ([
    dateText = JSONGetElement ( $currentInvoice ; "date" ) ; // or dueDate
    year = GetAsNumber ( Middle ( dateText ; 1 ; 4 ) ) ;
    month  = GetAsNumber ( Middle ( dateText ; 6 ; 2 )) ;
    day = GetAsNumber ( Middle ( dateText ; 9 ; 2 ))
] ;
    Date ( month ; day ; year )
)

# version 1.1.3 - 2025-11-27

    - new

        - action buttons:

            - Excel reporting (sales and supplier invoices)

            - settings: new global fields (dates) regarding Excel export

            - invoice JSON representation new parameters:

                    - applyTaxesToCharge

                    - paymentMethod, paymentMethodText

                    - bank account info (iban, bic)

        - the invoice state is now visible on the widget

    - changes

        - improved error trapping

        - improved code quality (create invoice)

    - fixed

        - get UBL button was not running the correct script

        - get UBL script was showing wrong messages

        - removed some undue parameters in UI buttons

# version 1.1.2 - 2025-11-22

    - new

        - action buttons:

            - added the Get UBL button

            - export: you can now export a single file (PDF, JSON, FacturX, UBL)

            - settings: Send on create: if enabled, the invoice will be sent to the customer directly after creation

        - links: subscribe to notifications about the FileMaker add-on

    - changes

        - improved documentation in the invoice JSON representation field, with examples for tinScheme/tinValue

    - fixed

        - removed undue conditional formatting on the Export button (> icon)

# version 1.1.1 - 2025-11-19

    - new

        - action buttons: you can now export a single file (PDF, JSON, FacturX, UBL).

    - fixed

        - Delete portal row now has allow user abort off to avoid "do you want do continue" message if the user cancels

        - Upload attachments: forced the exit loop (implementing an add-on sometimes switches the exit after last flag to No)

# version 1.1 - 2025-11-18

    - new 

        - scripts that take JSON as parameter verify they receive proper JSON

        - ABCinvoice_CreateInvoice now validates the JSON on both invoices and invoice lines

        - the UBL form of an invoice can now be downloaded and exported, as the PDF version and FacturX

        - in the invoice JSON representation, contact.country can now be passed as a country name and is converted to country code

        - the version number is now displayed on the settings layout

 - changes

        - value lists countries and currencies are sorted alphabetically. + common currencies are repeated at the top

        - "Example Buttons" is now labeled "Actions"

        - The button that illustrates the status change now marks the invoice as Closed

        - invoice_example::ΩABCinvoiceResult has been renamed ΩABCinvoiceJson and is of type container.

        - in the ABCinvoice_Config script, the resultField has been renamed jsonField

 - fixed

        - invoice JSON representation: language now has lower case, to get legal literals in all systems

        - invoice JSON representation: an old, unused parameter related to attachments was removed to avoid confusion

        - add default Legal literals. fixed a variable name

        - several bugs fixed in ABCinvoice_GetInvoicesState - Scheduled script

# version 1.0 - 2025-11-04

    - new 

        - in the ABCinvoice_Config script, you must specify a layout of your invoice table

        - scheduled script to update invoices status

        - invoice:

            - new parameter in JSONrepresentation: paymentsOnAccount. The amount already paid. Use a negative value if the client has an outstanding balance.

            - export all found PDFs and Factur-X files

        - received invoices:

            - download binary files and attachments for received invoices

            - attachments are displayed on Received invoices. A button saves the file on the desktop.

 - changes

        - the container fields in Invoice_Sample and Attachment tables are now configured with internal storage to avoid interfering with the host solution settings. It is recommended to set them back to external storage after implementation.

        - when downloading data, the invoice record is not updated if the data hasn't changed since last time

 - fixed

        - macOS: the add-on icon looks better with Dark Mode

        - the invoice state was not updated when the JSON was downloaded

# version 0.4 - 2025-10-13

    - new 

        - legal literals:

            - content updated for France an Belgium (in fr and nl)

            - the library can be edited and literals set to mandatory or default

            - a new field allows the user to insert a variable ({}) in the contents

            - new selector to add a legal literal to an invoice

            - the > icon on the popover button is red if some mandatory literals are undefined

 - changes

        - two buttons on the interface allow to insert attachments: one for the invoice PDF, one for other documents (state of account, terms and conditions…)

        - replaced custom functions with scripts to reduce the footprint

        - final URLs called in the production and test environment

        - the script that adds a legal literal uses the internal data API (does not require Data API to be activated on the server)

 - fixed

        - compiled with FileMaker Pro 21, so the add-on can be implemented with that version

# version 0.3 - 2025-10-03

- new

        - support of various tax identifiers (TIN codes)

        - added this change log