{"id":21336,"date":"2022-08-05T14:39:44","date_gmt":"2022-08-05T12:39:44","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/index\/index-consistency-of-invoice-amount-vs-multiple-orders\/"},"modified":"2024-05-07T10:34:34","modified_gmt":"2024-05-07T08:34:34","slug":"index-consistency-of-invoice-amount-vs-multiple-orders","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/index\/index-consistency-of-invoice-amount-vs-multiple-orders\/","title":{"rendered":"Index: Consistency of Invoice Amount vs. Multiple Orders"},"content":{"rendered":"\n<pre class=\"wp-block-code has-white-color has-black-background-color has-text-color has-background\" style=\"font-size:14px\"><code>var mtcapture= parseFloat(getTextFromIndexInfo(getFirstIndexFromID(pParameters, \"AMOUNT_EX_VAT_INDEX\")).replace(',', '.'));\nvar database = new JSE_Database(\"DSN=OBExample\");\n\nvar getNumCommandes = function(pParameters){\n    var result = &#91;];\n    var articles = getArticleLines(pParameters, \"COMMANDE_INDEX\");\n    if(articles == null)\n        return result;\n\n    for(var i=0;i&lt; articles.length; i++){\n        var numCde = getTextFromIndexInfo(getIndexFromArticleLine(articles&#91;i], \"NUM_REF_COMMANDE_INDEX\"));\n        if(numCde != null &amp;&amp; result.indexOf(numCde) === -1)\n            result.push(numCde);\n    }\n\n    return result;\n};\n\nvar getCdeAmount = function(nCommande, database){\n    var res = database.executeRequest(\"SELECT cdeAmount AS \\\"MTCDE\\\" \"\n    + \"FROM tableCde \"\n    + \"WHERE numCde LIKE '%\"+nCommande+\"%'\");\n\n    if(res != null &amp;&amp; res.length &gt; 0 &amp;&amp; res&#91;0]&#91;\"MTCDE\"] != null)\n        return res&#91;0]&#91;\"MTCDE\"];\n    return 0;\n};\n  \n\nvar sumAmountCde = 0;\nvar numCdeList = getNumCommandes(pParameters);\n\nfor(var i=0;i&lt; numCdeList.length;i++)\n    sumAmountCde += getCdeAmount(numCdeList&#91;i], database);\n\nif(sumAmountCde == mtcapture)\n    return 'Conforme';\n\nreturn 'Non Conforme, montant cde = '+sumAmountCde.toFixed(2);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":97,"featured_media":0,"parent":21276,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-21336","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21336"}],"version-history":[{"count":1,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21336\/revisions"}],"predecessor-version":[{"id":21340,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21336\/revisions\/21340"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21276"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}