In the Job Cost Report the "Actual Cost" column is not displaying the correct value for individual items. I investigated the issue by looking at the "Transaction Detail by Account" in Quickbooks and found that the report appears to be only picking up the debits and not the credits from the Qucikbooks database. How can I get the report to show the actual balance for each individual item? \\
The previous question was answered via live chat. The solution was to filter out a particular account by type.
If you run these reports in QuickBooks:
QQube works similarly. There is a field in the Account Folder called 'is a job cost account' meaning that if it is set to 'Yes' it will filter only for PandL; set to 'No' then all accounts.
Choose a location