Forum Discussion

toofless's avatar
toofless
Experienced User
4 years ago

File formats available for importing supplier invoices to In-Tray

So I spoke with my major supplier about how to get my invoices directly sent to MYOB.  They use a system that  is capable of sending in PDF, Excel or "System Import" - which includes an option for Xero versions depending upon your software I guess.

 

I can import the PDF by sending direct via my email as per the tutorial on where to find the 'In-Tray' email address....that is easy.   But it is not much different really to how I have been doing this for over 3 years now, just manually saving to my file system, then using the "Add Documents' tab.  Saves about 2 steps....

 

I tried practising on the Clearwater practice Company, but that one doesn't allow email addresses.....obvious why I guess.   So I didn't get any further.

 

Can we import using Excel formats?   Or is that not an option now?

 

Only minutes away from turning to alcohol....if that will help.  

 

 

6 Replies

Replies have been turned off for this discussion
  • toofless's avatar
    toofless
    Experienced User
    4 years ago

    Thanks Chris, I will try that out now.  

  • toofless's avatar
    toofless
    Experienced User
    4 years ago

    I've spent an hour on this solution now.....getting the bottle out now.

     

    That test company doesn't place nice like it should.

  • ChrisMYOB's avatar
    ChrisMYOB
    Former Staff
    4 years ago

    Can you please provide some more information about what you mean by it doesn't place like it should and any details on any errors when importing. If you can, please also provide screenshots to assist in troubleshooting. 

  • toofless's avatar
    toofless
    Experienced User
    4 years ago

    I meant "didn't play nice" .....spell check or predictive is fighting me here.  :smileymad:

     

    I will try again tomorrow, but the upshot is that the spreadsheet is either not recognised by the company file, or for some reason I cannot get the fields to upload for importation as it showed in the video tutorial.  

     

     

  • ChrisMYOB's avatar
    ChrisMYOB
    Former Staff
    4 years ago

    I’m sorry I think I think there is some confusion about the response.
    You are unable to import/email Excel documents into the Intray, which is why you would have got that email with the specifications of what can be.

    The way I had provided is done through the import wizard by going into the file menu and choosing Import/Export Assistant.

    If wanting to just use the In-tray you are unable to email excel sheets to the in-tray.

    I hope that clears things up a bit.