Skip to main content
Answer

Customizing SO643000 Report

  • October 29, 2025
  • 3 replies
  • 46 views
T
Captain I
Forum|alt.badge.img+3

Hi everyone,
I am customizing report SO643000 (Invoice) and I need to show the tax amount for items that actually have tax. I joined ARTax to ARTran on TranType, RefNbr, and LineNbr. The tax value appears correctly, but after adding ARTax, the same item starts printing twice. One row shows the tax and the other is blank.

My goal:
 Print each item only one time
Show the tax amount only for items that have tax
Do not repeat or duplicate the item row 

Has anyone done this before on SO643000?
Is there a recommended way to show ARTax.CuryTaxAmt for an item only if that item has a tax record, without causing duplicate ARTran rows?

Any guidance, formulas, or examples would be greatly appreciated. I have attached Report

 

Best answer by tahayabali

Thanks for sharing but i already found the solution. Another group created basd on line nbr and push all fields of details inside it.

1 Attachments
Taha Yab Ali

3 replies

T
Captain I
Forum|alt.badge.img+3
  • tahayabali
  • Author
  • Captain I
  • October 29, 2025

This duplication happens because of the ARTax table. When ARTax is joined to ARTran, the report prints two rows for the same inventory line:

  • one row coming from ARTax (with CuryTaxAmt), and

  • one row coming from ARTran (with CuryTaxAmt = NULL, since there is no matching ARTax record).

How can I prevent the report from printing both rows and only show one line per inventory item with its tax amount?

Taha Yab Ali
mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

​@tahayabali 

Please review below suggestions https://community.acumatica.com/reports-and-generic-inquires-115/how-to-extract-multiple-tax-details-to-custom-report-13428

https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
Chris Hackett
T
T
Captain I
Forum|alt.badge.img+3
  • tahayabali
  • Author
  • Captain I
  • Answer
  • October 29, 2025

Thanks for sharing but i already found the solution. Another group created basd on line nbr and push all fields of details inside it.

Taha Yab Ali
Chris Hackett
Terms & ConditionsCookie settingsAccessibility 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