Itgeneor626: No division to study accountant information on

Vragen
,
1

Bij het uitvoeren van de volgende code:

using Invantive.Data;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace TestInvantive
{
    internal class Program
    {
        static void Main(string[] args)
        {
            var providerFactory = new InvantiveClientFactory();

            using (var connection = providerFactory.CreateConnection())
            {
                const string EOL_USER = "john.doe@acme.com";
                const string EOL_PASSWORD = "secret";

                try
                {
                    connection.ConnectionString = $"provider=ExactOnlineAll;api-url=https://start.exactonline.nl;User ID={EOL_USER};Password={{{EOL_PASSWORD}}}"; 
                    connection.Open();
                    using (IDbCommand command = connection.CreateCommand())
                    {
                        command.CommandText = "select * from systemtables@datadictionary";
                        var rdr = command.ExecuteReader();
                        while (rdr.Read())
                        {
                            for (int i = 0; i < rdr.FieldCount; i++)
                            {

                            }
                            string name = rdr["name"].ToString();
                            Console.WriteLine(name);
                        }

                        connection.Close();
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }

                Console.ReadLine();
            }
        }
    }
}

treedt de foutmelding op:

itgeneor626
No division to study accountant information on.

met call stack:

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Invantive.Data.InvantiveException.HandleAndThrowError(InvantiveTraceLevel level, InvantiveTraceTag tag, Exception exception, String callerMemberName)
   at Invantive.Data.InvantiveConnection.ThrowDbException(GlobalState owner, ExecutionOptions executionOptions, Exception ex)
   at Invantive.Data.InvantiveConnection.Open()
   at TestInvantive.Program.Main(String[] args) in C:\tmp\TestInvantive\Program.cs:line 44
2

Het betreft een recent aangemaakt Exact Online App Developer account.

De AvailableFeatures zijn:

Lijst features
ID Omschrijving
1 Base
2 Account
3 Assets
4 Reminders
5 MultiCurrency
6 Banking
7 Budget
8 CostAnalysis
9 DropShipment
10 SalesInvoice
11 Payroll
13 BillOfMaterial
14 Users
16 Collection
17 MultiAdminManagement
18 IntraStat
19 Project
20 VAT
21 AccountantAccess
23 MultiLanguage
24 XBRL
27 EUSalesList
28 AddressWebServices
29 SEPA
31 Mailbox
32 Manufacturing
33 SalesForce
34 Quotation
36 Marketing
38 SalesOrder
39 ControlAndUpdateRelations
41 PurchaseInvoice
42 PurchaseOrder
43 Inventory
45 CreditInvoice
47 Subscription
48 MultiWarehouse
49 PurchaseReturn
51 AccountPro
52 GeneralPro
54 AccountOverviews
55 HRM
59 BackToBackOrder
60 PriceManagement
62 PartnerSales
63 PartnerSupport
65 VATPercentage
100 WBS
101 PSA
321 LinkedInIntegration
1.000 OAuth
1.001 Currency
1.003 MadCapHelp
1.009 TOTP
1.010 FreeFields
1.017 ElasticSearch
1.018 ElasticSearchIndexing
1.023 SmartMaxPageSize
1.031 ElasticSearchLimitResults
1.201 SalesOrderExplosion
1.800 AssemblyOrder
1.901 Transsmart
2.000 ProjectInvoiceSpecification
2.001 Backflush
2.002 DimensionalCalculators
2.003 TwitterIntegration
2.004 CRMReports
2.005 CRMMain
2.006 MailChimpIntegration
2.008 WordMerge
2.009 AccountMailMerge
2.011 AccountClassifications
2.012 DocumentStorage
2.013 TwitterAdvanced
2.014 CRMAdvanced
2.015 QuotationEmail
2.019 GdprAccountContact
2.024 MergeAccounts
2.025 QuotationPrint
3.400 QuotationProject
4.000 Schedule
4.001 NationalHolidays
4.003 RedirectF1ToSalesforceCommunity
4.005 LeaveBuildUp
4.006 CostAnalysisEndDate
4.007 GdprEmployeeUser
4.008 GdprUser
4.010 CompanyEmailValidation
4.011 CompanyEmailAddresses
4.016 CompanyCars
7.002 SalesMenu
7.004 SalesMargin
7.006 PurchaseMenu
7.008 InventoryMenu
7.009 QuantityPrecisionHigh
7.010 Barcode
7.011 SalesFinancialInsight
7.012 SelectionCode
7.013 SalesChannel
7.016 SalesCharges
7.020 SalesInvoiceDeliveryInfo
7.050 SalesPriceListMethodNewPrice
7.080 InventoryValuationMethodAverageCost
7.081 GLStockRevaluation
7.082 GLStockRevaluationConsistencyCheck
7.083 GLStockRevaluationImportCheck
7.100 SalesQuotationApproval
7.101 SalesQuotationDiscount
7.201 PickingList
7.202 SalesOrderDiscount
7.204 SalesOrderPaymentReference
7.205 MultipleGoodsDeliveries
7.206 SalesOrderEmail
7.207 SalesOrderDeliveryDebtor
7.210 PickingListLayouts
7.211 ClusterPickingListLayouts
7.212 DeliveryAdvice
7.213 TranssmartV2
7.214 DigitalOrderPicking
7.215 DeliverMoreThanOrdered
7.300 DirectSalesInvoice
7.302 SalesInvoiceDiscount
7.303 SalesInvoiceVariableGLAccount
7.304 SalesInvoiceCompressionOnLayout
7.305 SalesInvoicePrint
7.306 SalesInvoiceEMail
7.307 SalesInvoiceDigitalPostBox
7.308 SalesInvoiceBasedOnAccount
7.309 SalesInvoiceDocument
7.310 SalesInvoiceCollaboration
7.311 SalesInvoiceSimplerInvoicing
7.312 SalesInvoiceShippingMethod
7.313 SalesInvoicePaymentReference
7.315 SalesInvoicePEPPOL
7.317 SalesInvoiceSimplerInvoicingV11
7.319 SalesPaymentLink
7.320 SalesAllowNegativeQuantity
7.321 SalesInvoiceSimplerInvoicingV12
7.322 SalesInvoiceBISV3
7.323 SalesInvoiceSimplerInvoicingV20
7.324 SalesInvoiceDigitalPostBoxPreCheck
7.400 PurchasePriceLists
7.601 ReceiveMoreThanOrdered
7.603 PurchaseOrderEmail
7.607 PurchaseOrderMerge
7.660 PurchaseAnalysis
7.700 DirectPurchaseInvoice
7.701 PurchaseInvoiceGatewayList
7.702 PurchaseInvoiceV2
7.800 ItemCard
7.801 ItemHarmonizedSystem
7.802 ItemTransportData
7.803 ItemFreeFields
7.804 ItemReorderPolicy
7.805 ItemCharge
7.806 WarehouseTransfer
7.808 Incoterms
7.810 StorageLocation
7.811 SingleStorageLocationPerItem
7.812 MultipleStoragelocationsPerItem
7.813 MultipleStoragelocationsSplitting
7.820 SerialNumbers
7.821 BatchNumbers
7.822 SerialNumbersMandatory
7.830 StockCount
7.831 StockCountList
7.860 StockAgingAnalysis
7.861 ProjectedStock
7.862 MRPAdvice
7.863 MRPCalculation
7.864 MRPOrderGeneration
7.865 MRPSalesForecast
7.866 NegativeStockCheck
7.880 BillOfMaterialWhereUsed
7.900 LayoutAllowsNegativeDiscount
7.901 LayoutUseTemplates
7.910 WholesaleTemplateData
8.001 SepaDirectDebit
8.018 PaymentServices
8.019 MergeDuplicateBankAccounts
8.022 BankAccountSetup
8.024 GAccount
8.027 BankAccountCategory
8.029 AllocateMatchService
8.031 OINNumber
8.032 GAccountSales
8.033 CreditTransferInBatch
8.038 SmartMatching
8.039 DirectDebitOwnAccount
8.041 AllocateMatchInfo
8.042 CloudCommunitySuggestionProvider
8.043 AutomaticImportStatements
8.044 SmartMatchingWriteOff
8.046 GLNnumber
8.048 BgwIngSftp
8.049 BgwKnabSftp
8.050 SmartPartialMatching
8.051 StatementsToBeCompletedCounter
8.052 StatementsToBeCompletedShowCounter
8.053 BgwBunqConsent
8.055 BankimportSuggestMultipleLines
8.057 BgwRabobankConsent
8.060 BgwNonPsd2
8.061 BgwPsd2
8.064 MollieSettlements
8.065 BankImportAllocateOwnBankaccounts
8.066 BankImportInsights
8.067 BankImportInsightsShow
8.068 BankImportAllocateTopSuggestion
8.069 PaymentLink
8.070 RabobankBankLinkMigrateToPSD2
9.004 CostAnalysisPlus
9.005 AuditTrail
9.007 FinReversalEntry
9.008 FinInvoiceEntry
9.009 MultiGLSchemes
9.010 DeferredCostRevenue
9.020 Accounting
9.023 EmployeeCostRegulation
9.026 NLReferenceGLAccountScheme
9.043 OnboardingChecklist
9.065 GLAccountSuggestions
9.069 RemindersEmail
9.071 FindAndCorrect
9.079 BankImportAutomationLevel
9.083 NLReferenceGLAccountSchemeV3
9.088 AutomaticallyMatchPurchaseEntries
9.089 OEPScanningService
9.092 RgsMappingPrediction
9.093 IntercompanyAccounting
9.094 NLReferenceGLAccountSchemeV31
9.095 PurchaseEntryApprovalEnhanced
9.098 RgsBasedWidgets
9.099 DeferredCostRevenueReport
9.100 PurchaseEntryApprovalEnhancedV2
9.101 DeferredPerDaySalesPurchaseEntry
9.103 SalesInvoicesDaysToCash
9.104 GLAccountFlipSideClassification
9.106 IntercompanyPurchase
9.107 PurchaseEntryApprovalEnhancedV3
9.108 NLReferenceGLAccountSchemeV32
9.118 FinancialDashboardEnhanced
9.126 NewFinancialYearAutoGeneration
9.131 PurchaseEntryApprovalPurchaseAgentAndProject
9.134 RecurringEntriesAutomation
9.135 YearEndClosing
9.137 InvoiceDocumentPreview
9.138 FinCopyEntry
9.140 AssetsDepreciationAutomation
9.141 FinGLAccountNavigation
9.145 PurchaseEntryApprovalNotificationEmail
9.148 BankTransactionShowInvoiceDetails
9.149 ActivityFeeds
9.150 NLReferenceGLAccountSchemeV35
10.001 Items
10.002 Quantity
10.003 Employees
10.004 CRM
10.005 Warehouse
10.006 PricePrecision
10.007 AcceptQuotationProject
10.008 CRMDivisionManagement
10.013 Evergage
10.014 EarlyAccess
10.016 EvergageInteractionStudio
20.000 DocumentOverview
20.002 LayoutEmailSubject
20.003 LayoutDefaultAttachment
20.005 LayoutMergePDF
20.006 DocumentDownload
21.000 Prepaid
21.001 RebillableExpense
21.003 ProjectBillingMilestones
21.004 ProjectMargin
21.006 ProjectPurchaseControl
21.007 LeaveEntry
21.008 ProjectAdditionalInvoicing
21.009 PSADemoTemplate
21.010 Timesheet
21.011 PSP
21.014 ProjectPlanning
21.015 ProjectLayoutLink
21.016 ProjectLeaveAbsence
21.018 RecurringPlanning
21.019 ProjectBasic
21.021 ProjectDashboard
21.022 CommunicatePlanning
21.024 ProjectInvoiceAsQuoted
21.025 EditMyPlanning
21.026 ProjectEntryCorrection
21.029 ProjectInvoiceProposalReasons
21.031 WBSOnInvoice
21.032 SummarizeInvoiceLines
21.033 ProjectPreventBudgetOverrun
21.034 FeeHandling
21.037 ProjectAdjustAccount
21.038 ProjectHourTypeRestriction
21.039 ProjectInvoiceAI
21.040 PSACostCenter
21.041 PSAEmployeeCostCenter
21.043 WBSInvoicing
21.044 ProjectMembers
21.045 ProjectMemberUI
21.046 ProjectCardLazyLoad
21.047 CollaborationNewUI
21.048 QuoteOnlineAccept
21.049 QuotePartialAccept
21.050 CollaborationEDS
22.002 CreateAssetFromChecklist
22.004 AssetDepreciationWOZ
31.001 TransferDivision
31.002 TransferDivisionAutomation
31.003 ConfigureUpgrade
31.005 MyInvoices
31.010 GdprOptIn
31.013 MyInvoiceOverview
38.008 VatSystemCash
38.016 VATReturnCorrection
38.019 CollectivePKICertificate
38.025 VATNumberZZP
38.028 OneStopShop
39.001 Docs2EOL
39.006 QuarantinedEmail
40.006 EmployeeSelfService
40.008 PayrollProcessManagement
40.009 ESSDashboardV2
40.010 InviteESSWizard
40.011 PayrollSignalMonitoring
40.013 WageScales
40.014 PayrollSlip
40.016 PayrollSendAPGDeclarations
40.017 PayrollMinimumWage
42.004 SalesReturnPlanning
46.004 ManufacturingSubOrders
46.005 ManufacturingCostRollUp
46.007 BillOfMaterialsMultipleActive
46.008 BillOfMaterialsIndentedBOM
46.009 ManufacturingByProducts
46.010 ManufacturingDataCollectionTime
46.012 ManufacturingStockReceiptV2
46.013 ManufacturingDataCollectionItemTransactions
46.014 ItemNetWeightUnit
46.015 ManufacturingSSFTimeEntry
46.016 ManufacturingSSFSharedTimeEntry
46.017 ManufacturingShopOrderScheduling
46.018 ManufacturingShopOrderPriorityList
46.020 LayoutBarcodeFonts
46.023 Layout2dBarcodeFonts
46.024 ManufacturingShopManagerConsole
46.025 ManufacturingPriorityLogic
46.026 BillOfMaterialsWastePercentage
46.027 SalesCustomerItemCode
46.028 BillOfMaterialsIndentedPhantomBOM
50.000 AppCenterPartner
53.001 NewCompanySetupWizard
53.002 SubscriptionTemplate
53.003 SubscriptionMRR
53.004 NewBuyWizard
53.005 SubscriptionCancellationReason
53.006 SubscriptionTimeCostEntry
53.007 SubscriptionOneTimeFee
53.008 SubscriptionAddOn
53.010 SubscriptionMidtermChanges
53.011 OnboardingCompanySetupWizard
53.014 SubscriptionWeeklyInvoicing
57.000 Collaboration
57.001 CollaborationStatusOverview
57.002 CollaborateTimesheet
62.000 AccountCompanyLink
62.002 AccountantClientInformation
62.003 DocumentManagement
62.004 MyCustomers
62.006 DivisionRights
62.008 InvitationCompanyLink
62.009 AccountancyPracticeManagement
62.018 NewAccountantsCenter
62.022 PurchaseEntryApprovalForPayment
62.025 InvoiceProcessingSend
62.028 InvoiceGatewayWizard
62.034 AccountancyImportDeclarationFiles
62.035 PEPPOLSendOnly
62.039 Benchmarking
62.041 PEPPOLSendInBatch
63.000 MyApps
63.002 RealTimeBanking
63.004 AppConnectivity
65.000 DashboardV2
65.001 AccountantsDashboardV2
65.003 DashboardAPI
65.004 SalesDashboardV2
65.005 PurchaseDashboardV2
65.006 InventoryDashboardV2
65.008 ManufacturingDashboardV2
65.009 PayrollDashboardV2
66.001 GettingStarted
66.002 GettingStartedPackageEfficiency
70.000 AccountancyBeyond
76.000 Notes
76.002 NotesSalesEntry
3

Dit is met Invantive Bridge 22.0.690 met een App Center account op Exact Online. Met Query Tool 22.0.296 lukt het WEL om aan te melden met deze credentials. Met Query Tool 22.0.690 lukt het ook niet.

4

Dank.

Een controle op de eigenschappen van een Accountancy-abonnement van Exact Online geeft onterecht deze melding itgeneor626. Blijkbaar bevatten de App Developer-abonnementen tegenwoordig meer functionaliteit voor Accountancy.

Een aantal verbeteringen zijn doorgevoerd vanaf release 22.0.691. Deze zal naar verwachting einde van deze week beschikbaar komen via https://releasenotes.invantive.com.

Voor een duidelijkere systeemfoutmelding zal de tekst van itgeneor626 gewijzigd worden in:

The subscription is an accountancy subscription, but no division was found to retreive accountant information from.

De lijst van features van een recent gestart accountancy-abonnement zijn:

Lijst features
ID Omschrijving
1 Base
2 Account
3 Assets
4 Reminders
5 MultiCurrency
6 Banking
7 Budget
8 CostAnalysis
10 SalesInvoice
14 Users
16 Collection
17 MultiAdminManagement
20 VAT
21 AccountantAccess
23 MultiLanguage
24 XBRL
26 Accountant
27 EUSalesList
28 AddressWebServices
29 SEPA
31 Mailbox
33 SalesForce
34 Quotation
36 Marketing
39 ControlAndUpdateRelations
45 CreditInvoice
51 AccountPro
52 GeneralPro
54 AccountOverviews
61 AccountTemplateEntries
65 VATPercentage
67 AccountancyManagement
68 AccountancyCenter
70 AccountancyDashboard
71 AccountancyEndorsement
102 ContinuousMonitoring
321 LinkedInIntegration
1.000 OAuth
1.001 Currency
1.003 MadCapHelp
1.009 TOTP
1.017 ElasticSearch
1.018 ElasticSearchIndexing
1.023 SmartMaxPageSize
1.030 AzureB2CLogin
1.031 ElasticSearchLimitResults
2.003 TwitterIntegration
2.005 CRMMain
2.006 MailChimpIntegration
2.008 WordMerge
2.009 AccountMailMerge
2.011 AccountClassifications
2.012 DocumentStorage
2.015 QuotationEmail
2.019 GdprAccountContact
2.024 MergeAccounts
2.025 QuotationPrint
4.003 RedirectF1ToSalesforceCommunity
4.006 CostAnalysisEndDate
4.007 GdprEmployeeUser
4.009 DigitalEfficiencyBundle
4.010 CompanyEmailValidation
4.011 CompanyEmailAddresses
7.004 SalesMargin
7.009 QuantityPrecisionHigh
7.101 SalesQuotationDiscount
7.302 SalesInvoiceDiscount
7.303 SalesInvoiceVariableGLAccount
7.305 SalesInvoicePrint
7.306 SalesInvoiceEMail
7.307 SalesInvoiceDigitalPostBox
7.308 SalesInvoiceBasedOnAccount
7.309 SalesInvoiceDocument
7.310 SalesInvoiceCollaboration
7.311 SalesInvoiceSimplerInvoicing
7.313 SalesInvoicePaymentReference
7.317 SalesInvoiceSimplerInvoicingV11
7.319 SalesPaymentLink
7.321 SalesInvoiceSimplerInvoicingV12
7.322 SalesInvoiceBISV3
7.323 SalesInvoiceSimplerInvoicingV20
7.324 SalesInvoiceDigitalPostBoxPreCheck
7.325 SalesInvoiceNotificationEmail
7.701 PurchaseInvoiceGatewayList
7.900 LayoutAllowsNegativeDiscount
7.901 LayoutUseTemplates
8.001 SepaDirectDebit
8.004 INGBankLink
8.018 PaymentServices
8.019 MergeDuplicateBankAccounts
8.023 INGBankPayments
8.024 GAccount
8.027 BankAccountCategory
8.029 AllocateMatchService
8.031 OINNumber
8.032 GAccountSales
8.033 CreditTransferInBatch
8.039 DirectDebitOwnAccount
8.041 AllocateMatchInfo
8.042 CloudCommunitySuggestionProvider
8.043 AutomaticImportStatements
8.044 SmartMatchingWriteOff
8.046 GLNnumber
8.049 BgwKnabSftp
8.050 SmartPartialMatching
8.051 StatementsToBeCompletedCounter
8.052 StatementsToBeCompletedShowCounter
8.053 BgwBunqConsent
8.055 BankimportSuggestMultipleLines
8.057 BgwRabobankConsent
8.060 BgwNonPsd2
8.061 BgwPsd2
8.064 MollieSettlements
8.065 BankImportAllocateOwnBankaccounts
8.069 PaymentLink
8.070 RabobankBankLinkMigrateToPSD2
9.004 CostAnalysisPlus
9.005 AuditTrail
9.007 FinReversalEntry
9.008 FinInvoiceEntry
9.009 MultiGLSchemes
9.010 DeferredCostRevenue
9.013 ExactOnlineStarterPayments
9.023 EmployeeCostRegulation
9.026 NLReferenceGLAccountScheme
9.065 GLAccountSuggestions
9.069 RemindersEmail
9.070 GLAccountSuggestionsScanAndRecognize
9.071 FindAndCorrect
9.079 BankImportAutomationLevel
9.083 NLReferenceGLAccountSchemeV3
9.090 ProposedEntriesCounter
9.092 RgsMappingPrediction
9.094 NLReferenceGLAccountSchemeV31
9.095 PurchaseEntryApprovalEnhanced
9.098 RgsBasedWidgets
9.099 DeferredCostRevenueReport
9.101 DeferredPerDaySalesPurchaseEntry
9.103 SalesInvoicesDaysToCash
9.104 GLAccountFlipSideClassification
9.108 NLReferenceGLAccountSchemeV32
9.118 FinancialDashboardEnhanced
9.126 NewFinancialYearAutoGeneration
9.132 ProposedEntriesGenericAccount
9.135 YearEndClosing
9.137 InvoiceDocumentPreview
9.138 FinCopyEntry
9.141 FinGLAccountNavigation
9.148 BankTransactionShowInvoiceDetails
9.149 ActivityFeeds
9.150 NLReferenceGLAccountSchemeV35
10.001 Items
10.002 Quantity
10.004 CRM
10.006 PricePrecision
10.007 AcceptQuotationProject
10.008 CRMDivisionManagement
10.013 Evergage
10.014 EarlyAccess
10.016 EvergageInteractionStudio
20.002 LayoutEmailSubject
20.003 LayoutDefaultAttachment
20.005 LayoutMergePDF
20.006 DocumentDownload
22.002 CreateAssetFromChecklist
22.004 AssetDepreciationWOZ
31.001 TransferDivision
31.002 TransferDivisionAutomation
31.003 ConfigureUpgrade
31.005 MyInvoices
31.007 SimpleInvoice
31.010 GdprOptIn
31.013 MyInvoiceOverview
38.008 VatSystemCash
38.016 VATReturnCorrection
38.019 CollectivePKICertificate
38.025 VATNumberZZP
38.028 OneStopShop
39.001 Docs2EOL
39.006 QuarantinedEmail
40.010 InviteESSWizard
53.001 NewCompanySetupWizard
53.004 NewBuyWizard
53.012 RefreshMyAccountData
57.000 Collaboration
62.001 AccountancyProcesses
62.002 AccountantClientInformation
62.006 DivisionRights
62.007 AccountancyPreRelease
62.018 NewAccountantsCenter
62.021 AccountancyDashboardTemplates
62.022 PurchaseEntryApprovalForPayment
62.023 InviteClientWizard
62.033 AccountancyCompanyType
62.039 Benchmarking
62.043 GLSchemeMonitoring
62.044 EfficiencyMonitoring
62.058 InviteClientLite
62.064 ClientPortalPSD2
62.066 ConfigurationMonitor
62.080 InviteClientExistingSubscription
63.000 MyApps
63.002 RealTimeBanking
63.004 AppConnectivity
65.000 DashboardV2
65.003 DashboardAPI
66.001 GettingStarted
66.002 GettingStartedPackageEfficiency
76.000 Notes
76.002 NotesSalesEntry
5

Deze vraag is automatisch gesloten na 2 weken inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.

6

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.