Tracking Grants and Events in MoneyWorks

It is not uncommon for not for profits (such as sporting clubs, schools, charities) to get some sort of grant from a parent or government body, and need to monitor or report on how the funds were allocated. Similarly the organisation might run an event, and want to track its profitability.

This can be easily done in MoneyWorks by using Job Tagging, a feature that is available in all MoneyWorks products (even MoneyWorks Cashbook). Basically this provides an additional column in the transaction entry window for a job code, allowing you to tag relevant income and expenses to a job, which represents the grant or event.

Job column in transaction window

The job allocations can then be summarised in one of the Job Tagging reports.

If you haven’t used jobs before, you need to turn Job Tagging on under Edit>Document Preferences>Jobs and turn on the Show Job Column in Transaction Entry option.

If you are using MoneyWorks Express and Gold, you can turn off the Allow any value in job column option. This means you can create a”Job” for the grant/event, and MoneyWorks will be able to validate that you are entering a valid job code (which you can’t do in Cashbook). To create a job choose Show>Jobs and click the New toolbar button. Note that each job requires a client code (on the assumption that you are going to raise an invoice for the job): in this instance you should assign the job to yourself by setting yourself up as a customer (debtor).

Whenever you receive a grant (or income for an event), you can enter the code into the job column of the transaction. Similarly when you spend money from the grant (or on an expense for the event), you record the job code on the expense line. The status of the grant (or profitability of the event) can then be seen in the Job Allocation report (new in MoneyWorks 8.1.5):

Posted in FAQ, Tip du Jour | Comments Off on Tracking Grants and Events in MoneyWorks

Change History for 8.1.5

