MoneyWorks Blog

 

Ostendo release MoneyWorks Integration

Ostendo is “Operational Software” that includes advanced features for inventory, manufacturing and jobbing, and which now offers seamless, real-time integration with MoneyWorks Datacentre. In effect, Ostendo becomes an operational front end to MoneyWorks, adding powerful functionality for distribution, engineering and manufacturing, including:

  • Serial Number/Batch Tracking
  • Inventory and Purchasing
  • Landed Costing
  • MRP and Inventory Replenishment
  • Enhanced Job Costing and Projects
  • Labour, Timesheets and Job Tracking (includes Constraints Scheduling)
  • Distribution, POS and Service (includes Asset Preventive Maintenance)
  • CRM, Call Centre and Quoting
  • Manufacturing and Assembly
  • Configured Custom Products including Features and Options

Like MoneyWorks, Ostendo incorporates powerful custom reporting, graphical workflows, advanced scripting, and access from mobile devices, thus allowing for a high level of customisation to meet specific user requirements. For more information, visit www.ostendo.info or call +64-9-525-3612.

Posted in Uncategorized | Leave a comment

MoneyWorks Tops Accounting Reviews

MoneyWorks Gold 7 was named “top choice” in a recent review of accounting systems in the USA, beating out QuickBooks and AccountEdge (formerly MYOB), and earning 4.5 points out of a possible 5. To read the full article, click here

Posted in Accounting, News, Uncategorized | Leave a comment

Importing Bills of Materials

It’s been possible to import a bill of materials (BOM) into MoneyWorks since about MoneyWorks 3. However it always had to be done using some sort of script (AppleScript on Mac, vbScript on Windows), as there is no user interface for it in MoneyWorks.

However it is relatively easy to add an Import command by using a Report Script, and this also has the benefit of being cross-platform (Report Scripts were covered in this earlier post).

The sample report script below will read a text file consisting of three columns (no headings):

  • Parent Item Code: The item code of the product that is being built
  • Quantity: The quantity used of the component
  • Component Item Code: The item code of the component used

The line of the text file must contain these three values (no blank rows), and the file can be either tab or comma delimited (you specify when the report script it run). Note that you cannot edit an existing bill of materials for an item; it is completely replaced by the components and quantities specified in the file (which must be ordered by Parent Item Code). Also note that no checking is done: if the items or components do not exist (or cannot be used in a BOM) the import will silently fail.

To act as a report script, the “Import Bills of Material.crep” file must be placed in your MoneyWorks Custom Plug-ins/Scripts folder (unzip it first). You can then run it by choosing “Import Bills of Material” from the Command menu in MoneyWorks Gold/Datacentre (requires MoneyWorks 7 or later).

Download

Import Bills of Material.crep.zip

Posted in Technical, Tips | Comments Off

MoneyWorks 7 Unicode support

Up until now, MoneyWorks has used the native “code page” text encoding for the platform it is running on, and as these are different on Mac and Windows, accented characters have not translated between platforms, and support for special characters has been limited. In v7, all text is encoded as Unicode, so the full gamut of non-Roman and accented characters, ideographs, and other special symbols can now be entered into the database and are preserved across platforms. Files created on earlier versions will be converted when first opened in v7 (and if the file contains accented text, be sure to do the conversion on the same platform that the file has been used on, since that platform’s default pre-unicode encoding is what the file uses).

If you’re not accustomed to using accented characters, here a few tips for typing some common accents on a standard “US”-style keyboard.

Mac (using the US, Australian, or UK keyboards):

