TPAR

[mpauly]

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!

Please help!

[gavin12345]

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]

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 · Accepted solution]

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]

Thanks Gavin 

I will give this a try