March 2026 Updates

Ver 1.0.72#

Transaction Enhancements#

Entities: A General Setting > General > Enable Entities was added. Select Registered or Branch. This setting determines which Entity Type you can select on a transaction. If you select Branch, the parent Registered entity is also assigned to the transaction for accounting purposes.

The following Data Pipelines were added to the Transactions module:

• trans_item_attachments
• trans_item_notes

The following Data Pipelines were added for the Proposals module:

• proposal_items_attachments
• proposal_items
• proposal_root_items_attachments
• proposal_root_items_notes
• proposal_items_notes
• proposal_selected_items_attachments
• proposal_selected_items
• proposal_selected_items_notes
• proposal_root_item_attributes
• proposal_root_item
• proposal_items_attributes
• proposal_selected_items_attributes

Bank Module (New)#

The Bank module can be used for:

• Importing bank accounts
• Reconciling bank accounts (when files are unavailable to import)

Bank Profiles#

Open this module from Setup > Accounting > Bank Profiles (tab). It sets up the import method for different banks and formats. Supported formats include .ofx, .csv and .txt.

A Postgres function parses the bank files and updates the Bank Import table. The function must use the following format:

• Name = bank_parser_[file_extension][bank_name]. The lookup searches for functions that start with bank_parser_.
• Input Parameter = (bank_header_id integer).

Bank#

A Bank transaction consists of a Header and Transactions.

Setup: You must add a Status list for the Bank Header and for the Bank Items.

List View

Filters: Date (Bank and Updated), Account and Status.

Edit View

The Header contains the following fields:

• Status & Status Note
• Type: Import or Reconciliation. It cannot be changed.
• Account no.: Cannot be changed if a file is uploaded.
• Start Date: Set automatically to the End Date of the last Bank transaction + 1.
• End Date: Set automatically when you import.
• Note
• Bank: The bank balance as at the End Date.
• Ledger: The ledger balance as at the End Date.
• Variance: The difference between the Bank and the Ledger balances.

The Transactions grid view contains the following fields:

• Status
• Date
• Description
• Amount
• Trans No.

How to Create a Bank Import

• Click New (button).
• Select a bank account.
• The Start Date is set automatically from the last End Date.
• Click Actions (button) > Import and select the file.
• The file is uploaded and the bank transactions are generated.

How to Create Transactions From a Bank Import

• Check the Synchronise Ledger checkbox.
• Select a transaction. To create a transaction from it, double-click the applicable Transaction Type or click Create (button).
• Click Update (button) to change the Transaction Type. An error is returned if the transaction is in a read-only status.

How to Create a Bank Reconciliation

• Click New (button).
• Select a bank account.
• The Start Date is set automatically from the last End Date.
• Click Actions (button) > Import/Update Transactions. All the ledger transactions linked to the selected bank account are imported.

Fixes#

• The Unit Price in Items (Supplier, Cost and Sell) now supports four decimals.
• Entities > Edit View: A warning appears if you do not have Edit Access to Assets.

Ver 1.0.71#

Items – Status: A Default = New Item was added. (Previously, the Pending Status was assigned to new items.)

Proposal Enhancements#

You can now open the linked Document Template from the Proposal Template.

You can only select base (English) items in a Proposal. The Item field now also shows the Description, in the format ‘Description (Code)’.

The ‘Band’ column was renamed to ‘Group’. You can select from a distinct list of Groups in the linked Document.

Document Designer Enhancements#

• A ‘Reset Sort Order’ action was added. It fixes the sort order of Groups and Bands if the order is corrupted.
• Image Band > Image > ‘Placement’ was renamed to ‘Alignment’.
• Group functionality was added. Bands must now be contained in a Group. Nesting supports only two levels: Groups > Bands.
• Groups are explicitly ordered and can be moved up or down with the menu or with drag and drop. Groups can also be copied.
• Groups can have the same Name. A shared Name is useful when several Groups must extract data from the same Proposal Item.
• To add a Band to a Group, right-click the group or any item in the group and select the Band type.
• Bands are explicitly sorted within a Group. Bands can be moved between Groups with drag and drop.
• The Layout Attributes were moved to Groups, except the Columns and Column Gap settings.
• A Document can contain only one Header Group and one Footer Group per page, as set in the Layout > Show attribute.
• If a Document has only one page, the First Page Header and the Last Page Footer are used.
• A warning appears if headers and footers conflict (e.g. two headers are both set to appear on the first page).

