Forum Discussion

NinnessD's avatar
NinnessD
User
2 years ago

Supplier payment terms report

Hi, how can I run a report including exporting to excel on supplier payment terms. Want to check which supplier have terms and which do not etc. Have tried multiple options but cannot get the informa...
Digiwise's avatar
Digiwise
Experienced Partner

Hi Darren,

 

Have you tried exporting suppliers to a text file and then opening the text file in Excel?

 

They're are other options like reporting / data extraction add-ons (including one we have developed) that can do this and so much more.  However, for one-off or occassional supplier data checks, exporting a text file might be sufficient.  Let us know if you would like more information.

 

Regards,

Clancy

 

NinnessD's avatar
NinnessD
User
2 years ago

Thanks Clancy, however I cannot see an option to export as a text file. The only option for exporting was pdf or xps. I must be doing something wrong.

  • Digiwise's avatar
    Digiwise
    Experienced Partner
    2 years ago

    Hi Darren ( NinnessD )

     

    From MYOB's main menu at the top of the screen select File -> Import/Export Assistant.  Then choose Export Data, then choose "Cards".  Once there you can select the fields suggested by ChrisMYOB .

     

    Clancy