Override
De: Duvall, Duane [mailto:dduvall@ENERGY.TWC.com]
Date: mardi 30 novembre 1999 17:12
=C0: OAUGnet
Objet: Overrides.
HELP HELP HELP.
We have 10.7 character right now and we have a problem.
We have end users typing over the receivable account when they are
entering
invoices etc. and during the interface process that override goes to a
"mystery table" that we have not been able to find as of yet and we
have
been unable to get the name of the table. Do you have any ideas? If
anyone
can reply I have a bmp file that shows the screen I am talking about.
This is making the reconciliation process much more difficult because
we
have an A/R Sub ledger total of say 100,000 and a G/L Total of 90,000
(less
the 10,000 override).
Thank you.
Duane Duvall
EM& T Accounting Systems
A/R Reporting, A/R Postings, Finapps
BOk Tower, Tulsa MD19-4
Phone: 918-573-0468
Fax: 918-573-6987
Subject: RE: Overrides.
From: Darrieus Bertrand DarrieusB@mail.europcar.com
Date: Tue, 30 Nov 1999 17:44:19 +0100
Duane,
Receivable Account override after GL Posting:
This is a recorded bug since v10.5 and there is a patch for it (was =
405752
or so).
Subject: Overrides....the real problem
From: "Duvall, Duane" dduvall@ENERGY.TWC.com
Date: Tue, 30 Nov 1999 10:58:48 -0600
Darrieus and Corrado (and others) I'll pass on the patch info...
The end user will pick the transaction type then go to the next screen where
the receivable account is located then type over that account (in effect,
overriding the acct). Then when during the posting process when we run the
Journal Entries Report and then the GLTProgram and then have someone on the
G/L Side pull in the batch. The override flows thru and the A/R Sub Ledger
and the G/L both have the same info.
The problems arise when we use our Infomaker queries to try and pick up any
of the overrides. Our queries pull from the Transaction type on the first
input screen were you input the customer number etc. We can't figure out
what TABLE to look into to pull the DEFAULT Receivable account info from
(that's the next screen after the one were you input salesperson/ customer
number etc.)
That's the problem!! Does this help?
Any ideas?
Duane Duvall
EM& T Accounting Systems
A/R Reporting, A/R Postings, Finapps
BOk Tower, Tulsa MD19-4
Phone: 918-573-0468
Fax: 918-573-6987
Subject: RE: Overrides....the real problem
From: "Corrado Barbero" corrado.barbero@oraplus.com
Date: Tue, 30 Nov 1999 19:27:40 +0100
Sorry but my poor english doesn't help me: are you saying that the
account that the users write on the 'second screen' doesn't go to
RA_CUSTOMER_TRX_ALL?
If you're saying that, that's true, it goes to RA_CUST_TRX_LINE_GL_DIST,
the record with the same CUSTOMER_TRX_ID and with ACCOUNT_CLASS = 'REC'.
HTH
Corrado
Subject: RE: Overrides....the real problem
From: "Alicia" ahoekstr@csac.csac.com
Date: Tue, 30 Nov 1999 16:50:23 -0600
Although the table appears to be associated with the transaction
lines, the receivable account for each transaction is stored in
the gl distributions table.
RA_CUST_TRX_LINE_GL_DIST_ALL where the column ACCOUNT_CLASS = 'REC'.
CUSTOMER_TRX_ID is also a column in this table.
The revenue and other accounts associated with the transaction are
in the same table with ACCOUNT_CLASS = 'REV' or 'CHARGES' or 'FREIGHT'
or 'TAX' (and so on) and are associated (using CUSTOMER_TRX_LINE_ID)
with the specific lines for the transaction.
This is documented in the Technical Reference Manual. If you don't
have one, get one. :-) There is also information in the Interfaces
manuals since the AutoInvoice interface tables can be used to populate
the transaction tables as well as the forms.
Alicia
Computer Systems Authority
Subject: RE: Overrides....the real problem
From: Darrieus Bertrand DarrieusB@mail.europcar.com
Date: Wed, 1 Dec 1999 11:47:40 +0100
Right!
Using ACCOUNT_CLASS = 'REC' and CUSTOMER_TRX_ID you will retrieve
CODE_COMBINATION_ID for the actual Receivable Account
from RA_CUST_TRX_LINE_GL_DIST_ALL
The actual Transaction Type is in column CUST_TRX_TYPE_ID
from RA_CUSTOMER_TRX_ALL
The default Receivable Account code combination id (when available)
for a Transaction Type is in column GL_ID_REC from
RA_CUST_TRX_TYPES_ALL
So, for any transaction type you should be able to cross check
the actual versus the default Receivable code combination id.
Hope this will help!
Subject: RE: Overrides....the real problem
From: "Alicia" ahoekstr@csac.csac.com
Date: Wed, 1 Dec 1999 06:26:15 -0600
Don't assume that the default combination is the one that
is assigned in the transaction type setup.
The default receivable code combination (as well as the
ones for revenue, freight, tax, etc.) depends on how the
AutoAccounting is defined. The code combination for the
receivable account on a transaction is built from the
default segment values in the Transaction Type setup,
the Salesrep setup, OR using a constant value. It may
be a bit more complex than looking at the default based
on CUST_TRX_TYPE_ID unless AutoAccounting is defined for
every one of the receivable account segments to be
derived from the Transaction Types.
Alicia
Computer Systems Authority (CSA)