Finding Job Cost Records

In the MacNail construction accounting software, you can use the Query Box to find specific vendor expenses or other accounting info.

For example, to find all items purchased from Wickes Lumber for the Matthews job:

1. Type 4 into the criteria under job #, if it is not already there. Use the Delete or Backspace key to clear any other items that are already in the criteria.
2. Type 2 into the criteria under biz #, and press the Enter key.
3. You can type command-F to see the specific items individually, or use *Extract Special to put all matching items into a separate file.

To find all items in invoice #1264:

1. Clear the Criteria with the Delete or Backspace key.
2. Type 1264 into the criteria under invc #, and press the Enter key.
3. You can type command-F to see the specific items individually, or use *Extract Special to put all matching items into a separate file.

To find all materials items costing more than $200:

1. Clear the Criteria with the Delete or Backspace key.
2. Type >200 into the criteria under total, and press the Enter key.
3. You can type command-F to see the specific items individually, or use *Extract Special to put all matching items into a separate file.