Skip to main content
Solved

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

  • February 10, 2021
  • 2 replies
  • 173 views

Forum|alt.badge.img+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 

Best answer by EntNadeeL

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,

This topic has been closed for replies.

2 replies

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 182 replies
  • Answer
  • February 18, 2021

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,


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 78 replies
  • February 22, 2021

Hi @EntNadeeL 

 

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

 

Kind regards, 

Simon