Sage Accpac ERP Support Resources & FAQ
Some of these items require Adobe Reader. If you don't have it, you can download it for free here.
Below are a list of Frequently Asked Questions sorted by Sage Accpac ERP Module:
Year End
Can't find what you're looking for? Submit a Question
Q: If you are signing into your Sage Accpac on April 1st and you receive a message that the date is not in the fiscal calendar, this is because you have not created the year in Sage Accpac. - Click to See Solution
- Select the “Common Services” icon, then “Fiscal Calendar”
- Click on the icon to the right of the fiscal year (the page with the corner folded over) and 2012 will appear in the fiscal year field .. see below. NOTE: In order to ensure that the entries from subledger batches come through so 2012 and 2011 entries are not in the same batch (which could result in error batches if you have not created the new year in your GL) you should go to the setup icon in each of your subledgers (AR, AP, Payroll, PO, etc.) and under the GL Integration tab make sure the option to create a new batch is selected, rather than having it add the entries to an existing batch. This will enable you to post the remaining 2011 entries for all subledgers
- Click on “Add” and the system will be set up so that you can do entries in all of the subledgers. In order to do any 2012 entries in GL you have to create the new year in GL. For complete instructions on this, check our website under the Frequently Asked Questions, General Ledger section. If you decide to close your general ledger before you have done all 2011 year entries, you can simply go to your GL Setup and select the option to Allow Posting to Previous Year. Then you can post both 2011 and 2012 entries.
Collapse This Solution
Q: I have not opened the New Year in GL…but I have error batches. Why are they there? - Click to See Solution
A: For most of you, you have your subledgers (AP, AR,PR) set to create batches automatically in the General Ledger Program. Around this time of the year, some of the entries that are making their way across to the General Ledger are for March and some are for April.
Posting the batch, will post the March entries, but the April ones will be placed in an ERROR batch until the new year is created in the GL program.

Once the new year has been created in General Ledger, you can post the batch. You can change the batch description at any time before posting
Collapse This Solution
Bank Services
Can't find what you're looking for? Submit a Question
Q: How do I get a report that shows all cheques created? - Click to See Solution
- Go to Bank Services
- Select Bank Transaction Reports
- Select Check/Payment Register Report
- Choose your bank, the specific dates and any other options (See image below)
Collapse This Solution
Q: Is it possible to reverse an Entry in Bank Services? - Click to See Solution
A: Yes, in version 5.6 and higher it is possible to reverse cheques and bank transactions, as long as you have not cleared them in a posted bank reconciliation.
- Select Bank Transactions from the Common Services, Bank Services icons
- Select the Reverse Transactions Icon

- Type in your bank code or use the finder to select it from the list
- In the source application, select bank services
- In the reverse document field, select either deposits or withdrawals

