1 2 3 4 5 6 7
| Strsql = " INSERT INTO Z_JournalAchat ( VersionComptaGénérale, [Supplier ID], Num_facture, [Type mouvement], Journal," _
& " NumeropieceJournal, Date_Compta, Article9, GENCPT6_id, Crédit ) " _
& " SELECT VersionComptaGénérale, [Supplier ID], Num_facture, 'F', 'JAC', " _
& " NumeropieceJournal, Date(), 0, Compte, Sum(lgn_total_TVA) " _
& " FROM Z_Invoice_Details " _
& " WHERE [Supplier ID] = " & Me.Supplier_ID & " And num_facture = '" & Me.num_facture & "'" _
& " GROUP BY VersionComptaGénérale, [Supplier ID], Num_facture, 'F', Journal, NumeropieceJournal, Date(), 0, Compte " |
Partager