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
0 Votes
People who like this
Delete Comment
This post will be deleted permanently. Are you sure?
Subscribe to notifications when the FileMaker Add-on is updated
SUBSCRIBE
The FileMaker add-on documentation can be found here:
https://www.abcinvoice.eu/filemaker
0 Votes
1 Comments
Fabrice Nordmann posted about 1 month ago Admin
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:
Inverse "month" and "day"
The calculation must be:
# 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
0 Votes