2 Replies Latest reply on May 27, 2008 5:12 PM by Matt Wegner

    using a view in sales order entry

       

      we created a view named custaddress2taxcode that contains carcode and address2 from oinv and taxcode from inv1. now we have the following query that works to get the ship to address

       

       

      select t0.address2, t0,taxcode, to.cardcode from custaddress2taxcode t0 where t0.cardcode = $[http://$4.1.0|http://$4.1.0]

       

       

      now we want to get the taxcode related to the selected address so we have this query

       

       

      the system info for the ship to is form=139, item=92, pane=6, variable=1 and we are doing the formatted search in the content tax code field

       

       

      select t0.taxcode, t0.address2, to.cardcode from custaddress2taxcode t0 where t0.cardcode = $[http://$4.1.0|http://$4.1.0] and t0.address2 = $[http://$92.1.0|http://$92.1.0] and we receive the following error

       

       

      internal error (8180) occurred

       

       

      thanks for any help

       

       

      matt