ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings to Mailing Lists
ON
ACCOUNTS RECEIVABLES

Closing a period

Date: Wed, 28 Jul 1999 07:28:56 -0700 (PDT)
From: Prasanna Ramam sukkuv@yahoo.com
Subject: AR open/close period - APP-11171 Error

Please help !

When I am trying to close AR periods , Iam getting the following error and its still open !

APP - 11157 Please Wait ... checking for unposted items press any key to ack message &
APP- 11171 You must post all transactions in this period before you close it.

1. Why I am getting this error ?
2. We won't pass the AR info to GL
3. Do I need to run GL Interface for the transactions to be posted ( for those periods )
4. All the periods from '97 are still open , except May'97 was closed - I don'tknow why

Can anyone send me some solution to this ?
Rgds
Prasanna

Date: Wed, 28 Jul 1999 20:31:16 +0530
From: "Bagavathi Rajan K" rajankb@wipsys.soft.net
Subject: Re: AR open/close period - APP-11171 Error

Hi Prasanna,
You can't close a period if there are any unposted entries in that period. Run the Unposted Items report in AR for the period you are trying to close. It will return the list of unposted items under different categories. You have to post all the items identified by this report and only after that you can close the period.

However you can keep the period under the status "Closed Pending" with unposted entries. When a period is in this status, the users will not be able to enter a transaction in that period.

Regards,
K.Bagavathi Rajan.

Date: Wed, 28 Jul 1999 18:06:41 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
Subject: RE: AR open/close period - APP-11171 Error

If you are using MRC, you need to post the transactions in this book too.

-- Suzie Roth
MIS (Ext. 7151)

Date: Wed, 28 Jul 1999 10:49:32 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'sukkuv@yahoo.com'" sukkuv@yahoo.com
Subject: RE:AR open/close period - APP-11171 Error

Have you transfered all transaction entries to the GL? AR is a little scarry in that you can post transactions very easily to prior periods if they are still open. If you have transfered all transactions, I have run across this problem before. It usually is caused by a reversed receipt. Raise a TAR with Oracle. They have a SQL script that can be used to fix the receipt.

HTH, Stan Puchniak

Date: Wed, 28 Jul 1999 10:31:17 -0700 (PDT)
From: Prasanna Ramam sukkuv@yahoo.com
Subject: Re: AR open/close period - APP-11171 Error

Hi

Thanx very much ! Now I am able to close the periods after posting the transactions to GL ! and also used 'CLosed Pending' -

Rgds
Prasanna

Date: Mon, 02 Aug 1999 11:18:52 -0700
From: "sean smith" kiowasean@zdnetmail.com
Subject: Re: AR open/close period - APP-11171 Error

I would strongly suggest you set the period to close pending. This prevents any additional postings from happening while you investigate. We have found on 10.7 that you can have unposted transactions that sometimes won't appear on the unposted items report. If you run into this, look at the posting_control_id for transactions in cash receipts and interface lines and trx lines. Specifically look for posting_control_id's = negative 3. We've seen these have a posted flag of 'Y' but the system thinks they aren't posted because of the -3.

Oracle WWS can give you fix scripts for these.

How to setup Address Style

Date: Wed, 28 Jul 1999 15:38:12 +0530
From: Susan susan_jackson@mail.usa.com
Subject: countries and territories *

Hi ALL
Below 1,2,3 are extracts from help of AR, I had gone into Setup/Transactions/Territory but I can not see any address style kind of an option there, please advise::

1. You can view all countries and territories within your system in the Maintain Countries and Territories window.

2. Use the address style field to assign address styles to countries if you wish to use the Flexible Address Formats feature.

3. You can identify which countries are part of the European Union (EU) by entering a VAT Member State Code against these countries. The Receivables European Sales Listing report uses this information to produce a listing of all sales to customers in European Community member states other than your own.

Regds Susan

Date: Wed, 28 Jul 1999 17:24:51 +0530
From: "manoj_bhatnagar/Polaris"@polaris.co.in
Subject: Re: countries and territories *

Hi Susan

Your problem can be solved by doing the following :-

1. Check the Territory key flexfield of Oracle receivables. Is is defined properly.

2. Open the Standard Customer form and go to Addresses tab and try changing different countries to see different styles.

Hope this helps Manoj Bhatnagar

Date: Thu, 29 Jul 1999 12:39:36 +0530
From: Susan susan_jackson@mail.usa.com
Subject: Re: countries and territories *

