Epicor 10, Sales Tax tables

[system]

Here's the description of the PatchFld table from the data dictionary...

Patch Fields. A generic table used to provoide a temporary storage location for new fields that need to be implemented within a patch before a schema change can be made. The intent is that during the next schema change fields will be created to hold this data and a conversion program written to migrate it

I was told that sometimes the "correct" table's field doesn't have the necessary format, 2 decimals where 3 or 4 are needed for example (that's the case of the sales tax rate field). That's another case where the data is stored "temporarily" in the PatchFld table. The way I understand it, a schema change basically changes the database structure, rewriting the database while inserting new fields and changing formats of existing fields. For some reason it doesn't seem to be a priority of Epicor's to take care of clearing out the PatchFld table when they put thru a schema change. I would imagine it's quite a bit more involved than my explanation is!

Sue

---In vantage@yahoogroups.com, <thughes281@...> wrote :

Yes, Sue, that's where we finally found it!

Thanks for the reply. 

But what do you mean that it is waiting on a schema change? We're on 10.0.700.2

---

From: "snielsen.hipco@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, April 22, 2015 3:06 PM
Subject: [Vantage] Re: Epicor 10, Sales Tax tables

 

In Epicor 9 it is in the PatchFld table waiting for a schema change to move it to the correct table. Maybe it's still there in E10?

Sue

---In vantage@yahoogroups.com, <thughes281@...> wrote :

Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates > Effective Rate > Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record.

If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field.

What table is the actual tax percentage number stored in?

Thank you.

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 -- #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ads {
margin-bottom:10px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ad {
padding:0 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ad p {
margin:0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mkp .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-lc {
font-family:Arial;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-lc #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-lc .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity span {
font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity span span {
color:#ff7900;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343activity span .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343underline {
text-decoration:underline;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach div a {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach img {
border:none;padding-right:5px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach label a {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343bold a {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 dd.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 dd.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 dd.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343last p span.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343yshortcuts {
margin-right:0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach-table div div a {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach-table {
width:400px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343file-title a, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343file-title a:active, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343file-title a:hover, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343file-title a:visited {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photo-title a, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photo-title a:active, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photo-title a:hover, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 div#ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-msg p a span.ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343green {
color:#628c2a;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 o {
font-size:0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photos div {
float:left;width:72px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343reco-category {
font-size:77%;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343reco-desc {
font-size:77%;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 .ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343replbq {
margin:4px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg select, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 input, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg pre, #ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 code {
font:115% monospace;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-mlmsg #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343logo {
padding-bottom:10px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-msg p#ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-reco #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-sponsor #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-text {
font-family:Georgia;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-text tt {
font-size:120%;}

#ygrps-yiv-459157731 #ygrps-yiv-459157731ygrps-yiv-1402488010 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343 #ygrps-yiv-459157731ygrps-yiv-1402488010yiv4683836343ygrp-vital ul li:last-child {
border-right:none !important;}

[system]

The number is in the tax rate file. The dspTaxPercent is the percentage display and the TaxPercent is the storage of that display.

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-860-9862

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 22, 2015 8:50 AM
To: Vantage List
Subject: [Vantage] Epicor 10, Sales Tax tables

 

 

Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates > Effective Rate > Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record.

If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field.

 

What table is the actual tax percentage number stored in?

 

Thank you.

[system]

Thank you Charlie.

That's really weird, as every row in table TaxRate has 0.000 in the TaxRate.TaxPercent field.

But if I open the Tax Type form in Epicor I see the correct tax percentage, and all tax calculations are working correctly on orders and invoices.

---

From: "Charlie Smith ctcharlie@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, April 22, 2015 9:11 AM
Subject: RE: [Vantage] Epicor 10, Sales Tax tables

 

<div id="ygrps-yiv-987920919yiv8539795561ygrp-text">
  
  
  <div></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2878" class="ygrps-yiv-987920919yiv8539795561WordSection1"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2877" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2876" style="font-size:11.0pt;color:#1F497D;">The number is in the tax rate file. The dspTaxPercent is the percentage display and the TaxPercent is the storage of that display. </span></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2935" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2881"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2948" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Charlie Smith</span></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2937" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2936" style="font-size:11.0pt;color:#1F497D;">CTCharlie@...</span></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2944" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Cell: 860-919-1708</span></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2882" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2938" style="font-size:11.0pt;color:#1F497D;">Office: 817-860-9862</span></div></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2883" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-987920919qtdSeparateBR"><br><br></div><div class="ygrps-yiv-987920919yiv8539795561yqt6888271797" id="ygrps-yiv-987920919yiv8539795561yqt68447"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2887"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2886" style="border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2885" class="ygrps-yiv-987920919yiv8539795561MsoNormal"><b><span style="font-size:10.0pt;">From:</span></b><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2884" style="font-size:10.0pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 8:50 AM<br clear="none"><b>To:</b> Vantage List<br clear="none"><b>Subject:</b> [Vantage] Epicor 10, Sales Tax tables</span></div></div></div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2888" class="ygrps-yiv-987920919yiv8539795561MsoNormal"> &nbsp;</div><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2889" class="ygrps-yiv-987920919yiv8539795561MsoNormal">&nbsp; </div><div id="ygrps-yiv-987920919yiv8539795561ygrp-mlmsg"><div id="ygrps-yiv-987920919yiv8539795561ygrp-msg"><div id="ygrps-yiv-987920919yiv8539795561ygrp-text"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2890"><div id="ygrps-yiv-987920919yiv8539795561yui_3_16_0_1_1429710101821_2974"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2940" class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2939" style="font-size:9.0pt;color:black;">Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates &gt; Effective Rate &gt; Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record. </span></div></div><div id="ygrps-yiv-987920919yiv8539795561yui_3_16_0_1_1429710101821_3086"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2892" class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2891" style="font-size:9.0pt;color:black;">If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field. </span></div></div><div id="ygrps-yiv-987920919yiv8539795561yui_3_16_0_1_1429710101821_3098"><div id="ygrps-yiv-987920919yui_3_16_0_1_1429711799692_2893" class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-987920919yiv8539795561yui_3_16_0_1_1429710101821_3097"><div class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">What table is the actual tax percentage number stored in? </span></div></div><div><div class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-987920919yiv8539795561yui_3_16_0_1_1429710101821_3156"><div class="ygrps-yiv-987920919yiv8539795561MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">Thank you. </span></div></div></div></div><div><div class="ygrps-yiv-987920919yiv8539795561MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-987920919yiv8539795561yqt6888271797" id="ygrps-yiv-987920919yiv8539795561yqt13133"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561 -- #ygrps-yiv-987920919yiv8539795561ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp #ygrps-yiv-987920919yiv8539795561hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp #ygrps-yiv-987920919yiv8539795561ads {
margin-bottom:10px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp .ygrps-yiv-987920919yiv8539795561ad {
padding:0 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp .ygrps-yiv-987920919yiv8539795561ad p {
margin:0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mkp .ygrps-yiv-987920919yiv8539795561ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ygrp-lc {
font-family:Arial;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ygrp-lc #ygrps-yiv-987920919yiv8539795561hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ygrp-lc .ygrps-yiv-987920919yiv8539795561ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity span {
font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity span span {
color:#ff7900;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561activity span .ygrps-yiv-987920919yiv8539795561underline {
text-decoration:underline;}

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

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561attach div a {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561attach img {
border:none;padding-right:5px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561attach label a {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561bold a {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 dd.ygrps-yiv-987920919yiv8539795561last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 dd.ygrps-yiv-987920919yiv8539795561last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 dd.ygrps-yiv-987920919yiv8539795561last p span.ygrps-yiv-987920919yiv8539795561yshortcuts {
margin-right:0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561attach-table div div a {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561attach-table {
width:400px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561file-title a, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561file-title a:active, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561file-title a:hover, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561file-title a:visited {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561photo-title a, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561photo-title a:active, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561photo-title a:hover, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div.ygrps-yiv-987920919yiv8539795561photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 div#ygrps-yiv-987920919yiv8539795561ygrp-mlmsg #ygrps-yiv-987920919yiv8539795561ygrp-msg p a span.ygrps-yiv-987920919yiv8539795561yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561green {
color:#628c2a;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 o {
font-size:0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561photos div {
float:left;width:72px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561reco-category {
font-size:77%;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561reco-desc {
font-size:77%;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 .ygrps-yiv-987920919yiv8539795561replbq {
margin:4px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg select, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 input, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg pre, #ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 code {
font:115% monospace;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-mlmsg #ygrps-yiv-987920919yiv8539795561logo {
padding-bottom:10px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-msg p#ygrps-yiv-987920919yiv8539795561attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-reco #ygrps-yiv-987920919yiv8539795561reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-sponsor #ygrps-yiv-987920919yiv8539795561ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-text {
font-family:Georgia;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-text tt {
font-size:120%;}

#ygrps-yiv-987920919 #ygrps-yiv-987920919yiv8539795561 #ygrps-yiv-987920919yiv8539795561ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-987920919

[system]

Also, when running trace log and changing the value, the log shows change to TaxRate field DspTaxPercent, but I don't see that field on table TaxRate, TaxRate.TaxPercent field is still 0.000.

---

From: "Tony Hughes thughes281@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, April 22, 2015 9:16 AM
Subject: Re: [Vantage] Epicor 10, Sales Tax tables

 

<div id="ygrps-yiv-952280938yiv0438841362ygrp-text">
  
  
  <div></div><div id="ygrps-yiv-952280938yui_3_16_0_1_1429712736534_2716" style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12px;"><div dir="ltr" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2945">Thank you Charlie. <br clear="none"></div><div dir="ltr" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3850"><br clear="none"></div><div dir="ltr" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3950">That&#39;s really weird, as every row in table TaxRate has 0.000 in the TaxRate.TaxPercent field.</div><div dir="ltr" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3951">But if I open the Tax Type form in Epicor I see the correct tax percentage, and all tax calculations are working correctly on orders and invoices. <br clear="none"></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2871"><br clear="none"></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3949"><br clear="none"><span></span></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3915"><br clear="none"><span></span></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_3985"><span></span></div><br clear="none">  <div class="ygrps-yiv-952280938qtdSeparateBR"><br><br></div><div class="ygrps-yiv-952280938yiv0438841362yqt2010175728" id="ygrps-yiv-952280938yiv0438841362yqt13581"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2875" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12px;"> <div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2874" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2873"> <hr id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2949" size="1">  <font id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2872" face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> &quot;Charlie Smith ctcharlie@... [vantage]&quot; &lt;vantage@yahoogroups.com&gt;<br clear="none"> <b><span style="font-weight:bold;">To:</span></b> vantage@yahoogroups.com <br clear="none"> <b><span style="font-weight:bold;">Sent:</span></b> Wednesday, April 22, 2015 9:11 AM<br clear="none"> <b><span style="font-weight:bold;">Subject:</span></b> RE: [Vantage] Epicor 10, Sales Tax tables<br clear="none"> </font> </div> <div class="ygrps-yiv-952280938yiv0438841362y_msg_container" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2880"><br clear="none"><div id="ygrps-yiv-952280938yiv0438841362"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2879">

 

<div id="ygrps-yiv-952280938yiv0438841362ygrp-text">
  
  
  <div></div><div class="ygrps-yiv-952280938yiv0438841362WordSection1" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2878"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2877"><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2876" style="font-size:11.0pt;color:#1F497D;">The number is in the tax rate file. The dspTaxPercent is the percentage display and the TaxPercent is the storage of that display. </span></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2935"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2881"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2948"><span style="font-size:11.0pt;color:#1F497D;">Charlie Smith</span></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2937"><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2936" style="font-size:11.0pt;color:#1F497D;">CTCharlie@...</span></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2944"><span style="font-size:11.0pt;color:#1F497D;">Cell: 860-919-1708</span></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2882"><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2938" style="font-size:11.0pt;color:#1F497D;">Office: 817-860-9862</span></div></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2883"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div id="ygrps-yiv-952280938yui_3_16_0_1_1429712736534_2759" class="ygrps-yiv-952280938yiv0438841362qtdSeparateBR"><br clear="none"><br clear="none"></div><div class="ygrps-yiv-952280938yiv0438841362yqt6888271797" id="ygrps-yiv-952280938yiv0438841362yqt68447"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2887"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2886" style="border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2885"><b><span style="font-size:10.0pt;">From:</span></b><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2884" style="font-size:10.0pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 8:50 AM<br clear="none"><b>To:</b> Vantage List<br clear="none"><b>Subject:</b> [Vantage] Epicor 10, Sales Tax tables</span></div></div></div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2888"> &nbsp;</div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2889">&nbsp; </div><div id="ygrps-yiv-952280938yiv0438841362ygrp-mlmsg"><div id="ygrps-yiv-952280938yiv0438841362ygrp-msg"><div id="ygrps-yiv-952280938yiv0438841362ygrp-text"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2890"><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429710101821_2974"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2940" style="background:white;"><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2939" style="font-size:9.0pt;color:black;">Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates &gt; Effective Rate &gt; Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record. </span></div></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429710101821_3086"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2892" style="background:white;"><span id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2891" style="font-size:9.0pt;color:black;">If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field. </span></div></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429710101821_3098"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429711799692_2893" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429710101821_3097"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">What table is the actual tax percentage number stored in? </span></div></div><div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-952280938yiv0438841362yui_3_16_0_1_1429710101821_3156"><div class="ygrps-yiv-952280938yiv0438841362MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">Thank you. </span></div></div></div></div><div><div class="ygrps-yiv-952280938yiv0438841362MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-952280938yiv0438841362yqt6888271797" id="ygrps-yiv-952280938yiv0438841362yqt13133"><div style="color:#fff;height:0;"></div></div>

</div>
 


<div class="ygrps-yiv-952280938yiv0438841362yqt2010175728" id="ygrps-yiv-952280938yiv0438841362yqt38691"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362 -- #ygrps-yiv-952280938yiv0438841362ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp #ygrps-yiv-952280938yiv0438841362hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp #ygrps-yiv-952280938yiv0438841362ads {
margin-bottom:10px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp .ygrps-yiv-952280938yiv0438841362ad {
padding:0 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp .ygrps-yiv-952280938yiv0438841362ad p {
margin:0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mkp .ygrps-yiv-952280938yiv0438841362ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ygrp-lc {
font-family:Arial;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ygrp-lc #ygrps-yiv-952280938yiv0438841362hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ygrp-lc .ygrps-yiv-952280938yiv0438841362ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity span {
font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity span span {
color:#ff7900;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362activity span .ygrps-yiv-952280938yiv0438841362underline {
text-decoration:underline;}

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

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362attach div a {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362attach img {
border:none;padding-right:5px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362attach label a {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362bold a {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 dd.ygrps-yiv-952280938yiv0438841362last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 dd.ygrps-yiv-952280938yiv0438841362last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 dd.ygrps-yiv-952280938yiv0438841362last p span.ygrps-yiv-952280938yiv0438841362yshortcuts {
margin-right:0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362attach-table div div a {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362attach-table {
width:400px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362file-title a, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362file-title a:active, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362file-title a:hover, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362file-title a:visited {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362photo-title a, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362photo-title a:active, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362photo-title a:hover, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div.ygrps-yiv-952280938yiv0438841362photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 div#ygrps-yiv-952280938yiv0438841362ygrp-mlmsg #ygrps-yiv-952280938yiv0438841362ygrp-msg p a span.ygrps-yiv-952280938yiv0438841362yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362green {
color:#628c2a;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 o {
font-size:0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362photos div {
float:left;width:72px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362reco-category {
font-size:77%;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362reco-desc {
font-size:77%;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 .ygrps-yiv-952280938yiv0438841362replbq {
margin:4px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg select, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 input, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg pre, #ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 code {
font:115% monospace;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-mlmsg #ygrps-yiv-952280938yiv0438841362logo {
padding-bottom:10px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-msg p#ygrps-yiv-952280938yiv0438841362attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-reco #ygrps-yiv-952280938yiv0438841362reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-sponsor #ygrps-yiv-952280938yiv0438841362ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-text {
font-family:Georgia;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-text tt {
font-size:120%;}

#ygrps-yiv-952280938 #ygrps-yiv-952280938yiv0438841362 #ygrps-yiv-952280938yiv0438841362ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-952280938

[system]

Doesn’t the Tax Type have a default rate?

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-860-9862

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 22, 2015 9:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10, Sales Tax tables

 

 

Also, when running trace log and changing the value, the log shows change to TaxRate field DspTaxPercent, but I don't see that field on table TaxRate, TaxRate.TaxPercent field is still 0.000.

 

---

From: "Tony Hughes thughes281@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, April 22, 2015 9:16 AM
Subject: Re: [Vantage] Epicor 10, Sales Tax tables

 

 

Thank you Charlie.

 

That's really weird, as every row in table TaxRate has 0.000 in the TaxRate.TaxPercent field.

But if I open the Tax Type form in Epicor I see the correct tax percentage, and all tax calculations are working correctly on orders and invoices.

 

 

 

 

 

---

From: "Charlie Smith ctcharlie@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, April 22, 2015 9:11 AM
Subject: RE: [Vantage] Epicor 10, Sales Tax tables

 

 

The number is in the tax rate file. The dspTaxPercent is the percentage display and the TaxPercent is the storage of that display.

 

Charlie Smith

CTCharlie@...

Cell: 860-919-1708

Office: 817-860-9862

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 22, 2015 8:50 AM
To: Vantage List
Subject: [Vantage] Epicor 10, Sales Tax tables

 

 

Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates > Effective Rate > Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record.

If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field.

 

What table is the actual tax percentage number stored in?

 

Thank you.

 

 

[system]

Yes, and the taxes all work correctly on a sales order, on to the invoice.

But I cannot find the number that is entered as the percentage on the Tax Type form, tabs Rates > Effective Rate > Detail. 

The place you suspect, the TaxRate table, has the TaxPercent field for every row equal to 0.000

---

From: "Charlie Smith ctcharlie@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, April 22, 2015 9:57 AM
Subject: RE: [Vantage] Epicor 10, Sales Tax tables

 

<div id="ygrps-yiv-797315245yiv5998414885ygrp-text">
  
  
  <div></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3458" class="ygrps-yiv-797315245yiv5998414885WordSection1"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3481" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3671" style="font-size:11.0pt;color:#1F497D;">Doesn’t the Tax Type have a default rate?</span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3482" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3457"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3483" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Charlie Smith</span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3484" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">CTCharlie@...</span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3672" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Cell: 860-919-1708</span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3525" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Office: 817-860-9862</span></div></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3673" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-797315245qtdSeparateBR"><br><br></div><div class="ygrps-yiv-797315245yiv5998414885yqt1650836186" id="ygrps-yiv-797315245yiv5998414885yqt81816"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3463"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3462" style="border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3461" class="ygrps-yiv-797315245yiv5998414885MsoNormal"><b><span style="font-size:10.0pt;">From:</span></b><span id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3674" style="font-size:10.0pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 9:29 AM<br clear="none"><b>To:</b> vantage@yahoogroups.com<br clear="none"><b>Subject:</b> Re: [Vantage] Epicor 10, Sales Tax tables</span></div></div></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3526" class="ygrps-yiv-797315245yiv5998414885MsoNormal"> &nbsp;</div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3582" class="ygrps-yiv-797315245yiv5998414885MsoNormal">&nbsp; </div><div id="ygrps-yiv-797315245yiv5998414885ygrp-mlmsg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-msg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-text"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3464"><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3532" class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3531" style="font-size:9.0pt;color:black;">Also, when running trace log and changing the value, the log shows change to TaxRate field DspTaxPercent, but I don&#39;t see that field on table TaxRate, TaxRate.TaxPercent field is still 0.000. </span></div><div id="ygrps-yiv-797315245yui_3_16_0_1_1429729076940_3527" class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2720"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2719"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2740"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="text-align:center;background:white;" align="center"><span style="color:black;"></span><hr align="center" size="1" width="100%"></div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">From:</span></b><span style="font-size:10.0pt;color:black;"> &quot;Tony Hughes <a rel="nofollow" shape="rect" target="_blank" href="mailto:thughes281@...">thughes281@...</a> [vantage]&quot; &lt;<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt;<br clear="none"><b id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_3003">To:</b> &quot;<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&quot; &lt;<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt; <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 9:16 AM<br clear="none"><b>Subject:</b> Re: [Vantage] Epicor 10, Sales Tax tables</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2718"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;"> &nbsp;</span></div><div id="ygrps-yiv-797315245yiv5998414885"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2717"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;">&nbsp; </span></div><div id="ygrps-yiv-797315245yiv5998414885ygrp-mlmsg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-msg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-text"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2716"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2945"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">Thank you Charlie. </span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_3850"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_3950"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">That&#39;s really weird, as every row in table TaxRate has 0.000 in the TaxRate.TaxPercent field.</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_3951"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">But if I open the Tax Type form in Epicor I see the correct tax percentage, and all tax calculations are working correctly on orders and invoices. </span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2871"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_3949"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_3915"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div><div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="font-size:9.0pt;color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yqt13581"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2875"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2874"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2873"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="text-align:center;background:white;" align="center"><span style="color:black;"></span><hr align="center" size="1" width="100%"></div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">From:</span></b><span style="font-size:10.0pt;color:black;"> &quot;Charlie Smith <a rel="nofollow" shape="rect" target="_blank" href="mailto:ctcharlie@...">ctcharlie@...</a> [vantage]&quot; &lt;<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt;<br clear="none"><b>To:</b> <a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 9:11 AM<br clear="none"><b>Subject:</b> RE: [Vantage] Epicor 10, Sales Tax tables</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2880"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;"> &nbsp;</span></div><div id="ygrps-yiv-797315245yiv5998414885"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2879"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;">&nbsp; </span></div><div id="ygrps-yiv-797315245yiv5998414885ygrp-mlmsg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-msg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-text"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2878"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2877"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">The number is in the tax rate file. The dspTaxPercent is the percentage display and the TaxPercent is the storage of that display. </span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2935"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">&nbsp;</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2881"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2948"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">Charlie Smith</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2937"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;"><a rel="nofollow" shape="rect" target="_blank" href="mailto:CTCharlie@...">CTCharlie@...</a></span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2944"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">Cell: 860-919-1708</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2882"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">Office: 817-860-9862</span><span style="color:black;"></span></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2883"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;">&nbsp;</span><span style="color:black;"></span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429712736534_2759"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="color:black;"> &nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yqt68447"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2887"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2886" style="border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2885"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">From:</span></b><span style="font-size:10.0pt;color:black;"> <a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] <br clear="none"><b>Sent:</b> Wednesday, April 22, 2015 8:50 AM<br clear="none"><b>To:</b> Vantage List<br clear="none"><b>Subject:</b> [Vantage] Epicor 10, Sales Tax tables</span><span style="color:black;"></span></div></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2888"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;">&nbsp;</span></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2889"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="color:black;">&nbsp; </span></div></div><div id="ygrps-yiv-797315245yiv5998414885ygrp-mlmsg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-msg"><div id="ygrps-yiv-797315245yiv5998414885ygrp-text"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2890"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429710101821_2974"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2940"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates &gt; Effective Rate &gt; Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record. </span><span style="color:black;"></span></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429710101821_3086"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2892"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field. </span><span style="color:black;"></span></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429710101821_3098"><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429711799692_2893"><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">&nbsp;</span><span style="color:black;"></span></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429710101821_3097"><div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">What table is the actual tax percentage number stored in? </span><span style="color:black;"></span></div></div></div><div><div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">&nbsp;</span><span style="color:black;"></span></div></div></div><div id="ygrps-yiv-797315245yiv5998414885yui_3_16_0_1_1429710101821_3156"><div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="background:white;"><span style="font-size:9.0pt;color:black;">Thank you. </span><span style="color:black;"></span></div></div></div></div></div></div></div></div></div></div></div></div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="color:black;"> &nbsp;</span></div></div></div></div></div></div></div></div></div></div></div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="color:black;"> &nbsp;</span></div></div></div></div></div></div></div></div><div><div class="ygrps-yiv-797315245yiv5998414885MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-797315245yiv5998414885yqt1650836186" id="ygrps-yiv-797315245yiv5998414885yqt97535"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885 -- #ygrps-yiv-797315245yiv5998414885ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp #ygrps-yiv-797315245yiv5998414885hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp #ygrps-yiv-797315245yiv5998414885ads {
margin-bottom:10px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp .ygrps-yiv-797315245yiv5998414885ad {
padding:0 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp .ygrps-yiv-797315245yiv5998414885ad p {
margin:0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mkp .ygrps-yiv-797315245yiv5998414885ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ygrp-lc {
font-family:Arial;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ygrp-lc #ygrps-yiv-797315245yiv5998414885hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ygrp-lc .ygrps-yiv-797315245yiv5998414885ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity span {
font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity span span {
color:#ff7900;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885activity span .ygrps-yiv-797315245yiv5998414885underline {
text-decoration:underline;}

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

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885attach div a {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885attach img {
border:none;padding-right:5px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885attach label a {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885bold a {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 dd.ygrps-yiv-797315245yiv5998414885last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 dd.ygrps-yiv-797315245yiv5998414885last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 dd.ygrps-yiv-797315245yiv5998414885last p span.ygrps-yiv-797315245yiv5998414885yshortcuts {
margin-right:0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885attach-table div div a {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885attach-table {
width:400px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885file-title a, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885file-title a:active, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885file-title a:hover, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885file-title a:visited {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885photo-title a, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885photo-title a:active, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885photo-title a:hover, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div.ygrps-yiv-797315245yiv5998414885photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 div#ygrps-yiv-797315245yiv5998414885ygrp-mlmsg #ygrps-yiv-797315245yiv5998414885ygrp-msg p a span.ygrps-yiv-797315245yiv5998414885yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885green {
color:#628c2a;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 o {
font-size:0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885photos div {
float:left;width:72px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885reco-category {
font-size:77%;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885reco-desc {
font-size:77%;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 .ygrps-yiv-797315245yiv5998414885replbq {
margin:4px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg select, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 input, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg pre, #ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 code {
font:115% monospace;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-mlmsg #ygrps-yiv-797315245yiv5998414885logo {
padding-bottom:10px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-msg p#ygrps-yiv-797315245yiv5998414885attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-reco #ygrps-yiv-797315245yiv5998414885reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-sponsor #ygrps-yiv-797315245yiv5998414885ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-text {
font-family:Georgia;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-text tt {
font-size:120%;}

#ygrps-yiv-797315245 #ygrps-yiv-797315245yiv5998414885 #ygrps-yiv-797315245yiv5998414885ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-797315245

[system]

In Epicor 9 it is in the PatchFld table waiting for a schema change to move it to the correct table. Maybe it's still there in E10?

Sue

---In vantage@yahoogroups.com, <thughes281@...> wrote :

Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates > Effective Rate > Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record.

If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field.

What table is the actual tax percentage number stored in?

Thank you.

[system]

Yes, Sue, that's where we finally found it!

Thanks for the reply. 

But what do you mean that it is waiting on a schema change? We're on 10.0.700.2

---

From: "snielsen.hipco@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, April 22, 2015 3:06 PM
Subject: [Vantage] Re: Epicor 10, Sales Tax tables

 

<div id="ygrps-yiv-815764022yiv4683836343ygrp-text">
  
  
  <div id="ygrps-yiv-815764022yui_3_16_0_1_1429802958162_3042">In Epicor 9 it is in the PatchFld table waiting for a schema change to move it to the correct table. Maybe it&#39;s still there in E10?<br clear="none"><br clear="none">Sue<br class="ygrps-yiv-815764022yiv4683836343yui-cursor" clear="none"></div><div class="ygrps-yiv-815764022qtdSeparateBR"><br><br></div><div class="ygrps-yiv-815764022yiv4683836343yqt1288257042" id="ygrps-yiv-815764022yiv4683836343yqt14920"><div id="ygrps-yiv-815764022yui_3_16_0_1_1429802958162_3044" class="ygrps-yiv-815764022yiv4683836343ygroups-quoted"><br clear="none"><br clear="none">---In vantage@yahoogroups.com, &lt;thughes281@...&gt; wrote :<br clear="none"><br clear="none"><div id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840"><div id="ygrps-yiv-815764022yui_3_16_0_1_1429802958162_3045" style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12px;"><div dir="ltr" id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840yui_3_16_0_1_1429710101821_2974">Opening the form Tax Type maintenance, in customization mode, and the number in Percentage box on Rates &gt; Effective Rate &gt; Detail tab shows as from table TaxRate.DspTaxPercent. I assume this is a calculation done at loading a record. <br clear="none"></div><div dir="ltr" id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840yui_3_16_0_1_1429710101821_3086">If I look at a tax entry in table TaxType in SQL every entry has 0.000 in the TaxPercent field. <br clear="none"></div><div dir="ltr" id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840yui_3_16_0_1_1429710101821_3098"><br clear="none"></div><div dir="ltr" id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840yui_3_16_0_1_1429710101821_3097">What table is the actual tax percentage number stored in? <br clear="none"></div><div id="ygrps-yiv-815764022yui_3_16_0_1_1429802958162_3150" dir="ltr"><br clear="none"></div><div dir="ltr" id="ygrps-yiv-815764022yiv4683836343ygrps-yiv-701020840yui_3_16_0_1_1429710101821_3156">Thank you. <br clear="none"></div></div></div></div></div>

</div>
 


<div class="ygrps-yiv-815764022yiv4683836343yqt1288257042" id="ygrps-yiv-815764022yiv4683836343yqt96852"><div id="ygrps-yiv-815764022yui_3_16_0_1_1429802958162_3392" style="color:#fff;height:0;"></div></div>

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343 -- #ygrps-yiv-815764022yiv4683836343ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp #ygrps-yiv-815764022yiv4683836343hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp #ygrps-yiv-815764022yiv4683836343ads {
margin-bottom:10px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp .ygrps-yiv-815764022yiv4683836343ad {
padding:0 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp .ygrps-yiv-815764022yiv4683836343ad p {
margin:0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mkp .ygrps-yiv-815764022yiv4683836343ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ygrp-lc {
font-family:Arial;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ygrp-lc #ygrps-yiv-815764022yiv4683836343hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ygrp-lc .ygrps-yiv-815764022yiv4683836343ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity span {
font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity span span {
color:#ff7900;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343activity span .ygrps-yiv-815764022yiv4683836343underline {
text-decoration:underline;}

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

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343attach div a {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343attach img {
border:none;padding-right:5px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343attach label a {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343bold a {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 dd.ygrps-yiv-815764022yiv4683836343last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 dd.ygrps-yiv-815764022yiv4683836343last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 dd.ygrps-yiv-815764022yiv4683836343last p span.ygrps-yiv-815764022yiv4683836343yshortcuts {
margin-right:0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343attach-table div div a {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343attach-table {
width:400px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343file-title a, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343file-title a:active, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343file-title a:hover, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343file-title a:visited {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343photo-title a, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343photo-title a:active, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343photo-title a:hover, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div.ygrps-yiv-815764022yiv4683836343photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 div#ygrps-yiv-815764022yiv4683836343ygrp-mlmsg #ygrps-yiv-815764022yiv4683836343ygrp-msg p a span.ygrps-yiv-815764022yiv4683836343yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343green {
color:#628c2a;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 o {
font-size:0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343photos div {
float:left;width:72px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343reco-category {
font-size:77%;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343reco-desc {
font-size:77%;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 .ygrps-yiv-815764022yiv4683836343replbq {
margin:4px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg select, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 input, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg pre, #ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 code {
font:115% monospace;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-mlmsg #ygrps-yiv-815764022yiv4683836343logo {
padding-bottom:10px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-msg p#ygrps-yiv-815764022yiv4683836343attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-reco #ygrps-yiv-815764022yiv4683836343reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-sponsor #ygrps-yiv-815764022yiv4683836343ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-text {
font-family:Georgia;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-text tt {
font-size:120%;}

#ygrps-yiv-815764022 #ygrps-yiv-815764022yiv4683836343 #ygrps-yiv-815764022yiv4683836343ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-815764022