Share
ReportI am wanting to do an API to get the item quanitity for a specific site, but then subtract the /qty on sales order/ from that amount. Is that possible within the below API?
query 50002 /SQ Inventory Quantity/
{
QueryType = API;
APIPublisher = 'Name';
APIGroup = 'CustomAPI';
APIVersion = 'v2.0';
EntityName = 'inventoryQty';
EntitySetName = 'inventoriesQty';
elements
{
dataitem(Item; Item)
{
column(No_; /No./) { }
dataitem(Item_Ledger_Entry; /Item Ledger Entry/)
{
DataItemLink = /Item No./ = Item./No./;
DataItemTableFilter = /Location Code/ = const('MAIN');
column(Location_Code; /Location Code/) { }
column(Quantity; /Quantity/)
{
Method = Sum;
}
}
}
}
}
Categories:
All responses (
Answers (
75,561
