Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

AR Invoice and GL Journal Query in Oracle

Hi,

How to query to extract a report which AR invoice (invoice amount per line, invoice description per line and invoice transaction number) link with GL Journal (document sequence number)?

As per below SQL, the result i get is

AR INV amout per line show the total amount according to the account code and

AR INV description per line only show one INV's description

with one journal sequence number because user using create accounting to post the invoice, therefore all the invoice will be included in one journal sequence number.

Below are the SQL:

select

 H.period_name as "Period_Name"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center