Skip to main content
Question

Two approvals causing details section of SO report to duplicate

  • March 18, 2026
  • 1 reply
  • 25 views
M
Semi-Pro II
Forum|alt.badge.img

We are displaying the approver on our sales order report.  We bring this information in as follows:

 I have a situation where the same approver is in two approval maps rules (one inside of a workgroup and one as an individual).  So when he approves a document, it comes through twice.

 

This is now causing the detail lines on the sales order print out to duplicate.  I would like to group by the key field here, which is RefNoteID, but I get errors when doing this because it is not a normal numerical ID.

Any suggestions?  There might also be cases where there are two approvers who are not the same person, so grouping on Approver ID is probably not ideal, but maybe a work around for now because I only need to display one approver on the report.  Still wondering if there is a better way though?

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@MarciaW In situations where there is a duplicate which can’t be avoided, the best way to fix this is to use a subreport to pull in the duplicating data. I think that in this case though you can probably use the StepID from the approval in your join and it should prevent the duplicates. So if you leave the join on NoteID = RefNoteID and add the unique identifier for StepID (which you can find if you add this to a GI and check the results) then you should only get the approver for this step.

    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