ERPstuff - Oracle EBS Community

Hello. See if this query has enough info for you: SELECT h.name, l.effective_date, l.accounted_dr, l.accounted_cr, l.description, l.reference_1, l.reference_3, l.reference_4 FROM gl_je_lines l, gl_je_headers h WHERE l.je_header_id = h.je_header_id AND h.period_name = '<your period name>' AND h.set_o...

Hello. Navigate to Open/Close periods in both modules and try to close the periods. If the system does not allow you to close: In AP, run the Unaccounted Transactions Report for the corresponding period. If any items are listed, you must account for them. In AR, run the Unposted Items Report and run...

Hello.

You must have Dec-2009 open on AP and GL modules. This way you don't need to change the journal date and also avoid creating differences between the subledger and the general ledger balances.

Octavio

Hello.

What is your APPS version?

Octavio

Hello.

Just as Admin said, you need to open the new periods. Navigate to Setup/Financials/Calendars/Accounting, query you accountitng calendar and insert new periods.

Octavio

Hello.

By using Forms Personalization you can easily achive that.

Octavio

Hello. All standard reports are listed under the respective request groups of each module (navigate to Security/Responsibility/Request and query each module). About the usage of the standard reports, i believe it is not easy to define which are more usually requested because it depends on the bussin...

Hello.

You can create a new calendar but you cannot replace the one being used. To do that you will need also to create a new set of books and associate it to the new calendar. Then you have to transfer all existing account balances to the new set of books.

Octavio

Hello.

After it has been completed and accounted?

Octavio

Hello.

Enter a Debit Memo on the same amount and accounting and apply the Credit Memo against it.

Octavio

Hello.

Are you sure that the Supplier and the Site of the prepayment and the invoice are the same?

Octavio

Hello.

What is the status of the Prepayment? Is it paid?

Octavio

Hello.
You can find that info in tables AP_AE_LINES_ALL and AP_AE_HEADERS_ALL

Octavio

Hello.
In Release 12, APXEXPER, Expense Report Export replaces
the Release 11i program APXXTR, Expense Report Import

Octavio

Hello Madhu. You can let your customers make invoice payments in multiple installments by using a split payment term. When you assign a split payment term to an invoice, Receivables automatically creates the payment schedules based on the invoice date and the payment terms that you define. For examp...