Setup of Item Flexfield and Organization in AR
Date: Fri, 13 Aug 1999 15:06:37 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
Subject: Item Flexfield and Organization in AR setup
Hello Group,
We are implementing Release 11.0.2 with Oracle 8.0.5 as Database.We are also
installing Gl in this 1st phase.We just have 1 SOB and only 1 entity.
As we do not have Order entry/Inventory installed,How do we activate Default
system Item flexfield as this is one of the required step.Also how shd we
define Organization? We just have 2 produsts as our items and flexfield shd
have only 1 seg.
Any help will be appreciated.
Bimal Patel
Consultant-Oracle Financials
Date: Mon, 16 Aug 1999 10:59:35 -0500
From: "Gail Perfetti" gail_p@email.msn.com
Subject: Re: Item Flexfield and Organization in AR setup
You need to setup the inventory flexfields in order to setup items in AR.
Autoinvoice taking 2 hours to complete
Date: Mon, 16 Aug 1999 20:05:18 +0300
From: ahmed ragab a_ragab@tccbce.com
Subject: auto_invoice_problems??????????????????????
Hi all
Please help
The autoinvoice take 2 hours to compleate .....
any one help
best regards / ahmed ragab
Autoinvoice rejecting records with APP-43448 error after applying Megapatch K
Date: Mon, 16 Aug 1999 16:54:00 -0400
From: "Middleton, Linda" LMiddleton@tensarcorp.com
Subject: AR: Sales Tax Error with GEMMS 4.10.06 and Oracle AR patchset K
On Thursday, I applied AR megapatch K (693796) to my test system.
AutoInvoice
is rejecting records with the message "APP-43448 Unable to locate a valid
Sales Tax Rate for transaction".
1. This patch required that the Sales Tax Location Flexfield be recreated.
(\ Navigate Setup System Options , page down to tax options, quickpick
location flexfield and save.)
This process submits five concurrent requests and all five completed
successfully.
2. We are not running a third party tax package.
3. I have verified that the ship-to customer records being processed have
valid tax codes in Oracle AR and that the tax codes are not disabled.
Has anyone else encountered this problem?
Any help would be appreciated.
TIA,
Linda Middleton
lmiddleton@tensarcorp.com
770 - 968 - 3255 ext. 285
Date: Mon, 16 Aug 1999 14:18:08 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Sales Tax Error with GEMMS 4.10.06 and Oracle AR patchset K
Are you using VAT tax? Are you supplying a VAT tax code?
Web Customers
Date: Tue, 17 Aug 1999 08:25:20 -0700
From: Todd Manley tmanley@zilog.com
To: "Oracle Applications Forum (E-mail)" oraapps-l@cpa.qc.ca
Subject: Web Customers
Hello-
Has anybody implemented Web Customers within the past few months? I'm in
the process of evaluating the product and I'd like to hear any feedback.
-Thanks, Todd
Todd Manley
ZiLOG
408.558.8962
tmanley@zilog.com
Assigning Customer Bank Accounts to each Customer
Date: Tue, 17 Aug 1999 15:21:43 -0600
From: Alex Waddell alex.waddell@shaw.ca
To: "Oracle List (E-mail)" OraApps-L@cpa.qc.ca
Subject: AR: Assigning Accounts to Customer Banks
Is there an AR set-up expert that could assist me in explaining why Oracle
would set up their customer banking the way it seems to be? We are
attempting to set up AutoReceipt for pre-auth withdrawals on customer
accounts. (10.7 NCA)
If I am understanding this right, I need to first create the bank, the
branch and the specific account numbers within the Setup - Banks Forms
(apparently populating AP_BANK_BRANCHES, _ACCOUNTS). I will need to do this
for every single customer and then go into each customer setup and select
the account I just set up from a quick list and 'assign' it to that
customer.
Am I understanding this right? And if so, why would it be set up that way?
Would not every account be unique to a customer? This seems to be a lot of
duplication of data and extra maintenance effort - unless I'm missing
something obvious.
Alex Waddell
Financial System Administrator
Shaw Communications Inc.
Phone: (403) 750-4709
Fax: (403) 750-4505
Credit Transaction against Invoice with Accounting Rule
Date: Wed, 18 Aug 1999 07:35:20 GMT
From: "Sumit Sen" sens_sumit@hotmail.com
Subject: AR:Credit Trx against Invoice with Rules : URGENT
Dear All
We have a situation wherein an Invoice has been raised for us$1200 in June
99 with the Accounting rule of 12 months i.e. from June 99 to May99.
The periods open are :
March99 (first period)
April to June 99
On running the Revenue recognition the Revenue is spread over the 12 months
period as seen from the Accounting window of the Trx.
Then a Credit trx is raised against this trx in the same month i.e. in
June99 (but the system date is August 99) for the full amount of the Invoice
.The allocation had been selected as LIFO.
But we find that the revenue reversal entries have been passed as follows:
Aug99 $100
July 99 $100
June99 $100
March 99 $100
Could anyone let me know as to why the credit trx generates the entries for
the above mentioned periods instead of from June99 to May 99.
Could anyone help urgently.
Thanks in advance.
Sumit
Date: Mon, 23 Aug 1999 10:04:30 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AR:Credit Trx against Invoice with Rules : TOP URGENT...PLS
HELP!!!!!!
Hi Sumit,
I think, I have a solution. What do you mean by allocation = LIFO?
In the Credit Transaction form there are two options
Rule Method = LIFO/Prorate/Unit
Split Term Method = LIFO/FIFO/Prorate
I am sure, you have given LIFO for Rule Method. In that case the system is
doing just fine. It will start reversing from the last GL period (here
August99) of the Credit Memo. If you want to reverse all installmets then
you should make
Split Term method = LIFO
Then only the system starts reversing the accounting entries from the last
"installment" first. Try this. I am hopeful that it will work. Just let me
know how it goes.
Thanks
Prasanna Jena
KAY Software Inc.
Silicon Valley
Date: Tue, 24 Aug 1999 02:51:39 GMT
From: "Sumit Sen" sens_sumit@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Re: AR:Credit Trx against Invoice with Rules : TOP URGENT...PLS
HELP!!!!!!
Hi Prasanna
Thanks for your reply.But we do not have instalment payments.What we have is
that Invoicing in Advance and revenue recognised over a period of 12 months.
But when I select the the Rule Method in the Credit Transactions window as
LIFO then it gives the result as stated earlier. Moreover the Split Terms
field is shaded and does not allow me to enter any data.
Could you please look into the matter and give me any other solution that
comes to your mind.
Thanks in advance
Sumit
ra_customer_trx_lines - Column ASK CM
Date: Wed, 18 Aug 1999 11:04:55 -0700
From: "Orth, Tom (torth)" torth@sequent.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: AR: Autoinvoice "line_type"
Hello,
Can anybody think of why the "line_type" column in the data table
"RA_CUSTOMER_TRX_LINES" in a rel. 10.7 instance would be,
say, "ASK CM" instead of one of the valid values for the line_type
in the RA_INTERFACE_LINES_ALL table? Namely: LINE, TAX,
FREIGHT, or CHARGES?
Thanks!
Tom-
Credit Memo - applying to Invoice
Date: Wed, 18 Aug 1999 14:34:12 -0700
From: "McCreary, Randy" mccrear@wdni.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Applying Credit Memos to Invoices...
If a user has an open invoice for X dollars and then creates a credit memo
for X dollars, is there a way to apply the credit memo directly to invoice
and have it clear the amount due on the invoice? I have found a "Cross
Reference To" field on the Enter Invoices form, is this the right location?
Once you have associated the credit memo to the invoice do you need to
perform another action to apply it?
Randy McCreary
PH: 253.924-3442
FAX: 253.924.2301
e-mail: randy.mccreary@weyerhaeuser.com
Date: Wed, 18 Aug 1999 16:55:02 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Applying Credit Memos to Invoices...
We're on version 10.7 SC and do this directly in the Credit Transactions
menu
Date: Wed, 18 Aug 1999 23:27:22 -0400
From: "Chadda, Alok" achadda@kpmg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Cc: "'randy.mccreary@weyerhaeuser.com'" randy.mccreary@weyerhaeuser.com
Subject: RE:Applying Credit Memos to Invoices...Message-ID
Randy -
Use Credit transaction screen to directly apply the credit to an invoice. If
the credit memo is already in the system, use trasaction summary screen to
apply credit memo to an invoice(Verify it with the AR manual). As far as I
remember the cross reference field is used in case an invoice is referencing
another invoice which is already in the system.
HTH
Alok
Lockbox install in Germany - Bank file format
Date: Thu, 19 Aug 1999 09:25:54 -0500
From: Darren_C_Bell@Dell.com
To: oraapps-l@cpa.qc.ca
Subject: Help - lockbox advice needed.
Hi,
We are looking into setting up lockbox for our German office - this in
itself seems straight-forward enough. Our main head-scratches involve the
basics - how to get a decent file from our bank. When our customer pays his
invoice, he goes to his local bank and pays it. We don't deal directily
with this bank - this information is forwarded on to our bank in a German
format called DTAUS. Our bank then converts this into MT940 (Swift), which
we download via a German-specific application called Multicash. The problem
is, our bank does no data entry at all, they merrily pass on what they
receive from other banks. This means that we have no control over how the
receipt data is entered. It seems that the only mandatory fields are
currency, amount, date, and a couple other irrelevant (to us) ones. Things
like invoice number, customer no, (the things we would use for customer
recognition) are not mandatory, and appear (if at all) in any one of a
number of free-text fields, in any position, with other text etc. around it.
It is never consistently in the same position or field.
This is rather perplexing. I can't believe that these problems have never
occured and been overcome before. Short of writing our own pattern-matching
code and loading directly into the interface tables I don't really know the
answer. If we take this path, it raises the question of what to do with the
Transmission Formats and validation routines. ????????????
Question: Is there any organisation out there that is German based, (but
don't let that stop any others!) using the lockbox facility within Oracle
Financials? If so, can I contact you, and discuss?
Any points to ponder, different ideas etc. would be greatly appreciated. I
need a fresh viewpoint badly.
Regards,
Darren Bell
Omega Project, European IT
Phone: +44 (0)1344 748021
Email: darren_c_bell@dell.com
UNAPPL & ACCT type receipts not coming from legacy on the Customer Statements
Date: Thu, 19 Aug 1999 12:06:52 PDT
From: "prasad surisetty" surisettyp@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Missing Receipts of type UNAPPL & ACCT type on Customers Statement.
Hi Gurus,
I am not getting the Unapplied & Onacct receipts on statements report
which are from Legacy system.
But when I tried with the receipts created in APPS itself, they are coming
on report.
Can anybody help me in this what is the fix required../
Cheers
Prasad.