How To Get Item Receipt ID from Return Auth Transaction Search?

I have a transaction search filtered to “Return Authorization” types. I want to include the corresponding item receipt internal id as a results column.

I accomplished this by including a formula(numeric) field for {applyingtransaction.id}, but that duplicates results because it can bring back both the Item Receipt and the Cash Refund.

I thought I could fix this by adding a criteria of Applying Transaction : Type = Item Receipt, but then that excludes any non-received returns.

Is there some other way I can pull in the item receipt id while preventing duplicate results?

Rookie Asked on August 27, 2021 in Saved Searches.
Add Comment
3 Answer(s)

Hello gg_revant,

If I have understood correctly, does this work?

RE: How To Get Item Receipt ID from Return Auth Transaction Search?

Rookie Answered on August 30, 2021.
Add Comment

I want to include the Item Receipt ID if the RMA has been received. If the RMA is not received this result column would be blank/null.

If I don’t include any criteria for Applying Transaction I get duplicate results due to the potential association with many applying transactions (Item Receipt, Order/Bill/Invoice, Revenue Committed, etc.).

If I try to add criteria to Applying Transaction to prevent duplicate results then I can only get received RMA. I want to show received and unreceived, but prevent the of Applying Transaction from duplicating results.

Rookie Answered on August 30, 2021.
Add Comment

Hello,

Sorry, misread the original question. Makes sense.

If you group the document number and maximum on Applying Transaction: Document Number this should work?

Otherwise,

RE: How To Get Item Receipt ID from Return Auth Transaction Search?

RE: How To Get Item Receipt ID from Return Auth Transaction Search?

Rookie Answered on August 31, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor