Forum Discussion

mpauly's avatar
mpauly
Experienced User
4 years ago
Solved

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

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 :)