Financials GraphQL API Changelog

11/07/2025

• Financials GraphQL API now blocks queries and mutations that use inline variables. Variables must be passed as query variables instead of inline in the query body.

Details

Incorrect (blocked) query example:

query{
  debtors{
    masterRecords{
      customers{
        records(filter:{customerDetails:{ code:{beginsWith: "AQ"}}}){
          items{
            customerDetails{
              code
            }
          }
        }
      }
    }
  }
}

Correct query example:

query GetCustomers($filter: CustomerFilterInput) {
  debtors {
    masterRecords {
      customers {
        records(filter: $filter) {
          items {
            customerDetails {
              code
            }
          }
        }
      }
    }
  }
}

Variables:

{
  "filter": {
    "customerDetails": {
      "code": {
        "beginsWith": "AQ"
      }
    }
  }
}

12/02/2025

• Changed all DateFilterInput filters to DateOnlyFilterInput
• Changed many date inputs to DateOnly instead of DateTime

note

DateOnly inputs will still accept DateTime values but will ignore the time/timezone

29/01/2025

• Extended DateFilterInput, DateTimeFilterInput and DateOnlyFilterInput to have new options. The advanced section is now deprecated and may be removed in the future.
• DateTimeFilterInput now supports filters which ignore time using the dateOnlyFilter property
• Modified many DateTimeFilterInput properties to be DateFilterInput

Details

• AgedCreditTransactionHeaderFilterInput
  • approvedDate1
  • approvedDate2
  • approvedDate3
  • matchedDate
• AssetEnquiryTransactionDetailFilterInput
  • date
• BacsExportFilterInput
  • date
• ClosablePurchaseOrdersDetailFilterInput
  • requiredDate
• ConvertiblePurchaseRequestHeaderFilterInput
  • orderDate
  • requiredDate
• CostCentreDetailsFilterInput
  • startDate
  • endDate
• CostingTransactionHeaderFilterInput
  • date
  • userDate1
  • userDate2
• DeliverableSalesOrdersDetailFilterInput
  • requiredDate
  • orderDate
• InvoiceablePurchaseOrdersDetailFilterInput
  • orderDate
  • requiredDate
• InvoiceableSalesOrdersDetailFilterInput
  • requiredDate
  • orderDate
• InvoiceRegisterApprovalStatusHeaderFilterInput
  • date
  • receivedDate
  • userDate1
  • userDate2
  • userDate3
• InvoiceRegisterApprovalStatusDetailFilterInput
  • date
  • receivedDate
• NominalAccountUserDatesFilterInput
  • date1
  • date2
  • date3
• NominalTransactionBatchHeaderFilterInput
  • transactionDate
• NominalTransactionEnquiryDetailFilterInput
  • date
  • userDate1
  • userDate2
  • anticipatedPaymentDate
  • dueDate
• OutstandingCreditNotesDetailFilterInput
  • requiredDate
• OutstandingCreditNotesHeaderFilterInput
  • requiredDate
  • orderDate
  • userDate1
  • userDate2
• OutstandingPurchaseOrderDetailFilterInput
  • requiredDate
• OutstandingPurchaseOrderHeaderFilterInput
  • orderDate
  • requiredDate
  • userDate1
  • userDate2
• OutstandingSalesCreditNotesDetailFilterInput
  • requiredDate
  • userDate1
  • userDate2
• OutstandingSalesCreditNotesHeaderFilterInput
  • requiredDate
  • orderDate
  • userDate1
  • userDate2
• OutstandingSalesOrderDetailFilterInput
  • userDate1
  • userDate2
• OutstandingSalesOrderHeaderFilterInput
  • orderDate
  • requiredDate
  • userDate1
  • userDate2
  • customerUserDate1
  • customerUserDate2
• ProjectCustomFieldsFilterInput
  • date1
  • date2
  • date3
• ProjectDetailsFilterInput
  • startDate
  • endDate
• PurchaseOrderAccrualsDetailFilterInput
  • orderDate
  • requiredDate
  • projectStartDate
  • projectEndDate
  • userDate1
  • userDate2
• PurchaseOrderDeliveryHistoryDetailFilterInput
  • dateRequired
  • date
  • userDate1
  • userDate2
• PurchaseOrderDeliveryHistoryHeaderFilterInput
  • date
  • requiredDate
  • userDate1
  • userDate2
• PurchaseTransactionEnquiryHeaderFilterInput
  • approvedDate1
  • approvedDate2
  • approvedDate3
  • matchedDate
• ReceivablePurchaseOrdersDetailFilterInput
  • orderDate
  • requiredDate
• ReverseBadDebtsWrittenOffEnquiryFilterInput
  • date
