home *** CD-ROM | disk | FTP | other *** search
/ Jason Aller Floppy Collection / 160.img / A4V11B-2.ZIP / REPORT.ZIP / RECEIVBL.R4A < prev    next >
Encoding:
Text File  |  1989-11-17  |  3.5 KB  |  225 lines
  1. A4,2,1,0
  2. A-Report with complex calculated fields
  3. 0,0,0
  4. 1,2,6
  5. 7,2,6
  6. 0,0,0
  7. 0,0,0
  8. 0,0,0
  9. 0,0,0
  10. 0,0,0
  11. 0,0,0
  12. 0,0,0
  13. 0,0,0
  14. 0,0,0
  15. 13,2,2
  16. 0,0,0
  17. 0,0,0
  18. 0,0,0
  19. 0,0,0
  20. 0,0,0
  21. 0,0,0
  22. 0,0,0
  23. 0,0,0
  24. 15,2,4
  25. 0,0,0
  26. 19,2,3
  27. 22
  28. ─ Page Header ────────────────────────────────────────────────────────────────┐
  29.                
  30.                                                             PAGE:
  31.  
  32.            ACCOUNTS RECEIVABLE AGING - BY COMPANY
  33.            --------------------------------------
  34. ─ Titles ─────────────────────────────────────────────────────────────────────┐
  35.  
  36.                        ---------- Days Overdue -----------
  37.                                                      ABOVE     TOTAL
  38. COMPANY        INV#     1-30     31-60     61-90       90       DUE
  39. ------------   ----    -------   -------   -------   ------   --------
  40. ─ Detail ─────────────────────────────────────────────────────────────────────┐
  41.                                                               
  42. ─ Group 1 Footer ─────────────────────────────────────────────────────────────┐
  43.                        -------   -------   -------   -------  --------
  44.                                                               
  45.  
  46. ─ Summary Section ────────────────────────────────────────────────────────────┐
  47.                        =======   =======   =======   =======  ========
  48.                                                               
  49. ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
  50. 5
  51. UPTO30
  52. IF(CTOD("10/30/88")-INVDATE<=30, AMOUNTDUE, 0)
  53. FROM31TO60
  54. IF(CTOD("10/30/88")-INVDATE>31 .AND. CTOD("10/30/88")-INVDATE<=60, AMOUNTDUE, 0)
  55. FROM61TO90
  56. IF(CTOD("10/30/88")-INVDATE>61 .AND. CTOD("10/30/88")-INVDATE<=90, AMOUNTDUE, 0)
  57. ABOVE90
  58. IF(CTOD("10/30/88")-INVDATE>90, AMOUNTDUE, 0)
  59. TOTALDUE
  60. UPTO30 + FROM31TO60 + FROM61TO90 + ABOVE90
  61. 10
  62. G1UPTO30
  63. 8,N,2,255,0,1,3,0,0
  64. CALC
  65. UPTO30
  66. G131TO60
  67. 8,N,2,255,1,1,3,0,0
  68. CALC
  69. FROM31TO60
  70. G161TO90
  71. 8,N,2,255,2,1,3,0,0
  72. CALC
  73. FROM61TO90
  74. G1ABOVE90
  75. 8,N,2,255,3,1,3,0,0
  76. CALC
  77. ABOVE90
  78. G1TOTALDUE
  79. 8,N,2,255,4,1,3,0,0
  80. CALC
  81. TOTALDUE
  82. GRUPTO30
  83. 8,N,2,255,0,1,1,0,0
  84. CALC
  85. UPTO30
  86. GR31TO60
  87. 8,N,2,255,1,1,1,0,0
  88. CALC
  89. FROM31TO60
  90. GR61TO90
  91. 8,N,2,255,2,1,1,0,0
  92. CALC
  93. FROM61TO90
  94. GRABOVE90
  95. 8,N,2,255,3,1,1,0,0
  96. CALC
  97. ABOVE90
  98. GRTOTALDUE
  99. 8,N,2,255,4,1,1,0,0
  100. CALC
  101. TOTALDUE
  102. 19
  103. 0,1,1,59,250,1,68,8,10,10,1,2,0
  104. 1
  105. V
  106.  
  107. SYSTEM
  108. DATE
  109. 0,1,2,67,250,0,78,10,2,2,1,2,0
  110. N
  111. V
  112.  
  113. SYSTEM
  114. PAGENUMBER
  115. 0,12,13,1,0,0,67,12,12,12,1,0,0
  116. N
  117. U
  118.  
  119. RECEIVBL
  120. COMPANY
  121. 0,12,13,16,0,1,67,4,4,4,1,0,0
  122. N
  123. V
  124.  
  125. RECEIVBL
  126. INVOICE
  127. 0,12,13,24,255,0,78,8,7,7,1,2,2
  128. B
  129. V
  130.  
  131. CALC
  132. UPTO30
  133. 0,12,13,34,255,1,78,8,7,7,1,2,2
  134. B
  135. V
  136.  
  137. CALC
  138. FROM31TO60
  139. 0,12,13,44,255,2,78,8,7,7,1,2,2
  140. B
  141. V
  142.  
  143. CALC
  144. FROM61TO90
  145. 0,12,13,54,255,3,78,8,7,7,1,2,2
  146. B
  147. V
  148.  
  149. CALC
  150. ABOVE90
  151. 0,12,13,63,255,4,78,8,8,8,1,2,2
  152. N
  153. V
  154.  
  155. CALC
  156. TOTALDUE
  157. 0,21,16,24,253,0,78,8,7,7,1,2,2
  158. N
  159. V
  160.  
  161. SUMMARY
  162. G1UPTO30
  163. 0,21,16,34,253,1,78,8,7,7,1,2,2
  164. N
  165. V
  166.  
  167. SUMMARY
  168. G131TO60
  169. 0,21,16,44,253,2,78,8,7,7,1,2,2
  170. N
  171. V
  172.  
  173. SUMMARY
  174. G161TO90
  175. 0,21,16,54,253,3,78,8,7,7,1,2,2
  176. N
  177. V
  178.  
  179. SUMMARY
  180. G1ABOVE90
  181. 0,21,16,63,253,4,78,8,8,8,1,2,2
  182. N
  183. V
  184.  
  185. SUMMARY
  186. G1TOTALDUE
  187. 0,23,20,24,253,5,78,8,7,7,1,2,2
  188. N
  189. V
  190.  
  191. SUMMARY
  192. GRUPTO30
  193. 0,23,20,34,253,6,78,8,7,7,1,2,2
  194. N
  195. V
  196.  
  197. SUMMARY
  198. GR31TO60
  199. 0,23,20,44,253,7,78,8,7,7,1,2,2
  200. N
  201. V
  202.  
  203. SUMMARY
  204. GR61TO90
  205. 0,23,20,54,253,8,78,8,7,7,1,2,2
  206. N
  207. V
  208.  
  209. SUMMARY
  210. GRABOVE90
  211. 0,23,20,63,253,9,78,8,8,8,1,2,2
  212. N
  213. V
  214.  
  215. SUMMARY
  216. GRTOTALDUE
  217. 1
  218. 0,0,0,0,0,0,0,0
  219. RECEIVBL
  220. COMPANY
  221. 80,0,1,0,0,0,0,0,0,0,0,0,0
  222. 1,97,1,0,1,49,0,0,1
  223.  
  224. 0,0,0,0,1,66
  225.