home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / PLINVCRE.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  12.5 KB  |  395 lines
  1. VERSION 2.00
  2. Begin Report PLINVCRE.REP
  3.       Caption      =   "PLINVCRE.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   975
  7.       Header       =   570
  8.       Transaction  =   12795
  9.       SubTotal     =   45
  10.       Footer       =   1140
  11.       Pagefooter   =   15615
  12.       Replicate    =   345
  13.       Style        =   0
  14.       Query        =   "PLTRAN PTTXNTYPE="I" | PTTXNTYPE="C""
  15.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(1)=REPTOT(1)+PLTRAN.PTVAT"
  16.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(0)=REPTOT(0)+PLTRAN.PTVALUE"
  17.       Macro        =   "2LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
  18.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="C" then REPTOT(2)=REPTOT(2)+PLTRAN.PTVALUE"
  19.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="C" then REPTOT(3)=REPTOT(3)+PLTRAN.PTVAT"
  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(PTBATCHNO,PTDATE)"
  25. End
  26. Begin Control LABEL
  27.       Type         =   "Label"
  28.       Style        =   4
  29.       Caption      =   "Purchase Invoices and Credit Notes"
  30.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  31.       Location     =   "Reportheader Block"
  32.       Height       =   285
  33.       Left         =   0
  34.       Top          =   675
  35.       Width        =   11025
  36. End
  37. Begin Control LABEL
  38.       Type         =   "Label"
  39.       Style        =   9
  40.       Caption      =   "DTOC(DATE())"
  41.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  42.       Location     =   "Reportheader Block"
  43.       Height       =   285
  44.       Left         =   135
  45.       Top          =   705
  46.       Width        =   2880
  47. End
  48. Begin Control LABEL
  49.       Type         =   "Label"
  50.       Style        =   10
  51.       Caption      =   "PAGENUM()"
  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         =   10395
  56.       Top          =   720
  57.       Width        =   585
  58. End
  59. Begin Control LABEL
  60.       Type         =   "Label"
  61.       Style        =   2
  62.       Caption      =   "Page:"
  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         =   9720
  67.       Top          =   720
  68.       Width        =   585
  69. End
  70. Begin Control LABEL
  71.       Type         =   "Label"
  72.       Style        =   12
  73.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  74.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  75.       Location     =   "Reportheader Block"
  76.       Height       =   270
  77.       Left         =   -15
  78.       Top          =   405
  79.       Width        =   11070
  80. End
  81. Begin Control LABEL
  82.       Type         =   "Label"
  83.       Style        =   1
  84.       Caption      =   "Supplier ID"
  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         =   0
  89.       Top          =   240
  90.       Width        =   1140
  91. End
  92. Begin Control LABEL
  93.       Type         =   "Label"
  94.       Style        =   4
  95.       Caption      =   "Date"
  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         =   1155
  100.       Top          =   240
  101.       Width        =   1140
  102. End
  103. Begin Control LABEL
  104.       Type         =   "Label"
  105.       Style        =   1
  106.       Caption      =   "Reference"
  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         =   3285
  111.       Top          =   240
  112.       Width        =   1005
  113. End
  114. Begin Control LABEL
  115.       Type         =   "Label"
  116.       Style        =   2
  117.       Caption      =   "VAT"
  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         =   6705
  122.       Top          =   225
  123.       Width        =   1005
  124. End
  125. Begin Control LABEL
  126.       Type         =   "Label"
  127.       Style        =   2
  128.       Caption      =   "Value"
  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         =   4440
  133.       Top          =   240
  134.       Width        =   1005
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   2
  139.       Caption      =   "Goods"
  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         =   5625
  144.       Top          =   240
  145.       Width        =   1005
  146. End
  147. Begin Control LABEL
  148.       Type         =   "Label"
  149.       Style        =   1
  150.       Caption      =   "Type"
  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         =   2475
  155.       Top          =   240
  156.       Width        =   735
  157. End
  158. Begin Control LABEL
  159.       Type         =   "Label"
  160.       Style        =   1
  161.       Caption      =   "Supplier Name"
  162.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  163.       Location     =   "Header Block"
  164.       Height       =   285
  165.       Left         =   8025
  166.       Top          =   240
  167.       Width        =   2085
  168. End
  169. Begin Control PTCODE
  170.       Type         =   "Text"
  171.       Style        =   0
  172.       Fieldname    =   "PTCODE"
  173.       Filename     =   "PLTRAN"
  174.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  175.       Location     =   "Transaction Block"
  176.       Height       =   270
  177.       Left         =   0
  178.       Top          =   60
  179.       Width        =   1005
  180. End
  181. Begin Control PTTXNDATE
  182.       Type         =   "Text"
  183.       Style        =   0
  184.       Fieldname    =   "PTTXNDATE"
  185.       Filename     =   "PLTRAN"
  186.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  187.       Location     =   "Transaction Block"
  188.       Height       =   270
  189.       Left         =   1155
  190.       Top          =   60
  191.       Width        =   1140
  192. End
  193. Begin Control PTREF
  194.       Type         =   "Text"
  195.       Style        =   0
  196.       Fieldname    =   "PTREF"
  197.       Filename     =   "PLTRAN"
  198.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  199.       Location     =   "Transaction Block"
  200.       Height       =   270
  201.       Left         =   3285
  202.       Top          =   60
  203.       Width        =   1005
  204. End
  205. Begin Control PTVALUE
  206.       Type         =   "Text"
  207.       Style        =   0
  208.       Fieldname    =   "PTVALUE"
  209.       Filename     =   "PLTRAN"
  210.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  211.       Location     =   "Transaction Block"
  212.       Height       =   270
  213.       Left         =   4440
  214.       Top          =   60
  215.       Width        =   1005
  216. End
  217. Begin Control PTVAT
  218.       Type         =   "Text"
  219.       Style        =   0
  220.       Fieldname    =   "PTVAT"
  221.       Filename     =   "PLTRAN"
  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         =   6675
  226.       Top          =   60
  227.       Width        =   1005
  228. End
  229. Begin Control LABEL
  230.       Type         =   "Label"
  231.       Style        =   10
  232.       Caption      =   "STR(PLTRAN.PTVALUE-PLTRAN.PTVAT,10,2)"
  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         =   5535
  237.       Top          =   75
  238.       Width        =   1080
  239. End
  240. Begin Control LABEL
  241.       Type         =   "Label"
  242.       Style        =   9
  243.       Caption      =   "IF(PLTRAN.PTTXNTYPE="I","Invce","Cnote")"
  244.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  245.       Location     =   "Transaction Block"
  246.       Height       =   270
  247.       Left         =   2430
  248.       Top          =   75
  249.       Width        =   675
  250. End
  251. Begin Control PNNAME
  252.       Type         =   "Text"
  253.       Style        =   0
  254.       Fieldname    =   "PNNAME"
  255.       Filename     =   "PLNAME"
  256.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Transaction Block"
  258.       Height       =   270
  259.       Left         =   7965
  260.       Top          =   60
  261.       Width        =   3075
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   10
  266.       Caption      =   "STR(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         =   6615
  271.       Top          =   330
  272.       Width        =   1080
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "STR(REPTOT(0)-REPTOT(1),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         =   5535
  282.       Top          =   330
  283.       Width        =   1080
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   10
  288.       Caption      =   "STR(REPTOT(0),10,2)"
  289.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Footer Block"
  291.       Height       =   270
  292.       Left         =   4380
  293.       Top          =   330
  294.       Width        =   1080
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   1
  299.       Caption      =   "Total Invoices"
  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          =   330
  305.       Width        =   1620
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   1
  310.       Caption      =   "Total Credits"
  311.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  312.       Location     =   "Footer Block"
  313.       Height       =   270
  314.       Left         =   2430
  315.       Top          =   600
  316.       Width        =   1620
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   10
  321.       Caption      =   "STR(REPTOT(2),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         =   4380
  326.       Top          =   585
  327.       Width        =   1080
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   10
  332.       Caption      =   "STR(REPTOT(2)-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         =   5535
  337.       Top          =   600
  338.       Width        =   1080
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   10
  343.       Caption      =   "STR(REPTOT(3),10,2)"
  344.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  345.       Location     =   "Footer Block"
  346.       Height       =   270
  347.       Left         =   6615
  348.       Top          =   600
  349.       Width        =   1080
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   1
  354.       Caption      =   "Total"
  355.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Footer Block"
  357.       Height       =   270
  358.       Left         =   2430
  359.       Top          =   870
  360.       Width        =   1620
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   10
  365.       Caption      =   "STR(REPTOT(2)+REPTOT(0),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         =   4365
  370.       Top          =   870
  371.       Width        =   1080
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "STR(REPTOT(0)+REPTOT(2)-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         =   5535
  381.       Top          =   870
  382.       Width        =   1080
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   10
  387.       Caption      =   "STR(REPTOT(1)+REPTOT(3),10,2)"
  388.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Footer Block"
  390.       Height       =   270
  391.       Left         =   6615
  392.       Top          =   870
  393.       Width        =   1080
  394. End
  395.