home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLRECURR.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  12.0 KB  |  387 lines
  1. VERSION 2.00
  2. rem     Rev 1.0   12 Jan 1995 16:27:56   capital_admin
  3. rem  Initial revision.
  4. rem
  5. Begin Report NLRECURR.REP
  6.       Caption      =   "NLRECURR.REP"
  7.       Width        =   11175
  8.       Height       =   15795
  9.       Reportheader =   990
  10.       Header       =   930
  11.       Transaction  =   11430
  12.       SubTotal     =   1035
  13.       Footer       =   795
  14.       Pagefooter   =   15615
  15.       Replicate    =   390
  16.       Style        =   0
  17.       Query        =   "NLRECDT ALL"
  18.       Macro        =   "1LU:Select from NLRECHD where NRCODE=NLRECDT.NECODE"
  19.       Macro        =   "2LU:Select from NLNAME where NNACCOUNT=NLRECDT.NEACCID"
  20.       Macro        =   "2CD:When NLRECDT.NEVALUE=>0 then REPTOT(0)=REPTOT(0)+NLRECDT.NEVALUE"
  21.       Macro        =   "2CD:When NLRECDT.NEVALUE<0 then REPTOT(1)=REPTOT(1)+(NLRECDT.NEVALUE*-1)"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  23.       Macro        =   "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(1)"
  24.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  25.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  26.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  27.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  28.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  29.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  30.       BreakOn      =   "NLRECDT.NECODE"
  31. End
  32. Begin Control LABEL
  33.       Type         =   "Label"
  34.       Style        =   4
  35.       Caption      =   "List of Recurring Journals"
  36.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  37.       Location     =   "Reportheader Block"
  38.       Height       =   375
  39.       Left         =   0
  40.       Top          =   675
  41.       Width        =   11025
  42. End
  43. Begin Control LABEL
  44.       Type         =   "Label"
  45.       Style        =   9
  46.       Caption      =   "DTOC(DATE())"
  47.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  48.       Location     =   "Reportheader Block"
  49.       Height       =   285
  50.       Left         =   135
  51.       Top          =   705
  52.       Width        =   1800
  53. End
  54. Begin Control LABEL
  55.       Type         =   "Label"
  56.       Style        =   10
  57.       Caption      =   ""Page "+PAGENUM()"
  58.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  59.       Location     =   "Reportheader Block"
  60.       Height       =   285
  61.       Left         =   9180
  62.       Top          =   720
  63.       Width        =   1800
  64. End
  65. Begin Control LABEL
  66.       Type         =   "Label"
  67.       Style        =   12
  68.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  69.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  70.       Location     =   "Reportheader Block"
  71.       Height       =   270
  72.       Left         =   -15
  73.       Top          =   405
  74.       Width        =   11070
  75. End
  76. Begin Control LABEL
  77.       Type         =   "Label"
  78.       Style        =   1
  79.       Caption      =   "Entry:"
  80.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  81.       Location     =   "Header Block"
  82.       Height       =   285
  83.       Left         =   90
  84.       Top          =   60
  85.       Width        =   600
  86. End
  87. Begin Control LABEL
  88.       Type         =   "Label"
  89.       Style        =   1
  90.       Caption      =   "Next Due"
  91.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  92.       Location     =   "Header Block"
  93.       Height       =   285
  94.       Left         =   1170
  95.       Top          =   60
  96.       Width        =   1005
  97. End
  98. Begin Control LABEL
  99.       Type         =   "Label"
  100.       Style        =   1
  101.       Caption      =   "Freq"
  102.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  103.       Location     =   "Header Block"
  104.       Height       =   285
  105.       Left         =   2385
  106.       Top          =   60
  107.       Width        =   600
  108. End
  109. Begin Control LABEL
  110.       Type         =   "Label"
  111.       Style        =   1
  112.       Caption      =   "Repetitions"
  113.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  114.       Location     =   "Header Block"
  115.       Height       =   285
  116.       Left         =   3060
  117.       Top          =   60
  118.       Width        =   1005
  119. End
  120. Begin Control LABEL
  121.       Type         =   "Label"
  122.       Style        =   2
  123.       Caption      =   "Debit"
  124.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  125.       Location     =   "Header Block"
  126.       Height       =   285
  127.       Left         =   4935
  128.       Top          =   810
  129.       Width        =   1275
  130. End
  131. Begin Control LABEL
  132.       Type         =   "Label"
  133.       Style        =   2
  134.       Caption      =   "Credit"
  135.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  136.       Location     =   "Header Block"
  137.       Height       =   285
  138.       Left         =   6555
  139.       Top          =   810
  140.       Width        =   1275
  141. End
  142. Begin Control NRDUEDATE
  143.       Type         =   "Text"
  144.       Style        =   0
  145.       Fieldname    =   "NRDUEDATE"
  146.       Filename     =   "NLRECHD"
  147.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  148.       Location     =   "Header Block"
  149.       Height       =   270
  150.       Left         =   1125
  151.       Top          =   345
  152.       Width        =   1005
  153. End
  154. Begin Control LABEL
  155.       Type         =   "Label"
  156.       Style        =   1
  157.       Caption      =   "Account"
  158.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  159.       Location     =   "Header Block"
  160.       Height       =   285
  161.       Left         =   75
  162.       Top          =   810
  163.       Width        =   1140
  164. End
  165. Begin Control NRNARR
  166.       Type         =   "Text"
  167.       Style        =   0
  168.       Fieldname    =   "NRNARR"
  169.       Filename     =   "NLRECHD"
  170.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  171.       Location     =   "Header Block"
  172.       Height       =   270
  173.       Left         =   4395
  174.       Top          =   345
  175.       Width        =   3975
  176. End
  177. Begin Control NRCODE
  178.       Type         =   "Text"
  179.       Style        =   0
  180.       Fieldname    =   "NRCODE"
  181.       Filename     =   "NLRECHD"
  182.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  183.       Location     =   "Header Block"
  184.       Height       =   270
  185.       Left         =   45
  186.       Top          =   345
  187.       Width        =   870
  188. End
  189. Begin Control NRFREQ
  190.       Type         =   "Text"
  191.       Style        =   0
  192.       Fieldname    =   "NRFREQ"
  193.       Filename     =   "NLRECHD"
  194.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  195.       Location     =   "Header Block"
  196.       Height       =   270
  197.       Left         =   2475
  198.       Top          =   345
  199.       Width        =   330
  200. End
  201. Begin Control NRREPS
  202.       Type         =   "Text"
  203.       Style        =   0
  204.       Fieldname    =   "NRREPS"
  205.       Filename     =   "NLRECHD"
  206.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Header Block"
  208.       Height       =   270
  209.       Left         =   3015
  210.       Top          =   345
  211.       Width        =   465
  212. End
  213. Begin Control NNACCNAME
  214.       Type         =   "Text"
  215.       Style        =   0
  216.       Fieldname    =   "NNACCNAME"
  217.       Filename     =   "NLNAME"
  218.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  219.       Location     =   "Transaction Block"
  220.       Height       =   270
  221.       Left         =   1290
  222.       Top          =   90
  223.       Width        =   3165
  224. End
  225. Begin Control NEACCID
  226.       Type         =   "Text"
  227.       Style        =   0
  228.       Fieldname    =   "NEACCID"
  229.       Filename     =   "NLRECDT"
  230.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  231.       Location     =   "Transaction Block"
  232.       Height       =   270
  233.       Left         =   45
  234.       Top          =   90
  235.       Width        =   1005
  236. End
  237. Begin Control LABEL
  238.       Type         =   "Label"
  239.       Style        =   10
  240.       Caption      =   "CORD(NLRECDT.NEVALUE,10,2,1)"
  241.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  242.       Location     =   "Transaction Block"
  243.       Height       =   285
  244.       Left         =   4800
  245.       Top          =   105
  246.       Width        =   1410
  247. End
  248. Begin Control LABEL
  249.       Type         =   "Label"
  250.       Style        =   10
  251.       Caption      =   "CORD(NLRECDT.NEVALUE,10,2,-1)"
  252.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  253.       Location     =   "Transaction Block"
  254.       Height       =   285
  255.       Left         =   6420
  256.       Top          =   105
  257.       Width        =   1410
  258. End
  259. Begin Control NECOMMENT
  260.       Type         =   "Text"
  261.       Style        =   0
  262.       Fieldname    =   "NECOMMENT"
  263.       Filename     =   "NLRECDT"
  264.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  265.       Location     =   "Transaction Block"
  266.       Height       =   270
  267.       Left         =   8040
  268.       Top          =   90
  269.       Width        =   2895
  270. End
  271. Begin Control BOX
  272.       Type         =   "Box"
  273.       Style        =   8
  274.       Location     =   "Subtotal Block"
  275.       Height       =   465
  276.       Left         =   4875
  277.       Top          =   315
  278.       Width        =   2970
  279. End
  280. Begin Control LABEL
  281.       Type         =   "Label"
  282.       Style        =   10
  283.       Caption      =   "STR(REPTOT(0),10,2)"
  284.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  285.       Location     =   "Subtotal Block"
  286.       Height       =   270
  287.       Left         =   5010
  288.       Top          =   420
  289.       Width        =   1215
  290. End
  291. Begin Control LABEL
  292.       Type         =   "Label"
  293.       Style        =   10
  294.       Caption      =   "STR(REPTOT(1),10,2)"
  295.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  296.       Location     =   "Subtotal Block"
  297.       Height       =   270
  298.       Left         =   6615
  299.       Top          =   420
  300.       Width        =   1215
  301. End
  302. Begin Control LABEL
  303.       Type         =   "Label"
  304.       Style        =   1
  305.       Caption      =   "Account Total"
  306.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  307.       Location     =   "Subtotal Block"
  308.       Height       =   270
  309.       Left         =   3165
  310.       Top          =   420
  311.       Width        =   1605
  312. End
  313. Begin Control LABEL
  314.       Type         =   "Label"
  315.       Style        =   1
  316.       Caption      =   "Input By:"
  317.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  318.       Location     =   "Subtotal Block"
  319.       Height       =   270
  320.       Left         =   150
  321.       Top          =   420
  322.       Width        =   930
  323. End
  324. Begin Control NRINPUTBY
  325.       Type         =   "Text"
  326.       Style        =   0
  327.       Fieldname    =   "NRINPUTBY"
  328.       Filename     =   "NLRECHD"
  329.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  330.       Location     =   "Subtotal Block"
  331.       Height       =   270
  332.       Left         =   1215
  333.       Top          =   420
  334.       Width        =   945
  335. End
  336. Begin Control LABEL
  337.       Type         =   "Label"
  338.       Style        =   1
  339.       Caption      =   "Totals"
  340.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  341.       Location     =   "Footer Block"
  342.       Height       =   270
  343.       Left         =   3435
  344.       Top          =   330
  345.       Width        =   885
  346. End
  347. Begin Control LABEL
  348.       Type         =   "Label"
  349.       Style        =   10
  350.       Caption      =   "STR(REPTOT(2),10,2)"
  351.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  352.       Location     =   "Footer Block"
  353.       Height       =   270
  354.       Left         =   4995
  355.       Top          =   465
  356.       Width        =   1215
  357. End
  358. Begin Control LABEL
  359.       Type         =   "Label"
  360.       Style        =   10
  361.       Caption      =   "STR(REPTOT(3),10,2)"
  362.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  363.       Location     =   "Footer Block"
  364.       Height       =   270
  365.       Left         =   6615
  366.       Top          =   450
  367.       Width        =   1215
  368. End
  369. Begin Control BOX
  370.       Type         =   "Box"
  371.       Style        =   8
  372.       Location     =   "Footer Block"
  373.       Height       =   45
  374.       Left         =   5010
  375.       Top          =   345
  376.       Width        =   2835
  377. End
  378. Begin Control BOX
  379.       Type         =   "Box"
  380.       Style        =   8
  381.       Location     =   "Footer Block"
  382.       Height       =   45
  383.       Left         =   5010
  384.       Top          =   750
  385.       Width        =   2835
  386. End
  387.