1 / 29

QUEST INFOCUS 2013

QUEST INFOCUS 2013. Invoice / Statement Production and Workflow. QUEST INFOCUS 2013. Agenda: “This session is intended to be interactive; there are many methods to accomplish the same goal. Ask questions and share your experience.” Introduction & Background on CREIT (5m)

aleta
Download Presentation

QUEST INFOCUS 2013

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. QUEST INFOCUS 2013 Invoice / Statement Production and Workflow

  2. QUEST INFOCUS 2013 Agenda: “This session is intended to be interactive; there are many methods to accomplish the same goal. Ask questions and share your experience.” • Introduction & Background on CREIT (5m) • Form Invoices / Rental Advice Notices (10m) • Statement Production (25m) • Comments & feedback

  3. Background on CREIT • First REIT in Canada - Established in1993 • Head office in Toronto • 190 properties 20m sf owned 23m sf managed • 22 properties in development • Operate across 5 regions • For more details visit us at www.creit.ca

  4. Technology profile • JDE E1 v9.0 , tools 9.0 • Financials / RE / AREF • Spreadsheet Server • Excel • + Cloud solutions for AP, Building Ops, Tax management, etc.

  5. Invoice / Rental Advice Notices(RAN) • Each regional office produces their own invoices, charge backs for services, EP recovery adjustments, Administrative fee’s etc. • Rental advice notices are issued at year end for all tenants. And whenever a change in rent occurs. • Each invoice is produced individually from JDE

  6. Invoice / RAN Production • Custom UBE developed for invoice & Rental Advice Notice • Beginning to use JDE’s BI publisher for better presentation of these documents • Original application of BI publisher was for Check production.

  7. Invoice / RAN

  8. Invoice / RAN

  9. BI Publisher Experience • Initially used for replacement of check form software, we developed check templates using MS word 2010 • Very quirky (more a function of word) • Need to be very precise with positioning of MICR code, especially troublesome with overflow pages (multi-page check stubs) • Hint: Use tables to position everything on the form and use the word image “canvas” to lock down position of graphical elements • Documentation of BI publisher was scarce

  10. Invoice production experience What are your best practices? • Bulk invoice processing • System integration • Billing from other systems • Other software for invoice forms

  11. Tenant Statement Background: • Manual cutting / pasting from JDE • Invoices / cash receipts in different screens • Need to present a simplified view of account balance

  12. Getting tenant A/R information Biggest challenge: Users need to navigate multiple screens to see the complete picture • A/R tenant ledger inquiry • Work with tenant receipts inquiry • Work with tenant receipts summary • Work with tenant receipts detail

  13. Getting Tenant A/R Information

  14. CREIT’s Tenant Statement Objective: • Easy to understand view of all A/R activity • View the A/R position at any point in time • PDF / Excel output formats • Bilingual • Summary / Detail format • Show Security deposit / prepaid amounts

  15. Case Study CREIT’s tenant statement Requirement: • Credit card style statement of account • Allow to historical “As of” balance • PDF / Excel output formats • Bilingual • Summary / Detail format • Show Security deposit / prepaid amounts

  16. Tenant Statement

  17. Statement Footer

  18. Statement Processing

  19. Statement request application

  20. Statement job completion notice

  21. Design output for window envelope

  22. Statement integrity check Instruction to users: Always validate the statement balance to tenant’s A/R ledger in JD Edwards Excel attachments should only be requested on an exception basis. Show error message If there is an integrity issue with the tenant account balance (difference found in JDE current as of balance to statement calculated balance)

  23. Statement Application Architecture • Application Components: • Client Application • Request application (.net Visual Basic App) • Batch Server components • Windows desktop running in a VM session • Executive dash (globalsoft excel data connector - SQL) • PDF 995 (pdf printer) • Windows scheduler / Batch processing files to launch the template • Excel Statement template – turn off all security restrictions so that Excel launches macros without “enable macros” dialog box • VBA Code in the Excel template to build the report, Save output and Send email notice back to the user

  24. Statement Template Structure

  25. Statement Template Structure Step 1: Load Job Request

  26. Statement Page Components

  27. Statement production experience What are your best practices? • Methods of Statement production • Has anyone used BI Publisher for statements? • Questions?

  28. April 7-11, 2014 The Venetian and Sands Expo Center Las Vegas, Nevada QuestDirect.org/COLLABORATE Attend COLLABORATE 14 to hear high-level, strategic education for the JD Edwards audience. Register through Quest to receive exclusive JD Edwards updates, materials and networking events. Registration OPEN! Early Bird rates end February 12, 2014.

More Related