SCRIPT APISERVICE TROUVER LES FACTURES NON TRANSFÉRÉES EN COMPTABILITE

/// PARAMETERS [Date debut] DateTime, [Date fin] DateTime, [Journal] text; SELECT Facture.Code, Facture.DateDoc, Facture.CodeClient, Facture.FacNomSite, Facture.TotalTTC FROM Facture WHERE (((Facture.Code) Not In (SELECT Ecritures.Reference FROM [E:\SagePE\Services\v12\API2S\CPTSER\CPTOMNIP\compta.mdb].Ecritures GROUP BY Ecritures.Journal, Ecritures.Reference HAVING (((Ecritures.Journal)=[Journal])) ))) AND ((Facture.DateDoc) BETWEEN Format([Date debut], « yyyy/mm/dd ») AND Format([Date fin], « yyyy/mm/dd »)) ORDER BY Facture.DateDoc, Facture.Code ///