Group Types

• Header: Appears at the top of a page. Maximum 1 per page.
• Footer: Appears at the bottom of a page. Maximum 1 per page.
• Body: Appears between the headers and footers.

Attributes – Header & Footer Groups

• Layout
  • Show (Lookup) (For Headers and Footers only)
    • All Pages
    • First Page
    • Last Page
    • All excluding First Page
    • All excluding Last Page
    • All excluding First and Last Page

Attributes – Body Group

• Layout
  • Start New Page
  • Keep Together

New Bands

• Group Caption: Works the same as a Caption band, but appears only once. The caption is repeated if the Groups run over several pages.

Attributes removed from Bands

• Caption – Layout
• Image – Layout
• Attributes – Layout
• Line – Layout
• Text – Layout – All Except Columns and Column Gap
• Image – Layout – All except Column Gap
• Transaction… – Layout

Fixes#

• Fixed: Various refresh and backend problems in the Online Library.
• SAA/CAA: The Unallocated value was not calculated correctly for negative amounts on transactions. It was fixed in the Accounting Report. Previously, negative amounts were converted to positive amounts by switching Dr and Cr. Now the amounts are added exactly as they are on the transaction.
• SAA: Negative Unallocated amounts now appear in a red font.

Ver 1.0.70#

Enhancements#

Attachments: The Date fields (Expiry, Issued, etc.) are now hidden by default. To show them, click Actions (button) > Show Dates.

Email: Functionality was added to add Attachments to the email body. Select them from all the links and attachments in the Transaction Flow that are linked to items in the transaction. The [attachments] tag is replaced with links to the attachments. To upload attachments from your device, click the dropdown arrow on the Attachment button.

Online Library Enhancements#

The Online Library was updated to import translations of items that match the languages on the target database.

You can now Import Proposals. All the Items linked to the Proposal must be imported before you can import a Proposal. The Document Template linked to the Proposal is also imported.

Document Designer Enhancements#

A Description field was added to the Bands to identify what the band is used for.

You can now Hide a Band in the Document Designer to simplify testing. This function was later deprecated.

A Test – TransID attribute was added to the Data Binding of Text bands, for testing the Data Tags in the text.

The following data tags were added:

• item_sell_price_exc_vat: Displays the first VAT-exclusive Sell Price that matches the Transaction Currency.
• item_sell_price_inc_vat: Displays the first VAT-inclusive Sell Price that matches the Transaction Currency.
• item_sell_price_vat: Displays the first VAT on the Sell Price that matches the Transaction Currency.

Fixes#

• Fixed: The Transaction > Add Items > Confirm Qty dialog was generating scroll bars if the Description was too long. (The Description is now wrapped.)
• Items: The New button menu was reordered to Tasks > Task, Outwork, Costing.
• Estimating > Cost Summary: The ‘Services’ caption was renamed to ‘Tasks’.

Ver 1.0.69#

Enhancements#

Online Library:

• The Online Library was upgraded to support importing translated items.
• Only the languages that are assigned to the subscriber are imported from the library.
• Only the Base (English) items can be selected in the Library.

Financial Reports: The Debit and Credit columns in the Statement of Profit/Loss and Statement of Financial Position are now hidden by default.

Contacts > Attribute Setups:

• Captions were added to the top of the Groups and Attributes grid views.
• An Action to Update Attributes in Contacts was added. This action updates the contacts with the selected Attribute group assigned.
• The caption Tel was renamed to Telephone in Contacts, Customers, Suppliers, etc.

Timekeeping: An Hourly Cost Attribute was added to the Contacts > Staff Attribute set. This value is now assigned to Timekeeping records.

Transaction Enhancements#

Estimates: If only one Estimate Type exists, the Estimate button creates the estimate without using a dropdown menu.

A Reset button was added to the Items lookup dialog.

The following Transaction Type Settings were removed because they are redundant (the Copy Rules provide the same functionality):

• Production > Enable for Purchase Orders
• Production > Enable for Goods Issued

