April 2026 Updates

Ver 1.0.78#

PoS Enhancements#

• The Clock Out Note form was updated to make it smaller and neater.
• Users: The Admin checkbox was changed to Role, a lookup list with the following options:
  • Admin: As before, the user can access all the application settings.
  • User: The same as a user with Admin unchecked before the change.
  • PoS User: The same as User, except that the user can transact only inside a PoS Session. When a PoS User logs in to the application, they see only one Tile Menu item, Open PoS.

Transaction Enhancements#

• Transactions: The header Assign To field was added to the Items View.

Fixes#

• Fixed: PoS: The user in the main app was not updated when you signed in from the PoS Dashboard. You can no longer open a PoS session if no till is selected.
• Fixed: CAA/SAA: If negative amounts were used on Customer or Supplier transactions, the unallocated amounts were not calculated correctly.

Ver 1.0.77#

Enhancements#

Transactions: The following columns, hidden by default, were added to the Items grid in the Edit View as follows:

• Qty (From): The Qty in the item from which the transaction was copied.
• Qty (Var): The difference between Qty and Qty (From).

PoS#

Settings Enhancements

An orange warning bar was added, with the following warnings:

• Contacts are linked to multiple Users: The duplicate contacts are also highlighted in red.
• Required Settings are blank: Blank settings are listed.
• The PoS Status list is empty.

Dashboard Enhancements

• A caption was added to the Login form to confirm which action was executed (e.g. Clock In/Out or Create a new Sales).
• The Transaction Menu Group caption was renamed to Create Transaction.
  • Note: If you try to create a transaction that you do not have access to, you must sign out to get back to the Dashboard.

• An Open Transaction menu item was added to the Transfers grid. It is enabled only for Transfer Issues from the PoS Session location.
• Transactions are now excluded from the Create Transaction tile Menu Group if one of the following conditions is true:
  • New Access is disabled for all users
  • Enable Adding Items = None
  • Enable Transfer Receive = True

• Clock Out: You are now prompted to add a Note when you clock out. Timekeeping notes appear in the Dashboard > Users grid.

• When a PoS Session is Closed, the application now closes too. The application then does not have to check for a different PoS session every time a user signs in.
• When you are in a PoS Session, the application no longer checks the Master DB for other logins, which greatly improves performance.

Ver 1.0.76#

Enhancements#

• Inventory Transfer transactions: The Entity on these transactions is now set automatically from the selected Locations.
• Transactions – Add Items: The Barcode field linked to Prices is now included in the search, so you can add items with a barcode scanner.
• Entities: The Entity Type was added as a suffix in the Parent Entity lookup (e.g. Cape Town (Branch)).
• Customer Age Analysis > Transactions: Filters were added for Outstanding and Totals (All/Debit/Credit). Trans Type and No. columns were added as an alternative to the Trans No. column, so you can group by transaction.
• Custom Reports: The Output functionality was updated so that templates link to a Report and not to Custom Reports.

PoS Enhancements#

Settings

• The Default Customer setting was moved from General Settings to the PoS setup form. It is applied only to transactions where Entity = Till.

Dashboard

• When you Open PoS, the app now checks that the PoS Status and other settings are added.
• Login: Previously, you entered your PIN and then selected an action. Now you first select an action, and then a modal form pops up for you to enter your PIN and sign in. The change makes it easier, for example, to scan a barcode to log in.
• When you open a PoS session, the selected Till is now saved to the computer’s registry and assigned automatically the next time a PoS session is opened. The Till saved to the registry is now also used to restore an open session after an app restart.
• The PoS Session No., Till and Location now appear at the top of the PoS form in the module caption font, in the format PoS No. 233 – TillName – StockLocationName.
  • Note: If the TillName is the same as the StockLocationName, the StockLocationName does not appear.
• Active transfers from the PoS Session location now also appear on the Dashboard. The Due Date now appears too.
• Bank/Transactions tabs: User and @ (time updated) columns were added. A popup menu was added with the following actions:
  • Open Transaction: You are prompted to sign in.
  • Collapse
  • Expand