Thankyou very much bhatnagar
It helped.
Regds Susan

Date: Sun, 01 Aug 1999 15:25:21 GMT
From: "Sunny Sunny" sunn999@hotmail.com
Subject: Re: countries and territories *

Hi,
U have the countries form in AR setups.Access that form , the last field will have the address sytle in a LOV.If i am not wrong there are 6 of them.U can quick pick from the list.U will not have address style's in the territories form.

Regards, Sunil Wahi

Journal Entries that the system passes in Cash Basis

Date: Wed, 28 Jul 1999 12:52:48 -0500
From: "Nguyen, Michael" MNguyen@co.scott.mn.us
Subject: AR Cash Basis

We are on SC v. 10.7 Oracle Govt Receivables. My apologies if this is the wrong forum for this question:

1. Can someone tell me where I can find detailed information on the cash basis journal entries that are being created when invoices are created (as oppose to the wealth of info that is available on accrual basis)?

More specifically, I want to find out what is happenning to the receivables and revenue account under cash basis when an invoice is created but not yet booked until cash is received.

THANK YOU!
Michael Nguyen
Scott County, MN

--- "Nguyen, Michael" MNguyen@co.scott.mn.us wrote:

I had posted this message earlier this week but did not get any responses so I apologize to all and will try once again.

We are a local govt organization implementing AR on a cash basis...Smartclient v.10.7 GUI.

My question is this:

1. When an invoice is created, in an accrual basis system, the receivable account is debited and the revenue account credited. Upon receipt of the money, you debit cash and credit the receivables account. What happens on a cash basis? What does the journal entry look like until the money is actually received?

Oracle does not provide any details regarding cash basis so any assistance from the folks on this Listserver would be appreciated.

Michael Nguyen
Scott County, MN

Date: Fri, 30 Jul 1999 14:29:43 -0700 (PDT)
From: Bob Uppaluri mastechbob@yahoo.com
Subject: Re: Cash Basis AR

In a normal Cash Basis system:-
When you make an invoice, you are not recognizing it as an Asset until it is received. You can maintain it in the Sub Ledger only. You can not transfer it to GL. So you will not make any journal entry to recognize it as Revenue.

Once the cash is received you can post it to GL. Then you can debit the Cash account and credit the Revenue account. You can nullify the balance in the sub ledger by posing a cash control entry.

Date: Fri, 30 Jul 1999 18:09:05 -0400
From: "Lau, Gabby" gLau@wssc.dst.md.us
Subject: RE: Cash Basis AR

This is actually an accounting question. The journal entry is actually the same whether you are using cash basis or accrual basis accounting if you do not receive money right way. AR cannot be cash basis unless you get cash right away. In that case, you debit cash and credit your revenue account and bypass the receivable accounts.

Gabby

AR on cash basis

From: Dina Rotem dinar@rafael.co.il
Subject: AR: Is there Cash Basis Accounting?
Date: Sun, 01 Aug 1999 17:55:27 +0300

I saw several posting dealing with cash accounting in AR. In AP you can define a book that will use the accrual accounting, and a secondary book based on cash accounting. Is there a similar functionality in AR?

Dina

Date: Mon, 2 Aug 1999 13:06:35 +0200
From: "=?ISO-8859-1?Q?Geir_B=E5rdstu?=" geir.baardstu@ac.no
Subject: RE: AR: Is there Cash Basis Accounting?

The AR does not support the same parallell accounting principles as AP. In order to do a full Cash Based accounting installation, you need to consider using the Oracle Public Sector Financials (OPFS). When implementing the OPFS, there will be two SOBs in the GL, one for Accrual based accounting and one for Cash Based Accounting. Postings are done as traditional to the Accrual based SOB, but OPFS makes sure that no transactions updates the Cash Based SOB before payment is done / received. When receiving a payment to the AR, two journals will be updated in the Cash Based SOB;
- Journal 1: Credit to the Revenue and Tax accounts, Debet Accounts Receivable account
- Journal 2: Credit Accounts Receivable account, Debet Bank account

Geir

Define Items in AR

Date: Thu, 05 Aug 1999 07:29:26 PDT
From: "Gail Perfetti" perfettig@hotmail.com
Subject: AR Define Items

Has anyone every implemented Accounts Receivable with only a shared Inventory install. I am interested in Defining Items in Accounts Receivable. I need to know if I have to setup the other required Flexfields that are in the Inventory setup. By this I mean, do I need to set up Account Aliases, Item Catalogs, Item Categories, Sales Orders and Stock Locators. I know I have to setup the System Item Flexfield.

