Solved: Failed to create voucher

kashyap · ‎11-07-2024

We are trying to create voucher with PDF attachment. Getting below error.

{"errors":[{"message":"Error: The primary key is in use.","path":["useCompany","incomingAccountingDocumentAttachment_create","values/0"],"extensions":{"data":{"status":15,"status_name":"valueNotAccepted"}}}],"data":{"useCompany":{"batch_create":{"affectedRows":1,"items":[{"batchNo":46}]},"voucher_create":{"affectedRows":2,"items":[{"batchNo":46,"voucherNo":1,"voucherDate":20240627},{"batchNo":46,"voucherNo":2,"voucherDate":20240627}]},"incomingAccountingDocumentAttachment_create":{"affectedRows":1,"items":[{"incomingAccountingDocumentNo":1,"attachmentNo":0,"fileNo":0}]}}},"extensions":{"vbnxt-trace-id":"0000000000000000dcd04b09d706e92c"}}

Can you please help?

kashyap · ‎09-09-2024

Anyone know how to resolve below error. Everyday our client getting this error.

"The primary key is in use."

omelhus · ‎09-09-2024

Can you post the entire query?

kashyap · ‎10-09-2024

Request:

{"query":"mutation createBatchAndVoucherWithAttachment($batchId: Int = 0) { useCompany(no: 3105037) { batch_create( values: [{voucherSeriesNo: null, valueDate: 20240905, description: \"Z-rapport-1-1003\" }]) { affectedRows items { batchNo @export(as: \"batchId\") } } voucher_create( values: [{creditAccountNo: 3005, creditTaxCode: null, amountDomestic: 2660, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: \"Z-rapport 1003 Salg Varer 25.00% MVA (05.09.2024)\"}{debitAccountNo: 1920, debitTaxCode: null, amountDomestic: 1930, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: \"Z-rapport 1003 BankAxept (05.09.2024)\"}{debitAccountNo: 1901, debitTaxCode: null, amountDomestic: 730, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: \"Z-rapport 1003 Til nattsafe (05.09.2024)\"}]) { affectedRows items { batchNo voucherNo voucherDate } } incomingAccountingDocumentAttachment_create( values: [{incomingAccountingDocumentNo: 1, attachmentNo: 1, attachmentType: 2, fileName: \"z-report-1003-4.pdf\", fileData: \"JVBERi0xLjMKMSAwIG9iago8PCAvVHlwZSAvQ2F0YWxvZwovT3V0bGluZXMgMiAwIFIKL1BhZ2VzIDMgMCBSID4+CmVuZG9iagoyIDAgb2JqCjw8IC9UeXBlIC9PdXRsaW5lcyAvQ291bnQgMCA+PgplbmRvYmoKMyAwIG9iago8PCAvVHlwZSAvUGFnZXMKL0tpZHMgWzYgMCBSCjExIDAgUgoxMyAwIFIKMTYgMCBSCl0KL0NvdW50IDQKL1Jlc291cmNlcyA8PAovUHJvY1NldCA0IDAgUgovRm9udCA8PCAKL0YxIDggMCBSCi9GMiA5IDAgUgovRjMgMTAgMCBSCi9GNCAxNSAwIFIKPj4KPj4KL01lZGlhQm94IFswLjAwMCAwLjAwMCA1OTUuMjgwIDg0MS44OTBdCiA+PgplbmRvYmoKNCAwIG9iagpbL1BERiAvVGV4dCBdCmVuZG9iago1IDAgb2JqCjw8Ci9Qcm9kdWNlciAoZG9tcGRmIDw1Yzk4NjUyPiArIENQREYpCi9DcmVhdGlvbkRhdGUgKEQ6MjAyNDA5MDYwOTEwMjcrMDInMDAnKQovTW9kRGF0ZSAoRDoyMDI0MDkwNjA5MTAyNyswMicwMCcpCi9UaXRsZSAoKQo+PgplbmRvYmoKNiAwIG9iago8PCAvVHlwZSAvUGFnZQovTWVkaWFCb3ggWzAuMDAwIDAuMDAwIDU5NS4yODAgODQxLjg5MF0KL1BhcmVudCAzIDAgUgovQ29udGVudHMgNyAwIFIKPj4KZW5kb2JqCjcgMCBvYmoKPDwgL0ZpbHRlciAvRmxhdGVEZWNvZGUKL0xlbmd0aCAxNjY0ID4+CnN0cmVhbQp4nKWZy3LaSBSG936Ks0yqJj19v2SHy8RFzNgeg7OYJAtcyAwGC0Zgp+Zt5uXyDl7OEVa3GiEkjWdDwaG7z9//1ze1TiihlEL8mc1OTscgGVFMg9GSUOdgPIVfP3FwhML4HuDru0+rbDOfJikkGSwns2QL96sMfsJsDo/JdJLdJfhvlv+fwuo5wcKL7e4L/Imf0/VTutgmaQIDWK3Xs4eXLNkSCI3O03T2M4P5YpHAZvWYNzJNljB5hvffYfwZ+uNYoxKEMXqocbpaPD0m6XayeVil2ETe0l2S/r3dJhvYzpeQJbN0s5isN/cv2SZZRgKwM5N0mmG5nebtfAp3k02SbWH9E+6yp0WSpa+N3E0WyWOynM7TWZKRIE8YYjRq44poI4BJQThqZJxI6zAx3J8cWn9zfoJdgh9A4TN8BfiOX6Z5UzTvprCEaQ6PwCwlzpSRJYyO1NtJwFKO5fUqml6r5XnjzwK/KIpaYpV8tVZE1p4mm0U2f06WmyR0uXYoBa1FUq6JonzPhxrp1R4+AqeGSGMrfa4Xzywjhjeo7+GYWC6bhYeEhXCNLhrWJrwqE4UbQxjOoBZY3GgipYtohUgHXFxRop1p4rV8WYcONwyWIlk5WBgj2spd9qNrRTFYmCZM8MPko97wHK5vrs5uL8b9m3gGMyt30yKvKrQ6nMJK/UJpk+6qS5FvkfLcIlTJsMDRVFxr2pLMz8R8EAgZz8Qi0jITGUqwsjRXO4tSlZfofaScWCeO+Hje+9K/uLoZN+msyoqmTyQ0N4XmM0ViSlSGM+bAlGbvK41Gg73ZjxKRN8RHKo5whZPGqgZ93Yhp51CXioj5SDOxvJSTKiJmFeFUV4hp64ium3Y7YuOrcW/YiVcp01vbIrNarCTQVjH47TsYIvs99NMm76K15v9Mm7xlp3QMoYi0QLCaGKojCIYRp00VAnZAS3uo8J9O1gdxwdNIXLSpvC1NtdEIVLMHJRZvQojsu8ANgsIt4G36PCLDiWEmRlREWhBhcqlNhAgnLm5GVUQ6H0z6cJ5cXF2Oe5fd5kiQGDyNJEZrWp5M0pqjq+oEqkzjQTU7UWLxVoTIvhdc4ppmzHF9RnSdUMrttEa0ikgLLU0J5zaiJdXuVFOhJXFtEOaQ1n/ZgkqNwdlIY4wLjzDM1JziO21BURqPq9mKACd4ESL7Zvgt6Li+jrCkJly4GFYRaYGFpZx1ESzBCZ73qrAETntnD2H1L0Z46LqE0z7uQoPL807Qgtbgb6Q1hoZZnWBvhVam8dCaLSkReU9CZN+UAO2ovo7QhNidcyNoRaQFGpYyikbQGOZmrAqN4xKg3CG0L4Pr61EnUkFgMDUSGJPCVNrxt5Iq03hSzT6UXLwRIbLvRCB1VF9HUtis0SwmVURaSHFKFGMRKaqIMbxKiuXLBK054Y1vBtf9TqiCwuBqpDBGhbmkEm9FVabxqJqNCGCCEyGyb0VAdVRfR1RUE8XjiwwfaUGFPeQmushQjhMlRAWVcvniwA5R4TL42+CyN+wEK2gMvkYa8+MgZjE4IJRDUUwemsFYJ1plHk+r2YuSjTfDRypu+IP7cYGu6zlDOUG4FREwH2kGppwkVESXCco4wp2sArMCG615Iu90cC/FeU9jcdHB/W1pqo2WoFo8KLF4E0Jk3wV/cH+bPo8I3aAyvpLwkRZEWMq46EpCaU2oql5JKINrA625ksCD4Kg/hNG41+04WOoMxjbrrBaL/G+p6N0OPQyR/S6GiYJ9NKLmjoHhPtdxomDLlsbXDD5ynMKunhIES8b1ikgLPW2IUtH1hFKcWFa9nlAKlwBdcz3h6Q1vx93ohf4FLM39q3YnqtjcwWr7EfbmjNX2o4otGcPo8J6GyL6pYbygq9LV3IhUxwvWEfKVMx5yrKt5/r1cbeebmgoGF+/81rmowCThRY0/PmST9XqVbQHTCcCdmuKqQrmsa8XiPk5rHl2uXl+97F7d9L4Mzq+gd3PaH5zB1TkMLi+Gt2f9G3xkgN4IPsBp9rTY3j1t85cyKXx757gyFrdA9e093C0TmD0kabp6vH9BTaUcHNEfcTdbzWAzn6X5C5TKSxyv0Uh8uq45qY+zp2kCo8VDsnyepOULFjyP0fwauvzMZidFY3jqzw+diuO4R4B092t3Zf/X0UtsxV5/cYujpGYVHs1RBsvV71usG2udJ9jnvNdzOLvtD4eAu7t3hrqPrHFV+f1fXCL61wplbmRzdHJlYW0KZW5kb2JqCjggMCBvYmoKPDwgL1R5cGUgL0ZvbnQKL1N1YnR5cGUgL1R5cGUxCi9OYW1lIC9GMQovQmFzZUZvbnQgL1RpbWVzLVJvbWFuCi9FbmNvZGluZyAvV2luQW5zaUVuY29kaW5nCj4+CmVuZG9iago5IDAgb2JqCjw8IC9UeXBlIC9Gb250Ci9TdWJ0eXBlIC9UeXBlMQovTmFtZSAvRjIKL0Jhc2VGb250IC9IZWx2ZXRpY2EKL0VuY29kaW5nIC9XaW5BbnNpRW5jb2RpbmcKPj4KZW5kb2JqCjEwIDAgb2JqCjw8IC9UeXBlIC9Gb250Ci9TdWJ0eXBlIC9UeXBlMQovTmFtZSAvRjMKL0Jhc2VGb250IC9IZWx2ZXRpY2EtQm9sZAovRW5jb2RpbmcgL1dpbkFuc2lFbmNvZGluZwo+PgplbmRvYmoKMTEgMCBvYmoKPDwgL1R5cGUgL1BhZ2UKL01lZGlhQm94IFswLjAwMCAwLjAwMCA1OTUuMjgwIDg0MS44OTBdCi9QYXJlbnQgMyAwIFIKL0NvbnRlbnRzIDEyIDAgUgo+PgplbmRvYmoKMTIgMCBvYmoKPDwgL0ZpbHRlciAvRmxhdGVEZWNvZGUKL0xlbmd0aCAyMTI3ID4+CnN0cmVhbQp4nKVay3YbNxLd+yuwmXOcc8YInt1AdtKRhkexLE8kyos8Fu1hS0OLammatJLPmc/Kp3iZarqBLkKNh5WNaJVRqFt1L4ACqFeMCsYI/tnfvmKU7X+dfl4uXnGqye+EkR/JL4T8Bv9YzYwDZ6mp5hWpq5paxonmtNaMcEGVsaRvyc3cTFLRugInw6i0jNwTU1OBDBtyNes2xjKccjW4BcG/ug3A8E8Aebwkin8dWoPRCLJcke//JYmljCxvCPnl9duHbvfw3W9k+SM5Xc6n6kCO0YSxlFuZyzVIDUDXFVXaBMnOozaGsizqrnnq0sh9yBG60XtMOZYCoPdEVUCvUEXQFZBjaxHHftJ+bHdp3D7eiNtCOVRWXSHKe6IrBuyHuJ85am1BlwoJzFsKFKZFDWNlgqy+Xa2njBMCH6NNAteSWi724WcLhQSuDdWgyn10gaJLxrSPjaQVG391dL4g/758f3L9dnl6SYSGWP8gi8vri4vzowWeSUkDOklMpdg/GUvlHZYZFR5lvq8xp0KaeCjBK5MJ5jYfrWhVCbT5jIbM5qM1VVwgbhSjVS0dQkeD0lRqlaEhsV14dH4VIniIvlicefrefThKliaIhVb8YXRPeSw8z1EeTowWaZqHSRmOCG85ZEKLigol4hi1EoVSAVKVkEgqoyEmldFNGMqNQm6jIaMwJSivJVIYbCxKqlBhklMzt82UKswn5VlPZxUkgfxQWkiZMXzzyry6flekTI/aCyjDRQASOR7C9pKO4dbFkvYYvaTTGENEyDGtmEn5TjLecqgZv2/GkhP14YoFH1DxnkcOzUJtv7rw4ex1Pv/3o0ehVnA+K2m/sQnkjFph0CoZDZlVwjksdjOtEhe8pAlk4CvY32kCXTQphyawLm0Cfa4KNicFm9xhsukmMIk63wS6kA66+tqu5JqpAChArxUVQh9AdzY3NzSYGj5ycwczId2nNeBV7kXgLCUq0LCo6iGlWEGP282Xx4I+zQWbNGgU7CGspE+rgFVjTWb7ntiPjn/RdhqWCxUQpTDUihs4RHk8/BvQdW5jHFd6NVw7GLruOUN6pQ+jrEbXvQoabMF5cB5WtaaVts8RciuS6AIw09rE8BARsTjLtr9fd82GHDfdXfNH+5hs9cMg07rKVCUcNi2ajOPEsKuntxwW1B0WiYrKUsphZltxRPloyFBeCwprG1Gu6/1lMqC8gv1lbgFznUYXgEGUI3iI8lgcT/m7Zrtr+/80/aqI8ymuIzNdlnAY4jztODHsCuothxXVEpplEEU01VLC4WJWC3SrcoYM4YBK1ehWVSmYT4a3qkrBaWv4ywn36DwVCB4iPBbHE/5hvW2KqJ4iOg7TBQmHIarTjhOxrpTeclhLT3UsyVKq4V6lDLoVOUOGagXhJbreVNCTKhteb6rh+UjNdaq26HozofNUIHiI6licRfPU3j30O7Luus2XbdlmPgV1NKZrEg5DbKcdJ25dNb3lsJye7ViepWxLAY0Ausw6Q4ZtGGWtQmwPDYXWIdsC9icm544axkvY9ug8FQgeYjsWZ7nekK7Z7bbNTVvE9BTQUZiuRzgMMZ12nHh1lfSWw1K6945ojnXxqc3BiWnE9WjIcA2jaq0R10zvqx5wzWCDqtTLufboPBkIHuI6Fme4LzXdjqzWNzdt33TbMsansI7KdFXCYYjxtOPEr6untxwW1K/tWKalfMO0w+fE92jI8M2q/afnW1u4+Nd1wLe21b4OL+bbo/NUIHgT39E4b5vttv3Y/vdhs+rW3S1pu1UPn0WkT7Edm+nShMMQ6WnHiWJXVGcJqupIj6ZbSLq2gmpRT6Q7Q/pRU9eWCoOea5whrRVtJRV1jbRSG6qlCbViYJMz1czeVVtboJUpKcdgJqsgCeSH0kIai+H7s2+bp/5ztyoUFgI6KiYDNMSFHNMEhPNPisxFDOZHjumIk3Ad595ySLqXcqyqkSdJXVVUGlnyJKmhydVKEiWh181/4zlqHC5BTA4tNOCtmfCGjMZhVG3QJcYFL3iS1Frsn4Bf8iTpQLpU4diQNvv4FqQGerKGcpjxMNl51CAApUUGdcGTpAs5QudwmYVOKPdsGAAFfXGYEhwxdG9zZQEJiuyjdDgTEn1aA17iXgTeUqAC9yQZLWjpk6QLNmlw+NQq+STp2FSDceaKcHZM9mdoyYviBMBbEAL0uhSNBtSWHmGwf0im0DodDZl1KmvKNLqTaOiYJY/2Y8HkaKWgcKiMsFMPD+vzfciu3WxyZ0QwPdJ3Or9wGBJvxtFT5SrjLag0mLxYjrz4kqGFpKzSiLzRkOk/oNc1okJuoyHDOUxuOLqbDG6sjroFmBDnaZQBKOSHYCKtcAlH8Mx6vy5YciEkpJM0yBATckwXM5wfCSwdMZwfOWYieh06/rwFEYiVGatouK1M7YSCTtoKnmwn0GhoVrSe/dbI3TC24w2DPDV9u2lu254MFzdomhgg4+YHIeYmroAVN7HId0FKy/3XrM+AfGj71Zo0T98YXkLb8C3hhdp/jfAs/MXDbr2d+yLZDi/O/r2RQ3c5evz8pm8eH4e3NiBJIrBzsxi4RrEZmO8fH28/fenJzUNPjj6cLd6To8vj07MT8n5Bzi7enl+fnF6eXSzI0RV5Q477z3e7j59367u7tiO/vrYCWlNoD/Sv35GPm5bcfmq77uH+5gtgCmtHHm7Jdn3btfB/UOQ5jNA5D6/tzzAu+8+rllzdfWo3T01HUXM082eZ42Swcw8sD39dJpSF/x5+27cv/4se6PvlBr9BV6ErPfPHQWuAIQb0hyWukl6LFnIesl6Tk+vT83MCV1VXGWZ/4Mld/6e/AJIT/lsKZW5kc3RyZWFtCmVuZG9iagoxMyAwIG9iago8PCAvVHlwZSAvUGFnZQovTWVkaWFCb3ggWzAuMDAwIDAuMDAwIDU5NS4yODAgODQxLjg5MF0KL1BhcmVudCAzIDAgUgovQ29udGVudHMgMTQgMCBSCj4+CmVuZG9iagoxNCAwIG9iago8PCAvRmlsdGVyIC9GbGF0ZURlY29kZQovTGVuZ3RoIDM3MzYgPj4Kc3RyZWFtCnicnVzLdhy3Ed37K7DJOfZxhOD98I46GvPQlEiFHGkR24tROKLHJIfMcKTEX5Rf8g/kH7RMNdkAqsHGg9pQYh2g6+LeqgJQ08NvGBWMEfxzd/kNo+zh1/Tz7PAbTjX5N2HkJ/IzIb/Cfy5mxsHkl0siFWXcEKsl1ZaT5QX524+ScEUFWX4k5OdvT9+cL5YnRyeH3/1Klj+RxRLPEopyNIvHWW/PTl+9O14uzuZmMU9tmKWIBbCjq5v79X672V6Sj7e7i/X1ntz9j3xe7daXu093d+tdfJbUVMODjHVUM0GkoFYJwgVVzpPdmnycYwC8WwOTPKPec3JDjKNCu2i4Juez00ZfnoOTYVrm/HHaQCj++Uiu4o9DHafGyUCTp2xc8PHtdn8bVzUrUQA5ehPAnfG+tdZsaTdEWEu9ttli51Fb9Ti5iHq1X1/e7jZ14NHjiFwDYqFbwHOcQLdkVDrRhVyAL8tsGfrBdr+6vq4Djw6fBTyHCcCdoI71US4lp1yKMvA37w9e3K/29w3oweXzoGdAb4iCGBeyj3PpNfWQzUXoi6t7AvDryKPHZyHPcQJyZ6npjHNlDPXMV0lvoA7eRtRWUM5cE3WG8YZow6BQqFYp0hoKp1GoFkVLRzHSXFOrK8lxtL26nihVqYajv1QNjYJ/5QOA0lYTqqHxlHv16F8g/5IxjbeLUIdK44+2+/Vu82WH5wgnH+tHaZLmf2VssimF1CvNEBrW8Bc8RTEOTiorEcy4zI0CpaTTNWAWT6nJH8mPFsT+oLSAjVhWmANadcNZ2C0NZJiRaLccDY3dElKLcYniQwMkqwLCEAoaaofWjVCo7G8RXdw3EDwUQiU/b9YXm1XNUf5ctB9NPcXAK7niLcKz56INZOopBmzJUxawtYoffcVKOvWl4EjnhwArrko0lpU/GJXozBUEq/SyEhMtT9lzUVmtx2zKohC00TKNWg3MC1UJW96bVbC9MaFQVo2GRlbBKGsVyirpKJM6zyoFw+Dfr86qiC5GP4KHsqrk5+Dz5vJ2OLfvulIruospMHUXU6u4rt7USp5CAkw9xdQqeXpGakVfMQOmvmJqlXwp15tayVVIgcwVbA8SDiRFV+0szh6McqseuSmTQuhGyzR2Y26VMBrWmVvwXAsbbcqt0VDKrXEaSKvBf5o2GhopKT3VUqOUhCux9cVpGSaUYnWUGSg0D8FEqSk8VdY+PeOdv3vTlZMRX8ydOr4cDpo4BRiTuYRQN2tohghlc0PpDBGa2NA6ez7K6YbH7Plo4pSVeKIssSK46C4HCWXI2jrKHBOamKEMZ9iidrK7kESQsZA0QGaQ0MS6eKnehEyNFpSq+NRc1MBMa1DqaGkIaivMTB/s5WJ58Pro5PD8zWJ5+moxN3c494hY8BrdsA/r/eoabPc36/3txTrviOmhqAJL0sOFAJbW1xLTmsXwZJRzHi314qeH45E3qfgF9x09Ma0e2X7C8snq87bVKxhBjt60odLydq9gurQhyg3MENliS70CRq1kZdg9naXocARuJRWu2bfMYabIb6gU4jzJFC0dOmkB+WhEecUv19df7jp6BcFZihLIO7gg9/QKBhCam6fOj09Plgcny8kN24FEwj0CV37mht1zuU5oowXBfeDFwEFFlN1AmPSdVIYHO+5w2o2WRtoNBc84RChn1AmfXQOGfo+Yq2OHB+8Xx6dny/pmMkWEsgVhxKzzAQt7SkdjO5g+FMV2nYokTuAiWqZkaAlyaVbB1ykWFHVtPRZrtDTEguyWwiexlIcS71kuFoNj9FyWLY7Pl4uzExI2ki7REtbAL8KKRQOvInwS83zRopsoWp2SJFHgJFgyUqJoRXx9oinvqFQMiRYsddGUB1eeIdEc3KA0z0RTDkqA909Fe3/09u15j1II4EgqBoiUgg0C4kN8pVLJTVCqwUPSJRARLVMmglJlfJ1KOU0541ip0dJQCkY5jT6WUxau8FzkStmhTLCZ+9Dy7OjtokuqhDCwihBiqcCX9fJrpYpuolR1IpIwgYlomVIRpSri65QKHuuMwFKNloZUVlDD0WcGSlvqrMylMkNx4E+lgjL45ujk4HWXWAlj4BVhHJwNJAj14E3rmRY5511qRT9RrToXSZtARrRM2Qi3kTJA33vOUNpRIyQWbLQ0BBuuexY18ZVS1MjYVjLBCsP4TDf05Wp7tfrP+m5POrDm0JBydbD5MCRFfWIiPiwzWtA6K7QqDbdhhWkdLQ1alaFcoi6ukpxKr3NaIV2ZnWmEvVnd79e7f652F6Sb1AQ1sFWHmg9DpNYnJgrDIqMFrbJCqhSUK41JHS0NUmGU86gPp7ijXJucVAHDpH1K6vvN/aqfzgQy8FQHmQ9DdNYnJvLC8qIFra9CJ4zyDN/sg6Uxj2lqjMXzRktDBu6p0agjoJiintu8xjMPx72Z026jPZkvAglQX1a+CjQRrQvvCyWE3HTtCxFgFLoBMIODJtaJT/EQmI+WKfVxQymtrNzekkZSp+xMe+vN4tXB2cvF0avF2VxvS8LWoJTt7G3drC9Wuw/rzcV696SxJSEBtHUAxVBvVWdjS0KxYo9yw01CwUE2WOphPIxyHLUsgvuOxpaUw2sWM5eCjsZWADl663wJJlsaLFYPyutssQXUwlNuZBl2V2MrOHwe8AwmhC6zVErfB9w42B9dGXjXe0fR47OQ5zhTtjbiK+RmCrBo6Yiw8AZPccnPeIMn+EshDgVKO9/TlZNCwrV8ppdystmuyKs/Pqwvbq+u1ttJd04NccbLc9VktPUPNBZHc9v6pCEnFlGNVooaekVfovdjfQk1eAgLVG5GS6PcCCDZoR6RhJovNcsOL5LDMDnTDRlehLrcrXd7AgfDG9DgmrQx5xBR2aiDzoehtK1PzIehrGlMDMJFnqIFEVXRhcFhlDGsy2hp6AKjnEZtIOHFwzFiepoR3sCFeqb3sdx9uliT86vf19efV9suMRLSwDJCitKo6NNW3WQPRdJlbuzQ85ZlN1ww1UrA7NFI7jr7SdxAf7Bk/IcjTRmlZp2pOzzZGY5CJFjqISK8hHs86j8NryA7K7LUHT711nqm5zK8Ab7a7olt3j0yWClCGkDzYUnzxsR8WNKvNTGqFbiJFkRORQso/kYIrMVoaWjhGFzkUYNJAPtGylwLC8N44X3SrIxyJXvrKEIdGK+jzochYeoT82FImMbEIEMkKloQUxVh4PAtncTCjJaGMMZSLlEjScAxS/r8bVChLZzoZhpJJ7er38jL37/sther63VXIUVQA80IKi6kJafVTwvzhyLtMjfjQaboxurmQSZ7MpK7zn4SN9AfLVP+wwmoCNKrzlaj0JJypXCEjJZGhMAo51FPTEiQR+c9MaFgmJzpiYUyappvieW4UIDUkebDkOT1ifkwpF9jYlQrkBMtiJ2KGDDKM43FGC0NMRSjRqNemhAalp730oSEVfiZXtrccdR165JAB8LroPNhSJf6xHwY0qUxMagQeYoWRFRFF0g3YwzWZbQ05vHh23a4mxEsDT2FpYqjppzgEm65eVNOcOBDf0VTLlsEUq6+rHwVaCJa10Othl/h3ltE2GjKZXBQhDQAZnDQxAxgOC6XAHa8vpdjQuFYR5ljQhPr4ZGiNsRHtEwDJJ6zi8srtg65Mw8ti6etw+P3R8vl4uzo5HBxRr7/fm6uhV1Kz3QPz9aXm/s9VJjN9nK9Ixvy23r72+31BdlvrsnV6v5+df/H/X598/F2d3+123zcr8h/iXjh8qYilFCqnIMEsI8Ou5qKHLZTP4aroFqKaKmnITeOWoGaisF9R1ORDx9lmZmOT993MSPQ0aMAmZ1t9+emyxua5qAId9mCC8i1odpUoPe9MTc6HIFbiFTVFCqHmTKioVSI/yRVtHRoFd6YK66494254CxFCoSB8l29OT588OZmuljnB68Pz1PSTbtt/OHtiOJc3tVpS7CjBeFGdaToR7SvWyEJlYAjq8dJOFoaSQijvEetNijMVJj8dSwuYZiaabVlLJIX5Pj07VF995niQ1mEED+oMCSMKvuW9U+epg9FMV8nJmkVmImWKTXhllDEZ3nnLYFD/WGcYfFGS0O8oW4Z1I/jXFMm8n4c5zCMzbSDzhbLd2czKVBTLUENBCOoWLWS08Z7JNOHItXqjCSNAiXRMuUkfK+miE/3ijZ8+GA5Fm20NETjQJBAHTLOOOw++RtanBmqzEyHLBPtORmXEAeaEWKsXcl3442t6UORdnViklKBmWiZUhPe2Crj65SOPRKCpBstDenY4wvqUTrnqFb5C1seBomZdtqPp2eL13++PTokE/WOjo8X2ALDyPFPf77tUjQtJJCPFoIULWHqEzR6iYLW6UryBb6CZUpY0LOIrk9O56nwEqk5GupiejgsKNSDs5pKlrfgLFx83UwD6N3y9eL9g15zR4iKYgnrSC7CivQq+e3SK/oIctX5CNpEQoJhykgQqwitTyxYINMKiTUa6mLBIMfwF30F3C+ffM8XrlZqphn2UDF7xEnYRiYRNiROyU/XzhZ9BHHq649aBALSl7UwA/HbogVovZsaPNVxjdQZDY23ozzV1qBZo6GuqZHAJn5DzVEnTKbp8GeY2ExP7ezg5cES/zmliqxpUaMG9UVli0jT0KpQNJQQdqVqhJa+vFeFNkWCX1+vEZ6+8jcynt6RxpTHbxmUVjTf0rDePvzBm6d/KusfL3aru7vb3R52AiYJg4MYVCIm1NxTHJwR2Mwd6PTu7vL3L7vhxShy8P7o8JQ8vmFFTg/J0cnx63evHvfNg3PYTF/uPl3tP3zab4bXLcgv33qh4WIvmP7lO/Lhek0uf19vt7c3H78ApgSHcPeDEOT2ktxvLrdDo3b1mcxhtBDvfOakP/1gm6I7/MxfKIsvkVE7kC3sw22EPfz2cIP/V/FOO3yXZ/ht+BaYmanB5xuAIQf0U4pNddbhGtY8rHpDXr1bvH5N4HgVmGH+h/pl9+//B9aXUjwKZW5kc3RyZWFtCmVuZG9iagoxNSAwIG9iago8PCAvVHlwZSAvRm9udAovU3VidHlwZSAvVHlwZTEKL05hbWUgL0Y0Ci9CYXNlRm9udCAvSGVsdmV0aWNhLU9ibGlxdWUKL0VuY29kaW5nIC9XaW5BbnNpRW5jb2RpbmcKPj4KZW5kb2JqCjE2IDAgb2JqCjw8IC9UeXBlIC9QYWdlCi9NZWRpYUJveCBbMC4wMDAgMC4wMDAgNTk1LjI4MCA4NDEuODkwXQovUGFyZW50IDMgMCBSCi9Db250ZW50cyBbCjE3IDAgUgoxOCAwIFIKXQo+PgplbmRvYmoKMTcgMCBvYmoKPDwgL0ZpbHRlciAvRmxhdGVEZWNvZGUKL0xlbmd0aCAyMzkwID4+CnN0cmVhbQp4nJWby3IbRxJF9/qKWtoRo5p6P7wDgxCCIgx6AEiLsb2gQxSDEkVxOJT9hfMP/hQtJ0Eis1ItdHZhQwmJ7M5b96CAvni8MNoZo/jfh+sXRpunm+3vevHC6qj+Uka9Vr8q9Tv8592BPjjYRx1tUjlVHYxVwWZt4LZ1OpSqHq7U+0OnwqOK1aUa9UkNTnOrNnDYbgT/C+NOtjDiuTU7HYtT23fqn6+8qtqo7Xulfv3h/PLx6vrzw82Pv6vtazXfHtYdIhzuHU10VeeSB7pHBMSkYxIUzO4eL29vJ+YXp70tND9nHcKkbzGCzBSYcVTpcC66Ar1uXPjJ1e3Xe9ItcNsPa9xi1MG6p+kHl8u4JShW/zzccW6z1Wa+XM7X27k6W602y9mCpOwOzzvXw/jxRhI+tIkZx6TvPPJJu2iEMf8w4iQf4LQ7R5K24PUnRY+0feWZ0Ki10FWtY9YGp232qA9dDEmXGL6Xtzl/8+qV+t8vq/lWUjkUBTLxAclkctvHBopmDE8KtoOv0YYpNxodtIMqzA/BfuiqznP795UJ+4PXKXtmP+yZ6sPQfg9tNn7vxnq+ONts1/AgVm9n67l6qWar7Wy5VH+f9/FoutE6ppvzGFPQx4PGEA/ZnuY++kMVZpDAA55fUwmcx74ywcMbHXxgPGzUqcYhD2e0z+kIHuv56ZsNlLugNPHoHxPPoYzJ6INCYwiK7BEhIJOowlwSoNgELzqRQ9lXJqDAi7ytkUEx8LIV0xCKgTafe6D8sj7bdG+RphqNY6o5jbH5fTRoDNGQzWneoztUYfYINIyHK7LEaewrEzSgq8bUaKRStbN5QCNVD5cMpZvGURukSUf3mHSGZFREHxIaQ0hkhxoAtAgr3KNxJLuumjJDghUZSapGw8OAIclR11yGSIrRKdYeJOvZyWy77d0iTPfeOq6b8xhT0MWjjUEeE/aQ++QPVZhBAg+QDa83nMe+MsFjd3WdC+ORnM6+DnkkaHPmCB7HbBImHv1j4jmUMRl9UGgMQZE9agjQJKowlwQoyT9lFgZlX5mAkoJ2vjIooeoIcWEAJQZtixWhbF/PV/PN9vjLLaYd7WPaOZMxFX1MaAwxkS1qBNAjqjCTBCbRPKUYxmRfmWASn/NiY7KLQ8kOmQSja3BHMjlqs7QFoIdsARzMmJQ+MDSGwMg+EQYyiirMKQGM370/YjmYfWUCDHTlxBJ3cl4b54ZgHLSZA6n1MJhjLruYcjSPKedExjT0EaExREQ2qPmPDlGFWSQQga6ceVDHygQRF3R0LKgns3sLaRjUkw06pAO5WSBy1EZp8tFBJp9jGRPSh4XGEBbZpQYBbaIK80nAYmGM5wEeKxNYrNWusAAfK6w/DAN8MtDm5ADPsBx5+dW0o31MO2cypqKPCY0hJrJFRIA8wgo3aZxJrFm7ykM8VmQmsRZtAgvxsXjtzTDEx5J1LXKI/57JMZuFLWDvIV8AAzMqpQtMG4NgJnxqGNAoqjCnBDAlaBN5kMfKBBjoKoYF+ZiNNmkY5GOGMeFAkD4BFLPV6el8qZazBdA5W3ZhaHLRMSaXYxgb3IeBxhAG2ZVmOtpCFeaLgAG6iuUJHisTGLJ9+kChYYhJFzdM8DHBv+ZAeGYYXr2erzvf+mVq0TCmllMYm9tHgcYQBdmU5jm6QhVmi0AhZh0zD+1YmaAQi/aOhfYYvI5lGNpjKHCdJ4f289d/r89WiyOvsJhw9I4J50DGJPQBoTEERPan2Y8GUYU5JAAJQXvPUztWJoCEqE1hqT16o30YpvYI9xovp/YBkKNeM5p6NJCp51TGdPRRoTFERTapMUCXqMJsEqh4SDCVx3asTFCBrhJYbI+79zvtMLZHZ3WucmxvVObnUJqp85/VZrbt3zBtCegiWwJHMyamDw2NITSyUw0EWkUV5pWABrpK4ukdKxNobNFwCcjQGK9LHqZ3eC7XMcrpfRTNUVunrQOtZOvgfMYU9fGhMcRHtqvRQL+owgwT+Jigk+MhHisTfEzUPrMQH6rRyQ9DfKjQZuUQ3/gAmN7t0mSjc0w2wzEqoA8HjSEcsjvNfLQHK9yfcRyhWu0LT/BYkXGE6rT1LMGHnLWvwwS/W5fJcoL/BscxW4Rp39vHtXMmYyq6mLQxyGTCokYAPaIKM0lgkou2gcd3rEwwga5SWXwPKWgbh/E9JGjzcnxfzN7Ozy/gPy/V2/n69Kx3mzDp6B6TzpGMiehDQmMIiexQA4AWUYV5JCCBrmp4esfKBJIUdYosvYdodLXD9B4i3Fvl9P4dkqO2StOPFjL9nMuYkj4uNIa4yDY1CugTVZhRApdodUo8vGNlggt0B8vCe/BZpzwM7yHAuqL8KfzPsw1QeHo/pYtEU4ymMcWcxNjsPhI0hkjIxjTf0RmqMGsEEr7o4Hh+x8oECV+1zSy/Bxc0jByScNBm5U/g2Q45Jjoy5WgeU86JjGnoI0JjiIhsUPMfHaIKs0gg4qK2hWd5rEwQga7qWZYP1mpbh1keHiRwuSdn+SGRo56ymnx0kMnnWMaE9GGhMYRFdqlBQJuownwSsEBXDTzRY2UCi3U6VZbofc26xmGiDwbawoEkvVjPVqdqe7GdLSGNLBddDJpWtEvWOmxjrsoHNg9xlVgZLBPWqJ0P4+u0xpba9z1TX4vOhsd4rMgofK06RBbjfYETumGM9+X5+7IiivV8+2bdw4KJ3Zs8IXbY1lhMHNicx2VS5dt17jK6C8JCc+cXfn2JOmQe2rEi7yWfHTwYeJjEygTAAg8ix8I+RCcdyjDs+/z8PVsR4Gq+3V50AWyLRDLyIodrYgfKqxyen5GfmDg4PztQntgeIGgsVb51FrfvqLWwfe032xcOAtq730Xk3TNBtvjVexu02x/075cPl/f3nx8elTXGK8jCpmpnXDh0FrAgmwNPHBf399cfvj6o958f1Ozt2eJCzdYn87NTdbFQZ6vz5ZvT+VNOnW3g5ezk4cvHxz++PN58/Hh1p377obqYC2yN+NuP6o/bK3X94eru7vOn919BU5OjbPnJOfX5Wv335vruCu67/FMd0rj77MYe2FDbhy/vrtTm44er2z8v7zT7mcSB36bsT+aTztGo6DJs1gp37249/UjiP6O/N4j2+ZYr8BJ7IKVtbkBG2Kn/1uIkHrW4gjXvVn2jTt/Ml0tlEjlj6k9WfKr41/8BXuPiigplbmRzdHJlYW0KZW5kb2JqCjE4IDAgb2JqCjw8IC9GaWx0ZXIgL0ZsYXRlRGVjb2RlCi9MZW5ndGggMjkgPj4Kc3RyZWFtCnic4yrkMtQzVShXMFDwUohWUIgFMlK4AgE2/wSyCmVuZHN0cmVhbQplbmRvYmoKeHJlZgowIDE5CjAwMDAwMDAwMDAgNjU1MzUgZiAKMDAwMDAwMDAwOSAwMDAwMCBuIAowMDAwMDAwMDc0IDAwMDAwIG4gCjAwMDAwMDAxMjAgMDAwMDAgbiAKMDAwMDAwMDMyNyAwMDAwMCBuIAowMDAwMDAwMzU2IDAwMDAwIG4gCjAwMDAwMDA0OTggMDAwMDAgbiAKMDAwMDAwMDYwMSAwMDAwMCBuIAowMDAwMDAyMzM4IDAwMDAwIG4gCjAwMDAwMDI0NDcgMDAwMDAgbiAKMDAwMDAwMjU1NCAwMDAwMCBuIAowMDAwMDAyNjY3IDAwMDAwIG4gCjAwMDAwMDI3NzIgMDAwMDAgbiAKMDAwMDAwNDk3MyAwMDAwMCBuIAowMDAwMDA1MDc4IDAwMDAwIG4gCjAwMDAwMDg4ODggMDAwMDAgbiAKMDAwMDAwOTAwNCAwMDAwMCBuIAowMDAwMDA5MTIwIDAwMDAwIG4gCjAwMDAwMTE1ODQgMDAwMDAgbiAKdHJhaWxlcgo8PAovU2l6ZSAxOQovUm9vdCAxIDAgUgovSW5mbyA1IDAgUgo+PgpzdGFydHhyZWYKMTE2ODUKJSVFT0YK\" }]) { affectedRows items { incomingAccountingDocumentNo attachmentNo fileNo } }  } }"}

Response received:

{"errors":[{"message":"Error: The primary key is in use.","path":["useCompany","incomingAccountingDocumentAttachment_create","values\/0"],"extensions":{"data":{"status":15,"status_name":"valueNotAccepted"}}}],"data":{"useCompany":{"batch_create":{"affectedRows":1,"items":[{"batchNo":70}]},"voucher_create":{"affectedRows":3,"items":[{"batchNo":70,"voucherNo":1,"voucherDate":20240905},{"batchNo":70,"voucherNo":1,"voucherDate":20240905},{"batchNo":70,"voucherNo":2,"voucherDate":20240905}]},"incomingAccountingDocumentAttachment_create":{"affectedRows":1,"items":[{"incomingAccountingDocumentNo":1,"attachmentNo":0,"fileNo":0}]}}},"extensions":{"vbnxt-trace-id":"00000000000000003149118474fb2d56"},"success":true,"code":200}

omelhus · ‎10-09-2024

You are using the wrong endpoint to upload the document for the voucher/batch.

mutation createBatchAndVoucherWithAttachment($batchId: Int = 0) {
  useCompany(no: 5051201) {
    batch_create(
      values: [{voucherSeriesNo: null, valueDate: 20240905, description: "Z-rapport-1-1003"}]
    ) {
      affectedRows
      items {
        batchNo @export(as: "batchId")
      }
    }
    voucher_create(
      values: [{creditAccountNo: 3005, creditTaxCode: null, amountDomestic: 2660, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: "Z-rapport 1003 Salg Varer 25.00% MVA (05.09.2024)"}, {debitAccountNo: 1920, debitTaxCode: null, amountDomestic: 1930, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: "Z-rapport 1003 BankAxept (05.09.2024)"}, {debitAccountNo: 1901, debitTaxCode: null, amountDomestic: 730, batchNo: $batchId, voucherType: 1, voucherNo: null, voucherDate: null, text: "Z-rapport 1003 Til nattsafe (05.09.2024)"}]
    ) {
      affectedRows
      items {
        batchNo
        voucherNo
        voucherDate
      }
    }
    voucher_processings {
      addNewDocument(
        filter: {batchNo: {_eq: $batchId}}
        args: {fileName: "z-report-1003-4.pdf", description: "z-report-1003-4", fileBytes: "JVBERi0xLjMKMSAwIG9iago8PC..."}
      ) {
        succeeded
      }
    }
  }
}

kashyap · ‎19-09-2024

Is this new API available in documentation?

kashyap · ‎18-09-2024

I have applied above given changes and got another errors:

Request Body:

mutation createBatchAndVoucherWithAttachment($batchId: Int = 0) {
  useCompany(no: 12xx679) {
    batch_create(
      values: [
        {
          voucherSeriesNo: null
          valueDate: 20240627
          description: "Z-rapport-1-13000"
        }
      ]
    ) {
      affectedRows
      items {
        batchNo @export(as: "batchId")
      }
    }
    voucher_create(
      values: [
        {
          creditAccountNo: 3021
          creditTaxCode: null
          amountDomestic: 1
          batchNo: $batchId
          voucherType: 1
          voucherNo: null
          voucherDate: null
          text: "Z-rapport 13000 Salg Varer 25.00% MVA (27.06.2024)"
        }
        {
          debitAccountNo: 1900
          debitTaxCode: null
          amountDomestic: 1
          batchNo: $batchId
          voucherType: 1
          voucherNo: null
          voucherDate: null
          text: "Z-rapport 13000 Kassebeholdning endring (27.06.2024)"
        }
      ]
    ) {
      affectedRows
      items {
        batchNo
        voucherNo
        voucherDate
      }
    }
    voucher_processings {
      addNewDocument(
        filter: { batchNo: { _eq: $batchId } }
        args: {
          fileName: "z-report-13000-763.pdf"
          description: "z-report-13000-763.pdf"
          fileBytes: "JVBER9GCg=="
        }
      ) {
        succeeded
      }
    }
  }
}

