2 Replies Latest reply: May 15, 2014 9:51 AM by Fred _ RSS

    Detail

    Fred _

      I have a report that is generated daily  that shows out of balances.  These out of balances are marked by an asterix.   For my detail I was able to output the out of balance using the asc(Field)=42 filter.  The only problem is that on the second line, it is captured as an append and thus can't seem to be able to use the same filter.  Should I trap two lines as my detail then go ahead and run the model again?

        • Detail
          Grant Perkins

          Fred,

           

          Are your detail sections always 2 lines long? If so making your detail template 2 lines would seem to be a possibility. However if sometimes there is only one line or sometimes more than two or if the format of both lines is the same (so that any trap would in fact trap both lines) then things may get a little complex.

           

          It sounds like your current solution can end up giving the asterisk in one (or both) of two fields. In which case my first reaction is to suggest combining the two fields and treating both lines as a single record OR developing a filter that works with the asterisk in either field.

           

          However my mental image of the report may be different from the reality. Any chance of posting a sample or simplified replica of your report's layout?

           

          Grant

           

          Originally posted by Fred:

          I have a report that is generated daily  that shows out of balances.  These out of balances are marked by an asterix.   For my detail I was able to output the out of balance using the asc(Field)=42 filter.  The only problem is that on the second line, it is captured as an append and thus can't seem to be able to use the same filter.  Should I trap two lines as my detail then go ahead and run the model again? /b[/quote]

          • Detail
            Fred _

            Right now I am trapping all the fields and using the following filter.

            [font="courier"]asc(Doc_error)=42 .Or. asc()=42  .Or. asc(ER_Error)=42 .Or. Asc(Sub_error)=42[/font][/quote]My table looks like this with the filter on.  It's not show here, but I am not getting all the asterixes which means that there are still out of balances that I am not filtering out. [font="courier"]FUND G/L  DESCPT                         G/L_AMT     TRANSACTION      DOCUMENT    SUBSIDIARY       ALLOTMENT SUB_ERRO            APPR CASH_CTRL      TSY_FUND         OPER_ER DOC_E ALLO ER_ERROR

            PR   4110 PRE-OBLIGATIONS              81,897.66       81,897.66     81,897.66          0.00       -22304.84               -22,304.84      0.00          0.00        81897.66       *     **    

            XK   4120 OBLIGATIONS                  51,686.05       51,686.05     56,686.05          0.00        51686.05                51,686.05      0.00          0.00        51686.05 *           **     /font[/quote][quote][font="courier"]************************************************************************************************************************************

            REPORT1860                                     FUNKY CHICKEN CORP               RUN DATE: 09/03/2004

                                                            PROCESS CONTROL REPORT BY FUND                                  RUN TIME: 10:54 PM

            FAMIS UPDATE NO :      5460                         FISCAL PERIOD: 03 2004                                    PAGE NUM:         16

            ************************************************************************************************************************************

            PA    BLA BLABLABL BLALAB LABLABLABLAB

            PQ    BLABLABL BLABLAB BL ABLABLABLABL

            G/L ACCT  DESCRIPTION                  GENERAL LEDGER           DOCUMENT          ALLOTMENT       CASH CONTROL          OPERATING ER

                                                      TRANSACTION         SUBSIDIARY      APPROPRIATION      TREASURY FUND

             

            1100      CASH AND CASH EQUIVALENT     13,726,548.31-               .00                .00                .00                .00

                                                   13,726,548.31-               .00                .00      13,726,548.31-

            1310      ACCOUNTS RECEIVABLE WITH         89,372.70-         89,372.70-               .00                .00                .00

                                                       89,372.70-         89,372.70-               .00                .00

            1315      ACCOUNTS RECEIVABLE-CONTR        89,372.70                .00                .00                .00                .00

                                                       89,372.70                .00                .00                .00

            2100      ADVANCES FROM MEMBER GOVT   185,320,063.92-               .00                .00                .00                .00  **

                                                  185,320,063.92-        731,378.29 *              .00                .00

            2130      PAYMENTS PENDING CLEARANC     2,399,861.61       2,399,861.61                .00                .00                .00

                                                    2,399,861.61                .00                .00                .00

            3120      FUND BALANCE                186,051,442.21                .00                .00                .00                .00

                                                  186,051,442.21                .00                .00                .00

            4100      ALLOTMENTS                   62,715,058.78-               .00      62,715,058.78-               .00      62,715,058.78-

                                                   62,715,058.78-               .00      62,715,058.78-               .00

            4105      RESERVE FOR ALLOTMENTS       62,715,058.78                .00                .00                .00                .00

                                                   62,715,058.78                .00                .00                .00

            4110      PRE-OBLIGATIONS               4,912,282.08       4,912,282.08       4,912,282.08                .00       4,912,282.08

                                                    4,912,282.08                .00       4,912,282.08                .00

            4115      RESERVE FOR PRE-OBLIGATIO     4,912,282.08-               .00                .00                .00                .00

                                                    4,912,282.08-               .00                .00                .00

            4120      OBLIGATIONS                  26,906,837.68      26,906,837.68      26,906,837.68                .00      26,906,837.68

                                                   26,906,837.68                .00      26,906,837.68                .00

            4125      RESERVE FOR OBLIGATIONS      26,906,837.68-               .00                .00                .00                .00

                                                   26,906,837.68-               .00                .00                .00

            4200      REVENUE                         504,369.15-               .00                .00                .00         504,369.15-

                                                      504,369.15-               .00                .00                .00

            4300      DISBURSEMENTS                11,088,302.56                .00      11,088,302.56                .00      11,088,302.56

                                                   11,088,302.56                .00      11,088,302.56                .00

            5300      VARIANCE ACCOUNTS-EPI            11,375.00                .00                .00                .00                .00

                                                       11,375.00          11,375.00                .00                .00

            ************************************************************************************************************************************

            REPORT                                     FUNKY CHICKENS                        RUN DATE: 09/03/2004

                                                            PROCESS CONTROL REPORT BY FUND                                  RUN TIME: 10:54 PM

            FAMIS UPDATE NO :      5460                         FISCAL PERIOD: 03 2004                                    PAGE NUM:         17

            ************************************************************************************************************************************

            PA    BLABLABL BLABLAB BL ABLABLABLABL

            PR    FUNDS REGULAR

            G/L ACCT  DESCRIPTION                  GENERAL LEDGER           DOCUMENT          ALLOTMENT       CASH CONTROL          OPERATING ER

                                                      TRANSACTION         SUBSIDIARY      APPROPRIATION      TREASURY FUND

             

            1100      CASH AND CASH EQUIVALENT      6,227,842.85                .00                .00                .00                .00  **

                                                    6,227,842.85                .00                .00       6,217,246.85 *

            1200      QUOTA ASSESSMENT RECEIVAB    84,394,228.00      84,394,228.00                .00                .00                .00

                                                   84,394,228.00                .00                .00                .00

            1205      RESERVE FOR QUOTA ASSESSM    84,394,228.00-               .00                .00                .00                .00

                                                   84,394,228.00-               .00                .00                .00

            1300      ACCOUNTS RECEIVABLE             218,069.04-        218,069.04-               .00                .00                .00

                                                      218,069.04-        218,069.04-               .00                .00

            1310      ACCOUNTS RECEIVABLE WITH         11,045.00-         11,045.00-               .00                .00                .00

                                                       11,045.00-         11,045.00-               .00                .00

            1315      ACCOUNTS RECEIVABLE-CONTR        11,045.00                .00                .00                .00                .00

                                                       11,045.00                .00                .00                .00

            1400      PREPAID EXPENSES                278,960.53         278,960.53                .00                .00                .00

                                                      278,960.53         278,960.53                .00                .00

            2100      ADVANCES FROM MEMBER GOVT       149,104.00                .00                .00                .00                .00

                                                      149,104.00         149,104.00                .00                .00

            2110      ACCOUNTS PAYABLE                452,484.48-        452,484.48-               .00                .00                .00

                                                      452,484.48-        452,484.48-               .00                .00

            2120      FIELD PAYMENTS PENDING CL         1,940.21-          1,940.21-               .00                .00                .00

                                                        1,940.21-               .00                .00                .00

            2121      MANUAL FLD PMT PENDING CL           375.99             375.99                .00                .00                .00

                                                          375.99                .00                .00                .00

            2130      PAYMENTS PENDING CLEARANC       236,782.80         236,782.80                .00                .00                .00

                                                      236,782.80                .00                .00                .00

            2200      PRIOR YEAR RESERVES PAYAB     2,338,577.52       2,338,577.52                .00                .00                .00

                                                    2,338,577.52                .00                .00                .00

            4100      ALLOTMENTS                  155,966,769.00-               .00     155,966,769.00-               .00     155,966,769.00-

                                                  155,966,769.00-               .00     155,966,769.00-               .00

            4105      RESERVE FOR ALLOTMENTS      155,966,769.00                .00                .00                .00                .00

                                                  155,966,769.00                .00                .00                .00

            4110      PRE-OBLIGATIONS               1,409,518.40       1,409,518.40       1,409,518.40                .00       1,409,518.40

                                                    1,409,518.40                .00       1,409,518.40                .00

            ************************************************************************************************************************************

            REPORT                                      FUNKY CHICKEN FREEDOM                         RUN DATE: 09/03/2004

                                                            PROCESS CONTROL REPORT BY FUND                                  RUN TIME: 10:54 PM

            FAMIS UPDATE NO :      5460                         FISCAL PERIOD: 03 2004                                    PAGE NUM:         18

            ************************************************************************************************************************************

            PA    BLABLABL BLABLAB BL ABLABLABLABL

            PR    SOMETHING REGULAR

            G/L ACCT  DESCRIPTION                  GENERAL LEDGER           DOCUMENT          ALLOTMENT       CASH CONTROL          OPERATING ER

                                                      TRANSACTION         SUBSIDIARY      APPROPRIATION      TREASURY FUND

             

            4115      RESERVE FOR PRE-OBLIGATIO     1,409,518.40-               .00                .00                .00                .00

                                                    1,409,518.40-               .00                .00                .00

            4120      OBLIGATIONS                  10,028,366.91      10,028,366.91      10,028,366.91                .00      10,028,366.91

                                                   10,028,366.91                .00      10,028,366.91                .00

            4125      RESERVE FOR OBLIGATIONS      10,028,366.91-               .00                .00                .00                .00

                                                   10,028,366.91-               .00                .00                .00

            4200      REVENUE                       7,946,241.15-               .00                .00                .00       7,946,241.15-

                                                    7,946,241.15-               .00                .00                .00

            4300      DISBURSEMENTS                 9,916,653.18                .00       9,916,653.18                .00       9,916,653.18

                                                    9,916,653.18                .00       9,916,653.18                .00

            5000      CLEARING ACCOUNTS             9,536,878.05-      9,546,878.05-*              .00                .00                .00  **

                                                    9,536,878.05-      9,536,878.05-               .00                .00

            5100      PAYROLL CLEARING ACCOUNT      1,041,224.60                .00                .00                .00                .00

                                                    1,041,224.60                .00                .00                .00

            5200      IOT ACCOUNTS                  2,066,215.70-               .00                .00                .00                .00

                                                    2,066,215.70-      2,066,215.70-               .00                .00

            5600      VALUATION GAIN/LOSS              32,307.16                .00                .00                .00          32,307.16

                                                       32,307.16                .00                .00                .00

            9000      ADPICS DOC W/GENERAL LEDG        55,962.99-         55,962.99-               .00                .00                .00

                                                       55,962.99-               .00                .00                .00

            9005      ADPICS DOC W/GENERAL LEDG        55,962.99                .00                .00                .00                .00

                                                       55,962.99                .00                .00                .00  /font[/quote]Thanks

             

            Fred