Our objective is to instantiate a framework that facilitates the allocation of unique prefixes and invoice numerals for each individual user upon authentication within our database system. We have endeavored to implement a sequential mechanism alongside the invoice journal; however, we encountered significant challenges in associating the correct sequence with each respective journal.

Despite our efforts to designate the journals to specific users, a disconcerting issue arises when an invoice is generated: the system fails to associate the journal as previously configured. We seek guidance on effective methodologies to rectify this anomaly and ensure that each user's invoice generation is meticulously aligned with their designated journal and sequence.