Solved

Quick Reports: how to join total purchase order amount including charges in one report?

  • 10 February 2021
  • 2 replies
  • 157 views
B
Rank
Userlevel 4
Badge +9

Hi, 

I am trying to create a quick report. I want to show the total amount of a purchase order including possible charges on that order, preferably in one column. There is a column ‘Total Gross incl Chrg/Curr’ but this is including tax. I want to show the amount excluding tax. Is there a way to make this happen? 

Kind regards,

Simon 

icon

Best answer by EntNadeeL 18 February 2021, 06:25

View original
Kind regards, Simon
This topic has been closed for comments

2 replies

EntNadeeL
Rank
Userlevel 5
Badge +9

Hi @BZNSIMON ,

Hope I understood your requirement correctly.

You can get the Total Gross incl Chrg/Curr excluding tax by reducing Tot Tax Amt/Curr.

If you need to remove the tax from charge also, then you need to reduce Tot Tax Amt/Curr amount from  Total Gross incl Chrg/Curr in Charges tab also.

Thanks,

Kind Regards,

Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
B
Rank
Userlevel 4
Badge +9

Hi @EntNadeeL 

 

Thank you for your help. I did manage to get the result I wanted. 

 

Kind regards, 

Simon

Kind regards, Simon
Terms & ConditionsCookie settings