bugfixes value fields, create class ClsCostCode, ren Cost2Assignment, …

October 27th, 2008   Filed Under Wrk  


  • fixed bugs closed
  • fixed bug Edit supplier amount ID: 2119442
  • fixed empty numbers fields in invoice edit too: inv sn, amount, bookamount, years
  • fixed bug assignedamount and amount left should be read only
  • started on supplier choice from cmbx in invoice edit.
  • modification layout invoice edit form
  • modification layout
  • renamed class Cost to class Assignment
  • created class CostCode for costcodes (to be continued)

Upl. v 0.0.77

wrong date stops booking, empty cost detail, fill assignment

October 24th, 2008   Filed Under Wrk  


  • cost detail list now emptied on selection of invoice where nothing yet assigned
  • Non-existing date: mark with color red and stop from booking invoice.
  • Corrections on date. Edit invoice date: database format, but with control now.
  • Corrected bug Favourite supplier selection: now fills description from supplier.
  • Corrected bug empty fields of amounts crashed app; test empty and set to 0 now ( in vlbxAmount, vlbxBookAmount, vlbxToAssign,
  • Changed fill Assignments (not really ready yet)

Upl. v 0.0.76

Invoice date check

October 22nd, 2008   Filed Under Wrk  


  • Date input: check on impossible date (like february 30 th)
  • Existing invoice number: better message text to number of appearances.

Upl. v 0.0.74

listbox selected invoice’s assignments, max sn len, preset investyears

October 21st, 2008   Filed Under Wrk  


  • FMain: added listbox for assignments of current invoice
  • MData: added fillInvAssignments
  • FMain: added code in invoice select
  • Configure: maximum invoice SN length indicated + MCommon defined
  • fixed preset of investment years
  • lsbxFavCostcode tooltip: list of already used costcodes for supplier of selected invoice

Upl. v 0.0.74 (73 source + 73 exe)

Inv SN fixes, empty DB on condition

October 21st, 2008   Filed Under Wrk  


  • empty tables cpl, inv, ixc, sup with conditions checked
  • fixed bug inv sn total length in configure vlbxInvCountLen_LostFocus() corrected name in code
  • Fixed bug in doc sn compare last latest
  • MData: added clearDbAssignment
  • FClearDB: added code
  • FClearDB: added Empty Database: assigned costs buttons, fields

Upl. v 0.0.73 ( = 72 src + 72 exe)

Version number mixup

October 16th, 2008   Filed Under Wrk  

Changed version 0.0.72 to let source (tar.gz) and executable (facs.gambas) have same version number
Upload was the version of the source after making executable, which increases version number. So the upload version number was actually the increased source version number - and one higher than the actual executable and the source it was derived from.

upl v 0.0.72


cmbxAllSupplier cleanup, shiftDown, lsbxLstSupplier

October 15th, 2008   Filed Under Wrk  


  • cmbxAllSupplier cleanup
  • ShowSelSupplier
  • SelectSupplier
  • MData.shiftDown to MCommon.shiftDown
  • lsbxLstSupplier Add Last Supplier not after selection but after book invoice

Upl. v 0.0.72

sum input in assign amount, grey index and id’s

October 14th, 2008   Filed Under Wrk  


  • To Assign, Amount: sums consequent inputs (like invoice amount does)
  • record id’s and indexes less obvious (less disturbing) by greying them out
  • config order lost again - check later

Upl. v 0.0.71

order in config, invoice import work

October 10th, 2008   Filed Under Wrk  


  • order in config
  • some bugs
  • work on import of invoices from foxpro (no code here yet)

Upl. v 0.0.71

Popular Suppliers list, favourite Costcode per supplier

October 2nd, 2008   Filed Under Wrk  


  • Added popularity counter to suppliers
  • added MData sub to increase the supplier’s counter = rise supplier in favourite list
  • Added initialisation of the popularity list
  • testing mysql statements to fill the costcode list
    most popular costcodes:
    SELECT sup.sup_id, sup.sup_name, count(inv.sup_id) from sup, inv where sup.sup_id=inv.sup_id group by sup_id
    most popular costcodes of supplier id 1220:
    SELECT sup_name, cpl_code, count(cpl_code) as popularity from `ixc`, sup, inv where inv.sup_id=1220 and sup.sup_id=inv.sup_id and inv.inv_id=ixc.inv_id group by cpl_code order by popularity desc
  • Added favourite costcode list for selected invoice’s supplier
  • Arranged optimal field after selecting from popular/favourite lists

Upl. v 0.0.70