Advantage 3.3 Updates



Patches for Advantage version 3.3

Patch - 1

DESCRIPTION
PROGRAM(S)
AFFECTED
NEW VERSION 
FILE TO DOWNLOAD
Problem with screen form file caused section number not found error in Purchase Orders program 9.
PO9 
 3a02
This is the  version of the ADPOSCFM.DAT which can be viewed under the Info option of SA6.

ADPOSCFM.ZIP

This file contains the ADPOSCFM.DAT file. Save file to disc. Then using WIN. zip, extract file to the
AFILES (SYS) directory of Advantage.

Patch - 2

When posting disbursements through AP7 to vendors with lots of zero balance invoice detail, the program could lock up.  May also indicate a DOS error# R6000-Stack Overflow.

In response to customer requests, Order Entry programs 1 and 2 will now print orders that do not have item detail but do have service order detail. 

AP7
 
 
 

OE1
OE2

AP7: 3a01
 
 
 

OE1: 3a04
OE2: 3a01

adap0002.zip
adoe0102.zip

Save file to disc. Then using WIN. zip, extract file to the APROGS (PROGS) directory of Advantage.

Patch - 3

Using the Ctrl-U hotkey to add customers didnt work in Order Entry program 1.
OE1
Root Version 3a30
Only Order Entry has this root version change.


adoe0002.zip
adoe0202.zip

Save file to disc. Then using WIN. zip, extract file to the APROGS (PROGS) directory of Advantage.
Your installed software must be current as of patch 2 before you can successfully install this patch.

New Inventory program 35, Price Standardization, did not appear in SA4.
N/A
3a02
This is the version of the ADSAPROG.DAT file which can be viewed under the Info option of SA6.

SAPROG.ZIP

This file contains the ADSAPROG.DAT file. Save file to disc. Then using WIN. zip, extract file to the AFILES (SYS) directory of
Advantage.

Patch - 4

AR Statements (program 31) not properly paginating when the new statement message is printed.

Payroll program 20 was unable to update checks for employees that have direct deposit data listed in the master but a given check does not have any direct deposit amount.

The Shrink option of File Fixer was improperly setting the Total Used value to be the same as the Highest Used.

AR31
 
 

PR20
 
 
 
 

File Fixer

AR31: 3a02
 
 

PR20: 3a01
 
 
 
 

FX: 3a02

adar0102.zip
adpr0102.zip
adfx0002.zip

Save file to disc. Then using WIN. zip, extract file to the APROGS (PROGS) directory of Advantage.
Your installed software must be current as of patch 3 before you can successfully install this patch.

Order Entry program 3, Picking tickets, was giving a Value Number Not Found error. This SCFM file corrects that and gives you a new feature: you can now indicate the amount of explosion detail for each type of parent item (Affect Yes and Affect No).
OE3
3a02

This is the version of the ADOESCFM.DAT which can be viewed under the Info option of SA6


OESCFM.ZIP

This file contains the ADOESCFM.DAT file. Save file to disc. Then using WIN. zip, extract file to the AFILES (SYS) directory of Advantage.

Patch - 5


The 2001 formats for 1099's and W-2's

Record the current setup of your pre-tax screen in Payroll program 50,
System Defaults. This information must be edited after loading this update and it is
much easier to do if you know the current settings.

You also must have Patches 1 - 4 already installed before installing this patch.

DESCRIPTION
PROGRAM(S)
AFFECTED
NEW VERSION 
FILE TO DOWNLOAD
2001 Tax Forms: All programs (GL23, AP81, PR26 and AR33) that print tax forms (W2's and 1099's) have been updated to align to the new forms. In addition, the following changes were made to specific programs:

GL program 23: New prompt added for swapping employee names.

PR program 26: New prompts added for range on employee number and changed to recognize expanded options for printing of pre-tax deductions.
PR program 50: Pre-tax option: expanded meaning of the Print On W2 column to allow reporting of additional special disclosure items.

