home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / SLRECPTS.REP < prev    next >
Text File  |  1995-06-21  |  13KB  |  397 lines
  1. VERSION 2.00
  2. Begin Report SLRECPTS.REP
  3.       Caption      =   "SLRECPTS.REP"
  4.       Width        =   11175
  5.       Height       =   17370
  6.       Reportheader =   975
  7.       Header       =   810
  8.       Transaction  =   11820
  9.       SubTotal     =   660
  10.       Footer       =   1665
  11.       Pagefooter   =   16185
  12.       Replicate    =   390
  13.       Style        =   0
  14.       Query        =   "SLTRAN STTYPE="R" | STTYPE="D" ORDER BY STNOMBATCH+DTOS(STCREATION)"
  15.       Macro        =   "1LU:Select from NLTRAN where NTENTRYNO=SLTRAN.STNOMBATCH & NTRECONCIL<'D'"
  16.       Macro        =   "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  17.       Macro        =   "2LU:Select from SLNAME where SNACCOUNT=SLTRAN.STACCOUNT"
  18.       Macro        =   "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+SLTRAN.STVALUE"
  19.       Macro        =   "2CD:When SLTRAN.STTYPE="R" & SLTRAN.STALLOC="A" then REPTOT(2)=REPTOT(2)+SLTRAN.STVALUE"
  20.       Macro        =   "2CD:When SLTRAN.STTYPE="R" & SLTRAN.STALLOC=" " then REPTOT(3)=REPTOT(3)+SLTRAN.STVALUE"
  21.       Macro        =   "2CD:When SLTRAN.STTYPE="D" then REPTOT(4)=REPTOT(4)+SLTRAN.STVALUE"
  22.       Macro        =   "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  23.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  24.       BreakOn      =   "SLTRAN.STNOMBATCH"
  25.       Special      =   "TXNRANGE(ST_IC_NO,STCREATION)"
  26. End
  27. Begin Control LABEL
  28.       Type         =   "Label"
  29.       Style        =   12
  30.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  31.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  32.       Location     =   "Reportheader Block"
  33.       Height       =   270
  34.       Left         =   -15
  35.       Top          =   405
  36.       Width        =   11070
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   4
  41.       Caption      =   "Sales Receipts"
  42.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   285
  45.       Left         =   0
  46.       Top          =   675
  47.       Width        =   11025
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   9
  52.       Caption      =   "DTOC(DATE())"
  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         =   135
  57.       Top          =   705
  58.       Width        =   3690
  59. End
  60. Begin Control LABEL
  61.       Type         =   "Label"
  62.       Style        =   10
  63.       Caption      =   ""Page:"+PAGENUM()"
  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         =   9180
  68.       Top          =   720
  69.       Width        =   1800
  70. End
  71. Begin Control LABEL
  72.       Type         =   "Label"
  73.       Style        =   1
  74.       Caption      =   "Customer ID"
  75.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  76.       Location     =   "Header Block"
  77.       Height       =   285
  78.       Left         =   135
  79.       Top          =   645
  80.       Width        =   1140
  81. End
  82. Begin Control LABEL
  83.       Type         =   "Label"
  84.       Style        =   4
  85.       Caption      =   "Date"
  86.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  87.       Location     =   "Header Block"
  88.       Height       =   285
  89.       Left         =   1425
  90.       Top          =   645
  91.       Width        =   870
  92. End
  93. Begin Control LABEL
  94.       Type         =   "Label"
  95.       Style        =   1
  96.       Caption      =   "Reference"
  97.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  98.       Location     =   "Header Block"
  99.       Height       =   285
  100.       Left         =   3960
  101.       Top          =   645
  102.       Width        =   1005
  103. End
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   2
  107.       Caption      =   "Value"
  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         =   5520
  112.       Top          =   645
  113.       Width        =   1005
  114. End
  115. Begin Control LABEL
  116.       Type         =   "Label"
  117.       Style        =   1
  118.       Caption      =   "Account Name"
  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         =   6795
  123.       Top          =   645
  124.       Width        =   1815
  125. End
  126. Begin Control LABEL
  127.       Type         =   "Label"
  128.       Style        =   1
  129.       Caption      =   "Paying In Slip Reference:"
  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          =   240
  135.       Width        =   2220
  136. End
  137. Begin Control LABEL
  138.       Type         =   "Label"
  139.       Style        =   9
  140.       Caption      =   "MID(SLTRAN.STNOMBATCH+"          ",5,5)"
  141.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  142.       Location     =   "Header Block"
  143.       Height       =   285
  144.       Left         =   2295
  145.       Top          =   240
  146.       Width        =   870
  147. End
  148. Begin Control NTCODE
  149.       Type         =   "Text"
  150.       Style        =   0
  151.       Fieldname    =   "NTCODE"
  152.       Filename     =   "NLTRAN"
  153.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  154.       Location     =   "Header Block"
  155.       Height       =   270
  156.       Left         =   4170
  157.       Top          =   225
  158.       Width        =   735
  159. End
  160. Begin Control NNACCNAME
  161.       Type         =   "Text"
  162.       Style        =   0
  163.       Fieldname    =   "NNACCNAME"
  164.       Filename     =   "NLNAME"
  165.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  166.       Location     =   "Header Block"
  167.       Height       =   270
  168.       Left         =   5130
  169.       Top          =   225
  170.       Width        =   3075
  171. End
  172. Begin Control LABEL
  173.       Type         =   "Label"
  174.       Style        =   1
  175.       Caption      =   "Bank:"
  176.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  177.       Location     =   "Header Block"
  178.       Height       =   285
  179.       Left         =   3585
  180.       Top          =   240
  181.       Width        =   465
  182. End
  183. Begin Control LABEL
  184.       Type         =   "Label"
  185.       Style        =   4
  186.       Caption      =   "Type"
  187.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  188.       Location     =   "Header Block"
  189.       Height       =   285
  190.       Left         =   2640
  191.       Top          =   645
  192.       Width        =   870
  193. End
  194. Begin Control STACCOUNT
  195.       Type         =   "Text"
  196.       Style        =   0
  197.       Fieldname    =   "STACCOUNT"
  198.       Filename     =   "SLTRAN"
  199.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  200.       Location     =   "Transaction Block"
  201.       Height       =   270
  202.       Left         =   135
  203.       Top          =   90
  204.       Width        =   1140
  205. End
  206. Begin Control STTXNDATE
  207.       Type         =   "Text"
  208.       Style        =   0
  209.       Fieldname    =   "STTXNDATE"
  210.       Filename     =   "SLTRAN"
  211.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  212.       Location     =   "Transaction Block"
  213.       Height       =   270
  214.       Left         =   1425
  215.       Top          =   90
  216.       Width        =   1140
  217. End
  218. Begin Control STREF
  219.       Type         =   "Text"
  220.       Style        =   0
  221.       Fieldname    =   "STREF"
  222.       Filename     =   "SLTRAN"
  223.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  224.       Location     =   "Transaction Block"
  225.       Height       =   270
  226.       Left         =   3960
  227.       Top          =   90
  228.       Width        =   1275
  229. End
  230. Begin Control STVALUE
  231.       Type         =   "Text"
  232.       Style        =   0
  233.       Fieldname    =   "STVALUE"
  234.       Filename     =   "SLTRAN"
  235.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  236.       Location     =   "Transaction Block"
  237.       Height       =   270
  238.       Left         =   5520
  239.       Top          =   90
  240.       Width        =   1005
  241. End
  242. Begin Control SNNAME
  243.       Type         =   "Text"
  244.       Style        =   0
  245.       Fieldname    =   "SNNAME"
  246.       Filename     =   "SLNAME"
  247.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  248.       Location     =   "Transaction Block"
  249.       Height       =   270
  250.       Left         =   6750
  251.       Top          =   90
  252.       Width        =   3075
  253. End
  254. Begin Control LABEL
  255.       Type         =   "Label"
  256.       Style        =   9
  257.       Caption      =   "IF(SLTRAN.STTYPE="D","Discount","Receipt")"
  258.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  259.       Location     =   "Transaction Block"
  260.       Height       =   285
  261.       Left         =   2700
  262.       Top          =   105
  263.       Width        =   1140
  264. End
  265. Begin Control LABEL
  266.       Type         =   "Label"
  267.       Style        =   10
  268.       Caption      =   "STR(REPTOT(0),10,2)"
  269.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  270.       Location     =   "Subtotal Block"
  271.       Height       =   270
  272.       Left         =   3825
  273.       Top          =   30
  274.       Width        =   1080
  275. End
  276. Begin Control LABEL
  277.       Type         =   "Label"
  278.       Style        =   1
  279.       Caption      =   "Slip Total"
  280.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  281.       Location     =   "Subtotal Block"
  282.       Height       =   270
  283.       Left         =   2295
  284.       Top          =   30
  285.       Width        =   1350
  286. End
  287. Begin Control LABEL
  288.       Type         =   "Label"
  289.       Style        =   1
  290.       Caption      =   "Total Receipts"
  291.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  292.       Location     =   "Footer Block"
  293.       Height       =   270
  294.       Left         =   2295
  295.       Top          =   45
  296.       Width        =   1350
  297. End
  298. Begin Control LABEL
  299.       Type         =   "Label"
  300.       Style        =   10
  301.       Caption      =   "STR(REPTOT(1),10,2)"
  302.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  303.       Location     =   "Footer Block"
  304.       Height       =   270
  305.       Left         =   3825
  306.       Top          =   45
  307.       Width        =   1080
  308. End
  309. Begin Control LABEL
  310.       Type         =   "Label"
  311.       Style        =   1
  312.       Caption      =   "Allocated Receipts"
  313.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  314.       Location     =   "Footer Block"
  315.       Height       =   270
  316.       Left         =   135
  317.       Top          =   585
  318.       Width        =   1620
  319. End
  320. Begin Control LABEL
  321.       Type         =   "Label"
  322.       Style        =   1
  323.       Caption      =   "Unallocated Receipts"
  324.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  325.       Location     =   "Footer Block"
  326.       Height       =   270
  327.       Left         =   135
  328.       Top          =   855
  329.       Width        =   1755
  330. End
  331. Begin Control LABEL
  332.       Type         =   "Label"
  333.       Style        =   1
  334.       Caption      =   "Discount"
  335.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  336.       Location     =   "Footer Block"
  337.       Height       =   270
  338.       Left         =   135
  339.       Top          =   1125
  340.       Width        =   1620
  341. End
  342. Begin Control LABEL
  343.       Type         =   "Label"
  344.       Style        =   10
  345.       Caption      =   "STR(REPTOT(2),10,2)"
  346.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  347.       Location     =   "Footer Block"
  348.       Height       =   270
  349.       Left         =   2070
  350.       Top          =   585
  351.       Width        =   1080
  352. End
  353. Begin Control LABEL
  354.       Type         =   "Label"
  355.       Style        =   10
  356.       Caption      =   "STR(REPTOT(3),10,2)"
  357.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  358.       Location     =   "Footer Block"
  359.       Height       =   270
  360.       Left         =   2070
  361.       Top          =   855
  362.       Width        =   1080
  363. End
  364. Begin Control LABEL
  365.       Type         =   "Label"
  366.       Style        =   10
  367.       Caption      =   "STR(REPTOT(4),10,2)"
  368.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  369.       Location     =   "Footer Block"
  370.       Height       =   270
  371.       Left         =   2070
  372.       Top          =   1125
  373.       Width        =   1080
  374. End
  375. Begin Control LABEL
  376.       Type         =   "Label"
  377.       Style        =   1
  378.       Caption      =   "Total"
  379.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  380.       Location     =   "Footer Block"
  381.       Height       =   270
  382.       Left         =   135
  383.       Top          =   1395
  384.       Width        =   1620
  385. End
  386. Begin Control LABEL
  387.       Type         =   "Label"
  388.       Style        =   10
  389.       Caption      =   "STR(REPTOT(2)+REPTOT(3)+REPTOT(4),10,2)"
  390.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  391.       Location     =   "Footer Block"
  392.       Height       =   270
  393.       Left         =   2070
  394.       Top          =   1395
  395.       Width        =   1080
  396. End
  397.