Get price via BO or web services

Adam,

I've done that before, give me a ping and I will give you some ideas on how to query Epicor to get what you need.
 
Consultant
Carlos Madero
cmadero@...



On Tuesday, November 10, 2015 2:45 AM, "adamjwchen@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-774104136yiv3367388808ygrp-text">
  
  
  <div>Hi,<br clear="none">We are implementing E10, we tried figuring how to get correct sale price of parts for customers from external via BO, web service or direct SQL query. <br clear="none"></div><div><span><br clear="none" class="ygrps-yiv-774104136yiv3367388808yui-cursor"></span></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808 -- #ygrps-yiv-774104136yiv3367388808ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp #ygrps-yiv-774104136yiv3367388808hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp #ygrps-yiv-774104136yiv3367388808ads {
margin-bottom:10px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp .ygrps-yiv-774104136yiv3367388808ad {
padding:0 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp .ygrps-yiv-774104136yiv3367388808ad p {
margin:0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mkp .ygrps-yiv-774104136yiv3367388808ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ygrp-lc {
font-family:Arial;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ygrp-lc #ygrps-yiv-774104136yiv3367388808hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ygrp-lc .ygrps-yiv-774104136yiv3367388808ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity span {
font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity span span {
color:#ff7900;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808activity span .ygrps-yiv-774104136yiv3367388808underline {
text-decoration:underline;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808attach div a {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808attach img {
border:none;padding-right:5px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808attach label a {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808bold a {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 dd.ygrps-yiv-774104136yiv3367388808last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 dd.ygrps-yiv-774104136yiv3367388808last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 dd.ygrps-yiv-774104136yiv3367388808last p span.ygrps-yiv-774104136yiv3367388808yshortcuts {
margin-right:0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808attach-table div div a {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808attach-table {
width:400px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808file-title a, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808file-title a:active, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808file-title a:hover, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808file-title a:visited {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808photo-title a, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808photo-title a:active, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808photo-title a:hover, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div.ygrps-yiv-774104136yiv3367388808photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 div#ygrps-yiv-774104136yiv3367388808ygrp-mlmsg #ygrps-yiv-774104136yiv3367388808ygrp-msg p a span.ygrps-yiv-774104136yiv3367388808yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808green {
color:#628c2a;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 o {
font-size:0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808photos div {
float:left;width:72px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808reco-category {
font-size:77%;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808reco-desc {
font-size:77%;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 .ygrps-yiv-774104136yiv3367388808replbq {
margin:4px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg select, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 input, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg pre, #ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 code {
font:115% monospace;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-mlmsg #ygrps-yiv-774104136yiv3367388808logo {
padding-bottom:10px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-msg p#ygrps-yiv-774104136yiv3367388808attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-reco #ygrps-yiv-774104136yiv3367388808reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-sponsor #ygrps-yiv-774104136yiv3367388808ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-text {
font-family:Georgia;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-text tt {
font-size:120%;}

#ygrps-yiv-774104136 #ygrps-yiv-774104136yiv3367388808 #ygrps-yiv-774104136yiv3367388808ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-774104136



Hi,
We are implementing E10, we tried figuring how to get correct sale price of parts for customers from external via BO, web service or direct SQL query.


Look at the web services guide in EpicWeb


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Nov 10, 2015 at 3:45 AM, adamjwchen@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>Hi,<br>We are implementing E10, we tried figuring how to get correct sale price of parts for customers from external via BO, web service or direct SQL query. <br></p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>