home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / VATPL-C.REP < prev    next >
Text File  |  1995-06-21  |  10KB  |  296 lines
  1. VERSION 2.00
  2. Begin Report VATPL-C.REP
  3.       Caption      =   "VATPL-C.REP"
  4.       Width        =   11175
  5.       Height       =   15915
  6.       Reportheader =   1545
  7.       Header       =   465
  8.       Transaction  =   12360
  9.       SubTotal     =   0
  10.       Footer       =   1020
  11.       Pagefooter   =   15660
  12.       Replicate    =   420
  13.       Style        =   0
  14.       Query        =   "VATCASH "
  15.       Macro        =   "2CD:When VATCASH.VCVALUE<>0 then REPTOT(0)=VATCASH.VCVALUE-VATCASH.VCVAT"
  16.       Macro        =   "2CD:When VATCASH.VCTYPE="V" then REPTOT(0)=VATCASH.VCVALUE"
  17.       Macro        =   "2CD:When VATCASH.VCMODULE<>"P" then skip 3"
  18.       Macro        =   "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  19.       Macro        =   "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+VATCASH.VCVAT"
  20.       Macro        =   "2CD:When VATCASH.VCMODULE<>"P" then NOPRINT()"
  21.       Macro        =   "2PP:@REPVARS.REPTOT(0) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  24.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  25.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  26. End
  27. Begin Control LABEL
  28.       Type         =   "Label"
  29.       Style        =   4
  30.       Caption      =   "VAT Analysis Of Purchases"
  31.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  32.       Location     =   "Reportheader Block"
  33.       Height       =   420
  34.       Left         =   0
  35.       Top          =   675
  36.       Width        =   11025
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   9
  41.       Caption      =   "DTOC(DATE())"
  42.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   285
  45.       Left         =   135
  46.       Top          =   705
  47.       Width        =   3285
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   10
  52.       Caption      =   "PAGENUM()"
  53.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  54.       Location     =   "Reportheader Block"
  55.       Height       =   285
  56.       Left         =   10395
  57.       Top          =   720
  58.       Width        =   585
  59. End
  60. Begin Control LABEL
  61.       Type         =   "Label"
  62.       Style        =   2
  63.       Caption      =   "Page:"
  64.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  65.       Location     =   "Reportheader Block"
  66.       Height       =   285
  67.       Left         =   9720
  68.       Top          =   720
  69.       Width        =   585
  70. End
  71. Begin Control LABEL
  72.       Type         =   "Label"
  73.       Style        =   12
  74.       Caption      =   "TRIM(SYSTEM.COMPNAME))"
  75.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  76.       Location     =   "Reportheader Block"
  77.       Height       =   270
  78.       Left         =   -15
  79.       Top          =   405
  80.       Width        =   11070
  81. End
  82. Begin Control LABEL
  83.       Type         =   "Label"
  84.       Style        =   1
  85.       Caption      =   "For The Period Ending"
  86.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  87.       Location     =   "Reportheader Block"
  88.       Height       =   270
  89.       Left         =   3780
  90.       Top          =   1080
  91.       Width        =   2160
  92. End
  93. Begin Control LABEL
  94.       Type         =   "Label"
  95.       Style        =   9
  96.       Caption      =   "REPSTR(0)"
  97.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  98.       Location     =   "Reportheader Block"
  99.       Height       =   270
  100.       Left         =   6210
  101.       Top          =   1080
  102.       Width        =   1215
  103. End
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   2
  107.       Caption      =   "Goods"
  108.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  109.       Location     =   "Header Block"
  110.       Height       =   285
  111.       Left         =   5115
  112.       Top          =   75
  113.       Width        =   960
  114. End
  115. Begin Control LABEL
  116.       Type         =   "Label"
  117.       Style        =   2
  118.       Caption      =   "VAT"
  119.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  120.       Location     =   "Header Block"
  121.       Height       =   285
  122.       Left         =   6330
  123.       Top          =   75
  124.       Width        =   960
  125. End
  126. Begin Control LABEL
  127.       Type         =   "Label"
  128.       Style        =   1
  129.       Caption      =   "Supplier ID"
  130.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  131.       Location     =   "Header Block"
  132.       Height       =   285
  133.       Left         =   135
  134.       Top          =   75
  135.       Width        =   1410
  136. End
  137. Begin Control LABEL
  138.       Type         =   "Label"
  139.       Style        =   4
  140.       Caption      =   "Date"
  141.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  142.       Location     =   "Header Block"
  143.       Height       =   285
  144.       Left         =   1875
  145.       Top          =   75
  146.       Width        =   645
  147. End
  148. Begin Control LABEL
  149.       Type         =   "Label"
  150.       Style        =   1
  151.       Caption      =   "Type"
  152.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  153.       Location     =   "Header Block"
  154.       Height       =   285
  155.       Left         =   2925
  156.       Top          =   75
  157.       Width        =   465
  158. End
  159. Begin Control LABEL
  160.       Type         =   "Label"
  161.       Style        =   1
  162.       Caption      =   "Reference"
  163.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  164.       Location     =   "Header Block"
  165.       Height       =   285
  166.       Left         =   3510
  167.       Top          =   75
  168.       Width        =   1140
  169. End
  170. Begin Control LABEL
  171.       Type         =   "Label"
  172.       Style        =   1
  173.       Caption      =   "VAT Code"
  174.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  175.       Location     =   "Header Block"
  176.       Height       =   285
  177.       Left         =   7545
  178.       Top          =   75
  179.       Width        =   960
  180. End
  181. Begin Control VCACCOUNT
  182.       Type         =   "Text"
  183.       Style        =   0
  184.       Fieldname    =   "VCACCOUNT"
  185.       Filename     =   "VATCASH"
  186.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  187.       Location     =   "Transaction Block"
  188.       Height       =   270
  189.       Left         =   135
  190.       Top          =   150
  191.       Width        =   1350
  192. End
  193. Begin Control VCDATE
  194.       Type         =   "Text"
  195.       Style        =   0
  196.       Fieldname    =   "VCDATE"
  197.       Filename     =   "VATCASH"
  198.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  199.       Location     =   "Transaction Block"
  200.       Height       =   270
  201.       Left         =   1620
  202.       Top          =   150
  203.       Width        =   1080
  204. End
  205. Begin Control VCTYPE
  206.       Type         =   "Text"
  207.       Style        =   0
  208.       Fieldname    =   "VCTYPE"
  209.       Filename     =   "VATCASH"
  210.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  211.       Location     =   "Transaction Block"
  212.       Height       =   270
  213.       Left         =   2970
  214.       Top          =   150
  215.       Width        =   270
  216. End
  217. Begin Control VCREF
  218.       Type         =   "Text"
  219.       Style        =   0
  220.       Fieldname    =   "VCREF"
  221.       Filename     =   "VATCASH"
  222.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  223.       Location     =   "Transaction Block"
  224.       Height       =   270
  225.       Left         =   3510
  226.       Top          =   150
  227.       Width        =   1350
  228. End
  229. Begin Control LABEL
  230.       Type         =   "Label"
  231.       Style        =   10
  232.       Caption      =   "STR(REPTOT(0),10,2)"
  233.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  234.       Location     =   "Transaction Block"
  235.       Height       =   270
  236.       Left         =   4995
  237.       Top          =   150
  238.       Width        =   1125
  239. End
  240. Begin Control VCVAT
  241.       Type         =   "Text"
  242.       Style        =   0
  243.       Fieldname    =   "VCVAT"
  244.       Filename     =   "VATCASH"
  245.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  246.       Location     =   "Transaction Block"
  247.       Height       =   270
  248.       Left         =   6210
  249.       Top          =   150
  250.       Width        =   1125
  251. End
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   9
  255.       Caption      =   "IF(TRIM(VATCASH.VCTYPE)="V","VAT Adjustment due to unallocated cash","      "+VATCASH.VCALLOC)"
  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         =   7560
  260.       Top          =   150
  261.       Width        =   3645
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   10
  266.       Caption      =   "STR(REPTOT(2),10,2)"
  267.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Footer Block"
  269.       Height       =   270
  270.       Left         =   4995
  271.       Top          =   750
  272.       Width        =   1125
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "STR(REPTOT(3),10,2)"
  278.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Footer Block"
  280.       Height       =   270
  281.       Left         =   6210
  282.       Top          =   750
  283.       Width        =   1125
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   2
  288.       Caption      =   "Totals"
  289.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Footer Block"
  291.       Height       =   270
  292.       Left         =   3510
  293.       Top          =   750
  294.       Width        =   1350
  295. End
  296.