Understand the new Account Determination for Tax codes in S ...

SAP had a limitation till now wherein we need to setup different tax codes for deriving different General ledger accounts based on the ... SAPBlogs HomeSaps4hanaUnderstandthenewAccountDeterminationforTaxcodesinS/4HanaFinance1709 Saps4hana UnderstandthenewAccountDeterminationforTaxcodesinS/4HanaFinance1709 Byadmin OnJan15,2021 0 Share Abstract WithSAPS/4HanaFinanceversion1709onPremiseeditionLearnthenewconceptofaccountdeterminationintaxcodesanddifferencebetweentheECCandpriorversionofS/4Hanaversions. KeyConcept Themainconceptofdeterminationofdifferentgeneralledgeraccountsforthesametaxcodesindifferentcountriesforsametransactiontypes.   Reducethenumberoftaxcodescreationinthesystem.SinceSAPhaslimitationofwiththenumberof2digittaxcodesthishelpssothatwedon’tsetupdifferenttaxcodesforthesakeofdifferentGLpostings.   DifferentrulescanbesetuptohavesameGLaccountforallthecountriesanddefinetohavedifferentGLaccountforsomecountriesinexception.Thiscan havefurthercriteriabyhavingtaxcodeandcountrycombination     Many times aneedarisesunderSAPGlobalimplementationprojectswhichusesamechartofaccounts acrossallthecompanycodes,butneedtohavedifferentGLaccounttobederivedforthesametaxcode.Wecanhavedifferenttaxpercentagessetupforthesametaxcodes butGLaccountdeterminationislimitedforthesametransactionkey.PleaseseeFigure1forclearunderstanding. SAPhadalimitationtillnowwhereinweneedtosetupdifferenttaxcodesforderivingdifferentGeneralledgeraccounts basedonthetransactionkey.WecanuseonlysetupsametaxcodesindifferentcountriesasalongtheyderivesameGLaccountforthesametransactionkeyrefertoFigure1. ThisnewfeatureinS4Hana1709releaseallowstoderivedifferentGLAccountbasedon thesametaxcodeindifferentcountriesforthesametransactionkey(ForExample’s,MWSInputoutputtaxes)   Before1709versioninECCandS/4Hanaupto1610versionasshowninfollowingcombinationwherewecannothavedifferentGLaccountforsametaxcodeandtransaction Key   LearningObjectives Readingthisarticle,you’lllearn: Understandthenewfeatureofaccountdeterminationfortaxcodesin1709 ConfiguretoassigndifferentGLaccountstosametaxcodesindifferentcompanycodesbelongingtodifferentcountries PostthedocumenttodisplayhowsystemderivesdifferentGLaccountsforthesametaxcodes Theideaofthisarticleisnotgivedetailsaboutthetaxprocedure,assignmentoftaxproceduretocountryandconfigurationoftaxcodes.Justatthehigh-leveltaxcodesaredefinedatthecountrylevelinSAP.Theyhavetheactualrateswhichwillusedforcalculatingthetaxesbasedonthetaxcalculationprocedure.Multipletaxcodescanbedefinedfordifferenttypesoftaxessuchasinput,output,Non-deductibleetc.,Thisisstandardprocessofsettinguptaxes. Thescopeofthisarticleistoexplainthenewfeatureavailablefrom1709SAPS/4HanaonPremise.  FordemonstrationpurposesIhavetwocompanycodesGS01andGS02setupforcountriesGermany(DE)andGreatBritain(GB).TheysharethesamechartofaccountsINTandsameoutputtaxcodesetupA1.   Pleaseseethebelowfigure2whereinwecanhavedifferentGLaccountsforthesametaxcodeandtransactionkeyinS4Hana1709         Inthefollowingstepslet’sseehowwecanachievethisthroughconfigurationandthenIwillproceedtoshowthedocumentpostedtotherespectivetaxcodesfordifferentcompanycodes. Step1. DefineTaxposting  InCustomizingfor FinancialAccounting,choose FinancialAccountingGlobalSettings ® TaxonSales/Purchases ® BasicSettings ® Posting® DefineTaxAccounts TheretwowaysofassigningGLaccountseitherdirectlyinFTXP afterdefiningthetaxcodesorwecanassignGLaccountatthisstepwhichisOB40oncewehavedefinedtaxcodesinFTXP.AsshownaboveclickontheDefinetaxaccountsthisusedtobeOB40transactioncodeinpreviousECCanduntil1610wecouldassignGLaccountshere.Butitisdifferentnowasyoucanseeinfigure4 ithasnowpostingkeys,rulesandaccounts. TheonlydifferencebetweenpreviouslyandcurrentoneisruleswhichiswheredefinebasedonwhatruleweassignGLaccounts.  Step2:DefinePostingKeyforthetransactionkey AsshowninFigure4belowclickonfolderPostingKey.HerewedefinepostingkeysforthetransactionkeysMWS.Iwouldliketokeepthemasstandardhere. Step3:DefineRules HighlightMWStransactionkeyasshownFigure4andthenclickfolderRuleswhichwillbringtoscreenFigure5 SelectnewEntriesandkeyinthechartofaccountINTandcheckTaxcodeandCountryandclicksave HerewedefinewhatruleweneedtofollowforthetransactionkeysMWS. Three optionsare available foreachChartofaccountsandtransactionkeycombinationoneisTaxcodeandotherisCountry. Option1:Nocheck Option2:OnlyCountryisselected Option3: IftaxcodeandCountry   Pleasenoteperchartofaccount andtransactionkeywehavetochoseoneoption.PleaseseethebelowchartFigure6forthecombinationoftheentriesmaintained.   BasedontheFigure6abovethefollowingarethedetailedexplanation Option1:only1EntryismaintainedandforalltaxcodesinChartofaccountsABCfortransactionkeyMWStheGLaccountwillbesame.(Thisoptionwasalsoavailableinthepreviousversionalso) Option2:Twoentriesaremaintainedbutthecountrykeyisoptionalhere.Entry1foralltaxcodesinChartofaccountsCAFRfortransactionkeyMWStheGLaccountis445621exceptforcountryNLwhichwillbe445620.MeansthisoptionalsosupportssametaxcodeswithtransactionkeyMWScanhavedifferentGLaccountsbasedoncountry. Option3:Moregranularlevel heretaxcodeentryismandatoryandcountrykeyisoptional. TwoentriesaremaintainedEntry1fortaxcode A1inallcountriesinChartofaccountsINTfortransactionkeyMWStheGLaccountwillbe175000exceptforcountryGBcountrythetaxcodeA1willbe175001. Pleasenote:InalltheaboveoptionsGLaccountentryismandatory. Option3willbedemonstratedasapartofthisarticle Step4:AssignGLaccounts  HighlightchartofaccountINTasshownFigure5andthenclickfolderAccountswhichwillbringtoscreenFigure7  Selectnewentries KeyintaxcodeA1andGLaccount175000 SecondentryA1fortaxcode,countryGBandGLaccount175001asshowninFigure7 Clicksave   Step5:Verifytaxcodes  UsingTransactioncodeFTXPtoverifythetax codesA1incountriesDEandGBhavedifferentGLaccountsasshowninFigure8 (DEcountry)andFigure9  (GBcountry)     Step6:Verifytransactionpostings   IhavesimulatedthetwocustomerinvoicedocumentsincompanyGS01andGS02todisplaythepostings AswecanseeinFigure10simulation incompanycodeGS01incountryDEwithtaxcodeA1postingtoGLaccount175000. In Figure11simulation incompanycodeGS02incountryGBwithtaxcodeA1postingtoGLaccount175001. Thuswecanseehoweasytheconfigurationisfor assigningGLaccountsbasedonthevariousoptionsgivenbySAP.ThisisoneofthebestfeaturewhichwasduelongtimefromSAPforderivingdifferentGLaccountsforthesametaxcode. Letmeknowhowusefulisthisarticleandalsoabout thisnewfeaturealsowhichSAPS/4Hana1709hasprovided. Thanks SrinathGogineni Previouslypublishedarticlesbyme. https://www.linkedin.com/pulse/whats-new-sap-s4-hana-finance-addition-speed-srinath-gogineni-pmp/ https://sapexperts.wispubs.com/Financials/Articles/Accelerate-Your-Financial-Closing-with-New-Line-Item-Transaction-Codes-in-SAP-S-4HANA-Finance?id=49C89FF768CE4570ACC5CD76A282F6A4#.WiwYwkqnE2w https://sapexperts.wispubs.com/Financials/Articles/How-to-Use-the-Extension-Ledger-Functionality-in-SAP-S-4HANA-Finance?id=#.WiwY0UqnE2w   NewNetWeaverInformationatSAP.com VeryHelpfull UserRating:Bethefirstone! 0 Share FacebookTwitterGoogle+ReddItWhatsAppPinterestEmail admin 3597posts 0comments PrevPost SAPChangeManagementandSAPChangeControl:What’stheDifference?PartIII NextPost UsingSAPBusinessObjectsPredictiveAnalyticswithSAPHANA,expressedition Youmightalsolike Morefromauthor Saps4hana SimplificationItemCatalog,SimplificationItemCheckandSAPReadinessCheckfor… Saps4hana S/4HANA1511OnPremiseEdition–notassimplifiedaspromissed?(comparingthe… Saps4hana SAPS/4HANA,on-premiseedition1610:FeaturePackStack1(FPS01) Saps4hana Pre-checksinSystemConversion Prev Next LeaveAReplyCancelReplyYouremailaddresswillnotbepublished. Savemyname,email,andwebsiteinthisbrowserforthenexttimeIcomment. RecentPosts SecureYourGoldenYears:KnowtheBenefitsofInvestinginSeniorCitizenSavingScheme BoostYourCareerWith,BankingAndFinanceCertificateCourses HowtoPutTogetheranEffectivePulseSurvey BestFeaturesofBoardPortalsThatYouCan’tAffordtoMiss! WhatisDataRoomDueDiligence?  Category Signin Welcome,Logintoyouraccount. Forgetpassword? Rememberme Signin Recoveryourpassword. Apasswordwillbee-mailedtoyou.