Project Report Help

system · December 31, 2014, 6:33am

Hi, should be quite straight forward assuming Sales Invoice = billed. If you are billing through sales orders, then link the invcdtl ordernum,orderline,orderrelnum back to the sales order release table and then on to sales order detail table.

On Tuesday, 30 December 2014, 18:02, "rstlawrence@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-473047376yiv6159696562ygrp-text">
  
  
  <div>Does anyone have a report they&#39;ve already written that shows billed materials for a Project by date range?&nbsp; I&#39;m trying to build a report that will show all billed materials for a project within a specified date range that will lists the transactions by date and amount.&nbsp; The report could be in SSRS or Crystal, doesn&#39;t matter.&nbsp; <br clear="none"><br clear="none">Any help would be greatly appreciated!<br clear="none"></div><div><br clear="none" class="ygrps-yiv-473047376yiv6159696562yui-cursor"></div><div>

Sincerely,

Rory St. Lawrence

I.T. Manager

McClellan Automation Systems

http://www.mcclellan-automation.com/

</div>
 


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

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562 -- #ygrps-yiv-473047376yiv6159696562ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp #ygrps-yiv-473047376yiv6159696562hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp #ygrps-yiv-473047376yiv6159696562ads {
margin-bottom:10px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp .ygrps-yiv-473047376yiv6159696562ad {
padding:0 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp .ygrps-yiv-473047376yiv6159696562ad p {
margin:0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mkp .ygrps-yiv-473047376yiv6159696562ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ygrp-lc {
font-family:Arial;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ygrp-lc #ygrps-yiv-473047376yiv6159696562hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ygrp-lc .ygrps-yiv-473047376yiv6159696562ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity span {
font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity span span {
color:#ff7900;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562activity span .ygrps-yiv-473047376yiv6159696562underline {
text-decoration:underline;}

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

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562attach div a {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562attach img {
border:none;padding-right:5px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562attach label a {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562bold a {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 dd.ygrps-yiv-473047376yiv6159696562last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 dd.ygrps-yiv-473047376yiv6159696562last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 dd.ygrps-yiv-473047376yiv6159696562last p span.ygrps-yiv-473047376yiv6159696562yshortcuts {
margin-right:0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562attach-table div div a {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562attach-table {
width:400px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562file-title a, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562file-title a:active, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562file-title a:hover, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562file-title a:visited {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562photo-title a, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562photo-title a:active, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562photo-title a:hover, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div.ygrps-yiv-473047376yiv6159696562photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 div#ygrps-yiv-473047376yiv6159696562ygrp-mlmsg #ygrps-yiv-473047376yiv6159696562ygrp-msg p a span.ygrps-yiv-473047376yiv6159696562yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562green {
color:#628c2a;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 o {
font-size:0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562photos div {
float:left;width:72px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562reco-category {
font-size:77%;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562reco-desc {
font-size:77%;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 .ygrps-yiv-473047376yiv6159696562replbq {
margin:4px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg select, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 input, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg pre, #ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 code {
font:115% monospace;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-mlmsg #ygrps-yiv-473047376yiv6159696562logo {
padding-bottom:10px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-msg p#ygrps-yiv-473047376yiv6159696562attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-reco #ygrps-yiv-473047376yiv6159696562reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-sponsor #ygrps-yiv-473047376yiv6159696562ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-text {
font-family:Georgia;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-text tt {
font-size:120%;}

#ygrps-yiv-473047376 #ygrps-yiv-473047376yiv6159696562 #ygrps-yiv-473047376yiv6159696562ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-473047376

system · December 30, 2014, 1:02pm

Does anyone have a report they've already written that shows billed materials for a Project by date range? I'm trying to build a report that will show all billed materials for a project within a specified date range that will lists the transactions by date and amount. The report could be in SSRS or Crystal, doesn't matter.

Any help would be greatly appreciated!