Skip to main content
Solved

Report Writer Question - Breaks when attempting to join a table

  • 6 February 2024
  • 5 replies
  • 32 views

Forum|alt.badge.img

We have a report that will show any open replenishment purchase order lines. We are trying to connect this with the shipment table - to only show items that are currently not in stock but are on replenishment purchase orders. 

When I try to join SOShipLine or SOShipLine Split - the report breaks. I believe I am using all the common fields to join them, but not sure why it breaks. 

Relationship Schema

Could you please advise what I am missing? I have also attached the rpx file. Thank you in advance!

@lauraj46 - Hi Laura, any ideas or recommendations would be helpful! Thank you!

Best answer by lauraj46

Hi @kanupindi ,

See attached.  Hope this helps!

Laura

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

5 replies

craig2
Pro I
Forum|alt.badge.img+2
  • Pro I
  • 89 replies
  • February 6, 2024

Hi @kanupindi , it looks like you maybe didn’t define an Alias for the Child INItemSite?  I would try that first, either set the Child to IS, or remove the IS on the next line down.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • February 6, 2024

Hi @craig2 , thank you for the feedback. Unfortunately, that did not work


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • February 6, 2024

Hi @kanupindi,

Try this:

 

I didn’t review the logic, but it does run :)

Hope this helps!

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • February 6, 2024

Hi @lauraj46, do you please mind attaching your copy of the report? Adding aliases did not seem to work for me for some reason. I do not have any other condition or visible expression that can cause the report to break. thank you for your help


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • February 6, 2024

Hi @kanupindi ,

See attached.  Hope this helps!

Laura


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