In addition to the changes for tax forms, this patch also includes the following bug fixes:

PR16 & 18: Calculation of Adjusted Gross was incorrectly including some pre-tax deductions.

AR27: Using incorrect figures to calculate Average Days To Pay.
AR29: No longer considers zero balance deposits.

GL23
 
 

AP81
 

PR26
PR50
 
 
 

AR33
 
 
 
 
 
 
 
 

PR16
PR18
 

AR27
AR29

GL23: 3a02
GL PL: 3a02
GL SCFM: 3a01

AP81: 3a01
AP PL: 3a02

PR26: 3a02
PR50: 3a01
PR PL: 3a02
PR FR: 3A01
PR SCFM: 3a02

AR33: 3a01
AR PL: 3b02

The  versions of the FR, PL and SCFM files can be viewed under the Info
option of SA6.

 
 
 
 

PR16: 3a00

PR18: 3a01

AR27: 3a02

AR29: 3a01

* For a printable version of these instructions,
Click here.

 

Patch-5.exe

This patch contains: adpr0102.exe, adap0002.exe, adar0102.exe, and
adgl0002.exe.
These files contain the programs.

  

Taxdata.exe

This file contains data files for company AA for the Payroll and
General Ledger modules.

  

Taxsys.exe

This file contains the updated SCFM, FR, and PL files.

