- Posts: 103
- Thank you received: 0
Linking to MYOB
13 years 7 months ago #89338
by gofer123
Linking to MYOB was created by gofer123
Hi,
A client has asked, can Hika (Essential) be linked to MYOB?
Cheers
A client has asked, can Hika (Essential) be linked to MYOB?
Cheers
Please Log in or Create an account to join the conversation.
13 years 7 months ago #89428
by Xavier
Replied by Xavier on topic Linking to MYOB
Hi,
I don't know what MYOB is, and how it's working.
As I can see it allow you to manage your orders, right ?
How to import orders into MYOB ? Via CSV ? Via XML ?
Everything can be possible, but it require a lot of development.
I don't know what MYOB is, and how it's working.
As I can see it allow you to manage your orders, right ?
How to import orders into MYOB ? Via CSV ? Via XML ?
Everything can be possible, but it require a lot of development.
Please Log in or Create an account to join the conversation.
13 years 7 months ago #89522
by gofer123
Replied by gofer123 on topic Linking to MYOB
Hi Xavier,
MYOB is an accounting software similar to Quicken, off the shelf software for small to medium sized businesses.
Cheers
MYOB is an accounting software similar to Quicken, off the shelf software for small to medium sized businesses.
Cheers
Please Log in or Create an account to join the conversation.
13 years 7 months ago #89545
by nicolas
Replied by nicolas on topic Linking to MYOB
Hi,
There is probably a CSV import tool in MYOB and so you should be able to export the orders in HikaShop and then import them in MYOB manually. That might require editing the CSV with excel to change the column names to the ones of MYOB unless it has some tool to handle that.
But there is no automatic tool for that for now.
There is probably a CSV import tool in MYOB and so you should be able to export the orders in HikaShop and then import them in MYOB manually. That might require editing the CSV with excel to change the column names to the ones of MYOB unless it has some tool to handle that.
But there is no automatic tool for that for now.
Please Log in or Create an account to join the conversation.
13 years 7 months ago #89548
by gofer123
Replied by gofer123 on topic Linking to MYOB
OK, thanks nicolas
Please Log in or Create an account to join the conversation.
13 years 5 months ago #99470
by JIK
Replied by JIK on topic Linking to MYOB
I've successfully done this using the export order function in Hikashop to get all orders into a csv. I've found that importing the file into MS Access works best to create an automated and properly formated file for import into MYOB. Better than using Excel and you can then send an automated email as well, or use the MYOB Odbc connector.
From Hikashop version 1.59+ you'll need to format the price fields in the Hikashop data to round the values properly as MYOB rounds everything greater than 2 decimals which sometimes leads to incorrect order values and GST calculations in MYOB. It took me a LOT of time to get this right but now works perfectly.
Going from MYOB to Hikashop is more problematic especially when trying to update the inventory, but essentially connecting the two is do-able.
From Hikashop version 1.59+ you'll need to format the price fields in the Hikashop data to round the values properly as MYOB rounds everything greater than 2 decimals which sometimes leads to incorrect order values and GST calculations in MYOB. It took me a LOT of time to get this right but now works perfectly.
Going from MYOB to Hikashop is more problematic especially when trying to update the inventory, but essentially connecting the two is do-able.
The following user(s) said Thank You: nicolas
Please Log in or Create an account to join the conversation.
Time to create page: 0.194 seconds