Transcript Slide 1

August 2011 Update
The enhancements described in this document are being installed on your DPN accounting server. Make sure this
information is communicated to ALL users of the DPN accounting system before the update so the changes will be
anticipated. Here is a brief overview of some of the changes included in this update:

Zip Code File Structure Changes – Now Accommodates Foreign Addresses

Print Messages

Agent Credit Card Enhancements

Open Item Inquiry & Report Enhancements

eREBS Enhancements
SPECIAL NOTE: This will be the final update handled in this manner where a PowerPoint document accompanies the
update. The May 2011 “Paws for Thought” Lone Wolf newsletter explained in its entirety DPN’s new “Auto-Updating of DPN
Servers” process, which will update your server automatically. The Release Notes for these updates will be available on the
DPN website. Go to www.dpn.com and select the Release Notes tab to download the information.
If you did not receive a copy of the May 2011 “Paws for Thought” newsletter, it is available under the News & Events tab on
both the DPN website (www.dpn.com) and the Lone Wolf website (www.lwolf.com).
8/23/11
1
Zip Code File Enhancements
Many of the newer integration programs, including some franchise feeds, have become more particular of the structure for City
and State information. In addition, foreign addresses have also become more commonplace. Enhancements have been made
to the DPN Zip Code File to accommodate these changes, and they are applicable to all programs in DPN where a zip code can
be entered.
For Non-Foreign (i.e. United States) addresses
If the Zip Code entered is recognized, the City and State will be
populated.
For Foreign (i.e. non-United States) addresses
If the Zip Code entered is recognized, the City, Province, and
Country will be populated.
If the Zip Code entered is not recognized, the Zip Code window
will display the Zip Code along with the Foreign field. Enter N in
the Foreign field. Next, the City and State fields will display as two
separate fields. Enter the City without a comma - the comma will
be added by the system. Enter the 2-digit State Code – enter the
State Code correctly as it is not validated.
If the Zip Code entered is not recognized, the Zip Code window
will display the Zip Code along with the Foreign field. Enter Y in
the Foreign field. Next, the City/Prov/Country field will display.
Enter the City, Province, and Country with the necessary
punctuation.
8/23/11
2
Zip Code File Enhancements - eContract
The Zip Code enhancements are also applicable to the eContract module.
For Non-Foreign (i.e. United States) addresses – If the
Zip Code entered is recognized, the City and State will be
populated as shown in the example below.
8/23/11
If the Zip Code entered is not recognized, a message will
display stating that the Zip Code is not on file and prompt
the user to add the Zip Code to the file. If the user chooses
to add the Zip Code, the Foreign, City and State fields will
display as shown below. Accept the default of “No” in the
Foreign field. Enter the City without a comma - the comma
will be added by the system. Select the 2-digit State Code
from the drop-down list.
3
Zip Code File Enhancements - eContract
The Zip Code enhancements are also applicable to the eContract module.
For Foreign (i.e. non-United States) addresses – If the
Zip Code entered is recognized, the City, Province, and
Country will be populated as shown in the example below.
8/23/11
If the Zip Code entered is not recognized, a message will
display stating that the Zip Code is not on file and prompt
the user to add the Zip Code to the file. If the user chooses
to add the Zip Code, the Foreign field will display – select
“Yes” from the drop-down list, and the City/Prov/Country
field will display – enter the information as necessary.
4
Report Printing Enhancements - Print Messages
Currently when printing a DPN report, depending on the size of the data the report is compiling, the cursor will flash in the upper
left-hand corner of the screen until the report has finished compiling.
Now, a message will display alerting the user that the program is processing.
8/23/11
Following is an example:
5
Real Estate – Credit Cards – (RE-9-5)
The Agent Credit Card Menu has been changed to display in two columns. Option 2, is now labeled “Reports/Inquiry” and a
new inquiry option has been added. Two additional options, 12(Cancel Transactions) and 13(Edit/Update Cancelled) have been
added to allow you to cancel transactions that have been submitted to the credit card company for payment.
Previous Menu
New Menu
Note: If you are using CIM/API Interface, previously that option was number 12, but it is number 20 on the new menu.
8/23/11
6
Real Estate – Credit Cards – (Company Parameters)
A new option has been added to the Bank Rec Type field in the Credit Card Company Parameters. Previously, when credit card
records were updated to Bank Reconciliation the only option was R/Blank(receipts/deposits). Now the option is available to
have credit card records updated as W(wire in/wire out). This is applicable to records processed in options Edit/Update
Authorization File (RE-9-5-9), Edit/Update Manual Authorization (RE-9-5-11), and Edit/Update Cancelled (RE-9-5-13).
8/23/11
7
Real Estate – Credit Cards – Reports/Inquiry (RE-9-5-2)
Enhancements have been made to the following reports:
History Report (RE-9-5-2-2)
The option is now available to print only cancelled transactions. In addition, when the status is D(declined), C(cancelled) or
A(all), the program will use the authorization date for the comparison, otherwise the create date will be used.
History Report by Agent (RE-9-5-2-3)
The option is now available to print only cancelled transactions.
New Option - History Inquiry by Agent (RE-9-5-2-10)
This new option allows you to view an agent’s credit card payment history by record number or status. If the display order
selected is by S(status), the status code (new, submitted, accepted, cancelled, declined, or all) will be required. The
following example shows that C(cancelled) records were selected:
8/23/11
8
Real Estate – Credit Cards – “On Account” Payments
“On account” payments flagged to be paid back to an agent’s credit card using the Auto or Manual Flag Charges options, will now
have an “M” print on the following reports & inquiries:
•
•
•
Accounts Payable Open Items (AP-7-1) when printing type 2
Open Receivables Report (RE-9-10)
Open Receivables History (RE-9-20) Inquiry screen when F6(print) is selected
“M” Indicates item was
flagged in either the Auto
Flag Charges (RE-9-5-3) or
Manual Flag Charges (RE9-5-4) options AND updated
using the Edit/Update Agent
Charges option (RE-9-5-5)
8/23/11
9
Real Estate – Credit Cards – “On Account” Payments
“On account” payments posted in the new month will display with a “P” next to the status column when printing or viewing the records
in the new month. For example, an “on account” payment was posted in the current month (2/11), but was flagged to be back on the
agent’s credit card in the new month (3/11). When printing the Open Receivables Report (RE-9-10) for the current month (2/11), the
record will have a “P” printed next to the Status column. This is applicable to the following options:
•
•
•
•
•
Accounts Payable Open Items (AP-7-1) when printing type 2
Accounts Payable Aged Open Items (AP-7-1) when printing type 2
Open Receivables Report (RE-9-10)
Open Receivables History (RE-9-20) Inquiry screen when F6(print) is selected
Agents Aged A/R Report (RE-9-12)
“P” Indicates item was
paid in the new month
8/23/11
10
Real Estate – Credit Cards – “Open Item Inquiries & Reports”
The Accounts Payable Open Items Inquiry (type 2) (AP-7-1) and Open Items by Payee (type 2) Report (AP-7-1) have been enhanced
to be consistent with the Agent A/R Open Receivables Inquiry (AP-9-20) and Open Receivables Report (RE-9-10) options. These
options now print/display the same information for records that are flagged to be paid by credit card, manual check, or check writing.
Examples of both reports, along with a legend, show the consistency of the data that is printed on the two reports. These examples
are displayed on pages 12 and 13.
8/23/11
11
Real Estate – Credit Cards – “Open Item Inquiries & Reports”
A/P Open Items Report (AP-7-1)






