Advanced Collections Configuration work book

Navigator --> Setup and Maintainance--> Collections-->Manage Collecter

Collector Names	Type	Employee	Enabled	Collector Set
Default Collector	Employee	Collecter Name	Yes	Commen Set

Customer

Collection Methods

Collections Preferences

Navigator --> Setup and Maintainance--> Collections-->Manage Collections preferences

Global Preferences

*Transactions tab: default transaction class

*Transactions tab: automatically display closed transactions

*Transactions tab: automatically display current transactions

*Transactions tab from date range: number of days prior to the current date

*Transactions tab to date range: number of days after the current date

*Work status update: maximum number of days work can be rescheduled

*Default aging method

*Delimiter used to separate customer, account, and site

*Minimum number of characters required to perform a search

Allow collector to update transaction attributes

*Send or return email address for dunning correspondence

Maximum number of transactions to send with dunning letters

Number of grace days before a promise is broken

Maximum number of days to make a promise

*Common currency for metric calculations

*Past date to be used for metric calculations

Enable bankruptcy

*Number of parallel processors

*Batch size

Invoice

Yes

999

Collections

Yes

EURO

01-01-2021

Yes

1000

Preferences

Collection Preference Set	Business level	Open Credit Defualt	Currency Converstion Type	Correspondence Method	Unknown Dunning Contact
Comment Set	Site	Sumarize	Corporate	E-Mail	Accounts Payable
~~VJ_ITALY_BU_SET~~ 0333 Preference Set (or 0333 Collection Method Set ??)	Site	Sumarize	Corporate	E-Mail	Accounts Payable

Correspondence

Collection Preference Set	Send Dispute Notice	Dispute Template	Send Payment Notice	Pyament Template	Send Promise Notice	Promise Template
Comment Set	No	Dispute Confirmation Letter	No	Payment Confirmation Letter	Yes	Promise Confirmation Letter
~~VJ_ITALY_BU_SET~~ 0333 Preference Set (or 0333 Collection Method Set ??)	No	Dispute Confirmation Letter	No	Payment Confirmation Letter	Yes	Promise Confirmation Letter

Dunning Delivery using Email

Dunning Letter Template	Email Body
Soft Dunning Letter
Medium Dunning Letter
Hard Dunning Letter
Final Dunning Letter

Scoring formulas

Navigator --> Setup and Maintainance--> Collections-->Manage Collections Scoring

Name	Description	Start Date	Type	From Score	To Score	Enabled
~~Videojet Customer Scoring~~ VTI Customer Scoring	VJ Determines Collections Score of Customers	01-01-2021	Customer	1	100	Y

Weight	Data Points	Function
0.8	Customer Delinquent Amount in Past Year	No
0.2	Customer Delinquencies Count	No

Customer Delinquency Rate

From Range	To Range	Score Value
-99,99,99,999	3,000	90
3,000	10,000	80
10,000	50,000	50
50,000	1,00,000	40
1,00,000.01	99,99,99,999	20

Customer Delinquency Rate

From Range	To Range	Score Value
-99,99,99,999	3	50
3.01	6	40
6.01	9	15
9.01	99,99,99,999	1

Name	Description	Start Date	Type	From Score	To Score	Enabled
~~Intercompany Scoring~~ VTI Intercompany Scoring	VJ Intercompany Scoring	01-01-2021	Site	1	100	Y

Data points

Weight	Data Points	Function
1	Site Total Amount Past Due	Yes

Site Delinquency Rate

From Range	To Range	Score Value
-99,99,99,999	99,99,99,999	100

Name	Description	Start Date	Type	From Score	To Score	Enabled
~~Videojet Bill -To Site Scoring~~ VTI Bill -To Site Scoring	VJ Determines Collections Score of Bill-To Locations	01-01-2021	Site	1	100	Y

Data Points

Weight	Data Points	Function
0.8	Site Total Amount Past Due	No
0.2	Site Delinquencies Count	No

Site Delinquency Rate

From Range	To Range	Score Value
-99,99,99,999	3,000	90
3,000	10,000	80
10,000	50,000	50
50,000	1,00,000	40
1,00,000.01	99,99,99,999	20

