YR rental renewals are creating invoices the lookup cannot reach.

The painful part is not that Genius can create a monthly rental invoice. It can. The failure is that the monthly Zoho SO and the reused Genius SO no longer maintain a durable one-to-one relationship, so the invoice lookup loses the bridge it needs to find the related invoice information.

YR rental missing SO-to-SO bridge diagram Diagram showing that reusing one Genius sales order for multiple Zoho rental sales orders breaks invoice lookup because the SO-to-SO join key is missing. The lookup contract: one Zoho SO maps to one Genius SO Everything downstream assumes this bridge exists before it goes looking for invoices. Zoho Sales Order HR-81888 Genius Sales Order PoNumber = 81888 Universal Order Lookup Finds related invoice data SO-to-SO bridge lookup can traverse TODAY: MONTHLY RENTALS BREAK THE BRIDGE FIX: PRESERVE 1:1 EACH BILLING PERIOD Zoho SO - period 1 Original rental billing Zoho SO - period 2 Monthly rental charge Zoho SO - period 3 Monthly rental charge One reused Genius SO equipment attached once dates edited each month PO No cleared / overwritten relationship collapses Genius invoice exists Invoice PO No = HR-81888 but only on the invoice Invoice history grows periods 2, 3, 4... hang off reused SO Invoice data is present, but it is not the identity bridge. The lookup searches through SO identity, not a loose invoice-only PO reference. Lookup asks "show invoice info for Zoho HR-81888" No matching Genius SO PoNumber is blank, old, or no longer unique dead end This is a data-model gap, not an invoice-lookup bug. Zoho period 1 HR-81887 Genius SO 1 PoNumber 81887 Invoice period 1 Zoho period 2 HR-81888 Genius SO 2 PoNumber 81888 Invoice period 2 Zoho period 3 HR-81889 Genius SO 3 PoNumber 81889 Invoice period 3 durable SO-to-SO bridge normal invoice path The only process change: create a new Genius SO for each rental period. Alexis confirmed equipment is attached to the customer. Linking it to the new SO is a couple extra steps. No lookup patch. No fuzzy matching. No rental-only exception. Lookup asks "show invoice info for Zoho HR-81888" Finds Genius SO 2 PoNumber = 81888 Genius_Order_Number syncs Related invoice found existing lookup logic works Preserve 1:1 identity and the invoice lookup stops going blind. Critical point: a monthly rental invoice can be correct and still be unreachable when the Zoho SO -> Genius SO relationship is not maintained.