Hello!
I have researched this issue all afternoon with no success.
I need a solution for storing a Site Address on transaction documents that are not related to the Customer on the document. Currently, staff are using custom field that stores free-form text, but as you can guess, inconsistency with entering makes this almost useless for reporting/historical purposes.
For example, I enter SO for customer, but I need to assign a Site Location where the items will be installed for the customer (Customer may have mulitple site locations--think customer owning different.Convenient Stores/Gas Stations).
I thought about custom record; however, the same Site Location needs to be used on Purchase Orders as well as Sales Orders and Quotes and Returns and Cases.
Need a way to have a repository of Site Addresses which could be stored with the transaction documents and applied to transactions as needed. Also, want separate fields for each part of the address: Site, Add1, Add2, City, ST, and Zip. Would need ability to add on-the-fly a new Site Location from the Transaction Documents as well.
Another solution considered was to make the Sites setup as Subcustomers with address type/category setup as SITE, but that's not really the solution we're looking for either.
Anyone else have this issue where you need to have an additional address location stored on a transaction document that's not the address of the customer?
Thanks in advance everyone!