AP SYSTEM TO RAC 022810

 

FILE NAME IS OUR NUMBER FOR THISCLIENT

 

      TABLES –  

A)    VENDORNAME

                     FIELDS:

 AUTO NUMBER

 OUR VENDOR #

 NAME

ADDRESS (CITY STATE ZIP CODE)

TAX ID FEDERAL

TAX ID STATE

USUAL TERMS

DEFAULT ACCOUNTING CODE

AR CLERK NAME

AR CLERK PHONE

 MANAGER NAME

 MANAGER PHONE

SALES TAX BILLED

SALES TAX RATE

 

D)      TABLE INVOICES

OUR VENDOR NUMBER

OUR INVOICE NUMBER

VENDOR INVOICE #

SALES TAX CHARGED

TOTAL INVOICE

SHIPPING CHARGE

                        POSTED

PAID

 

                   C)TABLE INVOICE DETAIL

                          OUR VENDOR #

                          OUR INVOICE NUMBER

                           VENDOR PART #  

                           VENDOR UNIT PRICE

QUANTITY

     COST

     ACCOUNTING CODE

 

 

 

 

 

 

 

 

        D)TABLE CHECK REGISTER

OUR BANK ACCOUNT #

     BANK OFFICER CONTACT

     LAST CHECK NUMBER

     AMOUNT             

OUR VENDOR #

     OUR INVOICE #

     CHECK DATE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            

      DATE SENT

      DATE CLEARED

 

E)     TABLECLIENT DATA

BANK ACCOUNT 1

ROUTING #

ACCOUNT #

# OF SIGNATURES REQUIRED

LAST CHECK ISSUED

 

BANK ACCOUNT 2

ROUTING #

ACCOUNT #

# OF SIGNATURES REQUIRED

LAST CHECK ISSUED

 

BANK ACCOUNT 3

ROUTING #

ACCOUNT #

# OF SIGNATURES REQUIRED

LAST CHECK ISSUED

 

BANK ACCOUNT 4

ROUTING #

ACCOUNT #

# OF SIGNATURES REQUIRED

LAST CHECK ISSUED

SPECIAL ACCOUNTING CODES

 

CLIENT # 9999 (DEFAULT)

TABLE    BANKSTHIS TABLE NOT IN CLIENT FILE

ROUTING

BANK NAME

BANK ADDRESS

BANK TELEPHONE

BANK FAX

BANK EMAIL

GENERAL ACCOUNTING CODES (USE IF SPECIAL CODE IS

NOT AVAILABLE FOR THIS NUMBER)

CLIENT # 9999

GENERAL ACCOUNTING CODES 

I HAVE A CHECK WRITING PROGRAM, A NEW CLIENT TABLE AND FORM, AND A TABLE OF ACCOUNTING CODES.

WE WILL INCORPORATE THEM LATER,

 ALL DATA SHOULD BE RELATED SO REPORTS CAN CONTAIN DATA FROM ALL TABLES. 

ABBREVIATE TABLE NAME AND FIELDSFOR EASE OFINCORPORATION IN OTHER MODULES.  USE MY TABLE NAMES AS CAPTIONS . 

I WELCOME YOUR QUESTIONS.  PLEASE ESTIMATE COST AND DELIVERY TIME.

 REPORTS WILL BE REQUESTED AND PAID FOR SEPARATELY AFTER WE RECEIVE AND LOAD THESE TABLES.

THANKS   h

---

This broadcast message was sent to all bidders on Tuesday Mar 2, 2010 9:41:30 AM:

THIS IS A REQUEST FOR A COMPLETE SYSTEM IN ACCESS, VB6, AND VBA. I HAVE OTHER MODULES WHICH WILL LINK TO THIS SYSTEM.I SHOW SUGGESTED FILES AND FIELDS BUT I HAVE NOT CREATED THE TABLES.THE DATA INPUT IN FORMS MUST BE IN COMBO BOXES WITH AUTO COMPLETE.INPUTS ON THE FORM SHOULD BE IN A VERTICAL COLUMNI WELCOME YOUR QUESTIONS.

---

This broadcast message was sent to all bidders on Sunday Apr 11, 2010 4:42:44 PM:

SORRY FOR THE LONG DELAYS. I AM AN ACCOUNTANT AND GOT UNEXPECTEDLY BUSY. I AM COMMITTED THRU 4/15.I WILL NEED ONE DAY TO REST, THEN WILL REVIEW RESPONSES, ANSWER INQUIRES,AND CONTRACT WITH ONE OF YOU BEFORE 4/22. IF YOU ARE NO LONGER INTERESTED, PLEASE WITHDRAW. THANKS FOR YOUR PATIENCE. I KEEP A DEPOSIT WITH RAC, SO WE WILL GO ONCE SOME ONE IS SELECTED. h