home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / PLSUGGS.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  13.4 KB  |  407 lines
  1. VERSION 2.00
  2. Begin Report PLSUGGS.REP
  3.       Caption      =   "PLSUGGS.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   900
  7.       Header       =   780
  8.       Transaction  =   11670
  9.       SubTotal     =   1035
  10.       Footer       =   870
  11.       Pagefooter   =   15615
  12.       Replicate    =   345
  13.       Style        =   0
  14.       Query        =   "PLTRAN (PTTXNTYPE="I" & PTDUEDATE<DATE(0) | PTTXNTYPE<>"I" & PTTXNDATE<DATE(0)) &  PTALLOC=" " & PTDISP=" " ORDER BY PTCODE"
  15.       Macro        =   "1LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
  16.       Macro        =   "2OF:@REPVARS.REPTOT(1) = 0"
  17.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE<>"I" then SKIP 3"
  18.       Macro        =   "2CD:When (DATE(0)-PLTRAN.PTDUEDATE)<PLNAME.PNDAYS2 then REPTOT(0)=PLNAME.PNDISC2"
  19.       Macro        =   "2CD:When (DATE(0)-PLTRAN.PTDUEDATE)<PLNAME.PNDAYS1 then REPTOT(0)=PLNAME.PNDISC1"
  20.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(1)=REPTOT(0)*(PLTRAN.PTVALUE-PLTRAN.PTVAT)/100"
  21.       Macro        =   "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+PLTRAN.PTOUTSTAND"
  22.       Macro        =   "2OF:@REPVARS.REPTOT(2) = PLTRAN.PTOUTSTAND-REPTOT(1)"
  23.       Macro        =   "2OF:@REPVARS.REPTOT(4) = REPTOT(4)+REPTOT(1)"
  24.       Macro        =   "2OF:@REPVARS.REPTOT(5) = REPTOT(5)+REPTOT(2)"
  25.       Macro        =   "2PP:@REPVARS.REPTOT(1) = 0"
  26.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  27.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  28.       Macro        =   "3PP:@REPVARS.REPTOT(4) = 0"
  29.       Macro        =   "3PP:@REPVARS.REPTOT(5) = 0"
  30.       Macro        =   "3OF:@REPVARS.REPTOT(6) = REPTOT(6)+REPTOT(3)"
  31.       Macro        =   "3OF:@REPVARS.REPTOT(7) = REPTOT(7)+REPTOT(4)"
  32.       Macro        =   "3OF:@REPVARS.REPTOT(8) = REPTOT(8)+REPTOT(5)"
  33.       Macro        =   "4PP:@REPVARS.REPTOT(6) = 0"
  34.       Macro        =   "4PP:@REPVARS.REPTOT(7) = 0"
  35.       Macro        =   "4PP:@REPVARS.REPTOT(8) = 0"
  36.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  37.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  38.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  39.       BreakOn      =   "PLTRAN.PTCODE"
  40. End
  41. Begin Control LABEL
  42.       Type         =   "Label"
  43.       Style        =   4
  44.       Caption      =   "Suggested Payments List"
  45.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  46.       Location     =   "Reportheader Block"
  47.       Height       =   375
  48.       Left         =   0
  49.       Top          =   675
  50.       Width        =   11025
  51. End
  52. Begin Control LABEL
  53.       Type         =   "Label"
  54.       Style        =   9
  55.       Caption      =   "DTOC(DATE())"
  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         =   135
  60.       Top          =   705
  61.       Width        =   1800
  62. End
  63. Begin Control LABEL
  64.       Type         =   "Label"
  65.       Style        =   10
  66.       Caption      =   ""Page "+PAGENUM()"
  67.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  68.       Location     =   "Reportheader Block"
  69.       Height       =   285
  70.       Left         =   9180
  71.       Top          =   720
  72.       Width        =   1800
  73. End
  74. Begin Control LABEL
  75.       Type         =   "Label"
  76.       Style        =   12
  77.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  78.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  79.       Location     =   "Reportheader Block"
  80.       Height       =   270
  81.       Left         =   -15
  82.       Top          =   405
  83.       Width        =   11070
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   4
  88.       Caption      =   "Date"
  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         =   1020
  93.       Top          =   585
  94.       Width        =   1140
  95. End
  96. Begin Control LABEL
  97.       Type         =   "Label"
  98.       Style        =   1
  99.       Caption      =   "Discount"
  100.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Header Block"
  102.       Height       =   285
  103.       Left         =   3420
  104.       Top          =   585
  105.       Width        =   1005
  106. End
  107. Begin Control LABEL
  108.       Type         =   "Label"
  109.       Style        =   2
  110.       Caption      =   "Amount Due"
  111.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  112.       Location     =   "Header Block"
  113.       Height       =   285
  114.       Left         =   9405
  115.       Top          =   570
  116.       Width        =   1410
  117. End
  118. Begin Control LABEL
  119.       Type         =   "Label"
  120.       Style        =   2
  121.       Caption      =   "Outstanding"
  122.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  123.       Location     =   "Header Block"
  124.       Height       =   285
  125.       Left         =   6060
  126.       Top          =   585
  127.       Width        =   1410
  128. End
  129. Begin Control LABEL
  130.       Type         =   "Label"
  131.       Style        =   2
  132.       Caption      =   "Discount Amount"
  133.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  134.       Location     =   "Header Block"
  135.       Height       =   285
  136.       Left         =   7650
  137.       Top          =   585
  138.       Width        =   1545
  139. End
  140. Begin Control LABEL
  141.       Type         =   "Label"
  142.       Style        =   1
  143.       Caption      =   "Type"
  144.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  145.       Location     =   "Header Block"
  146.       Height       =   285
  147.       Left         =   2430
  148.       Top          =   585
  149.       Width        =   735
  150. End
  151. Begin Control PTCODE
  152.       Type         =   "Text"
  153.       Style        =   0
  154.       Fieldname    =   "PTCODE"
  155.       Filename     =   "PLTRAN"
  156.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  157.       Location     =   "Header Block"
  158.       Height       =   270
  159.       Left         =   105
  160.       Top          =   225
  161.       Width        =   1005
  162. End
  163. Begin Control PNNAME
  164.       Type         =   "Text"
  165.       Style        =   0
  166.       Fieldname    =   "PNNAME"
  167.       Filename     =   "PLNAME"
  168.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  169.       Location     =   "Header Block"
  170.       Height       =   270
  171.       Left         =   1365
  172.       Top          =   225
  173.       Width        =   4290
  174. End
  175. Begin Control LABEL
  176.       Type         =   "Label"
  177.       Style        =   1
  178.       Caption      =   "Reference"
  179.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   285
  182.       Left         =   45
  183.       Top          =   585
  184.       Width        =   1005
  185. End
  186. Begin Control PNPAYDAYS
  187.       Type         =   "Text"
  188.       Style        =   0
  189.       Fieldname    =   "PNPAYDAYS"
  190.       Filename     =   "PLNAME"
  191.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  192.       Location     =   "Header Block"
  193.       Height       =   270
  194.       Left         =   6015
  195.       Top          =   225
  196.       Width        =   1005
  197. End
  198. Begin Control LABEL
  199.       Type         =   "Label"
  200.       Style        =   1
  201.       Caption      =   "Days"
  202.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  203.       Location     =   "Header Block"
  204.       Height       =   270
  205.       Left         =   7095
  206.       Top          =   225
  207.       Width        =   810
  208. End
  209. Begin Control LABEL
  210.       Type         =   "Label"
  211.       Style        =   2
  212.       Caption      =   "Invoiced Amount"
  213.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  214.       Location     =   "Header Block"
  215.       Height       =   285
  216.       Left         =   4575
  217.       Top          =   585
  218.       Width        =   1410
  219. End
  220. Begin Control PTTXNDATE
  221.       Type         =   "Text"
  222.       Style        =   0
  223.       Fieldname    =   "PTTXNDATE"
  224.       Filename     =   "PLTRAN"
  225.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  226.       Location     =   "Transaction Block"
  227.       Height       =   270
  228.       Left         =   1155
  229.       Top          =   60
  230.       Width        =   1140
  231. End
  232. Begin Control PTREF
  233.       Type         =   "Text"
  234.       Style        =   0
  235.       Fieldname    =   "PTREF"
  236.       Filename     =   "PLTRAN"
  237.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Transaction Block"
  239.       Height       =   270
  240.       Left         =   45
  241.       Top          =   60
  242.       Width        =   1005
  243. End
  244. Begin Control LABEL
  245.       Type         =   "Label"
  246.       Style        =   10
  247.       Caption      =   "IF(PLTRAN.PTTXNTYPE="I",STR(REPTOT(1),10,2)," ")"
  248.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  249.       Location     =   "Transaction Block"
  250.       Height       =   270
  251.       Left         =   7830
  252.       Top          =   75
  253.       Width        =   1350
  254. End
  255. Begin Control LABEL
  256.       Type         =   "Label"
  257.       Style        =   9
  258.       Caption      =   "MID("   InvCrnPayAdjDscRfd",INSTR("ICPADF",PLTRAN.PTTXNTYPE)*3+1,3)"
  259.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  260.       Location     =   "Transaction Block"
  261.       Height       =   270
  262.       Left         =   2430
  263.       Top          =   75
  264.       Width        =   810
  265. End
  266. Begin Control LABEL
  267.       Type         =   "Label"
  268.       Style        =   9
  269.       Caption      =   "IF(PLTRAN.PTTXNTYPE="I",STR(REPTOT(0),5,2)+"%"," ")"
  270.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  271.       Location     =   "Transaction Block"
  272.       Height       =   270
  273.       Left         =   3375
  274.       Top          =   75
  275.       Width        =   675
  276. End
  277. Begin Control LABEL
  278.       Type         =   "Label"
  279.       Style        =   10
  280.       Caption      =   "STR(REPTOT(2),10,2)"
  281.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  282.       Location     =   "Transaction Block"
  283.       Height       =   270
  284.       Left         =   9450
  285.       Top          =   75
  286.       Width        =   1350
  287. End
  288. Begin Control LABEL
  289.       Type         =   "Label"
  290.       Style        =   10
  291.       Caption      =   "STR(PLTRAN.PTOUTSTAND,10,2)"
  292.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  293.       Location     =   "Transaction Block"
  294.       Height       =   270
  295.       Left         =   6075
  296.       Top          =   75
  297.       Width        =   1350
  298. End
  299. Begin Control LABEL
  300.       Type         =   "Label"
  301.       Style        =   10
  302.       Caption      =   "STR(PLTRAN.PTVALUE,10,2)"
  303.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  304.       Location     =   "Transaction Block"
  305.       Height       =   270
  306.       Left         =   4590
  307.       Top          =   75
  308.       Width        =   1350
  309. End
  310. Begin Control LABEL
  311.       Type         =   "Label"
  312.       Style        =   10
  313.       Caption      =   "STR(REPTOT(3),10,2)"
  314.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  315.       Location     =   "Subtotal Block"
  316.       Height       =   270
  317.       Left         =   6345
  318.       Top          =   435
  319.       Width        =   1080
  320. End
  321. Begin Control LABEL
  322.       Type         =   "Label"
  323.       Style        =   10
  324.       Caption      =   "STR(REPTOT(4),10,2)"
  325.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  326.       Location     =   "Subtotal Block"
  327.       Height       =   270
  328.       Left         =   8085
  329.       Top          =   435
  330.       Width        =   1080
  331. End
  332. Begin Control LABEL
  333.       Type         =   "Label"
  334.       Style        =   10
  335.       Caption      =   "STR(REPTOT(5),10,2)"
  336.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  337.       Location     =   "Subtotal Block"
  338.       Height       =   270
  339.       Left         =   9720
  340.       Top          =   450
  341.       Width        =   1080
  342. End
  343. Begin Control LABEL
  344.       Type         =   "Label"
  345.       Style        =   2
  346.       Caption      =   "Account Total"
  347.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  348.       Location     =   "Subtotal Block"
  349.       Height       =   270
  350.       Left         =   2445
  351.       Top          =   420
  352.       Width        =   2010
  353. End
  354. Begin Control BOX
  355.       Type         =   "Box"
  356.       Style        =   2
  357.       Location     =   "Footer Block"
  358.       Height       =   540
  359.       Left         =   4320
  360.       Top          =   330
  361.       Width        =   6615
  362. End
  363. Begin Control LABEL
  364.       Type         =   "Label"
  365.       Style        =   2
  366.       Caption      =   "Totals"
  367.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  368.       Location     =   "Footer Block"
  369.       Height       =   270
  370.       Left         =   4455
  371.       Top          =   465
  372.       Width        =   1350
  373. End
  374. Begin Control LABEL
  375.       Type         =   "Label"
  376.       Style        =   10
  377.       Caption      =   "STR(REPTOT(6),10,2)"
  378.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  379.       Location     =   "Footer Block"
  380.       Height       =   270
  381.       Left         =   6345
  382.       Top          =   465
  383.       Width        =   1080
  384. End
  385. Begin Control LABEL
  386.       Type         =   "Label"
  387.       Style        =   10
  388.       Caption      =   "STR(REPTOT(8),10,2)"
  389.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  390.       Location     =   "Footer Block"
  391.       Height       =   270
  392.       Left         =   9720
  393.       Top          =   450
  394.       Width        =   1080
  395. End
  396. Begin Control LABEL
  397.       Type         =   "Label"
  398.       Style        =   10
  399.       Caption      =   "STR(REPTOT(7),10,2)"
  400.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  401.       Location     =   "Footer Block"
  402.       Height       =   270
  403.       Left         =   8100
  404.       Top          =   450
  405.       Width        =   1080
  406. End
  407.