I'm so confused by the results of this saved searc...
# general
l
I'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
What is the operator for your internal id criteria? Equal to? Is?
You 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
Internal ID operator is "IS"
I tried your suggestion but it didn't work. Thanks though. It's really weird that Summary Types double the total. Hmmm
m
Try 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
this is a recurring problem it seems to me due to the join which falsifies the results