[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Dolibarr-user] Can't have more than 10 bills a months
From: |
Brice Delmotte |
Subject: |
[Dolibarr-user] Can't have more than 10 bills a months |
Date: |
Thu, 6 Oct 2005 18:16:03 +0200 |
There seems to be a problem in the file lune.modules.php of the
includes/modules/facture/lune folder
It takes only the last number of the bill reference number :
$sql = "SELECT max(0+substring(facnumber, 8)) FROM
".MAIN_DB_PREFIX."facture";
$sql .= " WHERE facnumber like '$prefix".$date."%'";
So I changed it in :
$sql = "SELECT max(0+substring(facnumber,6,8)) FROM
".MAIN_DB_PREFIX."facture";
$sql .= " WHERE facnumber like '$prefix".$date."%'";
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Dolibarr-user] Can't have more than 10 bills a months,
Brice Delmotte <=