Using a standardised naming convention for import files makes it simple to identify them later on. Continue reading “A naming convention for import files”
There are various times when it is useful to be able to compare the data in two or more separate records from the same table. For example when you have imported a change to a record, you should make a copy of it before you run your import which you can then use to compare with the same record after the import. Continue reading “Excel – Comparing records”
Some people seem to love reinventing the wheel – why learn from others’ mistakes when you can learn the same thing from your own? Continue reading “Some best practice rules for Maconomy implementers and administrators”
I spend my working life implementing Maconomy, BizView, and other ERP and data analysis systems, and I often have to clean and prepare data sets for importing to database tables. This nearly always involves constructing a clean data set in an Excel sheet – often from more than one source – and for this work there are a number of methods I use time and again. Continue reading “Excel – Testing Equivalences”
#,###.00_);[Red](#,###.00);-_);[Red]"Invalid – numbers only "@ Continue reading “Excel – Useful Custom Cell Formats”
A System Accountant (SA) is a jack of all trades and a master of some; prepared to turn his or her hand to any aspect of getting a system live and keeping it running. He or she is trainer, analyst, PM, developer, runner, author, data cleaner, converter, build manager, troubleshooter, lateral thinker, problem solver, explainer, diviner, mind-reader, demonstrator, experimenter, and pioneer.
There is no particular formalised training path for the role of System Accountant, but there are essential elements for anyone wanting to become one.