Skip to main content
Solved

Account Details GI - not all information pulling through

T
Freshman I
Forum|alt.badge.img
  • tveld
  • Freshman I
  • 41 replies

Hello Community,

I have created a new GI and have a question on it.  It is pulling information how I wanted, but then noticed that it is missing information.  This is a copy of the Account Details report, but I added the Reason Code column.

This is the report results:

For the Reason Code column, the SCRAP result should continue down the report as it is all the same record.

I have tried different relationship set ups, but the SCRAP is not coming through for the rest of the items.

These are the relationships that I currently have set up:

GLTranR left join to INTran
GLTranR left join to GLTran
GLTran left join to Batch

Any ideas/feedback is welcome!

Thank you,

Trisha

Best answer by dcomerford

The way your query is structured the entry must exist in the GLTranR in order to display and is suspect your scrap entry is not in this table. I would suggest changing you inquiry to make the GLTran or INTran your main table and left join everything to this table. 

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

3 replies

T
Freshman I
Forum|alt.badge.img
  • tveld
  • Author
  • Freshman I
  • 41 replies
  • January 24, 2024
tveld wrote:

Hello Community,

I have created a new GI and have a question on it.  It is pulling information how I wanted, but then noticed that it is missing information.  This is a copy of the Account Details report, but I added the Reason Code column.

This is the report results:

For the Reason Code column, the SCRAP result should continue down the report as it is all the same record.

I have tried different relationship set ups, but the SCRAP is not coming through for the rest of the items.

These are the relationships that I currently have set up:

GLTranR left join to INTran
GLTranR left join to GLTran
GLTran left join to Batch

Any ideas/feedback is welcome!

Thank you,

Trisha

Community,

Anyone have any pointers on this question?

Thank you,
Trisha

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 643 replies
  • Answer
  • January 24, 2024

The way your query is structured the entry must exist in the GLTranR in order to display and is suspect your scrap entry is not in this table. I would suggest changing you inquiry to make the GLTran or INTran your main table and left join everything to this table. 

Dermot Comerford
bryanb39
Chris Hackett
T
3 people like this
  • bryanb39
    bryanb39
  • Chris Hackett
    Chris Hackett
  • T
    tveld
T
Freshman I
Forum|alt.badge.img
  • tveld
  • Author
  • Freshman I
  • 41 replies
  • January 25, 2024

@dcomerford ,

Thank you for your help!  I was able to get this report to work the way we intended.

Thank you,

Trisha

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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