git.roojs.org Git - xtuple/blob - foundation-database/public/tables/report/BankrecHistory.xml

   1 <!DOCTYPE openRPTDef>
   2 <report>
   3  <title>Bank Reconciliation History</title>
   4  <name>BankrecHistory</name>
   5  <description></description>
   6  <grid>
   7   <snap/>
   8   <show/>
   9   <x>0.05</x>
  10   <y>0.05</y>
  11  </grid>
  12  <size>Letter</size>
  13  <portrait/>
  14  <topmargin>50</topmargin>
  15  <bottommargin>50</bottommargin>
  16  <rightmargin>50</rightmargin>
  17  <leftmargin>50</leftmargin>
  18  <querysource loadFromDb="true">
  19   <name>reconciled</name>
  20   <mqlgroup>bankrecHistory</mqlgroup>
  21   <mqlname>reconciled</mqlname>
  22  </querysource>
  23  <querysource>
  24   <name>head</name>
  25   <sql>SELECT (bankaccnt_name || '-' || bankaccnt_descrip) AS f_bankaccnt,
  26        (formatDate(bankrec_opendate) || '-' || formatDate(bankrec_enddate)) AS f_bankrec,
  27        bankrec_username AS f_username, formatDate(bankrec_created) AS f_created,
  28        formatDate(bankrec_opendate) AS f_opendate,
  29        formatDate(bankrec_enddate) AS f_enddate,
  30        formatMoney(bankrec_openbal) AS f_openbal,
  31        formatMoney(bankrec_endbal) AS f_endbal,
  32        text('Opening Balance') AS f_opendescrip,
  33        text('Ending Balance') AS f_enddescrip
  34   FROM bankrec, bankaccnt
  35  WHERE ((bankrec_bankaccnt_id=bankaccnt_id)
  36    AND  (bankrec_id=&lt;? value("bankrec_id") ?>));</sql>
  37  </querysource>
  38  <querysource>
  39   <name>Subtotal</name>
  40   <sql>SELECT
  41    formatMoney(COALESCE(MAX(selrec.bankrec_endbal) +
  42 --   SUM(currtolocal(bankaccnt_curr_id,gltrans_amount,gltrans_date) * -1),0)) AS amount
  43    SUM(currtolocal(bankaccnt_curr_id,gltrans_amount,gltrans_date)),0)) AS amount
  44  FROM gltrans
  45    JOIN bankaccnt ON (bankaccnt_accnt_id = gltrans_accnt_id)
  46    JOIN bankrec selrec ON ((selrec.bankrec_bankaccnt_id = bankaccnt_id)
  47                        AND (selrec.bankrec_id=&lt;? value("bankrec_id") ?>))
  48    LEFT OUTER JOIN bankrecitem ON ((bankrecitem_source='GL')
  49                               AND (bankrecitem_source_id=gltrans_id))
  50    LEFT OUTER JOIN bankrec actrec ON (actrec.bankrec_id = bankrecitem_bankrec_id)
  51  WHERE ((COALESCE(actrec.bankrec_postdate,endoftime()) > COALESCE(selrec.bankrec_postdate,now()))
  52  AND (gltrans_doctype='CK'))</sql>
  53  </querysource>
  54  <querysource>
  55   <name>ActualAmount</name>
  56   <sql>SELECT
  57    formatMoney(COALESCE(MAX(selrec.bankrec_endbal) +
  58 --   SUM(currtolocal(bankaccnt_curr_id,gltrans_amount,gltrans_date) * -1),0)) AS amount
  59    SUM(currtolocal(bankaccnt_curr_id,gltrans_amount,gltrans_date)),0)) AS amount
  60  FROM gltrans
  61    JOIN bankaccnt ON (bankaccnt_accnt_id = gltrans_accnt_id)
  62    JOIN bankrec selrec ON ((selrec.bankrec_bankaccnt_id = bankaccnt_id)
  63                        AND (selrec.bankrec_id=&lt;? value("bankrec_id") ?>))
  64    LEFT OUTER JOIN bankrecitem ON ((bankrecitem_source='GL')
  65
  66                               AND (bankrecitem_source_id=gltrans_id))
  67    LEFT OUTER JOIN bankrec actrec ON (actrec.bankrec_id = bankrecitem_bankrec_id)
  68  WHERE (COALESCE(actrec.bankrec_postdate,endoftime()) > COALESCE(selrec.bankrec_postdate,now()))</sql>
  69  </querysource>
  70  <querysource loadFromDb="true">
  71   <name>unreconciled</name>
  72   <mqlgroup>bankrecHistory</mqlgroup>
  73   <mqlname>unreconciled</mqlname>
  74  </querysource>
  75  <rpthead>
  76   <height>166</height>
  77   <label>
  78    <rect>
  79     <x>645</x>
  80     <y>100</y>
  81     <width>100</width>
  82     <height>15</height>
  83    </rect>
  84    <font>
  85     <face>Arial</face>
  86     <size>8</size>
  87     <weight>normal</weight>
  88    </font>
  89    <hcenter/>
  90    <vcenter/>
  91    <string>Amount</string>
  92   </label>
  93   <label>
  94    <rect>
  95     <x>370</x>
  96     <y>50</y>
  97     <width>100</width>
  98     <height>15</height>
  99    </rect>
 100    <font>
 101     <face>Arial</face>
 102     <size>8</size>
 103     <weight>normal</weight>
 104    </font>
 105    <right/>
 106    <vcenter/>
 107    <string>Posted By:</string>
 108   </label>
 109   <field>
 110    <rect>
 111     <x>100</x>
 112     <y>148</y>
 113     <width>535</width>
 114     <height>15</height>
 115    </rect>
 116    <font>
 117     <face>Arial</face>
 118     <size>8</size>
 119     <weight>bold</weight>
 120    </font>
 121    <left/>
 122    <vcenter/>
 123    <data>
 124     <query>head</query>
 125     <column>f_opendescrip</column>
 126    </data>
 127   </field>
 128   <label>
 129    <rect>
 130     <x>100</x>
 131     <y>100</y>
 132     <width>150</width>
 133     <height>15</height>
 134    </rect>
 135    <font>
 136     <face>Arial</face>
 137     <size>8</size>
 138     <weight>normal</weight>
 139    </font>
 140    <left/>
 141    <vcenter/>
 142    <string>Doc. Number/Notes</string>
 143   </label>
 144   <field>
 145    <rect>
 146     <x>145</x>
 147     <y>65</y>
 148     <width>220</width>
 149     <height>15</height>
 150    </rect>
 151    <font>
 152     <face>Arial</face>
 153     <size>8</size>
 154     <weight>bold</weight>
 155    </font>
 156    <left/>
 157    <vcenter/>
 158    <data>
 159     <query>head</query>
 160     <column>f_bankrec</column>
 161    </data>
 162   </field>
 163   <line>
 164    <xstart>5</xstart>
 165    <ystart>115</ystart>
 166    <xend>745</xend>
 167    <yend>115</yend>
 168    <weight>2</weight>
 169   </line>
 170   <label>
 171    <rect>
 172     <x>370</x>
 173     <y>65</y>
 174     <width>100</width>
 175     <height>15</height>
 176    </rect>
 177    <font>
 178     <face>Arial</face>
 179     <size>8</size>
 180     <weight>normal</weight>
 181    </font>
 182    <right/>
 183    <vcenter/>
 184    <string>Date Posted:</string>
 185   </label>
 186   <field>
 187    <rect>
 188     <x>145</x>
 189     <y>50</y>
 190     <width>245</width>
 191     <height>15</height>
 192    </rect>
 193    <font>
 194     <face>Arial</face>
 195     <size>8</size>
 196     <weight>bold</weight>
 197    </font>
 198    <left/>
 199    <vcenter/>
 200    <data>
 201     <query>head</query>
 202     <column>f_bankaccnt</column>
 203    </data>
 204   </field>
 205   <field>
 206    <rect>
 207     <x>475</x>
 208     <y>65</y>
 209     <width>220</width>
 210     <height>15</height>
 211    </rect>
 212    <font>
 213     <face>Arial</face>
 214     <size>8</size>
 215     <weight>bold</weight>
 216    </font>
 217    <left/>
 218    <vcenter/>
 219    <data>
 220     <query>head</query>
 221     <column>f_created</column>
 222    </data>
 223   </field>
 224   <label>
 225    <rect>
 226     <x>10</x>
 227     <y>100</y>
 228     <width>75</width>
 229     <height>15</height>
 230    </rect>
 231    <font>
 232     <face>Arial</face>
 233     <size>8</size>
 234     <weight>normal</weight>
 235    </font>
 236    <left/>
 237    <vcenter/>
 238    <string>Dist. Date</string>
 239   </label>
 240   <label>
 241    <rect>
 242     <x>23</x>
 243     <y>64</y>
 244     <width>117</width>
 245     <height>15</height>
 246    </rect>
 247    <font>
 248     <face>Arial</face>
 249     <size>8</size>
 250     <weight>normal</weight>
 251    </font>
 252    <right/>
 253    <vcenter/>
 254    <string>Bank Rec. Post:</string>
 255   </label>
 256   <field>
 257    <rect>
 258     <x>9</x>
 259     <y>148</y>
 260     <width>80</width>
 261     <height>15</height>
 262    </rect>
 263    <font>
 264     <face>Arial</face>
 265     <size>8</size>
 266     <weight>bold</weight>
 267    </font>
 268    <hcenter/>
 269    <vcenter/>
 270    <data>
 271     <query>head</query>
 272     <column>f_opendate</column>
 273    </data>
 274   </field>
 275   <field>
 276    <rect>
 277     <x>475</x>
 278     <y>50</y>
 279     <width>220</width>
 280     <height>15</height>
 281    </rect>
 282    <font>
 283     <face>Arial</face>
 284     <size>8</size>
 285     <weight>bold</weight>
 286    </font>
 287    <left/>
 288    <vcenter/>
 289    <data>
 290     <query>head</query>
 291     <column>f_username</column>
 292    </data>
 293   </field>
 294   <label>
 295    <rect>
 296     <x>40</x>
 297     <y>50</y>
 298     <width>100</width>
 299     <height>15</height>
 300    </rect>
 301    <font>
 302     <face>Arial</face>
 303     <size>8</size>
 304     <weight>normal</weight>
 305    </font>
 306    <right/>
 307    <vcenter/>
 308    <string>Bark Account:</string>
 309   </label>
 310   <label>
 311    <rect>
 312     <x>280</x>
 313     <y>5</y>
 314     <width>465</width>
 315     <height>38</height>
 316    </rect>
 317    <font>
 318     <face>Arial</face>
 319     <size>18</size>
 320     <weight>bold</weight>
 321    </font>
 322    <right/>
 323    <vcenter/>
 324    <string>Bank Reconciliation History</string>
 325   </label>
 326   <field>
 327    <rect>
 328     <x>644</x>
 329     <y>148</y>
 330     <width>100</width>
 331     <height>15</height>
 332    </rect>
 333    <font>
 334     <face>Arial</face>
 335     <size>8</size>
 336     <weight>bold</weight>
 337    </font>
 338    <right/>
 339    <vcenter/>
 340    <data>
 341     <query>head</query>
 342     <column>f_openbal</column>
 343    </data>
 344   </field>
 345   <label>
 346    <rect>
 347     <x>5</x>
 348     <y>125</y>
 349     <width>121</width>
 350     <height>15</height>
 351    </rect>
 352    <font>
 353     <face>Arial</face>
 354     <size>9</size>
 355     <weight>bold</weight>
 356    </font>
 357    <left/>
 358    <vcenter/>
 359    <string>Reconciled</string>
 360   </label>
 361  </rpthead>
 362  <pghead>
 363   <firstpage/>
 364   <height>0</height>
 365  </pghead>
 366  <pghead>
 367   <height>31</height>
 368   <line>
 369    <xstart>5</xstart>
 370    <ystart>15</ystart>
 371    <xend>745</xend>
 372    <yend>15</yend>
 373    <weight>2</weight>
 374   </line>
 375   <label>
 376    <rect>
 377     <x>100</x>
 378     <y>0</y>
 379     <width>150</width>
 380     <height>15</height>
 381    </rect>
 382    <font>
 383     <face>Arial</face>
 384     <size>8</size>
 385     <weight>normal</weight>
 386    </font>
 387    <left/>
 388    <vcenter/>
 389    <string>Doc. Number/Notes</string>
 390   </label>
 391   <label>
 392    <rect>
 393     <x>10</x>
 394     <y>0</y>
 395     <width>75</width>
 396     <height>15</height>
 397    </rect>
 398    <font>
 399     <face>Arial</face>
 400     <size>8</size>
 401     <weight>normal</weight>
 402    </font>
 403    <left/>
 404    <vcenter/>
 405    <string>Dist. Date</string>
 406   </label>
 407   <label>
 408    <rect>
 409     <x>645</x>
 410     <y>0</y>
 411     <width>100</width>
 412     <height>15</height>
 413    </rect>
 414    <font>
 415     <face>Arial</face>
 416     <size>8</size>
 417     <weight>normal</weight>
 418    </font>
 419    <hcenter/>
 420    <vcenter/>
 421    <string>Amount</string>
 422   </label>
 423  </pghead>
 424  <section>
 425   <name>reconciled</name>
 426   <group>
 427    <name>reconciled-group</name>
 428    <column>amount_xtnumericrole</column>
 429    <foot>
 430     <height>21</height>
 431     <field>
 432      <rect>
 433       <x>645</x>
 434       <y>3.28</y>
 435       <width>100</width>
 436       <height>15</height>
 437      </rect>
 438      <font>
 439       <face>Arial</face>
 440       <size>8</size>
 441       <weight>bold</weight>
 442      </font>
 443      <right/>
 444      <vcenter/>
 445      <data>
 446       <query>head</query>
 447       <column>f_endbal</column>
 448      </data>
 449     </field>
 450     <field>
 451      <rect>
 452       <x>10</x>
 453       <y>3.28</y>
 454       <width>80</width>
 455       <height>15</height>
 456      </rect>
 457      <font>
 458       <face>Arial</face>
 459       <size>8</size>
 460       <weight>bold</weight>
 461      </font>
 462      <hcenter/>
 463      <vcenter/>
 464      <data>
 465       <query>head</query>
 466       <column>f_enddate</column>
 467      </data>
 468     </field>
 469     <field>
 470      <rect>
 471       <x>100</x>
 472       <y>3.28</y>
 473       <width>200</width>
 474       <height>15</height>
 475      </rect>
 476      <font>
 477       <face>Arial</face>
 478       <size>8</size>
 479       <weight>bold</weight>
 480      </font>
 481      <left/>
 482      <vcenter/>
 483      <data>
 484       <query>head</query>
 485       <column>f_enddescrip</column>
 486      </data>
 487     </field>
 488    </foot>
 489   </group>
 490   <group>
 491    <name>reconciled-type</name>
 492    <column>sort</column>
 493    <head>
 494     <height>27</height>
 495     <field>
 496      <rect>
 497       <x>10</x>
 498       <y>6.78</y>
 499       <width>94</width>
 500       <height>15</height>
 501      </rect>
 502      <font>
 503       <face>Arial</face>
 504       <size>8</size>
 505       <weight>bold</weight>
 506      </font>
 507      <left/>
 508      <vcenter/>
 509      <data>
 510       <query>reconciled</query>
 511       <column>type</column>
 512      </data>
 513     </field>
 514    </head>
 515    <foot>
 516     <height>18</height>
 517     <field>
 518      <rect>
 519       <x>645</x>
 520       <y>2</y>
 521       <width>100</width>
 522       <height>15</height>
 523      </rect>
 524      <font>
 525       <face>Arial</face>
 526       <size>8</size>
 527       <weight>bold</weight>
 528      </font>
 529      <right/>
 530      <vcenter/>
 531      <data>
 532       <query>reconciled</query>
 533       <column>amount</column>
 534      </data>
 535      <format builtin="true">qty</format>
 536      <tracktotal subtotal="true"/>
 537     </field>
 538     <field>
 539      <rect>
 540       <x>438</x>
 541       <y>2</y>
 542       <width>168</width>
 543       <height>15</height>
 544      </rect>
 545      <font>
 546       <face>Arial</face>
 547       <size>8</size>
 548       <weight>bold</weight>
 549      </font>
 550      <left/>
 551      <vcenter/>
 552      <data>
 553       <query>reconciled</query>
 554       <column>type</column>
 555      </data>
 556     </field>
 557     <label>
 558      <rect>
 559       <x>399</x>
 560       <y>2</y>
 561       <width>49</width>
 562       <height>15</height>
 563      </rect>
 564      <font>
 565       <face>Arial</face>
 566       <size>8</size>
 567       <weight>normal</weight>
 568      </font>
 569      <left/>
 570      <vcenter/>
 571      <string>TOTAL</string>
 572     </label>
 573    </foot>
 574   </group>
 575   <detail>
 576    <key>
 577     <query>reconciled</query>
 578    </key>
 579    <height>18</height>
 580    <field>
 581     <rect>
 582      <x>206</x>
 583      <y>0</y>
 584      <width>430</width>
 585      <height>15</height>
 586     </rect>
 587     <font>
 588      <face>Arial</face>
 589      <size>8</size>
 590      <weight>bold</weight>
 591     </font>
 592     <left/>
 593     <vcenter/>
 594     <data>
 595      <query>reconciled</query>
 596      <column>notes</column>
 597     </data>
 598    </field>
 599    <field>
 600     <rect>
 601      <x>645</x>
 602      <y>0</y>
 603      <width>100</width>
 604      <height>15</height>
 605     </rect>
 606     <font>
 607      <face>Arial</face>
 608      <size>8</size>
 609      <weight>bold</weight>
 610     </font>
 611     <right/>
 612     <vcenter/>
 613     <data>
 614      <query>reconciled</query>
 615      <column>f_amount</column>
 616     </data>
 617    </field>
 618    <field>
 619     <rect>
 620      <x>10</x>
 621      <y>0</y>
 622      <width>80</width>
 623      <height>15</height>
 624     </rect>
 625     <font>
 626      <face>Arial</face>
 627      <size>8</size>
 628      <weight>bold</weight>
 629     </font>
 630     <hcenter/>
 631     <vcenter/>
 632     <data>
 633      <query>reconciled</query>
 634      <column>f_date</column>
 635     </data>
 636    </field>
 637    <field>
 638     <rect>
 639      <x>100</x>
 640      <y>-0.182</y>
 641      <width>100</width>
 642      <height>15</height>
 643     </rect>
 644     <font>
 645      <face>Arial</face>
 646      <size>8</size>
 647      <weight>bold</weight>
 648     </font>
 649     <left/>
 650     <vcenter/>
 651     <data>
 652      <query>reconciled</query>
 653      <column>gltrans_docnumber</column>
 654     </data>
 655    </field>
 656   </detail>
 657  </section>
 658  <section>
 659   <name>unreconciled</name>
 660   <group>
 661    <name>unreconciled-group</name>
 662    <column>amount_xtnumericrole</column>
 663    <head>
 664     <height>33</height>
 665     <label>
 666      <rect>
 667       <x>5</x>
 668       <y>10.3</y>
 669       <width>121</width>
 670       <height>15</height>
 671      </rect>
 672      <font>
 673       <face>Arial</face>
 674       <size>9</size>
 675       <weight>bold</weight>
 676      </font>
 677      <left/>
 678      <vcenter/>
 679      <string>Unreconciled</string>
 680     </label>
 681    </head>
 682    <foot>
 683     <height>136.499</height>
 684     <label>
 685      <rect>
 686       <x>454</x>
 687       <y>41.4985</y>
 688       <width>162</width>
 689       <height>15</height>
 690      </rect>
 691      <font>
 692       <face>Arial</face>
 693       <size>8</size>
 694       <weight>normal</weight>
 695      </font>
 696      <right/>
 697      <vcenter/>
 698      <string>Add: Checks in Circulation:</string>
 699     </label>
 700     <label>
 701      <rect>
 702       <x>5</x>
 703       <y>12.5</y>
 704       <width>235</width>
 705       <height>15.5</height>
 706      </rect>
 707      <font>
 708       <face>Arial</face>
 709       <size>9</size>
 710       <weight>bold</weight>
 711      </font>
 712      <left/>
 713      <vcenter/>
 714      <string>General Legder Reconciliation</string>
 715     </label>
 716     <label>
 717      <rect>
 718       <x>453</x>
 719       <y>73.5</y>
 720       <width>163</width>
 721       <height>15</height>
 722      </rect>
 723      <font>
 724       <face>Arial</face>
 725       <size>8</size>
 726       <weight>normal</weight>
 727      </font>
 728      <right/>
 729      <vcenter/>
 730      <string>Deduct: Deposits in Circulation:</string>
 731     </label>
 732     <label>
 733      <rect>
 734       <x>396</x>
 735       <y>105</y>
 736       <width>219</width>
 737       <height>15</height>
 738      </rect>
 739      <font>
 740       <face>Arial</face>
 741       <size>8</size>
 742       <weight>normal</weight>
 743      </font>
 744      <right/>
 745      <vcenter/>
 746      <string>Actual Account Balance:</string>
 747     </label>
 748     <label>
 749      <rect>
 750       <x>454</x>
 751       <y>25.5</y>
 752       <width>162</width>
 753       <height>15</height>
 754      </rect>
 755      <font>
 756       <face>Arial</face>
 757       <size>8</size>
 758       <weight>normal</weight>
 759      </font>
 760      <right/>
 761      <vcenter/>
 762      <string>Ending Reconciled Balance:</string>
 763     </label>
 764     <field>
 765      <rect>
 766       <x>642</x>
 767       <y>25.4985</y>
 768       <width>100</width>
 769       <height>15</height>
 770      </rect>
 771      <font>
 772       <face>Arial</face>
 773       <size>8</size>
 774       <weight>bold</weight>
 775      </font>
 776      <right/>
 777      <vcenter/>
 778      <data>
 779       <query>head</query>
 780       <column>f_endbal</column>
 781      </data>
 782     </field>
 783     <field>
 784      <rect>
 785       <x>642</x>
 786       <y>41.5</y>
 787       <width>100</width>
 788       <height>15</height>
 789      </rect>
 790      <font>
 791       <face>Arial</face>
 792       <size>8</size>
 793       <weight>bold</weight>
 794      </font>
 795      <right/>
 796      <vcenter/>
 797      <data>
 798       <query>unreconciled</query>
 799       <column>rtcheck</column>
 800      </data>
 801      <format builtin="true">money</format>
 802      <tracktotal/>
 803     </field>
 804     <label>
 805      <rect>
 806       <x>559</x>
 807       <y>57.4985</y>
 808       <width>56</width>
 809       <height>15</height>
 810      </rect>
 811      <font>
 812       <face>Arial</face>
 813       <size>8</size>
 814       <weight>normal</weight>
 815      </font>
 816      <right/>
 817      <vcenter/>
 818      <string>Subtotal:</string>
 819     </label>
 820     <field>
 821      <rect>
 822       <x>641</x>
 823       <y>57.5</y>
 824       <width>100</width>
 825       <height>15</height>
 826      </rect>
 827      <font>
 828       <face>Arial</face>
 829       <size>8</size>
 830       <weight>bold</weight>
 831      </font>
 832      <right/>
 833      <vcenter/>
 834      <data>
 835       <query>Subtotal</query>
 836       <column>amount</column>
 837      </data>
 838     </field>
 839     <field>
 840      <rect>
 841       <x>642</x>
 842       <y>73.5</y>
 843       <width>100</width>
 844       <height>15</height>
 845      </rect>
 846      <font>
 847       <face>Arial</face>
 848       <size>8</size>
 849       <weight>bold</weight>
 850      </font>
 851      <right/>
 852      <vcenter/>
 853      <data>
 854       <query>unreconciled</query>
 855       <column>rtdep</column>
 856      </data>
 857      <format builtin="true">money</format>
 858      <tracktotal/>
 859     </field>
 860     <field>
 861      <rect>
 862       <x>641</x>
 863       <y>89.5</y>
 864       <width>100</width>
 865       <height>15</height>
 866      </rect>
 867      <font>
 868       <face>Arial</face>
 869       <size>8</size>
 870       <weight>bold</weight>
 871      </font>
 872      <right/>
 873      <vcenter/>
 874      <data>
 875       <query>unreconciled</query>
 876       <column>rtadj</column>
 877      </data>
 878      <format builtin="true">money</format>
 879      <tracktotal/>
 880     </field>
 881     <field>
 882      <rect>
 883       <x>641</x>
 884       <y>105</y>
 885       <width>100</width>
 886       <height>15</height>
 887      </rect>
 888      <font>
 889       <face>Arial</face>
 890       <size>8</size>
 891       <weight>bold</weight>
 892      </font>
 893      <right/>
 894      <vcenter/>
 895      <data>
 896       <query>ActualAmount</query>
 897       <column>amount</column>
 898      </data>
 899     </field>
 900     <label>
 901      <rect>
 902       <x>439</x>
 903       <y>89.499</y>
 904       <width>177</width>
 905       <height>15</height>
 906      </rect>
 907      <font>
 908       <face>Arial</face>
 909       <size>8</size>
 910       <weight>normal</weight>
 911      </font>
 912      <right/>
 913      <vcenter/>
 914      <string>Add: Adjustments in Circulation:</string>
 915     </label>
 916    </foot>
 917   </group>
 918   <group>
 919    <name>unreconciled-type</name>
 920    <column>type</column>
 921    <head>
 922     <height>26.0233</height>
 923     <field>
 924      <rect>
 925       <x>10</x>
 926       <y>4.9</y>
 927       <width>94</width>
 928       <height>15</height>
 929      </rect>
 930      <font>
 931       <face>Arial</face>
 932       <size>8</size>
 933       <weight>bold</weight>
 934      </font>
 935      <left/>
 936      <vcenter/>
 937      <data>
 938       <query>unreconciled</query>
 939       <column>type</column>
 940      </data>
 941     </field>
 942    </head>
 943   </group>
 944   <detail>
 945    <key>
 946     <query>unreconciled</query>
 947    </key>
 948    <height>21.9767</height>
 949    <field>
 950     <rect>
 951      <x>204</x>
 952      <y>0.687</y>
 953      <width>430</width>
 954      <height>15</height>
 955     </rect>
 956     <font>
 957      <face>Arial</face>
 958      <size>8</size>
 959      <weight>bold</weight>
 960     </font>
 961     <left/>
 962     <vcenter/>
 963     <data>
 964      <query>unreconciled</query>
 965      <column>notes</column>
 966     </data>
 967    </field>
 968    <field>
 969     <rect>
 970      <x>10</x>
 971      <y>0.687</y>
 972      <width>80</width>
 973      <height>15</height>
 974     </rect>
 975     <font>
 976      <face>Arial</face>
 977      <size>8</size>
 978      <weight>bold</weight>
 979     </font>
 980     <hcenter/>
 981     <vcenter/>
 982     <data>
 983      <query>unreconciled</query>
 984      <column>f_date</column>
 985     </data>
 986    </field>
 987    <field>
 988     <rect>
 989      <x>98.5</x>
 990      <y>0.687</y>
 991      <width>94</width>
 992      <height>15</height>
 993     </rect>
 994     <font>
 995      <face>Arial</face>
 996      <size>8</size>
 997      <weight>bold</weight>
 998     </font>
 999     <left/>