When the Transaction Type setting Pricing is Accounting, the following applies:

• Only Items with a Cost Price can be selected (changed from Sell Price).
• Functionality to edit quantity when you add items is disabled.
• Note: The Accounting Price model uses the Fixed Price column, which is renamed to Amount. When an item is added, the Fixed Cost on the item is added to the Amount. If the Fixed Cost on the item is empty, the Unit Cost is added to the Amount. You can set up Accounting Items using the default Unit Cost or the Fixed Cost. (Tutorial)

The following Transaction Type Warnings were added:

• The Company needs to be enabled if the Dr Type or Cr Type is set to Customer or Supplier.

Items Enhancements#

Translate (button): The languages already translated now appear in bold on the dropdown menu.

Translate (button): When you click a language that is not translated, the copied item is now translated by default.

An Action to Update Attributes in Items was added to the Attribute Setup form. This action updates the items with the selected Attribute group assigned.

Document Designer Enhancements#

The Transaction Type – Description option was added to Caption (Band) > Data Field.

Functionality was added to Copy a Band. Right-click the band and select Copy.

An editable lookup list was added to the Attachment (Name) and the Note (Name) fields. It is the same lookup as in the Items module.

You can now add Data Tags to the following Bands:

• Caption: The Data Field setting was therefore removed.
• Text: Text. Content only.
• Image & Text: Text. Content only.

Data Binding:

• Item (ID) was renamed to Test – Item (ID).
• Trans (ID) was renamed to Test Trans (ID).
• Note: These fields are for testing in the Designer only.

Fixes#

• Proposals: The Band lookup was displaying items even when a Document was not selected.

• Fixed: When you Output > Email, the application stopped responding if the Email Body template contained an invalid tag.

• Fixed: Entities – The New button dropdown was displaying ‘Location’ instead of ‘Stock Location’.

• Fixed: Transactions – You were unable to clear the Resolve in the Items Grid view.

• Fixed: Transactions – The Delivery Address was not copied when a transaction was copied.

• Fixed: Transactions – The Trans No. column was not sorting numerically.

• Fixed: When you set ‘Do not Open’ on the Copy Dialog, the dialog did not close after the transaction was copied.

• Fixed: Estimating – The Speed columns were not formatted and showed unlimited decimals.

• Fixed: Estimating – When you updated from Setups, the items that were no longer linked to a Costing were not deleted.

• Fixed: Service Types – The Rep field was not copied to transactions. The dates shown in the Service Types were not updated to the time zone.

• Fixed: Trans Type Warnings – A warning about incorrect Dr Type/Cr Type was displayed even when these settings were not added.

• Fixed: Items – The dropdown in the Language indicator located on the Status bar was disabled.

• Fixes: CAA/SAA – The Rep field in the grid view now shows the ‘Known as’ field. (Previously, the full name was shown.) The Terms column was sometimes blank. Unallocated Credits were displayed as positive instead of negative. If an account only had an Unallocated Amount, the Total was not updated.

Ver 1.0.68#

Enhancements#

CAA/SAA – Allocations are now supported and an Unallocated column was added.

Email template Editor – Data Tags were added.

Transactions – Multi-word search functionality was added to the Items lookup. As a result, the lookup list no longer opens by default. (Updates: Transactions Edit View: Interface, Tutorials.)

The Supplier Reference* was added to the grid view, hidden by default (applies when transactions use Supplier Prices). *Refers to the supplier’s reference on items’ Prices tabs.

Transactions – You can now create an NCR from a transaction where NCR is enabled.

Allocations – Edit View – The Remove button now applies to multi-selected Allocations. (The ‘Remove Allocation’ menu item on the allocation grid popup menu was therefore removed.)

Items Enhancements#

Translations are now done at an Item level. The functionality works as follows (when several languages are linked to the Subscriber):

• When a new item is created, it is set to English (Base Language).
• The Translate button appears if several languages are linked to a Subscriber. Click it and select a language to create a translation. If the translation does not exist, the item is copied; otherwise, the translation opens.
• Action > Translate machine-translates the item from the original English.
• The original English appears in the Edit view of the translated items.

Notes on Translation:

