The logic of the last two posts extends to Creditor Recalculations, which can be done fast using the attached script.
Category Archives: Database Functions
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 […]