|
ODBC
Report Writing
Our
development team has many years of experience
in designing professional, complex management
reports and applets using SQL and various report
writing tools.
Now
we can extract your accounting data and present
it to you in many different formats which will
enable you to look at the performance of your
business in several new ways.
Just
have a look at our client case studies to see
the types of things that we can do:
Geminex
Industries
This
is one of our flagship sites, where we designed
an entire ecommerce system based around their
Attache accounting system and a dynamic web site.
You can read more about Geminex in our client
profile section, but basically, what we did here
was to design a back end order processing system
which extracted data from Attache and posts it
to their web site so that their major clients
can order on line.
At
the end of the day, their staff can collate the
orders from the site and read them into Attache
automatically. We use ODBC here to read product,
customer and special pricing information into
their web back end system which we wrote in house.
Transhose
NT
Transhose
are one of the largest hose & fittings providers
in the NT. They carry a huge amount of items in
their warehouse, but the tricky part is that their
stock is a mix of pre purchased stock, as well
as consignment stock from their suppliers.
Attache
unfortunately only tracks one type of stock level,
so we had to write a custom application which
separated the consignment stock from the regular
stock, and tracked receipts as well as sales to
see when purchase orders had to be raised (if
consignment stock had been used up).
This
system was written using a combination of Presenter's
ODBC routines and Microsoft Access.
PTM
Homes
PTM
is one of Darwin's leading building companies.
They needed a way to collate their customer invoices
to the supplier invoices so that they could properly
cost their housing development projects.
Unfortunately,
there is no easy way to link customer invoices
to supplier invoices in Attache. However, using
ODBC and some tweaking of their invoice screens,
we managed to link the two together using job
numbering.
Now,
their admin staff can select a particular job
number, and see just how much they spent with
their suppliers, and how much they charged their
customer to ensure that they are making a profit!
The
system is flexible enough to enable multiple supplier
invoice lines to be allocated to different customer
jobs.
Neata
Glass Services
This
company has had custom Microsoft Access reports
written by their previous group accountant. These
used to use Report Writer reports which generated
text files on disk that they used to read in to
generate the reports.
They
wanted to update their system so that they could
use ODBC to read the information directly into
Access, and that is where we came in.
The
queries were extremely complex, and used many
embedded Jet Functions to collate data from their
payroll system and calculate the final figures
in order to print Superannuation reports, and
cost centre reports.
AFL
Northern Territory
The
AFL have an extremely complex general ledger chart
structure, with over 20 cost centres in 'mini'
profit and loss statements. They wanted a way
to collate similar accounts from several cost
centres together in one.
Using
ODBC, we used inbuilt SQL functions to split the
GL codes into cost centres and summate each individual
code into Excel. We then set up several formulas
which enabled cross referencing to create a smart
looking profit and loss statements in Excel.
Better
Business Systems (NSW)
This
is a job we did for another Attache agent in NSW.
Mary from BBS had a client who wanted to generate
a list of customer transaction, grouped by invoice
and the realted payments - much as you see in
the customer enquiry screen within Attache.
Strangely
enough, Attache does not produce such a report,
so we used ODBC and Microsoft Access to generate
a quick report from the customer transaction file.
Southern
Cross Logistics
SCL
have a logistics base at the new East Arm wharf
in Darwin. They have very large contracts with
several large offshore and shipping companies
to provide logistical services to them.
They
needed a method to ensure that everything their
customer ordered was in turn ordered from their
own suppliers, and as mentioned earlier, Attache
is decidedly weak in linking customer orders to
supplier orders in turn.
This
is where we came in and wrote a small Microsoft
Access database which allows them to compare whether
every item on a customer order has a matching
supplier order, and vice versa. They can also
then compare how much they spent with their suppliers
versus how much they charged their customers to
work out profit percentage easily, with a press
of a button.
Group
Training Northern Territory
The
CEO of Group Training needed an easy way to extract
General Ledger financial information into an Excel
spreadsheet in order to present it to the board.
This was done easily using Microsoft Query and
Excel.
We
are currently working on another project with
them which will extract payroll information about
their placed trainees, and collate it onto a spreadsheet
for performance and cost reporting to their host
employers.
|