- Type in a reason for reversal
- Select the reversal date, and fiscal year and period (this is important, as the reversal date and period will determine which bank reconciliation the reversed transactions will show in.
- Use the finder to select the entry number
- Select the post button
- This transaction will now show up in the reconciliation for the date you have selected. The transaction can then be cleared as part of that period’s reconciliation.
Collapse This Solution
Payroll
Can't find what you're looking for? Submit a Question
Q: I generated my EFT file and realized it is not correct, what should I do first so I can regenerate the correct file and send to the bank? - Click to See Solution
Q: Printing T4 Forms on Plain Paper - Click to See Solution
A: Did you know that you no longer need to order pre-printed T-4 forms if you are using Sage ERP version 5.4? To print the form and the employee’s information at the same time, you simply select the option for “Plain Paper for Employees” to print 2 T-4 slips per page for your employees; or the “Plain Paper for CRA” or “Plain Paper for Employer”.
Collapse This Solution
Q: Why is the employee's return address not showing up on the T4? - Click to See Solution
Q: Why is the business number (Box 54) not printing on the T4? - Click to See Solution
A: The business number can be setup under payroll setup then income taxes and choose each tax that you have setup and add the Reporting ID (Business number). Note: This will not show up on the employee's copy of the T4.
Collapse This Solution
Q: Why is the Pension Plan (Box 20) not showing up on the T4? - Click to See Solution
Q: Why is the Pension Adjustment (Box 52) not showing up on the T4? - Click to See Solution
Q: Where is the Pension Plan number (Box 50) entered? - Click to See Solution
A: Box 50 would have to be entered on the employee record for each employee that pays into the plan on the Class/schd tab the field called RPP number.
Collapse This Solution
Q: Why are the EI / CPP / insurable earning boxes blank on the T4? - Click to See Solution
A: Box 50 would have to be entered on the employee record for each employee that pays into the plan on the Class/schd tab the field called RPP number.
Collapse This Solution
Q: Electronic Filing your T4? - Click to See Instructions
A:
Here are some instructions for T4 Electronic filing we discovered after several calls with our clients and to people at Canada Revenue Agency...
In Accpac:
1) Be sure that all employees have the PROVINCE in the PROVINCE field on their general tab (Payroll Employees, general), or it will not generate the file
2) Be sure that you have the province in both the Employer Info and Transmitter Info 1 Screens and you also need to have the contact name, phone # and email where it is requested.
3) You need to enter something in the SIN of 1st Proprietor field or it will not process the file. You can use zeroes.
4) Fill the Transmitter Info II screen out as per above ... the MM number was something CRA was testing but are no longer using, so you just fill the rest of the field with zeroes. The Submission reference ID is one you decide on.
You decide on the location of the file by browsing. If you have more than one RPP # you can include the info in the file, eg: T4EFILERP0001.
5) When you get to the CRA site, you select T4/T5 by Internet then Filing a T4 Information Return, then Internet File Transfer (XML), FILE NOW, Enter Secure site.
6) After clicking on the I agree button, you will see a screen where you enter your RPP number or MM #. Since the MM# does not exist, enter first your RPP # then further down there is a spot to enter the Web Access Code you were given by CRA.
7) Click the continue to next step button at the bottom of the screen and then select the file you saved in # 4 and upload it.
8) If the file was transmitted successfully you will receive a display telling you that the upload was successful. This will confirm the number of T4 slips, date and time and will give you a confirmation number. Be sure to print this page for future reference.
Repeat the above for each RPP # you have.
Collapse This Solution
Q: How do I print my T4? - Click to See Solution
A:
- Step One - Select "Payroll Government Reports"
- Step Two - Double-click "T4s" (continued below)
- Step Three - Choose your form (either 'Employee or Employer - Plain Paper')
- PLEASE NOTE: Leaving the 'From Employee / To Employee' field blank will, by default, select ALL employees
- Step Four - Select Print
Collapse This Solution
Q: How do I Electronic File my T4? - Click to See Solution
A: Follow the steps below...
- Step One - Select "Payroll Government Reports"
- Step Two - Double-click "T4s Electronic Filing" (continued below)
- PLEASE NOTE: Your file will be saved in the location you define in "Local File Path"
- Step Four - Select Process
Collapse This Solution
Q: I have updated Employee Information, but the new information is not showing on reports? - Click to See Solution
Q: After printing payroll cheques I realized one employee was paid the wrong amount, I have to generate my EFT file and send to the bank right away how do I correct this so the EFT file I generate is correct? - Click to See Solution
Answer: The first step is to reverse the incorrect payroll cheque for this employee:

Next go back and make sure the employee’s pay tab or timecard is correct. Then you can re-calculate payroll for this one employee only using the same pay period end date then process this new calculation of payroll.

