x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 238 subscribers
  • Views 1966 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
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
188
topics
442
replies
Siri H.

Understanding how costs feed from payroll to billing (or why they aren't?!)

SUGGESTED
Posted By

We use payroll and have field employees in unions. Their costs are categorized into Labor and Labor Burden. I can run a report from Job Costs (Entries by Job) and see all the breakdown of the costs for one job and see the amounts for each person's Labor and Labor Burden. But when I run the bill in Billing for this job, I am only getting the Labor on the WIP... The Labor Burden isn't appearing. So my bill is completely wrong!

Anyone ever experience this? I've talked to 3 differerent support people so far trying to chase this issue down and we're still in process... I thought maybe someone out here would have a suggestion.

We are on Sage CRE 13.1.24 (13.1.0 Rev 6 Acc Update 8). There is also a rate table associated with this job which indicates that on this job number, for a few key people, there are specific billing rates. For all other people (*) on this job, the "Pass Thru" box is checked.

Can you help?! I have a boss breathing down my neck to get this invoice out.... Thanks in advance!

Parents
  • 0
    SUGGESTED

    Hi Siri, the first thing you should check is to make sure that the PR Burden costs are set to distribute to Billing from Payroll.  In Payroll, go to Setup, Fringes, and Setup Taxes to see if the fringes and employer related taxes are set to Distribute to Billing.

    Since you can see the burden related cost in JC, you may also want to see if these costs have a WIP ID referenced on the JC transaction.

    You can do this by using JC>Inquiry>Cost/Estimating Entries. (select current when prompted for the transaction file)  Double click on the Job that is associated with the cost based contract.  Once you have drilled inot the transactions, click the Conditions button or the blue filter icon to ADD a condition: Application of Origin = PR.  From there click at the top of any of the columns to insert the WIP ID field.

    It is difficult to troubleshoot through email, since what is sent to billing from Payroll is dependent on many setup factors. Please email me your customer id and I can check on the status of your support tickets and see if I can be of further assistance in this matter. My email is [email protected]

Reply
  • 0
    SUGGESTED

    Hi Siri, the first thing you should check is to make sure that the PR Burden costs are set to distribute to Billing from Payroll.  In Payroll, go to Setup, Fringes, and Setup Taxes to see if the fringes and employer related taxes are set to Distribute to Billing.

    Since you can see the burden related cost in JC, you may also want to see if these costs have a WIP ID referenced on the JC transaction.

    You can do this by using JC>Inquiry>Cost/Estimating Entries. (select current when prompted for the transaction file)  Double click on the Job that is associated with the cost based contract.  Once you have drilled inot the transactions, click the Conditions button or the blue filter icon to ADD a condition: Application of Origin = PR.  From there click at the top of any of the columns to insert the WIP ID field.

    It is difficult to troubleshoot through email, since what is sent to billing from Payroll is dependent on many setup factors. Please email me your customer id and I can check on the status of your support tickets and see if I can be of further assistance in this matter. My email is [email protected]

Children
No Data

*Community Hub is the new name for Sage City