home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / SLINVCRE.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  12.1 KB  |  384 lines
  1. VERSION 2.00
  2. Begin Report SLINVCRE.REP
  3.       Caption      =   "SLINVCRE.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   975
  7.       Header       =   570
  8.       Transaction  =   13290
  9.       SubTotal     =   105
  10.       Footer       =   990
  11.       Pagefooter   =   15960
  12.       Replicate    =   345
  13.       Style        =   0
  14.       Query        =   "SLTRAN STTYPE="I" | STTYPE="C""
  15.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(1)=REPTOT(1)+SLTRAN.STVAT"
  16.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(0)=REPTOT(0)+SLTRAN.STVALUE"
  17.       Macro        =   "2LU:Select from SLNAME where SNACCOUNT=SLTRAN.STACCOUNT"
  18.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(2)=REPTOT(2)+SLTRAN.STVALUE"
  19.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(3)=REPTOT(3)+SLTRAN.STVAT"
  20.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  24.       Special      =   "TXNRANGE(ST_IC_NO,STCREATION)"
  25. End
  26. Begin Control LABEL
  27.       Type         =   "Label"
  28.       Style        =   12
  29.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  30.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  31.       Location     =   "Reportheader Block"
  32.       Height       =   270
  33.       Left         =   -15
  34.       Top          =   405
  35.       Width        =   11070
  36. End
  37. Begin Control LABEL
  38.       Type         =   "Label"
  39.       Style        =   4
  40.       Caption      =   "Sales Invoices and Credit Notes"
  41.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  42.       Location     =   "Reportheader Block"
  43.       Height       =   285
  44.       Left         =   135
  45.       Top          =   675
  46.       Width        =   11025
  47. End
  48. Begin Control LABEL
  49.       Type         =   "Label"
  50.       Style        =   9
  51.       Caption      =   "DTOC(DATE())"
  52.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  53.       Location     =   "Reportheader Block"
  54.       Height       =   285
  55.       Left         =   135
  56.       Top          =   705
  57.       Width        =   3285
  58. End
  59. Begin Control LABEL
  60.       Type         =   "Label"
  61.       Style        =   10
  62.       Caption      =   ""Page: "+PAGENUM()"
  63.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  64.       Location     =   "Reportheader Block"
  65.       Height       =   285
  66.       Left         =   9585
  67.       Top          =   720
  68.       Width        =   1395
  69. End
  70. Begin Control LABEL
  71.       Type         =   "Label"
  72.       Style        =   1
  73.       Caption      =   "Customer ID"
  74.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  75.       Location     =   "Header Block"
  76.       Height       =   285
  77.       Left         =   30
  78.       Top          =   225
  79.       Width        =   1080
  80. End
  81. Begin Control LABEL
  82.       Type         =   "Label"
  83.       Style        =   4
  84.       Caption      =   "Date"
  85.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  86.       Location     =   "Header Block"
  87.       Height       =   285
  88.       Left         =   1455
  89.       Top          =   225
  90.       Width        =   1110
  91. End
  92. Begin Control LABEL
  93.       Type         =   "Label"
  94.       Style        =   1
  95.       Caption      =   "Reference"
  96.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  97.       Location     =   "Header Block"
  98.       Height       =   285
  99.       Left         =   3840
  100.       Top          =   225
  101.       Width        =   990
  102. End
  103. Begin Control LABEL
  104.       Type         =   "Label"
  105.       Style        =   2
  106.       Caption      =   "VAT"
  107.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  108.       Location     =   "Header Block"
  109.       Height       =   285
  110.       Left         =   6975
  111.       Top          =   225
  112.       Width        =   960
  113. End
  114. Begin Control LABEL
  115.       Type         =   "Label"
  116.       Style        =   2
  117.       Caption      =   "Value"
  118.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  119.       Location     =   "Header Block"
  120.       Height       =   285
  121.       Left         =   4920
  122.       Top          =   225
  123.       Width        =   915
  124. End
  125. Begin Control LABEL
  126.       Type         =   "Label"
  127.       Style        =   2
  128.       Caption      =   "Goods"
  129.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  130.       Location     =   "Header Block"
  131.       Height       =   285
  132.       Left         =   5880
  133.       Top          =   225
  134.       Width        =   1005
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   4
  139.       Caption      =   "Type"
  140.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  141.       Location     =   "Header Block"
  142.       Height       =   285
  143.       Left         =   3015
  144.       Top          =   225
  145.       Width        =   600
  146. End
  147. Begin Control LABEL
  148.       Type         =   "Label"
  149.       Style        =   1
  150.       Caption      =   "Account Name"
  151.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  152.       Location     =   "Header Block"
  153.       Height       =   285
  154.       Left         =   8115
  155.       Top          =   225
  156.       Width        =   2085
  157. End
  158. Begin Control STACCOUNT
  159.       Type         =   "Text"
  160.       Style        =   0
  161.       Fieldname    =   "STACCOUNT"
  162.       Filename     =   "SLTRAN"
  163.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  164.       Location     =   "Transaction Block"
  165.       Height       =   270
  166.       Left         =   30
  167.       Top          =   60
  168.       Width        =   1095
  169. End
  170. Begin Control STTXNDATE
  171.       Type         =   "Text"
  172.       Style        =   0
  173.       Fieldname    =   "STTXNDATE"
  174.       Filename     =   "SLTRAN"
  175.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  176.       Location     =   "Transaction Block"
  177.       Height       =   270
  178.       Left         =   1335
  179.       Top          =   60
  180.       Width        =   1275
  181. End
  182. Begin Control STREF
  183.       Type         =   "Text"
  184.       Style        =   0
  185.       Fieldname    =   "STREF"
  186.       Filename     =   "SLTRAN"
  187.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  188.       Location     =   "Transaction Block"
  189.       Height       =   270
  190.       Left         =   3825
  191.       Top          =   60
  192.       Width        =   1005
  193. End
  194. Begin Control STVALUE
  195.       Type         =   "Text"
  196.       Style        =   0
  197.       Fieldname    =   "STVALUE"
  198.       Filename     =   "SLTRAN"
  199.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  200.       Location     =   "Transaction Block"
  201.       Height       =   270
  202.       Left         =   4980
  203.       Top          =   60
  204.       Width        =   870
  205. End
  206. Begin Control STVAT
  207.       Type         =   "Text"
  208.       Style        =   0
  209.       Fieldname    =   "STVAT"
  210.       Filename     =   "SLTRAN"
  211.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  212.       Location     =   "Transaction Block"
  213.       Height       =   270
  214.       Left         =   7080
  215.       Top          =   60
  216.       Width        =   870
  217. End
  218. Begin Control LABEL
  219.       Type         =   "Label"
  220.       Style        =   10
  221.       Caption      =   "STR(SLTRAN.STVALUE-SLTRAN.STVAT,10,2)"
  222.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  223.       Location     =   "Transaction Block"
  224.       Height       =   270
  225.       Left         =   5940
  226.       Top          =   75
  227.       Width        =   945
  228. End
  229. Begin Control LABEL
  230.       Type         =   "Label"
  231.       Style        =   9
  232.       Caption      =   "IF(SLTRAN.STTYPE="I","Invce","Cnote")"
  233.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  234.       Location     =   "Transaction Block"
  235.       Height       =   270
  236.       Left         =   2865
  237.       Top          =   75
  238.       Width        =   810
  239. End
  240. Begin Control SNNAME
  241.       Type         =   "Text"
  242.       Style        =   0
  243.       Fieldname    =   "SNNAME"
  244.       Filename     =   "SLNAME"
  245.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  246.       Location     =   "Transaction Block"
  247.       Height       =   270
  248.       Left         =   8100
  249.       Top          =   60
  250.       Width        =   3075
  251. End
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   10
  255.       Caption      =   "STR(REPTOT(1),10,2)"
  256.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Footer Block"
  258.       Height       =   270
  259.       Left         =   6885
  260.       Top          =   180
  261.       Width        =   1080
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   10
  266.       Caption      =   "STR(REPTOT(0)-REPTOT(1),10,2)"
  267.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Footer Block"
  269.       Height       =   270
  270.       Left         =   5805
  271.       Top          =   180
  272.       Width        =   1080
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "STR(REPTOT(0),10,2)"
  278.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Footer Block"
  280.       Height       =   270
  281.       Left         =   4785
  282.       Top          =   180
  283.       Width        =   1080
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   1
  288.       Caption      =   "Total Invoices"
  289.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Footer Block"
  291.       Height       =   270
  292.       Left         =   2430
  293.       Top          =   180
  294.       Width        =   1350
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   1
  299.       Caption      =   "Total Credits"
  300.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Footer Block"
  302.       Height       =   270
  303.       Left         =   2430
  304.       Top          =   450
  305.       Width        =   1350
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   10
  310.       Caption      =   "STR(REPTOT(2),10,2)"
  311.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  312.       Location     =   "Footer Block"
  313.       Height       =   270
  314.       Left         =   4785
  315.       Top          =   435
  316.       Width        =   1080
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   10
  321.       Caption      =   "STR(REPTOT(2)-REPTOT(3),10,2)"
  322.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  323.       Location     =   "Footer Block"
  324.       Height       =   270
  325.       Left         =   5805
  326.       Top          =   450
  327.       Width        =   1080
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   10
  332.       Caption      =   "STR(REPTOT(3),10,2)"
  333.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  334.       Location     =   "Footer Block"
  335.       Height       =   270
  336.       Left         =   6885
  337.       Top          =   450
  338.       Width        =   1080
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   1
  343.       Caption      =   "Total"
  344.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  345.       Location     =   "Footer Block"
  346.       Height       =   270
  347.       Left         =   2430
  348.       Top          =   720
  349.       Width        =   1350
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   10
  354.       Caption      =   "STR(REPTOT(2)+REPTOT(0),10,2)"
  355.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Footer Block"
  357.       Height       =   270
  358.       Left         =   4770
  359.       Top          =   720
  360.       Width        =   1080
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   10
  365.       Caption      =   "STR(REPTOT(0)+REPTOT(2)-REPTOT(1)-REPTOT(3),10,2)"
  366.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Footer Block"
  368.       Height       =   270
  369.       Left         =   5805
  370.       Top          =   720
  371.       Width        =   1080
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "STR(REPTOT(1)+REPTOT(3),10,2)"
  377.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  378.       Location     =   "Footer Block"
  379.       Height       =   270
  380.       Left         =   6885
  381.       Top          =   720
  382.       Width        =   1080
  383. End
  384.