• The Item list view and the Pricing and Inventory views show only the English Base Items.
• The Units, Prices and Inventory can be maintained only on the Base (English) version of the item.
• When you copy an item, only the original English version is copied.
• When the English (Base) item is deleted, all the translations are deleted with it (or moved to the Recycle Bin). The Recycle Bin shows only the Base Item.
• To delete one translation, click Actions (button) > Delete Translation. The translation is deleted permanently.

Document Designer Enhancements#

Documentation: Interface, Tutorials.

The Band ‘Description’ was renamed to ‘Name’ and is used in the Proposals module to link Bands to Proposal Items.

Band Groups – You can create a Group of Bands by assigning the same Name to multiple Bands. When the Group is linked to a Proposal Item, all the Bands in the Group are added for each item.

The Band ‘Attributes/Specification’ was renamed to ‘Attributes’.

A Caption group was added to the following Bands:

• Text – Displays the Reference of the Note
• Image – Displays the Description of the Attachment
• Image & Text – Applies to the Text portion – displays the Reference of the Note
• Attributes – Displays the Attribute Group’s Caption

Documents can be output from Transactions, or they can be used to output Proposals.

Notes on Proposal Documents: Multiple Bands can be assigned the same Name to create a Group. The grouped Bands must be in consecutive order.

Data Binding: The Bands in a document can now be bound to items using the Data Binding Attributes. The Item (ID) and Transaction (ID) attributes are for testing purposes only. The rest of the Data Binding Attributes are listed below by Band Type:

Image

• Attachment (Name) – Enter the name of an attachment linked to the Item

Caption (by default, the Item Description appears, but you can overwrite it with the attributes below):

• Data Field – Select from:
  • Item Description
  • Item Attachment – Description (By Name)
  • Item Note – Description (By Name)
  • Item Attributes – Description (By Name)
  • Transaction – Reference
  • Transaction – Company
  • Transaction – Contact
  • Transaction – Date
  • Transaction – Due Date
  • Transaction – Req Date
• Name – Applies if you select a Data Field that ends in (By Name)

Text

• Note (Name) – Shows the Note body text.

Image & Text

• Image – Attachment (Name) – Enter the name of an attachment linked to the Item.
• Text – Note (Name) – Shows the Note body text.

Attributes

• Attributes (Name) – Enter the name of an Attributes Group

Proposal Enhancements#

Proposal Templates can now be linked to an output document.

The Proposal’s Root Items can then be linked to a Band or a Band Group in the selected Document. The lookup list of Bands is a distinct list of Names that can be bound to items.

Reminder: The Proposal Root Items are:

• Mandatory (Item)
• Mandatory (Group) – Must select 1x Item
• Optional (Group) – Can select 1x Item
• Any (Group) – Can select any or none of the Items

Contacts Enhancements#

• Groups were renamed to Categories to remove the conflict with Attribute Groups.
• You can no longer edit the customer or supplier’s currency if it was used in a transaction.
• The Name field was added to the Attribute groups.
• Individual attributes can no longer be deleted, but you can delete an Attribute group.
• An Action to Update Attributes in Contacts was added to the Attribute setup form.

Transaction Type Enhancements#

The following warnings were added:

• Stock Adjustment Transactions only support Cost Price.
• The Debit Type or Credit Type does not match the Company selection.
• The editable Status on a Stock Adjustment Transaction may not update Inventory or Accounting.

You can no longer open a transaction if its Transaction Type has an error. The error appears instead.

Fixes#

• Fixed: When you navigated away from a Production Transaction’s Edit View, the Recent button took you back to the List View.
• Fixed: An error was returned when you reset your password.
• Fixed: Ledger – Detailed Ledger – If Movement was 0, the Closing Balance was 0.
• Transactions: Actions are now ordered alphabetically. When ‘Confirm’ on a Copy Rule was disabled, you still received a confirmation message.
• Financial Reporting: Negative values are now highlighted in red.
• General Settings: The ‘User Setting’ column was removed.
• Items > Pricing: ‘User Updated’ was renamed to ‘Updated by’.

1. Data tags are data fields that you can insert into a generated document (e.g. Document Designer, Email Templates). The tag is replaced with the actual information from the transaction or item when the document is generated. ↩︎