Legend:
**FLAGGED FOR CREDIT CARD – This description indicates the one of the following:
•1) A Partial Payment amount was updated in the Flag Charges Update (RE-9-5-5) and is waiting to be sent to the credit card company (RE-9-5-7).
•2) A Partial Payment amount has been sent to the credit card company (RE-9-5-7) and is awaiting authorization (the record has not been updated in DPN as “Authorized” OR
“Declined”.)
 **FLAGGED FOR COMPUTER CK – This description indicates a Partial Payment amount has been entered through Check Writing, but has not been paid.
 **FLAGGED FOR MANUAL CHECK – This description indicates a Partial Payment amount has been entered and the record is sitting in the Manual Check Edit.
 **IN CREDIT CARD EDIT – This description indicates a Partial Payment amount has been entered and the record is sitting in the Flag Charges
Edit (RE-9-5-5) .
•NOTE: Partial Payment amounts are not included in the totals – the partial payment amount is offset to the left of the amount column.
 M – An “M” printed to the left of the record indicates the entire amount has been flagged to be paid by manual check or credit card.
S – The record has been flagged to be paid and is sitting in the Agent Cash Receipts Edit.
8/23/11
12
Real Estate – Credit Cards – “Open Item Inquiries & Reports”
Open Receivables Report (RE-9-10)






Legend:
**FLAGGED FOR CREDIT CARD – This description indicates the one of the following:
•1) A Partial Payment amount was updated in the Flag Charges Update (RE-9-5-5) and is waiting to be sent to the credit card company (RE-9-5-7).
•2) A Partial Payment amount has been sent to the credit card company (RE-9-5-7) and is awaiting authorization (the record has not been updated in DPN as “Authorized” OR
“Declined”.)
 **FLAGGED FOR COMPUTER CK – This description indicates a Partial Payment amount has been entered through Check Writing, but has not been paid.
 **FLAGGED FOR MANUAL CHECK – This description indicates a Partial Payment amount has been entered and the record is sitting in the Manual Check Edit.
 **IN CREDIT CARD EDIT – This description indicates a Partial Payment amount has been entered and the record is sitting in the Flag Charges
