Credit Management Blocking Rules: Dynamics 365 Finance ...

To create the blocking rule click the “New” button and set the “Rule type” to “Blocking” and select the “Terms of payment” that should trigger a credit ... SkiptocontentDynamics365FinanceandOperationscreditmanagementfunctionalityhasbeenmuchimprovedinrecentmonthsfromwhathadbeenveryminimalfunctionality.MicrosofthasnowcreatedaCreditandCollectionsmodulededicatedtothisnewcreditmanagementfunctionality.Therearemanygreatfeaturesbutthemostimportantinmyestimationaretheblockingrules.Blockingrulesallowcreditmanagersandaccountmanagerstosetupaseriesofdifferentblockingrulesbasedoncommoncreditrelatedrulesthatwilltriggercreditmanagementholdsonasalesorder.Theserulesarebasedonverycommonreasonsforcreditholdsinmostorganizationsandareeasilyconfigured.Inthispostwewillgooverthesetupsrequiredtousethisfunctionalityaswellasshowsomeexamplesofhowtheholdsworkandhowtheholdreviewandreleaseprocessworks.BlockingRulesSetupsThefirststeptoenablingblockingrulesisenablingthecreditmanagementcheckpoints.TodothisnavigatetoCreditandcollections>Setup>Creditandcollectionsparameters.Clickthe“Credit”tab.Inthe“Creditmanagementcheckpoint”sectionweareabletoselectwhicheventswilltriggerthesystemtochecktheblockingrulesandifanyofthemareviolated,willresultinacreditmanagementhold.The“Documentstatuscheck”columnindicatestheeventandthe“Posting”columnindicatesiftheactualdocumentoreventispostedtheblockingrulesshouldbefired.Ifthe“Proforma”checkboxischeckeditmeansthattheblockingrulesareevaluatedwhenaproformaversionoftheeventisposted.Inthe“Gracedays”columnyoucanspecifyhowmanydaysafterthecreditmanagementholdhasbeenreleasedthatyouhavetoprocesstheorderbeforethesameholdcanbeappliedagain.So,forexampleifyousetthegracedaysto5andyoureleaseacreditmanagementholdyouwillhave5daystoprocessthatorderandonthe6thdayiftheblockingrulesarerunagainandaretriggered,thesameholdcanbereapplied.Ifyouwanttocheckcreditlimits,makesureyouenablethe“Checkcreditlimitonsalesorder”flag.Nowthatwehavesetupourtriggersforcreditmanagementblockingruleswecannowgothroughandsetupourblockingrules.Youcansetuponeormultipleblockingruletypesthatcanallbeevaluatedwhenblockingrulesaretriggered.DaysOverdueThefirstblockingruletypethatcanbeconfiguredisthe“Daysoverdue”blockingruletype.Thisblockingrulewillputacustomeronholdiftheyhaveabalancethatisoverduebyagivennumberofdays.Inmyexperiencethisisthemostcommonlyusedblockingrule.Tocreateablockingrulefor“Daysoverdue”,clickthe“Daysoverdue”tabandclickthe“New”button.Intheaccountcodefieldselectwhetheryouwantthescopeoftheruletoapplytoasinglecustomer(table),agroupofcustomers(group)orallcustomers(All).Ifyouselectgroup,youwillneedtoselectacreditmanagementgroupandthenassignthatcreditmanagementgrouptotheapplicablecustomers.Basedonthe“Accountcode”selection,inthe“Account/Group”fieldselectacustomeraccountorcreditmanagementgroup.Youcanalsopairdowntherulebyaddingariskgroup.Thiswillfiltertheruledowntoonlycustomersthatarealsoassociatedwithacertain“Riskgroup”.Thisisnotarequiredfield.Itisonlyusedifyouwanttofurtherfilterdownthecustomerselection.Inthe“Ruletype”fieldyoucanselectwhethertheruleisablockingruleoranexclusionrule.Typically,thewayIconfigurethisisIsetupallmyblockingrulesandtheniftherearespecificcustomersorgroupsofcustomersthatshouldbeexcludedfromtherulethatIjustsetup,Iwillsetthoseupas“Exclusion”rules.Thiswillexcludethosespecificcustomersorgroupsofcustomersfrombeingputonholdforthatspecificblockingrulecondition.The“Operator”and“Valuetype”fieldsarefixedsoyoucanskipthose.Thenextfieldisthe“Overdue”fieldwhichdefineshowmanydaysoverduedoyouwanttoallowabalancebeforethesalesordershouldbeputoncreditmanagementhold.So,inthisexampleifcustomer“C000000034”hasanyoverduebalanceof15daysormorethesalesorderwillbeputoncreditmanagementhold.AccountStatusThe“Accountstatus”blockingruletypewillplaceasalesorderonholdiftheaccountstatusofacustomerhasacertainaccountstatus.Thisisaprettystraightforwardrulethatallowsyoutocreateuserdefinedaccountstatusesandthenassignthemtocustomers.Tocreatetheblockingrule,clickthe“New”button,definethe“Ruletype”asa“Blocking”ruleandwhich“Accountstatus”shouldtriggerthesalesorderhold.TermsofPaymentThe“Termsofpayment”blockingruletypewillputasalesorderonholdiftermsarepaymentmatchthetermsofpaymentspecifiedintheblockingrule.Thisistypicallyusedforcustomersthatrequirefullpaymentorpre-paymentbeforeprocessinganorder.Tocreatetheblockingruleclickthe“New”buttonandsetthe“Ruletype”to“Blocking”andselectthe“Termsofpayment”thatshouldtriggeracreditmanagementholdonasalesorderifthatpaymenttermisused.CreditLimitExpiredThe“Creditlimitexpired”blockingtypewillplaceasalesorderonholdiftheselectedcustomerorgroupofcustomers,hasacreditlimitthatisagivennumberofdaysexpired.Onthecreditandcollectionsfasttabofthecustomerrecordthereisa“Creditlimitexpirationdate”fieldthatthesystemwilllookattodeterminewhetherornottheordershouldbeplacedonholdforthatcustomer.Thereisalsoacreditandcollectionsparametersettingcalled“Ignorecreditlimitexpiredrulewhenexpirationdateisblank”ifthisisuncheckedthesystemwillconsiderallblankcreditlimitexpirationdatesasexpiredsobeawareofthat.Tosetupa“Creditlimitexpired”blockingruleclickthe“Creditlimitexpired”tabclickthe“New”button.Selecttheappropriate“Accountcode”basedonifyouwanttoapplytheruletoasinglecustomer,agroupofcustomers(creditmanagementgroup),orallcustomers.Nextsetthe“Ruletype”to“Blocking”andenterthenumberofdaysafterthecreditlimitexpirationthatshouldtriggeracreditmanagementholdonasalesorder.OverdueAmountThe“Overdueamount”blockingruletypeallowsyoutoputasalesorderonholdifthecustomer,groupofcustomers,orallcustomers(basedonaccountcodeselection)ifthecustomerhasanoverdueamountgreaterthanorequaltotheamountspecifiedorifacertainpercentageoftheircreditlimithasbeenreachedorexceededbytheoverduebalance.Tocreatean“Overdueamount”blockingruletypeclickthe“Overdueamount”tabandclickthe“New”buttonandselectwhethertheruleshouldapplytoasinglecustomer(Table),agroupofcustomers(Group),orallcustomers(All).Theninthe“Account/Group”fieldselectthecustomerorcustomergroupdependingontheaccountcodeselection.Inthe“Ruletype”select“Blocking”andinthe“Overdueamount”selecttheoverdueamountthatshouldtriggeracreditmanagementholdonasalesorder.Finally,inthe“Creditlimitthreshold”fieldselectthepercentageofthecreditlimitthatwhenreachedorexceededwilltriggeracreditmanagementholdonthesalesorder.SalesOrderThe“Salesorder”blockingruleisusedtoinitiateacreditmanagementholdonasalesorderthatmeetsorexceedsthesalesorderamountdefinedforanycustomerinthespecifiedcriteria.Theamountappliesonlytoasinglesalesorder.Soevenifyouhavemultipleopensalesordersthatsummedtogetherexceedtheamountitwillnottriggeracreditmanagementrule.The“Releasesalesorder”optionisonlyavailableon“Exclusion”rulestypes.Ifthe“Releasesalesorder”optionisselectedandtheexclusionruleisapplied,thiswillcanceloutanyotherblockingruleholdsthatmayhavebeenapplicableotherwiseanditwillallowthesalesordertobeprocessed.Tocreatea“Salesorder”blockingruleclickthe“Salesorder”tabandclickthe“New”button.Selecttheappropriate“Accountcode”and“Account/Group”fielddependingonwhichcustomerstheruleshouldapplyto.Nextselectthe“Salesorderamount”thatshouldtriggerasalesorderholdifthesalesorderreachesorexceedsthatamount.Youcanalsocreateanexclusionruleifdesiredthatwillexcludecertaincustomersfromthisrule.CreditLimitUsedThe“Creditlimitused”blockingruletypeisusedtoplaceanorderonholdifacustomerwithintheblockingrulecriteriahasmetorexceededagivenpercentageofthatcustomer’screditlimit.Tocreatea“Creditlimitused”blockingruletypeclickthe“Creditlimitused”tabandclickthe“New”button.Selecttheappropriate“Accountcode”and“Account/Group”todefinetheapplicablecustomercriteria.Nextselect“Blockinginthe“Ruletype”fieldandenterthethresholdpercentageofthecustomer’screditlimitthatwilltriggeracreditmanagementhold.BlockingRulesExampleNowthatwehavesetupsomeblockingruleslet’swalkthroughanexampleofhowtheblockingrulesresultincreditmanagementholdsonasalesorderandhowweclearthecreditmanagementholdstocontinueprocessingthesalesorder.InthisexampleIhaveacustomerwitha$1,000overduebalance,a$1,000creditlimit,andanorderfor$1,000.Basedontheblockingruleswehavesetupweshouldexpectacreditmanagementholdforseveralreasons.Oneofourcreditmanagementcheckpointswasonsalesorderconfirmationsolet’spostasalesorderconfirmationandtriggeracreditmanagementhold.NowifIattempttopostaconfirmation,Iwillgetanerrortellingmethattheorderhasbeenplacedintocreditmanagement.Thiswillalsohappenonanyothercreditmanagementcheckpointsthatareselectedinthecreditmanagementparameters.Wecanalsoseethatthereisaflagcalled“Increditmanagement”onthesalesorderheaderthatissetto“Yes”nowthatindicatesthattheorderinoncreditmanagementhold.Youcanaddthisfieldtothesalesorderlistpagegridifneededtoeasilyseeordersthatareoncreditmanagementhold.YoucanseealistofallcreditmanagementholdsbynavigatingtoCreditandcollections>Creditmanagementholdlist>Allcreditholds.Alternatively,youcangettotheholddirectlyfromthesalesorderbyclickingthe“Creditmanagement”tabintheribbonandclickthe“Creditmanagementholdlist”.Nowwecanseethedetailsofthecreditmanagementhold.Inthe“Documentstatuscheck”fieldyoucanseetheactionthattriggeredthecreditmanagementholdbasedontheblockingrule.The“Creditholdreason”fieldtellsyouthereasonforthehold.Iftherearemultiplereasonsyouwillneedtoclickthe“Blockingreasons”buttontoseeallthereasons.Whenthecreditmanagerhasreviewedthecreditmanagementholdandisreadytoreleasethesalesordertobeprocessed,clickthe“Release”button.Next,selectareasoncodefortherelease,anda“Releaseaction”.The“Releaseaction”hastwooptions,“Withposting”and“Withoutposting”.“Withposting”meansthatassoonasyouclickthe“Release”buttonthesystemwillcontinueprocessingtheeventthatoriginallytriggeredthecreditmanagementhold.So,inmycaseitwouldgoaheadandpostthesalesorderconfirmation.“Withoutposting”meansthatsomeonewillhavetogoinandprocesstheeventmanually.Oncethecreditmanagementholdisreleasedyouwillnoticethatthe“Increditmanagement”flagissetto“No”andthesalesordercancontinuetobeprocessed.Keepinmindthatifyouhavenotsetthegracedaysyoumaytriggersomeofthesameholdcodesiftheblockingrulescontinuetobeviolated.TakeawayCreditmanagementblockingrulesconstituteagreatlyimprovedfeaturesetovertheoldercreditmanagementfunctionalityofversionspast.Blockingrulesareeasytosetup,easytoimplement,andveryflexibleintermsofwhentheyareevaluatedduringthesalesorderprocess.IhopethisposthasgivenyoutheinformationrequiredtoutilizeblockingrulesinyourD365FinanceandOperationsimplementation.TimhasbeenanAX/D365FinanceandOperationsConsultantforoveradecadeandlovestoshareinsightsandknowledgefrommultiplefullcycleimplementations.RecentPostslinktoDefaultOrderSettings:D365FinanceandOperationsInDynamics365FinanceandOperations,defaultordersettingsareacorepartoftheproductsetupifyouareusingmasterplanninginanycapacity.Thedefaultordersettingscontrolthingslike...ContinueReadinglinktoCustomerandVendorProposedChangeApprovals:D365FinanceandOperationsInmostorganizationscustomerandvendorsetupisataskhandledbytheAccountingortheSupplyChainteamandinsomecasesbothwitheachresponsibleforspecificsetups.Therearealsovery...ContinueReadingreportthisadAboutWeareDynamicsAX/365FinanceandOperationsconsultantswithyearsofimplementationexperience.WehavehelpedseveralbusinessesimplementandsucceedwithDynamicsAX/365FinanceandOperations.Thegoalofthiswebsiteistoshareinsights,tips,andtrickstohelpendusersandITprofessionals.LegalContentpublishedonthiswebsiteareopinions,insights,tips,andtrickswehavegainedfromyearsofDynamicsconsultingandmaynotrepresenttheopinionsorviewsofanycurrentorpastemployer.AnychangestoanERPsystemshouldbethoroughlytestedbeforeimplementation.SearchSearchfor: reportthisadxx