Skip to main content
Answer

Generic Inquiry comparing INTran Transaction Dates to give latest information

  • August 23, 2022
  • 6 replies
  • 148 views
K
Semi-Pro II
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:

 

Kandy Beatty

6 replies

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

HI @krausef77 

Here is one that may help get you started:

 

1 Attachments
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
K
K
Semi-Pro II
Forum|alt.badge.img+1
  • krausef77
  • Author
  • Semi-Pro II
  • August 23, 2022

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+17
  • Kandy Beatty
  • Captain II
  • 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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
DConcannon
K
DConcannon
Varsity II
Forum|alt.badge.img+2
  • DConcannon
  • Varsity II
  • 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?

Chris Hackett
K
Semi-Pro II
Forum|alt.badge.img+1
  • krausef77
  • Author
  • Semi-Pro II
  • 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. 

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
Chris Hackett
Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • 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. 

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! 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved