We are trying to show the ship to on the Sales quote but not having any luck finding the link. We want to use the ship address in the opportunity and it comes from the CRShippingAddress table. What would be the best way to link them? We have tried the @opportunity @quote but it doubles prints each item in the quote.
Sales Quote(CR604500) to include Ship to address
Hi
Hope this helps!!
select * from CROpportunityRevision CRR Inner Join CRAddress CRA on CRR.CompanyID = CRA.CompanyID
and CRR.shipaddressid = CRA.AddressID
Where CRR.CompanyID=2 and CRR.OpportunityID='OP000394'
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c9480877-6678-401b-9651-f02b3e40972b.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c06b6985-7b71-4446-864f-03ed217d5f87.png)
We are trying to do this within the report writer. I have tried to use you statement to find the right fields to link within the report writer but not having any luck finding CRaddress.companyid or CROpportunityRevision. companyid. How would I do this within the report writer?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/27c252bd-9f3a-4c39-9bf6-06e566e796fe.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/6eac5184-b5ca-40e1-8f89-e49bb9035085.png)
Hi
CROpportunityRevision.shipaddressid = CRAddress.AddressID
Naveen thank you. I ran into this error message while trying to make it work
The multi-part identifier "CRAddress.AddressID" could not be bound. The multi-part identifier "CROpportunityRevision.ShipAddressID" could not be bound. The multi-part identifier "CRAddress.AddressID" could not be bound. | Send | |||
Raised At: 2/10/2022 3:42:38 PM | Screen: CR.60.45.00 | |||
Details: 2/10/2022 3:42:38 PM Error: |
Hi
I think they are connected
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3de6fbb0-3e3b-4311-970e-3f7dab7b598b.png)
Here is the file
Hi
Please find the table JOINs below.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/6659e9d1-48f5-4b54-9b97-1b4a0ee28107.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c1182909-be19-494f-bacd-ab6a86bebb53.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8c3cc6b9-9568-4b86-85be-b11650bc6d40.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/34ab92c9-3c51-416b-8039-415575bfab24.png)
I am getting an error message
The multi-part identifier "CRAddress.AddressID" could not be bound. The multi-part identifier "CROpportunityRevision.ShipAddressID" could not be bound. | Send | |||
Raised At: 2/11/2022 2:23:26 PM | Screen: CR.60.45.00 | |||
Details: 2/11/2022 2:23:26 PM Error:
![]() ![]()
|
Save with new version and check once.
Thank you Naveen. Still no luck. Confirmed everything was correct. We are using Build 20.208.0031
Hi
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/49e95e0a-6d30-4130-b0f6-7be4bdbe5584.png)
Naveen,
I am not sure how to open this file. I changed the site and it seems to have pulled the wrong report. How do I transfer this report to the company I am working with?
- Instance URL, which you wanted to verify
- Provide the username/password
- Once you open the report, please SAVE this report to server with new version and verify.
Your patient Naveen. Thank you
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.