My Oracle Support Banner

E1: 15: Enhancement Request for New Tenant Ledger Report To Show Additional Detail (Doc ID 2482859.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Real Estate Management - Version 9.2 and later
Information in this document applies to any platform.


User is requesting a Report that does the following:

Client requires an additional Monthly Chronological table or report whereby
the Payments and Invoices are shown on a monthly basis (ie all Feb Invoices
and all Feb receipts would show up under the month of Feb). All detail would
have to be kept ¿ ie all GL offset codes would have to be shown with amounts.
An additional column would have the Invoices netted against the Monthly
Invoices. The result should show the Net over /under each month plus an
additional Accumulative amount.
This Accumulative Amount would equal the current OPEN amount showing in the
Invoice table (in other words the Tenant Ledger)
It must be kept in mind that the LEASE may have Tenant billings and payments
plus Agency billings and payments. Again, all must be detailed by month.
NSF's and ECK (errors) would also have to taken into account.

In summary, the OPEN amount of the Tenant Ledger would be equal to the
Accumulative Amount of the new Table. It is just the New Table would show how
the payments are used to net down the invoice amounts.

Currently, the client is able to ascertain where the payment is coming from
by using the alt payer number.

Would like to see:
Need Batch #'s
Need Lease #'s
Must be in Chrono order by Invoice Date.

So the Tenant Ledger shows the end balance. (just doesn't show how we got to
that point). If the user could run a report, see the Chrono listing of all
Lease transactions that would be great. The 'upload' to excel would be a
great function and we could manipulate and print from there.OR, having a
report available for printing in excel or CSV) format would be good too. User
could always do a Print Screen but can get a little cumbersome.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.