Page 1 of 1

Completely lost trying to duplicate a report

Posted: Fri Dec 14, 2007 1:36 pm
by codemonkey76
I have a report that i used to use with the DOS version of capital and have no idea how to reproduce it using the windows version, can someone please help.
Here it is:

#LAYOUT
TITLE = "Customer Sales Summary"
DATABASE = INVOICE
LINK = CUSTOMER->ACCOUNT
TOP = 1
BOTTOM = 1
LEFT = 0
HEADER = "[ANSWER3] Sales for [answer1] - [answer2], Page No. [PAGENO]"
SORT = (3)
SOFTSEEK = answer1
TOTAL = @SUM([FTOTAL]-[FREIGHT]), " GROSS SALES: {@Z $99,999,999.99}"
TOTAL = @SUM([TTOTAL]), " TOTAL TAX: {@Z $99,999,999.99}"
TOTAL = @SUM([FREIGHT]), " FREIGHT: {@Z $99,999,999.99}"
TOTAL = @SUM([INVTOT]), " SUB-TOTAL: {@Z $99,999,999.99}"
TOTAL = @SUM([TCOST]), " TOTAL COST: {@Z $99,999,999.99}"
TOTAL = @SUM([FTOTAL]-[FREIGHT] - [TCOST]), " TOTAL G.P.M.: {@Z $99,999,999.99}"
TOTAL = @MARGIN([FTOTAL]-[FREIGHT], [TCOST]), " RELATIVE G.P.M.: {@Z 99,999,999.99%}"
TOTAL = @MARKUP([FTOTAL]-[FREIGHT], [TCOST]), " MARKUP ON COST: {@Z 99,999,999.99%}"

#INPUT
@INPUT("Enter start date of report", [DATE], answer1)
@INPUT("Enter end date of report", [DATE], answer2)
@INPUT("Enter Customer Code", [ACCCODE], answer3)
#RULES
EXIT [DATE] > answer2
AND [ITYPE] # "6"
AND [CUSTYPE] # "I"
AND [ACCCODE] = answer3

#BODY

Posted: Wed Dec 19, 2007 5:03 pm
by COBS Tech Support
Is there any reason why you wouldn't just run report 401 (Sales: Standard) and click on 'Report Summary' and produce similar information?

Posted: Thu Dec 20, 2007 9:23 am
by codemonkey76
That's perfect, thanks, i thought it didn't show freight, but it does as Misc.