dolibarr-user
[Top][All Lists]
Advanced

[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."%'";






reply via email to

[Prev in Thread] Current Thread [Next in Thread]