Business Central

Ledger, sales, purchasing and inventory from Dynamics 365 Business Central, including Wiise. Read-only.

Connects with	OAuth
Reads	34 operations
Writes	None
Irreversible	None
Personal data	Customer, vendor and contact details.
Data stays in	AWS Sydney (ap-southeast-2)

What it reads

• The companies in the environment, and each company’s details (name, address, currency, fiscal year start, ABN).
• The chart of accounts and posted general ledger entries.
• Customers, vendors, contacts and items.
• Sales invoices and their lines, sales orders, quotes and credit memos.
• Purchase invoices and their lines, purchase orders and purchase credit memos.
• Customer and vendor payments, bank accounts, dimensions, currencies, payment terms and methods, tax groups, locations and projects.
• Reports Business Central computes: trial balance, balance sheet, income statement, cash flow statement, retained earnings, aged receivables and aged payables.

One connection reaches every company the connecting user can open.

What it does not read

Human resources and payroll, and any record outside the standard API’s financial set.

What it writes

Nothing. There are no write operations in this connector.

How you connect it

Connect with OAuth. From the Integrations page, choose Connect on Business Central, tick the operations StoriBot may use, and sign in with your Microsoft work account. The person who connects needs the Business Central permission sets for the data the Stori will read; a run that reports a 4xx error on a specific list usually means that permission is missing.

What StoriBot will ask for

Microsoft’s consent screen lists Financials.ReadWrite.All and offline_access. That is the permission Business Central’s API takes; read-only is enforced by StoriBot, not by the scope. Every operation in this connector is a read, each call is sent with Business Central’s read-only data-access intent, and the grant list in StoriBot is what decides what runs.

Every operation

These are the names the Integrations page shows beside each tick box, in the order it lists them. Generated from the connector registry; do not edit by hand.

All 34 operations

Operation	Kind	What it does
list_companies	Read	List the companies in the environment: id, name and displayName.
get_company_information	Read	Retrieve the company’s own details: displayName, address, currencyCode, currentFiscalYearStartDate, industry and taxRegistrationNumber (the ABN for an Austra…
list_accounts	Read	List the chart of accounts: number, displayName, category (Assets, Liabilities, Equity, Income, Cost of Goods Sold, Expense), subCategory, accountType and wh…
list_general_ledger_entries	Read	List posted general ledger entries: entryNumber, postingDate, documentNumber, documentType, accountId, accountNumber, description, debitAmount and creditAmount.
list_customers	Read	List customers: number, displayName, type, address, email, phoneNumber, salespersonCode, balanceDue, creditLimit, currencyCode, paymentTermsId, taxRegistrati…
list_vendors	Read	List vendors (suppliers): number, displayName, address, email, phoneNumber, balance, currencyCode, paymentTermsId, taxRegistrationNumber and blocked.
list_contacts	Read	List contacts, the people and companies in the relationship management area: number, displayName, type, companyName, jobTitle, email, phoneNumber and address.
list_items	Read	List items (products and services): number, displayName, type (Inventory, Service, Non-Inventory), itemCategoryCode, unitPrice, unitCost, inventory on hand…
list_sales_invoices	Read	List sales invoices: number, invoiceDate, dueDate, customerId, customerName, status (Draft, Open, Paid, Canceled, Corrective), currencyCode, totalAmountExclu…
list_sales_invoice_lines	Read	List the lines of one sales invoice: lineType, itemId, accountId, description, quantity, unitPrice, discountPercent, amountExcludingTax, taxCode and amountIn…
list_sales_orders	Read	List sales orders: number, orderDate, customerId, customerName, status, currencyCode, totalAmountIncludingTax, fullyShipped and requestedDeliveryDate.
list_sales_quotes	Read	List sales quotes: number, documentDate, validUntilDate, customerId, customerName, status, currencyCode and totalAmountIncludingTax.
list_sales_credit_memos	Read	List sales credit memos: number, creditMemoDate, customerId, customerName, status, currencyCode, totalAmountIncludingTax and remainingAmount.
list_purchase_invoices	Read	List purchase invoices (bills): number, invoiceDate, dueDate, vendorId, vendorName, vendorInvoiceNumber, status, currencyCode, totalAmountExcludingTax, total…
list_purchase_invoice_lines	Read	List the lines of one purchase invoice: lineType, itemId, accountId, description, quantity, directUnitCost, amountExcludingTax, taxCode and amountIncludingTax.
list_purchase_orders	Read	List purchase orders: number, orderDate, vendorId, vendorName, status, currencyCode, totalAmountIncludingTax, fullyReceived and requestedReceiptDate.
list_purchase_credit_memos	Read	List purchase credit memos: number, creditMemoDate, vendorId, vendorName, status, currencyCode and totalAmountIncludingTax.
list_customer_payments	Read	List customer payments in the default customer payment journal: postingDate, customerId, customerNumber, amount, appliesToInvoiceNumber, description and whet…
list_vendor_payments	Read	List vendor payments in the default payment journal: postingDate, vendorId, vendorNumber, amount, appliesToInvoiceNumber and description.
list_bank_accounts	Read	List bank accounts: number, displayName, bankAccountNumber, currencyCode, iban and blocked.
list_dimensions	Read	List dimensions, the analysis tags (department, project, region) that entries carry: code, displayName and id.
list_currencies	Read	List currencies: code, displayName, symbol and rounding.
list_payment_terms	Read	List payment terms: code, displayName, dueDateCalculation, discountDateCalculation and discountPercent.
list_payment_methods	Read	List payment methods: code and displayName.
list_tax_groups	Read	List tax groups, the GST or VAT product groupings: code, displayName and taxType.
list_locations	Read	List inventory locations: code, displayName, address and contact.
list_projects	Read	List projects (jobs): number and displayName.
report_trial_balance	Read	Retrieve the trial balance for a period: one row per G/L account with number, display, accountType, totalDebit and totalCredit for the period, and balanceAtD…
report_balance_sheet	Read	Retrieve the balance sheet as at a date: lineNumber, display, balance, lineType (header, detail, total) and indentation, in statement order.
report_income_statement	Read	Retrieve the income statement (profit and loss) for a period: lineNumber, display, netChange, lineType and indentation, in statement order.
report_cash_flow_statement	Read	Retrieve the cash flow statement for a period: lineNumber, display, netChange, lineType and indentation.
report_retained_earnings	Read	Retrieve the retained earnings statement for a period: lineNumber, display, netChange, lineType and indentation.
report_aged_receivables	Read	Retrieve aged accounts receivable as at a date: one row per customer with balanceDue, currentAmount and period1Amount to period3Amount with their labels, plu…
report_aged_payables	Read	Retrieve aged accounts payable as at a date: one row per vendor with balanceDue, currentAmount and period1Amount to period3Amount with their labels, plus a t…