That pivot table was so seductive. It made it easy to get your data out when all IT would give you was a huge data dump. The boss was happy. And the numbers worked fine. So, why worry?
But then next month, someone asked you to combine that data with a dump from another system. What harm could there be? Just a simple VLOOKUP? You didn’t even have to copy… Read More »
I’ve written before about the importance of having good processes to get good data (for example, not making sub-ledger entries in the general ledger).
The importance of good processes was underlined to us again recently when writing some complex Crystal Reports against Sage’s Timberline construction software for a client.
I’m not a Timberline expert, but I’ve done my fair share of job costing/project management over the years, and the same… Read More »
My son is learning how to play the piano. As I’m paying for the lessons, I insist that he practice. He doesn’t really like practicing, even though the piano lessons were his idea. Therefore, he asked me to write about why practice is important. And as practice is also relevant to business, it makes a good topic for a blog post.
In our daily lives, we do things for multiple… Read More »
While I’m certainly not a CPA, I’ve spent most of my life working with financial reporting and accounting departments. So, I like to keep on top of changes in GAAP and IFRS. Over the last several years, standards organizations have been discussing changes to accounting rules surrounding leases. (For an overview, see Compromise for Lease Accounting Overhaul Starts to Fall Apart in The Wall Street Journal.)
For the layperson, it’s… Read More »
A case study is worth a thousand opinions. Recently, a client came to me with a quote it’d received for the implementation of the newest Lawson security. The quote was $50,000.
My contact at the company was shocked. So was I.
I said I’d be happy to offer the company training. The client already has in house people to do the Lawson security setup, so I didn’t think I’d need… Read More »
“Happy families are alike; but every unhappy family is unhappy in its own way.”
– Leo Tolstoy, Anna Karenina
“Every successful company is successful for a different reason; but all successful companies have some part of their business where they’re only mediocre.”
– Adam Jacobson, Red Three Consulting
Over the years, we’ve worked for some very successful companies. And these companies are successful for different reasons. But all these companies… Read More »
Lately, we’ve been working with some clients on currency in Oracle EBS, which has revealed a few limits of the Oracle system. In this post, I’ll detail some of them as well as our solution.
If you need a refresher on general currency translation, review Understanding Currency Accounting: Revaluation and Translation, which lays it out in detail.
In brief, translation is a way of consolidating a company’s many operations into… Read More »
In a perfect world, you’d have a mature organization with a limited number of ways to roll up your accounting flex field segments. As such, you could cover most of your reporting needs through the main roll up hierarchy or perhaps through an alternate hierarchy.
But often, that’s not the case. Many times, you want to group parts of your accounting flex fields in multiple ways. For example, if you… Read More »
People hire me to help makes things more efficient, whether it relates to reporting, accounting systems or business processes. And sometimes, I help people “get out of the weeds” and focus on the big picture.
But, as with everything, there has to be a balance. As my company grew, I was sometimes too focused on the big picture. I delegated much of the busywork to others so that I could… Read More »