I am developing an application for Receipts (money received from clients) we collect money. Once a receipt is saved a Voucher Number gets generated and assigned to the saved Voucher.
Since I have multiple branch offices I want to generate numbering Branch wise since money is collected at different locations. I thought of 2 ways to get this done.
-
Create Branch wise Receipt Forms with multiple tables and have Numbering sequence set. Challenge with this is that i will have to create a new form every time a new branch office is opened.
-
Create a Single Receipt Form and auto generate Numbering sequence Branch wise.
Let's say I have 2 Locations ABC & XYZ which are 2 branch offices:
When the user from location ABC logs in and generates Receipts, Numbering to start from 1.
ABC-1, ABC-2, ABC-3 and it goes on.
Whereas when the user from Location XYZ logs in and generates Receipts, Numbering to start from 1.
XYZ1, XYZ2, XYZ3 and it goes on.