Hello All,
I created an module that having some fields of billing address like name, email, city, district but all these value are not stores in table which is responsible for billing address (I think the table name for billing address is : sales_flat_order_address).
The values of fields are stored in customer_address_entity_varchar table but not in table responsible for billing address.
I need all these new billing address fields in my Order Invoice mail.
I do the following in my module's config.xml file :
<global>
<fieldsets>
<sales_convert_quote_address>
<your_name>
<to_order_address>*</to_order_address>
<to_customer_address>*</to_customer_address>
</your_name>
<email>
<to_order_address>*</to_order_address>
<to_customer_address>*</to_customer_address>
</email>
</sales_convert_quote_address>
<customer_address>
<your_name>
<to_quote_address>*</to_quote_address>
</your_name>
<email>
<to_quote_address>*</to_quote_address>
</email>
</customer_address>
</fieldsets>
</global>
What can I do, Please suggest.
Thanks in anticipation.