AccountMate Data Wizard 8.1 for SQL

July 12, 2010

 

Important Changes

 

AccountMate Import Wizard

 

The following fields have been added to these tables:

 

Table Name

Field name

Field Description

ap99up

caddr1

Address 1                                         

ap99up

caddr2

Address 2                                        

ap99up

ccity

City                                             

ap99up

ccompany

Company                                          

ap99up

cfname

First Name                                        

ap99up

clname

Last Name                                        

ap99up

cpstate

Payer's State                                    

ap99up

cpstateno

Payer's State #                                  

ap99up

cstate

State                                             

ap99up

ctaxfld

Tax Field 1                                      

ap99up

cvendno

Vendor #                                         

ap99up

cyear

Year                                             

ap99up

czip

Zip

ap99up

lexceed

Direct Sales Exceed 5000                         

ap99up

n409adef

Section 409a Deferrals                           

ap99up

n409ainc

Section 409a Income                              

ap99up

ncropprcd

Crop Insurance Proceeds                           

ap99up

negppmt

Excess Golden Parachute Payments                 

ap99up

nfedtax

Federal Income Tax                               

ap99up

nfishboat

Fishing Boat Proceeds                            

ap99up

ngrpatt

Gross Proceeds Paid to an Attorney                

ap99up

nmed

Medical and Health Care Payments                 

ap99up

nnonemp

Non-Employee Compensation                        

ap99up

nothincome

Other Income                                     

ap99up

nrent

Rents                                             

ap99up

nroyalty

Royalties                                        

ap99up

nstateinc

State Income                                     

ap99up

nstaxwhamt

State Tax W/H                                    

ap99up

nsub

Substitute Payment for Dividends/Interest        

apvend

clpymtno

Last Payment #                                   

apvend

clpymttype

Last Payment Type                                

apvend

clsrcno

Last Source #                                    

apvend

dlastpymt

Last Payment Date                                

apvend

nlpaidamt

Last Paid Amount                                 

arcust

clinvcurr

Last Invoice Currency Code                       

arcust

clinvno

Last Invoice #                                    

arcust

clrcptcurr

Last Rcpt Currency Code                          

arcust

clrcptno

Last Receipt #                                   

arcust

dlrcpt

Last Receipt Date                                

arcust

dlsales

Last Sales Date                                   

arcust

dtempcrvld

Valid Until                                      

Table Name

Field name

Field Description

arcust

lshownote

Show Notepad                                     

arcust

ncrholdamt

Credit Hold Amt                                   

arcust

nlrcptamt

Last Receipt Amt                                 

arcust

nlsalesamt

Last Sales Amt                                   

arcust

nsqamt

Last Quote Amount                                

arcust

ntempcrinc

Temporary Credit Increase                        

icitem

lptarpsrmk

Print Remark on AR Packing Slip                  

icitem

lptraplrmk

Print Remark on RA Pick List                     

icitem

lptsoplrmk

Print Remark on SO Pick List                     

icitem

lptsopsrmk

Print Remark on SO Packing Slip                  


 

 The following fields have been deleted from these tables:

 

Table Name

Field name

Field Description

apvend

clbankno

Last Bank #

apvend

clchkno

Last Check #

apvend

dlastcheck

Last Check Date

apvend

nlchkamt

Last Check Amt

icitem

cimagepath

Image File Path

 

Bug Fixes

 

The following issues were fixed as of July 12, 2010:

 

Control #

Module

Description

Fixed In

10010542

SM

EN: Change the default password of amlogin to a longer one.

DWIMCONFIG.DBF, DWPROFIL.DBF

DWIMPORT.SCX

DWRENAME.SCX

10011530

AR

EN: Show Last Sales and Last Payment information in the customer record.

DWIMFIELDS.DBF, IMCUSTMSTR.PRG

10011555

AR

EN: Ability to print Customer Credit History Report.

DWIMFIELDS.DBF, IMCUSTMSTR.PRG

10009491

AR

EN: Option to show notepad first when creating a transaction

DWIMFIELDS.DBF, IMCUSTMSTR.PRG

10011509

AR

EN: Option to put Sales Orders on Credit Hold

DWIMFIELDS.DBF, IMCUSTMSTR.PRG

10011644

AR

Enhance Customer Maintenance so that there is a separate field for open Sales Quotes.

DWIMFIELDS.DBF, IMCUSTMSTR.PRG

10005869

IC

EN: Add options of printing remark in Inventory Maintenance and Inventory Type Maintenance.

DWIMFIELDS.DBF, IMITEMMSTR.PRG

10011642

AP

EN: Add a new function to perform current and previous-year 1099 Information Update

DWIMTABLES.DBF

DWIMFIELDS.DBF, IMVEND1099.PRG

10011645

AP

Show Last Payment Date and Amount instead of last check date/amt in Vendor Maintenance.

DWIMFIELDS.DBF, IMVENDMSTR.PRG

 

Additional Software Requirements for Modification (Optional)

Visual FoxPro 9.0 (SP2)