TimeTrak is a service management software/website that ties into ERP (Accounting) packages and allows for easy coordination of staff/management of tasks. I wanted to have TimeTrak open the tab for any client I was talking to whenever I answered my phone. My work uses 3CX to manage our telephony, and I figured that meant I […]
Monthly Archives: May 2019
MYOB Exo Business – Faster Creditors Recalc script
The logic of the last two posts extends to Creditor Recalculations, which can be done fast using the attached script.
MYOB EXO – Stored Procedure to recalc GL (Fast)
The standard utilities for Exo are slow to recalculate GL Balances and movement. This is because: They delete records line by line, which gets really slow for the GLMovements table in most databases. They take forever to update the resulting data, because most Exo functions work on a line-by-line basis, rather than calculating as a […]
MYOB Exo – Useful SQL Server Scalar Functions
The following are a collection of User Defined Functions I’ve found variously on the Internet. I use these extensively now to do simple data transforms when pulling reports, such as converting all line breaks to pipe characters so that copy/paste into Excel works nicely. Behind the cut I’ve got several functions, and they’re all wrapped […]
MYOB EXO API – Simple Test Script in Powershell
This will be primairily of use to Exo Consultants who need to verify what data an endpoint produces, or to Developers just getting started with the API who want to see what a very simple formula might look like. It’s worth noting that like most long-time Exo consultants, I’m so comfortable with database calls that […]
MYOB Exo API – Some errors explained.
This post will be a catalogue of errors I’ve had interacting with the MYOB Exo API, and how to resolve them. Code: Unable to load ModuleSecurity for ‘appid=4400’Appears: Error appears when doing any requests apart from discovery.Meaning: The module ‘4400’ is unlicensed. 4400 is the API.Resolution: Make sure the API License is loaded in Exo […]