Skip to content

Opening book details…

Can I read JDE OTC Ledger View Creation on EtoBox?

JDE OTC Ledger View Creation by Michael Judd is a document available to read on EtoBox.

What is JDE OTC Ledger View Creation about?

Peter proposes creating a new JDE view called otc_ledger_paid that selects data from the existing otc_ledger view and joins it with the f0312 table to retrieve the receipt date for paid documents. The new view will return the same fields as the otc_ledger view plus the receipt date field. This will allow identifying the payment date for documents in the ledger that have been paid.

Author
Michael Judd
Language
EN