Forum Discussion

John_Wallace's avatar
John_Wallace
Experienced Cover User
5 years ago

Item Sales - Need A Developers Help

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]

  • Han-Solo's avatar
    Han-Solo
    MYOB Moderator

    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's avatar
      John_Wallace
      Experienced Cover User

      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's avatar
        Mike_James
        Ultimate Cover User

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