Partner Zone
Partner Zone

Importing bulk invoices into MYOB Exo

Partner ferret_Malita
2 Posts
Partner
ferret_Malita

2Posts

0Kudos

0Solutions

Importing bulk invoices into MYOB Exo

Hi,

 

I have searched through the MYOB Exo developer API documentation as well the forums but am unable to find any information on how to import bulk purchases / supplier invoices into MYOB Exo.

 

Firstly, is this possible via the API or any other method? If so, how would we go about doing this.

 

Any help would be highly appreciated.

3 REPLIES 3
MYOB Staff Post CarlBrooks
214 Posts
MYOB Staff Post
Australia
CarlBrooks
MYOB Staff Post

214Posts

59Kudos

23Solutions

Re: Importing bulk invoices into MYOB Exo

Hi @ferret_Malita 

 

The Puchase Orders and Purchase invoices screens are not natively exposed through the standard END POINTS, see http://developer.myob.com/api/exo/endpoints/

 

But the product does allow custom tables to be exposed which could be used as an alternative, see more at 

http://developer.myob.com/api/exo/endpoints/custom-table/

 

There are other approaches available so you are not just stuck with the API as your only choice, within the EXO CONFIG module there is the ability to import data through a CSV Config wizard but this is primarly for preparation for go live rahter than to be used on an ongoing basis. 

 

EXO Business is built on a SQL Database which is not locked and can be exposed with correct SQL permissions so you could write directly to the tables. 

 

Good Luck !

 

Carl

 

MYOB Staff Post CarlBrooks
214 Posts
MYOB Staff Post
Australia
CarlBrooks
MYOB Staff Post

214Posts

59Kudos

23Solutions

Re: Importing bulk invoices into MYOB Exo

Hi @ferret_Malita 

 

I also completely forgot abotu Quick Insert as another alternative, more can be understood at http://help.myob.com.au/exo/whitepapers/MYOB%20EXO%20Business%20-%20Quick%20Insert.pdf#search=%22qui...

 

 

Valued Partner Steve_Marriott
193 Posts
Valued Partner
Australia
Steve_Marriott
Valued Partner

193Posts

48Kudos

14Solutions

Re: Importing bulk invoices into MYOB Exo

Hi @ferret_Malita 

 

1 of the drawbacks to using @CarlBrooks suggestion of using the Custom Tables is that NO checks are performed on the data that is entered into the system. You could end up posting an invoice to a Creditor account that doesn't exist, to GL codes that dont exist or using Stock Codes that aren't setup. The Header may not addup to the sum of the line. I guess that is the having an open database has lots of pluses but also drawbacks. Also, the cost of the fixing will high, from the Exo Partner concerned.

 

We (Very Impressive Software) have an API that does have Creditor Transactions that can be licenced on a per client basis that will perform all the checks (period is open, lines total to header, everything valid, correct tax rates applied) nessasary to post to Exo. 

 

Regards

 

Steve.

 

Steve Marriott
Very Impressive Software
steve@veryimpressive.co.nz
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post