Power BI Connector for Exact Online

Build 24.0.9062

GetSalesItemPrice

Retrieves SalesItemPrice report data. All input values are required.

Input

Name Type Description
ItemId String The ID of the Item.
CurrencyCode String The CurrencyCode to be used.
UnitCode String The UnitCode to be used.
Quantity String Number of items.
AccountId String The ID for the Account.
Date String The date to find the price.

Result Set Columns

Name Type Description
ItemId String The ID of the Item.
ItemCode String The Code of the Item.
ItemDescription String The Description of the Item.
PriceExcludingVAT String The Price (Excluding VAT) of the Item.
PriceIncludingVAT String The Price (Including VAT) of the Item.
CurrencyCode String The CurrencyCode to be used.
UnitCode String The UnitCode to be used.
UnitDescription String The Description of the Item's Unit.
VATCode String The VAT Code of the Item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062