RE: Report Writer Report - Journals File
Lemkemann, Jennifer
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