Skip to main content
Solved

Duplicate Record on Tax ID

  • Mar 11, 2025 1:17 AM UTC
  • 7 replies
  • 129 views
  • Translate All

Forum|alt.badge.img

Good day i have this one last problem on my report it duplicates the taxID 

on every invoice there is a one data that duplicates


actually its not really duplicating 
it adds a tax ID even though its not on the transaction like here it diplays wc158,wc120
 

 

Best answer by jhoncandare04

i already fix this thank you i use APTax. 
 

 

View original

7 replies

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

Hi ​@jhoncandare04 

1/. Please add Join with APTaxTran as shown in the screenshot below.

 

2/. Change Group "TaxCategoryDet.TaxID" to "APTaxTran.TaxID"

 

3/. Add Sum for fields.

 

 

Best Regards,

NNT

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Mar 11, 2025 7:17 AM UTC

​@nhatnghetinh The tax rate is correct, but my issue is the duplicate records in the reports and the Tax ID, as it differs from the transaction.

Translate

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

Hi ​@jhoncandare04 

You need to replace join TaxCategoryDet with APTaxTran and replace all TaxCategoryDet.TaxID in the report with APTaxTran.TaxID

 

Please refer to the attached report file.

 

Best Regards,

NNT

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Mar 11, 2025 8:20 AM UTC

its still the same

 

NVPSCONW02 - WI120 

there is no WI158 in NVPSCONW02 it must be still WI120 

​@nhatnghetinh 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Mar 12, 2025 1:34 AM UTC

This is my issue with this report: the red-marked section is incorrect. Additionally, the straight-line entry is also incorrect because it is a duplicate ​@nhatnghetinh  i use the one you send and its still the same

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • Mar 12, 2025 3:11 AM UTC

i already fix this thank you i use APTax. 
 

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Mar 12, 2025 4:09 AM UTC

Thank you for sharing your solution with the community ​@jhoncandare04!

Translate