Accounting API

Ledger Accounts

Tax Rates

Company Info

Invoices

Customers

Bills

Suppliers

Invoice Items

Payments

Credit Notes

Journal Entries

Subsidiaries

BalanceSheet

ProfitAndLoss

Purchase Orders

Locations

Departments

Attachments

Tracking Categories

Bill Payments

Expenses

Aged Creditors

Aged Debtors

Microsoft Dynamics 365 Business Central is an enterprise resource planning (ERP) system focused on mid & large scale businesses.

oauth_credentials

Microsoft Dynamics 365 Business Central

Indicates if accounting by row is used (true) or not (false). Accounting by row means that a separate ledger transaction is created for each row.

Accounting by Row

Balance

The name which you used in opening your bank account.

Bank Account Name

A bank account number is a number that is tied to your bank account. If you have several bank accounts, such as personal, joint, business (and so on), each account will have a different account number.

Bank Account Number

Account Type

A bank code is a code assigned by a central bank, a bank supervisory body or a Bankers Association in a country to all its licensed member banks or financial institutions.

Bank Code

Bank Name

A branch identifier is a unique identifier for a branch of a bank or financial institution.

Branch Identifier

A BSB is a 6 digit numeric code used for identifying the branch of an Australian or New Zealand bank or financial institution.

BSB Number

Indicates the associated currency for an amount of money. Values correspond to [ISO 4217](https://en.wikipedia.org/wiki/ISO_4217).

Currency

The International Bank Account Number (IBAN).

A routing number is a nine-digit code used to identify a financial institution in the United States.

Routing number

Name of the contact person at the address

country code according to ISO 3166-1 alpha-2.

Address field that holds a sublocality, such as a county

Line 1 of the address e.g. number, street, suite, apt #, etc.

Notes

A binary value used to detect updates to a object and prevent data conflicts. It is incremented each time an update is made to the object.

Row version

Salutation of the contact person at the address

The address string. Some APIs don't provide structured address data.

edge-case

The channel through which the transaction is processed.

Channel

The company or subsidiary id the transaction belongs to

CompanyId

The date and time when the object was created.

Created at (timestamp)

Created by

UNKNOWN_CURRENCY

Currency Exchange Rate at the time entity was recorded/generated.

Currency Exchange Rate

medium

When custom mappings are configured on the resource, the result is included here.

Company Name

Display ID

Display Name

Email

The ID of the customer this entity is linked to.

Customer ID

The name of the customer. Deprecated, use display_name instead.

Name

LinkedCustomer

Customer memo

Deposit

Discount Amount

Discount percentage applied to this invoice.

Discount Percent

The third-party API ID of original entity

The invoice due date is the date on which a payment or invoice is scheduled to be received by the seller - YYYY-MM-DD.

Due date

Invoice date

Invoice Sent

language code according to ISO 639-1. For the United States - EN

Code

Account ID

Account Name

Nominal Code

Invoice Line Item

Invoice number

The pass_through property allows passing service-specific, custom data or structured modifications in request body when creating or updating resources.

Payment method used for the transaction, such as cash, credit card, bank transfer, or check

Payment method

A PO Number uniquely identifies a purchase order and is generally defined by the buyer. The buyer will match the PO number in the invoice to the Purchase Order.

Purchase Order number

Invoice reference

URL link to a source document - shown as 'Go to [appName]' in the downstream app. Currently only supported for Xero.

Source document URL

Status

Sub-total amount

Applicable tax id/code override if tax is not supplied on a line item basis.

Tax Code

Tax inclusive

Template

Terms

Total amount

Total tax amount applied to this invoice.

Total tax amount

Linked tracking categories

The unique identifier for the tracking category.

Tracking Category ID

Tracking Category Name

Invoice type

The date and time when the object was last updated.

Updated at (timestamp)

Updated by

Accounting period

Bill date

Bill number

Discount percentage applied to this transaction.

Discount Percentage

The due date is the date on which a payment is scheduled to be received - YYYY-MM-DD.

Bill Line Item

The paid date is the date on which a payment was sent to the supplier - YYYY-MM-DD.

Paid date

Bill reference

The ID of the supplier this entity is linked to.

Supplier ID

LinkedSupplier

The balance reflecting any payments made against the transaction.

Date credit note issued - YYYY:MM::DDThh:mm:ss.sTZD

Datetime

Date credit note paid - YYYY:MM::DDThh:mm:ss.sTZD

Unique identifier representing the entity

Credit Note identifier

Optional note to be associated with the credit note.

Note

Credit note number

Optional reference message ie: Debit remittance detail.

Credit Note reference

Indicates the total credit amount still available to apply towards the payment.

Remaining Credit

Credit Note status

Optional terms to be associated with the credit note.

Credit Note Type

Unique identifier for the account to allocate payment to.

Accounts receivable account id

Type of accounts receivable account

Display id

Transaction note

Transaction number

Optional reference message returned by payment method on processing

Payment method reference

Indicates if the transaction has been reconciled.

Is Reconciled

Optional transaction reference message ie: Debit remittance detail.

Transaction Reference

Payment status

Linked Supplier

Total Amount

The date of the transaction - YYYY:MM::DDThh:mm:ss.sTZD

Transaction Date

Payment Type

Is active

Item code

Description

Item ID

The date of opening balance if inventory item is tracked - YYYY-MM-DD.

Inventory date

Item name

Description of the unit type the item is sold as, ie: kg, hour.

Unit of measure

Unit price

Item is available for purchase transactions

Item purchased

Quantity

Item will be available on sales transactions

Item sold

If true, transactions for this item are taxable

Item taxable

Item tracked

Type

critical

Company name

First name

Is this an individual or business customer

Is individual

Last name

Middle name

The parent customer this entity is linked to.

The parent ID of the customer this entity is linked to.

Microsoft Dynamics 365 Business Central

Supported resources

Details