Site Delinquency Rate

From Range	To Range	Score Value
-99,99,99,999	3	50
3.01	6	40
6.01	9	15
9.01	99,99,99,999	1

Collections Strategies

Navigator --> Setup and Maintainance--> Collections-->Manage Collections Strategies

Strategy Group

Group Name	Strategy Level	Strategy Type	Allow Strategy Change	Enabled	Start Date
~~Videojet Trade Strategy~~ VTI Trade Strategy	Site	Delinquent	Yes	Yes	01-01-2021

Strategies

Method Name	Lowest Applicable Score
~~Videojet Trade Low Risk Strategy~~ VTI Trade Low Risk Strategy	80
~~Videojet Trade Moderate Risk Strategy~~ VTI Trade Moderate Risk Strategy	35
~~Videojet Trade High Risk Strategy~~ VTI Trade High Risk Strategy	0

~~Videojet Trade Low Risk Strategy:Tasks~~ VTI Trade Low Risk Strategy:Tasks

Order	Name	Category	Excustion Start Time UOM	Post-Excustion wait Time UOM
100	Dunning Letter 1 – Low Risk	Send E-Mail	1 Day	5 Day
150	Call 1 – Low Risk	Phone Call	1 Day	5 Day
200	Dunning Letter 2 – Low Risk	Send E-Mail	1 Day	5 Day
250	Call 2 – Low Risk	Phone Call	1 Day	5 Day

~~Videojet Trade Moderate Risk Strategy:Tasks~~ VTI Trade Moderate Risk Strategy:Tasks

Order	Name	Category	Excustion Start Time UOM	Post-Excustion wait Time UOM
100	Dunning Letter 1 – Med Risk	Send E-Mail	1 Day	5 Day
150	Call 1 – Med Risk	Phone Call	1 Day	5 Day
200	Dunning Letter 2 – Med Risk	Send E-Mail	1 Day	5 Day
250	Call 2 – Med Risk	Phone Call	1 Day	5 Day
300	Account Review	Phone Call	1 Day	1 Day

~~Videojet Trade High Risk Strategy:Tasks~~ VTI Trade High Risk Strategy:Tasks

Order	Name	Category	Excustion Start Time UOM	Post-Excustion wait Time UOM
100	Dunning Letter 1 – High Risk	Send E-Mail	1 Day	3 Day
150	Call 1 – High Risk	Phone Call	1 Day	3 Day
200	Dunning Letter 2 – High Risk	Send E-Mail	1 Day	3 Day
250	Call 2 – High Risk	Phone Call	1 Day	3 Day
300	Account Review	Phone Call	1 Day	1 Day

Scoring and Strategic Assignment

Navigator --> Setup and Maintainance--> Collections-->Manage Collections scoring and Strategies Assignment

Default Assignment

Name	Business Level	Socring Formula	Delinquent Strategy Group
~~Site Delinquent Strategy Assignment~~ 0333 Site Delinquent Strategy Assignment	Site	~~Videojet Bill -To Site Scoring~~ VTI Bill -To Site Scoring	~~Videojet Trade Strategy~~ VTI Trade Strategy

Delinquent Strategy Assignments by Segment

*Name		*Business level	Business Unit	*Profile Class	*Scoring Formula	*Delinquent Strategy Group	Strat Date	Enabled
	Advanced Strategy Assignment 0333 Advanced Strategy Assignment	Site	~~Videojet Italy~~ 0333VJ ITALY	~~Defualt~~ ENDCUSTOMER	~~Videojet Bill -To Site Scoring~~ VTI Bill -To Site Scoring	~~Videojet Trade Strategy~~ VTI Trade Strategy	########	Yes

Predelinquent Strategy Assignments by Segment

Name

*Business level

Business Unit

*Amount Threshold

*Day Threshold

*Predelinquent Strategy Group

Start Date

Enabled

Credit Memo Reasons

