Duplicate query results is extremely frustrating, but are they really duplicates ? When a record appears more than once, it could be that the record meets the query criteria multiple times or the output includes one or more one-to-many fields . The good new is, when you use the query as a filter in reports...

No I'm sorry to say I don't have an answer to the gas price crisis, but I do have good news about city names. Do you have slightly different ways of spelling the same city in your database such as North Pleasantville, N Pleasantville, and N . Pleasantville? Have you steamed "it's all...

Trying to locate the one query amongst dozens or hundreds can feel like finding a needle in a hay stack. If you hate searching through all of your queries, t he answer is in the upcoming release of The Financial Edge version 7.77, due out in Quarter 4. After updating, you can create categories, or directories...

If your fiscal year ended June 30, you may suddenly start receiving errors such as Period Closed or Period Not Found when posting to General Ledger. These errors happen when transactions post to a hard-closed, soft-closed, or an undefined fiscal year. To resolve the error: Review the Batch Validation...

Would you like The Financial Edge to work more for you as a user? You can define options and preferences to customize the look of screens and establish a wide variety of default values. These settings not only make your workday easier but more efficient. But wait, there's more...your options follow...

Have you ever found yourself in a situation where you're looking for a transaction but it's missing from the Activity tab of the record? You know the charge exists because you're the one that added it or you've seen it before, but where did it go? Where's Waldo's transaction?...