Solved

Generic Inquiry comparing INTran Transaction Dates to give latest information

  • 23 August 2022
  • 6 replies
  • 85 views
K
Rank
Userlevel 5
Badge +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.

icon

Best answer by Kandy Beatty 23 August 2022, 17:21

View original

6 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @krausef77 

Here is one that may help get you started:

 

1 Attachment
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*.
K
Rank
Userlevel 5
Badge +1

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
Rank
Userlevel 7
Badge +16

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
Rank
Userlevel 6
Badge +2

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

K
Rank
Userlevel 5
Badge +1

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
Rank
Userlevel 7
Badge +16

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*.

Reply


Terms & ConditionsCookie settings
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