I'm so confused by the results of this saved searc...
# generall
Luis
05/10/2023, 12:42 PMI'm so confused by the results of this saved search.
Transaction saved search
Criteria: Internal ID of a PO, Main Line is False, Tax Line is False, Applying Transaction.Type is Bill
Results: Applying Transaction.Amount, Applying Transaction
With Summary Types, the results are correct. BUT when add Summary Types to the Applying Transaction.Amount (Sum) and Applying Transaction (Group), the total amount is twice than it should be.
If I drill down and manually sum the individual rows, they are ok.
m
MGBC
05/10/2023, 12:45 PMWhat is the operator for your internal id criteria? Equal to? Is?
MGBC
05/10/2023, 12:48 PMYou could also try a formula text to filter out unwanted rows. Like
CASE WHEN {applyingtransaction.type} = ‘Bill’ THEN {applyingtransaction.number} END
And group on that
l
Luis
05/10/2023, 12:59 PMInternal ID operator is "IS"
Luis
05/10/2023, 1:10 PMI tried your suggestion but it didn't work. Thanks though.
It's really weird that Summary Types double the total. Hmmm
m
MGBC
05/10/2023, 2:34 PMTry changing your Internal ID criteria to a Formula (text) and using the {internalid} has keywords "123456" (or whatever your internal id is) also try "contains" as well.
Also the applying transaction to a Purchase order could be a Item Receipt or Vendor Bill so it might be doubling your results because it's seeing item receipts as well. try to filter those out
m
Marc
05/10/2023, 9:49 PMthis is a recurring problem it seems to me due to the join which falsifies the results
26 Views