Skip to main content
Solved

Duplicate Record on Tax ID

J
Freshman II
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
1 Attachments
Did this topic help you find an answer to your question?

7 replies

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

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

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
Dmitrii Naumov
V
Chris Hackett
3 people like this
  • Dmitrii Naumov
    Dmitrii Naumov
  • V
    vkumar
  • Chris Hackett
    Chris Hackett
J
Freshman II
Forum|alt.badge.img
  • jhoncandare04
  • Author
  • Freshman II
  • 55 replies
  • March 11, 2025

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

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

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

1 Attachments
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
J
Freshman II
Forum|alt.badge.img
  • jhoncandare04
  • Author
  • Freshman II
  • 55 replies
  • March 11, 2025

its still the same

 

NVPSCONW02 - WI120 

there is no WI158 in NVPSCONW02 it must be still WI120 

​@nhatnghetinh 

J
Freshman II
Forum|alt.badge.img
  • jhoncandare04
  • Author
  • Freshman II
  • 55 replies
  • March 12, 2025

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

 

J
Freshman II
Forum|alt.badge.img
  • jhoncandare04
  • Author
  • Freshman II
  • 55 replies
  • Answer
  • March 12, 2025

i already fix this thank you i use APTax. 
 

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2750 replies
  • March 12, 2025

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved