ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
ACCOUNTS RECEIVABLES

Chargeback does not get updated on Receipt reversal

From: Dan Depies [SMTP:Tpsd032@shopko.com]
Sent: Tuesday, April 27, 1999 2:59 AM
Subject: AR: Receipt Reversal Error

When attempting to reverse a receipt that has been applied to a group, we are receiving an errror "APP-11084. Cannot update charge back associated with this receipt".

We received two patches from Oracle (patches 700204, 721896), neither of which fixed our problem.

Has anyone experienced this problem? Any suggestions would be greatly appreciated.... We are on Oracle 10.7 SC.

Thanks! Dan Depies (414)641-3777 TPSD032@shopko.com

Date: Thu, 29 Apr 1999 22:53:50 +0700
From: Srivastava S K sksrivastava@irs.co.id
Subject: RE: Receipt Reversal Error

Hi,
Error message shows that receipt was applied to Charge back item , this receipt can not be reversed directly. In order to reverse it you need to select Debit Memo Reversal route ,which is second method of reversal.

Regards, SKS

x-------------x

Date: Tue, 13 Jul 1999 09:39:47 -0400
From: ddicondina@SUNGARDRS.COM
Subject: Re: AR:Receipts problem urgent??/?

We are 10.7 character and applied patch 450435 to correct this problem. We are running Sun Solaris 2.6. There is a bug which does not allow you to reverse receipts if a credit memo was charged to the receipt.

Dominic DiCondina

Receipt reversal not getting posted

Date: Wed, 21 Jul 1999 07:49:48 +0800
From: Stephen.Solomon@rac.com.au
Subject: AR: Receipt Reversal

Hi all,

I was wondering whether anybody could tell me what journals entries are suppose to happen when you reverse a receipt in AR. We had a situation where a payment was receipted twice hence our bank account is double, but when we reversed one of the receipts there was no journal entry created to take in out of the bank account in AR.

The status of the receipt is REVERSED but in the AR_CASH_RECEIPTS_ALL and the REVERSAL_CATEGORY is equal to NSF (not sure what this means). We are on 10.7 SC 16.1

Thanks
Stephen
Stephen Solomon
Systems Accountant
RAC Group
Phone: +61 8 9421 4394
Fax: +61 8 9421 4545
Email: Stephen.Solomon@rac.com.au

Date: Wed, 21 Jul 1999 10:33:43 +0200
From: Mike Bennet MikeB@langeberg.co.za
Subject: RE: Receipt Reversal

When a receipt is entered in AR (and the interface to GL is done)the debit entry goes to Remittance account. When the receipt is reconciled in Cash Management (and the interface to GL is done)the following entry occurs:

DR Bank
CR Remittance account

This clears the receipt into the bank account. In your case, therefore, you should have one (reconciled) receipt in the GL bank account and one sitting in the Remittance account (unless someone inadvertently reconciled both receipts). When you reverse the receipt, the credit goes to the Remittance account.

Regards Mike Bennet

Date: Wed, 21 Jul 1999 13:44:13 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: RE: Receipt Reversal

Hi,
NSF stands for NON SUFFICIENT FUNDS
Sunil Wahi

Date: Thu, 22 Jul 1999 14:28:45 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: RE: Receipt Reversal

We had a seemingly random problem in which AR Cash Receipt Reversals would not post properly. You might want to check the posting_control_id in the AR_CASH_RECEIPT_HISTORY table. If it is -3 (negative 3), chances are the transaction didn't post and became broken and will not post without interceding.

Receiving Transaction Mgr. - APP-14531 &File...error

From: Andre Kuerten [SMTP:akuerten@imation.com]
Sent: Wednesday, May 05, 1999 1:19 PM
Subject: APP-14531 &File...

Hello,
in my org we have pending receipt transactions with following error message: APP-14531 &FILE-&ERR_NUMBER: Subroutine &SUBROUTINE returned error

Is there someone out that knows that message and know a way to solve it? Oracle was not helpful again...

Thanks in advance Andree

Date: Wed, 5 May 1999 15:39:11 +0700
From: "Nagamohan U." umohan@irs.co.id
Subject: RE: APP-14531 &File...

Hi Andree
This error comes when the receiving transaction manager fails. You might have performed a transaction, say receipt. As soon you perform this transaction a record will be inserted into the RCV_TRANSACTIONS_INTERFACE table. These records will be picked up by the Receiving Transaction Manager. When this manager fails the record stays back in the table and this error appears.

