Cross Table Sequential Number
We use QB to generate invoices across multiple tables within one app - how can I create a sequential numbering system that pulls the next number when the user clicks a button? We don't want the invoic...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHow about this for an idea which is not subject to Pipeline delays or failures.
Create a table called invoice number. Check what invoice number you were up to now and use an Excel import to burn off all of the invoice numbers that are already used up.
Then, set the Key field of this table to be a Custom Key in the format of XXX-Record ID# of the "Orders Table", where XXX is the table identifier and Record ID# is the Record ID# of the tale which needs the Invoice #.
So for example if your orders table needs an invoice #, then create a record with the Key field of ORD-1234 if the Record ID of the order is 1234. Make a relationship back own to orders and then lookup the Record ID# of the Invoices table down to Orders.
So on any table where you need to grab the next invoice # you make a button to go API_AddRecord to create the next Invoice # and the lookup will give you the next Invoice Record ID#.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Create a table called invoice number. Check what invoice number you were up to now and use an Excel import to burn off all of the invoice numbers that are already used up.
Then, set the Key field of this table to be a Custom Key in the format of XXX-Record ID# of the "Orders Table", where XXX is the table identifier and Record ID# is the Record ID# of the tale which needs the Invoice #.
So for example if your orders table needs an invoice #, then create a record with the Key field of ORD-1234 if the Record ID of the order is 1234. Make a relationship back own to orders and then lookup the Record ID# of the Invoices table down to Orders.
So on any table where you need to grab the next invoice # you make a button to go API_AddRecord to create the next Invoice # and the lookup will give you the next Invoice Record ID#.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Great idea Mark, thanks!
------------------------------
Matt Hardy
------------------------------
------------------------------
Matt Hardy
------------------------------