A Tile Menu was added. It shows all the available actions and transactions that use Entity = Till (excluding the Transfer Receive transaction). When you click a transaction menu item, the following steps are executed:

• You are prompted to sign in.
• The PoS Dashboard is closed.
• The User Settings are updated.
• User Access for the transaction is checked, and an error message is returned if you do not have access.
• The transaction is opened (if not already open).
• A new transaction is created and opened.

PoS Module

• You can now open the PoS Edit form in the PoS Module. It is the same form that you open on the Dashboard.

Fixes#

• Fixed: The ‘Default:’ prefix was removed from General Settings > Default: Messaging App.
• Fixed: CAA: The tag [contact_acc], used in the email body, was not working.
• Fixed: Assets: You could delete a Status that was in use.

Ver 1.0.75#

• Fixed: An error was returned when the Service Manager was opened.
• Fixed: When a Supplier Price transaction using VAT-inclusive pricing was copied to a No VAT transaction, the VAT-inclusive price was copied instead of the VAT-exclusive price.

Ver 1.0.74#

Bank Import – Transaction Setting > Update Bank: The setting determines which Transaction Types can be used in a Bank Import. Select one of the following options:

• None (default)
• Debit
• Credit
• Both

For example, if the transaction debits the bank, it can be used where the bank amount is positive, and vice versa.

Custom Reports: Output functionality was added, with the following pipelines:

• Report_rec: Outputs the selected record.
• Report_all: Outputs all the records in a report.

Transactions – Output: The following Data Pipelines were added:

• trans_entity_selected: Shows fields from the selected Entity, which could be a Branch or a Till.
• trans_items_from: Transaction items linked to the header ‘From’ transaction.
• trans_entity_selected: Fields from the selected Entity (e.g. Branch or Till).
• trans_header: The fields entity and entity_registered were added.

Entities Enhancements#

• Types: Division and Region were removed.
• The new hierarchy is Registered > Branch > Department > Till/Cost Centre/Stock Location.
• Colour icons were added to the Tree view to indicate the Types.
• Entities can no longer be nested under a Cost Centre, Stock Location or Till.
• The Output tab is now available to Branches and Tills.

Inventory Transfer Enhancements#

Transaction Settings:

• Inventory > Enable Transfer Issue: Enables the From/To fields in the transaction header and assigns the From location to items.
• Inventory > Enable Transfer Receive: Enables the From/To fields in the transaction header (read only) and assigns the To location to items.

Notes

• You can add items to the Issue transaction only if:
  • Both the From and To locations are added.
  • Items are set to Fixed Location and both locations are added to the item, or items are set to All Locations.
• You cannot add items to a Receive transaction.

Pages updated:Transaction Examples – Inventory, Setup Example – Transfer Issued, Setup Example – Transfer Received

PoS Enhancements#

When you log in to the application, the Sign Out (PoS) button caption changes to Open PoS. When PoS is opened, the caption changes back to Sign Out (PoS).

When PoS is opened for the first time, only the Open/Restore button appears. As a reminder, Restore opens the last open PoS Session (Status = Open) that you clocked in to. If no open session is found, you are prompted to open a session.

User PIN: The Default PIN is now set to 12 characters, so a Code 39 barcode fits on an ID card of 55 x 85 mm.

When the Till is opened, the default Stock Location is set to the first Location with the same parent as the Till. You should therefore have only one Location for each Till.

You can now add items to transactions only if the items are set to Fixed Location and the default till location is added to the item, or the items are set to All Locations.

You cannot edit the Location in transaction items.

When the PoS is opened, you are now warned about incomplete settings (e.g. no Timekeeping Statuses are added). You can now edit Timekeeping Statuses from the PoS Setup form.

The Cash Short/Over warnings were removed from the orange bar, and the variance fields are highlighted instead. The Expected Cash is updated when the PoS Session is saved or refreshed.

A General Setting, Default Customer, was added to the PoS Setup. You select the customer from Customers. Use the setting if most of the customers are unknown Cash Accounts. The customer is assigned by default to all customer transactions in the PoS Session.

The status bar now shows the Till name next to the company name, as CompanyName – TillName.

Dashboard