Edit (RE-9-5-5) .
•NOTE: Partial Payment amounts are not included in the totals – the partial payment amount is offset to the left of the amount column.
 M – An “M” printed to the left of the record indicates the entire amount has been flagged to be paid by manual check or credit card.
S – The record has been flagged to be paid and is sitting in the Agent Cash Receipts Edit.
8/23/11
13
Real Estate – Credit Cards – “Open Item Inquiries & Reports”
The legend shown on the previous page also applies to the Agent A/R Open Receivables Inquiry (RE-9-20) and Accounts Payable
Open Items Inquiry (AP-8-2) by Payee (type 2) options. These options now display and print the same information for records that
are flagged to be paid by credit card, manual check, or check writing. The examples below show the consistency of the data that is
displayed between the two inquiry options. When using either option, select the F3(applied payments) function key from the main
“pick” screen, then press Enter to display the record. To print the information, select the F6(print) function key from the main “pick”
screen.
Open Receivables Inquiry (RE-9-20)
8/23/11
Open Items Inquiry (AP-8-2)
14
eREBS Enhancements – Fallthru Contracts
An option to view Fallthru Contracts has been added to the eREBS Menu. Fallthru contracts can be viewed by agent or office:
8/23/11
15
eREBS Enhancements – Agent Profile/My Production
The following enhancements have been made to the Agent Profile/My Production screen:
The following new eREBS Parameter
options have been added (screen #3):
1) The option is now available to display
only the agent’s current level, or both
the agent’s current commission
percent and next level.
2) The option is now available to show or
omit the agent’s current commission
split.
3) The option is also available to display
the agents GCI as gross or income, or
omit the information completely.
The “Categories” header
has been changed to
“Categories/Teams”.
In
addition to any categories
an agent is affiliated with,
any teams the agent is
affiliated
with will also
display in this section.
8/23/11
This notation is dependent upon the
following settings:
1) If the Agent GCI field on Screen #3 of
the eREBS Parameters is set to
G(gross), and the Rpts/Add Promo to
Gross field on Screen #5 of the Real
Estate Parameters is set to “Y”, the
notation “Promo added to gross” will
display.
2) If the fields are set to “I”, the notation
“Promo added to income” will display.
16
eREBS Enhancements – Agent Profile/My Production
Drill-downs are now available in fields that have a hyperlink, such as Open Item A/R Balance, 1099 Balance, Projected Written
Commission, Closed GCI, Listings, and Closed Contracts, etc. When drilling-down on the A/R Balance detail from this screen,
partial payments will now display.
8/23/11
17
eREBS Enhancements – Agent Profile/My Production
The comparison layout in the Listings and Closed Contracts sections is now different – the examples below show both the new
and previous formats. The new format is more columnar, displaying additional information for average listing price, as well as
additional information regarding average sales price and GCI for closed contracts You can drill-down to the detail in the current
year and the last year. The Average Price columns are calculated as follows:
Total Volume divided by Total Units = Average Price
*NOTE: This calculation is using the sales volume, not the sales price.
New Format:
Previous Format:
8/23/11
18
eREBS Enhancements – Ancillary Services
The Ancillary Services Summary and Detail Reports have been enhanced to include “Cash” totals if your company uses the
Cash Sale Payee feature (the Cash Sale Payee number must be entered in the eREBS Parameters, Screen #2).
Previously, the ancillary reports excluded deals associated to the Cash Payee.
The example Summary report below was created by selecting Ancillary Services by Office for the Current Year, then
selecting the Mortgage Company Units/Volume – Summary option. The detail report for the same criteria is shown on the
next page:
8/23/11
19
eREBS Enhancements – Ancillary Services
The example Detail report below was created using the same criteria as the summary report on the previous page (Ancillary
Services by Office for the Current Year, Mortgage Company Units/Volume – Detail option). The totals on this report tie to the
summary report totals.
As shown in the example below, the “Cash” totals now print as a separate line item:
8/23/11
20
eREBS Enhancements - Reports
The following enhancements have been made to the eREBS Reports:
1. The Birthday List now includes the agent’s mailing address.
2. The Agent Receivables reports now display totals which are consistent with other reports. The “Download PDF Report” link has
also been added.
3. Closed and Written Contracts by Agent now display/print a Co $ column if the Company Dollar parameter field in screen #6 of the
eREBS parameters is set to Y.
4. Agent Ranking:
1. If the agent’s next level is zero, the verbiage “Highest Level” will be printed on the report.
2. If the ranking report selected does not include MTD columns, a default date will populate for the calculation.
5. Listings by Office summary screen – Totals now display on one screen. This is a great tool for General Managers.
8/23/11
21