=== 1. ALLER-RETOUR jdate/idate sur les dates du script ===
  2026-01-07 -> jdate=1767740400 -> idate=2026-01-07 00:00:00   dol_print=2026-01-07
  2026-07-31 -> jdate=1785448800 -> idate=2026-07-31 00:00:00   dol_print=2026-07-31
  2026-06-23 -> jdate=1782165600 -> idate=2026-06-23 00:00:00   dol_print=2026-06-23
  2026-08-07 -> jdate=1786053600 -> idate=2026-08-07 00:00:00   dol_print=2026-08-07
  2026-03-09 -> jdate=1773010800 -> idate=2026-03-09 00:00:00   dol_print=2026-03-09
  date_default_timezone_get() = Europe/Paris
  MySQL tz global=SYSTEM session=SYSTEM now=2026-08-10 23:46:15

=== 2. PaymentVarious : proprietes et sens dans create() ===
  fichier : /home/teknipn/gestion/compta/bank/class/paymentvarious.class.php (28960 octets)
function create($user)
	{
		global $conf, $langs;

		$error = 0;
		$now = dol_now();

		// Clean parameters
		$this->amount = (float) price2num($this->amount);
		$this->label = trim($this->label);
		$this->note = trim($this->note);
		$this->fk_bank = (int) $this->fk_bank;
		$this->fk_user_author = (int) $this->fk_user_author;
		$this->fk_user_modif = (int) $this->fk_user_modif;
		$this->fk_account = (int) $this->fk_account;
		if (empty($this->fk_account) && isset($this->accountid)) {	// For compatibility
			$this->fk_account = $this->accountid;
		}

		// Check parameters
		if (!$this->label) {
			$this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("Label"));
			return -3;
		}
		if ($this->amount < 0 || $this->amount == '') {
			$this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("Amount"));
			return -5;
		}
		if (isModEnabled("bank") && (empty($this->fk_account) || $this->fk_account <= 0)) {
			$this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("BankAccount"));
			return -6;
		}
		if (isModEnabled("bank") && (empty($this->type_payment) || $this->type_payment <= 0)) {
			$this->error = $langs->trans("ErrorFieldRequired", $langs->transnoentities("PaymentMode"));
			return -7;
		}

		$this->db->begin();

		// Insert into llx_payment_various
		$sql = "INSERT INTO ".MAIN_DB_PREFIX."payment_various (";
		$sql .= " datep";
		$sql .= ", datev";
		$sql .= ", sens";
		$sql .= ", amount";
		$sql .= ", fk_typepayment";
		$sql .= ", num_payment";
		if ($this->note) {
			$sql .= ", note";
		}
		$sql .= ", label";
		$sql .= ", accountancy_code";
		$sql .= ", subledger_account";
		$sql .= ", fk_projet";
		$sql .= ", fk_user_author";
		$sql .= ", datec";
		$sql .= ", fk_bank";
		$sql .= ", entity";
		$sql .= ")";
		$sql .= " VALUES (";
		$sql .= "'".$this->db->idate($this->datep)."'";
		$sql .= ", '".$this->db->idate($this->datev)."'";
		$sql .= ", '".$this->db->escape((string) $this->sens)."'";
		$sql .= ", ".price2num($this->amount);
		$sql .= ", '".$this->db->escape((string) $this->type_payment)."'";
		$sql .= ", '".$this->db->escape($this->num_payment)."'";
		if ($this->note) {
			$sql .= ", '".$this->db->escape($this->note)."'";
		}
		$sql .= ", '".$this->db->escape($this->label)."'";
		$sql .= ", '".$this->db->escape($this->accountancy_code)."'";
		$sql .= ", '".$this->db->escape($this->subledger_account)."'";
		$sql .= ", ".($this->fk_project > 0 ? ((int) $this->fk_project) : 0);
		$sql .= ", ".((int) $user->id);
		$sql .= ", '".$this->db->idate($now)."'";
		$sql .= ", NULL";	// Filled later
		$sql .= ", ".((int) $conf->entity);
		$sql .= ")";

		dol_syslog(get_class($this)."::create", LOG_DEBUG);
		$result = $this->db->query($sql);
		if ($result) {
			$this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."payment_various");
			$this->ref = (string) $this->id;

			if ($this->id > 0) {
				if (isModEnabled("bank") && !empty($this->amount)) {
					// Insert into llx_bank
					require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';

					$acc = new Account($this->db);
					$result = $acc->fetch($this->fk_account);
					if ($result <= 0) {
						dol_print_error($this->db);
					}

					// Insert payment into llx_bank
					// Add link 'payment_various' in bank_url between payment and bank transaction
					$sign = 1;
					if ($this->sens == '0') {
						$sign = -1;
					}

					$bank_line_id = $acc->addline(
						$this->datep,
						(string) $this->type_payment,
						$this->label,
						$sign * abs($this->amount),
						$this->num_payment,
						($this->category_transaction > 0 ? $this->category_transaction : 0),
						$user,
						$this->chqemetteur,
						$this->chqbank,
						'',
						$this->datev
					);

					// Update fk_bank into llx_payment_various
					// So we know the payment which has generate the banking transaction
					if ($bank_line_id > 0) {
						$this->update_fk_bank($bank_line_id);
					} else {
						$this->error = $acc->error;
						$error++;
					}

					if (!$error) {
						// Add link 'payment_various' in bank_url between payment and bank transaction
						$url = DOL_URL_ROOT.'/compta/bank/various_payment/card.php?id=';

						

=== 3. Y a-t-il une ligne llx_bank pour l'avoir INPI +32.57 et le -1.24 ? ===
  #99   2026-07-15    6758.95 (CustomerInvoicePayment)
  #208  2026-07-15  -22219.92 (AgentCompta effet) EFFETS DOMICILIES DOMICILIES
  #272  2026-07-15    -112.32 (AgentCompta relevé) Paiement par carte X7200 SA TAUPIN DOZULE 13/07
  #363  2026-07-15    7000.00 (CustomerInvoicePayment) Acompte Normandie Biologi'K
  #127  2026-07-16     379.20 (AgentCompta) VIREMENT EN VOTRE FAVEUR RENAULT TRUCKS 6402441962 29600
  #195  2026-07-16   -1944.00 (AgentCompta) VIREMENT EMIS WEB B.D.I.T 2093 TEKNIPLI FA06/30 BDIT 209
  #196  2026-07-16    -179.96 (AgentCompta) VIREMENT EMIS VIR INST vers FONDATION GABRIEL FA06/31 AT
  #355  2026-07-16     -22.00 Frais bancaires
  #429  2026-07-16     -12.00 Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)
  #197  2026-07-17     -93.80 (AgentCompta) PAIEMENT PAR CARTE X4074 DECHARENTON FLERS    16/07
  #198  2026-07-17     -49.58 (AgentCompta) PAIEMENT PAR CARTE X4074 OCMANDY CARPIQUET    16/07
  #430  2026-07-17      -5.99 Uber One — nature à confirmer
  #101  2026-07-20      34.71 (CustomerInvoicePayment)
  #105  2026-07-20    3589.86 (CustomerInvoicePayment)
  #125  2026-07-20      34.71 (AgentCompta) VIREMENT EN VOTRE FAVEUR FABIEN EUDELINE FACTURE 0261 VI
  #199  2026-07-20   -1152.00 (AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/28 SELLERIE
  #213  2026-07-20    -330.00 (AgentCompta relevé) Virement émis VIR INST vers ADS TECHNOLOGIES - 
  #308  2026-07-20   -1768.14 Prélèvement LIXXBAIL — crédit-bail 428164BP0
  #403  2026-07-20     584.43 (CustomerInvoicePayment) Virement PM BATIMENT SAS — Tendance Menuise
  #104  2026-07-21     165.26 (CustomerInvoicePayment)
  #431  2026-07-21    -225.77 Redevance INPI — dépôt/renouvellement de marque
  #386  2026-07-22    -116.80 (AgentCompta) Paiement par carte X4074 LA TABLE DE JOHN ST 21/07
  #106  2026-07-23     870.26 (CustomerInvoicePayment)
  #168  2026-07-23     -93.60 (AgentCompta) PAIEMENT PAR CARTE X7200 BRICO SAINT MART     22/07
  #169  2026-07-23     -15.12 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07
  #170  2026-07-23    -217.55 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07
  #171  2026-07-23    -189.05 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07
  #172  2026-07-23     -24.85 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 22/07
  #273  2026-07-23     -15.82 (AgentCompta relevé) Paiement par carte X4074 AMAZON PAYMENTS PARI 22
  #274  2026-07-27     -21.49 (AgentCompta relevé) Prélèvement OVH SAS - OVH - payment for order 
  #432  2026-07-27      26.40 Avoir KDI reçu — remboursement client 3813883
  #102  2026-07-28    5015.74 (CustomerInvoicePayment)
  #167  2026-07-28   -2712.00 (AgentCompta) PAIEMENT PAR CARTE X4074 METALMAQ GAVA        27/07
  #399  2026-07-28    -200.00 (AgentCompta) Paiement par carte X7200 CARREFOUR MARKET ST 27/07
  #162  2026-07-29    -209.00 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07
  #163  2026-07-29     -16.62 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07
  #164  2026-07-29     -56.59 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07
  #165  2026-07-29     -40.79 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07
  #166  2026-07-29     -11.75 (AgentCompta) PAIEMENT PAR CARTE X4074 AMAZON PAYMENTS PARI 28/07
  #161  2026-07-30      -1.24 (AgentCompta) PAIEMENT PAR CARTE X7200 INPI VADS 92 COURBEV 29/07
  #275  2026-07-30    -130.80 (AgentCompta relevé) Paiement par carte X7200 MEDIALEX RENNES 29/07
  #317  2026-07-30    2194.00 Remboursement DGFiP — crédit de TVA
  #103  2026-07-31    3120.00 (CustomerInvoicePayment)
  #126  2026-07-31      32.57 (AgentCompta) AVOIR CARTE X4074 INPI VADS      30/07
  #209  2026-07-31   -8804.22 (AgentCompta effet) EFFETS DOMICILIES DOMICILIES
  #356  2026-07-31   -1627.13 Salaire net
  #160  2026-08-03   -1290.00 (AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06/27 SELLERIE
  #212  2026-08-03   -3240.00 (AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-08-12 TE 
  #433  2026-08-04      -8.94 Fournitures — Amazon (TVA non récupérée faute de pièce)
  #434  2026-08-04     -46.89 Fournitures — Amazon (TVA non récupérée faute de pièce)
  #108  2026-08-05     100.41 (CustomerInvoicePayment)
  #109  2026-08-05   12346.02 (CustomerInvoicePayment)
  #285  2026-08-05    -352.05 Remboursement de prêt 10003101334 — capital
  #293  2026-08-05     -51.87 Remboursement de prêt 10003101334 — intérêts
  #301  2026-08-05     -18.30 Assurance emprunteur ASSU. CAAE — prêt 10003101334
  #435  2026-08-05     -56.53 Fournitures — Amazon (TVA non récupérée faute de pièce)
  #436  2026-08-05     -28.26 Fournitures — Amazon (TVA non récupérée faute de pièce)
  #110  2026-08-06     329.50 (CustomerInvoicePayment)
  #364  2026-08-06   11202.99 (CustomerInvoicePayment) Solde relevé Normandie Biologi'K
  #400  2026-08-06     -24.85 (AgentCompta) Paiement par carte LIDL 24,85
  #437  2026-08-06    -280.90 Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)
  #439  2026-08-06     692.38 (CustomerInvoicePayment) Virement RAULIN INVEST — fac 178/180/188/18
  #277  2026-08-07    -140.33 (AgentCompta relevé) Prélèvement ELECTRICITE DE FRANCE - EDF - TEKN
  #357  2026-08-07    -130.01 Assurance
  #358  2026-08-07     -78.89 Assurance
  #359  2026-08-07     -57.53 Assurance
  #360  2026-08-07     -11.38 Assurance
  #387  2026-08-07     -66.60 (AgentCompta) Paiement par carte X4074 LE BUFFAROT ST MARTI 06/08
  #438  2026-08-07     -59.30 Facture Crédit Agricole 2026-07 — services bancaires