Quest infocus 2013
This presentation is the property of its rightful owner.
Sponsored Links
1 / 29

QUEST INFOCUS 2013 PowerPoint PPT Presentation


  • 56 Views
  • Uploaded on
  • Presentation posted in: General

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)

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Quest infocus 2013

QUEST INFOCUS 2013

Invoice / Statement Production and Workflow


Quest infocus 20131

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


Background on creit

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


Technology profile

Technology profile

  • JDE E1 v9.0 , tools 9.0

    • Financials / RE / AREF

  • Spreadsheet Server

  • Excel

  • + Cloud solutions for AP, Building Ops, Tax management, etc.


Invoice rental advice notices ran

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


Invoice ran production

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.


Invoice ran

Invoice / RAN


Invoice ran1

Invoice / RAN


Bi publisher experience

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


Invoice production experience

Invoice production experience

What are your best practices?

  • Bulk invoice processing

  • System integration

  • Billing from other systems

  • Other software for invoice forms


Tenant statement

Tenant Statement

Background:

  • Manual cutting / pasting from JDE

  • Invoices / cash receipts in different screens

  • Need to present a simplified view of account balance


Getting tenant a r information

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


Getting tenant a r information1

Getting Tenant A/R Information


Creit s tenant statement

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


Case study creit s tenant statement

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


Tenant statement1

Tenant Statement


Statement footer

Statement Footer


Statement processing

Statement Processing


Statement request application

Statement request application


Statement job completion notice

Statement job completion notice


Design output for window envelope

Design output for window envelope


Statement integrity check

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)


Statement application architecture

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


Statement template structure

Statement Template Structure


Statement template structure1

Statement Template Structure

Step 1: Load Job Request


Statement page components

Statement Page Components


Statement production experience

Statement production experience

What are your best practices?

  • Methods of Statement production

  • Has anyone used BI Publisher for statements?

  • Questions?


Quest infocus 2013

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.


  • Login