home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / INSOUT.REP < prev    next >
Text File  |  1996-03-06  |  12KB  |  364 lines
  1. VERSION 2.00
  2. Begin Report INSOUT.REP
  3.       Caption      =   "INSOUT.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   1185
  8.       Transaction  =   9585
  9.       SubTotal     =   1620
  10.       Footer       =   570
  11.       Pagefooter   =   15960
  12.       Replicate    =   435
  13.       Style        =   8
  14.       Query        =   "STTRND CDTYPE="B"&CDPRODTYPE<>"0" ORDER BY CDDOCNO"
  15.       Macro        =   "1LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
  16.       Macro        =   "2CD:When STTRND.CDQUANTITY<>STTRND.CDQTYBAL then REPTOT(0)=REPTOT(0)+((STTRND.CDQTYBAL/STTRND.CDQUANTITY)*STTRND.CDGOODSOVR)"
  17.       Macro        =   "2CD:When STTRND.CDQUANTITY=STTRND.CDQTYBAL then REPTOT(0)=REPTOT(0)+STTRND.CDGOODSOVR"
  18.       Macro        =   "2LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
  19.       Macro        =   "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  23.       BreakOn      =   "STTRND.CDTRANNO"
  24.       Special      =   "TXNRANGE(CDTRANNO,CDCREATION)"
  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      =   "Outstanding Sales Orders"
  41.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  42.       Location     =   "Reportheader Block"
  43.       Height       =   420
  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      =   "Product ID"
  74.       Font         =   "-135|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          =   675
  79.       Width        =   945
  80. End
  81. Begin Control LABEL
  82.       Type         =   "Label"
  83.       Style        =   1
  84.       Caption      =   "Description"
  85.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  86.       Location     =   "Header Block"
  87.       Height       =   285
  88.       Left         =   2535
  89.       Top          =   675
  90.       Width        =   1110
  91. End
  92. Begin Control LABEL
  93.       Type         =   "Label"
  94.       Style        =   2
  95.       Caption      =   "Quantity"
  96.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  97.       Location     =   "Header Block"
  98.       Height       =   285
  99.       Left         =   5865
  100.       Top          =   675
  101.       Width        =   780
  102. End
  103. Begin Control LABEL
  104.       Type         =   "Label"
  105.       Style        =   1
  106.       Caption      =   "Unit"
  107.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  108.       Location     =   "Header Block"
  109.       Height       =   285
  110.       Left         =   5190
  111.       Top          =   675
  112.       Width        =   510
  113. End
  114. Begin Control LABEL
  115.       Type         =   "Label"
  116.       Style        =   2
  117.       Caption      =   "Balance"
  118.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  119.       Location     =   "Header Block"
  120.       Height       =   285
  121.       Left         =   6900
  122.       Top          =   675
  123.       Width        =   780
  124. End
  125. Begin Control LABEL
  126.       Type         =   "Label"
  127.       Style        =   4
  128.       Caption      =   "Value"
  129.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  130.       Location     =   "Header Block"
  131.       Height       =   285
  132.       Left         =   8250
  133.       Top          =   675
  134.       Width        =   1050
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   4
  139.       Caption      =   "Outstanding"
  140.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  141.       Location     =   "Header Block"
  142.       Height       =   285
  143.       Left         =   8250
  144.       Top          =   945
  145.       Width        =   1050
  146. End
  147. Begin Control CHDOCNO
  148.       Type         =   "Text"
  149.       Style        =   0
  150.       Fieldname    =   "CHDOCNO"
  151.       Filename     =   "STTRNH"
  152.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  153.       Location     =   "Header Block"
  154.       Height       =   270
  155.       Left         =   1080
  156.       Top          =   270
  157.       Width        =   1275
  158. End
  159. Begin Control LABEL
  160.       Type         =   "Label"
  161.       Style        =   1
  162.       Caption      =   "Order No. :"
  163.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  164.       Location     =   "Header Block"
  165.       Height       =   285
  166.       Left         =   30
  167.       Top          =   270
  168.       Width        =   945
  169. End
  170. Begin Control LABEL
  171.       Type         =   "Label"
  172.       Style        =   1
  173.       Caption      =   "Customer ID :"
  174.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  175.       Location     =   "Header Block"
  176.       Height       =   285
  177.       Left         =   2460
  178.       Top          =   270
  179.       Width        =   1080
  180. End
  181. Begin Control LABEL
  182.       Type         =   "Label"
  183.       Style        =   1
  184.       Caption      =   "Date :"
  185.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  186.       Location     =   "Header Block"
  187.       Height       =   285
  188.       Left         =   5025
  189.       Top          =   270
  190.       Width        =   675
  191. End
  192. Begin Control CHTXNDATE
  193.       Type         =   "Text"
  194.       Style        =   0
  195.       Fieldname    =   "CHTXNDATE"
  196.       Filename     =   "STTRNH"
  197.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  198.       Location     =   "Header Block"
  199.       Height       =   270
  200.       Left         =   5790
  201.       Top          =   270
  202.       Width        =   870
  203. End
  204. Begin Control CHACCID
  205.       Type         =   "Text"
  206.       Style        =   0
  207.       Fieldname    =   "CHACCID"
  208.       Filename     =   "STTRNH"
  209.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  210.       Location     =   "Header Block"
  211.       Height       =   270
  212.       Left         =   3570
  213.       Top          =   270
  214.       Width        =   1140
  215. End
  216. Begin Control LABEL
  217.       Type         =   "Label"
  218.       Style        =   1
  219.       Caption      =   "Due Date :"
  220.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  221.       Location     =   "Header Block"
  222.       Height       =   285
  223.       Left         =   6780
  224.       Top          =   270
  225.       Width        =   945
  226. End
  227. Begin Control LABEL
  228.       Type         =   "Label"
  229.       Style        =   12
  230.       Caption      =   "IF(STTRNH.CHDUEDEL<>NULLDATE & STTRNH.CHDUEDEL<DATE(),"<< Order Overdue >>","")"
  231.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  232.       Location     =   "Header Block"
  233.       Height       =   270
  234.       Left         =   8865
  235.       Top          =   270
  236.       Width        =   1755
  237. End
  238. Begin Control LABEL
  239.       Type         =   "Label"
  240.       Style        =   9
  241.       Caption      =   "IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),"")"
  242.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  243.       Location     =   "Header Block"
  244.       Height       =   270
  245.       Left         =   7830
  246.       Top          =   270
  247.       Width        =   810
  248. End
  249. Begin Control CDPRODID
  250.       Type         =   "Text"
  251.       Style        =   0
  252.       Fieldname    =   "CDPRODID"
  253.       Filename     =   "STTRND"
  254.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  255.       Location     =   "Transaction Block"
  256.       Height       =   270
  257.       Left         =   30
  258.       Top          =   165
  259.       Width        =   1770
  260. End
  261. Begin Control CDDESC
  262.       Type         =   "Text"
  263.       Style        =   0
  264.       Fieldname    =   "CDDESC"
  265.       Filename     =   "STTRND"
  266.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  267.       Location     =   "Transaction Block"
  268.       Height       =   270
  269.       Left         =   2220
  270.       Top          =   165
  271.       Width        =   2625
  272. End
  273. Begin Control CDQUANTITY
  274.       Type         =   "Text"
  275.       Style        =   0
  276.       Fieldname    =   "CDQUANTITY"
  277.       Filename     =   "STTRND"
  278.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Transaction Block"
  280.       Height       =   270
  281.       Left         =   5910
  282.       Top          =   165
  283.       Width        =   870
  284. End
  285. Begin Control CNUNITDESC
  286.       Type         =   "Text"
  287.       Style        =   0
  288.       Fieldname    =   "CNUNITDESC"
  289.       Filename     =   "STNAME"
  290.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  291.       Location     =   "Transaction Block"
  292.       Height       =   270
  293.       Left         =   5160
  294.       Top          =   165
  295.       Width        =   510
  296. End
  297. Begin Control CDQTYBAL
  298.       Type         =   "Text"
  299.       Style        =   0
  300.       Fieldname    =   "CDQTYBAL"
  301.       Filename     =   "STTRND"
  302.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  303.       Location     =   "Transaction Block"
  304.       Height       =   270
  305.       Left         =   7050
  306.       Top          =   165
  307.       Width        =   870
  308. End
  309. Begin Control LABEL
  310.       Type         =   "Label"
  311.       Style        =   10
  312.       Caption      =   "IF(STTRND.CDQUANTITY<>STTRND.CDQTYBAL,STR((STTRND.CDQTYBAL/STTRND.CDQUANTITY)*STTRND.CDGOODSOVR,10,2),STR(STTRND.CDGOODSOVR,10,2))"
  313.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  314.       Location     =   "Transaction Block"
  315.       Height       =   270
  316.       Left         =   8190
  317.       Top          =   165
  318.       Width        =   945
  319. End
  320. Begin Control LABEL
  321.       Type         =   "Label"
  322.       Style        =   9
  323.       Caption      =   ""Total Value Outstanding for Order = ""
  324.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  325.       Location     =   "Subtotal Block"
  326.       Height       =   270
  327.       Left         =   5715
  328.       Top          =   570
  329.       Width        =   2430
  330. End
  331. Begin Control LABEL
  332.       Type         =   "Label"
  333.       Style        =   10
  334.       Caption      =   "STR(REPTOT(0),10,2)"
  335.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  336.       Location     =   "Subtotal Block"
  337.       Height       =   270
  338.       Left         =   8190
  339.       Top          =   570
  340.       Width        =   945
  341. End
  342. Begin Control LABEL
  343.       Type         =   "Label"
  344.       Style        =   10
  345.       Caption      =   "STR(REPTOT(1),10,2)"
  346.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  347.       Location     =   "Footer Block"
  348.       Height       =   270
  349.       Left         =   8190
  350.       Top          =   300
  351.       Width        =   945
  352. End
  353. Begin Control LABEL
  354.       Type         =   "Label"
  355.       Style        =   9
  356.       Caption      =   ""Total Value Outstanding = ""
  357.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  358.       Location     =   "Footer Block"
  359.       Height       =   270
  360.       Left         =   5715
  361.       Top          =   300
  362.       Width        =   2430
  363. End
  364.