home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / VATSOUT.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  13.4 KB  |  427 lines
  1. VERSION 2.00
  2. Begin Report VATSOUT.REP
  3.       Caption      =   "VATSOUT.REP"
  4.       Width        =   11175
  5.       Height       =   16185
  6.       Reportheader =   1080
  7.       Header       =   675
  8.       Transaction  =   13080
  9.       SubTotal     =   105
  10.       Footer       =   990
  11.       Pagefooter   =   15960
  12.       Replicate    =   405
  13.       Style        =   0
  14.       Query        =   "SLTRAN (STTYPE="I" | STTYPE="C") & STVATOUT<>0"
  15.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(1)=REPTOT(1)+SLTRAN.STVATOUT"
  16.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(0)=REPTOT(0)+SLTRAN.STOUTSTAND"
  17.       Macro        =   "2LU:Select from SLNAME where SNACCOUNT=SLTRAN.STACCOUNT"
  18.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(2)=REPTOT(2)+SLTRAN.STOUTSTAND"
  19.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(3)=REPTOT(3)+SLTRAN.STVATOUT"
  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. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   4
  28.       Caption      =   "Sales VAT Outstanding"
  29.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Reportheader Block"
  31.       Height       =   420
  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        =   1800
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   10
  50.       Caption      =   "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         =   10395
  55.       Top          =   720
  56.       Width        =   585
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   2
  61.       Caption      =   "Page:"
  62.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   285
  65.       Left         =   9720
  66.       Top          =   720
  67.       Width        =   585
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   12
  72.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  73.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Reportheader Block"
  75.       Height       =   270
  76.       Left         =   -15
  77.       Top          =   405
  78.       Width        =   11070
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   1
  83.       Caption      =   "Customer ID"
  84.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Header Block"
  86.       Height       =   285
  87.       Left         =   135
  88.       Top          =   270
  89.       Width        =   1140
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   4
  94.       Caption      =   "Date"
  95.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   285
  98.       Left         =   1425
  99.       Top          =   270
  100.       Width        =   735
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   1
  105.       Caption      =   "Reference"
  106.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   285
  109.       Left         =   3285
  110.       Top          =   270
  111.       Width        =   1005
  112. End
  113. Begin Control LABEL
  114.       Type         =   "Label"
  115.       Style        =   4
  116.       Caption      =   "VAT"
  117.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   285
  120.       Left         =   7110
  121.       Top          =   255
  122.       Width        =   465
  123. End
  124. Begin Control LABEL
  125.       Type         =   "Label"
  126.       Style        =   4
  127.       Caption      =   "Value"
  128.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   285
  131.       Left         =   4710
  132.       Top          =   270
  133.       Width        =   735
  134. End
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   4
  138.       Caption      =   "Goods"
  139.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  140.       Location     =   "Header Block"
  141.       Height       =   285
  142.       Left         =   5895
  143.       Top          =   270
  144.       Width        =   735
  145. End
  146. Begin Control LABEL
  147.       Type         =   "Label"
  148.       Style        =   4
  149.       Caption      =   "Type"
  150.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  151.       Location     =   "Header Block"
  152.       Height       =   285
  153.       Left         =   2475
  154.       Top          =   270
  155.       Width        =   600
  156. End
  157. Begin Control LABEL
  158.       Type         =   "Label"
  159.       Style        =   1
  160.       Caption      =   "Customer Name"
  161.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  162.       Location     =   "Header Block"
  163.       Height       =   285
  164.       Left         =   8025
  165.       Top          =   270
  166.       Width        =   1545
  167. End
  168. Begin Control LABEL
  169.       Type         =   "Label"
  170.       Style        =   4
  171.       Caption      =   "Outstanding"
  172.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  173.       Location     =   "Header Block"
  174.       Height       =   285
  175.       Left         =   4440
  176.       Top          =   510
  177.       Width        =   1140
  178. End
  179. Begin Control LABEL
  180.       Type         =   "Label"
  181.       Style        =   4
  182.       Caption      =   "Outstanding"
  183.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  184.       Location     =   "Header Block"
  185.       Height       =   285
  186.       Left         =   5655
  187.       Top          =   510
  188.       Width        =   1140
  189. End
  190. Begin Control LABEL
  191.       Type         =   "Label"
  192.       Style        =   4
  193.       Caption      =   "Outstanding"
  194.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  195.       Location     =   "Header Block"
  196.       Height       =   285
  197.       Left         =   6720
  198.       Top          =   510
  199.       Width        =   1140
  200. End
  201. Begin Control STACCOUNT
  202.       Type         =   "Text"
  203.       Style        =   0
  204.       Fieldname    =   "STACCOUNT"
  205.       Filename     =   "SLTRAN"
  206.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Transaction Block"
  208.       Height       =   270
  209.       Left         =   135
  210.       Top          =   120
  211.       Width        =   1005
  212. End
  213. Begin Control STTXNDATE
  214.       Type         =   "Text"
  215.       Style        =   0
  216.       Fieldname    =   "STTXNDATE"
  217.       Filename     =   "SLTRAN"
  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          =   120
  223.       Width        =   1140
  224. End
  225. Begin Control STREF
  226.       Type         =   "Text"
  227.       Style        =   0
  228.       Fieldname    =   "STREF"
  229.       Filename     =   "SLTRAN"
  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         =   3285
  234.       Top          =   120
  235.       Width        =   1005
  236. End
  237. Begin Control STOUTSTAND
  238.       Type         =   "Text"
  239.       Style        =   0
  240.       Fieldname    =   "STOUTSTAND"
  241.       Filename     =   "SLTRAN"
  242.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  243.       Location     =   "Transaction Block"
  244.       Height       =   270
  245.       Left         =   4440
  246.       Top          =   120
  247.       Width        =   1005
  248. End
  249. Begin Control STVATOUT
  250.       Type         =   "Text"
  251.       Style        =   0
  252.       Fieldname    =   "STVATOUT"
  253.       Filename     =   "SLTRAN"
  254.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  255.       Location     =   "Transaction Block"
  256.       Height       =   270
  257.       Left         =   6675
  258.       Top          =   120
  259.       Width        =   1005
  260. End
  261. Begin Control LABEL
  262.       Type         =   "Label"
  263.       Style        =   10
  264.       Caption      =   "STR(SLTRAN.STOUTSTAND-SLTRAN.STVATOUT,10,2)"
  265.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  266.       Location     =   "Transaction Block"
  267.       Height       =   270
  268.       Left         =   5535
  269.       Top          =   135
  270.       Width        =   1080
  271. End
  272. Begin Control LABEL
  273.       Type         =   "Label"
  274.       Style        =   9
  275.       Caption      =   "IF(SLTRAN.STTYPE="I","Invce","Cnote")"
  276.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  277.       Location     =   "Transaction Block"
  278.       Height       =   270
  279.       Left         =   2565
  280.       Top          =   135
  281.       Width        =   675
  282. End
  283. Begin Control SNNAME
  284.       Type         =   "Text"
  285.       Style        =   0
  286.       Fieldname    =   "SNNAME"
  287.       Filename     =   "SLNAME"
  288.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  289.       Location     =   "Transaction Block"
  290.       Height       =   270
  291.       Left         =   7830
  292.       Top          =   120
  293.       Width        =   3075
  294. End
  295. Begin Control LABEL
  296.       Type         =   "Label"
  297.       Style        =   10
  298.       Caption      =   "STR(REPTOT(1),10,2)"
  299.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  300.       Location     =   "Footer Block"
  301.       Height       =   270
  302.       Left         =   6600
  303.       Top          =   180
  304.       Width        =   1080
  305. End
  306. Begin Control LABEL
  307.       Type         =   "Label"
  308.       Style        =   10
  309.       Caption      =   "STR(REPTOT(0)-REPTOT(1),10,2)"
  310.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  311.       Location     =   "Footer Block"
  312.       Height       =   270
  313.       Left         =   5535
  314.       Top          =   180
  315.       Width        =   1080
  316. End
  317. Begin Control LABEL
  318.       Type         =   "Label"
  319.       Style        =   10
  320.       Caption      =   "STR(REPTOT(0),10,2)"
  321.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  322.       Location     =   "Footer Block"
  323.       Height       =   270
  324.       Left         =   4365
  325.       Top          =   180
  326.       Width        =   1080
  327. End
  328. Begin Control LABEL
  329.       Type         =   "Label"
  330.       Style        =   1
  331.       Caption      =   "Total Invoices"
  332.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  333.       Location     =   "Footer Block"
  334.       Height       =   270
  335.       Left         =   2430
  336.       Top          =   180
  337.       Width        =   1620
  338. End
  339. Begin Control LABEL
  340.       Type         =   "Label"
  341.       Style        =   1
  342.       Caption      =   "Total Credits"
  343.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  344.       Location     =   "Footer Block"
  345.       Height       =   270
  346.       Left         =   2430
  347.       Top          =   450
  348.       Width        =   1620
  349. End
  350. Begin Control LABEL
  351.       Type         =   "Label"
  352.       Style        =   10
  353.       Caption      =   "STR(REPTOT(2),10,2)"
  354.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  355.       Location     =   "Footer Block"
  356.       Height       =   270
  357.       Left         =   4365
  358.       Top          =   435
  359.       Width        =   1080
  360. End
  361. Begin Control LABEL
  362.       Type         =   "Label"
  363.       Style        =   10
  364.       Caption      =   "STR(REPTOT(2)-REPTOT(3),10,2)"
  365.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  366.       Location     =   "Footer Block"
  367.       Height       =   270
  368.       Left         =   5535
  369.       Top          =   465
  370.       Width        =   1080
  371. End
  372. Begin Control LABEL
  373.       Type         =   "Label"
  374.       Style        =   10
  375.       Caption      =   "STR(REPTOT(3),10,2)"
  376.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  377.       Location     =   "Footer Block"
  378.       Height       =   270
  379.       Left         =   6600
  380.       Top          =   450
  381.       Width        =   1080
  382. End
  383. Begin Control LABEL
  384.       Type         =   "Label"
  385.       Style        =   1
  386.       Caption      =   "Total"
  387.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  388.       Location     =   "Footer Block"
  389.       Height       =   270
  390.       Left         =   2430
  391.       Top          =   720
  392.       Width        =   1620
  393. End
  394. Begin Control LABEL
  395.       Type         =   "Label"
  396.       Style        =   10
  397.       Caption      =   "STR(REPTOT(2)+REPTOT(0),10,2)"
  398.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  399.       Location     =   "Footer Block"
  400.       Height       =   270
  401.       Left         =   4365
  402.       Top          =   720
  403.       Width        =   1080
  404. End
  405. Begin Control LABEL
  406.       Type         =   "Label"
  407.       Style        =   10
  408.       Caption      =   "STR(REPTOT(0)+REPTOT(2)-REPTOT(1)-REPTOT(3),10,2)"
  409.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  410.       Location     =   "Footer Block"
  411.       Height       =   270
  412.       Left         =   5535
  413.       Top          =   720
  414.       Width        =   1080
  415. End
  416. Begin Control LABEL
  417.       Type         =   "Label"
  418.       Style        =   10
  419.       Caption      =   "STR(REPTOT(1)+REPTOT(3),10,2)"
  420.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  421.       Location     =   "Footer Block"
  422.       Height       =   270
  423.       Left         =   6600
  424.       Top          =   720
  425.       Width        =   1080
  426. End
  427.