Skip to main content
Solved

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

  • July 14, 2025
  • 6 replies
  • 150 views
  • Translate All

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.

 

View original

6 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@PanteaShahrian 

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

 

Best Regards,

NNT

Translate

Forum|alt.badge.img

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

Best regards,
Pantea

Translate

DrewNisley
Pro I
Forum|alt.badge.img+4

​@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)

Translate

Forum|alt.badge.img

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

I appreciate your help in advance.
Pantea

Translate

DrewNisley
Pro I
Forum|alt.badge.img+4

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.

 

Translate

Forum|alt.badge.img

​@nhatnghetinh ​@DrewNisley 
Thank you for your support.

Translate