Skip to main content
Solved

Opportunity & Sales Order Join Is Sporadically Missing Data

  • September 22, 2020
  • 6 replies
  • 367 views
jthrashr
Freshman I

I recently joined the opportunity and sales order tables (and vice versa).

 

It has been working perfectly until recently.

 

On the opportunities screen, I’ve noticed a behavior where information from the associated sales orders isn’t being pulled over for some opportunities (see the image below). On the sales order screen, it looks like every sales order is being correctly associated with the correct opportunity ID, so the issue is isolated to opportunities. Also, these opportunities do not have multiple sales orders associated either.

 

Any suggestions on what could be going wrong here?

 

 

Best answer by BenjaminCrisman

It looks like in the GI on the relation from OpportunityRelation to SOOrder you are including relation on CROpportunity.Amount to curyLineTotal:

 

This was preventing the Sales Order numbers from displaying for me locally and once deactivated it showed more:
Before deactivated:

After deactivated:

 

View original
Naveen Boga
Kandy Beatty
di93
16 people like this
  • Naveen Boga
    Naveen Boga
  • Kandy Beatty
    Kandy Beatty
  • di93
    di93
  • Jeff96
    Jeff96
  • purwandaruw
    purwandaruw
  • jinin
    jinin
  • iqraharrison
    iqraharrison
  • Laura02
    Laura02
  • Dana Moffat
    Dana Moffat
  • D
    deans16
  • jamest
    jamest
  • P
    paengesser82
  • RohitRattan88
    RohitRattan88
  • justinsanchez
    justinsanchez
  • M
    mflores
  • cwalton21
    cwalton21
Did this topic help you find an answer to your question?

6 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 691 replies
  • September 24, 2020

Hi jthrashr! I think this could be difficult without seeing the GI but typically there are a couple reasons for data not making it in to the results grid.

It could be that the missing information is related to the join for Sales Order to Opportunity. If you are joining CROpportunity to CRQuote then you may be missing information for Opportunities which have no quote.

Alternatively, I would check to see if there is any grouping being applied to the GI and if the same results are seen without the grouping.

Let me know if this helps!

 

Irina
jthrashr
2 people like this
  • Irina
    Irina
  • jthrashr
    jthrashr
Ali Jani
Community Manager
Forum|alt.badge.img
  • Ali Jani
  • Acumatica Chief Product Officer
  • 52 replies
  • September 24, 2020

Please export your GI as XML and attach here so we can see the makeup of your GI.  You can do this from the GI designer screen’s Copy/Past menu, using Export As XML option.

jthrashr
1 person likes this
  • jthrashr
    jthrashr
jthrashr
Freshman I
  • jthrashr
  • Author
  • Freshman I
  • 3 replies
  • September 24, 2020

@BenjaminCrisman@Ali Jani 

 

I’ve attached the GI here.

 

There isn’t any grouping being applied, and the join is CROpportunity => OpportunityRelation => SOOrder.

 

Appreciate any insights! Thanks.

1 Attachments
BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 691 replies
  • Answer
  • October 7, 2020

It looks like in the GI on the relation from OpportunityRelation to SOOrder you are including relation on CROpportunity.Amount to curyLineTotal:

 

This was preventing the Sales Order numbers from displaying for me locally and once deactivated it showed more:
Before deactivated:

After deactivated:

 

Aliya
jthrashr
V
3 people like this
  • Aliya
    Aliya
  • jthrashr
    jthrashr
  • V
    vkumar
jthrashr
Freshman I
  • jthrashr
  • Author
  • Freshman I
  • 3 replies
  • October 7, 2020

@BenjaminCrisman Thanks for the solve! I’m not sure why that relation was in there in the first place.

BenjaminCrisman
1 person likes this
  • BenjaminCrisman
    BenjaminCrisman
Irina
Community Manager
Forum|alt.badge.img+8
  • Irina
  • Acumatica Support Analyst
  • 515 replies
  • October 21, 2020

KB article on how to create such a GI can be found here: How to display sales orders created from opportunities in a generic inquiry

Best regards, Irina

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