My Products
Help
kashyap
PARTNER

Failed to create voucher

by kashyap

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?

4 REPLIES 4
kashyap
PARTNER

by kashyap

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

"The primary key is in use."

omelhus
PARTNER

by omelhus

Can you post the entire query?

kashyap
PARTNER

by kashyap

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
PARTNER

by omelhus

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
      }
    }
  }
}