|
Posted by Jack T on December 9, 2005, 10:59 am
Please log in for more thread options
Rob and Jeff, Thanks for your help! One more thing...Can I add Layaways to
this report as well?? Trying to see all transactions and the Detailed Sales
report only gives me Sales.
"Rob" wrote:
> In order to see Jeff's attachment you would have to use a News Reader (i.e.
> Outlook Express).
> You can add these columns to your report, make sure you put the Formula on
> one line.
>
> Rob
>
> Begin Column
> FieldName = "TotalTaxIncluded"
> DrillDownFieldName = ""
> DrillDownReportName = ""
> Title = "Total TaxInc"
> VBDataType = vbCurrency
> Formula = "(TransactionEntry.Price * TransactionEntry.Quantity) +
> TransactionEntry.SalesTax"
> ColHidden = False
> ColNotDisplayable = False
> FilterDisabled = False
> ColWidth = 1500
> GroupMethod = groupmethodSum
> ColFormat = ""
> End Column
> Begin Column
> FieldName = "TransactionEntry.SalesTax"
> DrillDownFieldName = ""
> DrillDownReportName = ""
> Title = "Sales Tax"
> VBDataType = vbCurrency
> Formula = ""
> ColHidden = False
> ColNotDisplayable = False
> FilterDisabled = False
> ColWidth = 1000
> GroupMethod = groupmethodSum
> ColFormat = ""
> End Column
>
> "Jack T" wrote:
>
> > Jeff,
> > No attachment is here...
> >
> > "Jeff" wrote:
> >
> > > Jack,
> > >
> > > Find a Custom - Detailed Sales with Return Values (Tax-Inclusive)
attached.
> > > Includes the tender type, sales person, total sale with tax
> > >
> > > --
> > > =
> > >
> > > > Rob,
> > > > I added to Detailed Sales Report with Return Values and you are right it
> > > > works, however, neither report shows the sale with tax included so you
> > > > could
> > > > see what the entire tender amount really was. That was why I was trying
> > > > to
> > > > add to the "Custom-Tender entry by date" report. Would you have any
idea
> > > > how
> > > > I might be able to either add the salestax to the DSRRV report or
perhaps
> > > > to
> > > > remedy the other report??
> > > >
> > > > "Rob" wrote:
> > > >
> > > >> Try modifying the Detailed Sales report or the Detailed Sales Report
with
> > > >> Return Values, I tried it by adding the code below and adding the
columns
> > > >> and
> > > >> it worked.
> > > >>
> > > >> Rob
> > > >>
> > > >> "Jack T" wrote:
> > > >>
> > > >> > Rob,
> > > >> > I am trying to add to the "Custom-Tender entry by date" report and
keep
> > > >> > getting Invalid proceedure call or Argument. I am wondering if I am
> > > >> > trying
> > > >> > to place the statement in the wrong place?
> > > >> >
> > > >> > "Rob" wrote:
> > > >> >
> > > >> > > Jack to add Sales Person and Tender to a report you need to add
these
> > > >> > > tables:
> > > >> > > LEFT JOIN SalesRep WITH(NOLOCK) ON TransactionEntry.SalesRepID =
> > > >> > > SalesRep.ID
> > > >> > > LEFT JOIN TenderEntry WITH(NOLOCK) ON
> > > >> > > TransactionEntry.TransactionNumber =
> > > >> > > TenderEntry.TransactionNumber
> > > >> > > LEFT JOIN Tender WITH(NOLOCK) ON TenderEntry.TenderID = Tender.ID
> > > >> > >
> > > >> > > Then add the Tender.Description and SalesRep.Name columns to the
> > > >> > > report.
> > > >> > >
> > > >> > > Rob
> > > >> > >
> > > >> > >
> > > >> > > "Jack T" wrote:
> > > >> > >
> > > >> > > > Yea, I was trying to tie the salesperson into a report that shows
> > > >> > > > customer,
> > > >> > > > salesperson, total sale including tax and tender type.
> > > >> > > >
> > > >> > > > "Jeff" wrote:
> > > >> > > >
> > > >> > > > > Jack,
> > > >> > > > >
> > > >> > > > > Are you asking for 2 reports or a single one?
> > > >> > > > >
> > > >> > > > > The second, how much for each tender types, you have already
> > > >> > > > > have, if you
> > > >> > > > > separate out your credit card tenders. A tender for MC, a
> > > >> > > > > separate for
> > > >> > > > > VISA, etc.
> > > >> > > > >
> > > >> > > > > SO Manager | Reports | Misc | Tender Summary | then collapse
> > > >> > > > > grouped rows,
> > > >> > > > > the 8th icon on top or press Ctrl+O.
> > > >> > > > >
> > > >> > > > > --
> > > >> > > > > *
> > > >> > > > > Anyone know how I can make a sales report that contains a sales
> > > >> > > > > reps sales
> > > >> > > > > within a given time frame, including item price, with tax if
any,
> > > >> > > > > and tender
> > > >> > > > > type (basically the entire sale rung up). I am trying to run a
> > > >> > > > > report that
> > > >> > > > > shows how much we are putting on types of credit cards, Visa,
> > > >> > > > > MasterCard,
> > > >> > > > > Discover, cash, etc. Would like to know the SQL statements
that
> > > >> > > > > are needed
> > > >> > > > > to do so.
> > > >> > > > >
> > > >> > > > >
> > > >> > > > >
> > >
> > >
> > >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap