ERPstuff - Oracle EBS Community

Hello.

Insert a line with Calculations and choose the Low/High line sequence you want to sum up.

Octavio

Hello. This is for EBS 11.5.0.2. For an Invoice: select l.reference_5 InvNr, l.reference_10, cc.segment2 account, l.accounted_dr, l.accounted_cr from gl_je_lines l, gl_code_combinations cc where cc.code_combination_id = l.code_combination_id and l.reference_2 = <your invoice_id> and l.reference_5 = ...

Hello.

To which segments do these accounts belong to? What do you want to sum? Debit? Credit? For which period?

Octavio

Hello.

Normally, the Invoice Aging is enough because it can show you everything, or just only what is due. You must set up Aging Periods before running Invoice Aging. You can define a lot of periods but usually, for what i've seen, six periods are enough.

Octavio

Hello.

For issue 2 i think you can use the Invoice Aging Report.

Octavio.

Hello.

Are you talking about APPS standard reports? Can you mention their exact names?

Octavio

Hello. Here's the script: CREATE OR REPLACE VIEW GL_CODE_COMBINATIONS_KFV (ROW_ID, CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID, CONCATENATED_SEGMENTS, PADDED_CONCATENATED_SEGMENTS, GL_ACCOUNT_TYPE, DETAIL_BUDGETING_ALLOWED, DETAIL_POSTING_ALLOWED, REFERENCE2, SEGMENT_ATTRIBUTE37, SEGMENT_ATTRIBUTE14, ...

Hello. Customer Class IS NOT the same as Customer Profile Class. Customer Class is a category that you have previously defined in the Receivables Lookups window with the lookup type 'Customer Class'. You can classify your customers by industry, location, or size. If you choose industry, you might wa...

Hello. Supose you create journal A and post it. Later you reverse it. The system automatically creates journal B, unposted. If you delete journal B you can no longer reverse journal A because it has already been reversed. What you can do is to manually enter a journal with the opposite accounting of...

Hello. To pay some amount in AP, the record to be paid must exist. If you do not have the invoice at the time of issuing the payment you can record an invoice of type Prepayment and pay it. Later, when you receive the final invoice you can apply the Prepayment to that invoice and it will get paid. O...

Hello.

You can define rules for all combinations of segments.

Octavio

Hello.

Did you try to personalize the form?

Octavio

Hello.
Cash Management considers amounts entered through GL if they affect an account used as the Cash Account at a Bank Account. You can treat these amounts as Payments or Receipts.

Hope this helps.
Octavio

Hello.
In the Asset Workbench, search for the asset you want and press the Financial Inquiry button then open the Cost History tab to see transactions recorded against the asset.

Hope this helps.
Oct

Hello. From the front end I guess there is no place where you can look for this information. In the table AP_INVOICES_ALL (EBS 11.5.10.2) there is a column called SOURCE which stores the value ?Manual Invoice Entry? for manually entered invoices or other for the name of the source if the record has ...