An example of how the conditions are added to a report can cause erroneous information can be found by doing the following:

In Construction Sample Data, go to Job Cost and Run the Job Cost Billing Detail report. (Report/Billing/Job Cost Billing Detail).

Add a condition for Cost Code equal to 1-040.

Add another condition for Cost Code equal to 1-580. (use the OR function when adding this cost code). The report will display inaccurate information and entries will "appear" to duplicate, however can have different accounting dates, amounts etc.

Add your "OR"conditions before the "AND" conditions and the report will display correctly.

OR conditions must be before AND conditions.

In general, add the conditions with the OR connectors first when adding conditions on Reports or Inquiries.

Note: Conditions are evaluated in order from top to bottom in the Condition Selection window. You may have difficulty setting up a condition with multiple AND and OR statements. Consider creating a formula for use in the condition to ensure the condition works properly.