Skip to main content
Answer

Duplicate Line Items Due to Reverse Charge – Report Designer Filter Needed

  • July 14, 2025
  • 6 replies
  • 95 views

Forum|alt.badge.img

Hello 🙂, 
my issue is that due to reverse charge (i.e., input/output VAT handling), the line items appear twice on the document.

I want to create a filter in the Report Designer to correct this duplication.
Does anyone have an idea how I could solve this problem?

Below are a few images that illustrate the issue.

 


 

 

Best answer by DrewNisley

Actually, you should just be able to put it in the filter. Just filter out the ID of your VAT taxes in the filter section of the report designer. This should stop it from duplicating and shouldn’t take away anything from the report as long as you weren’t using VAT values anywhere on the report.

 

6 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • July 14, 2025

Hi ​@PanteaShahrian 

Try creating conditions at VisibleExpr, get only what data you want.

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 14, 2025

Hi ​@nhatnghetinh
I tried that, unfortunately it doesn’t work. 
As I mentioned, it’s about the reverse charge.

Best regards,
Pantea


DrewNisley
Pro I
Forum|alt.badge.img+3
  • Pro I
  • July 14, 2025

@PanteaShahrian You should just be able to make an exclusion in your join to the POTaxTran table, saying that the Tax ID NotEqual to ‘EU B2B VST19’ (I assume that is your VAT Tax ID)


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • July 15, 2025

Hi ​@DrewNisley  ,
Can you explain it in more detail?

I appreciate your help in advance.
Pantea


DrewNisley
Pro I
Forum|alt.badge.img+3
  • Pro I
  • Answer
  • July 15, 2025

Actually, you should just be able to put it in the filter. Just filter out the ID of your VAT taxes in the filter section of the report designer. This should stop it from duplicating and shouldn’t take away anything from the report as long as you weren’t using VAT values anywhere on the report.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • September 26, 2025

@nhatnghetinh ​@DrewNisley 
Thank you for your support.