***If the Patch-5.exe, Taxdata.exe, and Taxsys.exe files do not down load for you, then
Click here to down load .zip file versions.

  • STEP 1, Download the Patch5.exe into the Advantage directory, then double-left click the file and the Winzip self-extractor window will open up. Please verify and correct (if necessary) the default path to the PROGS directory for Advantage.

  • STEP 2, Download the Taxdata.exe into the Advantage directory, then double-left click the file and the Winzip self-extractor window will open up. Please verify and correct (if necessary) the default path to the DATA directory for Advantage.

  • STEP 3, Download the Taxsys.exe into the Advantage directory, then double-left click the file and the Winzip self-extractor window will open up. Please verify and correct (if necessary) the default path to the SYS directory for Advantage.

  • STEP 4, Run System Administrator Program 7, Update Files. For Payroll, both the data files and the PL files need to be updated. For the other modules (General Ledger, Accounts Payable and Accounts Receivable) only the PL file needs to be updated.

  • STEP 5, Copy Tax Form Formats from 00 to Company-Specific PL file. If you have a company-specific PL file, you will want to copy the new tax form formats that you will use from the 00 PL file to your company PL file. This is done through the Copy option of System Administrator program 11, Modify Reports. This step only needs to be done for modules that have company-specific PL files. After copying the new format (s), you can use the Delete option in this program to remove the old formats.

    Copying New Formats

  1. Go to System Administrator program 11, Modify Reports.
  2. Select the Copy Option.
  3. Enter the module code you want to work with. For example, PR for Payroll.
  4. Enter Company Number 00.
  5. Enter the program number used for printing W2's/1099 forms for the specific module you are working with.
  6. Program Module:

    23 General Ledger
    81 Accounts Payable
    26 Payroll
    33 Accounts Receivable

  7. At Format Number, use the F6 key to view a list of available formats. Select the one you wish to use, taking note of the description for this format. Choose this format based on the printer you plan to print these forms on.
  8. At Destination Company, enter your company number. (If you get a message saying the PL file does not exist, select Cancel and then TAB back out of this program--you do not have a company-specific PL file and therefore do not need to copy these formats; you can use the default formats directly from the 00 PL file. You can continue on with the next module.
  9. Enter a New Description for this form For example, "2001 W2 60 lpp".
  10. After selecting OK, the program will save your new format.
  11. Repeat these steps for each form you need to use.
  • STEP 6, Decide which format to use.
    Each tax form has 3 possible formats available: one for dot matrix printers, one for laser printers set to 60 lines per page and one for laser printers set to 66 lines per page. If you are printing your tax forms on a dot matrix printer, use the format for dot matrix printers. If you are printing to a laser printer, the best results are obtained by setting the printer to 60 lines per page and using the 60 LPP format. If you cannot change the lines per page for your printer and the printer is set to 66 lines per page, use the 66 LPP format.


What's new with Payroll W2's for 2001

    Form W2 Changes

  • The form is now a full 8 1/2" wide
  • Separate box for employee's last name
  • Old Box 12 is gone
  • New Box 12 has space for up to 4 special disclosure items such as 401(k) amounts
  • Boxes after 12 have been renumbered to reflect the removal of old box 12
  • The Locality Name box has been moved to the end of the line
  • The checkboxes in old box 15 are now in box 13 and there are only 3: Statutory Employee, Retirement Plan (formerly, Pension Plan) and Third-party sick pay (new). Advantage only addresses the Retirement Plan box.

    Software Changes

  • Payroll program 26, Tax Forms, now has a range on employee number.
  • For 2001, the reporting of 4 additional disclosure items into box 12 have been added:
    Code E 403(b) Plans
    Code F 408(k) SEP Plans
    Code S 408(p) SIMPLE Plans
    Code K 20 % Excise Tax on Golden Parachute Payments

  • The "Print on W2" column under the Pre-tax option of Payroll program 50, System Defaults, now has options available to allow you to indicate which code should print for box 12 items.
  • The employee's last name is extracted for printing in the new name area of form W2.
  • Although no longer required by the IRS, the software still prints a Totals W2 to help you fill out your W3 form.
  • The software does not produce a second W2 for an employee with more than 4 special disclosure items to be printed in box 12. If an employee has more than 4 items, the software does print a notification of this condition in the employee's address box of the affected employee's W2 and you will have to produce the additional W2 manually.


Things you might need to to do after loading this patch

    Change the "Print on W2" Flag in System Defaults

  • If you have reported 401(k) amounts in previous years, you MUST make these changes in order to print W2's successfully.
  • Because the possible values for the "Print on W2" flag have been increased, your previous answers will be thrown out by System Administrator program 7, Update Files. For any of your pre-tax deductions that were previously flagged as "Y" in the "Print On W2" column, you will need to go through the Pre-tax option of Payroll program 50, System Defaults, and enter a "1" in that column for those deductions.
  • If you have other deductions that you want to report on the W2 form, you can add them to the Pre-tax list in Systems Default, entering the appropriate code in the "Print On W2" column. For tax year 2001, you will have to manually add these deductions to each employee.

    Format Employee Names properly

  • For the best results, the names should be swapped--they should be entered through Payroll program 6, Employee Master, in the form of "Last Name, First Name MI". This format will produce the best and most consistent results. For example (Are Names Swapped: Yes):
Name In FileLast Name ExtractedFirst Name/MI Extracted
Henderson, Mary JoHendersonMary Jo
de la Hoya, Jamesde la HoyaJames
Gates-Peters, Amy J.Gates-PetersAmy J.
Robert B. McPhersonRobert B. Mcpherson 

  • If you have entered the employee names as "First Name MI Last Name", the program attempts to extract the last name by taking the last group of non-blank characters. For example (Are Names Swapped: No):
Name In FileLast Name ExtractedFirst Name/MI Extracted
Mary Jo HendersonHendersonMary Jo
James de la HoyaHoyaJames de la
Amy J. Gates-PetersGates-PetersAmy J.
McPherson, Robert B.B.McPherson, Robert

  • Note that in either case, names that are not entered in conformance to the way the "Are Names Swapped" prompt is answered will produce dramatically incorrect results (see Robert B. McPherson).

  • If you need to edit employees, you can use Payroll program 21, Quick Edit, to access only the Employee Name field. In this program, you can specify the employee name field twice: once for viewing and once for editing. That way, you don't have to remember the "old" name while entering the "new", reformatted name.


Using the new features in this patch

    How to implement deductions for the new Box 12 Codes E, F, and S

  • These special disclosure items are all some type of retirement plan that can reduce the taxable wage basis for FWT. Therefore, they are implemented in the same manner as 401(k) deductions. They must be implemented as a deduction number lower than the deduction numbers for FWT. If monies are deposited into each plan each pay period, the deduction would be added to the employee master. If the plan is only paid into once per year, you can post the deduction manually through program 14, Post Payroll.

    How to report Code K-20% Excise Tax on Golden Parachute payments

  • If you made excess "golden parachute" payments to certain key corporate employees, report the 20% excise tax on these payments in box 12 preceded by code "K". If these excess payments are considered wages, this 20% tax must be included in box 2 as part of the federal income tax withheld.

  • If the excess payments are to be considered as wages this must be handled as a separate check within Advantage. To do this, set up a pay type in program 1. This would be a salary-type of pay (not rate per hour). You also need to set up a deduction type in program 3, being certain to flag the deduction with a Federal Reference of 1 for FWT. You also set up a table to calculate the 20% tax or just manually calculate and enter the amount through Payroll program 14, Post Payroll as you are entering the check.

  • If the payments are not considered wages, the deduction can be added to any check, but will have to be calculated manually and posted through Payroll program 14, Post Payroll, under the Deduction option.

Patch - 6

DESCRIPTION
PROGRAM(S)
AFFECTED
NEW VERSION 
FILE TO DOWNLOAD

Updated Tax Tables and Country Code field added. This patch contains revised tax tables (see below) and the files necessary to add a new field--Country Code--to the Employee Master. This field is necessitated by new Magnetic Media W-2 requirements. 

Updated Tax Tables:
FWT
FICA OASDI
California
District of Columbia
Hawaii
Idaho
Maine
Maryland
Michigan
Missouri
North Carolina
North Dakota
New Mexico
Oregon
Utah
Wisconsin


 
 
 
  No program
files are
affected by
this patch.
........
SYS Directory Files:
ADPR00FR: 3B01
ADPRSCFM: 3b02
ADPR00PL: 3b02
The versions of the FR, PL and SCFM files
can be viewed under the Info option of SA6.
ADPRTAX1: 3b02
ADPRTAX2: 3a02
The versions of these TAX  files can be viewed when selecting either Transfer option in PR58.
ADPRDICT: 3b01
The version of the PR Dictionary file for RG can be viewed when printing the dictionary through RG51.

 

DATA Directory Files:

ADPRAA*.DAT
This is the sample data for Payroll that 
contains updated Help articles for this patch.
....
 ...
 
SYS6.ZIP

Copy this file to the SYS directory by right mouse click, then choose save target as. Then extract it (using WinZip) allowing it to overwrite existing
files.

DATA6.ZIP

Copy this file to the DATA directory by right mouse click,
then choose save target as. Then
extract it (using WinZip) allowing
it to overwrite
the existing  files.

After decompressing these files, you will need to Update Payroll files through SA program 7.

Patch - 7


Updated 2001 1099-MISC form for Payroll. The dollar amounts printed on the Payroll W2 were in the wrong boxes. This only affects Payroll; all other modules (GL, AP and AR) that print 1099's are correct.
No program
files are
affected by
this patch.
PR PL: 3c02
The  version of the PL file can be viewed under the Info option of SA6.

SYS7.ZIP
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  file.

After decompressing this file, you may need to copy the 1099 format from the 00 PL to your company-specific PL. Formats are copied through SA program 11.

Patch - 8

Updated version of the File Maintenance utility to work with new Data Export Tool.
FM
FM00: 3a02
 

ADFMDATA: 3c02
The  version of the this file is displayed as the DATA VERSION at the bottom of the screen in File Maintenance.


PROGS8.ZIP
Copy this file to the PROGS directory and decompress it, allowing it to overwrite the existing  file.

SYS8.ZIP
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  file.


Patch - 9


Your installed software must be current as of Patch - 5 before you can
successfully install Patch-9a.zip

Updated Payroll program 26 with W-2 changes for 2002 reporting.
(Note: 1099's are not affected.)
PR
PR26: 3b02

Patch-9a.zip

Copy this file to the PROGS directory and decompress it, allowing it to overwrite the existing  file.


Updated PL file with new double-wide W2.
 

 
No program
files are
affected by
this patch.

 

PR PL: 3e02
The version of the PL file can be viewed
under the Info option of SA6.

Patch-9b.zip

Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  files.

After decompressing this file, you may need to copy the double-wide W2 format from the 00 PL to your company-specific PL.
which is done in SA11

If you have a company specific PL, run SA7, update for PR, your company number, and PL only.


Updated tax tables for tax year 2003 for the following:

Federal Withholding
OASDI
California
Louisiana
Minnesota
Missouri
New Mexico
North Dakota

As of 12/17/02: Added Maine, Rhode Island, and Vermont. Versions shown at the right are after these tables were added

As of 12/20/02: Updated North Dakota's exemption amount. Original documentation said the amount was $3,000; should be $3050.

As of 12/30/02: added Michigan for 2003. Versions shown at the right reflect these changes.
 

No program
files are
affected by
this patch.

 

ADPRTAX1: 3d02
ADPRTAX2: 3e02
The versions of these TAX 
files can be viewed when selecting
either Transfer option in PR58.


To view or print the Federal Tables:

FICA HI

FICA OASDI

FWT SINGLE

FWT MARRIED



To download the tables, click on the link below.

Patch-9c.zip
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  files.

Tax Table Transfer Instructions

Patch - 10

Updated tax tables for the following; effective June 1, 2003:

Federal Withholding
Connecticut
New Mexico

No program
files are
affected by
this patch.
ADPRTAX1: 3e02
ADPRTAX2: 3f02
The versions of these TAX  files can be viewed when selecting either Transfer option in PR58.


To view or print the FWT Tables:

FWT Single

FWT Married


To download the tables, click on the link below.

SYS10.ZIP
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  files.

Tax Table Transfer Instructions


Patch - 11

Updated tax tables for 2004 for the following:

FICA OASDI

California
Maine
Maryland (5 new tables
                        added  1-15-04
)
Michigan
Minnesota
North Carolina
North Dakota
New Mexico
New York
Puerto Rico
Rhode Island
Vermont

.....

No program
files are
affected by
this patch.

.....

ADPRTAX1: 3f02
ADPRTAX2: 3g02
The versions of these TAX  files can be viewed when selecting either Transfer option in PR58.

.....
To view or print the FICA OASDI Table:

FICA OASDI


To download the table, click on the link below.

SYS11a.ZIP
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  files.

Tax Table Transfer Instructions
 

Patch - 12


Your installed software must be current as of Patch - 9 before you can
successfully install Patch - 12

This patch corrects a problem with the quarterly reporting of State Unemployment in 2004.

Magnetic Media

MM02: 3d05

admm0002.zip

Copy this file to the PROGS directory and decompress it, allowing it to overwrite the existing  file.

Patch - 13

This ZIP file contains three formats: JDATE, ENCRYPT and ARMONTHS that are discussed in the Book of Knowledge.
No program
files are
affected by
this patch.
No Version Change
NEWFMTS.ZIP
Copy this file to the directory where you keep your RG formats and then decompress it.

Patch - 14

Updated tax tables for the following states:

Georgia
(effective 01/01/04)
Idaho
(effective 07/01/04)

No program
files are
affected by
this patch.

ADPRTAX1: 3g02
The version of this file can be viewed when selecting the Tax Transfer 1 option in PR58.

SYS14.ZIP
Copy this file to the SYS directory and decompress it, allowing it to overwrite the existing  files.

Tax Table Transfer Instructions


Back to: Intro Page | Home Page | TOP