web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Parameter No in method...
Microsoft Dynamics NAV (Archived)
Suggested Answer

Parameter No in method Read in service 'SOAP Endpoint' is null!

(0) ShareShare
ReportReport
Posted on by Koya Temitope 17

Hi everybody,

I added a custom field on the item card 'product id' which is the product id in dynamics crm, i also made this field a key on the item table.

I created an Item web service but i cannot query/get an item using the 'product id' field

Below are screenshot of steps carried out and response i got

When i query using the 'Item no' field, the response return an item:

WizdlerResponse1.png


WizdlerResponse2.png

When i query using the 'product id' field, the response is 'Parameter No in method Read in service AstItem_Service is null!'

WizdlerResponse3.png

WizdlerResponse.png

My aim is to have an azure function that will get the product id from crm and query the item card field 'product id' to get the item

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    For the Item web service you mention, are you using the Item List page or the Item Card page? Is the field available on that page?

  • Koya Temitope Profile Picture
    Koya Temitope 17 on at

    Thank you Stefano for your response

    I have tried both Item Card page and Item List page, the field is also available on the page.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Are you using SOAP web services? If the field is added to a page exposed as web service, you absolutely can see it. Have you refreshed your web service reference? Can you check the WSDL?

  • Koya Temitope Profile Picture
    Koya Temitope 17 on at

    yes i am using SOAP web service, the field is added to the page exposed in the web service

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Please check the WSDL and maybe post it here.

  • Koya Temitope Profile Picture
    Koya Temitope 17 on at
    I have highlighted the product id field in red, kindly see below
     
    <definitions xmlns="schemas.xmlsoap.org/wsdl" xmlns:tns="urn:microsoft-dynamics-schemas/page/astitem" targetNamespace="urn:microsoft-dynamics-schemas/page/astitem">
    "); vertical-align: bottom; height: 10px;"><types>
    "); vertical-align: bottom; height: 10px;"><xsd:schema xmlns:xsd="www.w3.org/.../XMLSchema" elementFormDefault="qualified" targetNamespace="urn:microsoft-dynamics-schemas/page/astitem">
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Type">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Inventory"/>
    <xsd:enumeration value="Service"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Unit_Group">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Microsoft"/>
    <xsd:enumeration value="Cyberoam"/>
    <xsd:enumeration value="Sophos"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Sector">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Academic"/>
    <xsd:enumeration value="Government"/>
    <xsd:enumeration value="Corporate"/>
    <xsd:enumeration value="Education"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="StockoutWarningDefaultYes">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Default"/>
    <xsd:enumeration value="No"/>
    <xsd:enumeration value="Yes"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="PreventNegInventoryDefaultYes">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Default"/>
    <xsd:enumeration value="No"/>
    <xsd:enumeration value="Yes"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Costing_Method">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="FIFO"/>
    <xsd:enumeration value="LIFO"/>
    <xsd:enumeration value="Specific"/>
    <xsd:enumeration value="Average"/>
    <xsd:enumeration value="Standard"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Price_Profit_Calculation">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Profit_x003D_Price_Cost"/>
    <xsd:enumeration value="Price_x003D_Cost_x002B_Profit"/>
    <xsd:enumeration value="No_Relationship"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Replenishment_System">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Purchase"/>
    <xsd:enumeration value="Prod_Order"/>
    <xsd:enumeration value="Assembly"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Manufacturing_Policy">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Make_to_Stock"/>
    <xsd:enumeration value="Make_to_Order"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Flushing_Method">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Manual"/>
    <xsd:enumeration value="Forward"/>
    <xsd:enumeration value="Backward"/>
    <xsd:enumeration value="Pick__x002B__Forward"/>
    <xsd:enumeration value="Pick__x002B__Backward"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Assembly_Policy">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Assemble_to_Stock"/>
    <xsd:enumeration value="Assemble_to_Order"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Reordering_Policy">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="_blank_"/>
    <xsd:enumeration value="Fixed_Reorder_Qty"/>
    <xsd:enumeration value="Maximum_Qty"/>
    <xsd:enumeration value="Order"/>
    <xsd:enumeration value="Lot_for_Lot"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Reserve">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="Never"/>
    <xsd:enumeration value="Optional"/>
    <xsd:enumeration value="Always"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="Order_Tracking_Policy">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="None"/>
    <xsd:enumeration value="Tracking_Only"/>
    <xsd:enumeration value="Tracking__x0026__Action_Msg"/>
    </xsd:restriction>
    </xsd:simpleType>
    "); vertical-align: bottom; height: 10px;"><xsd:complexType name="AstItem">
    "); vertical-align: bottom; height: 10px;"><xsd:sequence>
    <xsd:element minOccurs="0" maxOccurs="1" name="Key" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Description" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Blocked" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Type" type="tns:Type"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Base_Unit_of_Measure" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Last_Date_Modified" type="xsd:date"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="GTIN" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Item_Category_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Product_Group_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Service_Item_Group" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Unit_Group" type="tns:Unit_Group"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Sector" type="tns:Sector"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Product_ID" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Full_Description" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Automatic_Ext_Texts" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Shelf_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Created_From_Nonstock_Item" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Search_Description" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Inventory" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Purch_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Prod_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Component_Lines" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Sales_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Service_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Job_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Assembly_Order" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Qty_on_Asm_Component" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="StockoutWarningDefaultYes" type="tns:StockoutWarningDefaultYes"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="PreventNegInventoryDefaultYes" type="tns:PreventNegInventoryDefaultYes"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Net_Weight" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Gross_Weight" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Unit_Volume" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Costing_Method" type="tns:Costing_Method"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Standard_Cost" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Unit_Cost" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Indirect_Cost_Percent" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Last_Direct_Cost" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Net_Invoiced_Qty" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Cost_is_Adjusted" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Cost_is_Posted_to_G_L" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="SpecialPurchPricesAndDiscountsTxt" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Gen_Prod_Posting_Group" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="VAT_Prod_Posting_Group" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Inventory_Posting_Group" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Default_Deferral_Template_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Tariff_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Country_Region_of_Origin_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Unit_Price" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="CalcUnitPriceExclVAT" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Price_Includes_VAT" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Price_Profit_Calculation" type="tns:Price_Profit_Calculation"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Profit_Percent" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="SpecialPricesAndDiscountsTxt" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Allow_Invoice_Disc" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Item_Disc_Group" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Sales_Unit_of_Measure" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Application_Wksh_User_ID" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="VAT_Bus_Posting_Gr_Price" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Replenishment_System" type="tns:Replenishment_System"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Lead_Time_Calculation" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Vendor_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Vendor_Item_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Purch_Unit_of_Measure" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Manufacturing_Policy" type="tns:Manufacturing_Policy"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Routing_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Production_BOM_No" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Rounding_Precision" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Flushing_Method" type="tns:Flushing_Method"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Overhead_Rate" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Scrap_Percent" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Lot_Size" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Assembly_Policy" type="tns:Assembly_Policy"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Assembly_BOM" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Reordering_Policy" type="tns:Reordering_Policy"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Reserve" type="tns:Reserve"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Order_Tracking_Policy" type="tns:Order_Tracking_Policy"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Stockkeeping_Unit_Exists" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Dampener_Period" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Dampener_Quantity" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Critical" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Safety_Lead_Time" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Safety_Stock_Quantity" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Include_Inventory" type="xsd:boolean"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Lot_Accumulation_Period" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Rescheduling_Period" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Reorder_Point" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Reorder_Quantity" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Maximum_Inventory" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Overflow_Level" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Time_Bucket" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Minimum_Order_Quantity" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Maximum_Order_Quantity" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Order_Multiple" type="xsd:decimal"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Item_Tracking_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Serial_Nos" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Lot_Nos" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Expiration_Calculation" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Warehouse_Class_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Special_Equipment_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Put_away_Template_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Put_away_Unit_of_Measure_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Phys_Invt_Counting_Period_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Last_Phys_Invt_Date" type="xsd:date"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Last_Counting_Period_Update" type="xsd:date"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Next_Counting_Start_Date" type="xsd:date"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Next_Counting_End_Date" type="xsd:date"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Identifier_Code" type="xsd:string"/>
    <xsd:element minOccurs="0" maxOccurs="1" name="Use_Cross_Docking" type="xsd:boolean"/>
    </xsd:sequence>
    </xsd:complexType>
    "); vertical-align: bottom; height: 10px;"><xsd:complexType name="AstItem_List">
    "); vertical-align: bottom; height: 10px;"><xsd:sequence>
    <xsd:element minOccurs="1" maxOccurs="unbounded" name="AstItem" type="tns:AstItem"/>
    </xsd:sequence>
    </xsd:complexType>
    "); vertical-align: bottom; height: 10px;"><xsd:simpleType name="AstItem_Fields">
    "); vertical-align: bottom; height: 10px;"><xsd:restriction base="xsd:string">
    <xsd:enumeration value="No"/>
    <xsd:enumeration value="Description"/>
    <xsd:enumeration value="Blocked"/>
    <xsd:enumeration value="Type"/>
    <xsd:enumeration value="Base_Unit_of_Measure"/>
    <xsd:enumeration value="Last_Date_Modified"/>
    <xsd:enumeration value="GTIN"/>
    <xsd:enumeration value="Item_Category_Code"/>
    <xsd:enumeration value="Product_Group_Code"/>
    <xsd:enumeration value="Service_Item_Group"/>
    <xsd:enumeration value="Unit_Group"/>
    <xsd:enumeration value="Sector"/>
    <xsd:enumeration value="Product_ID"/>
    <xsd:enumeration value="Full_Description"/>
    <xsd:enumeration value="Automatic_Ext_Texts"/>
    <xsd:enumeration value="Shelf_No"/>
    <xsd:enumeration value="Created_From_Nonstock_Item"/>
    <xsd:enumeration value="Search_Description"/>
    <xsd:enumeration value="Inventory"/>
    <xsd:enumeration value="Qty_on_Purch_Order"/>
    <xsd:enumeration value="Qty_on_Prod_Order"/>
    <xsd:enumeration value="Qty_on_Component_Lines"/>
    <xsd:enumeration value="Qty_on_Sales_Order"/>
    <xsd:enumeration value="Qty_on_Service_Order"/>
    <xsd:enumeration value="Qty_on_Job_Order"/>
    <xsd:enumeration value="Qty_on_Assembly_Order"/>
    <xsd:enumeration value="Qty_on_Asm_Component"/>
    <xsd:enumeration value="StockoutWarningDefaultYes"/>
    <xsd:enumeration value="PreventNegInventoryDefaultYes"/>
    <xsd:enumeration value="Net_Weight"/>
    <xsd:enumeration value="Gross_Weight"/>
    <xsd:enumeration value="Unit_Volume"/>
    <xsd:enumeration value="Costing_Method"/>
    <xsd:enumeration value="Standard_Cost"/>
    <xsd:enumeration value="Unit_Cost"/>
    <xsd:enumeration value="Indirect_Cost_Percent"/>
    <xsd:enumeration value="Last_Direct_Cost"/>
    <xsd:enumeration value="Net_Invoiced_Qty"/>
    <xsd:enumeration value="Cost_is_Adjusted"/>
    <xsd:enumeration value="Cost_is_Posted_to_G_L"/>
    <xsd:enumeration value="SpecialPurchPricesAndDiscountsTxt"/>
    <xsd:enumeration value="Gen_Prod_Posting_Group"/>
    <xsd:enumeration value="VAT_Prod_Posting_Group"/>
    <xsd:enumeration value="Inventory_Posting_Group"/>
    <xsd:enumeration value="Default_Deferral_Template_Code"/>
    <xsd:enumeration value="Tariff_No"/>
    <xsd:enumeration value="Country_Region_of_Origin_Code"/>
    <xsd:enumeration value="Unit_Price"/>
    <xsd:enumeration value="CalcUnitPriceExclVAT"/>
    <xsd:enumeration value="Price_Includes_VAT"/>
    <xsd:enumeration value="Price_Profit_Calculation"/>
    <xsd:enumeration value="Profit_Percent"/>
    <xsd:enumeration value="SpecialPricesAndDiscountsTxt"/>
    <xsd:enumeration value="Allow_Invoice_Disc"/>
    <xsd:enumeration value="Item_Disc_Group"/>
    <xsd:enumeration value="Sales_Unit_of_Measure"/>
    <xsd:enumeration value="Application_Wksh_User_ID"/>
    <xsd:enumeration value="VAT_Bus_Posting_Gr_Price"/>
    <xsd:enumeration value="Replenishment_System"/>
    <xsd:enumeration value="Lead_Time_Calculation"/>
    <xsd:enumeration value="Vendor_No"/>
    <xsd:enumeration value="Vendor_Item_No"/>
    <xsd:enumeration value="Purch_Unit_of_Measure"/>
    <xsd:enumeration value="Manufacturing_Policy"/>
    <xsd:enumeration value="Routing_No"/>
    <xsd:enumeration value="Production_BOM_No"/>
    <xsd:enumeration value="Rounding_Precision"/>
    <xsd:enumeration value="Flushing_Method"/>
    <xsd:enumeration value="Overhead_Rate"/>
    <xsd:enumeration value="Scrap_Percent"/>
    <xsd:enumeration value="Lot_Size"/>
    <xsd:enumeration value="Assembly_Policy"/>
    <xsd:enumeration value="Assembly_BOM"/>
    <xsd:enumeration value="Reordering_Policy"/>
    <xsd:enumeration value="Reserve"/>
    <xsd:enumeration value="Order_Tracking_Policy"/>
    <xsd:enumeration value="Stockkeeping_Unit_Exists"/>
    <xsd:enumeration value="Dampener_Period"/>
    <xsd:enumeration value="Dampener_Quantity"/>
    <xsd:enumeration value="Critical"/>
    <xsd:enumeration value="Safety_Lead_Time"/>
    <xsd:enumeration value="Safety_Stock_Quantity"/>
    <xsd:enumeration value="Include_Inventory"/>
    <xsd:enumeration value="Lot_Accumulation_Period"/>
    <xsd:enumeration value="Rescheduling_Period"/>
    <xsd:enumeration value="Reorder_Point"/>
    <xsd:enumeration value="Reorder_Quantity"/>
    <xsd:enumeration value="Maximum_Inventory"/>
    <xsd:enumeration value="Overflow_Level"/>
    <xsd:enumeration value="Time_Bucket"/>
    <xsd:enumeration value="Minimum_Order_Quantity"/>
    <xsd:enumeration value="Maximum_Order_Quantity"/>
    <xsd:enumeration value="Order_Multiple"/>
    <xsd:enumeration value="Item_Tracking_Code"/>
    <xsd:enumeration value="Serial_Nos"/>
    <xsd:enumeration value="Lot_Nos"/>
    <xsd:enumeration value="Expiration_Calculation"/>
    <xsd:enumeration value="Warehouse_Class_Code"/>
    <xsd:enumeration value="Special_Equipment_Code"/>
    <xsd:enumeration value="Put_away_Template_Code"/>
    <xsd:enumeration value="Put_away_Unit_of_Measure_Code"/>
    <xsd:enumeration value="Phys_Invt_Counting_Period_Code"/>
    <xsd:enumeration value="Last_Phys_Invt_Date"/>
    <xsd:enumeration value="Last_Counting_Period_Update"/>
    <xsd:enumeration value="Next_Counting_Start_Date"/>
    <xsd:enumeration value="Next_Counting_End_Date"/>
    <xsd:enumeration value="Identifier_Code"/>
    <xsd:enumeration value="Use_Cross_Docking"/>
    </xsd:restriction>
    </xsd:simpleType>
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    If you're using Read, it wants a primary key (so Item No).

    To retrieve Items via your Product ID field (custom) you need to filter the Items for that field and then retrieve who matches the filters. Something like described here for Customers:

    docs.microsoft.com/.../readmultiple-operation

  • Koya Temitope Profile Picture
    Koya Temitope 17 on at

    Thank you very much Stefano, i was able to get the item using the "productid" field

    Below code did the magic:

    static async Task Main(string[] args)

       {
           

           var cred = clientCred();

           try

           {

               var itemFilterList = new List<it.AstItem_Filter>();

               var itemFilter = new it.AstItem_Filter()

               {

                   Field = it.AstItem_Fields.Product_Id,

                   //The productid value is passed into the criteria to get the nav item

                   Criteria = "eca123e6-23dc-4649-94bf-b26c4dda22cb"

               };

               itemFilterList.Add(itemFilter);

               var asrr = itemFilterList.ToArray();

               var astItm = await cred.ReadMultipleAsync(new it.ReadMultiple(asrr, null, 0));

               Console.WriteLine(astItm.ReadMultiple_Result1);

               var navItem = astItm.ReadMultiple_Result1;

               for (int i = 0; i < navItem.Length; i++)

               {

                   string itemDes = navItem[i].Description;

                   Console.WriteLine(itemDes);

                   itemNo = navItem[i].No;

                   Console.WriteLine(itemNo);

                   string itemPID = navItem[i].Product_Id;

                   Console.WriteLine(itemPID);

                   var so = createSOrder();

               }

               Console.ReadLine();

           }

           catch (Exception ex)

           {

               var msg = ex.StackTrace;

               Console.WriteLine(msg);

               Console.ReadLine();

           }

           return;

       }

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans