| AP Voucher Transactions Import Program
TechTonics Software Architects, Inc., has
created an auto import for AP Voucher Transactions Import
program. This modification has been written in Visual Basic
and will support either Pervaisive Btrieve or Microsoft SQL-Server.
Do you have clients running Macola Accounting
but running a different Distribution package? Would they
like to quit manually entering the voucher transactions to
keep the Accounts Payables updated?
This application will read a comma delimited
file and populate the needed fields in the AP Voucher Transaction
file along with the AP Voucher Distribution file. Once the
data is imported into Macola, the user can use their existing
Macola program to Print Voucher Transactions to validate
the data and make sure all figures balance before running
the Voucher Post Transaction program.
While the data is being imported, validation
is also taking place on fields such as the customer number.
If any field is in error, the record will not be written
to the sales transaction file but written to the Reprocess
file. The user will have access to a Reprocess screen that
will them to correct the error and send the record back through
the import routine.
AP Voucher Transaction Import Program -
The user will need to log into the AP Voucher Transactions
Import program and select the company they want to import
the data into, as seen in the screen shot below. The username
and the password are from Macola’s password file so
you do not have to create a new login for a user. You will
use your existing Macola login.
Once the user has logged in to the company
they want to process, the next screen will allow the user
to search for the text file to import as seen below in the
screen shot.
Once the user has double clicked on the
file they wish to process, another screen will popup asking
the user to “Process” the file or “Exit” without
processing as seen in the screen shot below.
Once the user processes the file, the actual
importing of the data will populate the AP Voucher Transaction
file and the AP Voucher Distribution file. As the import
program is processing the text file that the user selected,
it will also be validating the data. If any data is in error,
the record will be moved to the reprocess file.
AP Voucher Transaction Reprocess
program – In the second screen shot, you
will see a pushbutton called “Reprocess”. This
pushbutton will start the reprocess functionality that
will allow the user to fix any records that are in error.
The screenshot below, displays all the Voucher
Transactions that are in error. The user will double click
on the document number they wish to reprocess.
Once the user has selected the voucher number
to reprocess, the next screenshot below is the actual Reprocess
screen. A description of the error will be displayed in the
bottom right hand corner. The cursor will be sitting in the
field that is in error. On some fields, full searchable of
Macola data is available.
The user will fix the error and press the
save button, the “Reprocess” program will write
the record back into a comma delimited file and be ready
for importing.
|
