Sage 100

 View Only
Expand all | Collapse all

We have a customer that's using Sage 100 ERP Stand

Michael McDonald

Michael McDonald08-18-2014 13:03

  • 1.  We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:30
    We have a customer that's using Sage 100 ERP Standard 4.3 who started processing payroll for 7/12/2014 (Q3 2014) even though she had not completed her Period End processing for the 2nd Quarter. She proceeded with processing, printing, and posting the transactions. Finally she closed the period on 8/6/14 and all the payment information for her 7/12/2014 payroll run is not being reflected in the Payroll or GL modules. She has retained all of her documentation for the check run. Is the only resolution for the customer to manually re-enter and re-process her check run? They do not have any recent backups.


  • 2.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:40
    I'm puzzled at how she could have posted that payroll run - Sage won't let you post it until she closed 2nd quarter if the checks were dated in July. typically as soon as the user gets the message that they are in the incorrect quarter I have them close the prior quarterand all of the check run information is still there to update in the correct quarter. .


  • 3.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:50
    If she has all of the documentation - have you seen the actual Daily Transaction register for this payroll. I've not ever know it to post if a check date was outside of the quarter.


  • 4.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:52
    I agree with David. Sage 100 won't let you update the 3rd QTR payroll until 2nd Quarter is closed. Can she print a Payroll Check Register, or is it empty? The payroll was either updated to the wrong quarter (check Perpetual History, or is was deleted, or it is not posted yet. IF posted, then check the System Activity Log and see if Payroll Options was changed (implying the Current Qtr was changed enabling them to post). If posted to the wrong QTR, the payroll would need to be reversed and re-entered for the correct QTR.


  • 5.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:52
    She was able to print everything up to the check register but I don't see a daily transaction so she did not actually post the transactions which is why the transactions are not showing up.


  • 6.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:55
    If she did indeed post the transactions, they should be reflected in the G/L. They will also be reflected in the YTD figures but not in the current (3rd) quarter. I would not re-enter anything as you might double up in the G/L and the YTD numbers. She will need to adjust the 3rd quarter returns manually by adding back the Payroll for 07/12/2014.


  • 7.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 10:58
    it sounds like she just needs to reprint the check registers and post it now that she has completed period end processing.


  • 8.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 13:03
    I agree with @DavidOverholt


  • 9.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 13:32
    If she claims to have posted - spot check a few employees and see if checks show up so that you can rule out her having printed the checks but cleared the payroll before it was updated.


  • 10.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 14:23
    The customer indicated that she posted the transactions but she did not post the transactions as the transactions are not showing up in the GL or on the Payroll modules. While the checks printed, the Check History report nor the Employee Maintenance records reflect those payments. For all intents and purposes it looks like the transactions never took place. The numbers are not showing up in the GL or in the YTD information. Additionally, the Payroll Entry and transaction registers are all empty. It is as if the transactions never ran in the first place. She does not have a Daily Transaction Register. She was able to print were the Earnings Register, Pre-Check Register, Actual Checks, Check Register all with the 7/12/14 date on them. Finally she printed the Payroll Check Register Error Log indicating that the checks were being printed in the wrong quarter and the Payroll Data Entry Audit Report. I've gone as far back as the beginning of this year and don't see the payments reflected there at all. The weird thing is, the checks sequence that the checks were printed on are not showing up anywhere. They were essentially 'skipped over'. How far back will Sage allow you to post checks?


  • 11.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 14:34
    You can post using any Payroll Date in the current quarter. Assuming client is in Payroll Quarter 3, any date between July 1 - Sept.30. It looks like you simply need to enter a Manual Payroll for July 12, 2014 and post.


  • 12.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 14:35
    @KennethPhillips that's what I'm thinking as well.


  • 13.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 16:14
    Sounds to me like she entered all the data, printed the reports and checks and then went back into Payroll Data Entry and clicked the ""Clear"" button.


  • 14.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-18-2014 16:15
    Too bad she just doesn't fess up...... Does this get written to the activity log?


  • 15.  RE: We have a customer that's using Sage 100 ERP Stand

    Posted 08-22-2014 12:27
    The resolution was for her to re create the check run. She did indicate that she received no 'alarming messages' about the check data and the quarter discrepancy but I'm not sure how true that is. Nevertheless the issue is resolved. Thanks for all of your insight.