Comparing, Combining, and Contrasting Accounts
Imagine
that you had one accounting system until the end of 1997. You
switched in 1998, and there were some slight differences in the new
chart of
accounts that grouped things differently at a high level, in addition
to merging one or two existing accounts. Not being administratively
perfect, you didn’t get it all set up on the first of January,
and there is an annoying discrepancy at the changeover point you
can’t figure out. Export scripts can be written to get the data
into BookSets. A dictionary can be prepared that
maps account names in the old system to account names in the new one,
and then both sets of data can be merged. Ad hoc queries using an
interactive prompt also make it easy to see where data doesn’t
match.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access