home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / SLODUE.REP < prev    next >
Text File  |  1996-10-08  |  16KB  |  471 lines
  1. VERSION 2.00
  2. Begin Report SLODUE.REP
  3.       Caption      =   "SLODUE.REP"
  4.       Width        =   11175
  5.       Height       =   15915
  6.       Reportheader =   120
  7.       Header       =   135
  8.       Transaction  =   14460
  9.       SubTotal     =   345
  10.       Footer       =   0
  11.       Pagefooter   =   15345
  12.       Replicate    =   14055
  13.       Style        =   13
  14.       Query        =   "SLNAME "
  15.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  16.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  17.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  18.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(4) = 0"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(5) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(6) = 0"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(7) = 0"
  23. End
  24. Begin Control LABEL
  25.       Type         =   "Label"
  26.       Style        =   9
  27.       Caption      =   "IF(SLNAME.SNDUEDTOPT=0 | SLNAME.SNPAYDAYS<>31,"","Payment due on the last day of the month, "+STR(SLNAME.SNDUEDTOPT,2,0)+(IF(SLNAME.SNDUEDTOPT=1," month following invoice date"," months following invoice date")))"
  28.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  29.       Location     =   "Transaction Block"
  30.       Height       =   270
  31.       Left         =   2700
  32.       Top          =   6495
  33.       Width        =   8235
  34. End
  35. Begin Control SNNAME
  36.       Type         =   "Text"
  37.       Style        =   0
  38.       Fieldname    =   "SNNAME"
  39.       Filename     =   "SLNAME"
  40.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Transaction Block"
  42.       Height       =   270
  43.       Left         =   810
  44.       Top          =   2850
  45.       Width        =   2700
  46. End
  47. Begin Control SNADD1
  48.       Type         =   "Text"
  49.       Style        =   0
  50.       Fieldname    =   "SNADD1"
  51.       Filename     =   "SLNAME"
  52.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  53.       Location     =   "Transaction Block"
  54.       Height       =   270
  55.       Left         =   810
  56.       Top          =   3120
  57.       Width        =   2700
  58. End
  59. Begin Control SNADD2
  60.       Type         =   "Text"
  61.       Style        =   0
  62.       Fieldname    =   "SNADD2"
  63.       Filename     =   "SLNAME"
  64.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  65.       Location     =   "Transaction Block"
  66.       Height       =   270
  67.       Left         =   810
  68.       Top          =   3390
  69.       Width        =   2700
  70. End
  71. Begin Control SNADD3
  72.       Type         =   "Text"
  73.       Style        =   0
  74.       Fieldname    =   "SNADD3"
  75.       Filename     =   "SLNAME"
  76.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  77.       Location     =   "Transaction Block"
  78.       Height       =   270
  79.       Left         =   810
  80.       Top          =   3660
  81.       Width        =   2700
  82. End
  83. Begin Control SNADD4
  84.       Type         =   "Text"
  85.       Style        =   0
  86.       Fieldname    =   "SNADD4"
  87.       Filename     =   "SLNAME"
  88.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  89.       Location     =   "Transaction Block"
  90.       Height       =   270
  91.       Left         =   810
  92.       Top          =   3930
  93.       Width        =   2700
  94. End
  95. Begin Control SNPOSTCODE
  96.       Type         =   "Text"
  97.       Style        =   0
  98.       Fieldname    =   "SNPOSTCODE"
  99.       Filename     =   "SLNAME"
  100.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Transaction Block"
  102.       Height       =   270
  103.       Left         =   810
  104.       Top          =   4200
  105.       Width        =   2700
  106. End
  107. Begin Control SNACCOUNT
  108.       Type         =   "Text"
  109.       Style        =   0
  110.       Fieldname    =   "SNACCOUNT"
  111.       Filename     =   "SLNAME"
  112.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  113.       Location     =   "Transaction Block"
  114.       Height       =   270
  115.       Left         =   5265
  116.       Top          =   2850
  117.       Width        =   1350
  118. End
  119. Begin Control LABEL
  120.       Type         =   "Label"
  121.       Style        =   10
  122.       Caption      =   ""Customer ID""
  123.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  124.       Location     =   "Transaction Block"
  125.       Height       =   270
  126.       Left         =   4050
  127.       Top          =   2850
  128.       Width        =   1080
  129. End
  130. Begin Control COMPNAME
  131.       Type         =   "Text"
  132.       Style        =   0
  133.       Fieldname    =   "COMPNAME"
  134.       Filename     =   "SYSTEM"
  135.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  136.       Location     =   "Transaction Block"
  137.       Height       =   270
  138.       Left         =   810
  139.       Top          =   825
  140.       Width        =   4050
  141. End
  142. Begin Control COMPADD1
  143.       Type         =   "Text"
  144.       Style        =   0
  145.       Fieldname    =   "COMPADD1"
  146.       Filename     =   "SYSTEM"
  147.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  148.       Location     =   "Transaction Block"
  149.       Height       =   270
  150.       Left         =   810
  151.       Top          =   1095
  152.       Width        =   3240
  153. End
  154. Begin Control LABEL
  155.       Type         =   "Label"
  156.       Style        =   1
  157.       Caption      =   "Telephone No."
  158.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  159.       Location     =   "Transaction Block"
  160.       Height       =   270
  161.       Left         =   6750
  162.       Top          =   825
  163.       Width        =   1080
  164. End
  165. Begin Control COMPADD2
  166.       Type         =   "Text"
  167.       Style        =   0
  168.       Fieldname    =   "COMPADD2"
  169.       Filename     =   "SYSTEM"
  170.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  171.       Location     =   "Transaction Block"
  172.       Height       =   270
  173.       Left         =   810
  174.       Top          =   1365
  175.       Width        =   3240
  176. End
  177. Begin Control COMPADD3
  178.       Type         =   "Text"
  179.       Style        =   0
  180.       Fieldname    =   "COMPADD3"
  181.       Filename     =   "SYSTEM"
  182.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  183.       Location     =   "Transaction Block"
  184.       Height       =   270
  185.       Left         =   810
  186.       Top          =   1635
  187.       Width        =   3240
  188. End
  189. Begin Control COMPADD4
  190.       Type         =   "Text"
  191.       Style        =   0
  192.       Fieldname    =   "COMPADD4"
  193.       Filename     =   "SYSTEM"
  194.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  195.       Location     =   "Transaction Block"
  196.       Height       =   270
  197.       Left         =   810
  198.       Top          =   1905
  199.       Width        =   3240
  200. End
  201. Begin Control LABEL
  202.       Type         =   "Label"
  203.       Style        =   1
  204.       Caption      =   "Facsimile No."
  205.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  206.       Location     =   "Transaction Block"
  207.       Height       =   270
  208.       Left         =   6750
  209.       Top          =   1095
  210.       Width        =   1080
  211. End
  212. Begin Control COUNTRY
  213.       Type         =   "Text"
  214.       Style        =   0
  215.       Fieldname    =   "COUNTRY"
  216.       Filename     =   "SYSTEM"
  217.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  218.       Location     =   "Transaction Block"
  219.       Height       =   270
  220.       Left         =   7830
  221.       Top          =   1365
  222.       Width        =   405
  223. End
  224. Begin Control LABEL
  225.       Type         =   "Label"
  226.       Style        =   1
  227.       Caption      =   "VAT Reg. No."
  228.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  229.       Location     =   "Transaction Block"
  230.       Height       =   270
  231.       Left         =   6750
  232.       Top          =   1365
  233.       Width        =   1005
  234. End
  235. Begin Control COMPTEL
  236.       Type         =   "Text"
  237.       Style        =   0
  238.       Fieldname    =   "COMPTEL"
  239.       Filename     =   "SYSTEM"
  240.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  241.       Location     =   "Transaction Block"
  242.       Height       =   270
  243.       Left         =   7830
  244.       Top          =   825
  245.       Width        =   2160
  246. End
  247. Begin Control COMPFAX
  248.       Type         =   "Text"
  249.       Style        =   0
  250.       Fieldname    =   "COMPFAX"
  251.       Filename     =   "SYSTEM"
  252.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  253.       Location     =   "Transaction Block"
  254.       Height       =   270
  255.       Left         =   7830
  256.       Top          =   1095
  257.       Width        =   2160
  258. End
  259. Begin Control VATREG
  260.       Type         =   "Text"
  261.       Style        =   0
  262.       Fieldname    =   "VATREG"
  263.       Filename     =   "SYSTEM"
  264.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  265.       Location     =   "Transaction Block"
  266.       Height       =   270
  267.       Left         =   8235
  268.       Top          =   1365
  269.       Width        =   2160
  270. End
  271. Begin Control LABEL
  272.       Type         =   "Label"
  273.       Style        =   9
  274.       Caption      =   ""Dear Sirs,""
  275.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  276.       Location     =   "Transaction Block"
  277.       Height       =   270
  278.       Left         =   810
  279.       Top          =   4875
  280.       Width        =   1215
  281. End
  282. Begin Control LABEL
  283.       Type         =   "Label"
  284.       Style        =   9
  285.       Caption      =   "IIF(SLNAME.SNTHISTYPE=1,REPSTR(1),IIF(SLNAME.SNTHISTYPE=2,REPSTR(2),REPSTR(3)))"
  286.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  287.       Location     =   "Transaction Block"
  288.       Height       =   3915
  289.       Left         =   810
  290.       Top          =   7710
  291.       Width        =   9315
  292. End
  293. Begin Control LABEL
  294.       Type         =   "Label"
  295.       Style        =   9
  296.       Caption      =   ""Account Balance:""
  297.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  298.       Location     =   "Transaction Block"
  299.       Height       =   270
  300.       Left         =   810
  301.       Top          =   6090
  302.       Width        =   1755
  303. End
  304. Begin Control LABEL
  305.       Type         =   "Label"
  306.       Style        =   9
  307.       Caption      =   ""Credit Terms:""
  308.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  309.       Location     =   "Transaction Block"
  310.       Height       =   270
  311.       Left         =   810
  312.       Top          =   6495
  313.       Width        =   1755
  314. End
  315. Begin Control LABEL
  316.       Type         =   "Label"
  317.       Style        =   9
  318.       Caption      =   ""Amount Overdue:""
  319.       Font         =   "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  320.       Location     =   "Transaction Block"
  321.       Height       =   270
  322.       Left         =   810
  323.       Top          =   7035
  324.       Width        =   1890
  325. End
  326. Begin Control SNBALANCE
  327.       Type         =   "Text"
  328.       Style        =   0
  329.       Fieldname    =   "SNBALANCE"
  330.       Filename     =   "SLNAME"
  331.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  332.       Location     =   "Transaction Block"
  333.       Height       =   270
  334.       Left         =   2700
  335.       Top          =   6090
  336.       Width        =   1485
  337. End
  338. Begin Control LABEL
  339.       Type         =   "Label"
  340.       Style        =   9
  341.       Caption      =   "IF(SLNAME.SNDUEDTOPT=0 | SLNAME.SNPAYDAYS=31,"","Payment due on the "+STR(SLNAME.SNPAYDAYS,3,0)+(IF((RIGHT(STR(SLNAME.SNPAYDAYS,3,0),1)>"3" & RIGHT(STR(SLNAME.SNPAYDAYS,3,0),1)<="9") | RIGHT(STR(SLNAME.SNPAYDAYS,3,0),1)="0" | (SLNAME.SNPAYDAYS>10 & SLNAME.SNPAYDAYS<14), "th",IF(RIGHT(STR(SLNAME.SNPAYDAYS,3,0),1)="1","st",IF(RIGHT(STR(SLNAME.SNPAYDAYS,3,0),1)="2","nd","rd"))))+" day of the "+STR(SLNAME.SNDUEDTOPT,2,0)+(IF((RIGHT(STR(SLNAME.SNDUEDTOPT,2,0),1)>"3" & RIGHT(STR(SLNAME.SNDUEDTOPT,2,0),1)<="9") | RIGHT(STR(SLNAME.SNDUEDTOPT,2,0),1)="0" | (SLNAME.SNDUEDTOPT>10 & SLNAME.SNDUEDTOPT<14), "th",IF(RIGHT(STR(SLNAME.SNDUEDTOPT,2,0),1)="1","st",IF(RIGHT(STR(SLNAME.SNDUEDTOPT,2,0),1)="2","nd","rd"))))+" month following invoice date")"
  342.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  343.       Location     =   "Transaction Block"
  344.       Height       =   270
  345.       Left         =   2700
  346.       Top          =   6495
  347.       Width        =   7695
  348. End
  349. Begin Control LABEL
  350.       Type         =   "Label"
  351.       Style        =   12
  352.       Caption      =   ""Overdue Account Reminder""
  353.       Font         =   "-225|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  354.       Location     =   "Transaction Block"
  355.       Height       =   270
  356.       Left         =   810
  357.       Top          =   5280
  358.       Width        =   9855
  359. End
  360. Begin Control LABEL
  361.       Type         =   "Label"
  362.       Style        =   9
  363.       Caption      =   "REPSTR(8)"
  364.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  365.       Location     =   "Transaction Block"
  366.       Height       =   270
  367.       Left         =   810
  368.       Top          =   12030
  369.       Width        =   1485
  370. End
  371. Begin Control LABEL
  372.       Type         =   "Label"
  373.       Style        =   9
  374.       Caption      =   "REPSTR(9)"
  375.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  376.       Location     =   "Transaction Block"
  377.       Height       =   270
  378.       Left         =   810
  379.       Top          =   13500
  380.       Width        =   3105
  381. End
  382. Begin Control LABEL
  383.       Type         =   "Label"
  384.       Style        =   9
  385.       Caption      =   ""Credit Control Department""
  386.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  387.       Location     =   "Transaction Block"
  388.       Height       =   270
  389.       Left         =   810
  390.       Top          =   13785
  391.       Width        =   3105
  392. End
  393. Begin Control LABEL
  394.       Type         =   "Label"
  395.       Style        =   10
  396.       Caption      =   ""Date""
  397.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  398.       Location     =   "Transaction Block"
  399.       Height       =   270
  400.       Left         =   8100
  401.       Top          =   2850
  402.       Width        =   1080
  403. End
  404. Begin Control SNOVERDUE
  405.       Type         =   "Text"
  406.       Style        =   0
  407.       Fieldname    =   "SNOVERDUE"
  408.       Filename     =   "SLNAME"
  409.       Font         =   "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  410.       Location     =   "Transaction Block"
  411.       Height       =   270
  412.       Left         =   2700
  413.       Top          =   7035
  414.       Width        =   1485
  415. End
  416. Begin Control LABEL
  417.       Type         =   "Label"
  418.       Style        =   10
  419.       Caption      =   ""Letter No.""
  420.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  421.       Location     =   "Transaction Block"
  422.       Height       =   270
  423.       Left         =   6750
  424.       Top          =   2850
  425.       Width        =   900
  426. End
  427. Begin Control SNTHISTYPE
  428.       Type         =   "Text"
  429.       Style        =   0
  430.       Fieldname    =   "SNTHISTYPE"
  431.       Filename     =   "SLNAME"
  432.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  433.       Location     =   "Transaction Block"
  434.       Height       =   270
  435.       Left         =   7800
  436.       Top          =   2850
  437.       Width        =   195
  438. End
  439. Begin Control TXNDATE
  440.       Type         =   "Text"
  441.       Style        =   0
  442.       Fieldname    =   "TXNDATE"
  443.       Filename     =   "RUNTIME"
  444.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  445.       Location     =   "Transaction Block"
  446.       Height       =   270
  447.       Left         =   9315
  448.       Top          =   2850
  449.       Width        =   1215
  450. End
  451. Begin Control GRAFIX
  452.       Type         =   "Picture"
  453.       Style        =   1
  454.       Location     =   "Transaction Block"
  455.       Height       =   1215
  456.       Left         =   810
  457.       Top          =   12300
  458.       Width        =   2835
  459. End
  460. Begin Control LABEL
  461.       Type         =   "Label"
  462.       Style        =   10
  463.       Caption      =   "IF(SLNAME.SNDUEDTOPT=0,STR(SLNAME.SNPAYDAYS,2,0)+" Days","")"
  464.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  465.       Location     =   "Transaction Block"
  466.       Height       =   270
  467.       Left         =   2700
  468.       Top          =   6495
  469.       Width        =   1485
  470. End
  471.