1000     <vcenter/>
1001     <data>
1002      <query>unreconciled</query>
1003      <column>gltrans_docnumber</column>
1004     </data>
1005    </field>
1006    <field>
1007     <rect>
1008      <x>643</x>
1009      <y>0.687</y>
1010      <width>100</width>
1011      <height>15</height>
1012     </rect>
1013     <font>
1014      <face>Arial</face>
1015      <size>8</size>
1016      <weight>bold</weight>
1017     </font>
1018     <right/>
1019     <vcenter/>
1020     <data>
1021      <query>unreconciled</query>
1022      <column>f_amount</column>
1023     </data>
1024    </field>
1025   </detail>
1026  </section>
1027  <pgfoot>
1028   <height>15</height>
1029   <field>
1030    <rect>
1031     <x>705</x>
1032     <y>0</y>
1033     <width>40</width>
1034     <height>15</height>
1035    </rect>
1036    <font>
1037     <face>Arial</face>
1038     <size>8</size>
1039     <weight>bold</weight>
1040    </font>
1041    <left/>
1042    <vcenter/>
1043    <data>
1044     <query>Context Query</query>
1045     <column>page_number</column>
1046    </data>
1047   </field>
1048   <label>
1049    <rect>
1050     <x>0</x>
1051     <y>0</y>
1052     <width>75</width>
1053     <height>15</height>
1054    </rect>
1055    <font>
1056     <face>Arial</face>
1057     <size>8</size>
1058     <weight>normal</weight>
1059    </font>
1060    <right/>
1061    <vcenter/>
1062    <string>Report Date:</string>
1063   </label>
1064   <label>
1065    <rect>
1066     <x>615</x>
1067     <y>0</y>
1068     <width>85</width>
1069     <height>15</height>
1070    </rect>
1071    <font>
1072     <face>Arial</face>
1073     <size>8</size>
1074     <weight>normal</weight>
1075    </font>
1076    <right/>
1077    <vcenter/>
1078    <string>Page:</string>
1079   </label>
1080   <field>
1081    <rect>
1082     <x>80</x>
1083     <y>0</y>
1084     <width>100</width>
1085     <height>15</height>
1086    </rect>
1087    <font>
1088     <face>Arial</face>
1089     <size>8</size>
1090     <weight>bold</weight>
1091    </font>
1092    <left/>
1093    <vcenter/>
1094    <data>
1095     <query>Context Query</query>
1096     <column>report_date</column>
1097    </data>
1098   </field>
1099  </pgfoot>
1100  <rptfoot>
1101   <height>143</height>
1102  </rptfoot>
1103 </report>