Skip to main content
Solved

Wrong CuryOrderTotal in Sales Order GI

  • March 23, 2026
  • 1 reply
  • 19 views

FinnSystemAG
Freshman II
Forum|alt.badge.img

Hello all,

 

we have the following problems in the GI “SO3010PL” (Sales orders):

The total sum of some orders are multiplied by a factor, for example 2 or 4 and thus show the wrong order sum in the GI. In the Sales order itself the Order Sum is totally correct but not matching with the one shown in the GI.

Example for wrong Sales Order (Total 8,068,20):

In GI false:
 



Example for right sales order (Total 2570,40):
 

In GI correct:



Screenshots of GI:

 

 

 

 


 



Please let me know, if you need more information. Thank you.

Greetings

Best answer by jhalling52

Hi ​@FinnSystemAG,

I’m guessing the CRActivity table may be pulling in multiple records per Sales Order.  To test, can you make the join to the CRActivity inactive and make any fields in the results grid referencing this table inactive?

To fix, you could add an additional condition in the table join to only pull in one transaction. (Not sure what you are trying to pull in).  

Otherwise, you could leave as is but add a Min or Max Aggregate Function for the Amount fields in the results grid.

1 reply

jhalling52
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • Answer
  • March 23, 2026

Hi ​@FinnSystemAG,

I’m guessing the CRActivity table may be pulling in multiple records per Sales Order.  To test, can you make the join to the CRActivity inactive and make any fields in the results grid referencing this table inactive?

To fix, you could add an additional condition in the table join to only pull in one transaction. (Not sure what you are trying to pull in).  

Otherwise, you could leave as is but add a Min or Max Aggregate Function for the Amount fields in the results grid.