There is currently no way to accurately match the delivery address on a SOP with the delivery address as in delivery address table - the unique values of AddressID and CustDeliveryAddresses.Description are not captured in the SOP and Invoice tables, so reporting on the data as is produces multiple duplications where there are any identical variables eg multiple outlets with the same postcode
Linda Capewell
| Idea Benefit | Allow accurate reporting of sales by delivery address on an account with multiple sites, based on the delivery addresses as set up in the main Head Office Account. |
| How do you solve for this problem today? | Multiple vlookups in data in excel - long-winded process and still subject to errors |
| Fixed in version | Report Design Service |
Hi Linda
Please contact the Sage 200 Report Design team to discuss this further (if your a Partner direct your customer to this article), with a view to seeing if this can be achieved with a custom report.
Details on how to do this are available here.
Regards,
Keith Carver
Sage 200 Report Design
Attachments Open full size
SOPOrderID is on both tables - that's your direct link.
SELECT *
FROM dbo.SOPOrderReturn sor
LEFT OUTER JOIN dbo.SOPDocDelAddress sdda ON sdda.SOPOrderReturnID = sor.SOPOrderReturnID
Or is that not the table you want to link?
Attachments Open full size