Next verify your pre-cheque register and proceed to print cheques then to generate your EFT file as normal.
Collapse This Solution
General Ledger
Can't find what you're looking for? Submit a Question
Q: I created my new year and some accounts closed to the incorrect closing account, how do I correct this? - Click to See Solution
A:Since the new year is already created, you would have to do a GL entry to take the amount out of the incorrect closing account (debit), and then credit the correct closing account. To prevent this from happening in the future there are a couple of things you can do to make sure it does not happen again:
- Specify the correct closing account for those departments in the segment icon in GL options
- Go through each Revenue and Expense account, and at the bottom where it says "Close to Segment', select 'Department' so that it will look to the department to find the closing account. If not, it assumes the default closing account specified in GL options
Collapse This Solution
Q: I have error batches in GL, how do I find out what the error is? - Click to See Solution
A: Go to GL reports then GL posting journals and then select posting journal errors for the batch in question.
Collapse This Solution
Q: Before creating your new year in General Ledger - Click to See Solution
A: Creating a new year in General Ledger will create and post a batch to take the revenue and expense accounts (designated as Income Statement Type of accounts) to a $0.00 balance for the beginning of the next fiscal year. All of the details will remain in the previous year history file.
Before performing this function you should:
- Backup your data
- Run a data integrity check on all modules. Print and keep the report.
Â
- Print a chart of accounts and verify that you have at least 1 account designated as a retained earnings or closing account. You must have at least 1 account that is account type “R” for Retained Earnings before you can create the new year.
- In your printed chart of accounts, verify that all accounts that are revenue and/or expense type of accounts have been designated as “Income Statement” type of accounts. Accounts that are mistakenly defined as balance sheet accounts will have their balance carried forward to the next year.
- If you have more than 1 retained earnings account, and you have departments that close to different retained earnings accounts, make sure the correct closing account is specified for each department in the segment codes in GLSetup.
- Related to #5 above, for each Income Statement type of account in General Ledger, make sure there is a value in the Close To field for each account. This value is usually defined as either department or program. You will have a pull down list available to select from. Without this specified at the account level, the account will close to the default retained earnings account defined in GL Options.
Collapse This Solution
Q: How to create a new year in Sage Accpac ERP General Ledger - Click to See Solution
A: FIRST BACK UP YOUR DATA, then:
- Go to General Ledger, GL Setup, Options and select the Posting tab. Verify that the number of years’ transaction history to keep is greater than 1. If you are running Sage Accpac ERP 5.5 you will be able to keep a minimum of 7 years of history now.  If you are using Sage Accpac ERP 500 you can retain up to 99 years history.
- Verify that the Create New Year function has not yet been run by verifying that the current year showing is 2009
- Next, select Periodic Processing, Create New year. You will have a warning to backup prior to proceeding. DO NOT IGNORE THIS WARNING! As long as you have done a backup, select “Process”.
- Once the year is created, a message will display indicating that the new year has been created.  NOTE:  IT IS VERY IMPORTANT THAT YOU DO NOT RESET BATCH NUMBERS, AS IT WILL ELIMINATE THE ABILITY TO LOOK AT TRANSACTION DETAILS FOR YOUR AUDITOR
Collapse This Solution
Q: Why can I not see all the batches listed in the batch list window? - Click to See Solution
A: If you are working in the GL for example, open the batch list window check to be sure the source ledger is blank, this will allow you to see all the batches from all the ledgers listed. Also check to be sure the check mark is on show posted and deleted batches.
Collapse This Solution
Accounts Receivable
Can't find what you're looking for? Submit a Question
Q: How do I reverse Customer Payments? - Click to See Solution
A: Reversing customer payments is performed in the bank services module. Since AR sends information related to deposits (receipts) and cheques (refunds); both of those types of transactions are available for reversing.
As with any other Accpac Module, dates are important to verify when you are reversing items in bank services.
You may need to reverse a customer payment for a number of reasons including the payment did not clear or it was entered/recorded to the wrong customer account.
To reverse the customer payment, select the Reverse transactions icon under Bank Transactions in the Bank Services module.
Collapse This Solution
Accounts Payable
Can't find what you're looking for? Submit a Question
Purchase Orders
Can't find what you're looking for? Submit a Question
Pervasive
Can't find what you're looking for? Submit a Question
Q: I am receiving error=2, what should I do? - Click to See Solution
A: FIRST BACK UP YOUR DATA, then:
This means that Accpac is not communicating with Pervasive, which would normally mean that the connection has been lost, Pervasive Services needs to be restarted - which restarting the server or workstation would do, however a technician would be able to go into Pervasive services and do that manually as well.
Collapse This Solution
Tax Tables
Q: How do I download the January 2012 Tax Tables? - Click to See Solution
A: Please follow these steps:
- Backup your Sage Accpac data (database dump)
- Follow this link
- Click on the appropriate version of Sage Accpac you are running & download the January 2012 Canadian tax table
- Install the tax table
- Now you can open Sage Accpac and activate the January 2011 tax table you just installed. To do this, sign in as the Admin user and go to Administrative Services, ensure all users except Admin are out of the program and click on the Data Activation icon and select the Canadian Payroll Tax Update, January 2011 item, then click on “next”, then “activate.
Collapse This Solution