start d m w finish
3/8/07 3 2 * * 3rd day of every second month
1/8/07 14 * * * every 14th day
31/7/07 2 * 3 * every second wednesday
22/8/07 3 1 5 * 3rd friday of every month
31/7/7 32 1 * * last day of every month
1/8/07 7 * * 31/12/08 every 7 days, finishing 31/12/08
1/8/07 7 * * 5 every 7 days, recurring 5 times
Load Bank Statement now supports .qbo and .ofx files
Transaction entry tax code behaviour: Changing tax code in detail entry now prefers to keep the same net unless there is a good reason to keep the same gross (such as the transaction was imported from bank statement). You can force MoneyWorks to retain the same gross when changing the tax code by option-tabbing out of the tax code field.
Change to product buy price behaviour when purchasing: New option to control whether the buy price of a product is updated every time the product is purchased. This is a new checkbox on the Buy tab of the product record "Update price whenever purchased", on by default.
Advanced Replace can now operate on Product.Flags
New intrinsic function: SetFlag(value, flagsToSetInValue). Useful to set flags in Product.Flags using Advanced Replace. E.g Set Flags to SetFlag(Flags, #400000) sets the flag that controls the new "Update price when purchased", turning the checkbox off (because of reverse logic of this particular flag).
New intrinsic function: ClearFlag(value, flagsToClearInValue). Useful to clear flags in Product.Flags using Advanced Replace. E.g Set Flags to ClearFlag(Flags, #400000) clears the flag that controls the new "Update price when purchased", turning the checkbox on.
Deposit on Order: Tax code on deposit now respects the Name tax code override
Deposit on Order: The tax code of the deposit product is now respected
Vista printer selection: We now update a form's print settings every time it is printed. This means that on Windows, a change of printer in the Print dialog will stick without having to visit the Printer settings in the Page Setup dialog. This change is necessary because Microsoft has removed the printer selection feature from Page Setup in Windows Vista.
New localisations for Fiji and Sth Africa (charts of accounts and tax names)
Relational searching: It is now possible to get unions and intersections of selections that start from different sources. This is achieved using intersection and union operators. Having found one selection in the target file, you save that selection using the push operator (^), then start finding a new selection in the target file. Finally, apply the desired operator to combine the new and previously-saved selection. The operators are postfix notation: ^ push, + union, * intersect). e.g. [Transaction:transdate >= from and transdate <= to and type = `DI@`][Detail]^[Product:Supplier=supplier_code][Detail]* -- find details for invoices in date range, push result; find details for products for supplier; intersect 2 detail selections to get details for products for supplier in invoices in date range.
Relational searching: When the field linking one file to another is ambiguous, it is now possible to explicitly specify which field to use. Where necessary, two terms of the same file may be used. E.g. to go from a selection of payments to invoices they pay, use [Transaction:ourref="blah"][Payments.CashTrans][Payments.InvoiceID][Transaction]
Relational searching in report for-loops: It is no longer necessary to construct the relational search using string arithemtic in order to incorporate variables into the search expression. E.g. ="[transaction:transdate < '" + to_date + "']" can now be done simply as [transaction:transdate < to_date]
Product.LeadTimeDays field now works with Replace command
New global variable "version" (contains MW version number).
Export from Applescript using format string no longer appends null char to exported text
Standard statement forms no longer display completely bogus overpayment figure
Writeoff checkbox in receipt on invoice now responds to quick click when running on very slow connection (such as Internet)
Names Modify Privilege: When off, no longer allows you to change a Customer to Debtor
Datacentre client now picks up locale from the document
Cashbook/Express v4 backups with passwords can now be restored on Gold 5
Backups done on v4 on Windows with filename extension hiding on can now be restored on v5 on Windows
Exporting product.lastmodifiedtime now incudes the time rather than just the date.
Added a new number format with no thousands separators. use NumToText(n, 16)
Overriding deposit slip (using ~Banking.crep report) now works on Windows
Reorder Products for selection of sales orders no longer skips products at random
Subsummaries applied to reports containing calculated columns based on other columns with sign adjustment now work.
Removed spurious warning when attempting to apply another deposit on an order that already has 100% deposit
Prompt Payment Discount: now respects tax code of Discount write-off account
Duplicating a zero-valued invoice and changing value no longer calculates bad prompt pay discount
Fixed intermittent crash starting server on Intel-based Macs
Dummy Contra Payment no longer uses inappropriate bank account marked as unused by ~ prefix
No longer possible to roll back to the point between creating deposit CR and saving SO with deposit lodged
Auto backup on close was not saving first, so backup was of previously saved version.
Print to Excel no longer results in extra space at end of text cells
Expressions no longer subject to arbitrary rounding after prior use of Apply Format 0;-0 in a form
Corrected tool tip for currencies window
Opening jobsheet list was not always honouring saved descending sort preference
Subsummary by category with report that has breakdown by dept now works properly
Modify selection of categories: list no longer loses sort after changing a record
Coachtips no longer come up over the middle of dialogs on Mac.
Modify selection: After hitting a locked (read only) record when stepping through a selection MW Gold would stay in read only mode for the rest of the records in the selection. This is now fixed
Fixed crasher: Modifying and attempting to OK/Next a record that is locked by another user
Mac Gold added binding to Cashbook 5 documents (i.e can now drag CB 5 document onto Gold 5 icon)
Mac Gold added binding to Express 5 documents
Fixed crasher: Analyse function does not validate source file parameter
Fixed crasher: Search expression with const=const crashes search expression optimiser
Fixed Aged Debtors/Creditors reports sometimes failing to reconcile foreign currency AR/AP accounts properly
Aged Creditors report now shows correct sign for control account
New intrinsic function: SuggestNameCode(name). Suggests unique code for company name. Only available to scripts via Evaluate
Importing job sheet stock requisitions no longer baulks at out of stock items - it will now go into negative stock without complaint, consistent with the manual entry case.
Import new Name with transaction with multiple currencies enabled: Work-it-out for Contra now suported.
Switching between new QU/SO was getting colours wrong
Scripted 'evaluate': accessing CurrentPer variable was crashing if no document open
Work around Microsoft's removal of Printer button from Vista Page Setup
Downsaved file with Gold-only navigator tab selected, could get stuck tabs in Express/Cashbook
Fixed crasher with certain analysis reports exporting to text file
Terminal Services: disable detail line stripes on 4-bit colour device to avoid ugly dithering.
Filter popup was sometimes being misdrawn as a 'new record' icon.
Import was failing to create new Name if Contra is set to work it out (with multicurrency enabled)
Switching between new quote/sales order was getting colours wrong
Import trannsaction with Create Job option set was creating blank job if the job code was empty
ExpandDetail function optional rangeEnd argument now works
Budget editor now works properly on Windows when Balance spreadsheet is also open
Datacentre now remembers a user's transaction entry screen column widths
Fixed a hole in the invoice locking when multiple users simultaneously attempt to pay the same invoice
Cmd-down-arrow to edit receipt details from payment method popup menu now keeps the focus on the control after editing details (Mac)
Mac Datacentre restart from web page after configuration change now works again
Windows Datacentre: Restarting service while a file is open should no longer restart on a different port (typically 6701 instead of 6699, and web service on 6702 instead of 6700). This problem is still present on Mac version and does not appear to be fixable at this time: Workaround is to ensure all users have logged out and wait 2 minutes before restarting Datacentre, or before running Installer to install update.
Load Bank Statement date range exclusion no longer fails when bank supplies transactions that are not in date order
Corrected tax rate list display for rates with no changeover date
Euro locale chart of accounts setup was getting wrong tax codes
New variables: GstCycleEndDate (date), GstCycleNum (integer), GstIncomeInvoiceBasis (boolean), GstExpenseInvoiceBasis (boolean) reflect the current state of the GST prefs, required for writing a custom GST report.
Report interpreter Continue part followed by subsequent nested loop(s) now behaves properly
TestFlags function now works for #80000000
Improved formatting of HTML plain remittance
TextToDate now takes an optional format argument (see DateToText)
Fixed problems with formatting of some analysis reports
New date format YYYYMMDD. use -8 for format parameter to DateToText or TextToDate
Purging warning now reports correct # of unreconciled transactionsthat wont be purged
Analyse function less strict on period range checking
Leopard compatibility for Datacentre
Report chains (separate reports) option now correctly loads page settings from subreports
Preference setting "Relookup discount when qty changed" no longer forces a price relookup on orders
Windows: COM object compatibility with Visual Studio 2005
Command line modes (command line support is beta -- documentation). This provides an interface for integration with unix scripting environments, web servers etc.
Important fix to PST on printed invoices
Improvements to order deposit handling
Importing transctions and payments no longer locks database for other users during validation
VAT Guide form for Nepal
Software Update improvements (particularly on Windows/Vista)
Fixed ASB Fastnet export on Intel Macs
Show correct cycle and date on retrospective GST Guide form (NZ/Aus)
Fixed a networking issue with contains search on descending indexed sorted selection
Removed currency symbols from credit limit warnings
Fixed issue where Windows forms could sometimes print with unintended scaling
Version applescript property now works again
Open file or location via Apple Event returns an error if the open/connect fails
Fixed intermittent cosmetic issue with tab rendering on Windows
Fixed spurious currency diagnostic
Mac Navigator skins now expected to be in the bundle Resources folder
Fixed processing of forex purchase orders to cash purchase.
Fixed crash with chain reports with subreports containing running headers
Canadian cheques: date formats are now dd mm yyyy; also added new full page cheque form with cheque at top and dual remittance advice
Fix timesheet entry of resources with departmentalised cost-of-goods control account
Prompt payment discount on invoices created from orders
Scanning of Scripts folder for scripts to add to Command menu was stopping prematurely (Mac)
Replace of Name.ReceiptMethod now works
COM export with empty search function now selects all records
Login window now treats Return key as Enter
About:System Info on Windows: text had grey background
Reinstated v4 behaviour for allocating muliple existing overpayments during receipt entry for a debtor
Aged Debtors Report: no longer show ledger balance if only reporting on a subset of debtors
Fix incorrect number formatting on some cheque forms
Fix crash printing payments history with very long descriptions
Deposit on Invoice: Receipt bank details were not being kept
Swap State and postcode fields in name entry screen and company details
Names entry: address details had wrong tab order
Fixed incorrect GST labels in Canadian tax rate entry dialog box
/fold command line switch now works again as for v4 (Citrix/Windows)
Fixed initial Navigator window size for new documents (Mac)
Standard charts of accounts: header accounts were not coming through as heading only in new document
Duplicate Journal was inappropriately showing autosplit and ex-tax controls
Custom Navigator skin was not auto loading until selected in prefs (fixed in 5.0.3/Nepal)
Fixed broken APS Accountants Export
Fixed conversion of v4 files whose names contain a single quote (failed with "conversion tool missing")
Fixed GST cycle failure to increment in multiuser when GST journal is posted (new v5 bug) - affects GST reprints
Fixed to general problem with "Faster Networking" that affected GST reprints
Fixed faulty Navigator rendering on 10.3.9
Correct Canadian PST support
feature: add Checkmark Payroll import map for Canada (note: requires as-yet-unreleased update to Checkmark Payroll)
Fix: Statement form Balance History from Date no longer producing the correct running total
Fix: Find Related: Product -> Job Sheet Item; never finds anything
Export of Payments file fails with scripts written for v4 (re-added legacy field names for that file)
Set flag field for default allocations in QIF import
Fix: Batch Creditor Payments skipping 2 cheque numbers
Removed QIF Ref= Code= Part= parsing as it is less than useful
Fix: Deleting > 32767 products can report bogus numbers in confirmation alert
Speed up DC login: Datacentre sending unused page setup data to clients on login
Transactions All/Posted tabs toolbars swapped
Fix Report writer trace not working on Mac if report name > 27 chars
Fix: Ship multiple SO -> crash
Reinstate DC multiple connections from same workstation (WTS session detection)
Custom forms: double chevron character not cross platform. << >> digraphs now preferred
Reports: fix double overscore positioning
Fix bogus error message when adding or removing Category on P&L type GL Code
Fix posted multicurrency transaction margin (was calculated using the system rate)
Deposits on Orders: Where DEPOSIT product has exempt GST, the resulting invoice would not balance.
Fix detail line sorting w.r.t long text in detail description field
Fix company name >= 50 characters crashing DC
Fixes to Accountants Export formats in v5
Fix "tried to write record without exclusive access" opening new period on DC
Fix intermittent crash when drilldown and scroll in GST report preview on Win
Fix logo in Company Details not sticking in DC (new graphic formats)
Fix: Deposits on Orders: TaxAmount is set to zero on resultant transaction, giving wrong GST on report
Fix: Reports: Logos in v5 sometimes print too large.
Better handling of foreign currencies in Sales/Purchase enquiries
Detail.job column with "Allow any value in job column" allowed an "@"
Fix: Accounts list gets odd toolbar when accounting for GST is turned off
Fix numeric format on FE Chq form
Cash Basis/Include Unposted are mutaually exclusiv: Reflect this in checkbox enabling
Fix CurrencyConvert function not respecting period parameter
Fix: Show Department when Printing Report: If set along with Show Movements, get transactions from every period
Fix: Duplicate filter: new filter does not appear in edit filters list (until Cmd-J)
Scripts Folder: Bundled (.app) applications put in custom scripts do not appear to show in the Command menu (Mac)
Fix: Simple Find "<=" does not translate properly to a formula in Advanced Find
Fixed Name.Contact tab order
DC: folder.conf without max_connections param no longer results in 0 connections allowed
Fixed Import payment on invoice allowing overpayment against creditor
Make all currency fields available to Analysis reports
Changed FastNet export to provide better Code/Ref/Particulars for payer/payee statements
Transaction importing: Make it possible to instantiate a calculated-only detail line (i.e. no detail fields being imported).
Fixed handling of transactions with very large amounts of text in many details (>32K of text). Symptom = crash.
Deposits on Orders: Where DEPOSIT product has exempt GST and deposit is 100% of order, the resulting invoice does not balance.
Product Sales Enquiry: Advanced Find gives simple find dialog. workaround is to hold down option key and click Find. Same with Name sales Enq
Printing Transaction list containing payments/receipts on invoice prints incorrect information when "Faster Networking" is enabled
work-it-out disabled for name.accrec/pay when importing trans even though it _defaults_ to work-it-out
Fixed bogus "Currency delta self test failure" on posting
Currency delta self test failure - but posting is restored by session restore. Fix so bad posting is not restored.
Products - History - Historical - Value column in list has "ReportDate" as field name
Centering of windows broken on Mac new install: rego screen and nav come up partially off screen on small screen
Datacentre crashes in NextCPNumber()
DC client does not get correct std plugins for locale - always gets NZ plugins
Recurring Transactions Datacentre: Do not recur when you open a new period using Period management
Canada 2 tier tax: "All GST" doesn't calculate properly on invoices (or GST Report!)
Datacentre Install Windows: does not create c:/MoneyWorks Documents/
gst report and multi-currency: need to show forex transactions in local currency
Job - Job Details - Target Date - accepts any date but reverts to current date on saving.
Plain invoice and statement: for non-base currency, doesn't show currency symbol
Sales Order Foreign Currency convert to Cash Receipt only gives base currency Bank choices (refer 0000738?)
Australian Tax Table: X rate (for export) is set at -0.01%
Form Font style corruption on Intel Macs
Debtors Reconcile Report showing as choice under Reports button on toolbar in Names list. This report no longer exists (part of Aged Debtors option now)
No Navigator Screen after scheduled (eg daily) software update check. Mac
New Windows install over v4, where v4 client was last quit while minimised -> locks up with no open windows after rego screen
sort by calculated column that includes function crashes moneyworks_daemon
Sales Enquiry for selected products: crash on Win. Have to do it quite a few times to reproduce
crash if report aborted due to other user posting connected via WAN; client does a profit and loss report - slow due to WAN performance error message "someone has posted something while the report was being prepared" (or words to that effect) client crashes
see What's new
Fix crash when autocompleting email address longer than 31 characters
Fixed incorrect behaviour when changing category codes via an import of chart of accounts with the new update option (would result in incorrect subsequent reporting of the category). If you have this problem, change the category code back to what it was.
Fixed a crash when attempting to run in server mode on some systems running Terminal Services (Win)
Improved performance of Reorder report (about 10x faster)
Improved behaviour of Work-It-Out for distributing payments to invoices in Import Payments. Import Payments no longer displays which invoices will be paid by the import, as this may be inaccurate in the work-it-out case when there are multiple payments against the same debtor or creditor.
Fixed backup archives to work with .fp7 files in Custom Plug-Ins
No longer try to show movemenent on Cash-basis reports (the hidden checkbox could still be left ticked).
Transactions shown in reports are now sorted by transdate/timeposted/ourRef instead of transdate/ourRef.
Fixed a bug in 4.1.9 that ignored requested number format for cells in custom reports.
Fixed incorrect behaviour of Receive Cheque from Creditor for Head Office creditors
Automatic assignment of a unique code to a new Name now more robust when existing codes are not of a consistent pattern/length.
Fix bug that allowed an invalid account code to be entered into a field by hitting Ecape in the choices list.
Don't force NZ bank account number formatting on other countries
Fix inactive scroll bar in invoice list of a receipt or payment after the following sequence of operations: clear debtor code; press tab; hit cancel; type debtor code; press tab
Fixed an issue where the next transaction reference number would reset to what it was at the start of a session if a network client visited the Open/Close period dialog box while other users were logged in
Importing from a script is now much faster
Remittance advice slips printed from the cheque run now show invoices in date order. Additionally, the cheque run no longer warns about continuing without having printed cheques when you have actually printed cheques.
Corrected typo in reprint GST report.
Fix crash when "printing" transaction list to a file.
Fix potential crash when evaluation expressions that are too complex. Now correctly report "expression too complex" error.
Storing passwords in Mac keychain now works again (broken in 4.1.7)
Reports showing Budget YTD for financial years more than one year in the past (for which budgets are not stored) no longer show garbage budgets.
The Rollback command now disables the Rollback button when all database transactions are selected (since this would just roll back to the current state - i.e. no change)
The MoneyWorks Gold Applescript dictionary is now recognised by Mac OS X Tiger.
Fixed a potential crash when printing some lists with very long description fields.
Fixed Dr/Cr Reconciliation report names in Names list toolbar.
Fixed an error when entering an '@' symbol at the end of the account code when specifying the write-off expense account for a writeoff.
Fixed the emailing of PDF custom remittance forms.
Fixed problem with very large transaction analyses.
Fixed new problem in 4.1.8 with batch creditor payments.
Enforce 500K limit on compressed size of plugins folder uploaded from a client
Compatible with Mac OS X 10.4 (Tiger) (Bonjour browsing, Mail.app, Date format warning for Tiger bug in N.Z.)
Fixed a (rare) database lockup when billing Jobs.
Ledger report for a range now sorts the accounts. Also a ledger report derived from a account enquiry from a range of accounts uses that range.
PDFs can now be dragged out of the forms designer.
No longer lose a receipt number in multi user mode after accepting a batch of debtor receipts.
No longer lose receipt numbers after cancelling a batch of debtor receipts which included allocation of a previous overpayment.
The field parameter in the SumSelection function may now be an arbitrary expression. e.g.
SumSelection("Transaction.gross - amtpaid", "type = `DII` and status = `P`")
gross - amtpaid is treated as an expression evaluated in the context of each transaction
found by the search expression.
Fixed a bug in transaction importing which would fail to flag non-balancing lines as an error.
Honour stock unit conversion factor when importing job sheet items
Improve the warning in transaction importing when product code is invalid
The number of cheques is now shown on deposit slips
Fixed a problem with period menus in account enquiry when there are more than 90 unpurged periods.
Fixed an issue with allocating head-office overpayments to pay branch invoices.
Fixed an issue with dialog box scripting where mouse clicks could start to be ignored after executing certain script operations (Windows)
The ValidateForm method for attached scripts is now called when user clicks Next or Prev, as well as for OK
GetListField now works for the decription field in transaction details
New, empty documents can now be created from a script. The parameters are: the file to create, the balance date for the new document, and the date to which you want periods to be opened (which must be after the balance date, and within 10 years of it).
e.g. (Win)
All changes as above for Gold.
Accountants Export to MoneyWorks format and Save A Backup As are now supported for clients.
Fixes to Plugin location overriding
Fixed client download when web admin is password protected
Installation permissions compatible with Mac OS X 10.4 (Tiger)
Serving of documents in subdirectories of subdirectories is now supported. For ASP situations, this allows one level of hierarchy within each ASP client directory.
In the Administrator's Guide, in the Document Root section of Configuration Options, the number of directory levels which are scanned and served has been increased from 2 to 3, so the sentence "The Datacentre will share any MoneyWorks Gold document in this directory or in subdirectories or (but not subdirectories of subdirectories)" should read "The Datacentre will share any MoneyWorks Gold document in this directory or in subdirectories up to 3 levels deep."
Fixed crasher with new files created with 4.1.5
The PriceCode popup menu on the transaction entry screen (sales) now remembers the `Don't Tab Into` setting
Advanced OLE transaction importing features (replace and post) no longer lock up server when there is an error in the import. Additionally the return_seq option in same now works
Fixed contextual menus on Win98 (broken in 4.1.5)
GST finalisation now correctly pre-locks records (it may refuse to finalise if other users are modifying affected transactions—if you can a meesage to this effect, just run the report again and try finalising again.)
Bank Reconciliation discrepancy is now correctly recorded in log file
One-off addresses in transactions are no longer clobbered if you drill down into the Name
Report writer: A problem with Show Accumulator changing the accumulated valued for calculated columns is fixed.
Cash basis reporting. Custom Reports, and the Trial Balance report, can now be generated on a Cash Basis. There is a new check box in the report settings dialog box to select this option. Note: You can't include transactions on a cash basis (use the Cashflow report if you want transactions).
Include Unposted is now available in multi-user mode for Bank Reconciliation, Account Enquiry, and reports.
Invoices in the Batch Debtor Receipts and one-off invoice receipt entry screens can now be sorted. Very useful if you have a high volume of receivables.
[Datacentre] Clients can upload plugins to Datacentre server. This is done using the new Upload button in the report and form signing dialog box (File:Sharing and Users:Signing). Obviously you need the signing privilege to do this.
Support for printers with names longer than 31 characters on Windows. It is currently still a requirement that the printer names be unique in the first 31 characters.
Entering dates outside of your open period range is now much more difficult to do accidentally.
When Connecting, MW now remembers your preference for Manual or Bonjour
When a product has a sales account whose tax code is *, the Name's tax code override will no longer override the *.
When modifying transactions, the customer discount is now respected for cash sales as well as for invoices.
When sharing, the server is no longer advertised over AppleTalk on the Mac—only Rendezvous.
Replace command now works on Product.JobPricingMode
You can now import payments-on-invoices that include negative pay amounts against credit notes (provided the total payment amount is positive)
On Mac, you can now make proper internet shortcuts for the moneyworks:// URL scheme and click them to make a connection.
How to make a shortcut:
In Safari Bookmarks, click the + icon;
Type the address for your shortcut in the form described in /support.faq.php?art=url. This will most usefully be a Datacentre-style url, e.g. moneyworks://rowan:fred@zaphod.cognito.co.nz:6699?doc=Acme%20Widgets%20Ltd
Note that you can omit the password for the document if you have already stored the password in your Keychain (see below)
You can now start a connection by clicking the bookmark.
You can also drag this bookmark to the Finder to make a double-clickable shortcut document, however, Safari will create this document with a file extension of .inetloc, and this will not work due to a bug in the Mac OS X Finder (currently under investigation by Apple). You can make it work by simply renaming the file extension to .webloc. Double-click it to start a connection.
[Datacentre] Keychain is now supported on Mac for Datacentre logins. (MoneyWorks stores the server's IP address rather than its name in the Keychain, so you will need to use a dotted-decimal IP in any shortcuts you make so that it matches).
There is now an Update If Exists option for importing accounts. If you change the departmentalisation or type of an account, that will be ignored, but you can import changes to Categories, Accountant's Code, Description, Tax code, P&L account, and bank account number. This means that you can make changes on a copy of a data file then transfer those changes over.
The database is no longer locked for all users when one user is looking at the invoice they have just made in Bill Job.
Quotes, POs and SOs now remember your preferred colour
When addressing an email, you can now add all email addresses for a selection of names, instead of just one at a time.
The behaviour of type-selection in the account choices window is now much better: in particular, if you leave the choices list sorted by description it will fall back to treating what you type as a code if no match is found in the description column. Also if you type an account code that is departmentalised then bring up the choices, then the department list for the account will already be highlighted.
Dialogs for dept/group management are all now resizable.
The accountant's export command now has a reminder to tell accountant the username/password when user is sending a password-protected document in MoneyWorks format.
There is a (currently hidden) option to update ship quantities for a selection of Sales Orders. Select the sales orders, choose Ship Orders, then hold down the Option key (Mac) or Shift Key (Win) in the dialog box and the Process button will change to Update. Click it with the key held down to update the ship quantities on the orders en-masse, from the top down.
The lines on reports (underscores, overscores etc) should now look better (thinner) when previewed/printed (Mac)
decimal-aligned columns in reports now get right-aligned headings
There is a new preference option to turn off the "Update ship quantities?" query you get when opening an existing Sales Order with backordered products.
Changed the StockValue column display (if you have added it to the Products list) to show actual stock value rather than average value.
The A and B budget tool icon is now a pop-up menu since having an A and a B icon confused people.
The NumToText function now takes an optional format argument. The format is a number from 0 to 13 which denotes the format to use for the number. See the Apply Format popup in the calculation box to figure out the number you need (0 is 0;-0, 1 is 0.00;-0.00, 2 is 0;(0) etc).
Printing and fonts on Mac: MoneyWorks will now always override a printing font preference set to Geneva, and change it to Helvetica. This is because Geneva, when printed, comes out with extremely ugly letter spacing, particularly on OS X. Also, for a new installation on OS X, the default list view font will be Lucida Grande 10, not Geneva 9.
Reduced the volume of the sounds on Mac by 5dB (already did this on Windows for 4.1.2)
Custom movements in reports (unsupported): If there is a file in the same folder as the report with the same name but with a ~ at the start, then the columns in the ~ report are used to define the format for showing transactions in the report. The ~ report should contain just calculation columns. These calculations may reference the transaction and detail fields. Will be properly supported in v5.
The 4.1.4 export syntax allows the 'filename' parameter to contain formatting information that specifies what is to be exported:
export "Filename[.sortfield[-]][#formatstring]"
sortField can be included to sort the export by that field
sortField can have a "-" appended to specify descending sort
formatstring can specify what to export. Everything in the format string is returned verbatim except for anything inside [...] which is treated as an expression which can reference the fields of the file being exported. Thus if you want tab-delimited, then put tabs between the expressions. You can use metacharacters \t \r \n \xHH (hex) or \\. Note that since Applescript expands the same metacharacters, you are best to use meta-metacharacters in applescripts, e.g. \\t \\r \\x0a etc
examples (Applescript)
export "Name"
same as usual
export "Name.Code-"
export in usual format but sorted descending by code
export "Name.Code-#[Code],[Phone]\\r"
export code and phone number separated by a comma with lines delimited by a Return character
export "Name.Code-#\"[Code]\",\"[Phone]\"\\r\\n"
as above, but fields are quoted, and line delimiter is MSDOS-style
export "Ledger.concat#\"[AccountCode + if(Department != ``, `-` + Department, ``)]\",\"[Lookup(AccountCode, `Account.Description`)+ if(Department != ``, ` (` + Lookup(Department, `Department.Description`) + `)`, ``)]\",\"Y\",\"[Lookup(AccountCode, `Account.TaxCode`)]\"\\r"
exports account codes in banklink format
Added ?path option for importing and exporting on Windows: If file path stars with ?, use it as default but put up a dialog box (the given filename extension in the path will be respected)
MoneyWorks 4.1.5 incorporates fixes for two bugs that were present in v4.1.4:
1. The General Deparmental (nz) chart of accounts was found to be faulty. Specifically, the Profit and Loss account attached to IN and EX accounts did not exist. 4.1.5 will automatically fix this condition.
2. A problem with the improved behaviour of the account/depratment choices window has been fixed.
Double-clicking a transaction in the Account Enquiry now has the correct menu command names for Modify etc in the Edit menu.
Reminder Messages will now come up at midnight again if you leave MW on overnight.
When changing the type of a name between, say, Customer and Debtor, the control code fields now enable properly.
Fixed receipt number skipping when you edit a previously entered receipt in Batch Debtor Receipts.
Fixed a bug that could cause a receipt to go haywire in Batch Debtor receipts if another user posted a new invoice for a debtor dated earlier than the ones that have been set to be paid in the batch before the batch is accepted.
Fixed a data-corrupting bug with cancelling payments on invoices when related invoice is locked by another user
When updating Sales Order ship qty, ignore negative order qties, else end up backordering them
Fixed Age Debtors in multi-user mode
Disabled the recurring option for stock journals.
Fixed crasher in ImportFile from VBS scripts
Better error message when opening read-only files on Windows
[Datacentre] Custom column settings now get properly stored per-user: You must turn on users/passwords for these to be stored.
Typing into combo boxes to select an item works better on Windows
PostedBy now gets cleared when you Duplicate a transaction
Importing payments on invoices now sets the AmtPaid field properly
AmtPaid is now set properly on batched writeoffs
Forms design submenu enabling was broken on Express/Win.
Made importing payments on invoices safer in multi-user
Eliminated some spurious list redraws when editing transactions etc. This makes a big difference when you are running over a really slow internet connection.
When you open a different document, the default reporting period will reset to the current period for the new document instead of being something random.
Fixed "Help On This" on Mac (and added it to context menu)
Fixed crasher when hit Enter with a user selected in the Signing dialog.
[Datacentre] Fixed Signature Revocation for reports and forms (plus it is now instant, rather than next-login)
Job sheet entry now properly separates departmentalised cost accounts into the account and cost centre fields