Please run the following scripts.

1.Select rt.interface_transaction_id From rcv_transactions rt, rcv_transactions_interface rti where rti.interface_transaction_id = rt.interface_transaction_id;

2.Update rcv_transactions_interface Set transaction_status_code='ERROR' where transaction_status_code='PENDING'

3. Once the new receipts have been entered and have been processed successfully the transactions that have been errored via script 3 can then be deleted. The script will delete the "Error" transactions. Delete rcv_transaction_interface where transaction_status_code=error;

Actually the first script is of no use because all the transactions have to be flushed out of the table. After updating the table, perform the transactions again. After successful completion delete the lines (third Script) from the table.

We have faced this problem in our initial stages of going live and this worked fine. You can check for one transaction and if it is successful you may go ahead.

Regards/Nagamohan

Credit Balance Refunds

cfrank2@ix.netcom.com wrote:

How do you submit document to remove Credit Balances from A/R Customer Account and be able to get a check cut in Accounts Payable? A/R and A/P currently do not talk to each other in Oracle.

From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: Re: Credit Balance Refunds
Date: Sat, 8 May 1999 15:51:00 -0400 (EDT)

It's a manual process. You have to enter a debit memo that credits an AR /AP clearing account in AR. Then you match the credit to the debit, again in AR.

In AP you enter an invoice that debits the same clearing account, and pay it.

Of course, if the customer is not already a supplier, you have to set the m up in AP before entering the invoice.

I think this may be automated in 12. Hopefully, someone else can comment on that.

Hope this isn't too painful for your users. Craig Craig Yedinak Independent Consultant

Date: Sat, 08 May 1999 19:23:15 PDT
From: "tayi sanjit" sandytayi@hotmail.com
Subject: Re: Credit Balance Refunds

Frank,
The other alternative is to define the Customer as a Supplier in AP. then pay off the amount as required. Oracle provides a standard report called the Customer-Supplier Netting report which shows the updated balance.

Hope this helps! SANDY

Receipt Classes and Payment Methods

Date: Sat, 26 Jun 1999 02:27:52 NZST
From: Martin Bryant marty_bryant@hotmail.com
Subject: AR: Receipt Classes and Payment Methods

Can anyone assist on the optimal approach for setting up receipt classes and payment methods in an AR multi-org environment.

It would appear that receipt classes and payment methods are available in all operating units when you set them up. Remittance banks seem to be operating unit specific.

What structure have others used for their receipt classes and payment methods, especially if multiple operating units are using the one bank account and they require different GL account coding? You cannot repeat payment method names, so a naming convention is required.

Also, what should you set the clearance method to if you are intending on using cash management in the future? (not using it immediately).

Date: Mon, 28 Jun 1999 14:46:17 -0400
From: Teresa Reynolds teresa.reynolds@ey.com
Subject: Re: AR: Receipt Classes and Payment Methods

If you are going to use Cash Management, your clearance method has to be "By Matching". This is not an updateable field, so you can't change it later when you start using cash management. What this does is it creates a status of "Remitted" when the receipt is entered. Once it is reconciled in cash management, it changes the status to "Cleared". Also, if you are going to use a clearing account. When it is reconciled it will create an accounting entry to move it from the clearing account to the cash account.

We prefixed the payment methods with the operating unit identifier. We also had a receipt class for each operating unit.

Consolidated View of all Transactions for a Receipt

From: vv vv venvivek@usa.net
Subject: Urgent : AR : To get Consolidated view for all tran related to a receipt
Date: 28 Jun 99 10:24:03 MDT

Hi.

If any one can help me in finding this i appriciate it.
The requirement is to get a consolidated view for all related transactions to a given receipt. Is there any view by which we can find the respective transaction or is there anyother way to find it out.

Please help me in this. Its very urgent.

Thanx.
VV.
My email id is dear_breeze@yahoo.com

From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
Subject: RE: Urgent : AR : To get Consolidated view for all tran related t
Date: Mon, 28 Jun 1999 12:37:48 -0400

The only thing I know which would come close is the AR_RECEIVABLE_APPLICATIONS table. This table will also hold other applications though, such as when on-account cash is applied to an invoice .

From: vv vv venvivek@usa.net
Subject: Re: [RE: Urgent : AR : To get Consolidated view for all tran related t]
Date: 28 Jun 99 12:05:24 MDT

