You need to sign in to do that
Don't have an account?
Sagar104
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
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
Ex
Order number = 000123456
SAP ID = 123456
right(order number, 6) = 123456
can you plz elaborate how to get the report ? do i need to put some formula? How is everything i can achieve?