| AR Sales Transactions Import Program
TechTonics Software Architects, Inc., has created an auto
import for AR Sales 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 sales transactions to keep the customers
accounts updated?
This application will read a comma delimited file and populate
the needed fields in the AR Sales Transaction file along
with the AR Sales Distribution file. Once the data is imported
into Macola, the user can use their existing Macola program
to Print Sales Transactions to validate the data and make
sure all figures balance before running the Sales 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.
AR Sales Transaction Import Program - The user will need to log into the AR Sales 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 AR Sales Transaction file and
the AR Sales 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.
AR Sales 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 Sales Transactions
that are in error. The user will double click on the document
number they wish to reprocess.
Once the user has selected the document 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.
|