Hi

Thanx Kelly for U concern on this query. I agree with Ur suggestion.

In AR_RECEIVABLE_APPLICATIONS we can get the cash_receipt_id, do U know how u link between transaction number for the respective AR_RECEIVABLE_APPLICATIONS for the respective cash_receipt_id.

Thanx.
VV.
My email id is dear_breeze@yahoo.com

From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
Subject: RE:Urgent : AR : To get Consolidated view for all tran related to
Date: Mon, 28 Jun 1999 13:41:13 -0500

We are using 10.7 character. The path is Navigate/View/Receipt/History. Peform a query on the receipt number and you will see all transactions the receipt was applied to.

HTH, Stan

Notes Receivable - not working

Date: Sun, 04 Jul 1999 06:51:07 GMT
From: Sunny Sunny sunn999@hotmail.com
Subject: Notes Receivable

Hi,
HELP:
The Notes Receivables feature of AR is not working. Even if the check box 'Notes Receivable' in the receipt class definition form is checked the status of the receipt is not changing to the Notes Receivables status’s like “open” “matured”, “repurchased”, “delinquent”, etc. when a receipt is made. The receipt is behaving in a similar manner as a standard receipt even if the check box “Note Receivable” is enabled. This feature is used to support Post Dated Checks or Promissory Notes.

Date: Sun, 4 Jul 1999 21:50:40 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: Re: Reply:SunnyNotes Receivable

hi,

hope you had done all necessary setup steps regarding receipt class/receipt sources etc and also defined the receipt class with bank, necessary GL accounts . please check the Profile: AR: create Bank Charges = yes. you had to define the payment method for notes receivable and the purpose of notes receivable is to track post dated checks to a major extent(still i feel notes receivable is not a total solution for Post dated checks). just for information only: can you tell me the place of implementation? this is just to know what are the countries that use PDC. Hope this helps. else pl.get back to me

nkrishnakumar
Krishnakumar
Gokulam
35/12 East Park Road
Shenoy Nagar, Chennai 600 030
INDIA
Ph: (91)(44)6446131
http://members.tripod.com/~sramji/kk

Receipt for an invoice with multiple lines with tax

Date: Thu, 8 Jul 1999 20:30:27 +0200
From: Manny Albalancy MannyA@Amdocs.com
Subject: Receipt for an invoice with multiple lines with tax

Hi,

I am trying to record a receipt for an invoice that has multiple lines, each having it's own tax code attached to it. When choosing the line number in the "Applications" screen, the line is presented as base amount without tax, and can not apply a payment to close the charged tax. Where did I go wrong??

Manny Albalancy Mail: MannyA@Amdocs.com

Date: Thu, 8 Jul 1999 11:45:00 -0700
From: Tina.Thousand@weac.com
Subject: Re:Receipt for an invoice with multiple lines with tax

Manny - I have not used the functionality to apply receipts to specific transaction lines, however, I understand the functionality to be used for lines only. In other words, if you have an invoice with 2 product lines (1 - 300 widget A's for $300 and 2 - 500 widget B's for $250) + tax for $8 + freight for $10 then you can choose to apply a receipt to line 1 vs. line 2 or you can apply to the invoice as a whole - so the application of receipts would be $300 for line 1, $250 for line 2 and $18 for the entire invoice in order to clear the total invoice balance due.

You did not do anything wrong in creating the invoice, it's just that the sales tax for each line is not part of the line balance due - it's a separate component of the invoice.

Hope that helps some.
Tina Thousand
Ernst & Young, LLP
christina.thousand@ey.com

Overpayments from customers

Date: Mon, 9 Aug 1999 17:06:54 +0200
From: Mark Veitch mark@epol.co.za
Subject: Overpayments from Customers

Hi there, all

Instead of paying the exact amount of the invoice, some customers pay a few cents too much, eg. if the invoice is for $99.95 the customer may pay $100.00. I would like to apply $99.95 against the invoice and offset the balance (i.e. $0.05) against settlement discount. Is this possible, and if so, how do I go about setting this up?

Best Regards Mark

Date: Mon, 9 Aug 1999 11:53:45 -0400
From: Martha Blumberg mblumberg@goaa.org
Subject: RE: Overpayments from Customers

We do it in Misc receipts. Set up a Receipts Activity for settlement discount. Misc receipts will also allow you to post a negative if the customer underpays.

