Item Sales - Need A Developers Help

[John_Wallace]

I have a client who needs a csv file created with Item Sales invoices based on entered dates using an small App developed using the AccountRight API....

Yes, I know this could be satisfied by using the AccountRight Export but the Item Sales export has one major flaw... The Shipping address is only available in four address fields. The first of these fields (Address Line 1) contains the Customer Name albeit it is included in the Customer Name export field(s) - I think the analysts might have been a bit Tipsy at the time !!  The remaining three export fields (Address Line 2... Line 3... Line 4) are just poplulated by the 1st three lines of the Shipping Address. This means that when there are more shipping adddress lines then the shipping address in incomplete such that the Suburb, State and Postcode may not present in the export.

I examined the MYOB API Item Sales Invoice Endpoint where the Shipping Address is String (255). I have confirmed it contains /r/n characters implicit in the Shipping Address on the Invoice which means it caters for the more than 3 lines (assuming the same export file data analysts were not involved in the spec !)..

If there is any developer who could help with an App, please contact directly me on 042450XXX..

John Wallace

Certified Consultant 

Sydney 

[Phone number removed  by Administrator HB]

[Hannah_B]

Hi @John_Wallace 

Thanks for reaching out, I have just tested this field via the API to make sure this is all pulling through correctly. Below is the maximum amount of characters the API can handle for the shipping address. If you go over the character limit this would give you an error. 

"ShipToAddress": "Hannah Test\r\n123 API Drive\r\nAddress line 1 \r\nAddress line 2\r\nAddress line 3\r\nAddress line 4 \r\nAddress line 5 \r\nAddress line 6 \r\nAddress line 7\r\nAddress line 8\r\nAddress line 9\r\nAddress line 10\r\nAddress line 11\r\nAddress li\r\nBurnside NSW 8023\r\nNew Zealand",

One thing to note is we are unable to import the CSV file via the API. One option could be to look on the MYOB App Marketplace, this is where we host all of the approved 3rd party addons for MYOB. There might already be an app that does what you require via the API. 

The other option is to get a developer to create an app for your needs - you or the developer can register for API access HERE. 

Let us know if you have any questions, 

[John_Wallace]

Thanks Hannah...

I'm aware the shipping address in the EndPoint is a string (255) field which means the full address wont be cut off as happens in the MYOB import/export function.

I'm looking for a freelance MYOB developer to build an App to create a csv file using data from the Item Sales Invoice Endpoint.  The file will be used by a well known third party logistics company to manage the client's warehousing. needs.  

If any of MYOB API Developer Team know of any potential developers out there I would appreciate any help..

[Mike_James]

Hi @John_Wallace , we've created several such solutions over the years, please email me with details of your requirements. 

[John_Wallace]

Hi Mike

Thanks for your response.... 

I'll prepare a high-level spec and email to you ASAP... My client is keen to move forward...

Cheers John..