cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Established Member
Solved

I'm running a find report of sales orders for a week, showing details only. I want to filter out GST lines. Anyone know how to do get rid of the GST lines from the report

I managed to get rid of the $0 lines by filtering amount >= -0.01 (which doesn't make sense, but it works) but I can't find anything that will let me hide the tax lines, which are irrelevant for my purposes.

Best answer 3 weeks ago

Accepted Solutions
Community Backer ***

Re: I'm running a find report of sales orders for a week, showing details only. I want to filter out GST lines. Anyone know how to do get rid of the GST lines from the report

Hello @don18 , 

 

The 'Open Sales Orders by Item' gives you the amount detail net of taxes, without you having to customize the report in any way.

 

You can also run the 'Open Sales Orders by Customer', but you would have to adjust the filters as follows:  1) Remove the Summary Only from the 'Detail Level' filter; 2) Under 'Account' filter, choose 'Multiple Accounts, Select All, then Clear your GL tax accounts (GST Payable and PST Payable) and finally; 3) under 'Amount' filter, choose =< 0.00.

 

You can also run the  'Pending Sales' report, but you would have to 1) enable Sales Orders on the Account filter; 2) Remove the Summary Only filter from the 'Detail Level' filter; 3) Under 'Account' filter, choose 'Multiple Accounts, Select All, then Clear your GL tax accounts (GST Payable and PST Payable) and finally 4) under 'Amount' filter, choose =< 0.00.

 

You can also make your own 'Custom Transaction Detail Report' and filter as follows:  1) Account filter choose 'Multiple Accounts', Select All, then Clear GST Payalbe & PST Payable; 2) Detail level filter choose 'All except summary'; 3) Posting Status filter choose 'Non-posting' and 4) Transaction Type filter choose 'Sales Order'.

 

Choose whichever you prefer, change the name as you like and save as a memorized report.

3 Comments
Established Member

Re: I'm running a find report of sales orders for a week, showing details only. I want to filter out GST lines. Anyone know how to do get rid of the GST lines from the report

Is that your way of telling me to call support? Because they don't answer their phone.

 

Ok, they did answer the phone this time. And then wasted half an hour of my day trying to sell me a new support package so they could build me a custom report instead of just answering my simple question.

 

I thought this was going to be a 30 second google search, not a an all-morning struggle to get a simple answer.

Community Backer ***

Re: I'm running a find report of sales orders for a week, showing details only. I want to filter out GST lines. Anyone know how to do get rid of the GST lines from the report

Hello @don18 , 

 

The 'Open Sales Orders by Item' gives you the amount detail net of taxes, without you having to customize the report in any way.

 

You can also run the 'Open Sales Orders by Customer', but you would have to adjust the filters as follows:  1) Remove the Summary Only from the 'Detail Level' filter; 2) Under 'Account' filter, choose 'Multiple Accounts, Select All, then Clear your GL tax accounts (GST Payable and PST Payable) and finally; 3) under 'Amount' filter, choose =< 0.00.

 

You can also run the  'Pending Sales' report, but you would have to 1) enable Sales Orders on the Account filter; 2) Remove the Summary Only filter from the 'Detail Level' filter; 3) Under 'Account' filter, choose 'Multiple Accounts, Select All, then Clear your GL tax accounts (GST Payable and PST Payable) and finally 4) under 'Amount' filter, choose =< 0.00.

 

You can also make your own 'Custom Transaction Detail Report' and filter as follows:  1) Account filter choose 'Multiple Accounts', Select All, then Clear GST Payalbe & PST Payable; 2) Detail level filter choose 'All except summary'; 3) Posting Status filter choose 'Non-posting' and 4) Transaction Type filter choose 'Sales Order'.

 

Choose whichever you prefer, change the name as you like and save as a memorized report.

Established Member

Re: I'm running a find report of sales orders for a week, showing details only. I want to filter out GST lines. Anyone know how to do get rid of the GST lines from the report

Thanks @Rochelley 

I set up a custom transaction detail report as you detailed and was able to get exactly the report I wanted.