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. It would take me months to go through each idividual subcontractor to check! :smileysad:

 

Please help!

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

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.