Date: Fri, 06 Aug 1999 08:28:08 PDT
From: "tayi sanjit" sandytayi@hotmail.com
Subject: Re: AR Define Items

Gail,

When we did an AR Implementation on 11.0.2 recently, we had to compile the other Inventory key flexfields, to be able to Enter new items.

Also you may have to create a value set to enter all the items using the shared Inventory install.

Hope this helps,
Bye, SANDY

How to manipulate the dates of transactions involving - Invoice, Receipt, Application of Receipt to Invoice and then reversal of the application and then of the receipt itself.

Date: Thu, 12 Aug 1999 15:52:34 -0400
From: "Rusty Kimbrell" RKimbrel@pgahq.com
Subject: AR EXPERTS, Please confirm

Let me start by saying I know this has gone across the service a lot and Im sure it is in the archives. However, the explanation is general and I need specifics . Therefore if you were going to reply by telling me to look in the archives or RTFM. Just save me and all the others, who get tired of your nasty grams, the pleasure of deleting your response.

When a receipt comes in and it has a receipt date of Jan 30 and the gl date is Jan 30, then this occurs

Dr Cash
CR UNAPPLIED

then lets say we get around to appling the cash on Feb 5th, we get

DR UNAPPLIED
CR Receivable

BOth of these entries hit in Feb and therefore the 4 way transaction has occured in two different periods.

Now in June we relaize we applied it incorrectly

DR Receivable
CR UNAPPLIED

Then in June we realize the check is not for that customer at all so we revesre the payment(that is how the client insists on handling it since we dont put things on account.

DR Unapplied
CR cash.

All of this in June from an invoice orignianlly date Jan.

So if I run scripts to see account dr and accouted credits Im going to see entries in several periods and we would have a credit balance in our unapplied account in Jan and June (until the reversal).

Am I right, because our implementation team choosen to manually enter all historical invoices and receipts and they thought that they would put all of them in with dates prior to our live date and then never post those periods but it looks as if they put them in fro prior periods as orgianlly receiving the cash but then applied the receipt in an open period. OR sometimes they would do a reversal of the historical receipt and let it pick up the current system date and the gl date , thusly posting the Dr to unapplied and the credit to cash.

Does this make sense to anyone.

Support is trying to tell me the date of the receipt overrides all of the gl dates. And the apply date is the date that drives the transaction on the applications screen. So if we apply the invoice in a closed period but the date showing in the GL date field is valid , it will not effect my balances.

THis is WRONG isnt it.

Is there any one who know the nitty gritty of these eintries that I can dicuss this with.

let me know

Date: Fri, 13 Aug 1999 10:26:46 +0930
From: "Savory, Aaron" Aaron.Savory@boral.com.au
Subject: RE: AR EXPERTS, Please confirm

I agree it does not sound correct. The only way I could see this happenning is if the original receipt was entered using a set up which included a do not post statement. Then any further transaction using this would not create a journal in GL. If this is not the case then the gl will be effected in the relevant period (that is the current period).

Receipt not posted - what action required

From: Mohammed Alshaarawi[SMTP:m_sharawy@tccbce.com]
Sent: Wednesday, August 18, 1999 4:41 AM
To: Multiple recipients of list
Subject: reciept Problem Urgent!!!

If a reciept is not posted and appears in Unposted tems report what actions showld be taken?

thanx

Date: Wed, 18 Aug 1999 08:47:26 -0500
From: "Mancuso, Keeley" KMancuso@ENERGY.TWC.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: reciept Problem Urgent!!!

I query that receipt and look at it. The GL date could be a problem. We have also been having problems with reversed receipts and cash applications from different months getting hung up with fragmented entries. Still working with Oracle on this as we are unable to close the accounting month. Any suggestions on this one would be helpful.

Date: Wed, 18 Aug 1999 10:49:53 -0700
From: SCross@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AR reciept Problem Urgent!!!

Hi Mohammed,
I've had a similiar problem in the past where a receipt was applied but showed up on the unposted items report. This was a receipt where AR removed the tax and the tax was still showing up on the unposted items report along with the rest of the receipt. I deleted the tax from the ra_cust_trx_line_gl_dist_all table and the AR accountant was able to rerun the interface again successfully. We were then able to close the period. We also have had problems with reversals and receipts getting applied incorrectly. We're on 10.7 SC, RDBMS 7.3.4, 16.1 GUI.

Susan Cross
scross@littonapd.com
818 226-2637

Date: Thu, 19 Aug 1999 08:51:22 +0200
From: Suzie Roth suzie_roth@stcl.scitex.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: reciept Problem Urgent!!!

Hi,
Check the GL transfer logfile. You will see their what is the reason for the receipts not to be posted. We had the same problem and the cause of it was that the amounts in the functional currency were not balanced (we are using the Cash Management module and after we reconciled receipts we got this problem). We solved it by fixing the amounts in ar_cash_receipts_history_all and ar_distributions and by fixing gl_date for part of the receipts (when part of the journals were in different gl period then the others).

Hope it helped.
-- Suzie Roth
MIS (Ext. 7151)

Organization setup problem

Date: Thu, 19 Aug 1999 14:15:51 -0400
From: "Bimal Patel" bimal.patel@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: Problem with Organization setup-Urget

We are on release 11.0.2 and having problem in settting up Organization info in AR setup.(We have only core modules and installed through 1 hr install )
1)There is no LOV for org_type.(Even after defining new quickcode with this name;its value doesn't showup in LOV for the field Organization Type
2)After defining Org.classification on the same screen and saving the record-the same organization doesn't show up in LOV for attaching it to profile option
OE:Item Validation Organization.
As both these are required steps I am not able to proceed with AR set up. Has anyone encountered this problem earlier?
Any help will be greatly appreciated.

