function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sagar104Sagar104 

Linking two objects report type

Need to create a new report type has been requested linking  two objects "X" & "Y" . This report should contain all "X" objects as well as the fields associated to them by a common Sales Order number.
The link between these two objects should be as follows:
Order Number ("X") = SAP ID ("Y")
NOTE: Order Number will have 3 leading zeroes where as SAP ID will not, some logic needs to applied through the report link to remove these zeroes to ensure the link works properly.

HOW do i achieve it.. kindly suggest as im new to it
Steve LoudermilkSteve Loudermilk
looks like you will likely use a right() function on the order number assuming all of the numbers are the same length in the order number field, if not use a len() formula to return the number of characters in a string and then return what you want using the right() formula, you may need a text or a value function to convert it back to the correct type depending on how your fields are set-up

Ex

Order number = 000123456
SAP ID = 123456

right(order number, 6) = 123456
Sagar104Sagar104
@Steve Loudermilk
can you plz elaborate how to get the report ? do i need to put some formula? How is everything i can achieve?
Steve LoudermilkSteve Loudermilk
Is there any existing relationship between objects that contain x and y?