Accounts Receivable Reports that include Invoices and Paid Amounts
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 |
| -113574.56 |
| -132479.40 | 14/01/2014 |
12345 | 881954 | 06/06/2012 | 21/08/2012 |
| -11699.66 |
| -14468.74 | 06/06/2012 |
12345 | 1038402 | 21/01/2015 |
|
|