Skip to main content
Solved

Generic Inquiry comparing INTran Transaction Dates to give latest information


Forum|alt.badge.img+1

Hi everybody,

I am currently working on a Generic Inquiry that needs to give out the latest location after a transfer.
I read something about Self-Joins which doesn’t seem to be working for the INTran object.
Basically, I need to evaluate if the ToLocationID is the one from the latest transaction and display this location.
 

Does anybody know a feasible solution?
The client is currently operating in 2022 R1.

Best answer by Kandy Beatty

HI @krausef77 

Here is one that may help get you started:

 

View original
Did this topic help you find an answer to your question?

6 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • Answer
  • August 23, 2022

HI @krausef77 

Here is one that may help get you started:

 


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 177 replies
  • August 23, 2022
kbeatty21 wrote:

HI @krausef77 

Here is one that may help get you started:

 

Thank you for sharing this. Could give some insight of what the goal of this inquiry was?

Thank you!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • August 23, 2022

HI @krausef77 

It was to show IN Transfer Receipt Details.

You will need to adjust some of it to fit your exact need but it’s a start for you. 


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 119 replies
  • August 23, 2022

@krausef77 Can you provide the business scenario/more info?  Your client is tracking the last location for?  a specific item? limited by warehouse? in a lot? not limited at all? You mention To Location, only for transfers? replenishment orders? do you need to consider unreleased transactions?


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 177 replies
  • August 23, 2022
kbeatty21 wrote:

HI @krausef77 

It was to show IN Transfer Receipt Details.

You will need to adjust some of it to fit your exact need but it’s a start for you. 

This worked perfect! 
I had a mistake in the self-join of my original inquiry and was missing a condition.

 

Thanks again for the quick and helpful response!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • August 23, 2022
krausef77 wrote:
kbeatty21 wrote:

HI @krausef77 

It was to show IN Transfer Receipt Details.

You will need to adjust some of it to fit your exact need but it’s a start for you. 

This worked perfect! 
I had a mistake in the self-join of my original inquiry and was missing a condition.

 

Thanks again for the quick and helpful response!

Glad to have helped! 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings