home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / FACTBAT.REP < prev    next >
Text File  |  1996-08-01  |  15KB  |  432 lines
  1. VERSION 2.00
  2. Begin Report FACTBAT.REP
  3.       Caption      =   "FACTBAT.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   0
  7.       Header       =   3495
  8.       Transaction  =   10260
  9.       SubTotal     =   0
  10.       Footer       =   0
  11.       Pagefooter   =   13755
  12.       Replicate    =   405
  13.       Style        =   13
  14.       Query        =   "FACTAD  ORDER BY STR(FCFACTER,8,0)+FCBATCHNO+FCDOCNO"
  15.       Macro        =   "0LU:Select from FACTOR where ALL"
  16.       Macro        =   "1OF:@REPVARS.REPTOT(3) = REPTOT(3)+1"
  17.       Macro        =   "1CD:When REPTOT(3)=1 then REPTOT(2)=0"
  18.       Macro        =   "1CD:When REPTOT(3)=1 then REPTOT(4)=0"
  19.       Macro        =   "1CD:When REPTOT(3)=1 then REPTOT(5)=0"
  20.       Macro        =   "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+FACTAD.FCTOTVALUE"
  21.       Macro        =   "2OF:@REPVARS.REPTOT(1) = REPTOT(1)+FACTAD.FCTOTVAT"
  22.       Macro        =   "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+1"
  23.       Macro        =   "2OF:@REPVARS.REPTOT(4) = REPTOT(4)+FACTAD.FCTOTVALUE"
  24.       Macro        =   "2OF:@REPVARS.REPTOT(5) = REPTOT(5)+FACTAD.FCTOTVAT"
  25.       Macro        =   "2OF:RUNTIME.ALPHAFIELD = FACTAD.FCBATCHNO"
  26.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  27.       Macro        =   "5PP:@REPVARS.REPTOT(0) = 0"
  28.       Macro        =   "5PP:@REPVARS.REPTOT(1) = 0"
  29.       BreakOn      =   "STR(FACTAD.FCFACTER,8,0)+FACTAD.FCBATCHNO"
  30. End
  31. Begin Control LABEL
  32.       Type         =   "Label"
  33.       Style        =   12
  34.       Caption      =   "IF(REPTOT(3)=1,IF(FACTAD.FCTYPE="I","NOTIFICATION OF RECEIVABLES","NOTIFICATION OF RETURNS & ALLOWANCES"),IF(FACTAD.FCTYPE="I","NOTIFICATION OF RECEIVABLES ( Contd )","NOTIFICATION OF RETURNS & ALLOWANCES ( Contd )"))"
  35.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  36.       Location     =   "Header Block"
  37.       Height       =   285
  38.       Left         =   270
  39.       Top          =   540
  40.       Width        =   11025
  41. End
  42. Begin Control LABEL
  43.       Type         =   "Label"
  44.       Style        =   4
  45.       Caption      =   "VAT"
  46.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  47.       Location     =   "Header Block"
  48.       Height       =   285
  49.       Left         =   8430
  50.       Top          =   3090
  51.       Width        =   510
  52. End
  53. Begin Control LABEL
  54.       Type         =   "Label"
  55.       Style        =   9
  56.       Caption      =   "IF(FACTAD.FCTYPE="I","Invoice No.","Credit No.")"
  57.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  58.       Location     =   "Header Block"
  59.       Height       =   285
  60.       Left         =   2940
  61.       Top          =   3090
  62.       Width        =   1110
  63. End
  64. Begin Control LABEL
  65.       Type         =   "Label"
  66.       Style        =   1
  67.       Caption      =   "Cust. Ref. No."
  68.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  69.       Location     =   "Header Block"
  70.       Height       =   285
  71.       Left         =   1320
  72.       Top          =   3090
  73.       Width        =   1245
  74. End
  75. Begin Control LABEL
  76.       Type         =   "Label"
  77.       Style        =   9
  78.       Caption      =   "IF(REPTOT(3)=1,"Client Number :","")"
  79.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  80.       Location     =   "Header Block"
  81.       Height       =   270
  82.       Left         =   810
  83.       Top          =   1080
  84.       Width        =   1755
  85. End
  86. Begin Control LABEL
  87.       Type         =   "Label"
  88.       Style        =   2
  89.       Caption      =   "Item"
  90.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  91.       Location     =   "Header Block"
  92.       Height       =   285
  93.       Left         =   105
  94.       Top          =   3090
  95.       Width        =   705
  96. End
  97. Begin Control LABEL
  98.       Type         =   "Label"
  99.       Style        =   9
  100.       Caption      =   "IF(FACTAD.FCTYPE="I","Invoice Date","Credit Date")"
  101.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  102.       Location     =   "Header Block"
  103.       Height       =   285
  104.       Left         =   4560
  105.       Top          =   3090
  106.       Width        =   1245
  107. End
  108. Begin Control LABEL
  109.       Type         =   "Label"
  110.       Style        =   10
  111.       Caption      =   "IF(FACTAD.FCTYPE="I","Invoice Value","Credit Value")"
  112.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  113.       Location     =   "Header Block"
  114.       Height       =   285
  115.       Left         =   6315
  116.       Top          =   3090
  117.       Width        =   1110
  118. End
  119. Begin Control LABEL
  120.       Type         =   "Label"
  121.       Style        =   12
  122.       Caption      =   "IF(FACTAD.FCTYPE="I","INVOICES","CREDIT NOTES")"
  123.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  124.       Location     =   "Header Block"
  125.       Height       =   285
  126.       Left         =   270
  127.       Top          =   270
  128.       Width        =   11025
  129. End
  130. Begin Control LABEL
  131.       Type         =   "Label"
  132.       Style        =   9
  133.       Caption      =   "IF(REPTOT(3)=1,FACTOR.FACTCLIENT,"")"
  134.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  135.       Location     =   "Header Block"
  136.       Height       =   270
  137.       Left         =   2565
  138.       Top          =   1080
  139.       Width        =   1485
  140. End
  141. Begin Control LABEL
  142.       Type         =   "Label"
  143.       Style        =   9
  144.       Caption      =   "IF(REPTOT(3)=1,"Authorised Signatory :","")"
  145.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  146.       Location     =   "Header Block"
  147.       Height       =   270
  148.       Left         =   810
  149.       Top          =   1755
  150.       Width        =   3105
  151. End
  152. Begin Control LABEL
  153.       Type         =   "Label"
  154.       Style        =   1
  155.       Caption      =   "Batch Number :"
  156.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  157.       Location     =   "Header Block"
  158.       Height       =   270
  159.       Left         =   6885
  160.       Top          =   1080
  161.       Width        =   1620
  162. End
  163. Begin Control LABEL
  164.       Type         =   "Label"
  165.       Style        =   9
  166.       Caption      =   "FACTAD.FCBATCHNO"
  167.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  168.       Location     =   "Header Block"
  169.       Height       =   270
  170.       Left         =   8505
  171.       Top          =   1080
  172.       Width        =   1485
  173. End
  174. Begin Control LABEL
  175.       Type         =   "Label"
  176.       Style        =   9
  177.       Caption      =   "IF(REPTOT(3)=1,"Date :","")"
  178.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  179.       Location     =   "Header Block"
  180.       Height       =   270
  181.       Left         =   6885
  182.       Top          =   1755
  183.       Width        =   675
  184. End
  185. Begin Control LABEL
  186.       Type         =   "Label"
  187.       Style        =   9
  188.       Caption      =   "IF(REPTOT(3)=1,DTOC(DATE()),"")"
  189.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  190.       Location     =   "Header Block"
  191.       Height       =   270
  192.       Left         =   7560
  193.       Top          =   1755
  194.       Width        =   1080
  195. End
  196. Begin Control FCTOTVALUE
  197.       Type         =   "Text"
  198.       Style        =   0
  199.       Fieldname    =   "FCTOTVALUE"
  200.       Filename     =   "FACTAD"
  201.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  202.       Location     =   "Transaction Block"
  203.       Height       =   270
  204.       Left         =   6300
  205.       Top          =   135
  206.       Width        =   1185
  207. End
  208. Begin Control FCTOTVAT
  209.       Type         =   "Text"
  210.       Style        =   0
  211.       Fieldname    =   "FCTOTVAT"
  212.       Filename     =   "FACTAD"
  213.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  214.       Location     =   "Transaction Block"
  215.       Height       =   270
  216.       Left         =   7800
  217.       Top          =   135
  218.       Width        =   1185
  219. End
  220. Begin Control FCDOCNO
  221.       Type         =   "Text"
  222.       Style        =   0
  223.       Fieldname    =   "FCDOCNO"
  224.       Filename     =   "FACTAD"
  225.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  226.       Location     =   "Transaction Block"
  227.       Height       =   270
  228.       Left         =   3000
  229.       Top          =   135
  230.       Width        =   1050
  231. End
  232. Begin Control FCFACTR
  233.       Type         =   "Text"
  234.       Style        =   0
  235.       Fieldname    =   "FCFACTR"
  236.       Filename     =   "FACTAD"
  237.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Transaction Block"
  239.       Height       =   270
  240.       Left         =   1380
  241.       Top          =   135
  242.       Width        =   960
  243. End
  244. Begin Control FCTXNDATE
  245.       Type         =   "Text"
  246.       Style        =   0
  247.       Fieldname    =   "FCTXNDATE"
  248.       Filename     =   "FACTAD"
  249.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  250.       Location     =   "Transaction Block"
  251.       Height       =   270
  252.       Left         =   4620
  253.       Top          =   135
  254.       Width        =   960
  255. End
  256. Begin Control LABEL
  257.       Type         =   "Label"
  258.       Style        =   10
  259.       Caption      =   "STR(REPTOT(2),3,0)"
  260.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  261.       Location     =   "Transaction Block"
  262.       Height       =   270
  263.       Left         =   30
  264.       Top          =   135
  265.       Width        =   675
  266. End
  267. Begin Control LABEL
  268.       Type         =   "Label"
  269.       Style        =   10
  270.       Caption      =   "IF(REPTOT(3)=0,"___________","")"
  271.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  272.       Location     =   "Pagefooter Block"
  273.       Height       =   270
  274.       Left         =   7800
  275.       Top          =   1125
  276.       Width        =   1185
  277. End
  278. Begin Control LABEL
  279.       Type         =   "Label"
  280.       Style        =   10
  281.       Caption      =   "IF(REPTOT(3)=0,"___________","")"
  282.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  283.       Location     =   "Pagefooter Block"
  284.       Height       =   270
  285.       Left         =   6300
  286.       Top          =   1125
  287.       Width        =   1185
  288. End
  289. Begin Control LABEL
  290.       Type         =   "Label"
  291.       Style        =   10
  292.       Caption      =   "STR(REPTOT(0),10,2)"
  293.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  294.       Location     =   "Pagefooter Block"
  295.       Height       =   270
  296.       Left         =   6300
  297.       Top          =   760
  298.       Width        =   1185
  299. End
  300. Begin Control LABEL
  301.       Type         =   "Label"
  302.       Style        =   10
  303.       Caption      =   "STR(REPTOT(1),10,2)"
  304.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  305.       Location     =   "Pagefooter Block"
  306.       Height       =   270
  307.       Left         =   7800
  308.       Top          =   760
  309.       Width        =   1185
  310. End
  311. Begin Control LABEL
  312.       Type         =   "Label"
  313.       Style        =   2
  314.       Caption      =   "___________"
  315.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  316.       Location     =   "Pagefooter Block"
  317.       Height       =   270
  318.       Left         =   6300
  319.       Top          =   370
  320.       Width        =   1185
  321. End
  322. Begin Control LABEL
  323.       Type         =   "Label"
  324.       Style        =   2
  325.       Caption      =   "___________"
  326.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  327.       Location     =   "Pagefooter Block"
  328.       Height       =   270
  329.       Left         =   6300
  330.       Top          =   910
  331.       Width        =   1185
  332. End
  333. Begin Control LABEL
  334.       Type         =   "Label"
  335.       Style        =   2
  336.       Caption      =   "___________"
  337.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  338.       Location     =   "Pagefooter Block"
  339.       Height       =   270
  340.       Left         =   7800
  341.       Top          =   370
  342.       Width        =   1185
  343. End
  344. Begin Control LABEL
  345.       Type         =   "Label"
  346.       Style        =   2
  347.       Caption      =   "___________"
  348.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  349.       Location     =   "Pagefooter Block"
  350.       Height       =   270
  351.       Left         =   7800
  352.       Top          =   910
  353.       Width        =   1185
  354. End
  355. Begin Control LABEL
  356.       Type         =   "Label"
  357.       Style        =   1
  358.       Caption      =   "Sub Totals"
  359.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  360.       Location     =   "Pagefooter Block"
  361.       Height       =   270
  362.       Left         =   4410
  363.       Top          =   760
  364.       Width        =   1590
  365. End
  366. Begin Control LABEL
  367.       Type         =   "Label"
  368.       Style        =   9
  369.       Caption      =   "IF(REPTOT(3)=0,"Totals for Batch "+TRIM(RUNTIME.ALPHAFIELD),"")"
  370.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  371.       Location     =   "Pagefooter Block"
  372.       Height       =   270
  373.       Left         =   4410
  374.       Top          =   1515
  375.       Width        =   1860
  376. End
  377. Begin Control LABEL
  378.       Type         =   "Label"
  379.       Style        =   10
  380.       Caption      =   "IF(REPTOT(3)=0,STR(REPTOT(4),10,2),"")"
  381.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  382.       Location     =   "Pagefooter Block"
  383.       Height       =   270
  384.       Left         =   6300
  385.       Top          =   1515
  386.       Width        =   1185
  387. End
  388. Begin Control LABEL
  389.       Type         =   "Label"
  390.       Style        =   10
  391.       Caption      =   "IF(REPTOT(3)=0,"___________","")"
  392.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  393.       Location     =   "Pagefooter Block"
  394.       Height       =   270
  395.       Left         =   6300
  396.       Top          =   1665
  397.       Width        =   1185
  398. End
  399. Begin Control LABEL
  400.       Type         =   "Label"
  401.       Style        =   10
  402.       Caption      =   "IF(REPTOT(3)=0,STR(REPTOT(5),10,2),"")"
  403.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  404.       Location     =   "Pagefooter Block"
  405.       Height       =   270
  406.       Left         =   7800
  407.       Top          =   1515
  408.       Width        =   1185
  409. End
  410. Begin Control LABEL
  411.       Type         =   "Label"
  412.       Style        =   10
  413.       Caption      =   "IF(REPTOT(3)=0,"___________","")"
  414.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  415.       Location     =   "Pagefooter Block"
  416.       Height       =   270
  417.       Left         =   7800
  418.       Top          =   1665
  419.       Width        =   1185
  420. End
  421. Begin Control LABEL
  422.       Type         =   "Label"
  423.       Style        =   9
  424.       Caption      =   "IF(REPTOT(3)=0,"Total No. of Documents in Batch "+TRIM(RUNTIME.ALPHAFIELD)+" = "+STR(REPTOT(2),3,0),"")"
  425.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  426.       Location     =   "Pagefooter Block"
  427.       Height       =   270
  428.       Left         =   225
  429.       Top          =   1515
  430.       Width        =   3615
  431. End
  432.