BAQ rows duplicating issue

Yahoo Archive
1
sorry for the duplication of message....my yahoo freaked out.  That is the query from my BAQ.
 


On Wednesday, January 7, 2015 11:19 AM, "Kimberley White faepigrl@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1359415706yiv8646207424ygrp-text">
  
  
  <div></div><div style="color:rgb(0, 0, 0);font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;background-color:rgb(255, 255, 255);"><div id="ygrps-yiv-1359415706yiv8646207424yui_3_16_0_1_1420645358560_34223"><span id="ygrps-yiv-1359415706yiv8646207424yui_3_16_0_1_1420645358560_34224"><span id="ygrps-yiv-1359415706yiv8646207424yui_3_16_0_1_1420645358560_33443">for each InvcHead no-lock&nbsp; where&nbsp; InvcHead.InvoiceDate &gt;= 12/01/2013 And InvcHead.InvoiceType &lt;&gt; &#39;DEP&#39; And InvcHead.Posted = TRUE&nbsp; ,&nbsp; each InvcDtl no-lock&nbsp; where (InvcDtl.Company = InvcHead.Company and InvcDtl.InvoiceNum = InvcHead.InvoiceNum and InvcDtl.CustNum = InvcHead.CustNum ) ,&nbsp; each Part no-lock&nbsp; outer-join where (InvcDtl.Company = Part.Company and InvcDtl.PartNum = Part.PartNum ) ,&nbsp; each Customer no-lock&nbsp; ,&nbsp; each CustGrup no-lock&nbsp; outer-join where (Customer.Company = CustGrup.Company and Customer.GroupCode = CustGrup.GroupCode ) ,&nbsp; each SalesTer no-lock&nbsp; ,&nbsp; each PartTran no-lock&nbsp; where&nbsp; PartTran.TranType = &#39;STK-CUS&#39;&nbsp; ,&nbsp; each ShipDtl no-lock&nbsp; outer-join where (ShipDtl.Company = PartTran.Company and ShipDtl.PackNum = PartTran.PackNum and ShipDtl.PartNum = PartTran.PartNum ) ,&nbsp; each ShipTo no-lock&nbsp; ,&nbsp; each ProdGrup no-lock&nbsp; outer-join where (Customer.Company = SalesTer.Company and Customer.TerritoryID = SalesTer.TerritoryID ) outer-join where (InvcDtl.Company = ShipDtl.Company and InvcDtl.PackNum = ShipDtl.PackNum and InvcDtl.PackLine = ShipDtl.PackLine and InvcDtl.OrderLine = ShipDtl.OrderLine and InvcDtl.OrderRelNum = ShipDtl.OrderRelNum ) outer-join where (Customer.Company = ShipTo.Company and Customer.CustNum = ShipTo.CustNum and Customer.ShipToNum = ShipTo.ShipToNum ) outer-join where (InvcDtl.Company = Customer.Company and InvcDtl.CustNum = Customer.CustNum ) where (Part.Company = ProdGrup.Company and Part.ProdCode = ProdGrup.ProdCode ) by InvcDtl.InvoiceNum&nbsp; by InvcDtl.InvoiceLine .</span></span></div> <div class="ygrps-yiv-1359415706yiv8646207424qtdSeparateBR"><br clear="none"><br clear="none"></div><div class="ygrps-yiv-1359415706yiv8646207424yqt7242168742" id="ygrps-yiv-1359415706yiv8646207424yqt67328"><div class="ygrps-yiv-1359415706yiv8646207424yahoo_quoted" style="display:block;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"> <font face="Arial" size="2"> On Wednesday, January 7, 2015 11:14 AM, &quot;&#39;Vic Drecchio&#39; vic.drecchio@... [vantage]&quot; &lt;vantage@yahoogroups.com&gt; wrote:<br clear="none"> </font> </div>  <br clear="none"><br clear="none"> <div class="ygrps-yiv-1359415706yiv8646207424y_msg_container"><div id="ygrps-yiv-1359415706yiv8646207424"><div>

 

