RE: Report Writer Report - Journals File

0 views
Skip to first unread message

Lemkemann, Jennifer

unread,
Nov 4, 2010, 2:30:47 PM11/4/10
to pt_u...@googlegroups.com

I am trying to write a custom report writer report using the journals files and trying to output data from specific GL’s in separate columns.  However I can’t get the amounts to output at all.  Below is my report layout, current output and sample of what I would the report results to look like.  If you have done a report similar to this, can you send me your report layout.

 

Thanks in advance for your help.

 

 

REPORT LAYOUT

 

DATA_DEFINE:    /*  ------------------------------------------------------------

  File= JOURNALS _ Key 04 Collect Yes                                          

     TRANSACTION_CODE; SOURCE_JOURNAL; JOURNAL_MEMO; BATCH; $AMOUNT;         ~ 

     CREDIT_LEDGER_ACCOUNT; PRIMARY_KEY_FIELDS; DATE_EFFECTIVE; ACTIVITY;    ~ 

     PHASE; JOB; CHECK#/DEPOSIT#; COMMITMENT_ID; COMPANY_ID;                 ~ 

     CREDIT_JOB_ACCOUNT; DATE_INVOICE; DEBIT_JOB_ACCOUNT;                    ~ 

     DEBIT_LEDGER_ACCOUNT; HOURS; INVOICE_COMPONENT; INVOICE#; LFD_NAME;     ~ 

     REFERENCE; V/C_NUMBER                                                     

  File= LEDGER$ACCOUNT _ Key 0                                                 

     ACCOUNT; ACCOUNT_NAME                                                     

LEVEL:          /*  ------------------------------------------------------------

  BATCH                                                                         

   JOURNAL_MEMO                                                                

    ACCOUNT                                                                    

     SOURCE_JOURNAL          Blank                                             

      TRANSACTION_CODE       Blank                                             

COLUMN:         /*  ------------------------------------------------------------

  Level:JOURNAL_MEMO Row:  1                                                    

     BATCH             1    8                                                  

     JOURNAL_MEMO      10   16                                                 

     FICA_EE           30   B'---,---,--#.##'                                   

     FICA-ER           45   B'---,---,--#.##'                                  

     DIFF              60   B'---,---,--#.##'                                  

CALCULATION:    /*  ------------------------------------------------------------

  DIFF    = FICA-EE - FICA-ER                                                  

CONDITION:      /*  ------------------------------------------------------------

 FICA-EE         is $AMOUNT              when                        ~ 

                  ACCOUNT from 233.10     thru 233.10    

  FICA-ER         is $AMOUNT              when                        ~ 

                  ACCOUNT from 233.67     thru 233.67 

 

 

CURRENT REPORT OUTPUT

 

                              233.10         233.67      (UNDER) /

                              FICA-EE        FICA-ER       OVER

 BATCH    JOURNAL MEMO        AMOUNT         AMOUNT       ACCRUED

--------------------------------------------------------------------------------

P#000014 Ck Date 11/01/10      0.00           0.00           0.00

P#000080 Ck Date 11/01/10      0.00           0.00           0.00

P#000775 Ck Date 11/01/10      0.00           0.00           0.00

P#000776 Ck Date 11/01/10      0.00           0.00           0.00

P#000777 Ck Date 11/01/10      0.00           0.00           0.00

P#000779 Ck Date 11/01/10      0.00           0.00           0.00

P#000780 Ck Date 11/02/10      0.00           0.00           0.00

P#000781 Ck Date 11/02/10      0.00           0.00           0.00

P#000782 Ck Date 11/02/10      0.00           0.00           0.00

 

GRAND TOTAL                    0.00           0.00           0.00

 

 

SAMPLE OF REPORT OUTPUT NEEDED

 

                              233.10         233.67      (UNDER) /

                              FICA-EE        FICA-ER       OVER

 BATCH    JOURNAL MEMO        AMOUNT         AMOUNT       ACCRUED

--------------------------------------------------------------------------------

P#000014 Ck Date 11/01/10    -13.20           -13.20        0.00

P#000080 Ck Date 11/01/10 -1,876.20        -1,876.20        0.00

P#000675 Ck Date 11/02/10    -69.43           -69.43        0.00

P#000775 Ck Date 11/02/10    -89.90           -89.90        0.00

P#000776 Ck Date 11/01/10    -71.92           -71.92        0.00

P#000777 Ck Date 11/01/10   -199.68          -199.68        0.00

P#000779 Ck Date 11/01/10   -171.48          -171.30       -0.18

P#000780 Ck Date 11/02/10    -17.98           -17.96       -0.02

P#000781 Ck Date 11/02/10   -117.82          -117.82        0.00

P#000782 Ck Date 11/02/10    -71.92           -71.92        0.00

 

GRAND TOTAL               -2,699.53        -2,699.33       -0.20

 

 

Thanks, Jenny

_____________________________

Jenny Lemkemann

E-Mail: jennifer....@bisfrucon.com

Voice: 636-391-4605

Cell: 314-413-1827

Fax: 636-391-4594

 

 

 

Reply all
Reply to author
Forward
0 new messages