x Want to participate? Join the group to interact
  • Replies 6 replies
  • Subscribers 240 subscribers
  • Views 1165 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
189
topics
443
replies
sbasnet

Payroll did not post to Billing

Posted By

Hi,

I recently ran into an issue where payroll for the month did not post to billing when I genetated WIP.  Payroll journal did not have any rejections or warnings.

The project had not been completely set up in Contracts prior to paryoll posting (all job costs had not been linked).  I regenerated then generated wip after linking was done but this did not resolve. I would think regenerting wip would catch everying unbilled but it does not seem to be the case.  Is this a system limitation or am I missing a step?

Has anyone run into this issue?  Aside from entering a month's worth of payroll into Job Cost (or getting consultant involved) is there any way to fix?

Any input would be greatly appreciated.

Thanks,

Sumi

  • Hi Sumi-

    Did you repost job costs?  Also what date are you running your WIP through? Colud this be an accounting date isue?

  • We used to run into this issue all the time. Just keep trying with the generate WIP and regenerate WIP. Sometimes you have to do it a few times, believe it or not.  So start with the flow of information - you post in PR. Then post in JC. Then go to BL and generate WIP. Then regenerate WIP.  Then see if everything is there. Don't put any limitations on anything. It should work. Good luck.

  • Is the contract approved?

  • Sorry, I just saw the part the part in your comments that the job was not linked. If you go to BL, Inquiry, Transactions is the payroll there? If not you may have missed your chance. You could fix the contract and have payroll void and reprint the payroll.

    Regenerating WIP is for entries that have already been generated from the new.blt file and maybe the rates were wrong and you need it to look at the contract for a new rate table. Those type fixes. 

    You can of course manually add the payroll but cost codes, categories and employee names are not available. This can effect the billing invoices. If this happens a lot consider having Sage give you read/write access to the new.blt file and use Microsoft Access to create the records. I recommend this for Advanced T&M Billing users only.  

  • Sumi, I know sometimes billing is the last to know about a job but I would ask you coworkers if when the job is created that at least the Contract be created and linked to a job and the "send cost to billing" is setup on the contract item. This will help prevent the missed payroll.  I also recommend generating wip with a job range, limiting it to the one job you are working on. This can also help with missing WIP entries. Email me if you have any questions.   [email protected] 

  • in reply to Jenny Evans

    Hi Jenny - Payroll is not in BL - Transactions - Inquiry. I do think we will be voiding payroll and rerunning.  I will post manually this time.  Thanks everyone for the replies and suggestions!

    Sumi  

*Community Hub is the new name for Sage City