Job Cost - Cost Spreadsheet not Summarizing Correctly

SOLVED

Hi Everyone,

I am having an issue where Job Cost is not summarizing the entries correctly. Here is an example. The summarized view of the cost spreadsheet shows $81,980.18. However, when I click inside it only totals to $51,064.45, which is the correct total and ties to the GL.

Cost Spreadsheet Summarized View ($81,980.18):

Entry Level View ($51,064.45):

If I pull the Job Cost Data in an ODCB connection it all totals out to match the GL as I would like. Not sure what the issue is here.

  • 0

    When looking at the drill-down display you show above (where only Category 20 data is shown), click the "Filter" icon to observe the conditions applied.  The standard condition is that "Accumulate as" = "Labor".  You may have multiple categories that are defined with "Accumulate as" set to "Labor," other than your Category 20.  See if there is an additional filter applied on this drill-down that limits the display to Category = 20.  

  • 0 in reply to Art Minds

    That made sense to me to I tried removing all of the filters, but it did not change anything.

  • 0 in reply to syarian

    If removing all filters doesn't display any additional information, something is drastically amiss.. Removing all filters should display every transaction for the entire job, including Dollars Paid transactions in addition to Cost Transactions, and the display would not be limited to the single Category. 

  • 0 in reply to Art Minds

    This is a new company that we have not been cutting checks out of so there is nothing of that nature, but here is a screenshot with the filters removed. Maybe, this is not what you meant?

  • 0 in reply to syarian

    Have you tested removing the conditions on another job or cost code to confirm that other transactions appear, such as Material costs or Equipment Costs? I notice that the data in the "Transaction Type" column is "JC Cost". So you are not using Sage 300 CRE Payroll?  A transaction type of "JC Cost" means the entries came from JC > Tasks > Enter Direct Costs.  Go to GL > Inquiry > Transactions and look at your NEW file to see if there are transactions that haven't posted in General Ledger that originate in JC when you entered those labor transactions.  Also confirm that there are no unposted transactions in Job Cost by doing a similar inquiry against the NEW file.  If you are certain that all transactions are properly entered and posted, and as you say Job Cost is in balance with General Ledger, then your system may have had a hiccup when posting to Job Cost and the accumulator totals on the category or cost code records may not have updated correctly. Confirm the current month of your Job Cost module and the GL module. Job Cost can only post one month into the future. Do you review the "Close Month" report when you close the month in Job Cost? That will reveal if the accumulators on a job are out of balance. 

  • 0 in reply to Art Minds

    Thanks Art. We do not use Sage 300 Payroll. These companies are very simple and we are essentially just billed by our corporate office. All of the information in these companies is simply the following and are just JE's:

    Dr. Job Cost

          Cr. Due to/from Related Party

    I have a Job Cost and GL ODBC reports I tie out to each other each month so I have not been using the Close Month Validation Report in the past, however, it seems to have found the issue. Not sure how this is possible, but the Transaction Cost is not equal to the JTD cost and this is our difference. Do you know how I can correct this? The Transaction Amount it the correct amount that ties with the GL.

  • +1 in reply to syarian
    verified answer

    You will find detailed instructions for making this correction in Knowledgebase Article ID 104598. 

  • 0 in reply to Art Minds

    Thank you! That took care of the problem