<div id="ygrps-yiv-1359415706yiv8646207424ygrp-text">
  
  
  <div></div><div class="ygrps-yiv-1359415706yiv8646207424WordSection1"><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;">It&#39;d be easier to diagnose and help you if you pasted the query here.&nbsp; </span></div><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;"> &nbsp;</span></div><div class="ygrps-yiv-1359415706yiv8646207424yqt0285375449" id="ygrps-yiv-1359415706yiv8646207424yqt97180"><div><div style="padding:3pt 0in 0in;border-top-color:rgb(181, 196, 223);border-top-width:1pt;border-top-style:solid;"><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, January 07, 2015 10:48 AM<br clear="none"><b>To:</b> vantage@yahoogroups.com<br clear="none"><b>Subject:</b> [Vantage] BAQ rows duplicating issue</span></div></div></div><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal"> &nbsp;</div><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal">&nbsp; </div><div id="ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg"><div id="ygrps-yiv-1359415706yiv8646207424ygrp-msg"><div id="ygrps-yiv-1359415706yiv8646207424ygrp-text"><div><div id="ygrps-yiv-1359415706yiv8646207424yui_3_16_0_1_1420645358560_3124"><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal" style="background:white;"><span style="color:black;">I have written a BAQ for (AR Invoices)and I am getting some rows duplicating.&nbsp;&nbsp; It seems to be only customers assigned to a certain group if they have more than one invoice line they are duplicating....any suggestions.&nbsp; I have changed my joins and checked my table relationships.&nbsp; I am sure it is one or the other.</span></div></div></div></div><div><div class="ygrps-yiv-1359415706yiv8646207424MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-1359415706yiv8646207424yqt0285375449" id="ygrps-yiv-1359415706yiv8646207424yqt93873"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>



</div>
 


