Skip to main content

General Ledger Accounts

Entity›Datastore›Datastore.GeneralLedgerAccount

General ledger accounts link products to your accounting system for financial reporting.

Use the Datastore_GeneralLedgerAccount endpoint to query general ledger accounts.

Endpoints​

List General Ledger Accounts​

GET/v1/odata/Datastore_GeneralLedgerAccount

Single General Ledger Account​

GET/v1/odata/Datastore_GeneralLedgerAccount({id})

Fields​

Datastore Fields (inherited)​

FieldTypeDescription
NameStringDisplay name
CodeStringUnique code identifier
LocalizedNameStringLocalized display name
IsDefaultBooleanWhether this is the default value

Relationships​

RelationshipTarget EntityCardinalityDescription
ProductProduct1:NProduct

Expanding Relationships​

GET/v1/odata/Datastore_GeneralLedgerAccount({id})?$expand=Product
GET/v1/odata/Datastore_GeneralLedgerAccount({id})/Product

Filtering Examples​

GET/v1/odata/Datastore_GeneralLedgerAccount?$filter=Name eq '{Name}'&$top={top}
GET/v1/odata/Datastore_GeneralLedgerAccount?$filter=contains(Name, '{Name}')&$top={top}
GET/v1/odata/Datastore_GeneralLedgerAccount?$filter=Code eq '{Code}'&$top={top}
GET/v1/odata/Datastore_GeneralLedgerAccount?$filter=IsDefault eq {IsDefault}&$top={top}

Custom Query​

Build your own OData query against Datastore_GeneralLedgerAccount. Open Run and edit the whole request inline — swap the entity set, change the $filter, or add $expand, $select, $orderby, $top, $skip. Type $ for suggestions; use ↺ Reset to restore this example.

GET/v1/odata/Datastore_GeneralLedgerAccount?$top=10