WAVESOFT MARQUER UNE ECHEANCE REGLER

L’affichage de la liste des impayés en gestion vient de la vue : [V_PIECEVENTEECHEANCE_NONREGLEES] /// SELECT dbo.PIECEVENTES.PCVID, dbo.PIECEVENTES.PCVNUM, TIERS_CLIFAC.TIRCODE AS TIRCODE_FAC, TIERS_CLIFAC.TIRSOCIETE AS TIRSOCIETE_FAC, dbo.PIECEVENTES.EXEID, dbo.PIECEVENTEECHEANCE.PEVDATE, dbo.V_LST_NATUREPIECE.PINSENSCPT * dbo.PIECEVENTEECHEANCE.PEVMONTANT AS PEVMONTANT, dbo.REGLEMENTTYPE.RGTINTITULE, dbo.V_LST_NATUREPIECE.PINSENSCPT * (dbo.PIECEVENTEECHEANCE.PEVMONTANT – dbo.PIECEVENTEECHEANCE.PEVMNTREGLE) / dbo.PIECEVENTES.PCVCOURSDEV AS SOLDE_ECHEANCE, TIERS_REP.TIRCODE AS TIRCODE_REP, dbo.V_LST_NATUREPIECE.PINSENSCPT * dbo.PIECEVENTEECHEANCE.PEVMNTREGLE AS PEVMNTREGLE, dbo.PIECEVENTES.PCVDATEEFFET, dbo.PIECEVENTES.SOCID, dbo.V_LST_ETABLISSEMENTS.SOCCODE, dbo.PIECEVENTES.TIRID_REP, TIERS_CLIFAC.TIRSOCIETETYPE FROM dbo.PIECEVENTES INNER JOIN dbo.V_LST_NATUREPIECE ON dbo.PIECEVENTES.PINID = dbo.V_LST_NATUREPIECE.PINID INNER JOIN dbo.PIECEVENTEECHEANCE ON dbo.PIECEVENTES.PCVID = dbo.PIECEVENTEECHEANCE.PCVID INNER JOIN dbo.REGLEMENTTYPE ON dbo.PIECEVENTEECHEANCE.RGTID = dbo.REGLEMENTTYPE.RGTID INNER JOIN dbo.V_LST_ETABLISSEMENTS ON dbo.PIECEVENTES.SOCID = dbo.V_LST_ETABLISSEMENTS.SOCID INNER JOIN dbo.TIERS AS TIERS_CLIFAC ON dbo.PIECEVENTES.TIRID_CPT = TIERS_CLIFAC.TIRID LEFT OUTER JOIN dbo.TIERS AS TIERS_REP ON dbo.PIECEVENTES.TIRID_REP = TIERS_REP.TIRID WHERE (dbo.PIECEVENTES.PITCODE = ‘F’ OR dbo.PIECEVENTES.PITCODE = ‘M’) AND (dbo.PIECEVENTEECHEANCE.PEVISREGLE = ‘N’) AND (dbo.PIECEVENTEECHEANCE.PEVMONTANT <> dbo.PIECEVENTEECHEANCE.PEVMNTREGLE) /// Pour corriger une échéance il faut repérer son PCVID puis appliquer la requête de mise à jour suivante : /// Update [CEISTA].[dbo].[PIECEVENTEECHEANCE] set [PEVISREGLE] = ‘O’, [PEVMNTREGLE] = ‘1000.560’ where pcvid = 2567 ///