Page 1 sur 1

Etat des ventes

Posté : mer. mars 09, 2022 3:07 pm
par duts
Bonjour,

j'utilise la version 1.7.1.

La demande de l'état des ventes provoque un blocage...
Capture d’écran 2022-03-09 à 16.03.26.png
Capture d’écran 2022-03-09 à 16.03.26.png (42.77 Kio) Vu 11588 fois
Et des erreurs en cascade dans le log :

SELECT "SAISIE_VENTE_FACTURE_ELEMENT"."CODE", "SAISIE_VENTE_FACTURE_ELEMENT"."NOM", "SAISIE_VENTE_FACTURE_ELEMENT"."ID_ARTICLE", "SAISIE_VENTE_FACTURE_ELEMENT"."ID_TAXE", "FAMILLE_ARTICLE"."NOM", SUM(CASE WHEN "mod1"."ID_TYPE_REGLEMENT"=2 OR "mod2"."ID_TYPE_REGLEMENT"=2 THEN "SAISIE_VENTE_FACTURE_ELEMENT"."QTE" ELSE 0 END) as "Cheque", SUM(CASE WHEN "mod1"."ID_TYPE_REGLEMENT"=3 OR "mod2"."ID_TYPE_REGLEMENT"=3 THEN "SAISIE_VENTE_FACTURE_ELEMENT"."QTE" ELSE 0 END) as "CB", SUM(CASE WHEN "mod1"."ID_TYPE_REGLEMENT"=4 OR "mod2"."ID_TYPE_REGLEMENT"=4 THEN "SAISIE_VENTE_FACTURE_ELEMENT"."QTE" ELSE 0 END) as "Especes"
FROM "OpenConcerto"."OpenConcerto50"."SAISIE_VENTE_FACTURE_ELEMENT"
LEFT JOIN "OpenConcerto"."OpenConcerto50"."SAISIE_VENTE_FACTURE" on ((("SAISIE_VENTE_FACTURE_ELEMENT"."ID_SAISIE_VENTE_FACTURE" = "SAISIE_VENTE_FACTURE"."ID") AND ("SAISIE_VENTE_FACTURE"."ARCHIVE" = 0)) AND ("SAISIE_VENTE_FACTURE"."ID" <> 1)) AND ("SAISIE_VENTE_FACTURE_ELEMENT"."ID_TICKET_CAISSE" = 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."ARTICLE" on (("SAISIE_VENTE_FACTURE_ELEMENT"."ID_ARTICLE" = "ARTICLE"."ID") AND ("ARTICLE"."ARCHIVE" = 0)) AND ("ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "FAMILLE_ARTICLE"."ID") AND ("FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("FAMILLE_ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."MODE_REGLEMENT" "mod1" on (("SAISIE_VENTE_FACTURE"."ID_MODE_REGLEMENT" = "mod1"."ID_MODE_REGLEMENT") AND ("mod1"."ARCHIVE" = 0)) AND ("mod1"."ID_MODE_REGLEMENT" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."TICKET_CAISSE" "ticket" on ((("SAISIE_VENTE_FACTURE_ELEMENT"."ID_TICKET_CAISSE" = "ticket"."ID") AND ("ticket"."ARCHIVE" = 0)) AND ("ticket"."ID" <> 1)) AND ("SAISIE_VENTE_FACTURE_ELEMENT"."ID_SAISIE_VENTE_FACTURE" = 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."ENCAISSER_MONTANT" "enc" on (("enc"."ID_TICKET_CAISSE" = "ticket"."ID") AND ("enc"."ARCHIVE" = 0)) AND ("enc"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."MODE_REGLEMENT" "mod2" on (("enc"."ID_MODE_REGLEMENT" = "mod2"."ID_MODE_REGLEMENT") AND ("mod2"."ARCHIVE" = 0)) AND ("mod2"."ID_MODE_REGLEMENT" <> 1)
WHERE ("SAISIE_VENTE_FACTURE_ELEMENT"."ID" <> 1) AND (("SAISIE_VENTE_FACTURE_ELEMENT"."ARCHIVE" = 0) AND ((("ticket"."DATE" BETWEEN CAST( '2022-01-01 00:00:00.0' AS timestamp ) AND CAST( '2022-03-31 23:59:59.0' AS timestamp )) OR ("SAISIE_VENTE_FACTURE"."DATE" BETWEEN CAST( '2022-01-01' AS date ) AND CAST( '2022-03-31' AS date ))) AND ("SAISIE_VENTE_FACTURE_ELEMENT"."NIVEAU" = 1)))
GROUP BY "SAISIE_VENTE_FACTURE_ELEMENT"."NOM", "SAISIE_VENTE_FACTURE_ELEMENT"."CODE", "SAISIE_VENTE_FACTURE_ELEMENT"."ID_ARTICLE", "SAISIE_VENTE_FACTURE_ELEMENT"."ID_TAXE", "FAMILLE_ARTICLE"."NOM"
ORDER BY "FAMILLE_ARTICLE"."NOM"
SELECT "AVOIR_CLIENT_ELEMENT"."CODE", "AVOIR_CLIENT_ELEMENT"."NOM", "AVOIR_CLIENT_ELEMENT"."ID_ARTICLE", "AVOIR_CLIENT_ELEMENT"."ID_TAXE", "FAMILLE_ARTICLE"."NOM"
FROM "OpenConcerto"."OpenConcerto50"."AVOIR_CLIENT_ELEMENT"
LEFT JOIN "OpenConcerto"."OpenConcerto50"."AVOIR_CLIENT" on (("AVOIR_CLIENT_ELEMENT"."ID_AVOIR_CLIENT" = "AVOIR_CLIENT"."ID") AND ("AVOIR_CLIENT"."ARCHIVE" = 0)) AND ("AVOIR_CLIENT"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."ARTICLE" on (("AVOIR_CLIENT_ELEMENT"."ID_ARTICLE" = "ARTICLE"."ID") AND ("ARTICLE"."ARCHIVE" = 0)) AND ("ARTICLE"."ID" <> 1)
LEFT JOIN "OpenConcerto"."OpenConcerto50"."FAMILLE_ARTICLE" on (("ARTICLE"."ID_FAMILLE_ARTICLE" = "FAMILLE_ARTICLE"."ID") AND ("FAMILLE_ARTICLE"."ARCHIVE" = 0)) AND ("FAMILLE_ARTICLE"."ID" <> 1)
WHERE ("AVOIR_CLIENT_ELEMENT"."ID" <> 1) AND (("AVOIR_CLIENT_ELEMENT"."ARCHIVE" = 0) AND (("AVOIR_CLIENT"."DATE" BETWEEN CAST( '2022-01-01' AS date ) AND CAST( '2022-03-31' AS date )) AND ("AVOIR_CLIENT_ELEMENT"."NIVEAU" = 1)))
GROUP BY "AVOIR_CLIENT_ELEMENT"."NOM", "AVOIR_CLIENT_ELEMENT"."CODE", "AVOIR_CLIENT_ELEMENT"."ID_ARTICLE", "AVOIR_CLIENT_ELEMENT"."ID_TAXE", "FAMILLE_ARTICLE"."NOM"
ORDER BY "FAMILLE_ARTICLE"."NOM"
2022-01-01 00:00:00.0
2022-03-31 23:59:59.0
End column search : 9
End row search : 54
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Nombre de page == 1
End column search : 6
End row search : 54
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Nombre de page == 1
End column search : 6
End row search : 54
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Index out of bounds Exception
Nombre de page == 1
End column search : 10
End row search : 54
Nombre de page == 1
org.openconcerto.erp.generationDoc.InvalidTemplateException: La feuille numéro 4 n'est pas dans le modèle
at org.openconcerto.erp.generationDoc.OOgenerationListeXML.genere(OOgenerationListeXML.java:99)
at org.openconcerto.erp.generationDoc.AbstractListeSheetXml$1.call(AbstractListeSheetXml.java:60)
at org.openconcerto.erp.generationDoc.AbstractListeSheetXml$1.call(AbstractListeSheetXml.java:1)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.IndexOutOfBoundsException: Index: 5 Size: 5
at org.jdom.ContentList.get(ContentList.java:377)
at org.jdom.ContentList$FilterList.get(ContentList.java:582)
at org.openconcerto.openoffice.spreadsheet.SpreadSheet.getSheet(SpreadSheet.java:268)
at org.openconcerto.erp.generationDoc.OOgenerationListeXML.genere(OOgenerationListeXML.java:97)
... 6 more

Re: Etat des ventes

Posté : mer. mars 09, 2022 4:39 pm
par duts
Le modèle 'EtatVentes' livré avec la version 1.17.1 semble incorrect :
1) il manque une feuille n° 5 qui est utilisée par le xml et c'est cela qui provoque le plantage...
2) pour la feuille 'Ventes' la colonne 'En CB' est remplie avec les mêmes infos que la colonne espèces... et le total n'est pas géré sur la ligne attendue généralement en bas de page...

Pouvez-vous nous communiquer les bons fichiers ?

Re: Etat des ventes

Posté : ven. mars 11, 2022 10:51 am
par guillaume
Bonjour,

On est dessus pour la 1.7.2 (deja dispo en beta).

Cordialement,

Re: Etat des ventes

Posté : ven. mars 25, 2022 5:59 pm
par duts
Merci !