Improvements and bug fixes
18 Dec 2018

  • Several fixes for Analysis reports that ask for a search code when run
  • Scroll wheel now works on date fields again (Mac)
  • Job sheet entries from transactions now use transaction description if the detail description is blank (v8 regression)
  • Bank statement import: Fixed a problem with importing multiple payments to the same creditor
  • Daily Summary dashboard report performance optimisation (could be quite slow with many unposted transactions)
  • Dashboard Overview Debtors graph now correctly handles foreigh currency accounts receivable
  • Fixed Find related destination views for Receipts ➝ Details et al
  • Fixed data corruption when Job Sheet item is created from a transaction with very long detail description
  • Fixed a problem with window sizing on very small (unsupported) screen sizes on Windows. I guess that means they are semi-supported
  • Holiday Updates: Holidays to 2024
  • Fixed potential crash (reported on Mojave) when canceling emailing of report
  • Age by Due Date Report: Remove fixed NZD currency label
  • New Job Allocation report
  • Fixed the initial recording of Buy/Sell checkboxes for new sticky notes
  • Fixed enabling of Reports menu subfolders after modifying Document Preferences on Mac
  • Partitioned user and system mutexes, and ensured autorelease of mutexes held by a client that loses its connection to the server (so Script Editor edit lock mutex now releases when Logged out due to idle connection)
  • Fulltext Transaction Search now includes Freight docket field
  • Updated Job detailed report
  • Fixed crash when clicking Edit for an error in an Unload script while closing document (Edit is no longer available in that situation)
  • Fixed heap buffer overflow in InsertListObject
  • Form autosave no longer generates thumbnails while autosaving
  • Fixed Memo importing
  • Added Contact Person importing
  • 64-bit update to internal Mac Console component that was still 32-bit
  • Scripting improvements and bug fixes
    • New Script editor now remembers scroll position of each script that has been edited in the session
    • Scripting: GetActiveListRow function now works for selectable lists
    • Scripting: User static text fields on transaction entry screen no longer format as numbers
    • Scripting: Fixed crash with SetListContents on an active editable list (Windows)
    • Scripting: Fixed crash with long running script that causes sticky notes to be displayed (Windows)
    • New MWScript Dawdle(winRef) handler called periodically (10 second intervals) for custom MWScript windows
    • MWScript: Fixed CloseWindow() modality failure if it executes asynchronously while a modal window is up
    • MWScript associative array keys no longer truncated to 31 characters (63 allowed).
    • Resizing in Forms and UI editor: alignment guides now align to the edge not the mouse location within the drag handle
    • Script editor autosaves all scripts periodically
    • Lookup() function works for dates/numbers in Jobsheet
    • New MWScript new function: TransferFunds(from, to, date, period, ref, analysis, desc, amt [, recAmt]). Creates a funds transfer payment between two bank accounts. recAmount must be supplied if the banks are different currencies. Each amount is specified in that bank’s currency. The return value is the sequence number of the payment transaction.
    • New Optional boolean parameter to Trim: Trim(text, true) to trim all whitespace (newlines and tabs, in addition to the normal ASCII 32 space)
    • New MWScript DateFormTimestampMacEpoch date format to get a numeric timestamp from a date/time (albeit as a string, when used with DateToText)
    • New You can get the read-only status of a record entry window using pseudo-field -3 with GetFieldValue
    • SetFieldValue no longer returns an error for overlay fields when the window is in read-only state due to the record being locked
    • Removed forced numeric formatting on T_USRTEXT fields in transaction entry window
    • MWScript: ReleaseMutex function now only allows releasing mutexes obtained by the calling client
    • New MWScript File_Path(fd) to get the full path of an open file (that was opened with a partial path)
    • Resizing a custom list column in a custom window no longer has deleterious effects on window resizing
    • Preliminary support for autoloaded script bundles
    • Find Selected (Find Again) now works correctly in Script Editor when script contains multibyte unicode characters
    • Scripting: UI Form buttons set to be disabled are now actually diasbled when form is instantiated
    • Commands added to the Command menu by scripts are now cleaned up properly when the scripts unload
    • CLI: No longer use libedit/readline when CLI stdin is connected to a pipe (since it can get into an infinite spinloop
    • CLI: diagnose command no longer requires credentials to open the file when the document is opened in read-only mode (using -oe diagnose)
  • Server improvements
    • New Datacentre: REST API for server administration. Supersedes the old web admin interface which is removed
    • Datacentre: Configurable cliSemaphoreTimeoutSeconds and cliLingerSeconds to control REST worker lifecycle
    • Datacentre: Reworked port allocation on Windows to not make connections to existing running databases, resulting in spurious SSL error log entries
    • Datacentre: Tidied up SSL connection code
    • Mac Datacentre server no longer automatically sends a shutdown advisory to running databases when the service is stopped (database servers abandon their process group)
    • Server operations that create transactions now set user initials for EnteredBy correctly
    • Datacentre Backups: Pictures folder was not backed up when company name ended with a dot
    • Serverside debtor aging was setting incorrect Aged_At date in log file when client and server were on different platforms. This would cause prolems for subsequent statements that relied on that date being stored accurately
    • Fixed the attachment name for statements generated on the server for emailing
    • REST Server: some changes to Server: header
    • Emailing server-generated statements now picks up email addresses for statements that go over one page
    • Statement form thumbnail creation (which uses live data) can now run on the server, greatly improving performance when latency is high
    • The idle-disconnect alert no longer suppresses all background redraws on Mac
Posted in Change History | Comments Off on Change History for 8.1.5

Change History for 8.1.4

Improvements and bug fixes
Aug 2018

8.1.4r1

  • Fixed a crash that affected reports with certain kinds of charts
  • Fixed a potential crash in scripts that iterate over text files when an invalid file path is supplied (Windows)

8.1.4

  • New Transdate today/remember preference is now separately settable for transactions and orders
  • New Scripting: SetTaggedValue() function
  • New Datacentre Console Broadcast All function to send a message to all logged-in users of all active databases
  • Performance Age Debtors now runs on server when latency is high for significant performance increase
  • Mac: Fixed an issue with inappropriately-enabled menu items during startup
  • Fixed budget importing to not be confused by thousands separators
  • Report/Form autosave is now invoked before testing out the report
  • Fixed APS Accountant Export format (broken by changes to transaction export in 8.0.4)
  • Fixed calculation of gross for import of orders with separate freight amount
  • Windows: Fixed positioning of autocomplete dropdowns and sticky notes on HiDPI screens
  • Windows: Fixed rendering of autocomplete on std resolution monitor when main monitor is High DPI
  • Windows: Fixed initial transaction list coming up as non-MDI (modal-style) window in some circumstances
  • Datacentre: First REST request of the month (before any user has loged in) can now auto-open period
  • Windows: Fixed sticky note rendering with HiDPI monitors
  • Fixed unexpected security level filtering in non-password-protected documents
  • Bank Rec: Fix enabling of Cancel toolbar icon in Select mode
  • Importing Sales Orders against cash customers now supported
  • Name.country fields may now be up to 63 characters
  • Windows: Fixed Cashbook/Express Outlook integration
  • Fixed Highlighted-Only control enabling in Aged receivables report
  • TableAccumulate function optimised for large tables that happen to be built in sorted order
  • Print to clipboard on Windows now putting unicode text on the clipboard
  • Job Form now allows full length of Category fields to be entered
  • Fixed filter syntax checking for Product/Name record methods such as SOHforLocation
  • Sped up startup on Windows when updating plugins (now delete old plugins instead of asking the shell to move them to the trash, which is very slow on Windows 10)
  • Pad(): now returns an error for unsupported pad lengths
  • Windows: Transfer Funds window is now correct size on HiDPI screen
  • Fixed a potential crash on Windows when resixing edit lists
  • Timesheet by Resource no longer spurious department code if the resource cost account is departmentalised
  • Uninstall option now showing in Add/Remove Programs on Windows 10
  • Auto-formatted custom columns no longer reformat numeric codes as numbers when left aligned
  • Saving invoice to PDF file now sets printed flag
  • Fixed buffer overflow in script editor with very long lines
  • QIF import no longer tries to record overpayments for foreign debtors uing the auto-pay invoice rule
  • Auto-repair missing registry keys for COM on Windows after a major WIndows 10 update
  • Emailing server-generated statements from Preview window no longer uses previous email message
  • Addressed potential for crash when exiting script handlers whose window has been closed while the handler executed
  • Fixed pasting of unicode text into Budget spreadsheet on Windows
  • Scripting: persistent property of date type now retains time granularity
  • Scripting: persistent property of text type is no longer limited in length
  • Analysis with ‘Ask for search code’ can now run on the server
  • Custom reporting: PeriodNum report variable is now available in SetupReport handler on the server
  • Selecting a department from choices list in Account Enquiry after using a wildcard to invoke the choices now inserts the selected department as expected
  • MYOB AO export now strips returns embedded in descriptions — embedded returns were preventing the file from importing to AO
  • Cashbook fixed exception in auto allocation rule setup when editing complex rules
  • Fixed potential crash in auto allocation rule setup when editing complex rules
  • 5-character tax codes now look up rate properly when changed manually in detail line
  • Full-text search: The sort order is now reapplied if the full-text search completely reasonably quickly
  • Orders now always default to today’s date
  • Increased size of index cache
  • Optimisation to Diagnostic for documents with many ledgers
  • Report writer: Fixed a crash thatcould happen when changing a for-loop with multilevel sort to a different table
  • Build Command: 8.1.3 was not calculating the new the cost price for built items
  • Stock units longer than 3 chars no longer being truncated
  • Tax Codes longer than 3 characters no longer being truncated (or failing to look up rate when manaually changed) in some entry screens
  • Auto fill for departmental accounts now shows department options after pressing hyphen key
  • Auto allocation rules with amount terms now remember the relational operator correctly
  • Datacentre ASP mode should not longer impose incorrect folder metering when there are stale pid files after a server crash/reboot
  • Payments History: performance improved for high latency network connections
  • MYOB AO exporter now filters inch symbols (since the format is quoted CSV)
  • Cash Flow Statement: Now includes explicitly tagged journals
  • Singapore Customer Accounting: updated reports and default tax codes
  • Custom bank statement importer scriptss may now be located in Custom Plugins as well as standard
  • AddStatementTransaction() function now applies autoallocation rules to the transaction
  • Windows Datacentre now collects service crash dumps on 64 bit platform
  • New Plain invoice—Now includes remittance advice text from Company Details
  • Datacentre Console Show Active Documents now excludes folders with no active documents to make the active ones easier to see
  • New Custom form list objects can now display data from any table in the database
  • Remote single-pass import no longer strips tabs from the rejected records file
  • Scripting: Custom window static text controls now apply formatting to numeric data
  • Sales enquiry by name was excluding cash sales in the monthly totals for enquiries executed on the server—fixed
  • Datacentre: fixed product image deletion
  • DoReport function with output to preview now works when report is generated on the server
  • Fixed flickering cursor over form list items (Mac)
  • Fixed user role window size on MoneyWorks Now
  • Demo purchase links in MoneyWorks now load secure site
  • Balances window column names now display properly on HiDPI screen on Win10
  • Fixed memory leak in APFS folder traversal
  • Job.custom5 to 8 now available on import map
  • Ask() popup title width corrected for on HiDPI displays on Windows
  • Job Detailed report settings had an underscore in Highlighted Only control for no good reason
  • Default login list window size is wider to accommodate all columns better
  • Login.Usertext may now be set from a script with WriteCurrentRecordForWindow()
  • Scripting: Disabled lists no longer get clicks and key events
  • Fixed receipting of full amount of invoices with non-expired PPD
  • Datacentre/REST: Additional fix to interpretation of headers with non-canonical case
  • Report charts now respect cell font/size
  • Fixed typo in subscription expiry alert
Posted in Change History | Comments Off on Change History for 8.1.4

Change History for 8.1.3

7 May 2018

  • New Stock transfer journals may now be imported. The importer expects a non-product contra detail line to populate the contra field (do not import the contra account into the contra field—journals do not use that field).
  • New Having the user’s email address override the Reply-To when sending email via SMTP is now optional. This is particularly relevant to MoneyWorks Now users who are obliged to have a user email address. You can turn off user email reply-to substitution on the user record in Users & Security
  • Fixed some inconsistency in word wrap in reports between server- and client-generated reports (Windows server)
  • Fixed sign-adjustment when switching between Writeoff and Transfer journal
  • Opening report in Excel now works when the report title contains a $ character (Windows)
  • Exporting a report to text no longer applies hard word wrap in cells
  • Replace may now be used on Job.EndDate
  • Fixed crash in XML import when XML file begins with a utf-8 BOM
  • File → Import → XML now reports any errors rather than failing silently on errors
  • Account Enquiry movement list now shows transaction colour (single-user mode)
  • Payments History All list now sorts as it claims to be
  • Payments History All list no longer gets a Sequence Number Mismatch error when you drill down and change the value of the indexed field (typically date) that the list is sorted by
  • Stock Enquiry now shows lines from transfer journals
  • Build Product no longer resets the found set in the products list
  • New Audit → Backdated Transactions report: New option to show prior year transactions and posted
  • Age by Due Date Report: Corrected for case of future periods being open already
  • Fixed Period Name/Year Name corruption in files that were originally created from an Empty Clone of an older file
  • Fixed GST Report crash with 5-character tax codes
  • Fixed pasting of multi-line text from external editors into Script Editor on Windows
  • Fixed crash in WriteCurrentRecordForWindow() function when second parameter is not of the correct type
  • New GetActiveListColumn(listRef) function to determine which column of an editable list has keyboard focus
  • New GetActiveListRow(listRef) function to determine which row of an editable list has keyboard focus
  • Relational sort on a target field smaller than 4 bytes now works again (broken in v8)
  • Fixed cosmetic issue in Login dialog when switching between login modes with more options shown
  • Fixed spurious logged error on Datacentre whenever a REST request caused a document to be opened
  • Auto Allocations: Fixed multisplit allocations of non-percent values
  • Ledger Report: Fixed run time error when run for periods where there is no data
  • New GST on Prescribed Goods: invoice form (Singapore)
  • New GST on Prescribed Goods: Modifications to F5 and Tax Table (Singapore)
  • New South African VAT rate increase from 14% to 15% on 1 Apr: updated default rate table for new documents (South Africa)
  • Datacentre subscription: Revalidate button now reports error if the subscription server cannot be reached due to firewall or outdated operating system security (TLS 1.2 support must be enabled on old versions of Windows to support subscription-based licensing)
  • V7 file conversion no longer truncates description fields longer than about 750 characters
  • Stock Transfer journals now always post at the current average unit value
  • Fixed crash when starting a new MoneyWorks instance via AppleEvent while the current one is converting a large v7 file
  • Fixed buffer overflow in batch debtor receipts with very long (imported) customer name
  • Customer/supplier names up to 255 characters now supported
  • fixed a typo in the user entry dialog
  • Stock On Order displays now more consistent (previously relied on expected receive qty rather than order qty less previously received qty)
  • Updated OpenSSL to version 1.0.2o
  • Fixed window layering issue on Mac with Import Budgets
  • No longer include OTF fonts in font menu on Windows because they do not work with PDF generation
  • Fixed a crash in the report part editor dialog
  • Report maximum line length increased
Posted in Change History | Comments Off on Change History for 8.1.3

Reporting on GST for new customer accounting for prescribed goods (Singapore)

Requirements

GST F5 report in MoneyWorks 8.1.2 or later

Setup

  1. Create a All GST tax code
  2. Create a GST tax code called CAG to be used with prescribed items for customer accounting
  3. Create a general ledger code called GST Adjustment, assign it to ALL tax code and create an item also called GST_ADJ and code the Purchase (tick We buy it) account to GST Adjustment general ledger

Data Entry – Creating purchase invoice or payment By Item

  1. Enter the prescribed item as normal (including tax etc) replace the tax code to CAG (instead of G)
  2. Enter another item called GST_ADJ (created during setup) the tax code will automatically be ALL.
  3. Enter the negative tax amount (from the Suppliers invoice) into the tax column
     
  4. The invoice will have the payable amount of $10000 (from the attached image), and tax adjustment for the prescribed item of $700 (which is to be reported by the customer on behalf of supplier)
  5. Run GST report
     
  6. Run F5 Guide (updated)
     
  7. The net amount payable to IRD will be zero

If you are going to claim input tax on only the partial amount of the GST, then instead of -$700, you need to enter the amount you will be claiming back from IRAS, for eg. -$500 in the tax column of the invoice entry window.

Posted in FAQ | Comments Off on Reporting on GST for new customer accounting for prescribed goods (Singapore)

Change History for 8.1.2

Bug fixes and feature updates
25 Jan 2018

  • Fixed auto-allocation of payment to invoice in bank statement import when there is an outstanding invoice for the wrong Name type. If you are importing bank statements you should install this update.
  • New Updated GST F5 Guide (Singapore) for customer accounting on supply of prescribed goods
  • Fixed pluralisation of paid invoices count indicator
  • Cosmetic fix to Use two-tier HST checkbox (Canada)
  • New Scripting UI support for card billing scripts
  • Scripting: Fixed URLCallback enabling

Also see changes in 8.1.1.

Posted in Change History | Comments Off on Change History for 8.1.2

Change History for 8.1.1

Bug fixes and some new features
18 Jan 2018

  • Fixed some problems with autoallocation rules in bank statement importing. Everyone who imports bank statements should install this update
  • New Feature Added support for bank statement importing to create overpayments for debtors who do not yet have an invoice
  • New sample script in Gold Acme that uses fixer.io for currency cross rates
  • New Feature Allow negative receipts to pay credit notes. This facilitates credit card refunds being processed through the Banking mechanism as part of a credit card batch.
  • Prevent ctrl-Return from inserting newlines in fields that don’t support newlines (Cocoa)
  • Prevent crashes due to corrupt autocomplete data due to newlines in description fields that shouldn’t have newlines
  • Prevent reports from hanging when they are invoked via Applescript/COM with an invalid date/period range
  • New Feature SetFieldValue may now be used to set the Fields popup option in the toolbar of the transaction entry screen using pseudo-field number -1
  • Name Entry: Address field tab order now goes through postcode, country etc before progressing to the delivery address fields
  • The Outlook glue script on Windows no longer fails to attach file when there is no recipient specified
  • Batch-tracked products no longer demand a batch number when processing an order where that product’s line is not being shipped/received (zero ship qty)
  • Fix High Sierra exception when running Payments History for a selected Name in the Names list on Datacentre
  • New Feature Offer to reload dependent scripts when a library script is recompiled
  • Fixed report/form upload failure to Datacentre when the database has been open for more than a day. This issue may also have prvented plugins from downloading to fresh clients when the database has been open for more than a day
  • New Feature XPath support via libxml. New functions: XMLParseFile, XMLParseString, XPathEval, XMLFree
  • Fixed a problem with APFS directory scanning that could prevent REST-generated reports from working when the server was running on High Sierra and the report was in a subfolder
  • It’s hot. Have an ice cream… 🍦
Posted in Change History | Comments Off on Change History for 8.1.1

Upgrading a MoneyWorks 5 or earlier file on MacOS High Sierra

MacOS 13 (High Sierra) uses a new file system (APFS) which is not compatible with older versions of MoneyWorks (only MoneyWorks 8 will run on APFS, older versions require HFS+, which was the Mac file system up until High Sierra).

MoneyWorks 8 will open and convert a MoneyWorks 6 or 7 file into the MoneyWorks 8 format, but if you running MoneyWorks 5 or earlier, you will need to do some additional work.

  1. You will need to move your old MoneyWorks files to an HFS+ drive, either an existing external one, or you can make a temporary HFS+ formatted disk, as described below.
  2. You will then need to open those files in MoneyWorks 7, so they are converted into MoneyWorks 7 format
  3. You will then need to open those files in MoneyWorks 8, so they are converted into the MoneyWorks 8 format

Making an HFS disk

If you don’t have an external HFS+ drive to plug-in, you can easily a make temporary HFS+ disk image by using Disk Utility (found in Applications/Utilities).

  1. Choose File > New Image > Blank Image.
  2. Enter a file name for the disk image, then choose where to save it.

    The disk image you are making is just a file, so needs a name and location just like any other file. If in doubt, call it “MoneyWorks Conversion” and save it on your desktop.

  3. In the Name field, enter the name for the disk image.
    This is the name that appears on your desktop and in the Finder sidebar, after you open the disk image. “MoneyWorks Files” is suitable name
  4. In the Size field, enter a size for the disk image.
    Make this at least three times the size of the MoneyWorks files you are converting.
  5. Click the Format pop-up menu, then choose Mac OS Extended (Journaled)
    This is the old HFS+ file system.
  6. Leave the other options untouced. Your final settings should be something like this:
     
  7. Image Settings

  8. Click Save
    The disk image will be created and mounted for you (you will see it in the Finder sidebar under devices).
  9. Quit out of Disk Utility

You should see the disk mounted under the Devices section of the Finder sidebar:

Mounted image

Copy your old MoneyWorks files onto this disk image.

Installing MoneyWorks 7

MoneyWorks 7 is available from the Try page on the Cognito Website:

https://cognito.co.nz/download.php

Fill out the form, ensuring that you choose the correct version of MoneyWorks 7 from the pop-up menu (these are all marked as Obsolete):

Choosing Obsolete Version

The actual download link for the installer will be emailed to you. When you receive the email click the link to download the installer, then run the installer to install MoneyWorks 7 (this will over-write any existing copies of MoneyWorks).

Note: If you have previously installed MoneyWorks 8, you will need to delete it (or rename it) before installing MoneyWorks 7. This is because a MoneyWorks 7 install will not overwrite an existing MoneyWorks 8 installation.

Upgrading your files to MoneyWorks 7

Start MoneyWorks 7 (you can just run it as a trial copy, no serial number is required — if prompted for a serial number, select the “Demonstration mode” option), and click the “Open Other” button.

In the file open dialog, navigate to the HFS image (or the external HFS drive) and open the first of your old MoneyWorks files.

MoneyWorks will ask you if you want to convert it (you do), and then ask you where to save the newly converted file. Save it on the same HFS image (it will default to your Documents folder; as this is not compatible with MoneyWorks 7 you must select the HHS image/drive).

Close the converted file, then repeat for all other old files.

Upgrading to MoneyWorks 8

Having converted all your files to MoneyWorks 7 format, you can now convert them to MoneyWorks 8.

Start MoneyWorks 8 (you may need to re-install it), and, using the “Open Other” button, open and convert each of the MoneyWorks 7 files. When prompted to save, you should save it back onto your normal hard drive (as MoneyWorks 8 will work fine on the new APFS file system).

If you have existing Custom Plug-ins, remember that these must be in the same directory as the MoneyWorks file, so you might want to save the new MoneyWorks 8 files into the same location as your original MoneyWorks 5 files (assuming this is somewhere sensible, and not in our Applications folder).

Once all the files are converted to MoneyWorks 8, you can unmount the disk image and discard the disk image file (that was the file we suggested be called “MoneyWorks Conversion” and saved on your desktop).

Posted in FAQ, File Conversion | Comments Off on Upgrading a MoneyWorks 5 or earlier file on MacOS High Sierra

Change History for 8.1

Performance improvements, tweaks, new scripting functions, and bug fixes

8.1r1

11 December 8.1r1 fix for Gold/Datacentre 8.1

  • Gold/Datacentre 8.1 could display incorrect cost values for non-inventoried products in the margin display of sales transactions

8.1

7 December 2017

  • Datacentre: Include Unposted no longer fails due to unposted transactions being open for modification (in the case of Account Enquiry, this failure would be silent). It is, however, now possible for an unposted transaction to be partially included if changes to it are saved during running of a report (this is highly unlikely though, and considered the lesser of two evils)
  • Fixed a rare server crash in Bank Reconciliation finalisation with a slow network. Also slightly improved performance for good measure
  • Datacentre: Nightly save and backup for a document that is held open continuously overnight now moves the backup to the configured backups location as expected (Mac)
  • Age by Due Date report: Added breakdown by categories
  • An unfinished progressive Find in a list is now cancelled when you double-click a record in the list to modify it (actually any of Modify, New, Delete, Duplicate)
  • Fixed several issues with bank statement import and coding
  • Bank statement import now offers to open periods if necessary (if single-user mode is available)
  • Datacentre: Improved performance of bank statement import — especially evident on a high-latency network
  • Datacentre: Improved performance of transaction validation and saving — especially evident on a high-latency network
  • Datacentre: Improved performance of inventory transaction saving — especially evident on a high-latency network
  • Deleting a selection of transactions is now stoppable
  • Database tweaks to support future functionality
  • Stock History Report updated: Fixes error if run using selected locations and highlighted only
  • Scripting: Fixed crash when 4th parameter to Insert[Edit]ListObject function is not text type
  • Scripting: GetCodeField function now works properly for Name codes (supplier type parameter was not being received)
  • Scripting: Allow changing of current tab in product/job/name entry when exiting a field
  • Scripting: Scripts may replace Jobsheet.destranseq
  • Scripting: UI overlays now display correctly on HiDPI screens on Windows
  • Scripting: Fixed a potential crash in GetFieldValue (Mac)
  • Scripting: SetFieldValue can be used to change a tab control from an ExitedField handler
  • Scripting: Scripts can be copied to clipboard as RTF to retain syntax colouring (Mac)
  • Scripting: MakeGUID() function
  • Scripting: URLCallback calls must now be requested using a WebViewControl option
  • Scripting: Expat-based XML parsing functions XML_ParserCreate(), XML_SetElementHandler(), XML_SetCharacterDataHandler(), XML_Parse(), XML_Free()
  • Scripting: The DoReport() function may now take an optional extra parameter prefer_remote=1 to prefer running the report on the server even when latency is apparently low
  • Script editor now selects the bottom-most enabled script when opened (was selecting the preceding script)
  • Bank Reconciliation Start Over now refreshes transactions that are scrolled out of sight (Mac, cosmetic)
  • Stock History Report now accounts for Discounts on Stock Purchase Invoices
  • XML export now has the option of using .mwxml as the file extension
  • Journal Entry: Using shift-tab after entering last credit no longer sets the detail gross for that line to zero
  • Updated about box copyright date
  • Fixed drag-and-drop of images into Products (Mac, 64-bit)
  • Scripting: ReadCurrentRecordForWindow now returns correct value (as colour name) for colour fields
  • Product history list now shows transactions in colour for network clients
  • Fixed some spurious logging (Error 9) on server
  • Fixed button enabling in Order Processing dialog after selecting unbilled account
  • List printing now remembers preferred scale factor (Windows)
  • Fixed a problem with Script Editor autocomplete popup windows never closing on High Sierra
  • Form Layout dialog was not refreshing when new dimensions were entered (Mac)
  • Fixed a performance problem with syntax colouring in the script editor with very large scripts (Mac)
  • Save a Copy as Clone: Changed wording on dialog to better indicate that the balance date is end of financial year
  • Work around CURL error 35 on older Windows versions when accessing https
  • Single company Datacentre now autoselects first doc when none is specified
  • Fixed potential crash with a certain malformed search expression in a report
  • 🎶 and a kererū in kauri tree 🎄
Posted in Change History | Comments Off on Change History for 8.1

Change History for 8.0.9

Bug fixes
9 Oct 2017

  • Doing a find by typing into the toolbar search box has not been finding within the current found set like it used to. That’s now fixed.
  • Fixed insertion of serial/batch numbers using the serial chooser
  • Fixed Chain Report creation (Mac)
  • The date column may now be shown in the transaction detail entry independent of serial numbers
  • Duplicating and reversing a CI with a PPD now clears the PPD info on the credit being created
  • Converting Cashbook 7 to Express/Gold 8 now creates AR/AP control accounts
  • Trial Balance report is now much faster when showing movements
  • Trial Balance report now prints the “includes unposted” advisory in the footer. In fact any report that implements include unposted functionality using a custom control will now get this provided that the custom control is named exactly “Include Unposted”.
  • Use Default Printer preference is now remembered (Windows)
  • Updated MYOB AO export (was still picking up the accountant codes when the option was unticked)
  • Fixed failure to copy backups to external locations when certain other server software is installed on the machine. Also avoid an unneccessary move for monthly archives.
  • Scripting/CLI: -z command-line option now sends the Load/Unload and UserLoggedIn/UserLoggingOut messages to scripts
  • Datacentre backups were omitting pictures folder with sanitised company name
  • Script editor script order now reliably saved
  • Preview from Report Editor on Windows now comes up on top when preview window first opens
  • Print List: Title (if altered) is now remembered
  • The log entry for Age Debtors now stores the optional As At date in ISO order for more reliable parsing by reports that wish to use it
  • Serial numbers in a Quote now transfer to the Job budget
  • Cashbook: Fixed missing resource error when attempting to change Fonts in preferences
  • Datacentre port range is no longer optional (since it is no longer possible to assign a port to a document using Gold)
  • Fixed slight misalignment of movements list in Account enquiry
  • Blank auto-allocation rules can no longer be entered
  • Selling an expiring batch now autofills the batch expiry date in the sale line
  • Stock transfer journal (and any new purchase) now updates a batch’s expiry date when a new date is supplied. This can be used to correct an expiry date that was previously incorrectly specified
  • Scripting: New function FindRecordsInListWindow(winRef, searchExpr) to apply a search to a list window programmatically
  • Jobsheet Analysis and Activity fields may now be changed on processed items using the Replace command (or ReplaceField function)
  • Fixed occasional truncation of long product codes in orders
  • Fixed lower limit on stale client time in Datacentre advanced settings
  • Reduced the instances of transactions being delete-locked
  • Scripting: ReadCurrentRecordForWindow funciton now returns 0 for sequencenumber for new and duplicated records
  • Updated Open-Item statements: Correct to use last “aged at date” where provided, instead of the date the ageing was done
  • Age by Due Date report: Fix zero suppression in right hand column
  • Cancelling serial chooser no longer allows invalid value to be accepted in serial cell
  • ApprovedBy fields are now cleared on a duplicate order/transaction
  • Detail line date column can now be shown independently of serial number column
  • You read the release notes! have a cookie 🍪
Posted in Change History | Comments Off on Change History for 8.0.9