Price Books in invoices based on another field?
I am trying to help out a client with a ZOHO invoice need. They have 1 price book now and when they select ZOHO invoice from the Customer in the CRM to create an invoice they have the item details linked as a lookup field to that Price Book. What they want however is to have several price books with each connected to a property. So if I am invoicing a customer at The Oaks property I see only The Oaks price book when I select the item details for the invoice. When I invoice someone at Windermere I see only the Windermere price book when I select the item details and so on. Is this possible to do ? If so where do I make those dependencies/connections?
Thank you!