Financial - JDE1 (MOSC)

MOSC Banner

Accounts Receivable Reports that include Invoices and Paid Amounts

edited Feb 1, 2015 2:22PM in Financial - JDE1 (MOSC) 1 commentAnswered

Hello

I'm wondering if there is a standard JDE report that will show invoices open
and paid and when they were paid per customer.

Using SQL I extracted the following data for an end user from the F03B11 and
F03B14, but before developing a customised report I wondered if there is a
standard JDE report that shows similar data.


 

Customer


 

 

Invoice


 

 

Invoice Date


 

 

Receipt date


 

 

Foreign Invoice amount


 

 

Foreign Paid Amount


 

 

Invoice Amount


 

 

Paid Amount


 

 

G/L Date


 

 

12345


 

 

972639


 

 

14/01/2014


 

 

28/04/201


 

 
  1. 113574.56
 

 

-113574.56


 

 
  1. 139509.38
 

 

-132479.40


 

 

14/01/2014


 

 

12345


 

 

881954


 

 

06/06/2012


 

 

21/08/2012


 

 
  1. 11699.66
 

 

-11699.66


 

 
  1. 14308.01
 

 

-14468.74


 

 

06/06/2012


 

 

12345


 

 

1038402


 

 

21/01/2015


 

 


 

 
  1. 17569.17
 

 


 

 
  1. 22389.64
 

 


 

 


 




 
 
 
 
 
 
 
 
 
 
 
 


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