Missing series of invoices; new invoice number is?

April 12th, 2010   Filed Under Wrk  

When lagging behind with the input, you might end up in a situation where you are (someone is) working on the input of recent invoices, and at the same time (someone) trying to complete the missing invoices of the past.
When starting the program, the new highest invoice number plus one is not what you need. You want to find the place where an invoice is missing. Give the program a hand, select the invoice where you want to somewhere start from, and Facs looks for the next missing invoice serial number.

Working on that now. From the invoice you select, we need to create the counter value:
invSn2number will give that, taking into account the settings for the invoice prefix.

Sample data: bakery

April 6th, 2010   Filed Under Wrk  

Tried to make some kind of universal sample to test the program.

Sample 1: anonymous

Suppliers: Supplier A, Supplier B, Supplier C, ..
Invoices numbers from 1 to …, amounts random
Costcodes: cc1, cc2, cc3, cc4, cc5, …

20080923: Have an idea now: let’s make a bakery. This seems universal enough for everyone to understand, as it is a kind of “production” process. Excuses to real bakery-managers, lots of the sample may be nonsense to them.

I started a new database with the name “bakery” to fill with sample data. [More…]