<div class="ygrps-yiv-1359415706yiv8646207424yqt7242168742" id="ygrps-yiv-1359415706yiv8646207424yqt19554"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424 -- #ygrps-yiv-1359415706yiv8646207424ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp #ygrps-yiv-1359415706yiv8646207424hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp #ygrps-yiv-1359415706yiv8646207424ads {
margin-bottom:10px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp .ygrps-yiv-1359415706yiv8646207424ad {
padding:0 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp .ygrps-yiv-1359415706yiv8646207424ad p {
margin:0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mkp .ygrps-yiv-1359415706yiv8646207424ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ygrp-lc #ygrps-yiv-1359415706yiv8646207424hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ygrp-lc .ygrps-yiv-1359415706yiv8646207424ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity span {
font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity span span {
color:#ff7900;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424activity span .ygrps-yiv-1359415706yiv8646207424underline {
text-decoration:underline;}

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

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424attach div a {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424attach label a {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424bold a {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 dd.ygrps-yiv-1359415706yiv8646207424last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 dd.ygrps-yiv-1359415706yiv8646207424last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 dd.ygrps-yiv-1359415706yiv8646207424last p span.ygrps-yiv-1359415706yiv8646207424yshortcuts {
margin-right:0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424attach-table {
width:400px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424file-title a, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424file-title a:active, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424file-title a:hover, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424photo-title a, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424photo-title a:active, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424photo-title a:hover, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div.ygrps-yiv-1359415706yiv8646207424photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 div#ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg #ygrps-yiv-1359415706yiv8646207424ygrp-msg p a span.ygrps-yiv-1359415706yiv8646207424yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424green {
color:#628c2a;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 o {
font-size:0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424photos div {
float:left;width:72px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424reco-category {
font-size:77%;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424reco-desc {
font-size:77%;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 .ygrps-yiv-1359415706yiv8646207424replbq {
margin:4px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg select, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 input, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg pre, #ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 code {
font:115% monospace;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-mlmsg #ygrps-yiv-1359415706yiv8646207424logo {
padding-bottom:10px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-msg p#ygrps-yiv-1359415706yiv8646207424attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-reco #ygrps-yiv-1359415706yiv8646207424reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-sponsor #ygrps-yiv-1359415706yiv8646207424ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1359415706 #ygrps-yiv-1359415706yiv8646207424 #ygrps-yiv-1359415706yiv8646207424ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1359415706



2
I have written a BAQ for (AR Invoices)and I am getting some rows duplicating.   It seems to be only customers assigned to a certain group if they have more than one invoice line they are duplicating....any suggestions.  I have changed my joins and checked my table relationships.  I am sure it is one or the other.
3

It'd be easier to diagnose and help you if you pasted the query here.Â

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 07, 2015 10:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ rows duplicating issue

 

 

I have written a BAQ for (AR Invoices)and I am getting some rows duplicating.   It seems to be only customers assigned to a certain group if they have more than one invoice line they are duplicating....any suggestions.  I have changed my joins and checked my table relationships.  I am sure it is one or the other.

4
for each InvcHead no-lock  where  InvcHead.InvoiceDate >= 12/01/2013 And InvcHead.InvoiceType <> 'DEP' And InvcHead.Posted = TRUE  ,  each InvcDtl no-lock  where (InvcDtl.Company = InvcHead.Company and InvcDtl.InvoiceNum = InvcHead.InvoiceNum and InvcDtl.CustNum = InvcHead.CustNum ) ,  each Part no-lock  outer-join where (InvcDtl.Company = Part.Company and InvcDtl.PartNum = Part.PartNum ) ,  each Customer no-lock  ,  each CustGrup no-lock  outer-join where (Customer.Company = CustGrup.Company and Customer.GroupCode = CustGrup.GroupCode ) ,  each SalesTer no-lock  ,  each PartTran no-lock  where  PartTran.TranType = 'STK-CUS'  ,  each ShipDtl no-lock  outer-join where (ShipDtl.Company = PartTran.Company and ShipDtl.PackNum = PartTran.PackNum and ShipDtl.PartNum = PartTran.PartNum ) ,  each ShipTo no-lock  ,  each ProdGrup no-lock  outer-join where (Customer.Company = SalesTer.Company and Customer.TerritoryID = SalesTer.TerritoryID ) outer-join where (InvcDtl.Company = ShipDtl.Company and InvcDtl.PackNum = ShipDtl.PackNum and InvcDtl.PackLine = ShipDtl.PackLine and InvcDtl.OrderLine = ShipDtl.OrderLine and InvcDtl.OrderRelNum = ShipDtl.OrderRelNum ) outer-join where (Customer.Company = ShipTo.Company and Customer.CustNum = ShipTo.CustNum and Customer.ShipToNum = ShipTo.ShipToNum ) outer-join where (InvcDtl.Company = Customer.Company and InvcDtl.CustNum = Customer.CustNum ) where (Part.Company = ProdGrup.Company and Part.ProdCode = ProdGrup.ProdCode ) by InvcDtl.InvoiceNum  by InvcDtl.InvoiceLine .


On Wednesday, January 7, 2015 11:14 AM, "'Vic Drecchio' vic.drecchio@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-103043850yiv1664460092ygrp-text">
  
  
  <div></div><div class="ygrps-yiv-103043850yiv1664460092WordSection1"><div class="ygrps-yiv-103043850yiv1664460092MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;">It&#39;d be easier to diagnose and help you if you pasted the query here.&nbsp; </span></div><div class="ygrps-yiv-103043850yiv1664460092MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;"> &nbsp;</span></div><div class="ygrps-yiv-103043850yiv1664460092yqt0285375449" id="ygrps-yiv-103043850yiv1664460092yqt97180"><div><div style="padding:3pt 0in 0in;border-top-color:rgb(181, 196, 223);border-top-width:1pt;border-top-style:solid;"><div class="ygrps-yiv-103043850yiv1664460092MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, January 07, 2015 10:48 AM<br clear="none"><b>To:</b> vantage@yahoogroups.com<br clear="none"><b>Subject:</b> [Vantage] BAQ rows duplicating issue</span></div></div></div><div class="ygrps-yiv-103043850yiv1664460092MsoNormal"> &nbsp;</div><div class="ygrps-yiv-103043850yiv1664460092MsoNormal">&nbsp; </div><div id="ygrps-yiv-103043850yiv1664460092ygrp-mlmsg"><div id="ygrps-yiv-103043850yiv1664460092ygrp-msg"><div id="ygrps-yiv-103043850yiv1664460092ygrp-text"><div><div id="ygrps-yiv-103043850yiv1664460092yui_3_16_0_1_1420645358560_3124"><div class="ygrps-yiv-103043850yiv1664460092MsoNormal" style="background:white;"><span style="color:black;">I have written a BAQ for (AR Invoices)and I am getting some rows duplicating.&nbsp;&nbsp; It seems to be only customers assigned to a certain group if they have more than one invoice line they are duplicating....any suggestions.&nbsp; I have changed my joins and checked my table relationships.&nbsp; I am sure it is one or the other.</span></div></div></div></div><div><div class="ygrps-yiv-103043850yiv1664460092MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-103043850yiv1664460092yqt0285375449" id="ygrps-yiv-103043850yiv1664460092yqt93873"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092 -- #ygrps-yiv-103043850yiv1664460092ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp #ygrps-yiv-103043850yiv1664460092hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp #ygrps-yiv-103043850yiv1664460092ads {
margin-bottom:10px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp .ygrps-yiv-103043850yiv1664460092ad {
padding:0 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp .ygrps-yiv-103043850yiv1664460092ad p {
margin:0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mkp .ygrps-yiv-103043850yiv1664460092ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ygrp-lc {
font-family:Arial;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ygrp-lc #ygrps-yiv-103043850yiv1664460092hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ygrp-lc .ygrps-yiv-103043850yiv1664460092ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity span {
font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity span span {
color:#ff7900;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092activity span .ygrps-yiv-103043850yiv1664460092underline {
text-decoration:underline;}

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

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092attach div a {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092attach img {
border:none;padding-right:5px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092attach label a {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092bold a {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 dd.ygrps-yiv-103043850yiv1664460092last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 dd.ygrps-yiv-103043850yiv1664460092last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 dd.ygrps-yiv-103043850yiv1664460092last p span.ygrps-yiv-103043850yiv1664460092yshortcuts {
margin-right:0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092attach-table div div a {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092attach-table {
width:400px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092file-title a, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092file-title a:active, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092file-title a:hover, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092file-title a:visited {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092photo-title a, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092photo-title a:active, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092photo-title a:hover, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div.ygrps-yiv-103043850yiv1664460092photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 div#ygrps-yiv-103043850yiv1664460092ygrp-mlmsg #ygrps-yiv-103043850yiv1664460092ygrp-msg p a span.ygrps-yiv-103043850yiv1664460092yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092green {
color:#628c2a;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 o {
font-size:0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092photos div {
float:left;width:72px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092reco-category {
font-size:77%;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092reco-desc {
font-size:77%;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 .ygrps-yiv-103043850yiv1664460092replbq {
margin:4px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg select, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 input, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg pre, #ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 code {
font:115% monospace;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-mlmsg #ygrps-yiv-103043850yiv1664460092logo {
padding-bottom:10px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-msg p#ygrps-yiv-103043850yiv1664460092attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-reco #ygrps-yiv-103043850yiv1664460092reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-sponsor #ygrps-yiv-103043850yiv1664460092ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-text {
font-family:Georgia;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-text tt {
font-size:120%;}

#ygrps-yiv-103043850 #ygrps-yiv-103043850yiv1664460092 #ygrps-yiv-103043850yiv1664460092ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-103043850



5
for each InvcHead no-lock  where  InvcHead.InvoiceDate >= 12/01/2013 And InvcHead.InvoiceType <> 'DEP' And InvcHead.Posted = TRUE  ,  each InvcDtl no-lock  where (InvcDtl.Company = InvcHead.Company and InvcDtl.InvoiceNum = InvcHead.InvoiceNum and InvcDtl.CustNum = InvcHead.CustNum ) ,  each Part no-lock  outer-join where (InvcDtl.Company = Part.Company and InvcDtl.PartNum = Part.PartNum ) ,  each Customer no-lock  ,  each CustGrup no-lock  outer-join where (Customer.Company = CustGrup.Company and Customer.GroupCode = CustGrup.GroupCode ) ,  each SalesTer no-lock  ,  each PartTran no-lock  where  PartTran.TranType = 'STK-CUS'  ,  each ShipDtl no-lock  outer-join where (ShipDtl.Company = PartTran.Company and ShipDtl.PackNum = PartTran.PackNum and ShipDtl.PartNum = PartTran.PartNum ) ,  each ShipTo no-lock  ,  each ProdGrup no-lock  outer-join where (Customer.Company = SalesTer.Company and Customer.TerritoryID = SalesTer.TerritoryID ) outer-join where (InvcDtl.Company = ShipDtl.Company and InvcDtl.PackNum = ShipDtl.PackNum and InvcDtl.PackLine = ShipDtl.PackLine and InvcDtl.OrderLine = ShipDtl.OrderLine and InvcDtl.OrderRelNum = ShipDtl.OrderRelNum ) outer-join where (Customer.Company = ShipTo.Company and Customer.CustNum = ShipTo.CustNum and Customer.ShipToNum = ShipTo.ShipToNum ) outer-join where (InvcDtl.Company = Customer.Company and InvcDtl.CustNum = Customer.CustNum ) where (Part.Company = ProdGrup.Company and Part.ProdCode = ProdGrup.ProdCode ) by InvcDtl.InvoiceNum  by InvcDtl.InvoiceLine .


On Wednesday, January 7, 2015 11:14 AM, "'Vic Drecchio' vic.drecchio@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1058811706yiv1664460092ygrp-text">
  
  
  <div></div><div class="ygrps-yiv-1058811706yiv1664460092WordSection1"><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;">It&#39;d be easier to diagnose and help you if you pasted the query here.&nbsp; </span></div><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal"><span style="color:rgb(68, 84, 106);font-size:11pt;"> &nbsp;</span></div><div class="ygrps-yiv-1058811706yiv1664460092yqt0285375449" id="ygrps-yiv-1058811706yiv1664460092yqt97180"><div><div style="padding:3pt 0in 0in;border-top-color:rgb(181, 196, 223);border-top-width:1pt;border-top-style:solid;"><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal"><b><span style="font-size:10pt;">From:</span></b><span style="font-size:10pt;"> vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] <br clear="none"><b>Sent:</b> Wednesday, January 07, 2015 10:48 AM<br clear="none"><b>To:</b> vantage@yahoogroups.com<br clear="none"><b>Subject:</b> [Vantage] BAQ rows duplicating issue</span></div></div></div><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal"> &nbsp;</div><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal">&nbsp; </div><div id="ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg"><div id="ygrps-yiv-1058811706yiv1664460092ygrp-msg"><div id="ygrps-yiv-1058811706yiv1664460092ygrp-text"><div><div id="ygrps-yiv-1058811706yiv1664460092yui_3_16_0_1_1420645358560_3124"><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal" style="background:white;"><span style="color:black;">I have written a BAQ for (AR Invoices)and I am getting some rows duplicating.&nbsp;&nbsp; It seems to be only customers assigned to a certain group if they have more than one invoice line they are duplicating....any suggestions.&nbsp; I have changed my joins and checked my table relationships.&nbsp; I am sure it is one or the other.</span></div></div></div></div><div><div class="ygrps-yiv-1058811706yiv1664460092MsoNormal"><span style="color:white;"></span></div></div></div></div></div></div> 

</div>
 


<div class="ygrps-yiv-1058811706yiv1664460092yqt0285375449" id="ygrps-yiv-1058811706yiv1664460092yqt93873"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092 -- #ygrps-yiv-1058811706yiv1664460092ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp #ygrps-yiv-1058811706yiv1664460092hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp #ygrps-yiv-1058811706yiv1664460092ads {
margin-bottom:10px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp .ygrps-yiv-1058811706yiv1664460092ad {
padding:0 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp .ygrps-yiv-1058811706yiv1664460092ad p {
margin:0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mkp .ygrps-yiv-1058811706yiv1664460092ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ygrp-lc #ygrps-yiv-1058811706yiv1664460092hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ygrp-lc .ygrps-yiv-1058811706yiv1664460092ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity span {
font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity span span {
color:#ff7900;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092activity span .ygrps-yiv-1058811706yiv1664460092underline {
text-decoration:underline;}

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

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092attach div a {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092attach label a {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092bold a {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 dd.ygrps-yiv-1058811706yiv1664460092last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 dd.ygrps-yiv-1058811706yiv1664460092last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 dd.ygrps-yiv-1058811706yiv1664460092last p span.ygrps-yiv-1058811706yiv1664460092yshortcuts {
margin-right:0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092attach-table {
width:400px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092file-title a, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092file-title a:active, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092file-title a:hover, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092photo-title a, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092photo-title a:active, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092photo-title a:hover, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div.ygrps-yiv-1058811706yiv1664460092photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 div#ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg #ygrps-yiv-1058811706yiv1664460092ygrp-msg p a span.ygrps-yiv-1058811706yiv1664460092yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092green {
color:#628c2a;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 o {
font-size:0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092photos div {
float:left;width:72px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092reco-category {
font-size:77%;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092reco-desc {
font-size:77%;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 .ygrps-yiv-1058811706yiv1664460092replbq {
margin:4px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg select, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 input, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg pre, #ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 code {
font:115% monospace;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-mlmsg #ygrps-yiv-1058811706yiv1664460092logo {
padding-bottom:10px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-msg p#ygrps-yiv-1058811706yiv1664460092attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-reco #ygrps-yiv-1058811706yiv1664460092reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-sponsor #ygrps-yiv-1058811706yiv1664460092ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1058811706 #ygrps-yiv-1058811706yiv1664460092 #ygrps-yiv-1058811706yiv1664460092ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1058811706