Skip to main content
Solved

Report Writer Question - Breaks when attempting to join a table

  • 6 February 2024
  • 5 replies
  • 30 views

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!

5 replies

craig2
Rank
Userlevel 5
Badge +1

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.

K
Rank
Userlevel 4
Badge

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

Kaavya
lauraj46
Rank
Userlevel 7
Badge +8

Hi @kanupindi,

Try this:

 

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

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
K
Rank
Userlevel 4
Badge

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

Kaavya
lauraj46
Rank
Userlevel 7
Badge +8

Hi @kanupindi ,

See attached.  Hope this helps!

Laura

1 Attachment
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings