I want to second this NB. The order of fields assignment is important in BNXT. This is way putting the suggested fields at the end may lead to incorrect results. For this reason we made that feature obsolete a while ago (should be removed actually from our API). Use null as a value to indicate suggest.
voucher_create(
values: [
{
batchNo: $batchno,
voucherNo: null,
amountDomestic: 14296.19,
debitAccountNo: 7519,
valueDate: 20240602,
voucherDate: 20240601,
voucherType: 50
},
{
batchNo: $batchno,
voucherNo : null,
amountDomestic: 14296.19,
creditAccountNo: 2920,
valueDate: 20240602,
voucherDate: 20240601,
voucherType: 50
}]
) {
affectedRows
}
Note that I'm not saying this is the cause of your problem, but it can be the cause of problems in other cases.
... View more