home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / SLAUDIT1.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  8.6 KB  |  278 lines
  1. VERSION 2.00
  2. Begin Report SLAUDIT1.REP
  3.       Caption      =   "SLAUDIT1.REP"
  4.       Width        =   11175
  5.       Height       =   15825
  6.       Reportheader =   1155
  7.       Header       =   480
  8.       Transaction  =   11715
  9.       SubTotal     =   1035
  10.       Footer       =   660
  11.       Pagefooter   =   15615
  12.       Replicate    =   405
  13.       Style        =   0
  14.       Query        =   "NLTRAN NLTRAN.NTAUDIT="A" ORDER BY NLTRAN.NTCODE"
  15.       Macro        =   "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  16.       Macro        =   "2SQ:Select from SLANDT where SANOMACC+SANOMBATCH=NLTRAN.NTCODE+NLTRAN.NTENTRYNO"
  17.       Macro        =   "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+SLANDT.SAVALUE*-1"
  18.       Macro        =   "3PP:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  20.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  22.       BreakOn      =   "NLTRAN.NTCODE"
  23.       Special      =   "TXNRANGE(NTENTRYNO,NTPOSTDATE)"
  24. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   4
  28.       Caption      =   "Analysis of Sales Invoices & Credits"
  29.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Reportheader Block"
  31.       Height       =   375
  32.       Left         =   0
  33.       Top          =   675
  34.       Width        =   11025
  35. End
  36. Begin Control LABEL
  37.       Type         =   "Label"
  38.       Style        =   9
  39.       Caption      =   "DTOC(DATE())"
  40.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Reportheader Block"
  42.       Height       =   285
  43.       Left         =   135
  44.       Top          =   705
  45.       Width        =   3285
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   10
  50.       Caption      =   ""Page "+PAGENUM()"
  51.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  52.       Location     =   "Reportheader Block"
  53.       Height       =   285
  54.       Left         =   9180
  55.       Top          =   720
  56.       Width        =   1800
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   12
  61.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  62.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   270
  65.       Left         =   -15
  66.       Top          =   405
  67.       Width        =   11070
  68. End
  69. Begin Control NNACCNAME
  70.       Type         =   "Text"
  71.       Style        =   0
  72.       Fieldname    =   "NNACCNAME"
  73.       Filename     =   "NLNAME"
  74.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  75.       Location     =   "Header Block"
  76.       Height       =   270
  77.       Left         =   1155
  78.       Top          =   45
  79.       Width        =   2760
  80. End
  81. Begin Control NNACCOUNT
  82.       Type         =   "Text"
  83.       Style        =   0
  84.       Fieldname    =   "NNACCOUNT"
  85.       Filename     =   "NLNAME"
  86.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  87.       Location     =   "Header Block"
  88.       Height       =   270
  89.       Left         =   45
  90.       Top          =   45
  91.       Width        =   1005
  92. End
  93. Begin Control LABEL
  94.       Type         =   "Label"
  95.       Style        =   1
  96.       Caption      =   "Entry"
  97.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  98.       Location     =   "Header Block"
  99.       Height       =   285
  100.       Left         =   75
  101.       Top          =   330
  102.       Width        =   600
  103. End
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   1
  107.       Caption      =   "Reference"
  108.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  109.       Location     =   "Header Block"
  110.       Height       =   285
  111.       Left         =   1965
  112.       Top          =   330
  113.       Width        =   1140
  114. End
  115. Begin Control LABEL
  116.       Type         =   "Label"
  117.       Style        =   1
  118.       Caption      =   "Account"
  119.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  120.       Location     =   "Header Block"
  121.       Height       =   285
  122.       Left         =   3585
  123.       Top          =   330
  124.       Width        =   1140
  125. End
  126. Begin Control LABEL
  127.       Type         =   "Label"
  128.       Style        =   2
  129.       Caption      =   "Value"
  130.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  131.       Location     =   "Header Block"
  132.       Height       =   285
  133.       Left         =   5340
  134.       Top          =   330
  135.       Width        =   1140
  136. End
  137. Begin Control LABEL
  138.       Type         =   "Label"
  139.       Style        =   1
  140.       Caption      =   "Date"
  141.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  142.       Location     =   "Header Block"
  143.       Height       =   285
  144.       Left         =   885
  145.       Top          =   330
  146.       Width        =   870
  147. End
  148. Begin Control SAREF
  149.       Type         =   "Text"
  150.       Style        =   0
  151.       Fieldname    =   "SAREF"
  152.       Filename     =   "SLANDT"
  153.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  154.       Location     =   "Transaction Block"
  155.       Height       =   270
  156.       Left         =   1965
  157.       Top          =   105
  158.       Width        =   1410
  159. End
  160. Begin Control SADATE
  161.       Type         =   "Text"
  162.       Style        =   0
  163.       Fieldname    =   "SADATE"
  164.       Filename     =   "SLANDT"
  165.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  166.       Location     =   "Transaction Block"
  167.       Height       =   270
  168.       Left         =   855
  169.       Top          =   105
  170.       Width        =   1005
  171. End
  172. Begin Control LABEL
  173.       Type         =   "Label"
  174.       Style        =   10
  175.       Caption      =   "STR(SLANDT.SAVALUE*-1,10,2)"
  176.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  177.       Location     =   "Transaction Block"
  178.       Height       =   285
  179.       Left         =   5070
  180.       Top          =   120
  181.       Width        =   1410
  182. End
  183. Begin Control SAACCOUNT
  184.       Type         =   "Text"
  185.       Style        =   0
  186.       Fieldname    =   "SAACCOUNT"
  187.       Filename     =   "SLANDT"
  188.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  189.       Location     =   "Transaction Block"
  190.       Height       =   270
  191.       Left         =   3585
  192.       Top          =   105
  193.       Width        =   1275
  194. End
  195. Begin Control LABEL
  196.       Type         =   "Label"
  197.       Style        =   9
  198.       Caption      =   "mid(NLTRAN.NTENTRYNO,5,5)"
  199.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  200.       Location     =   "Transaction Block"
  201.       Height       =   285
  202.       Left         =   75
  203.       Top          =   120
  204.       Width        =   870
  205. End
  206. Begin Control SACOMMENT
  207.       Type         =   "Text"
  208.       Style        =   0
  209.       Fieldname    =   "SACOMMENT"
  210.       Filename     =   "SLANDT"
  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         =   6690
  215.       Top          =   105
  216.       Width        =   3030
  217. End
  218. Begin Control BOX
  219.       Type         =   "Box"
  220.       Style        =   8
  221.       Location     =   "Subtotal Block"
  222.       Height       =   465
  223.       Left         =   5010
  224.       Top          =   180
  225.       Width        =   1485
  226. End
  227. Begin Control LABEL
  228.       Type         =   "Label"
  229.       Style        =   10
  230.       Caption      =   "STR(REPTOT(0),10,2)"
  231.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  232.       Location     =   "Subtotal Block"
  233.       Height       =   270
  234.       Left         =   5145
  235.       Top          =   285
  236.       Width        =   1350
  237. End
  238. Begin Control LABEL
  239.       Type         =   "Label"
  240.       Style        =   1
  241.       Caption      =   "Totals"
  242.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  243.       Location     =   "Footer Block"
  244.       Height       =   270
  245.       Left         =   3840
  246.       Top          =   330
  247.       Width        =   885
  248. End
  249. Begin Control LABEL
  250.       Type         =   "Label"
  251.       Style        =   10
  252.       Caption      =   "STR(REPTOT(1),10,2)"
  253.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  254.       Location     =   "Footer Block"
  255.       Height       =   270
  256.       Left         =   5265
  257.       Top          =   330
  258.       Width        =   1215
  259. End
  260. Begin Control BOX
  261.       Type         =   "Box"
  262.       Style        =   8
  263.       Location     =   "Footer Block"
  264.       Height       =   45
  265.       Left         =   5280
  266.       Top          =   210
  267.       Width        =   1215
  268. End
  269. Begin Control BOX
  270.       Type         =   "Box"
  271.       Style        =   8
  272.       Location     =   "Footer Block"
  273.       Height       =   45
  274.       Left         =   5280
  275.       Top          =   615
  276.       Width        =   1215
  277. End
  278.