GL Posting Interim tables
From: server@ibm6000.cpa.qc.ca [mailto:server@ibm6000.cpa.qc.ca]On
Behalf Of Mandadi, Harish
Sent: Wednesday, June 09, 1999 8:36 AM
Subject: GL Posting Interim tables
GL Guru's
I have a problem with GL_POSTING_INTERIM table. This table is being used by
several programs in GL application to post balances to GL_BALANCES table.
But, some how this table is not getting cleaned up and it is holding lot of
records and also I have 11 tables like GL_POSTING_INTERIM_1385..... I do not
know how these are getting created. Did any body see this problem before.
Any ideas....
TIA
-Harish
Date: Wed, 9 Jun 1999 09:40:08 -0600
From: David Moore dmoore@UATC.com
Subject: RE: GL Posting Interim tables
I have seen this, but only when the job "breaks" because the table's storage
clause is insufficient. In this case, there is a table, GL_POSTING_INTERIM,
that I understand is used as a template for the table that gets generated
with the job - i.e. GL_POSTING_INTERIM_1385. The numbers increment
everytime the table is used. When the job breaks, nothing cleans up the
tables. You can alter the storage clause from the GL SUPERUSER
responsibility - path = setup, system, storage. Even though you have 11 or
so tables lingering, this has worked 1370+ times. The same thing happened
to us when we first implemented Financials, until we got the storage clause
right. It is okay to drop the "numbered" tables, as a new one is generated
every time a relevant job is run.
David Moore
DBA, United Artists Theatre Circuit, Inc.
Date: Wed, 9 Jun 1999 11:06:23 -0500
From: "Mandadi, Harish" HMandadi@obiwan.intecom.com
Subject: RE: GL Posting Interim tables
Hi David,
My storage clause is as following
Initial Kbytes: 2000, Next Kbytes: 2000, Max: 100, Increase: 0
Do I need to change any of these values, If, what values I need to change
and how much. Even after altering the above values still I need to drop the
_1385... tables? what about GL_POSTING_INTERIM table this one has 55213 rows
in it. Please advise...
Thanks again for your time and help.....
-Harish
Date: Wed, 9 Jun 1999 11:13:39 -0600
From: David Moore dmoore@UATC.com
Subject: RE: GL Posting Interim tables
My values (which work for me, I don't know about you) are Initial: 500,
Next: 250, Max: 500, and Pct: 50.
The _1385... tables are more than likely left over from jobs that crashed
(this was always the case with me - and they had all crashed due to
insufficient storage clause parameters). When the job completes normally,
they are cleaned up, otherwise, not. When you run another job, another
table is created. That old table is never used again. They (the _number
tables) are okay to drop (once again, in my experience).
My GL_POSTING_INTERIM table has 250K+ rows - I don't think you need to worry
about it.
Date: Wed, 9 Jun 1999 14:36:01 -0500
From: "Michael S Barone" Michael_S_Barone@notes.cummins.com
Subject: RE: GL Posting Interim tables
Mandadi:
Please note that the Default GL Tablespace is GLD or GL_Data.
We have experienced extreme fragmentation in the GLD or GL_Data
tablespace at the hands of the Oracle Applications Interim GL
Processes.
Our experience suggests creating a separate GL_Interim Tablespace
and altering your GL Interim Tablespace processes to use this new
dedicated GL_Interim Tablespace:
Example:
---------------------------------------------------------------------------
Oracle Server GL Interim Tablespace and GL Interim Objects
From the oracle userid: (Create GL Interim Tablespaces)
oracle sqlplus system/PASSWD
sqlplus CREATE TABLESPACE GL_INTERIM_DATA
DATAFILE
=91/u05/oradata/SID/ora_gl_interim_data_01.dbf=92
SIZE 50M REUSE
DEFAULT STORAGE (INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 0)
ONLINE;
sqlplus CREATE TABLESPACE GL_INTERIM_INDX
DATAFILE
=91/u05/oradata/SID/ora_gl_interim_indx_01.dbf=92
SIZE 50M REUSE
DEFAULT STORAGE (INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 0)
ONLINE;
sqlplus alter user APPS quota unlimited on
GL_INTERIM_DATA;
sqlplus alter user APPS quota unlimited on
GL_INTERIM_INDX;
sqlplus alter user GL quota unlimited on
GL_INTERIM_DATA;
sqlplus alter user GL quota unlimited on
GL_INTERIM_INDX;
sqlplus exit
From the GL Super User Account: (Setup GL Interim
Tablespace Use)
General Ledger Super User Responsibility
Navigate - Setup - System - Storage
Note: Interim database objects will fragment the
GLD or GL_DATA and GLI or GL_INDEX (default) Tablespaces every time
the GL Interim processes are executed. These GL Setup Instructions will
help isolate and sequester the GL Interim Objects into their own INTERIM Tablespaces.
Drill down from GL to Inv. Tx
Date: Thu, 08 Jul 1999 10:26:21 CDT
From: Suneel Kalavala sk_kalavala@hotmail.com
Subject: INV:Drill down from GL
How do we drill down from the JE lines in GL to the corresponding
Inventory Transactions ?
thanks
KSK
Date: Thu, 8 Jul 1999 08:31:59 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: INV:Drill down from GL
You must take the GL Batch number, switch to an INV
repsonsility and query the tranfers to the GL. There
is no direct way to drill down that I know of, in
release 10 anyway.
Date: Thu, 8 Jul 1999 12:01:23 -0400
From: Zoe Reyes zreyes@goaa.org
Subject: RE: INV:Drill down from GL
You can drill down from GL only to AP and/or AR. Disappointed? So are
we!!!
P.S. Don't forget to use your copy and paste features.
Posting Batch with errors
Date: Fri, 9 Jul 1999 10:19:34 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: GL: Posting Batch with error
Hi all:
10.7 SC, here is the situation, we have a batch in gl that didn't post
correctly and ended up with error. We have corrected the error (account was
desactivated) and would like to post the same batch again. In character
10.5 the same batch was able to be posted again. In GUI 10.7 this
functionality do no exist. I opened a TAR in Oracle Support and the
solution was to update the status code of the batch form Z to U this is done
by special, tools, examine which I consider is not the best solution.
Have any of you faced this situation? how do you actually handle it?
Tia
Ynes Coiscou
Sub Gerente Sistemas Financieros
MIS, Tricom
Tel. (809) 476-4622
Mail:ycoiscou@tricom.com.do
Date: Fri, 9 Jul 1999 07:35:29 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: GL: Posting Batch with error
We often have journals that don't post due to error.
If you are unable to post them from the POST JOURNALS
screen, query the entry up from ENTER JOURNALS and
post it via MORE ACTIONS. That always works for us
under 10.7SC
Date: Fri, 9 Jul 1999 09:32:25 -0500
From: "Krzes, Joe" JKrzes@smith.com
Subject: GL: RE Posting Batch with error
This may sound strange, but try changing the batch name slightly and save
it. I think it forces re-validation or resets the flags. This was in 10.7
character.
Joe
Date: Fri, 9 Jul 1999 10:50:12 -0400
From: "Ynes Coiscou, TRI" YCoiscou@tricom.com.do
Subject: RE: RE Posting Batch with error
I tryed this solution and only works fine when the status of the funds
reservation has not passed. If the batch has funds status passed you can
not change the name of the batch, or journal in other works the batch is not
updatable.
Ynes Coiscou
Sub Gerente Sistemas Financieros
MIS, Tricom
Tel. (809) 476-4622
Mail:ycoiscou@tricom.com.do
Date: Fri, 09 Jul 1999 08:04:18 +0100
From: jmcdonald@princesscruises.com (Jeanne R Mcdonald)
Subject: Re: GL: RE Posting Batch with error
Actually, you can change any field in the batch record. I usually use
description (and add a space somewhere between words). And if some journals in
the batch were OK and some weren't, you have to make the "change/correction" at
the journal level.
jeanne!
Merge GL accounts
Date: Tue, 13 Jul 1999 13:48:21 -0400
From: Linda_Ead@Millipore.com
Subject: GL question
Does anyone know of a way to merge GL balances from many accounts into one?
We're using 10.7 character and GUI.
Thank you.
Date: Tue, 13 Jul 1999 14:01:48 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: GL question
I am assuming you are NOT talking about doing this through a Consolidation
but in your production SOB where you want to eliminate CC's which are not
longer needed/used.
There is no standard functionality to do that in 10.7. It could be done
with a modification though. A good technical person could complete it
quickly.
Cheers,
Joe Maliszewski
Consultant
Date: Tue, 13 Jul 1999 11:06:43 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: Re: GL question
If it is in Applications, perhaps u can think of a rollup group and summary
template. Do u want to load balances from outside!!
dasari
Date: Tue, 13 Jul 1999 11:07:22 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
Subject: RE: GL question
Joe, could this be done with mass allocations?
Andy Schindler
Date: Tue, 13 Jul 1999 14:48:30 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: GL question
I suppose you could open all the periods where there is activity, then run a
MA to reverse any amounts that are there. Then I you can disable the old
CC's manually. Didn't really think about it that way. But you could do it.
Good thought.
Joe Maliszewski
Consultant
Date: Tue, 13 Jul 1999 15:20:13 -0400
From: "Donohue, Lynn " ldonohue@kpmg.com
Subject: RE: GL question
This can be done with a mass allocation formula.
In the A line, sum the total of the accounts to be consolidated.
In the B line, multiply by -1
In the C line, divide by 1
The Target will be used to clear the original balances
The Offset will have the new total in the one GL account.
Lynn Donohue
Editing fields after GL import from AP
Date: Wed, 14 Jul 1999 09:00:11 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: GL - Journal Import from AP
We have the defined the journal import source Payables and disabled the
Freeze Journal option. We want to edit few fields such as description,
journal category when transactions are imported from AP for some specific
transactions.
We ran the import in both Summary and detail level but note that none of the
fields can be updated.
Are we missing any other set up.
Regards,
Chetan
Date: Wed, 14 Jul 1999 09:12:36 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: GL - Journal Import from AP
Chetan,
Have you unreserved funds on the journal (more
actions button), then saved that record before attempting to edit any of the
fields?
Date: Wed, 14 Jul 1999 11:56:32 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: GL - Journal Import from AP
Craig,
I tried to unreserve the funds. But I observe the button is disabled. I also
checked the Batch status and observe that ' the transaction has passed funds
reservation'.
Thanks,
Chetan
Date: Wed, 14 Jul 1999 10:19:11 +0200
From: Craig Riffel CraigR@langeberg.co.za
Subject: RE: GL - Journal Import from AP
Chetan,
It could be that you were in the Inquiry screens?
This has worked for me on quite a few occasions,
using the following procedure:
Journals--Entry--Find (by batch since this batch
would be from payables)--Review Journal--More Actions--Unreserve
Funds--Save.
This now enables me to edit any record in that
particular journal and then to save it. Once saved, you would have to
Reserve Funds again and save.
Date: Wed, 14 Jul 1999 13:41:37 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: GL - Journal Import from AP
Craig,
I am querying the journal in the Enter Journals form using Find and More
Actions options.
Have you tried to unreserve a journal imported from AP. It is possible to
unreserve transactions created within GL, but not for JE coming from AP.
Thanks & regards,
Chetan
Date: Fri, 16 Jul 1999 10:22:00 -0400
From: "Brian S Kuzniar" bkuzniar@paychex.com
Subject: Re: GL - Journal Import from AP
If you have ADI, you could get the information through Discoverer or Access or
ftp the Journals - General report into an Excel spreadsheet and modify the
information any way you want to.
Brian Kuzniar
Paychex
716-383-3270
Setting Security at Posting Screen
Date: Wed, 21 Jul 1999 15:23:21 GMT
From: "Joe Lichtefeld" j_lichtefeld@hotmail.com
Cc: tstraub@rescare.com
Subject: GL:Posting screen security
We are on Oracle's version 10.7, character. We would like to limit the
batches that a particular user can see when they go to the posting screen.
Is there a way to enforce the Security rule on this form? Can batches be
limited by using the argument field on the menu set-up?
If anyone has any suggestion, we would appreciate it.
Date: Wed, 21 Jul 1999 12:45:31 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Posting screen security
Not as far as I know. But it has been a good 4 years since I have used a
Character based system.
You are asking for Record Based Security here. Typically Oracle does not
offer this type of security. And even if it did on this form what would be
the criteria for the security? A Segment Value in the JE? Some sort of
Hierarchy of Users? What would happen if the JE violated your Security
Rule?
In any case standard functionality does not provide for your requirement.
Regards,
Joe Maliszewski
Consultant
Date: Wed, 21 Jul 1999 13:09:57 -0400
From: "Kamdar, Rita R, CFCTR" rkamdar@att.com
Subject: RE: Posting screen security
Joe,
We had modified the posting screen in char and GUI to incorporate the
security by userid and this custom form was attached to Regional
responsibilities' menus.
GL Super User can view/post any of the batches.
This worked very well for the users.
Rita
Date: Wed, 21 Jul 1999 13:16:39 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Posting screen security
Yes, I concur. You can MODIFY the form to do this.
I believe the original question was regarding using the Argument field which
one would assume this was trying to be done without a modification.
I was just responding to the standard functionality of the Apps.
Joe Maliszewski
Consultant
How to post to Gl some accounts in Summary and others in Detail mode
Date: Wed, 21 Jul 1999 16:43:17 -0500
From: llesser@iquest.net
Subject: A/P Posting
We are experiencing a posting problem from Oracle Accounts Payable system
to Oracle General Ledger system in 10.7.
We need the liabilities to post in summary and the expenses to post in
detail for our daily activity. We have tried setting the parameters in
the Payables Transfer to General Ledger to Liability - No Audit, Expenses
- Audit, and the Summary Journal Entry - Yes without success. We either
get detail entries for everything or summary entries for everything. Our
GL for May and June is huge as you can imagine since we decided to go with
the detail instead of summary. If anyone has any suggestions or
solutions, please help.
Date: Wed, 21 Jul 1999 16:16:23 -0600
From: Alex Waddell alex.waddell@shaw.ca
Subject: RE: A/P Posting
Your problem is that you are setting "Summary Journal Entry to - YES". This
is overriding the audit/no audit options you have defined. Leave the
"Summary Journal Entry" field blank and your upload should work the way you
want.
Alex Waddell
Financial System Administrator
Shaw Communications Inc.
Phone: (403) 750-4709
Fax: (403) 750-4505
Journals not visible in GL posting module
Date: Mon, 02 Aug 1999 03:12:53 PDT
From: "moses rajasingh" mosesrajasingh@hotmail.com
Subject: Posting in GL module- Problem
Hi GL experts
I am facing a problem in GL posting, when I check the entries in GL_JE
HEADER AND DETAIL FILES, I have 20,000 records, which showing status = 'N'.
Both in the Header and Detail showing the same status, when I get through
the Posting Module in the GL, it is not appearing at all. Is any body faced
the same problem, can you please help to come out of the problem.
thanks in advance
moses
Date: Mon, 02 Aug 1999 16:27:02 +0530
From: "Bagavathi Rajan K" rajankb@wipsys.soft.net
Subject: Re: Posting in GL module- Problem
Hi,
I faced a similar situation some time back. Then I found that,
someone else was accessing the journal through the journal entry screen and
hence, the journal was locked.
Ask your DBA to check whether there is any lock on the particular row in
GL_JE_HEADERS table.
Regards,
K.Bagavathi Rajan.
Delete Journal Batch
At 01:46 AM 6/11/99 -0400, you wrote:
A user duplicated a journal entry from GLDI. He then attempted to delete
the journal in GL. When prompted to delete the journal he chose Yes. When
prompted to delete the batch he chose No by mistake. Now the batch is
available in the posting screen, with no values. When I have attempted to
query for the batch in the journal entry screen, the batch is not visible
(because the journal has been deleted).
Can anyone advise me how I can delete the batch?
Thanks,
Kalpana
Date: Sun, 08 Aug 1999 17:22:13 +0400
From: Srinivas Sreepada satncr@emirates.net.ae
Subject: Re: GL: Delete journal batch
Hi
I had come accross a similar situation where the user had created a batch
saved it and signed off. Thereafter when he signed on again he created a new
batch and continued with his entries. The batch with no Journal entries was
rejected by the posting program with the error message " No Journals Exist
for this Batch".
We then queried the batch entered one journal line with zero amounts and
posted it as the client did not want the Journal Number Lost.
Although the situation we saw was not due to Journal Deletions, you could
also try posting it once and then after the posting fails, delete after
entering one dummy line.
Try this
Good Luck
Srinivas
GL Date and Effective Date
Date: Wed, 11 Aug 1999 16:23:38 +0530
From: "Anoop Abrol" aabrol@mailcity.com
Subject: GL Date and Effective Date
Hi
We have Payables and GL (10.7 GUI). I have a few questions on GL Date and
Effective Date.
Q1. What is the concept of GL Date in the 'Enter Invoices' form ?
We entered Invoices and Payments on various dates for a month say April-99.
Next we did 'Payables transfer to GL' where we selected the 'Post Through
Date' as 30-APR-99.
We did Journal Import and the Journal that was created had an Effective Date
of 08-APR-99.
Moreover all my GL Reports - like Journal Entry and General Ledger for have
all transactions bearing the date 08-APR-99.
Q1 What, then is the relevance of GL Dates in the Invoice and Payment Forms
in AP ?
Q2 Any ideas, as to on what basis the effective date of 08-APR-99 has been
generated.? I tried the process for May-99 and this time the effective date
was 19-May-99 ?
Q3 In our live instance we want the GL Date in Payables to be the date that
appears in the desired GL Reports - mentioned above, do we have to run
'Payables Transfer to GL' everyday ?
TIA
Date: Wed, 11 Aug 1999 11:24:39 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: GL Date and Effective Date
Q1 - The GL Date is calculated based on the value set in the Payables
Options form, Invoice Alternative Region in the GL Date Basis Button. This
is also affected by what is the earliest open GL Period.
Q1 - The date as calculated in above will be defaulted to the Distribution
Line.
Q2 - If I had to guess I would say you are calculating the date based on
Invoice Date and the invoice you entered for May-99 had an Invoice Date of
19-MAY-1999.
Q3 - The GL Date is the GL Date. It should have nothing to do with when the
Payables Transfer to GL was run. Unless you have done some other things
which you did not say here, like run the sweep program.
Cheers,
Joe Maliszewski
Consultant
Date: Thu, 12 Aug 1999 13:24:53 +0530
From: "Anoop Abrol" aabrol@mailcity.com
Subject: RE: GL Date and Effective Date
Joe,
I cheked the Payable Options for GL Date, it is set to Invoice Date. What I
am trying to say is that I have entered every day of the month - Apr-99. The
GL Date is the Invoice Date and Invoices are dated 01-APR-99,02-APR-99 and
so on till 30-APR-99.
I want to transfer these invoices to GL in one go and choose the Post
Through Date as 30-APR-99.
On Journal Import, the Purchase Invoice Journal that is created has an
effective date of 08-APR-99.
I can understand the limitations of the system that since the Invoices bear
different dates, and effective date being one only it has to work like that.
But what I am puzzled about is how it has calculated the Effective Date of
08-APR-99.
Also you have not answered my Q3 - i.e. In our live instance we want the GL
Date in Payables to be the date that appears in the desired GL Reports -
mentioned above, do we have to
run 'Payables Transfer to GL' everyday ?
Thanks
Import of GL Balances - Conc Request error - EM01
Date: Wed, 11 Aug 1999 08:44:42 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: GL-IMPORT
Hi Gurus,
We have a problem with Gl- balances import.
1.The concurrent request report gives EM-01 as the error key and there
is no explaination of this error in the error listing below the report.
2.We are using 10.7NCA.
3.Asssociated with this I would like to know if this has anything to do
with the period statuses.
4.The period to import is the first period of a new Fiscal year(eg.FY99
and the period is the first in this fiscal)
5.Does the last period of the earlier Fiscal year needs to be closed
for this?
Any inputs....
thanks in advance,
Murthy.
Date: Wed, 11 Aug 1999 11:39:00 -0500
From: "Haseman, Neil" nhaseman@BCSINS.COM
To: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com,
Subject: RE: GL-IMPORT
EM01 = Invalid Journal Entry Category
The fact that the previous period is not closed has no bearing on the
situation
Neil Haseman
BCS Financial Corp
Date: Wed, 11 Aug 1999 11:38:56 -0500
From: Mike Dennis mdennis@mdp.com
Subject: Re: GL-IMPORT
EM01 on my report (107SC) is listed in the Miscellaneous Error Codes section
of the report. The error message states: "Invalid journal entry category".
Mike Dennis
Financial System Administrator
Meredith Corporation
mdennis@mdp.com
Date: Wed, 11 Aug 1999 09:57:00 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
Subject: Re: GL-IMPORT
Miscellaneous Error Codes
-------------------------
EM01 Invalid journal entry category.
EM02 There are no journal entry categories defined.
EM03 Invalid set of books id.
Please check your spelling for column
USER_JE_CATEGORY_NAME.
I haven't tested it in 10.7, but in 10.6 you could
only have two fiscal years open at one time. i.e. if
you had DEC-98 open and tried to open JAN-00, then
Oracle would close DEC-98 automatically and perform
it's year end routines. As far as periods go, they
must be either open or future-enterable for GL Import
to work.
Good luck.
Andy Schindler
NRC, Inc
Date: Wed, 11 Aug 1999 12:29:12 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
Subject: RE: GL-IMPORT
Kudos gurus,
Thanks for the immediate response to one and all.
The gl category has been created and the import runs fine.
Murthy.
Error on posting batches generated by Mass Allocation program
Date: Thu, 05 Aug 1999 12:19:00 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: GL:Problem in Posting
Hi,
I am getting the folowing message in the posting problem.
This is happening only for the batches generated by the Mass Alocation
program.
PPOS0225: glpubr(): Number of updated GL_BALANCES rows does not equal the
number or
rows in
GL_POSTING_INTERIM_785 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.
SHRD0042: Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
glpubr:updated balances rows != gl_interim_posting rows. Posting stops.
CALL YOUR CUSTOMER SUPPORT REPRESENTATIVE!
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
sqlerrp: sqlerrd: 0 0 20 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...
PPOS0064: Posting exited with error status
Thanks in advance for any help.
MOHAN
Date: Thu, 5 Aug 1999 11:19:53 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: GL:Problem in Posting
We had a similar message and it turned out the
database had invalid objects in it and needed to be
recomplied. (I think that was the term.) Check with
your DBA
Field in GL_JE_LINES containing Receipt No. coming from AR
Date: Mon, 16 Aug 1999 14:02:06 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
Subject: Receipt # in GL_JE_Lines
What attribute field in GL_JE_LINES stores the receipt number from trade
receipts coming from AR?
Date: Mon, 16 Aug 1999 15:34:43 -0400 (EDT)
From: Satyanarayana Venuganti CMCISMV@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca,
Subject: Re: Receipt # in GL_JE_Lines
Hi,
It's reference_4 or reference_5 column in GL_JE_LINES Table.If not look
around
other reference columns (REFERENCE_1 TO REFERENCE_10).
HTH,
Satya.
Date: Mon, 16 Aug 1999 15:45:37 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
To: oraapps-l@cpa.qc.ca, CMCISMV@NJTRANSIT.STATE.NJ.US
Subject: Resolution!!! Receipt # in GL_JE_Lines
The receipt number is held in Reference_4 of the gl_je_lines.
thanks for your replies
MRC Setup problem
Date: Mon, 4 Oct 1999 10:04:04 -0700
From: Larry Scheurich larrys@dpapplications.com
To: oraapps-l@cpa.qc.ca
Subject: MRC question
Folks,
I have been experimenting with MRC on the Vision demo database. I am using
the MRC Reporting set of books to view transactions. When I run inquiries,
I was expecting to see the amounts in the currency of the set of books
(reporting) that I'm in. However, they show up in the currency of the
primary set of books. I opened the currency folder to see the translated
amounts, but they are showing up blank (I was expecting to see translated
amounts). Can anyone point me in the right direction to see the translated
amounts? I know it's something I'm doing wrong.... :-)