Date: Tue, 10 Aug 1999 13:42:32 +0700
From: Argon Usman argon@newmail.net
Subject: Re: Overpayments from Customers

During the Application of receipts to invoice, adjust the invoice value using invoice adjustments, to match the receipts amount. assign the correct account to the adjustment.

Good luck,
Argon I. Usman
Consultant
PT Jati Piranti Solusindo
Menara Rajawali 12th Fl.
Kawasan Mega Kuningan Lot 5.1
Jakarta
12950
Indonesia
Phone:(6221)5761850
Fax:(6221)5761848

Date: Tue, 10 Aug 1999 10:20:40 EDT
From: "Debashish Bhattacharjee" dkbhatta@hotmail.com
Subject: Re: Overpayments from Customers

Hi,
As you suggest to adjust the invoice amount at the tiem of adjustment and had already been saved. Unfortunately we are at a state where we did not adjust the invoices and now the reciepts are open with as less as a penny is there a way out to close these receipts

regds Debashish

Date: Tue, 10 Aug 1999 14:05:03 -0400
From: "Marzieh Hariri" mhariri@russelmetals.com
Subject: Re: Overpayments from Customers

I believe for small amounts you should be able to use autoadjustments to close the receipts.

Thanx. Debashish Bhattacharjee wrote:

Date: 12 Aug 99 11:29:58 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: RE: Overpayments from Customers

Hi Debashish,

A Clarification. AutoAdjustments and Adjustments will only work for Invoices, Credit and Debit Memos, not for receipts. At the present time you can only put the amount On-Account or create a debit memo and apply the pennies to it.

Neither is much of a solution. There is an enhancement scheduled for 11i or 12 which is supposed to give the users the ability to write off small receipt amounts.

Best of Luck, Craig
Craig Yedinak
Independent Consultant

Unable to do Chargeback from Receipt Application Form

From: Shanthi
To: 'oraapps-ar-l@elm.attaininc.com'
Sent: 8/9/99 2:11 PM
Subject: 11.02 - UNABLE TO DO CHARGEBACK FROM RECEIPT APPLICATION FORM

Hi,

I am trying to do a chargeback from the receipt application form. When I go to the 'Type' field in the chargeback form the list of values does not give any values to select. I have already defined the transaction type 'Chargeback' in the transaction type form. Anybody with the same problem before?

Shanthi

From: Deborah Bryda [mailto:DBryda@specgrp.com]
Sent: Tuesday, August 10, 1999 7:50 AM
To: 'Shanthi '; ''oraapps-ar-l@elm.attaininc.com' '
Subject: RE: 11.02 - UNABLE TO DO CHARGEBACK FROM RECEIPT APPLICATION FORM

Hi,

Do you have a Receivables Activity of type "Adjustment" set up?

Also, you need to have the Profile Option "AR: Cash - Allow Actions" set to yes to use Chargebacks from the Receipt application window.

Hope this helps!
Deb

Date: Wed, 11 Aug 1999 15:24:21 -0700
From: Shanthi Shanthi@SignatureEyewear.com
Subject: 11.02 A/R- UNABLE TO DO CHARGEBACK FROM RECEIPT APPLICATION FORM

Hi AR people,

I am putting below the error I am getting in 11.02 when i try to do a charge back on the receipt application form. The error is "APP-11086 Transaction type has an invalid creation sign" The transaction type chargeback has been defined with natural application to yes and any sign. I am also unable to choose the transaction type on the chargeback form 'List of values contains no entries'. Any body with this error and any solutions? Please let me know. Oracle support is as puzzled as we are. In fact they are getting the same error with a different APP-11088!!! Please help!!!

Thanks.
Shanthi
---------------
History
---------------------------

I have done both. I have an Adjustment activity set up and the adjustment form works fine. But chargeback gives the problem I mentioned. I have also set the Profile Allow actions to yes. Any further ideas?

Thanks, Shanthi

Date: Thu, 12 Aug 1999 09:31:07 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: 11.02 A/R- UNABLE TO DO CHARGEBACK FROM RECEIPT APPLICATION FORM

Hi Shanti,
Check out the Effective dates of the Charge back Transaction type.Probably there's an end date to it.Set the Transaction Type Creation Sign to "Positive".This might not matter as such but u can give it a try.

Regards, Sunil Wahi