Mapping Entity-to-Entity from Backend

Enable “office-specific-products-enabled“ global configuration to display entities to the login user based on the entity-to-entity mapping.

Office to Loan Product Mapping

Insert into m_entity_to_entity_mapping(rel_id,from_id,to_id,allowed_for_child_offices)
select 1,o.id,lp.id,0 from m_office o,m_product_loan lp 
where o.name in (?) and lp.name in (?);

2. Office to Charges Mapping

Insert into m_entity_to_entity_mapping(`rel_id`,`from_id`,`to_id`,`allowed_for_child_offices`)
select 3,o.id,c.id,0
from m_office o,m_charge c
where o.name in (?) and c.name in (?);