Inventory Used in Project Job Costs

Problem

Inventory Used amounts are not showing up in the report under Reports--Projects--Project Job Costs.

They appear in all other job costing reports, but not this one.

Caught By

User bug report.

Workaround

None.

Solution

This problem is fixed in Goldenseal 3.8. That report now combines material purchases and inventory used amounts in the Materials column of the report.

NOTE-- If you have customized the Project Job Costs report, this bug fix will not take effect in your file. To update to the latest version, use the Custom Layouts command to open the report, then choose Revert to Original from the File menu. You'll then need to re-enter any changes you made to the report.

Technical Details

We have added two new calculated fields-- Date Range Inventory Used, and Date Range All Materials.

If you'd like the report to show material purchases and inventory used separately, follow these steps:

  1. Choose Custom Layouts from the Options menu, and choose Reports from the submenu.
  2. Enter Projects into the Area popup field at upper left, and enter Project Job Costs into the Report popup field.
  3. Click in the report table and select the Material column.
  4. Choose Delete Column From Table from the Edit menu.
  5. Choose Add Column to Table from the Edit menu.
  6. In the list of fields, choose Date Range Materials.
  7. Double-click on the new column, and change the title to Materials.
  8. Choose Add Column to Table from the Edit menu.
  9. In the list of fields, choose Date Range Inventory Used.
  10. Double-click on the new column, and change the title to Inventory.
  11. Hold down the Alt key (Windows) or the Command key (Mac) so the cursor changes to a hand. Click on the new columns, and move them so they are after the Labor column.
  12. When the report's appearance is the way you'd like, choose Safe from the File menu.