Skip to main content
Solved

Duplicate Record on Tax ID

  • March 11, 2025
  • 7 replies
  • 129 views
  • Translate All
Jr Varsity III
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+14

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
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Jr Varsity III
    Forum|alt.badge.img

    ​@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+14

    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
    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      Jr Varsity III
      Forum|alt.badge.img

      its still the same

       

      NVPSCONW02 - WI120 

      there is no WI158 in NVPSCONW02 it must be still WI120 

      ​@nhatnghetinh 

      Translate
      Jr Varsity III
      Forum|alt.badge.img

      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
      Jr Varsity III
      Forum|alt.badge.img
      • jhoncandare04
      • Author
      • Jr Varsity III
      • Answer
      • March 12, 2025

      i already fix this thank you i use APTax. 
       

       

      Translate
        Chris Hackett
        Community Manager
        Forum|alt.badge.img
        • Chris Hackett
        • Acumatica Community Manager
        • March 12, 2025

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

        Translate
        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*.
        Terms & ConditionsAccessibility statement
        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