If Crystal Reports is slow to open when trying to modify a Crystal Report in Sage 100 ERP 2013, uncheck “Check for Updates on Start up” on the Help menu inside Crystal.
via 90 Minds
Thanks to W Warby for the tortoise picture!
After installing the Sage 100 ERP wksetup for a client this morning, we got the following error message:
Every time we’d click a menu option, we were getting the same message.
The warning says “Open File – Security Warning” and references the file pvxwin32.exe.
We clicked OK on the warning message a few times, but pretty quickly got frustrated.
How did we fix the issue?
Make changes to your operating system and system files at your own peril! If you can backup files, do so before trying this.
via Wayne Schulz
Do you sell merchandise through the Amazon Marketplace (MWS)? Would you like to?
Selling through Amazon opens up a whole new world of opportunity. If you are already using Sage 100 ERP, Amazon Marketplace Connector for EDI Advantage gives you the ability to automatically integrate Amazon Marketplace orders with your Sage 100 ERP system.
The Amazon Marketplace Connector by Kissinger Associates brings Amazon Marketplace orders into Sage 100 and notifies Amazon when orders have been fulfilled, getting you paid. It can be automated or initiated on demand.
If you have questions or would like more information using Sage 100 ERP with the Amazon Marketplace, contact us for more information. It can be automated or initiated on demand.
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.
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.
First you setup a credit card payables account if you don’t already have one.
You then create a bank code for each credit card and if you have more than 26 bank accounts and/or credit cards, obviously this won’t work.
When you get a receipt, you enter it in manual check entry to the correct vendor selecting the proper bank code for that card.
When you get the credit card statement, you reconcile it like you would any other bank account and enter any missing items.
Enter the invoice to the credit card vendor, making sure to code it to the credit card payables account and coding any interest or service fees to the right GL expense account.
In many ways it is simpler than the transfer button. If you entered the invoice and paid it after the fact with a credit card, you can enter it as a manual check.
Many of you have gotten letters from Sage about the new Sage MAS Intelligence (SMI) reporting tool. This demo video provides an overview of Sage MAS Intelligence.
Sage MAS Intelligence is Sage’s replacement for the soon to be retired Microsoft FRx. It is an Excel based plugin that reads Sage MAS 90/200 data and presents it in both a report format and as a dashboard.
Additional good news: unlike FRx and F9, SMI reports not just on General Ledger Data, but it reports on data from the other MAS 90/200 modules.
This video by Clients First, a fellow Sage Partner and 90 Minds member firm.
via Clients First
We’ve all done it at one point or another. We setup some of our addresses in ALL CAPS and accidentally setup others in Mixed Case.
As Brett Zimmerman points out over on the 90 Minds blog, the Upper Case Address Utility (or SWUPCS) is a “Hidden Utility” in Sage MAS 90/200 for converting Customer and Vendor addresses (or just City in case you forgot about the “Return City Name in ALL CAPS” setting in Company Maintenance) to ALL CAPS.
WARNING!: This is a permanent change, so be sure to use with caution!
To access this utility in MAS go to File | Run.
Enter SWUPCS in the Program box and click OK.
From here you can select City Only or All Address Fields and which addresses you’d like to set to All Caps (Customer, Ship To, Vendor, or Purchase Addresses) and click Proceed.
Unfortunately there isn’t a utility to convert all addresses to Mixed Case, but that’s what Visual Integrator is for, right?
Via 90 Minds
One of the new features in Sage MAS 90 and MAS 200 4.40 PU 3 is the ability to post Bank Fees and Adjustments to the General Ledger from the Bank Reconciliation module.
This has to be one of the most requested features for any user of the MAS 90 Bank Rec module.
From Modules | Bank Reconciliation | Main select Check, Deposit, and Adjustment Entry. There are a few new features here. From either the Checks tab
or the Dep/Adjust tab
you now have access to a “Select For G/L Posting” check box and a “Distribution Account No.”. If you check the GL Posting check box, it will allow you to enter the distribution account number.
Once you’ve finished entering your adjustments you can click the new “B/R Trans Register button at the bottom of the Check, Deposit, and Adjustment Entry screen (highlighted in red above).
You’ll then be prompted to select the bank code or leave it blank for all and select the GL Posting date and print and update as you would any other module.
One place where the posting from Bank Rec is different from other modules is that you can delete the record from Check, Deposit, and Adjustment Entry after it’s been posted and it won’t update the GL. Also the account number can’t be changed after it’s been posted, so you’ll either need to correct with a GL Journal entry or enter a correcting entry if there is a problem with an account that has been selected.
If you try to update the Bank Reconciliation Register and purge cleared transactions you will get the following message and be unable to purge until you have run the Bank Reconciliation Transaction Register and updated it (or deleted the transactions).