Completely lost trying to duplicate a report
  • codemonkey76
    Posts:4
    Joined:Fri Aug 31, 2007 2:05 pm
    Completely lost trying to duplicate a report

    by codemonkey76 » Fri Dec 14, 2007 1:36 pm

    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
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Wed Dec 19, 2007 5:03 pm

    Is there any reason why you wouldn't just run report 401 (Sales: Standard) and click on 'Report Summary' and produce similar information?
  • codemonkey76
    Posts:4
    Joined:Fri Aug 31, 2007 2:05 pm

    by codemonkey76 » Thu Dec 20, 2007 9:23 am

    That's perfect, thanks, i thought it didn't show freight, but it does as Misc.

Who is online

Users browsing this forum: No registered users and 4 guests