home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / VATPREC.REP < prev    next >
Text File  |  1995-06-21  |  11KB  |  337 lines
  1. VERSION 2.00
  2. Begin Report VATPREC.REP
  3.       Caption      =   "VATPREC.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   900
  7.       Header       =   1230
  8.       Transaction  =   11220
  9.       SubTotal     =   1035
  10.       Footer       =   0
  11.       Pagefooter   =   15615
  12.       Replicate    =   420
  13.       Style        =   0
  14.       Query        =   "VATREC VRMODULE="P" ORDER BY VRACCOUNT"
  15.       Macro        =   "1LU:Select from PLNAME where PNCODE=VATREC.VRACCOUNT"
  16.       Macro        =   "2OF:@REPVARS.REPTOT(0) = 0"
  17.       Macro        =   "2CD:When VATREC.VRTYPE<>"V" then REPTOT(0)=VATREC.VRVALUE"
  18.       Macro        =   "2OF:@REPVARS.REPTOT(2) = VATREC.VRVAT"
  19.       Macro        =   "2CD:When VATREC.VRTYPE="V" then REPTOT(2)=REPTOT(2)*-1"
  20.       Macro        =   "2OF:@REPVARS.REPTOT(1) = REPTOT(0)-REPTOT(2)"
  21.       BreakOn      =   "VATREC.VRALCBATCH"
  22.       Special      =   "TXNRANGE(VRALCBATCH,VRALCDATE)"
  23. End
  24. Begin Control LABEL
  25.       Type         =   "Label"
  26.       Style        =   4
  27.       Caption      =   "Purchase VAT Reconciliation Report"
  28.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  29.       Location     =   "Reportheader Block"
  30.       Height       =   375
  31.       Left         =   0
  32.       Top          =   675
  33.       Width        =   11025
  34. End
  35. Begin Control LABEL
  36.       Type         =   "Label"
  37.       Style        =   9
  38.       Caption      =   "DTOC(DATE())"
  39.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  40.       Location     =   "Reportheader Block"
  41.       Height       =   285
  42.       Left         =   135
  43.       Top          =   705
  44.       Width        =   2745
  45. End
  46. Begin Control LABEL
  47.       Type         =   "Label"
  48.       Style        =   10
  49.       Caption      =   ""Page "+PAGENUM()"
  50.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  51.       Location     =   "Reportheader Block"
  52.       Height       =   285
  53.       Left         =   9180
  54.       Top          =   720
  55.       Width        =   1800
  56. End
  57. Begin Control LABEL
  58.       Type         =   "Label"
  59.       Style        =   12
  60.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  61.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  62.       Location     =   "Reportheader Block"
  63.       Height       =   270
  64.       Left         =   -15
  65.       Top          =   405
  66.       Width        =   11070
  67. End
  68. Begin Control LABEL
  69.       Type         =   "Label"
  70.       Style        =   4
  71.       Caption      =   "Date"
  72.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  73.       Location     =   "Header Block"
  74.       Height       =   285
  75.       Left         =   75
  76.       Top          =   855
  77.       Width        =   735
  78. End
  79. Begin Control LABEL
  80.       Type         =   "Label"
  81.       Style        =   2
  82.       Caption      =   "Value"
  83.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  84.       Location     =   "Header Block"
  85.       Height       =   285
  86.       Left         =   3630
  87.       Top          =   855
  88.       Width        =   600
  89. End
  90. Begin Control LABEL
  91.       Type         =   "Label"
  92.       Style        =   2
  93.       Caption      =   "Goods"
  94.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  95.       Location     =   "Header Block"
  96.       Height       =   285
  97.       Left         =   4845
  98.       Top          =   855
  99.       Width        =   735
  100. End
  101. Begin Control LABEL
  102.       Type         =   "Label"
  103.       Style        =   4
  104.       Caption      =   "VAT"
  105.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  106.       Location     =   "Header Block"
  107.       Height       =   285
  108.       Left         =   6345
  109.       Top          =   855
  110.       Width        =   600
  111. End
  112. Begin Control LABEL
  113.       Type         =   "Label"
  114.       Style        =   4
  115.       Caption      =   "Type"
  116.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  117.       Location     =   "Header Block"
  118.       Height       =   285
  119.       Left         =   1170
  120.       Top          =   855
  121.       Width        =   600
  122. End
  123. Begin Control PNNAME
  124.       Type         =   "Text"
  125.       Style        =   0
  126.       Fieldname    =   "PNNAME"
  127.       Filename     =   "PLNAME"
  128.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   270
  131.       Left         =   2040
  132.       Top          =   495
  133.       Width        =   2835
  134. End
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   1
  138.       Caption      =   "Reference"
  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         =   2205
  143.       Top          =   855
  144.       Width        =   1005
  145. End
  146. Begin Control VRALCDATE
  147.       Type         =   "Text"
  148.       Style        =   0
  149.       Fieldname    =   "VRALCDATE"
  150.       Filename     =   "VATREC"
  151.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  152.       Location     =   "Header Block"
  153.       Height       =   270
  154.       Left         =   6690
  155.       Top          =   495
  156.       Width        =   1005
  157. End
  158. Begin Control LABEL
  159.       Type         =   "Label"
  160.       Style        =   1
  161.       Caption      =   "Date of Allocation :"
  162.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  163.       Location     =   "Header Block"
  164.       Height       =   270
  165.       Left         =   5070
  166.       Top          =   495
  167.       Width        =   1620
  168. End
  169. Begin Control LABEL
  170.       Type         =   "Label"
  171.       Style        =   1
  172.       Caption      =   "Allocation Batch No.  :"
  173.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  174.       Location     =   "Header Block"
  175.       Height       =   270
  176.       Left         =   7770
  177.       Top          =   495
  178.       Width        =   1890
  179. End
  180. Begin Control LABEL
  181.       Type         =   "Label"
  182.       Style        =   1
  183.       Caption      =   "Supplier ID :"
  184.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  185.       Location     =   "Header Block"
  186.       Height       =   270
  187.       Left         =   30
  188.       Top          =   495
  189.       Width        =   1050
  190. End
  191. Begin Control LABEL
  192.       Type         =   "Label"
  193.       Style        =   2
  194.       Caption      =   "Paid/Received"
  195.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  196.       Location     =   "Header Block"
  197.       Height       =   285
  198.       Left         =   3420
  199.       Top          =   1125
  200.       Width        =   1140
  201. End
  202. Begin Control LABEL
  203.       Type         =   "Label"
  204.       Style        =   2
  205.       Caption      =   "Paid/Reclaimed"
  206.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Header Block"
  208.       Height       =   285
  209.       Left         =   5850
  210.       Top          =   1125
  211.       Width        =   1275
  212. End
  213. Begin Control LABEL
  214.       Type         =   "Label"
  215.       Style        =   4
  216.       Caption      =   "VAT"
  217.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  218.       Location     =   "Header Block"
  219.       Height       =   285
  220.       Left         =   7290
  221.       Top          =   855
  222.       Width        =   600
  223. End
  224. Begin Control LABEL
  225.       Type         =   "Label"
  226.       Style        =   4
  227.       Caption      =   "Code"
  228.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  229.       Location     =   "Header Block"
  230.       Height       =   285
  231.       Left         =   7335
  232.       Top          =   1125
  233.       Width        =   600
  234. End
  235. Begin Control VRACCOUNT
  236.       Type         =   "Text"
  237.       Style        =   0
  238.       Fieldname    =   "VRACCOUNT"
  239.       Filename     =   "VATREC"
  240.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  241.       Location     =   "Header Block"
  242.       Height       =   270
  243.       Left         =   1035
  244.       Top          =   495
  245.       Width        =   960
  246. End
  247. Begin Control LABEL
  248.       Type         =   "Label"
  249.       Style        =   9
  250.       Caption      =   "RIGHT(VATREC.VRALCBATCH,5)"
  251.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  252.       Location     =   "Header Block"
  253.       Height       =   270
  254.       Left         =   9615
  255.       Top          =   495
  256.       Width        =   1050
  257. End
  258. Begin Control VRDATE
  259.       Type         =   "Text"
  260.       Style        =   0
  261.       Fieldname    =   "VRDATE"
  262.       Filename     =   "VATREC"
  263.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  264.       Location     =   "Transaction Block"
  265.       Height       =   270
  266.       Left         =   75
  267.       Top          =   150
  268.       Width        =   1140
  269. End
  270. Begin Control VRREF
  271.       Type         =   "Text"
  272.       Style        =   0
  273.       Fieldname    =   "VRREF"
  274.       Filename     =   "VATREC"
  275.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  276.       Location     =   "Transaction Block"
  277.       Height       =   270
  278.       Left         =   2205
  279.       Top          =   150
  280.       Width        =   1275
  281. End
  282. Begin Control LABEL
  283.       Type         =   "Label"
  284.       Style        =   10
  285.       Caption      =   "STR(REPTOT(2),10,2)"
  286.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  287.       Location     =   "Transaction Block"
  288.       Height       =   270
  289.       Left         =   6075
  290.       Top          =   150
  291.       Width        =   990
  292. End
  293. Begin Control LABEL
  294.       Type         =   "Label"
  295.       Style        =   9
  296.       Caption      =   "MID("   InvCrnPayAdjDscRfdVad",INSTR("ICPADFV",VATREC.VRTYPE)*3+1,3)"
  297.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  298.       Location     =   "Transaction Block"
  299.       Height       =   270
  300.       Left         =   1350
  301.       Top          =   150
  302.       Width        =   810
  303. End
  304. Begin Control LABEL
  305.       Type         =   "Label"
  306.       Style        =   10
  307.       Caption      =   "STR(REPTOT(0),10,2)"
  308.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  309.       Location     =   "Transaction Block"
  310.       Height       =   270
  311.       Left         =   3510
  312.       Top          =   150
  313.       Width        =   990
  314. End
  315. Begin Control LABEL
  316.       Type         =   "Label"
  317.       Style        =   10
  318.       Caption      =   "STR(REPTOT(1),10,2)"
  319.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  320.       Location     =   "Transaction Block"
  321.       Height       =   270
  322.       Left         =   4725
  323.       Top          =   150
  324.       Width        =   990
  325. End
  326. Begin Control LABEL
  327.       Type         =   "Label"
  328.       Style        =   9
  329.       Caption      =   "IF(TRIM(VATREC.VRTYPE)="V","VAT Adjustment due to unallocated cash",VATREC.VRVATCODE)"
  330.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  331.       Location     =   "Transaction Block"
  332.       Height       =   270
  333.       Left         =   7560
  334.       Top          =   150
  335.       Width        =   3645
  336. End
  337.