|
Season
Starting Member
37 Posts |
 Posted - July 09 2008 : 23:02:33
|
Hi, I am trying to generate a sales report, version 4.5 I am trying to get the total with out the Sales Tax and Shipping. Is there a way to use ORDERAMOUNT - Tax - Shipping in the Fields below so it would show this amount less the tax and shipping.
I have include what is in the Shopa_reports.asp ver 4.5
Fields(0)="ORDERID"
Fields(1)="ORDERAMOUNT"
Fields(2)="Odate"
Fields(3)="ofirstname"
Fields(4)="olastname"
Fields(5)="oaddress"
Fields(6)="oCity"
Fields(7)="ostate"
Fields(8)="ocountry"
Fields(9)="Otax"
Fields(10)="oshipcost"
Fields(11)=("orderamount-otax-oshipcost") <<<<---NOTE this doesnot work, can someone tell me what it should be
fieldcount=11
CapFields(0)=LangProductOrderNumber
CapFields(1)=LangProductTotal
CapFields(2)=LangStatusDate
CapFields(3)=LangCustFirstName
CapFields(4)=LangCustLastName
CapFields(5)=LangCustAddress
CapFields(6)=LangCustCity
capFields(7)=LangCustState
capFields(8)=LangCustCountry
capFields(9)=LangProductTax
capFields(10)=LangFormatShippingInformation
capFields(11)=LangProductTotal
Thanks
Cliff |
Edited by - Season on July 10 2008 18:29:56 |
|
All Forums
Sales Report help
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
