Etat des ventes

Répondre
duts
Messages : 11
Enregistré le : mer. janv. 13, 2021 8:19 pm

mer. mars 09, 2022 3:07 pm

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 11589 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
duts
Messages : 11
Enregistré le : mer. janv. 13, 2021 8:19 pm

mer. mars 09, 2022 4:39 pm

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 ?
Avatar du membre
guillaume
Messages : 2429
Enregistré le : ven. févr. 11, 2011 7:15 pm

ven. mars 11, 2022 10:51 am

Bonjour,

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

Cordialement,
Directeur technique d'OpenConcerto qui dans son temps libre s'occupe du forum.
Pour une assistance pro, nous sommes joignables à ILM Informatique contre quelques jetons.
Pensez aussi à lire le manuel !
duts
Messages : 11
Enregistré le : mer. janv. 13, 2021 8:19 pm

ven. mars 25, 2022 5:59 pm

Merci !
Répondre