Thanks
Bimal Patel

Date: Thu, 19 Aug 1999 13:37:26 -0500
From: "Mancuso, Keeley" KMancuso@ENERGY.TWC.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem with Organization setup-Urget

We have the same problem in 10.7 character. Oracle has logged a bug, but so far, we've had no luck. I would appreciate help if anyone else figures this out.

Thanks.

Date: Fri, 20 Aug 1999 00:01:33 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: ReplyProblem with Organization setup-Urget

hi,

did you check the stock locator flexfield? in rel11.03 they had included 19,20 segement for Project task. you can try by disabling the segments. or alternately verify if you had applied patch 851461(recommended).

HTH,
nkrishnakumar

Inter Bank transfers

Date: Mon, 5 Jul 1999 17:15:24 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Cc: Senapathy sena@enoc.co.ae
Subject: Re- Inter Bank transfers

Hello AP/AR Experts,

We have a Head Office - Bank accounts and the Branch Office - Bank account in the same set of books. Also, separate bank accounts have been created in AP/AR. Note that Head Office and Branch are segment values for Balancing segment in the Accounting Flexfield. We need to record inter bank transfers i.e. H.O makes payment to Branch and vice versa and also there are transfers between bank accounts of Head Office..

The easiest way is to record a journal in GL. Shall appreciate, if someone can throw some light on how to record these transactions through AP/AR. We are implementing GL, AP, AR, CM on 10.7SC.

Thanks in advance.
Regards,
Chetan Banglorewala

Date: Mon, 05 Jul 1999 20:09:50 LKT
From: Sannidhi Kris sannidhik@hotmail.com
Subject: Re: Re- Inter Bank transfers

Hi Chetan

The way you can do is enter a miscellaneous receipt in AR by taking the bank into which you are receiving money and Crediting a GL account. Then in the same misc receipts screen enter a transaction with negative amount(payment) and take the bank (payment method) from which the money paid.

Hope this works welll.
Bye
Krishna Sannidhi

Date: Tue, 6 Jul 1999 08:35:49 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: Re- Inter Bank transfers

Hi Krishna.
Thanks for your suggestion.
Regards, Chetan

Date: Tue, 6 Jul 1999 14:20:35 +0530
From: rohit.sharma/Polaris@polaris.co.in
Subject: Re: Re- Inter Bank transfers

In my opinon you open bank as supplier in your AP and when you have to Receive money just raise an invoice with distribution set having Cash or bank A/C you have for that bank in G/L and assign credit a/c of the bank while opening bank as supplier. and In case you want to remit money from that bank you just make payment in AP that way you can credit bank A/C while making payment and net balance of the supplier account (Opened for bank name will show balance as of date). In case of branch and H.O transactions you can have intercompany transactuion in Multi org environement.

When money recd.
Debit Assign G/L Cash or bank account in distribution set or line level in the invoice ie: the account from which you are reciving money. credit G/L Account of bank which you have assigned while opening bank as supplier.

I hope this will serve your purpose any clarification feel free to contact me.

Rohit Sharma