ERPstuff - Oracle EBS Community

hai all,

i have one entry pending in unposted items report from gl transfer program.

actually entry is showing like this category=misc receipts,
dr amt cr amt
entry=distribution ac dr 5000 0
cash ac 0 0

i am in 11i can any body tell me how to clear it plzz it is urgent
Warm regards,
stalin

hai

issue is in AR
DR CR
ENTRY IS DISTRIBUTION AC 5000 0
TO
CASH AC 0 0

HAI ALL

I HAVE NOT POSTED IT CORRECTLY

ISSUES IS
ENTRY IS SHOWNIG A DEBIT BALANE
DISTRIBUTION AC 5000
TO
CASH AC 0

I WANT TO CLEAR IT AND MAKE REPORT WITH NO ENTRIES PENDING

hai,

end user entered a a unbalanced misc receipt.is there any possibility to delete it?to void it?or to nullify it?

what is solution for it?i need to cancel the receippt in AR IN 11i
plz help me

stalin

Hello.

That is weird. The system does not allow to enter unbalanced Misc Receipts. The total distributions must equal the receipt amount. Probably it will be better to raise an SR with Support.

Octavio

hai,

thank you for u r answer.but when i see the receipt in tools-view accounting it is showing cash ac dr 5000 to misc receipt ac cr 0

and i no more require the receipt is there anyway to delete it.as it is unbalanced it is not going to gl so please help me

stalin

Hello.

Does the Unposted Items report show any data for the receipt period?
When you navigate to Control/Accouting/Correct Invalid GL Accounts and query do you see any data there?

Octavio

HAI Octavio,

THANK YOU.WHEN I TRY TO RUN THE REPORT ON 31-AUG-2009.ALL THE ENRIES R TRANSFERD TO GL BUT EXCEPT THIS ENTRY.ALL THE JOURNAL ENTRIES IN THE RECEIPT HAS WENT TO GL BUT THIS ONE WAS LEFT AS IT IS UN BALANCED.I WANT TO DELETE IT.

IF FROM BACKEND WHAT R THE TABLES I NEED TO CHECK AND DELETE

TELL ME IN BRIEF WHER TO CHECK CONTROL ACCOUNTING.PLEASE.

STALIN

Hello.

It is not a good idea to delete the journal entry from backend.

To access the accounting control you should navigate to Control/Accounting/Correct Invalid GL Accounts

Octavio

HAI,

IT IS NOT PROBLEM WITH ACCOUNT.IT IS WITH AMOUNT.

CAN I DELETE THE PENDING ENTRY IN UNPOSTED ITEMS REPORT.DOES IT EFFECT IN GENERAL LEDGER.TO DELETE THE MISC RECEIPT CAN ANYBODY TELL THE COMMAND I HAVE TO RUN FORM BACKEND.


STALIN

If you are working in Vision/Test instance, you may update the credit amount column with 5000 (through backend) and then try posting to GL.

If the issue is in PROD instance, then create a SR with oracle support. They would provide the datafix.

Cheers,
Saravanan

HI,

Thank you sarvan.we are working on production.now becoz of this receipt my misc receipts account in gl is showing excess of 5000 in the balance.show now i want to reduce the account balance by 5000.how can i make adjustment in gl.

so,please tell me how to make adjustment to this account by reducing 5000 in gl.what is the process for adjusting in gl.

Thanks,
stalin.

Hi,

can anybody let me know how to make adjustmets in gl accounts.i want to adjust misc receipts account in gl.i want to reduce the balance of that account.so do i need to create any dummy accounts to dedit or credit the required misc receipt account.it is urgent.

Thanks in advance,
stalin.

Please raise a SR with oracle support as it is a production instance.

Have you closed AR period in which the misc receipt is done? It is not just the adjustment of the amount, you should make the entire cycle complete, otherwise you may not be able to close the AR period.

Cheers,
Saravanan