Pat Jones FCMA

View Pat Jones's LinkedIn profileView Pat Jones’s profile

pnjonesI started my professional career as an accountant and developed many excel and access based systems which bridged the gaps in the finance systems. Over the years I was involved in implementing major system changes in many firms including a European Logistics System and a worldwide accounting System using by skills as a Business Analyst and VBA modeller.

Some of the systems include

  • MASC (Mobile Automated Sales Control) is designed to eliminate manual delivery dockets and links to accounting systems, the system is written in Access and Satellite forms (Handheld Software).
  • Freight bookings – Developed for a client this system is designed in Access linked to SQL Server and includes XML booking transfers, SMS confirmations and Supplier invoice matching.
  • Sales order automation ; We developed an Sales Order import program in Microsoft Access that load an XML sales order ; validates the data and loads the order in Syspro using Syspro business objects.
  • Invoice Mailing – Batch Emailing and Faxing of Sales Invoices or Statements using MS Access and linked to Sage Line 50.
  • Database systems for Research reporting and Payroll budgeting
  • Developing systems enhancement and reports for Sage Line 50, Intact Business Accounting and Syspro.

You can contact me by email

If you need some help on a project drop leave a comment on the post and I will reply.