Method Community

 

Error on Sales Order

Last post 06-04-2009 9:25 AM by Anonymous. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-03-2009 11:45 AM

    • Keith
    • Top 200 Contributor
    • Joined on 06-03-2009
    • Posts 23

    Error on Sales Order

     I have written a web app. that creates a Sales order and I get an Insert error when I sent to methods. I get the error when I try to insert the detail lines into the SalesOrderLine table. Does anyone have an example of a sales order>

     

    Thanks

  • 06-03-2009 12:58 PM In reply to

    Re: Error on Sales Order

     Hi Keith,

    Please make sure you pass the currency value without dollar ($) sign or omit the single quotation marks around the currency value.  That should make the error go away :)

  • 06-03-2009 3:07 PM In reply to

    • Keith
    • Top 200 Contributor
    • Joined on 06-03-2009
    • Posts 23

    Re: Error on Sales Order

     Thanks Amanda..that seem to work when I took off the $.. I was using the same code for an Invoice and that worked with the $ sign... does that sound correct?

     

  • 06-04-2009 9:25 AM In reply to

    Re: Error on Sales Order

     Hi Keith,

    We believe it’s the combination of $ and it was enclosed in single Quotation marks - '$12.00'. If you used $12.00 it would probably work provided the field is a currency field.  If you only had $ without the single quotation marks and it still didn't work then we would have to investigate further.  Let me know if that helps.

Page 1 of 1 (4 items)