Forum Discussion

The_Doc's avatar
The_Doc
Ultimate Cover User
5 months ago

Emailing Invoices using API send endpoint

A very annoying missing part of this very good endpoint is that the status on the invoice is not updated to 'already printed or sent' from 'to be emailed'.

 

Do it from within MYOB - and this status is updated - via the API the status in not updated.

 

This is a bit of a letdown on a very useful feature.

 

Why is it annoying - when you do everything via the API - from Orders, BackOrders, to converting an Order into a Sales Invoice - the final part is emailing - up to here - everything can be done via the API - except updating that status.

 

Am I missing something with the endpoint? or is this just something it cannot do.

The Doc

 

13 Replies

  • The_Doc's avatar
    The_Doc
    Ultimate Cover User
    4 months ago

    Hi ROC_MYOB​ 

     

    This endpoint gets worse - I found another bug which is nasty.

    It does not seem to be able to handle the unusual format of the email address that MYOB uses for sending invoices to in-trays on MYOB - '17685900-0a92-48e6-9aae-9b990690c663@document.myob.com' - works fine if done manually from within MYOB emailing but via the email endpoint it doesn't go out - or vanishes into the ether.

    I have tested this numerous times to authenticate this bug - if you open an email sent via the endpoint to confirm received it indicates it was received - but it isn't there.

    My client has 15 plus franchises each with their own MYOB via - even though I have now sent out over 500 invoices using the endpoint - none have been received by these franchises - yet send them from within MYOB and they are received - is my endpoint working correctly - yes - the 1st thing I checked to ensure I wasn't truncating email addresses as they are quite long - grr - I have now to resend manually over 200 invoices. 

     

    This is not good MYOB - haven't heard back on the original bug - you didn't call me when I set a time for a call at your request and now this new bug.

     

    The Doc

  • The_Doc's avatar
    The_Doc
    Ultimate Cover User
    4 months ago

    Hi ROC_MYOB​ 

     

    This endpoint would appear to be merely the result, not the cause of a problem in emailing from MYOB - something I long ago suspected as faulty but could get no traction with MYOB.

     

    The endpoint may just be leveraging a faulty emailing code within MYOB - however, I do not have cast-iron proof just suspicions that go back years and the suspicions heightened recently.

    After writing code to auto-invoice for a client - something that manual staff were dropping the ball on regularly, delaying completed orders conversion to invoices and emailing out the invoice for account customers for up to 3 weeks sometimes to the tune of 500k in revenue - then auto-invoicing came as a breeze of fresh air - hmm - but doubled edged it seems.

     

    Everything worked - it was tested - emailing using the emailing endpoint and a normal email address eg

     

    mailto:bob@thehappyhomre.com.au  - it worked well - however, I didn't test emailing to MYOB's in-trays in MYOB files email addresses look like this

    mailto:17685907-0a92-48e6-9aae-9b980690c663@document.myob.com which nicely puts invoices into MYOB file in-trays.

     

    80% of my client's customers were franchisees running MYOB files they managed and the email addresses were of this type.  On the 3rd day of running the new code we had a catchup to do 344  invoices to go out - code worked beautifully - 

     

    1. Check Web status - Order Completed - tick
    2. Download Sales Order from MYOB - as Sales Order from Web may not be upto date - orders change
    3. Create invoice and POST to MYOB via API- tick
    4. Delete Sales order - through API - tick
    5. Download Sales Invoices - as UID is needed to email invoice - tick worked
    6. Download Customers from MYOB to check email address - tick
    7. Email Invoices using email endpoint - 100% error free - not 1 error 

     

    344 invoices sent - ALL clients with in-tray emails - 80% never received invoices; YET - check the emailing app in MYOB - sent emails - it shows email sent AND RECEIVED!

    And worse - yesterday when we found this error - the emailing app in MYOB just timed out saying cannot connect - and nothing to do with internet access, slow internet - I am on very fast NBN - open 2 other MYOB files at the same time - select the email app in the file - pops up instantly.

     

    So my client had to go into each of these invoices - now up to 500 because that is how many in the past week not sent out by the emailing app that had to be manually opened - select - 'send email' - top left and sent. That appears to work - though I need that confirmed.

     

    2 years ago on my son's business myob file - payslips were sent to staff - every single pay period - emails for some staff were not received - dropped, missed or mysteriously vanished. This problem not pops up as a warning I suspect.

     

    Houston - we have a problem - I cannot rely on the emailing up in MYOB to send invoices to clients. 

     

    I am now coding my auto-invoicing app to send out invoices via CDO code from my application which does not use Outlook as the emailer - in the past this process works 100% or tells you with an error.

     

    Folks I am not saying categorically there is a problem but you know the saying about smelling like duck poo, looking like duck poo etc. 

     

    The end point may not actually be the culprit but then I don't think it is Lilly white.

     

    If you want to discuss MYOB please call me 0415262694

     

    The Doc

     

  • The_Doc's avatar
    The_Doc
    Ultimate Cover User
    4 months ago

    Hi ROC_MYOB​ 

     

    Well, MYOB, a reprieve - just had a brainflash overnight and realised that thee reason these clients aren't getting invoices to their in-try emails is not because they aren't going out - they are, BUT ......... the original 2 problems with this endpoint were - 

    1. that it was the queuing the delioverystatus from 'to be emailed' to émailed', and
    2. it wasn't attaching an invoice according to the emailing instructions in MYOB - 'add link to invoice and attach invoice' - and the endpoint doesn't, or is unable to attach an invoice.

    So - emailing to an in-tray email address will appear to 'not occur' - but look at the email status in MYOB and it says 'sent' and 'received' - but there is no attached invoice ( for reason 2 above) so nothing appears in the in-tray - and this is seen as 'not sent'.

     

    So the fault is the endpoint MYOB - however, notwithstanding - emailing within MYOB facility is slow, times out and is NOT 100% - that still stands as a complaint - whereas if you send from say outlook - you get an error message back.

     

    So my fall back is to create an external pdf of the invoice and email it using an external emailer - this is the solution now being worked on.

     

    Oh -  there is another endpoint - 'render invoice to pdf' - yep but just cannot get this to work ......

     

    The Doc

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.