LOOKUP_CODE	Reference Data set	MEANING	ENABLED_FLAG
A/R ERROR	Common set	Accounts receivables billing error	Y
BANKRUPT	Common set	Bankrupt-CF	Y
OMBILLING	Common set	Billing	Y
CANCELLATION	Common set	Cancellation	Y
CONTRACTS	Common set	Contract Line Terminated	Y
CREDIT MEMO MISSING	Common set	Credit Memo Missing-VJ	Y
CREDIT and REBILL	Common set	Credit and rebill	Y
LATE PAYMENT	Common set	Credit late payment charge	Y
PA CREDIT MEMO	Common set	Credit memo from projects	Y
CUSTOMER APPROVAL PENDING	Common set	Customer Approval Pending-CP	Y
CUSTOMER FINANCIEL ISSUES	Common set	Customer Financial Issues- CF	Y
CUSTOMER WORKFLOW	Common set	Customer Workflow-CP	Y
NLDAMAGED	Common set	Damaged goods	Y
DAMAGED PRODUCT	Common set	Damaged product	Y
OMERROR	Common set	Data entry error	Y
DELIVERY DATE	Common set	Delivery Date (pull in)-VD	Y
DISCOUNT	Common set	Discount	Y
ORA_DISTRIBUTION_REVERSAL	Common set	Distribution reversal	Y
DOCUMENTS MISSING	Common set	Documents Missing-VA	Y
DUPLICATE BILLING	Common set	Duplicate billing	Y
EMP TERMINATED	Common set	Employee terminated	Y
FOREIGN	Common set	Foreign freight error	Y
FREE PRODUCT	Common set	Free product	Y
FRIGHT ISSUES	Common set	Fright Issues-VL	Y
FUNCTIONALITY NOT MET	Common set	Functionality Not Met-VS	Y
GOOD NOT RECEIVED	Common set	Good not received-VL	Y
WRONG ADM CHG	Common set	Incorrect administrative charge	Y
INSTALLATION DELAYED	Common set	Installation Delayed (VJ)-VD	Y
INSTALLATION DELAYED(CUSTOMER)	Common set	Installation Delayed(Customer)-CD	Y
INCOICE CASE	Common set	Invoice Case -VI	Y
INVOICE MISSING	Common set	Invoice Missing-VI	Y
INVOICE PORTAL ISSUES	Common set	Invoice Portal Issues-CP	Y
LATE PRODUCT	Common set	Late delivery	Y
LEGAL CASE	Common set	Legal case -CF	Y
MISSING/INCORRECT PO FROM CUST	Common set	Missing/Incorrect Po From Customer -VJ	Y
NO REASON	Common set	No reason entered	Y
NOT DELIVERED	Common set	Not delivered	Y
ORDER ENTRY ERROR	Common set	Order entry error	Y
ORA_OWNERSHIP_CHANGE	Common set	Ownership definition change	Y
PA_CREDIT_MEMO	Common set	PA Credit Memo	Y
PARTIAL DELIVERY NOT ACCEPTED	Common set	Partial Delivery Not Accepted-VD	Y
PAYMENT TERMS ISSUE	Common set	Payment Terms issue-VI	Y
PeopleSoft Migration	Common set	PeopleSoft Migration	Y
PRICE DIFFERNCES	Common set	Price differences-VI	Y
RETURN	Common set	Product return	Y
SV CONTRACT CASE	Common set	SV contract case-VS	Y
CONCTRACT EARLY CANCELLATION	Common set	SV contract early cancellation -CD	Y
SALES TAX ERROR	Common set	Sales tax error	Y
SERVICE	Common set	Service	Y
SHIPPING and HANDLING	Common set	Shipping and handling	Y
SHIPPING CHARGES ERROR	Common set	Shipping charges error	Y
TAX_EXEMPT	Common set	Tax exempt	Y
TAX RATE ERROR	Common set	Tax rate error	Y
UNJUSTIFIED CASH DISCOUNT	Common set	Unjustified Cash Discount-CF	Y
WARRANTY CASE	Common set	Warranty case-VS	Y
PA_WRITE_OFF	Common set	Write off from projects	Y
WRONG FREIGHT	Common set	Wrong freight	Y
WRONG PRODUCT	Common set	Wrong product	Y
WRONG TAX RATE	Common set	Wrong tax rate	Y