training manual mwm – field user

Training Manual

Deposits

1CRIS_Training Manual_Deposits

2

ContentsProgram Details

Minimum Deposit Amount

Deposit Review

Deposit Refund

3

4

8

23

CRIS_Training Manual_Deposits

Program Details

Program Objective

To familiarize participants on the processes for handling deposits in CRIS

Synopsis

Focus Group

Duration 0.50 Days

• CBS

• Development

• Finance

• Minimum Deposit Amount

Calculation

• Deposit Recommendation &

Review

• Cash Deposit

• Non Cash Deposit

• Deposit Allotment

• Deposit Refund

• Deposit Transfer


Step 1• Minimum Deposit Amounts are configured in Feature Configuration CMDEPMIAMT.

• Admin -> F -> Feature Configuration

• Click on “Search” button and select CMDEPMIAMT


• A new Deposit SA has been created with Minimum Deposit Amount of MYR 70 as configured for Single Level home


• Deposit amount will be charged once the Initial Bill is created as part of New Connection Process.


• Users can see the Deposit Amount a customer holds on Account -> Deposits tab

• All the Bank Guarantees (BG) will be stored as Non-Cash Deposit (NCD) in CC&B.


Deposit Review

• Deposit Amounts will be reviewed annually for Domestic Customers and bi-annually for Industrial customers. Other customers will not be part of Deposit Review.

• Domestic (Tariff 10, 17, 18 and 21)

• Annual: January 31

• Industrial (Tariff 11 and 14)

• Bi-annual: January 31 and July 31

• Charitable Organization, Religious and Government (Tariff 12, 13 and 15)

• No deposit review


• Deposit Recommendation is done through a background process for Deposit Review.

• Batch Control DEPRVWR will run annually on January 31 to recommend Deposit for Domestic Customers.

• Batch Control DEPRVWC will run bi-annually on January 31 and July 31 to recommend Deposit for Industrial Customers.


• Below is the logic for Recommended Deposit Amount Calculation for a customer with following Billing history.

BILL DATE

DAYS IN

BILL PERIOD

CONSU-

MPTION

DAC BILLED AMOUNT (includes GST)

BILLED AMOUNT (excludes GST)

AVERAGE DAILY AMOUNT*

06-01-2016 33 1940 58.79 RM 4,680.03 RM 4,415.12 RM 133.79

04-02-2016 29 1570 54.14 RM 3,786.59 RM 3,572.25 RM 123.18

03-03-2016 28 2370 84.64 RM 5,720.03 RM 5,396.25 RM 192.72

06-04-2016 34 3820 112.35 RM 9,223.35 RM 8,701.28 RM 255.92

06-05-2016 30 4500 150 RM 10,867.81 RM 10,252.65 RM 341.76

06-06-2016 31 3390 109.35 RM 8,185.16 RM 7,721.85 RM 249.09

COMPUTATION Review date 31-07-2016

Average of the daily amounts for 6 months

= (133.79 + 123.18 + 192.72 + 255.92 + 341.76 + 249.09) / 6

= 1296.46 / 6

= 216.08 /day

1-month period coverage = 216.08 x 30 days

= 6482.40

2-month (as deposit amount requires 2-month worth)

6482.40 x 2 = 12964.80

Rounded Up 12970

New Recommended Deposit Amount

RM 12,970.00


• Deposit Review can have 4 scenarios.

• Account has sufficient Deposit

• Additional Deposit Recommended.

• Account has excess Deposit

• Insufficient History on Account

Account has Sufficient Deposit

• If recommended deposit amount is same or within the tolerance of MYR 5, no action will be taken on the Account.


Additional Deposit Recommended

• An additional Deposit required will be created as an Adjustment on the Account.

Example:

Account has a Deposit on hand of MYR 70.


• After running Deposit review, Recommended Deposit Amount is MYR 510.

• Additional Deposit of MYR 440 will be created as an Adjustment.


• This will be swiped onto the next bill generated.


• Account will show the Cash Deposit on Hand as MYR 70 whereas Deposit Requested in MYR 510.


• Once the payment is received from customer, Cash Deposits on Hand will be updated.


Account has excess Deposit

• If Account already had an excess Deposit Amount on hand then the excess Deposit amount will be moved to an Overpayment SA which can be used to offset any debts on the Account.

• Example: Account has an existing Deposit of MYR 2500.


• After Deposit Review, recommended deposit is MYR 2310.


• Transfer Adjustment created for Overpayment SA.


• Overpayment SA has credit of MYR 190.


Insufficient History on Account

• If Account was not having enough billing history available to recommend deposit, an entry will be created in Deposit Review table

• This can be viewed from Menu -> Financial Query -> Deposit Review


Deposit Refund

• After the account is terminated, any deposit available on the account will be first used to offset Account’s debt.

• Any remaining Deposit Amount available on the Deposit SA has to be manually refunded.

• Example: Deposit SA is stopped.


• Account had a Deposit balance of MYR 100. Out of this MYR 34.19 was transferred to Water service SA to offset Account debt.

• Remaining balance of MYR 65.81 can be refunded using Account Payable (A/P) adjustment.


• Account Context -> Go To Adjustment -> Add


• Select Deposit SA.

• Create Adjustment Type of DEPREF.


• Freeze the Adjustment


• AP Request is created and this will be interfaced to SAP system where the refund will be processed.


• Accounts Deposit Amount is zero now.


Thank You


training manual mwm – field user

Documents