POS software data exportation to QuickBooks & MYOB

Hello Team

I’ve been playing around with importing data from the Amicus POS system into QuickBooks & MYOB accounting software solutions and have unearthed a little more information that you may not have been aware of in regards to the third party software.

Firstly, let me confirm that the importation process can be automated from the third party software via its front end. Basically it will set up a service that monitors the contents of a folder for a specific file type and uses pre-defined column mappings to import them. So combined with our Amicus POS software data exportation service, this should really be a set and forget process.

Currently we can import invoices & sales receipts into MYOB. In addition to these types, we can also import payments, bills and credit memos into QuickBooks.

Although currently the Amicus data exportation service is geared for quick books, the column mapping protocol for the third party software is quite straight forward, and better still, once we have done it once, we can pass around the Settings.xml file complete with mappings to all customers.

I have found one minor problem with the MYOB importation however. It appears that MYOB is only geared towards a maximum of 8 characters for sale numbers. Currently Amicus revolves around int64 sale numbers (20 chars). We are currently investigating the most efficient way to transform our decimal numbers into a shorter form (perhaps base 36?). What does this mean for our clients? For the majority of our clients (particularly those in single site fuel, retail or hospitality sectors), this will not be an issue. For our larger multi-site supermarket chains however, potentially producing thousands of sale records per day, we will need to give them the modified exportation service.

If you have any further questions, just drop me a line.

Dave