550 likes | 569 Views
DBSi 5.0 Credit Integration. Customer focused. Results-driven. Moving your business to a new level. February 2011. DBS i 5.0 Credit Management. Credit Check Process Alternate Credit Check Credit Configuration Display Customer Information-DBS Display Blocked Orders
E N D
DBSi 5.0 Credit Integration Customer focused. Results-driven.Moving your business to a new level. February 2011
DBSi 5.0 Credit Management • Credit Check Process • Alternate Credit Check • Credit Configuration • Display Customer Information-DBS • Display Blocked Orders • Credit Approval Levels • Display Customer Information-CODA V11 • Credit Diary • Payment Terms • Interest Calculation • Customer Statement
DBSi 5.0Credit Check Process • Manages credit limits and credit category parameters within Credit Areas • Utilizes both credit limit and credit category parameters to evaluate credit risk: • Credit Exposure • Maximum Document Value • Percentage Past Due • Oldest Aging Bucket • Offers Parent/Child functionality • Will block Rental Orders from EMS due to Credit • Will offer Credit Approval Levels
DBSi 5.0 Credit Exposure Calculation Credit Exposure Calculation within Credit Areas: • Available credit = (credit limit - open receivables (CODA V11.3) - open orders (DBS) and invoices not posted to CODA (DBS) • Will be calculated for a parent/child relationship by combining the exposure for the parent as well as all children in that relationship • For multi-currency dealers documents will be converted to the customer’s currency on a document by document basis using the exchange rate assigned to that document
DBSi 5.0Credit Check Process- Alternate Process • If there are connectivity problems between CODA and DBS: • A credit check will be performed for exposure (including DBS Open Orders only) against credit limit and an error message will be displayed stating there were connectivity problems. All zeroes will be populated in fields containing CODA information such as aging, high balance, Open AR. • This will allow the orders to be processed, and will alert the user there was a problem.
Service CA 0002 Parts, Service,Rent, Sales CA 0001 Parts, Service, Rent CA 0001 Rental CA 0003 Sales CA 0002 Sales CA 0004 Parts CA 0001 DBSi 5.0 Credit Areas A Credit Area is an organizational entity that defines and monitors credit limit data for customers. Below are a few examples of Credit Area setup options. Example 1 or Example 2 or Example 3
DBSi 5.0 Configuration to Define Exposure Assign Lines of Business to Credit Areas MNTFNCRDP Credit Check Parms Maintain Aging Bucket, GL Account and Document Code Selection in Credit Area Ledgers Financial Ledger Master Maintenance Set Up AR Account Balances for Exposure. Assign ledger to Credit Area MNTFNACBL Customer Account Balance 0001-ZZCRCK0001 0002-ZZCRCK0002 0003-ZZCRCK0003 0004-ZZCRCK0004 TOTL-ZZCRCKTOTL PART- 0001 SRVC- 0002 RENT- 0003 SALE- 0004 ALL- TOTL ZZCRCK0001-120100-PS00,PS10,etc ZZCRCK0002-120100-SV00,SV10,etc ZZCRCK0003-120100-RR00,RR10,etc ZZCRCK0004-120100-SS00,SS10,etc ZZCRCKTOTL-120100-”*”(All)
DBS 2.3.4 Credit Parameters CODA Option 07
DBSi 5.0 Credit Parameters MNTNFCRDP
DBSi 5.0 Credit Parameters MNTNFCRDP
DBS 2.3.4 Credit - AR Balances CODA Option 08
DBSi 5.0 Customer Account Balances MNTFNACBL
DBSi 5.0 Customer Account Balances MNTFNACBL
Maintain Credit Area Selector • Menu Path: Financials/Masters/Selector • Add appropriate Document Codes
Maintain Credit Area Ledger • Menu Path:eFinance/Enquiries/Masters/Ledger • Please Note: Column Names and Order cannot change. • You can change the aging buckets within the columns
DBSi 5.0 Customer Credit Configuration Create Credit Categories MNTFNCRCT -Credit Categories Assign a credit limit and a credit category to a customer for each credit area being used. MNTCICUS -Customer Information NEW-NewCustomer LOW-LowRisk MED-MedRisk H01-HighRisk NCC-NoCredit Check 0001-LOW, $10,000 0002-LOW, $60,000 0003-LOW, $100,000 0004-NCC, $600,000
DBS 2.3.4 Credit Credit Categories Was not Available
DBSi 5.0 Credit Categories MNTFNACBL
DBSi 5.0 Credit Categories MNTFNCRCT
DBSI 5.0 Customer Credit Master Data MNTCICUS
DBSI 5.0 Customer Credit Master Data MNTCICUS The only credit limit which will be passed to CODA V11 is the Total Credit Limit
DBSi 5.0 Parent/Child • A new Finance Parent field will be available on the customer maintenance screen in core DBSi. • A new CHLD (Child Customer Number) Info Code will be available. • If the Finance Parent field is populated on a customer record, when an order is placed for the child customer, the child customer will receive the invoice however, when that invoice is posted in CODA V11.3 the parent customer will be moved in as the receivables customer account. Dealers will have the option of passing the child customer via an info code in either an element or an external reference. • If the child is being passed as an element it will need to be configured in MNTFNCOCD -Company Maintenance • New Limit of Children allowed is 2,000
DBSi 5.0 Credit Approval Configuration Setup Credit Managers in CODA Administration-Security- User Master Assign Credit Levels and Stores to Credit Approvers and Credit Managers -MNTFNCRAL Approver Level Parameters Assign Excess Exposure Amount and Aging Bucket Limits to Credit Levels -MNTFNCRLP Credit Level Parameters XUPD43ABC-99, Store**, Crdt Mgr-Y XUPD43DEF-10, Store00,Crdt Mgr-N BRANCH 1- 99, Store 01,Crdt Mgr-Y XUPD43ABC-Capability Group: Credit BRANCH 1- Capability Group:Display 10-$10,000,TWO 20-$50,000, TWO 30-$100,000, THREE 99-$999,999,999 OVER
DBSi 5.0 Credit Approval Parameters • Dollar limits denote the maximum amount of exposure that may exceed credit for the approval level. All 9’s in this field denotes unlimited credit approval. • Approval parameters include checking Aging Bucket Limit. An OVER in this field designates no aging bucket limit. • An approver may be assigned to approve documents from multiple stores or “**” may be used to signify approval authority for all stores. • All approvers that will be assigned to customers as credit managers, will need to have a “Y” in the credit manager field and will need to be set up as a user in CODA • These parameters are set in core DBSi -MNTFNCRLP Credit Level Parameters and MNTFNCRAL Approver Level Parameters
DBSi 5.0 Credit Level Parameters MNTFNCRLP
DBSi 5.0 Credit Approver Parameters MNTFNCRAL
User Setup-CODA • Menu Path: Administration/Security/User Master
DBSi 5.0 Credit Approval • DBS orders blocked due to credit failure are approved using the CRDTSTS function in DBS • This screen may also be accessed by selecting a specific document in the Blocked Orders (DSPFNBLOR) screen in DBS. • Valid statuses for the approval field include • O = Approved for Open • C = Approved for Close (An approval level of “C” approves a work order on Open and Close) • P = Pending (A document with this status is not approved) • R = Rejected (A document with this status will be removed from the Credit Approval Screen) • Approval levels along with the approval parameters are set in DBS. These levels are then assigned to credit approvers and will determine who may or may not approve an order.
DBS 2.3.4 Credit Approval CODA Option 70
DBSi 5.0 Credit Information DSPCRDT
DBSi 5.0 Credit Information DSPCRDT – F11
DBSi 5.0 Credit Information DSPCRDT – F14/F11
Rental Credit Information- (DSPFNCRDT) This functionality will be obsolete in DBSi 5.0.
DBSi 5.0 Credit Display DBSi 5.0 Credit Information • All DBSi orders blocked due to credit may be viewed by executing DSPFNBLOR- Display Blocked Orders • Total exposure for a customer may be viewed by executing either DSPCRDT-Display Credit Approval or CRDTSTS-Display Credit Status • Credit Diary, Line Item Reports, Aging Reports, Balance Reports are all available in CODA.
Coda V11- Browse Ledger- Drill Down Tabs Display • Please Note: Tabs displayed are customizable
DBSi 5.0- Payment Terms Set Up • Payment Terms Code will be four characters to match CODA payment terms. • Payment Terms will be set up in Core DBSi -MNTSCTAB • Payment terms by line of business will be offered in DBSi 5.0. and are set up in MNTFNCRDP • Customers who are exceptions to the default payment terms may be set up with their own payment terms by line of business. This is done in Core DBSi in MNTCICUS. • Default Payment Terms will be set up by Document Master/Elements in CODA for those transactions that originate in CODA and not Core DBSi.
Assign Default Payment Terms by Line of Business (MNTFNCRDP)
DBSi 5.0- Payment Terms Process • The payment program process is as follows: • Check to see if a due date is entered on the document. If so use that as the baseline date and enter payment terms of due immediately. • If a due date is not entered on the document, the program will check to see if the customer has payment terms. If so, these payment terms will be used. • If there are no payment terms on the customer master the default payment terms by line of business will be used. • If a document is sent to CODA V11.3 without a due date and there is no payment term on the document code, the due date will be due immediately.