RSS

Database Structure

Maybe you hope to bail out of work early on Friday for the long holiday weekend, well if so then Murph has some 'light reading' to occupy your end-of-summer fun time. Read more

General Ledger

Murph looks at one of the 'data utilities' that professionals use for extracting data from QuickBooks (Desktop) into external databases such as MS-SQL or MS-Access. Read more

Vendor Corner 4 Comments

Murph is known for his QuickBooks Desktop Database understanding. But did you know he has been studying the QuickBooks Online Database as well? Join him as he shares the fundamentals of the QBO Data Structure. Read more

Training and Live Events

When we learn how the QuickBooks Database Server can use various combinations of the ADR files to identify missing data, and restore it, we can easily see the great value this feature poses in many corrupt file situations. Read more

General Ledger 2 Comments

The QuickBooks Point-of-sale Clean-Up Company Data utility repairs transaction and list damage in your data file, but it is limited to damage it is programmed to fix. This article examines the use of that utility. Read more

Payroll & Merchant Services 1 Comments

When using multiple different Apps linked to QuickBooks potential problems are lurking in the dark, like a strong wind ready to blow the pieces of your jigsaw puzzle to the far beyond. Read more

General Ledger 2 Comments

Is it Door Number 1, Door Number 2 or Door Number 3?

Is it Door # 1 - Application, Door # 2 - Installation or Door # 3 - Data?

Ways to detect if your QuickBooks data-file is the problem. Read more

General Ledger 5 Comments

Our old sleuth takes on 'names on target not internally consistent' in this edition of the Data Detective. Read more

General Ledger

QuickBooks Custom Reporting

How many reports can you get out of QuickBooks - Never Enough...

QuickBooks does a good job of collecting the data, but does not always return the information the way the user wants or needs it. That is where custom reporting tools come in, this series will explore many of those tools in summary and detail. Read more

Vendor Corner 1 Comments

Both Windows and QuickBooks are responsible for the fragmentation affecting your Company File performance. Read more

General Ledger 5 Comments

Understanding how QuickBooks source and target data as well as report filters work are essential to your ability to properly use the QuickBooks reporting function. Read more

General Ledger 2 Comments

This Techno Topic article explains the basics of the database concept of Indexes, and various ways QuickBooks uses indexes to streamline user queries and searches for information. Read more

General Ledger

The first of a series of articles on the design of the QuickBooks database. Read more

General Ledger

300 Opaque Ad Separator

300 Opaque Ad Separator

300 Opaque Ad Separator

300 Opaque Ad Separator