Error received:

{
  "errors": [
    {
      "message": "Error: Illegal value date 27.06.2024. Check suspension date and the accounting periods and VAT periods tables.",
      "path": [
        "useCompany",
        "batch_create",
        "values/0"
      ],
      "extensions": {
        "data": {
          "status": 15,
          "status_name": "valueNotAccepted"
        }
      }
    },
    {
      "message": "Error: Some non-incremental primary key columns are not entered.",
      "path": [
        "useCompany",
        "voucher_create",
        "values/0"
      ],
      "extensions": {
        "data": {
          "status": 2,
          "status_name": "nonAutomaticallyAssignablePrimaryKeyColumnsNotEntered"
        }
      }
    },
    {
      "message": "Error: Some non-incremental primary key columns are not entered.",
      "path": [
        "useCompany",
        "voucher_create",
        "values/1"
      ],
      "extensions": {
        "data": {
          "status": 2,
          "status_name": "nonAutomaticallyAssignablePrimaryKeyColumnsNotEntered"
        }
      }
    },
    {
      "message": "Error: Failed to execute operation.",
      "path": [
        "useCompany",
        "voucher_processings",
        "addNewDocument"
      ],
      "extensions": {
        "data": {
          "status": 5,
          "status_name": "failedToExecuteOperation"
        }
      }
    }
  ],
  "data": {
    "useCompany": {
      "batch_create": {
        "affectedRows": 1,
        "items": [
          {
            "batchNo": 0
          }
        ]
      },
      "voucher_create": {
        "affectedRows": 2,
        "items": [
          {
            "batchNo": 0,
            "voucherNo": 0,
            "voucherDate": 0
          },
          {
            "batchNo": 0,
            "voucherNo": 0,
            "voucherDate": 0
          }
        ]
      },
      "voucher_processings": {
        "addNewDocument": {
          "succeeded": false
        }
      }
    }
  },
  "extensions": {
    "vbnxt-trace-id": "0000000000000000518559a0d44533c4"
  }
}

Øyvind Årseth · ‎19-09-2024

@kashyap You have to fix the first error, the given value date is in conflict with the current suspension date for the company, prohibiting the batch creation, which is key to the rest of your mutation. Check the current suspension date by running the processing "Move suspension date" in the company information table. Then adjust your suspension date accordingly.

kashyap · ‎19-09-2024

Yes. Using BNXT AI chatbot I am able to resolve the issue. Thanks for quick response.

omelhus · ‎18-09-2024

Yeah, this is probably an issue that the BNXT AI chatbot can help you with, as it's an issue within Business NXT.

Try it out here and follow its recommendation.

Failed to create voucher

Useful pages

About Visma

Contact us

Follow us