• SalesAnalysisFilterInput
  • userDate1
  • userDate2
  • userDate3
• SalesEstimatesHeaderFilterInput
  • orderDate
  • requiredDate
• SalesOrderDeliveryHistoryDetailFilterInput
  • date
  • requiredDate
  • userDate1
  • userDate2
• SalesOrderDeliveryHistoryHeaderFilterInput
  • orderDate
  • requiredDate
  • userDate1
  • userDate2
  • userDate3
• SalesTransactionEnquiryHeaderFilterInput
  • transactionDate
• WriteOffBadDebtsEnquiryHeaderFilterInput
  • transactionUserDate1
  • transactionUserDate2

• Modified a few DateFilterInput properties to be DateTimeFilterInput

Details

• PurchaseOrderSummaryFilterInput
  • completionDate
• TransactionUserKeyFilterInput
  • created
  • lastUpdated
• UserTaskFilterInput
  • created

• Renamed several types

Details

Old	New
AddressDetailsAddressFilterInput	AddressDetailsFilterInput
AddressDetailsInput	MainAddressDetailsInput
Cis	SupplierCis
CisReferences	SupplierCisReferences
CisReferencesFilterInput	SupplierCisReferencesFilterInput
Credit	CustomerCredit
CreditFilterInput	CustomerCreditFilterInput
CreditInput	CustomerCreditInput
Custom	StockCustom
CustomerAdddressSummaryFilterInput	CustomerAddressSummarySectionFilterInput
DirectDebit	CustomerDirectDebit
DirectDebitFilterInput	CustomerDirectDebitFilterInput
DirectDebitInput	CustomerDirectDebitInput
EmailTemplates	CustomerEmailTemplates
EmailTemplatesFilterInput	CustomerEmailTemplatesFilterInput
EmailTemplatesInput	CustomerEmailTemplatesInput
HeadOffice	CustomerHeadOffice
HeadOfficeFilterInput	CustomerHeadOfficeFilterInput
HeadOfficeInput	CustomerHeadOfficeInput
InvoiceRegister	SupplierInvoiceRegister
InvoiceRegisterApprovers	SupplierInvoiceRegisterApprovers
SalesTransactionEnquiryFilterInput	SalesTransactionEnquiryHeaderFilterInput
SalesTransactionEnquirySort	SalesTransactionEnquiryHeaderSort
SalesTransactionEnquirySortGroupByInput	SalesTransactionEnquiryHeaderSortGroupByInput
SalesTransactionEnquirySortSortByInput	SalesTransactionEnquiryHeaderSortSortByInput
Settings	CustomerSettings
SettingsFilterInput	CustomerSettingsFilterInput
SettingsInput	CustomerSettingsInput
StockFilterInput	StockRecordFilterInput
StockSort	StockRecordSort
StockSortGroupByInput	StockRecordSortGroupByInput
StockSortSortByInput	StockRecordSortSortByInput
TermsFilterInput	TermsTemplateFilterInput
TermsSort	TermsTemplateSort
TermsSortGroupByInput	TermsTemplateSortGroupByInput
TermsSortSortByInput	TermsTemplateSortSortByInput
TransactionDefaults	CustomerTransactionDefaults
TransactionDefaultsFilterInput	CustomerTransactionDefaultsFilterInput
TransactionDefaultsInput	CustomerTransactionDefaultsInput
UserCharacters	CustomerUserCharacters
UserCharactersFilterInput	CustomerUserCharactersFilterInput
UserCharactersInput	CustomerUserCharactersInput
UserDates	CustomerUserDates
UserDatesFilterInput	CustomerUserDatesFilterInput
UserDatesInput	CustomerUserDatesInput
UserFlags	CustomerUserFlags
UserFlagsFilterInput	CustomerUserFlagsFilterInput
UserFlagsInput	CustomerUserFlagsInput
UserNumbers	CustomerUserNumbers
UserNumbersFilterInput	CustomerUserNumbersFilterInput
UserNumbersInput	CustomerUserNumbersInput
UserSort	CustomerUserSort
UserSortFilterInput	CustomerUserSortFilterInput
UserSortInput	CustomerUserSortInput

• Changed types on addresses

Details

Location	Type
CustomerDetails.addressDetails	MainAddressDetails
CustomerDetailsFilterInput.addressDetails	MainAddressDetailsFilterInput
SupplierAddress.details	AddressDetails
SupplierDetails.addressDetails	MainAddressDetails

• Renamed property summary on CustomerAddress, CustomerAddressInput, SupplierAddress and SupplierAddressInput to summarySection

27/11/2024

• New field BankStatementDetailTotals under financials\masterRecords\cashBooks that can be used to get an aggregated view of Bank Statement Details.