Sage Accpac Community
Accpac Support Community
Search in




With every great feature, come great questions! This blog is dedicated to those great questions - your great questions. Check back often as our Sage Accpac ERP support analysts, Tyrone Loo and Louis Doza, post solutions to commonly asked questions, helpful hints, and other useful product information.

January 2009 - Posts

  • Printing 1099/CPRS - 101

    It seems that we are getting quite a bit of calls regarding 1099 in technical support recently. And since we have talked about printing T4s and W2s already, I figure this may be a good time to talk about 1099 and CPRS reports as well.

    If you don't set it up first, 1099/CPRS Tax Reporting is not going to work. So in the vendor setup, make sure you select the 1099 or CPRS option for the vendor under the Invoicing tab. Also, make sure you enter the 1099/CPRS amounts in the 1099 (CPRS) box when you enter your invoices.

    The 1099 forms can be printed using the icons in A/P Vendor Reports, and you can do an inquiry of the amounts using the 1099/CPRS Inquiry icon in A/P Vendors. If any amounts are missing or incorrect, you can also edit and insert them through that window, but again, you have to turn the option on first before you can do so. Go to A/P Options, and under the Transactions tab, you will see the option to Allow Edit of 1099/ CPRS Amounts. If you want the 1099/CPRS amounts on the invoices to use document totals as default, select the Default 1099/CPRS Amount option also.

    If you are using version 5.5 and you are getting the error "Invalid input. Year must be entered" when adding new amounts into the 1099/CPRS Inquiry window, make sure you download and install Product Update 2 for Accounts Payable. You can download that from:

     http://support.accpac.com/techsupport/Service_Packs/a4w/.

    Yes! We now support 1096! You can print 1096 forms by installing the latest Product Update for version 5.5. However, the option of printing with a range has been removed. The idea of putting that option back into the print screen has been brought to Development already.

    So if there are no other questions... Class dismiss!!!

    with no comments
  • It's a New Year, Time to Clean up!

    So what are your new year's resolutions?  Go to the gym every week?  Eat healthier?  Keep your desk at work clean?  How about keeping your Accpac database clean?  I don't mean you should be getting a bucket and sponge, and start scrubbing your server (please don't do that, water and computers don't usually mix), I mean maybe it's time to start limiting the history you keep.

    Why would you want to clear history?  The primary reason would be it saves disk space, and the database generally just runs faster. 

    Before you start, make sure you have a backup.

    In almost every module, there's a function called Clear History.  Each Clear History function can clear different things, most of which are pretty self explanatory.  Before processing though, check the F1 help for a couple of things:

    • For some types of history, only transactions that meet certain criteria will be cleared.  For example, for AP, clearing Fully Paid Documents, only documents which have a zero balance, and have had their checks reconciled in the bank for at least 45 days will clear.
    • There are some consequences as well, such as in AP, if you clear Posting Journals, you can no longer print them (You can of course print them before you clear it, and save a hard copy).

    So you may have missed the gym this week, but at least you're cleaning up your Accpac database. =)

    with no comments
  • T4 and W2 - Life after Payroll Year End

    Happy New Year! Welcome back! Now that you have finished your payroll year end, you may turn your attention to T4 and W2. There are no changes to the format of the T4 printout, but there are changes to the specifications for filing it electronically. And as usual, the form and efile specs for W2 has changed also. But don't worry, the payroll update would have included all the modifications that you need already. But before you print out or generate your final copy, just make sure there aren't any more updates.

    Notice missing information or inaccruate information on the government forms?

    Check the payroll tax table update Readme or the Update notice first because you may need to make a few modifications to your existing setup. They will list out all the new changes, features, and fixes.

    If you don't find anything, check the knowledge base next (http://kb.accpac.com). Select Sage Accpac ERP under the Product list and select your payroll module under the sub product list. You can do a search by Similar Phrases and search by your question. Or you can do a search with the key words "T4" or "w2", and this should list out all the articles related to printing these two government reports.

    You may want to make a note of Solution ID 24258 (for T4) or Solution ID 26049 (for w2). Occasionally, you will find that you will need to adjust the YTD amounts on the forms. These two articles will tell you how to do that by making use of the Transaction History function.

    Remember, there may be last mintue changes by the government, so always check for the latest update before you print your final T4 and W2. And just a side note for the US Payroll users, the 941 forms have not been updated in the January 01, 2009 payroll. So the forms will still print with 2008. The forms with be updated in a future upate, before the end of Q1.

    with no comments