Our Sage 100 ERP [MAS 90 / 200] webinar series continues on Wednesday, June 19. We will be covering the topics that you asked for, and we are confident this material will help you to get the most from your Sage 100 ERP [MAS 90 / 200] accounting software!
“Making it Easier to Print & File Government Reports”
Learn all about the eFiling and Reporting application for Sage 100 ERP and how the processing for 941, W-2, and 1099 forms will change later this year.
Can’t attend the Webinar on the scheduled day? Registered attendees will be able to view the recorded session at their convenience.
How to Replace a Lost Payroll Check in Sage 100 ERP (fka MAS 90/200) Without Reversing the Check in Payroll.
You could reverse the original PR check in Payroll and reissue it from Payroll. You then also have to make adjustments if the check was from a previous Payroll Quarter.
Since I personally hate reversing payroll checks, the other way I’ve handled replacing lost or missing payroll checks is to replace the check using Accounts Payable. How does that work?
This only works if you are replacing a check for the same amount. If you have to make an adjustment to the check amount, you will have to reverse the check in Payroll as you normally would.
First create the employee as a vendor in Accounts Payable. You may want to setup a Payroll Suspense Account or use a different Suspense Account for the default GL account for the vendor. If you are using divisions, it may make sense to have a different division for PR employees.
If you are using AP to pay employee reimbursements, you may already have the employee setup as a vendor and can use that vendor if you like. Just remember to change the GL account to the Suspense account you want to use.
In Manual Check Entry, you could create a reversal of the original net payroll check and then issue a new check for the net payroll check amount.
To “Reverse” the original Payroll check, in Manual Check Entry you would:
- Enter the Bank Code as the Payroll checking account Bank Code.
- Enter the Original PR check number as the check number.
- Enter the date you want to use. I would normally use today’s date. You could also use the original payroll date. There are issues with either choice.
- Enter the Vendor created for the employee.
- Enter the net PR check amount as a negative.
- Enter an appropriate comment since depending on your setup, this may carry over to the GL and will be in the AP history.
- On Lines, select GL Distribution and make sure the Suspense Account is the account.
- Click Accept.
To create the replacement check, while still in AP Manual Check Entry:
- Use the Payroll Bank Code.
- Click the Quick Print button to let the system print the check.
- Use the same employee vendor number.
- Enter the date you want to use. Here you should use today’s date.
- Enter the net PR check amount as a positive number this time.
- On Lines, select GL Distribution again making sure the Suspense Account is the account.
- Click Accept, print the check*, and print the Manual Check Register and update as you normally would.
This will create a debit and credit to the Payroll Cash Account in the GL and to the Payroll Suspense Account. Bank Rec will look as it would if you had reversed the check in Payroll.
I won’t even pretend it’s a perfect solution, but it works. And where you’re replacing checks from previous quarters or years, it’s probably the best answer I have.
*You will also need to setup an AP check printing format for your payroll checking account. If AP and PR use the same check format, you are good.
The 941 printing issues that were reported last week have been posted
Sage have released a program patch for versions 4.30 and up for Sage 100 ERP which corrects a printing issue some users had affecting printing the 2013 IRS form 941.
The original issue relates to the report itself which would resize the fonts incorrectly when the workstation display settings were NOT set to 100% (small) which is the default.
The two report files which are updated:
For your version of Sage 100 ERP (fka Sage ERP MAS 90 and MAS 200) you can download the fix from:
You will need to login to the Sage Customer Portal before using those links.
The Sage 100 ERP (fka MAS 90 or MAS 200) 941 update for 2013 has been released and you can either download it from the Sage Customer site or contact DDF for assistance in getting it installed.
There is one issue which we know about. We have had reports of the 2013 941 not aligning properly when printed.
Be sure to print your reports including your 941 before closing the quarter. If you have to close the quarter before the 941 patch gets intstalled, make a copy of the company inside Sage 100 ERP so you can run it from the copy once the patch is installed.
Thanks to some of the eagle eyed folks in the 90 Minds group, there appears to be a resolution (pun intended).
The issue is caused by having the default system font set to something other than 100% on the computer from which the 941 is being printed.
How do I get my Sage 100 ERP 941 form to print with the proper alignment?
You need to change your computers display (DPI) settings to Smaller – 100%(default).
1. Go to Control Panel and click Display
2. Select Smaller-100%(default)
3. Click Apply
NOTE: This will require a reboot for changes to take affect.