In OpenERP 7.0 I have a requirement in that I need the address on the sales order to not change even if the company or customer address changes over time.
For example, we create a sales order for customer A they have an address Aa, his address might get updated to Ab and now all sales orders, invoices, delivery orders etc linking that customer to the invoices are set to the customer address Ab. I need them to still be Aa.
Is there anyway to achieve this in the system, or should I start coding? I am pretty doubtful but thought I'd ask here anyways.
I haven't tried this, but one possible idea is:
For each company, create a contact called 'Company' which represents the current address.
Sales orders, etc would be for this 'contact' - showing up as 'OpenERP, Company' although OpenERP is still responsible for the purchases.
When you get a change of address for the company, rename 'Company' to 'Until July 2013' and mark it 'Inactive' so it only shows up on those historic documents as 'OpenERP, Until July 2013'. Create a new contact called 'Company' with the new address.
For each customer, just keep creating new addresses, making each old one 'Inactive' so these too only show up on historic documents.
This idea renders meaningless the address on a company, and requires you always sell to 'contacts'.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/16/13, 8:39 PM|
|Seen: 898 times|
|Last updated: 3/16/15, 8:10 AM|