cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Reply to message

View discussion in a popup

Replying to:
Rochelley
Level 8

Reply to message

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.

View solution in original post

Need to get in touch?

Contact us