home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / NLPRJRNL.REP < prev    next >
Text File  |  1997-02-18  |  10KB  |  316 lines
  1. VERSION 2.00
  2. Begin Report NLPRJRNL.REP
  3.       Caption      =   "NLPRJRNL.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   1020
  7.       Header       =   825
  8.       Transaction  =   11505
  9.       SubTotal     =   1035
  10.       Footer       =   795
  11.       Pagefooter   =   15615
  12.       Replicate    =   330
  13.       Style        =   0
  14.       Query        =   "NLTRAN NLTRAN.NTTXNTYPE='9' ORDER BY RIGHT(NLTRAN.NTENTRYNO,5)"
  15.       Macro        =   "1LU:Select from NLJRNL where NJENTRYNO=NLTRAN.NTENTRYNO"
  16.       Macro        =   "2LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  17.       Macro        =   "2CD:When NLTRAN.NTVALUE=>0 then REPTOT(0)=REPTOT(0)+NLTRAN.NTVALUE"
  18.       Macro        =   "2CD:When NLTRAN.NTVALUE<0 then REPTOT(1)=REPTOT(1)+(NLTRAN.NTVALUE*-1)"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(1)"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  24.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  25.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  26.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  27.       BreakOn      =   "NLTRAN.NTENTRYNO"
  28.       Special      =   "TXNRANGE(NTENTRYNO,NTPOSTDATE)"
  29. End
  30. Begin Control LABEL
  31.       Type         =   "Label"
  32.       Style        =   4
  33.       Caption      =   "Imported Payroll Journals"
  34.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  35.       Location     =   "Reportheader Block"
  36.       Height       =   375
  37.       Left         =   0
  38.       Top          =   675
  39.       Width        =   11025
  40. End
  41. Begin Control LABEL
  42.       Type         =   "Label"
  43.       Style        =   9
  44.       Caption      =   "DTOC(DATE())"
  45.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  46.       Location     =   "Reportheader Block"
  47.       Height       =   285
  48.       Left         =   135
  49.       Top          =   705
  50.       Width        =   3825
  51. End
  52. Begin Control LABEL
  53.       Type         =   "Label"
  54.       Style        =   10
  55.       Caption      =   ""Page "+PAGENUM()"
  56.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  57.       Location     =   "Reportheader Block"
  58.       Height       =   285
  59.       Left         =   9180
  60.       Top          =   720
  61.       Width        =   1800
  62. End
  63. Begin Control LABEL
  64.       Type         =   "Label"
  65.       Style        =   12
  66.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  67.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  68.       Location     =   "Reportheader Block"
  69.       Height       =   270
  70.       Left         =   -15
  71.       Top          =   405
  72.       Width        =   11070
  73. End
  74. Begin Control LABEL
  75.       Type         =   "Label"
  76.       Style        =   2
  77.       Caption      =   "Debit"
  78.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  79.       Location     =   "Header Block"
  80.       Height       =   285
  81.       Left         =   4395
  82.       Top          =   510
  83.       Width        =   1410
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   2
  88.       Caption      =   "Credit"
  89.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  90.       Location     =   "Header Block"
  91.       Height       =   285
  92.       Left         =   6015
  93.       Top          =   510
  94.       Width        =   1410
  95. End
  96. Begin Control LABEL
  97.       Type         =   "Label"
  98.       Style        =   1
  99.       Caption      =   "Entry:"
  100.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Header Block"
  102.       Height       =   285
  103.       Left         =   90
  104.       Top          =   30
  105.       Width        =   600
  106. End
  107. Begin Control NJDATE
  108.       Type         =   "Text"
  109.       Style        =   0
  110.       Fieldname    =   "NJDATE"
  111.       Filename     =   "NLJRNL"
  112.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  113.       Location     =   "Header Block"
  114.       Height       =   270
  115.       Left         =   1530
  116.       Top          =   45
  117.       Width        =   1005
  118. End
  119. Begin Control NJNARATIVE
  120.       Type         =   "Text"
  121.       Style        =   0
  122.       Fieldname    =   "NJNARATIVE"
  123.       Filename     =   "NLJRNL"
  124.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  125.       Location     =   "Header Block"
  126.       Height       =   270
  127.       Left         =   2880
  128.       Top          =   45
  129.       Width        =   4110
  130. End
  131. Begin Control LABEL
  132.       Type         =   "Label"
  133.       Style        =   9
  134.       Caption      =   "mid(NLJRNL.NJENTRYNO+"         ",5,5)"
  135.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  136.       Location     =   "Header Block"
  137.       Height       =   285
  138.       Left         =   615
  139.       Top          =   60
  140.       Width        =   735
  141. End
  142. Begin Control NNACCNAME
  143.       Type         =   "Text"
  144.       Style        =   0
  145.       Fieldname    =   "NNACCNAME"
  146.       Filename     =   "NLNAME"
  147.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  148.       Location     =   "Transaction Block"
  149.       Height       =   270
  150.       Left         =   1155
  151.       Top          =   30
  152.       Width        =   2895
  153. End
  154. Begin Control NTCODE
  155.       Type         =   "Text"
  156.       Style        =   0
  157.       Fieldname    =   "NTCODE"
  158.       Filename     =   "NLTRAN"
  159.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  160.       Location     =   "Transaction Block"
  161.       Height       =   270
  162.       Left         =   45
  163.       Top          =   30
  164.       Width        =   1005
  165. End
  166. Begin Control LABEL
  167.       Type         =   "Label"
  168.       Style        =   10
  169.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  170.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  171.       Location     =   "Transaction Block"
  172.       Height       =   285
  173.       Left         =   4395
  174.       Top          =   45
  175.       Width        =   1410
  176. End
  177. Begin Control LABEL
  178.       Type         =   "Label"
  179.       Style        =   10
  180.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  181.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  182.       Location     =   "Transaction Block"
  183.       Height       =   285
  184.       Left         =   6015
  185.       Top          =   45
  186.       Width        =   1410
  187. End
  188. Begin Control NTCOMMENT
  189.       Type         =   "Text"
  190.       Style        =   0
  191.       Fieldname    =   "NTCOMMENT"
  192.       Filename     =   "NLTRAN"
  193.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  194.       Location     =   "Transaction Block"
  195.       Height       =   270
  196.       Left         =   8040
  197.       Top          =   30
  198.       Width        =   2895
  199. End
  200. Begin Control BOX
  201.       Type         =   "Box"
  202.       Style        =   8
  203.       Location     =   "Subtotal Block"
  204.       Height       =   465
  205.       Left         =   4605
  206.       Top          =   315
  207.       Width        =   2835
  208. End
  209. Begin Control LABEL
  210.       Type         =   "Label"
  211.       Style        =   10
  212.       Caption      =   "STR(REPTOT(0),10,2)"
  213.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  214.       Location     =   "Subtotal Block"
  215.       Height       =   270
  216.       Left         =   4605
  217.       Top          =   420
  218.       Width        =   1215
  219. End
  220. Begin Control LABEL
  221.       Type         =   "Label"
  222.       Style        =   10
  223.       Caption      =   "STR(REPTOT(1),10,2)"
  224.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  225.       Location     =   "Subtotal Block"
  226.       Height       =   270
  227.       Left         =   6210
  228.       Top          =   420
  229.       Width        =   1215
  230. End
  231. Begin Control LABEL
  232.       Type         =   "Label"
  233.       Style        =   2
  234.       Caption      =   "Account Total"
  235.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  236.       Location     =   "Subtotal Block"
  237.       Height       =   270
  238.       Left         =   2220
  239.       Top          =   420
  240.       Width        =   2010
  241. End
  242. Begin Control LABEL
  243.       Type         =   "Label"
  244.       Style        =   1
  245.       Caption      =   "Input By:"
  246.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  247.       Location     =   "Subtotal Block"
  248.       Height       =   270
  249.       Left         =   150
  250.       Top          =   420
  251.       Width        =   930
  252. End
  253. Begin Control NJINPUTBY
  254.       Type         =   "Text"
  255.       Style        =   0
  256.       Fieldname    =   "NJINPUTBY"
  257.       Filename     =   "NLJRNL"
  258.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  259.       Location     =   "Subtotal Block"
  260.       Height       =   270
  261.       Left         =   1080
  262.       Top          =   420
  263.       Width        =   945
  264. End
  265. Begin Control LABEL
  266.       Type         =   "Label"
  267.       Style        =   2
  268.       Caption      =   "Totals"
  269.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  270.       Location     =   "Footer Block"
  271.       Height       =   270
  272.       Left         =   3300
  273.       Top          =   465
  274.       Width        =   885
  275. End
  276. Begin Control LABEL
  277.       Type         =   "Label"
  278.       Style        =   10
  279.       Caption      =   "STR(REPTOT(2),10,2)"
  280.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  281.       Location     =   "Footer Block"
  282.       Height       =   270
  283.       Left         =   4590
  284.       Top          =   465
  285.       Width        =   1215
  286. End
  287. Begin Control LABEL
  288.       Type         =   "Label"
  289.       Style        =   10
  290.       Caption      =   "STR(REPTOT(3),10,2)"
  291.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  292.       Location     =   "Footer Block"
  293.       Height       =   270
  294.       Left         =   6210
  295.       Top          =   450
  296.       Width        =   1215
  297. End
  298. Begin Control BOX
  299.       Type         =   "Box"
  300.       Style        =   8
  301.       Location     =   "Footer Block"
  302.       Height       =   45
  303.       Left         =   4605
  304.       Top          =   345
  305.       Width        =   2835
  306. End
  307. Begin Control BOX
  308.       Type         =   "Box"
  309.       Style        =   8
  310.       Location     =   "Footer Block"
  311.       Height       =   45
  312.       Left         =   4605
  313.       Top          =   750
  314.       Width        =   2835
  315. End
  316.