Users: All the users who clocked in to the PoS Session appear. The start time is taken from the first clock-in record and the closing time from the last clock-in record. The Sales column includes credits and debits to the Sales Accounts. The following columns were added or updated:

• Hrs (C): Hours clocked in.
• Hrs (S): Hours signed in.

Transfers: The Dashboard now shows a list of stock transfers that are in transit. Right-click a transaction to receive the items. The action executes the Copy Rule from the Transfer Issue to the Transfer Receive transaction, signs you in and opens the Receive transaction for editing.

Tech note

The pos_session_id field was added to the Accounting Report table (trans_accounting_report) to make reporting easier.

Point of Sale (PoS) – New Module#

The PoS module is a backend module where you can view all the current and historic PoS Sessions.

The PoS Module can be added to the Menu in Setup > Menu.

Data Filter

• Date (default = Today)
• Entity (Till (PoS) Entities)
• Status

Grid View Columns

• Status
• Session No.
• Date: The opening date.
• Opened + By: Time and user.
• Closing + By: Time and user.
• Sales: Total sales excluding VAT.
• Variance (Open): Cash variance on open.
• Variance (Close): Cash variance on close.

Menu (button)

• Views
  • Default: Lists the PoS Sessions.
  • Users: Lists all the users, with the same fields that appear on the PoS Edit form.
• Settings
• Save/Restore Grid

Fixes#

• Fixed: The Production Transaction > Materials/Outwork Views did not show the linked GI / PO No. (Resolved column).
• Fixed: PoS: On the Bank tab, only cash transactions were displayed.
• Fixed: PoS Setup: Inactive users were displayed.
• Fixed: PoS: Signing in did not set the new Timekeeping record to ‘Started’.
• Fixed: In some cases, the Registered Entity was not set from the selected Till Entity, which excluded it from accounting. The upgrade script updates all the blank Registered Entities.
• Fixed: An error was returned when you updated a Bank Recon transaction.
• Fixed: Estimating: The Edit Format for W% was not applied. In Estimate Types, you could select Item Categories that had child items.
• Fixed: Service Types: The Project Tasks grid was not saved or restored.
• PoS messages were updated to fix grammar errors.
• The caption for the PoS Setting > Denominations was updated.

Ver 1.0.73#

Bank Import Enhancements#

You can now download Bank Profiles from the Master DB.

Note: The process for adding new Bank Profiles is as follows:

• Create a bank_parser_… function.
• Upload the new Bank Profile to the Master DB, including notes on how it works.
• The newly created Bank Profile is immediately available for download.

Guidelines for bank_parser_… function:

• The function should verify the bank account number. The number must be in the linked Bank Account’s Lookup field. If verification fails, return an error message.
• If the export file contains a unique ID (e.g. FITID in an FNB .ofx file), the ID is saved to the bank_id field and used to check for duplicate transactions in the bank_items table. The function must set the Start Date and the End Date.
• If the export file does not contain a unique ID, the bank_id field should be left blank. Only transactions dated on or after the Start Date must be imported, and the function must set the End Date.

Functionality was added to return an error message from the bank_parser function.

Bank items are now linked directly to the Transaction Header table with the field trans_header.bank_item_id. Previously, a link table was used.

Transaction Enhancements#

List View > Batch Update functionality was added for the transaction Reference.

A Transaction Setting > Enable Entities was added. The setting lets you select one of the following:

• Registered (default)
• Branches
• Tills (PoS)

You can select only Entities that are nested under a Registered Entity, directly or indirectly. The parent Registered Entity is assigned automatically from the selected Entity for accounting.

Proposals: The Price fields show the default Sell Price in the transaction currency.

Point of Sale (New Functionality)#

Timekeeping: The following Types were added:

• Clock In: Used in Point of Sale (PoS).
• Sign In: Used in PoS.

Entities: A new Type was added:

• Till (PoS): Identifies the individual Tills used in PoS. Multiple Tills can be added to a Department or to a Registered Entity.

The PoS features are for Retail Environments and manage the following:

