x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 240 subscribers
  • Views 284 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
summer ranson

Direct Cost - Labor in Cost Based Billings

Posted By

We are trying to get lines of labor into our T&M cost based billing jobs.  We enter the labor through the JC Direct Costs table using category (L).  The transaction date is the date worked, the accounting date being end of the work month.  We are trying this for both November and December, both months still open.  When we go into the cost based billing table, the lines for those entries are not there (Generating and re-generating WIP) .  The hrs are showing on JC Exec summary though.  We have checked to see if anything is hung up and not posted.   We did a test by entering equipment (category E) this way and those costs went through no problem. 

We are fairly knowledgeable with both JC and Cost based billings but not PR and are now completely out of ideas. 

Thanks in advance. 

  • 0

    Hi Summer,

    You want to review your Job Cost Enter Direct Costs journal to see if the entries were sent to billing, and if so if there are any rejections from Billing on the journal.

    You also want to review the Generate Work in-progress journal for rejections.

    If you aren't finding anything, you can go to Billing, Reports, Cost-based, WIP Reconcilation report. Select all 3 files and condition for the job. You should see the labor entries there. Check on the left for WIP ID. If the WIP ID is blank, then the costs were not sent to Billing. If they weren't sent, you can check here to see what might not be set up correctly:

    https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=223924550037007

    If there is a WIP ID, check the  report for Contract, Contract item, or Billed amount. If any of those are populated, the costs generated and are either in the Unbilled, Billed, or History file. Rerun the report selecting one file at a time to see which file they are in.

    If there is a WIP ID and there is no contract, contract item, or billed amount, then the entry is either in the new file waiting to be generated, or it was deleted. You can review the new file by going to Inquiry, Transactions.

    If you don't find it, it was deleted. I would suggest entering the cost again in Job Cost and checking the journal to see what it says.

    Thanks!

  • 0 in reply to Jesse Gordon

    Thank you for responding.  I ran the report you suggested and there is a WIP ID.  There is no contract, contract item, or billed amount.  I then checked inquiry, transactions and found the WIP ID in there, but I have generated and regenerated with no luck?... 

*Community Hub is the new name for Sage City