To get acute and grave, type option-e or option-`, then the vowel you want to receive the accent. E.g. for é, type option-e then e. For è, type option-` then e. Here are a few more:

              for       type…	
               à	option-`, a	
               ç	option-c	 
               è	option-`, e	 
               é	option-e, e	
               ê	option-i, e	 
               ë	option-u, e
               î	option-i, i	
               ï	option-u, i	
               ô	option-i, o	
               ù	option-`, u	
               û	option-i, u	
               ü	option-u, u	  
               ñ	option-n, n	  

If you are running Lion, Mountain Lion, or Mavericks, you can just hold down the key you want an accent on, and a popup will give you the options:

Screen shot 2013-11-10 at 11.55.11 AM

Press the digit key for the character you want.

Windows (using the US, Australian, or UK keyboards):

For the occasional accent, and without changing your keyboard settings, you can type the “alt code” for the character you want. Here’s how:

  • Hold down the left-hand ALT key;
  • On the numeric keypad, type the 4-digit alt-code for the character you want;
  • Release the ALT key.
                        code		                code
               à	0224	               À	0192
               ç	0231	               Ç	0199
               è	0232	               È	0200
               é	0233	               É	0201
               ê	0234	               Ê	0202
               ë	0235	               Ë	0203
               î	0238	               Î	0206
               ï	0239	               Ï	0207
               ô	0244	               Ö	0212
               ù	0249	               Ù	0217
               û	0251	               Û	0219
               ü	0252	               Ü	0220

If you need to type quite a few accents, you might want to consider using the US International keyboard. See Using US-Int’l Keyboard Layout to Type Accented Characters.

Macrons for Māori

For our New Zealand users, who may need to type Māori long vowels, here’s how:

First, enable the Maori keyboard:

  • Mac OS X 10.6—10.8:
    System Preferences → Language and Text → Input Sources. Scroll down the input methods and click the check box next to Maori, and make sure the option “Show Input menu in menu bar” is turned on.
  • Mac OS X 10.9 (Mavericks):
    System Preferences → Keyboard → Input Sources. Click the +, select Maori from the list of input methods and click Add. Make sure the option “Show Input menu in menu bar” is turned on.

Now you can select the Maori keyboard from the menu next to the time in the menu bar. With this keyboard selected, just type option-a, option-e, option-u etc to get ā, ē, ū, …

Posted in News, Tips | Comments Off

MoneyWorks 7: Easier, faster search

MoneyWorks 7 is now available, so we’ll be posting some articles on how to make the most of the new features.

While Moneyworks has always had quite powerful searching, it was not sufficiently accessible to users who did not know which field they wanted to search on. These days people are used to near-instant results from a browser search bar. So that is what we now provide. The new search field in the toolbar does a fast asynchronous full-text search (including sticky notes and transaction details).

The Cmd-F or Ctrl-F keyboard shortcut now activates the search box in the toolbar. Just type a word and MoneyWorks instantly starts searching the full text of the records in the list. As usual, the search applies to the current view, and the currently selected filter, if any. For moderately-sized data files, the search will be instant. For very large files, it may take a little longer, but results will be added to the list as they are found, and you can continue working as the search proceeds.


The new search box. The filter popup is on the left; type in your search term.

For users who want more control over searching, the usual Find by Field and Find by Formula are still available. Just press Cmd-option-F (Mac) or Ctrl-Shift-F (Windows) to bring up the usual search dialog. This mode of searching has also been improved for network users: Even very complex searches are now performed entirely on the server, for faster results and less network and server load.

For more details on the new searching, see Finding Records using the Search Box in the new online manual (Yep, the entire MoneyWorks 7 manual is available on the web).

Posted in News | Comments Off

British Columbia change back to PST

On April 1st 2013, British Columbia is reverting to the more complex PST tax system, reversing a change to the simpler HST environment adopted a few years ago.

As this is a structural change in the tax system, you can’t just change the HST rate to the new GST+PST rate. Instead you must set up a new tax (or, for users who have had MoneyWorks for several years, reinstate the old one).

We have prepared a document which discusses how you can change your MoneyWorks file(s) to implement PST. It would also be a good idea to refresh yourself on how MoneyWorks handles taxes by revisiting pages 202-206 of the MoneyWorks 6 Manual (available under the Help menu in MoneyWorks).

Download the PST Reimplementation Notes as a PDF.

Note: The notes were updated on 26 March to include a section on changing your MoneyWorks Locale to “PE” so that the standard invoices would print with PST and GST instead of HST.

Posted in News | Comments Off

Mountain Lion Compatibility

MoneyWorks 6.1.1 and later are compatible with Mountain Lion (Mac OS X 10.8).

Earlier versions of MoneyWorks 6 (and MoneyWorks 5) may or may not work on Mountain Lion.

MoneyWorks 4 and earlier are not compatible, as they require the now discontinued Rosetta compatibility layer (which means that these older versions were not compatible with Lion either). Users of these old versions need to note that they must upgrade their MoneyWorks (and their data files) before upgrading to Lion/Mountain Lion, as the data conversion also requires Rosetta.

Mountain Lion Installation Note

MoneyWorks does not at this stage support Gatekeeper, the new security system on Mountain Lion. To install MoneyWorks therefore you will need to right-click on the installer and select Open, instead of double-clicking. This will give you access to the Open button to override Gatekeeper

We will add Gatekeeper-compatible signatures to the next update release of MoneyWorks.

Information on Lion compatibility is available here.

Posted in Uncategorized | Comments Off

Daylite 4 and MoneyWorks

Congratulations to the team at Marketcircle on the release of Daylite 4. I was privileged to attend their Partners Conference in Toronto last October, and was hugely impressed by the look and feel of this new version.

For the many MoneyWorks users who also use Daylite, you should read the before you upgrade information provided by MarketCircle. In particular, you need to be aware that the new version of Daylite does not support the existing Connectors, including MoneyWorks. From their website:

Daylite Connectors
Daylite 4 does not currently support the 3rd party connectors. We are exploring a new, REST/JSON based API for connectors in the future. We’ll maintain the API and we’ll guide 3rd parties on how to make and maintain connectors. This new mechanism will allow for much better integration opportunities.

We’re looking forward to working with the team at MarketCircle to provide even better connectivity between Daylite 4 and MoneyWorks. But this is a major project which will take months, so please be patient.

If you are not familiar with Daylite, it is sort of a “CRM system on steriods” for Mac, and manages customers, projects, meetings, tasks, emails etc.

Update: The new connector for Daylite 4/5 is now available — see the Daylite Connector page.

Posted in Uncategorized | Comments Off

Mobile Access with MoneyWorks Datacentre 6.1

The advent of smart devices (iphones, ipads etc) means that mobile connectivity is becoming more and more realistic. In the release of MoneyWorks Datacentre 6.1 we have included two sample mobile apps which provide direct communication over the internet with MoneyWorks Datacentre, eliminating the problems of data synching, which is the bane of most mobile solutions. These samples are intended to illustrate what can be accomplished using MoneyWorks.

The two “webapps” we have provided are:

Reports: An app that will generate and display a nominated report in real time. Any report created using the MoneyWorks Report writer can be displayed; this includes any of your own specially developed reports, as well as most of the standard report. So now, when you are out on the road, the latest information is always available, whether it is sales information (what is the purchasing history of the customer I am about to visit), management information (how did the business perform today?), or traditional financial reports.

Timer: A timer application that allows you to record time and materials against jobs – simply tap a job to select, then start the timer or record materials used. The information you enter will go live into the job system back to your Datacentre, ready for collating and billing. Ideal for people selling time and expertise (consultants, tradespeople etc).

List of current jobs on iPhone

List of current jobs

Performance is astonishingly fast. I was recently in Vancouver, and it took just a few seconds to display a sales report generated live in Auckland, 11,000 kilometers away on the other side of the Pacific.

Of course there are limitless other possibilities for this technology, such as direct order entry, invoice creation, point of sale and more, with a number of developers already working on specific solutions for clients. It is all very exciting!

Our sample apps are written in javascript and html5, so can be easily modified by others to meet your specific requirements. They require an active internet connection to work. For more information on these web apps and how to access them, please download this pdf. More technical developer information can be found on the Developer Page.

Posted in Uncategorized | Comments Off

Developer Documentation

For developers interested in integrating with MoneyWorks Datacentre, there is now new developer documentation on the Developer page for the new REST (HTTP) interface introduced with Datacentre v6.1.

Posted in Uncategorized | Comments Off