• Till Sessions
• Cash movements and checks
• Staff Clock In/Out: Time and Attendance, linked to a Till Session
• Staff Sign In/Out: When a user logs in to create or update a transaction

When a Till Session is opened, all the Clock In and Sign In Timekeeping records and transactions are linked automatically to the session. The links use the pos_session_id field in the Timekeeping and Transaction Header tables.

You can exit a Till Session by restarting the application. To resume the open session, click Sign Out (PoS) (button).

Setting Up#

Menu: Go to Main Menu > Setup > Menu and add the fixed menu item Sign Out (PoS) to the PoS Menu Template.

Entities: Create Till (PoS) records for each till (cash register) in the company. These entities must link directly or indirectly (e.g. through a Branch) to a Registered Entity.

Transactions: All transactions linked to a PoS session must have the following setting:

• Enable Entities = Tills (PoS)

PoS Setup Module: Go to Main Menu > Setup > Point of Sale (PoS). The module gives access to the PoS General Settings, the Session Statuses and the users’ PIN numbers.

• Settings: General Settings.
  • Denominations: Used for counting cash. A comma-separated list (e.g. 1000, 500, 100, 50, 20, 10, 5, 2, 1, 0.5, 0.2).
  • Sales Accounts: Select the Sales Accounts from a dual list. The setting is used in the PoS Dashboard.
  • Cash Accounts: Select the Cash Accounts from a dual list. The setting is used to calculate the Expected Cash at the end of a PoS Session.
• Users
  • All users must be linked to a Contact.
  • PIN No.: To support a Code 39 barcode, the PIN No. should contain only numeric (0-9) and alpha (capitals only) characters. To generate a 16-digit PIN, right-click a user and select Generate PIN No. This feature will be changed to generate a 12-digit PIN.
• Status
  • This Status list is used for PoS Sessions. The default statuses are:
    • Pending
    • Open (Default = Open)
    • Closed (Default = Closed)
    • Cancelled
• User Access
  • Click Menu > User Access.
    • View: Select one of the following options. Admin can change the Status of a PoS Session.
      • None
      • Admin
      • User
    • New: Lets you create a Till Session.

PoS – Edit Form

Dashboard

• Used to sign in.
• Shows a dashboard of information about the active session.

PoS Session

• Displays the Session information
• Cash Open and Close

Bank

• Displays all the transaction items linked to a Bank Account and linked to the Session.

Transactions

• Displays all the transactions linked to the Session.

PoS – Open Application

Sign Out (PoS): A fixed menu item that must be added to a Menu Template. It is used for:

• Signing out after transacting.
• Opening the PoS after the first login or after the application restarts.

PoS – How to Open a Till Session

1. Log in to the application and click the Sign Out (PoS) menu item.
2. Select a Till. Tills are created in Entities and must be active and linked to a Registered Entity.
3. Count the opening cash using the Denomination fields.
4. Click Done (button) to complete the process. The button locks the Opening Cash Count.

PoS – How to Close a Till Session

1. Click Till (button) to open the Till Session form.
2. Count the closing cash using the Denomination fields.
3. Click Done (button) to complete the process.

PoS – How to Continue a Till Session After an App Restart

1. Log in to the application and click the Sign Out (PoS) menu item.
2. Enter or scan your PIN No. and click Restore (button).

The application locates and opens the active till session to which you are clocked in.

Fixes#

• Transaction – Allocations: You are now prompted to update the transaction amount to the Allocated Amount only on a Customer Credit transaction (e.g. Customer Receipt) or a Supplier Debit transaction (e.g. Supplier Payment). The change prevents invoice amounts from being changed.
• Items: Data Tags were hidden on Item Notes. The Document Designer feature is paused for now in favour of using Reportbuilder Templates to output Proposals.
• Fixed: Contacts > Notes: The Trans No/Ser No. now prefixes the note when you view linked notes from a contact.
• Fixed: The Delivery Address was not copied when a transaction was copied.
• Fixed: Estimating > Update from Setups: ‘Services’ was renamed to ‘Tasks’.
• Fixed: The Transactions > Add Items Search did not support a partial search on the Item Description and Code.
• User Updated and Date Updated fields were added to the Users table.