Skip to main content

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.

HI @krausef77 

Here is one that may help get you started:

 

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!

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. 

@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?

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!

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


Terms & ConditionsCookie settings