Hi, We're not able to fetch open entries from GraphQL due to the following issues:   [ { "Locations": null, "Message": "Error: Failed to execute operation.", "Path": [ "useCompany", "openCustomerEntry", "items", 0, "joinup_Order" ], "Extensions": { "data": { "status": 5, "status_name": "failedToExecuteOperation" } } }, { "Locations": null, "Message": "Error: SQL command no. 3014 failed.", "Path": [ "useCompany", "openCustomerEntry", "items", 0, "joinup_Order" ], "Extensions": { "data": { "status": 2, "status_name": "databaseError" } } } ]   The query: Variables: { "voucherDateAsDate": null, "companyId": *, "nextPageCursor": null } query GetUnpaidInvoices($companyId: Int, $nextPageCursor:String) { useCompany(no: $companyId) { openCustomerEntry(filter: { _and: [ { orderNo: { _not_eq: 0 } } ],}after:$nextPageCursor ) { totalCount pageInfo { hasNextPage hasPreviousPage startCursor endCursor } items { amountInCurrency debitAmountInCurrency creditAmountInCurrency invoiceAmountInCurrency outstandingAmountInCurrency debitOutstandingAmountInCurrency creditOutstandingAmountInCurrency cashAmountInCurrency fixedAmountInCurrency partPaymentInCurrency outstandingCashAmountInCurrency vatAmountInCurrency voucherJournalNo customerNo voucherNo voucherDateAsDate valueDateAsDate voucherType text dueDateAsDate paidLastAsDate orderNo invoiceNo reference crossReference turnover paidStatus generalLedgerAccountNo changedByUser paymentTerms cashDueDateAsDate employeeNo additionalText transactionStatus deliveryAssociateNo paymentMethod externalReference1 externalReference2 paymentNo cid originalDueDate originalDueDateAsDate currencyCorrectionExchangeRate currencyCorrectionAmount currencyCorrectionDateAsDate bankAccount createdByUser autopayPaymentReference originalVoucherNo changedDateTime createdDateTime amountDomestic vatAmountDomestic outstandingAmountDomestic noReminders joinup_Country { isoCode name } joinup_Currency { currencyNo isoCode name } joinup_GeneralLedgerAccount { accountNo name taxCode } joinup_Country { isoCode name } joinup_VoucherType { voucherType defaultText }joinup_Order { customerNo invoiceCustomerNo totalDiscountPercent orderPreferences name addressLine1 addressLine2 addressLine3 addressLine4 postCode postalArea deliveryName deliveryAddress1 deliveryAddress2 deliveryAddress3 deliveryAddress4 deliveryPostCode deliveryPostalArea deliveryTerms deliveryMethod paymentTerms paymentMethod factoringNo sellerOrBuyer roundingDomestic roundingInCurrency joinup_Associate_via_InvoiceCustomer { title companyNo emailAddress phone privatePhone mobilePhone } joinup_PaymentTerms { creditDays creditMonths } joinup_Country { isoCode name } joinup_Country_via_DeliveryCountry { isoCode name } }joinup_Associate_via_Customer { externalId invoiceCustomerNo customerNo factoringCompanyNo name title companyNo emailAddress phone privatePhone mobilePhone addressLine1 addressLine2 addressLine3 addressLine4 postCode postalArea visitPostCode visitPostalArea countryNo deliveryMethodForCustomer deliveryTermsForCustomer paymentTermsForCustomer paymentMethodForCustomer currencyNo generalLedgerAccountNoForCustomer yourReference customerPreferences1 joinup_Country { isoCode name } } } } } }   Do you know what is the root cause?   ... View more

Good morning, Currently we import ledger transactions to Visma business Nxt using Batches (batch_create) along with vouchers (voucher_create). But due to this, a customer needs to post these transactions (drafts) manually in accounting system.   I'm wondering if ledger transactions can be posted automatically via API?         ... View more

Hi, I'm wondering if it is possible to create an order and provided number?    I was trying to do it and I received the following error message:  "A record with the same primary key already exists." despite the fact that the order with provided number doesn't exist.   mutation CreateOrder($companyId: Int) { useCompany(no: $companyId) { order_create( values: [ { orderNo: 99, orderType: 1, name: "Test order", orderDateAsDate: "2024-03-10", customerNo: 99999999, orgUnit2: 125 } ]) { affectedRows items { orderNo name customerNo orderDateAsDate } } } }   Response:   { "errors": [ { "message": "A record with the same primary key already exists.", "path": [ "useCompany", "order_create", "values/0" ], "extensions": { "data": { "status": 3, "status_name": "PrimaryKeyAssignmentFailed" } } } ], "data": { "useCompany": { "order_create": { "affectedRows": 0, "items": null } } }, "extensions": { "vbnxt-trace-id": "00000000000000007438f11cafe2fdb3" } }   ... View more

We're trying to update the customer by using the mutation associate_update, but we're receiving the following error: Error: Not allowed to change if transactions.    Do you know what exactly this error message means? We couldn't find anything in the documentation.   Request: mutation UpdateAssociate($companyId: Int) { useCompany(no: $companyId) { associate_update(filters : [{customerNo : {_eq : 9000}}], values: [ { addressLine1: "", postCode: "", postalArea: "", name: "Test Account", customerNo: 9000 } ]) { affectedRows items { associateNo name shortName customerNo } } } }   ... View more