Skip to Main Content

Generating output text file from Planning

728483Jul 12 2010 — edited Jul 13 2010
How hard would it be to write a report script such that I could get the output to be a text file (that is either fixed width or comma-delimited--no preference--though the example below is fixed width) whereby the unit name is repeated on each and every line, followed by a member data value, followed by a hard-coded string, followed by another data value, followed by a period name? Where might I turn to get started writing such a report script? The end result is that I want to send this file to Oracle Financials to do a GL import. An example sample output follows:

AIKEN SVC. LEARNING-407005094285USD 0.00 JUL-11
AIKEN SVC. LEARNING-407005094285USD 0.00 AUG-11
AIKEN SVC. LEARNING-407005094285USD 152474.83 SEP-11
AIKEN SVC. LEARNING-407005094285USD 243959.72 OCT-11
AIKEN SVC. LEARNING-407005094285USD 152474.83 NOV-11
AIKEN SVC. LEARNING-407005094285USD 152474.83 DEC-11
AIKEN SVC. LEARNING-407005094285USD 106732.38 JAN-11
AIKEN SVC. LEARNING-407005094285USD 152474.83 FEB-11
AIKEN SVC. LEARNING-407005094285USD 182969.76 MAR-11
AIKEN SVC. LEARNING-407005094285USD 198217.27 APR-11
AIKEN SVC. LEARNING-407005094285USD 152474.83 MAY-11
AIKEN SVC. LEARNING-407005094285USD 30494.97 JUN-11

Thanks.
Comments