RAS_EDI
Digital data flows in and out of SAGE 50 Accounts.
▼ more
RAS_EDI - More information
included:
- the import of product data files into the SAGE Product list
- the import of cost price updates into the SAGE Product list
- the import of orders coming from various online ordering web sites into either SAGE invoices or sales orders
- the import of supplier Purchase ledger transaction batches directly into the audit trail
- the import of Sales and Purchase ledger data from csv files
- the export of supplier back office orders from SAGE invoices, sales orders or purchase orders
- back to back orders - SAGE invoices or sales orders to SAGE purchase orders
- ftp interface with suppliers' dedicated ftp servers
- 'plug in modules' which permitted new imports to be quickly added
|
|
MS Access based projects
Business productivity applications using Microsoft Office Access as the base platform.
▼ more
Client 1
- Management of complex product codes, import into SAGE Product list, upload to client web site and complex stock take and valuation reports.
Client 2
- Complete replacement of SAGE sales order and invoicing functions,
- with product management and pricing including export to SAGE and import of new prices from xls files,
- customer management including price lists, customer special prices and export to SAGE, van routing,
- daily orders with order acknowledgements/delivery notes/van delivery schedules and production analysis,
- supplier orders with analysis by supplier groups and internal order transfer between companies,
- invoicing with batch production of invoice pdfs and batch emailing of pdfs to customers,
- invoice batch export to SAGE.
- The client operates in a multi-company environment.
Client 3
- Customer management with customer calls, van routing and adoption of price files to extend SAGE standard 5 x discount letters.
- Export of customer and pricing data to SAGE;
- Product management with price lists and customer special prices,
including the addition of product groups to simplify and speed up the creation of product discounts.
Summary or expanded price list reports.
- Export of product and price lists / customer special prices to SAGE.
- Purchase invoice daybook with easy cloning of existing records, filtering by month, analysis reports, and export to SAGE.
A superb module for processing and matching multiple purchase invoices from large suppliers.
|
|
Applets
I used the word 'applet' to describe my compact yet very powerful range of
bespoke programs which could do all sorts of tasks.
▼ more
Just some of the bigger applets:
Ini-File-Ed
Setup / ini file editor. Ini-File-Ed works by reading
in one or more user created 'description' files which lay out the arrangement of
one or more setup/ini files requiring to be edited. The resulting setup/ini
files are then available for use by other applications. RAS_EDI very much
depends on Ini-File-Ed because of the very comprehensive number of setup
values required to setup the execution of a data flow in or out of SAGE.
run7zip
run7zip is designed to manage backup and restore operations using
the free 7-Zip file archiver program. The user will typically
first see the run7zip user interface which allows backup zip files to be
created and stored in a user chosen location. Previous backups can be
selected and restored. The backups can be scheduled using the windows
scheduler. Comprehensive log files are maintained. The user
can optionally choose to replicate an individual backup zip file to a
secondary location, and can also apply retention policies to the zip and
log files to prevent the files gobbling up space. The software is
designed to run on a server but can be setup in such a way as to permit
the server settings to be used on a workstation.
SndMailA
A program to send emails via smtp. The emails may have the 'to' and
'from' addresses specified, as well as including a 'subject', 'body file'
and 'attachment file'. The smtp server parameters are held in a separate file.
A set of variables may be passed into SndMailA via a setup file.
These variables may then be substituted not only in the message body
file but also in several of the ini files used by SndMailA.
SndMailA can send batches of emails. A summary outcome of
the send mail process for each message being sent can optionally be
recorded. The outcome file can be accessed by a higher level
application after the batch has been sent.
The variable substitution and batch outcome facilities are both used in
the 'client 2 - MS Access replacement of SAGE sales order and
invoicing functions' project as described above. The use of variables
permits outgoing batch invoice emails to have their settings tailored to
each company and the outcome of each email sent is recorded in the
relevant invoice record in the main application data set.
|
|