home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / SLINVCRE.REP < prev    next >
Text File  |  1996-02-05  |  13KB  |  406 lines
  1. VERSION 2.00
  2. Begin Report SLINVCRE.REP
  3.       Caption      =   "SLINVCRE.REP"
  4.       Width        =   11190
  5.       Height       =   16185
  6.       Reportheader =   1335
  7.       Header       =   960
  8.       Transaction  =   12540
  9.       SubTotal     =   0
  10.       Footer       =   1095
  11.       Pagefooter   =   15960
  12.       Replicate    =   405
  13.       Style        =   0
  14.       Query        =   "SLTRAN STTYPE="I" | STTYPE="C""
  15.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(1)=REPTOT(1)+SLTRAN.STVAT"
  16.       Macro        =   "2CD:When SLTRAN.STTYPE="I" then REPTOT(0)=REPTOT(0)+SLTRAN.STVALUE"
  17.       Macro        =   "2LU:Select from SLNAME where SNACCOUNT=SLTRAN.STACCOUNT"
  18.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(2)=REPTOT(2)+SLTRAN.STVALUE"
  19.       Macro        =   "2CD:When SLTRAN.STTYPE="C" then REPTOT(3)=REPTOT(3)+SLTRAN.STVAT"
  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(ST_IC_NO,STCREATION)"
  25. End
  26. Begin Control LABEL
  27.       Type         =   "Label"
  28.       Style        =   12
  29.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  30.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  31.       Location     =   "Reportheader Block"
  32.       Height       =   270
  33.       Left         =   -15
  34.       Top          =   405
  35.       Width        =   11070
  36. End
  37. Begin Control LABEL
  38.       Type         =   "Label"
  39.       Style        =   4
  40.       Caption      =   "Sales Invoices and Credit Notes"
  41.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  42.       Location     =   "Reportheader Block"
  43.       Height       =   285
  44.       Left         =   135
  45.       Top          =   675
  46.       Width        =   11025
  47. End
  48. Begin Control LABEL
  49.       Type         =   "Label"
  50.       Style        =   9
  51.       Caption      =   "DTOC(DATE())"
  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         =   135
  56.       Top          =   705
  57.       Width        =   3285
  58. End
  59. Begin Control LABEL
  60.       Type         =   "Label"
  61.       Style        =   10
  62.       Caption      =   ""Page: "+PAGENUM()"
  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         =   9585
  67.       Top          =   720
  68.       Width        =   1395
  69. End
  70. Begin Control LABEL
  71.       Type         =   "Label"
  72.       Style        =   1
  73.       Caption      =   "Customer ID"
  74.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  75.       Location     =   "Header Block"
  76.       Height       =   285
  77.       Left         =   30
  78.       Top          =   405
  79.       Width        =   1080
  80. End
  81. Begin Control LABEL
  82.       Type         =   "Label"
  83.       Style        =   4
  84.       Caption      =   "Date"
  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         =   1185
  89.       Top          =   405
  90.       Width        =   975
  91. End
  92. Begin Control LABEL
  93.       Type         =   "Label"
  94.       Style        =   1
  95.       Caption      =   "Reference"
  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         =   3075
  100.       Top          =   405
  101.       Width        =   990
  102. End
  103. Begin Control LABEL
  104.       Type         =   "Label"
  105.       Style        =   2
  106.       Caption      =   "VAT"
  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         =   6375
  111.       Top          =   405
  112.       Width        =   960
  113. End
  114. Begin Control LABEL
  115.       Type         =   "Label"
  116.       Style        =   2
  117.       Caption      =   "Value"
  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         =   4245
  122.       Top          =   405
  123.       Width        =   915
  124. End
  125. Begin Control LABEL
  126.       Type         =   "Label"
  127.       Style        =   2
  128.       Caption      =   "Goods"
  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         =   5340
  133.       Top          =   405
  134.       Width        =   870
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   4
  139.       Caption      =   "Type"
  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         =   2400
  144.       Top          =   405
  145.       Width        =   600
  146. End
  147. Begin Control LABEL
  148.       Type         =   "Label"
  149.       Style        =   1
  150.       Caption      =   "Account Name"
  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         =   7530
  155.       Top          =   405
  156.       Width        =   2085
  157. End
  158. Begin Control LABEL
  159.       Type         =   "Label"
  160.       Style        =   10
  161.       Caption      =   "IF(TRIM(REPSTR(9))="Y","Factored","")"
  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         =   10065
  166.       Top          =   405
  167.       Width        =   1005
  168. End
  169. Begin Control STACCOUNT
  170.       Type         =   "Text"
  171.       Style        =   0
  172.       Fieldname    =   "STACCOUNT"
  173.       Filename     =   "SLTRAN"
  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         =   30
  178.       Top          =   120
  179.       Width        =   1095
  180. End
  181. Begin Control STTXNDATE
  182.       Type         =   "Text"
  183.       Style        =   0
  184.       Fieldname    =   "STTXNDATE"
  185.       Filename     =   "SLTRAN"
  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         =   1200
  190.       Top          =   120
  191.       Width        =   1140
  192. End
  193. Begin Control STREF
  194.       Type         =   "Text"
  195.       Style        =   0
  196.       Fieldname    =   "STREF"
  197.       Filename     =   "SLTRAN"
  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         =   3060
  202.       Top          =   120
  203.       Width        =   1140
  204. End
  205. Begin Control STVALUE
  206.       Type         =   "Text"
  207.       Style        =   0
  208.       Fieldname    =   "STVALUE"
  209.       Filename     =   "SLTRAN"
  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         =   4275
  214.       Top          =   120
  215.       Width        =   1020
  216. End
  217. Begin Control STVAT
  218.       Type         =   "Text"
  219.       Style        =   0
  220.       Fieldname    =   "STVAT"
  221.       Filename     =   "SLTRAN"
  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         =   6405
  226.       Top          =   120
  227.       Width        =   1020
  228. End
  229. Begin Control LABEL
  230.       Type         =   "Label"
  231.       Style        =   10
  232.       Caption      =   "STR(SLTRAN.STVALUE-SLTRAN.STVAT,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         =   5340
  237.       Top          =   120
  238.       Width        =   1020
  239. End
  240. Begin Control LABEL
  241.       Type         =   "Label"
  242.       Style        =   9
  243.       Caption      =   "IF(SLTRAN.STTYPE="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         =   2460
  248.       Top          =   135
  249.       Width        =   555
  250. End
  251. Begin Control SNNAME
  252.       Type         =   "Text"
  253.       Style        =   0
  254.       Fieldname    =   "SNNAME"
  255.       Filename     =   "SLNAME"
  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         =   7515
  260.       Top          =   120
  261.       Width        =   3075
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   9
  266.       Caption      =   "IF(TRIM(REPSTR(9))="Y",IF(SLTRAN.STFACTEF='Y',"Yes","No"),"")"
  267.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Transaction Block"
  269.       Height       =   285
  270.       Left         =   10605
  271.       Top          =   120
  272.       Width        =   330
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "STR(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         =   6405
  282.       Top          =   285
  283.       Width        =   1020
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   10
  288.       Caption      =   "STR(REPTOT(0)-REPTOT(1),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         =   5340
  293.       Top          =   285
  294.       Width        =   1020
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   10
  299.       Caption      =   "STR(REPTOT(0),10,2)"
  300.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Footer Block"
  302.       Height       =   270
  303.       Left         =   4275
  304.       Top          =   285
  305.       Width        =   1020
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   1
  310.       Caption      =   "Total Invoices"
  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          =   285
  316.       Width        =   1485
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   1
  321.       Caption      =   "Total Credits"
  322.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  323.       Location     =   "Footer Block"
  324.       Height       =   270
  325.       Left         =   2430
  326.       Top          =   555
  327.       Width        =   1485
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   10
  332.       Caption      =   "STR(REPTOT(2),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         =   4275
  337.       Top          =   540
  338.       Width        =   1020
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   10
  343.       Caption      =   "STR(REPTOT(2)-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         =   5340
  348.       Top          =   555
  349.       Width        =   1020
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   10
  354.       Caption      =   "STR(REPTOT(3),10,2)"
  355.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Footer Block"
  357.       Height       =   270
  358.       Left         =   6405
  359.       Top          =   555
  360.       Width        =   1020
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   1
  365.       Caption      =   "Total"
  366.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Footer Block"
  368.       Height       =   270
  369.       Left         =   2430
  370.       Top          =   825
  371.       Width        =   1350
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "STR(REPTOT(2)+REPTOT(0),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         =   4275
  381.       Top          =   825
  382.       Width        =   1020
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   10
  387.       Caption      =   "STR(REPTOT(0)+REPTOT(2)-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         =   5340
  392.       Top          =   825
  393.       Width        =   1020
  394. End
  395. Begin Control LABEL
  396.       Type         =   "Label"
  397.       Style        =   10
  398.       Caption      =   "STR(REPTOT(1)+REPTOT(3),10,2)"
  399.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  400.       Location     =   "Footer Block"
  401.       Height       =   270
  402.       Left         =   6405
  403.       Top          =   825
  404.       Width        =   1020
  405. End
  406.