Site Search:
Sign in | Join | Help

EConnect generate Item UOFM error when sending Sales Order

Last post 06-02-2008 5:25 AM by phamdachoang. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 06-02-2008 5:25 AM

    EConnect generate Item UOFM error when sending Sales Order

     Hi every body

    I am a newbiew of GP 10. I used Econnect 10 to send my Purchase Order to GP as Sales Order

     

    I tried to send Purch as GO Sales Order. Sometime, it transferred data successful but sometimes this generates following  error: 

    Sql procedure error codes returned: Error Number = 1599  Stored Procedure taSopLineIvcInsert  Error Description = The UOFM for the item is not specified in the Item Price List as a Default Selling UofM Node Identifier Parameters: taSopLineIvcInsert                                  SOPNUMBE = ORDST2270         SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert                                  UOFM =  Note: This parameter was not passed in, no value for the parameter will be returned.    Error Number = 5313  Stored Procedure taSopLineIvcInsert  Error Description = Unit of Measure does not exist for the Unit of Measure Schedule being used Node Identifier Parameters: taSopLineIvcInsert                                  SOPNUMBE = ORDST2270         SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert                                  NONINVEN =  Note: This parameter was not passed in, no value for the parameter will be returned.  UOFM =  Note: This parameter was not passed in, no value for the parameter will be returned.    Error Number = 771  Stored Procedure taSopLineIvcInsert  Error Description = Price Level is blank, it must either be passed in or a default must exist for the transaction Node Identifier Parameters: taSopLineIvcInsert                                  SOPNUMBE = ORDST2270         SOPTYPE = 2 Related Error Code Parameters for Node : taSopLineIvcInsert                                  PRCLEVEL =  Note: This parameter was not passed in, no value for the parameter will be returned.    

     

    Athough I declaired

    lineItem.UOFM = GetXmlTextFromGPItem("1-A3483A") // -->This funtion return "Each".

    lineItem.NONINVEN =0

     

    string GetXmlTextFromGPItem(string gpItemID)

    {

        XmlNode itemnode= _itemDocXml.SelectSingleNode(string.Format("descendant::eConnect/Item[ITEMNMBR= '{0}']", gpItemID)); 

        XmlNode valueNode =null;  
        if (itemnode!=null)
            valueNode =itemnode.SelectSingleNode("SELNGUOM");           
        
        if (valueNode!=null)

                 return  valueNode.InnerText;

        return  string.Empty;

     

     Please help me solve this problem

    Thanks and best regards

     

     

    • 203.162.3.160
Page 1 of 1 (1 items)