Forum Discussion

mpauly's avatar
mpauly
Experienced User
4 years ago

TPAR

Hi I need to find a way to print a report to include Ticked or Non Ticked subcontractors for Reportabel Tax Payments. I am required to advise OSR which contractors have not been ticked to report. I...
Purchases
TPAR
  • gavin12345's avatar
    gavin12345
    4 years ago

    Hi mpauly 

     

    All exports are text files, either tab delimited or CSV based on your choice. If not sure how to open these in excel, do an internet search, I'm sure you will find some posts that are easy to follow.

     

    An export includes all records, there is a column for Inactive. Sort in excel to isolate what you need, for example sort all to find the Active ones only, then sort those to find where TPAR has been selected.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
4 years ago

Hi mpauly 

 

Note sure if there is a report (others user might know), however if you Export Supplier Cards and then open in Excel you will find a field for TPAR.

 

Regards

Gavin

  • mpauly's avatar
    mpauly
    Experienced User
    4 years ago

    Thanks Gavin - This is a good solution - however only could export as a Text doc, couldn't find how to open in Excel? Plus all cards even inactive cards show - problem being really old suppliers don't have TPAR ticked.

     

    • gavin12345's avatar
      gavin12345
      Ultimate User
      4 years ago

      Hi mpauly 

       

      All exports are text files, either tab delimited or CSV based on your choice. If not sure how to open these in excel, do an internet search, I'm sure you will find some posts that are easy to follow.

       

      An export includes all records, there is a column for Inactive. Sort in excel to isolate what you need, for example sort all to find the Active ones only, then sort those to find where TPAR has been selected.

       

      Regards

      Gavin

      • mpauly's avatar
        mpauly
        Experienced User
        4 years ago

        Thanks Gavin 

        I will give this a try :)

Looking for something else?

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

Community home

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