Transactions - Dynamics GP | Microsoft Docs

Microsoft Dynamics GP Analytical Accounting Part 2: Transactions ... The Transaction Dimension Description field displays the description of ... Skiptomaincontent Thisbrowserisnolongersupported. UpgradetoMicrosoftEdgetotakeadvantageofthelatestfeatures,securityupdates,andtechnicalsupport. DownloadMicrosoftEdge Moreinfo Tableofcontents Exitfocusmode ReadinEnglish Save Tableofcontents ReadinEnglish Save Feedback Edit Twitter LinkedIn Facebook Email Tableofcontents MicrosoftDynamicsGPAnalyticalAccountingPart2:Transactions Article 04/01/2022 168minutestoread 4contributors Isthispagehelpful? Yes No Anyadditionalfeedback? FeedbackwillbesenttoMicrosoft:Bypressingthesubmitbutton,yourfeedbackwillbeusedtoimproveMicrosoftproductsandservices.Privacypolicy. Submit Thankyou. Inthisarticle Thispartofthedocumentationcontainsinformationaboutenteringanalysis informationfortransactionsinMicrosoftDynamicsGP.Thisinformation includesthefollowingtopics: Chapter4,“GeneralLedgerTransactions”describeshowtoenteranalysis informationforGeneralLedgertransactions.Italsoexplainshowyoucan adjustanalysisinformationforpostedjournalentries. Chapter5,“PayablesManagementTransactions”explainshowtoenter analysisinformationforPayablesManagementtransactions. Chapter6,“PurchaseOrderProcessingTransactions”explainshowtoenter analysisinformationforPurchaseOrderProcessingtransactions. Chapter7,“ReceivablesManagementTransactions”describeshowtoenter analysisinformationforReceivablesManagementtransactions. Chapter8,“SalesOrderProcessingTransactions”explainshowtoenter analysisinformationfortransactionsinSalesOrderProcessing. Chapter9,“InventoryTransactions”explainshowtoenteranalysis informationforInventorytransactions. Chapter10,“FixedAssetTransaction”explainshowtoenteranalysis informationforFixedAssetTransactions *Chapter11,“BankReconciliationTransactions”*explainshowtoenter analysisinformationforBankReconciliationtransactions. *Chapter12,“CashbookBankManagementTransactions”*describeshowtoenter analysisinformationforCashbookBankManagementtransactions. *Chapter13,“ElectronicBankManagement.”*describeshowtoenteranalysis informationforElectronicBankManagementtransactions. *Chapter14,“DirectDebitsAndRefundsTransactions”*describestheanalysis informationthatiscreatedforDirectDebitsandRefundstransactions. Chapter15,“AnalysisinformationforU.S.Payrolltransactions”describes theanalysisinformationthatiscreatedforU.S.Payrolltransactions. Chapter4:GeneralLedgerTransactions ThevariousproceduresinvolvedinenteringanalysisinformationforGeneral Ledgertransactionsareexplainedhere.Youcanenteranalysisinformation fordistributionaccountsthatarelinkedtoanaccountclass.Youcanalso adjustanalysisinformationforpostedjournalentries.Also,youcanview theanalysisinformationforaselectedaccountorjournalentry. ThereportsgeneratedusingtheDistributionandMultilevelqueriesdisplay analysisinformationenteredinGeneralLedger. YoucanopentheAnalyticalTransactionEntrywindowonlyifAnalytical Accountinghasbeenactivated.RefertoActivatingAnalyticalAccounting formoreinformation. Thisinformationisdividedintothefollowingsections: EnteringanalysisinformationforGeneralLedgertransactions Validatingtransactionsandcorrectingerrors EnteringanalysisinformationforQuickJournals EnteringanalysisinformationforMiscellaneousChecks Analysisinformationinbatches Voidinganunpostedtransaction Backingoutapostedtransaction Backingoutandcorrectingapostedtransaction Copyingapostedtransaction VoidingaQuickJournalentry Analysisinformationforwriteoffs Seriespostingandmasterposting Adjustinganalysisinformationinpostedtransactions Validatingadjustmentsandcorrectingerrors Viewingdetailjournalentrieswithanalysisinformation Viewingjournalentrieswithanalysisinformation AnalyticalAccountingchecklinks CopyingAnalyticalAccountingInformationforGeneralJournal EnteringanalysisinformationforGeneralLedgertransactions Usethefollowinginformationtoenteranalysisinformationfordistribution accountsthatarelinkedtoanaccountclass.Youcansavetransactions individuallyorinabatchwithorwithoutanalysisinformation. TheAnalyticalGeneralTransactionEntrywindowopensautomaticallywhenyou pressTABfromafieldintheTransactionEntrywindow(Transactions>> Financial>>General)inthefollowinginstances: Ifanaccountislinkedtoanaccountclassandnoanalysisinformationhas beenenteredfortheaccountearlier. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation enteredpreviouslyfortheline.Theseincludechangingtheaccount,amount ordebittocreditorviceversa,asthiswilldeletethepreviouslyentered analysisinformationandcreateasingleassignmentof100percent. IftheoptionCalculateTaxesinGeneralLedgerismarkedintheCompany SetupOptionswindow(Administration>>Setup>>Company>>Company >>Options),youmayneedtoenteranalysisinformationfordistribution accountsthatarecreatedfromtheTaxEntrywindow.Ifanyofthenew distributionaccountsarelinkedtoanaccountclass,afterthetax transactionsarecreatedfromtheTaxEntrywindow,theAnalyticalGeneral TransactionEntrywillopenautomaticallyfromthegeneralTransactionEntry window.IftheAnalyticalGeneralTransactionEntrywindowhasbeenopened earlierforthedistributionaccounts,itdisplaysthefirstofthenew distributionaccountsthatarelinkedtoanaccountclass(asperthe distributionsequence).Ifnot,thefirstofthepreviousdistribution accountslinkedtoanaccountclasswillbedisplayed. IfyoudeleteatransactionintheGeneralLedgerTransactionEntrywindow, anyanalysisinformationenteredforthetransactionisalsodeleted. Formulticurrencytransactions,achangeinthetransactiondatere-creates distributionamountsduetoachangeintheexchangerate.Ifthe transactiondateismodified,analysisinformationcreatedpreviouslyis deletedwhenthedistributionamountsarere-created. ToenteranalysisinformationforGeneralLedgertransactions: OpentheAnalyticalGeneralTransactionEntrywindow. (Transactions>>Financial>>General>>Enteraccount/amount>> ChoosetheAnalyticalAccountingbutton) (Transactions>>Financial>>General>>Enteraccount/amount>> Additional>>AnalyticalTransactionorCTRL+T) TheAnalyticalGeneralTransactionEntrywindowdisplaysthedistribution accountselectedintheGeneralTransactionEntrywindow.Toviewtheother distributionsforthetransaction,enterorselectadistributionnumber. ThesequenceofdistributionsintheAnalyticalGeneralTransactionEntrywindowmaynotcorrespondtothesequenceintheGeneralTransactionEntrywindowbecauseonlyaccountslinkedtoanaccountclassaredisplayedintheAnalyticalGeneralTransactionEntrywindow. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamountintheoriginatingorfunctionalcurrencybasedontheoptionselectedinthecurrencyview. Note Youcanchoosetheexpansionbuttontoviewmulticurrencyinformationiftheoriginatingcurrencydiffersfromthefunctionalcurrency.Thecurrencyiconisnotdisplayedifthedisplayeddistributionaccountisaunitaccount. TheCompanyIDfielddisplaystheIDforthecurrentcompany. TheAccountfielddisplaystheaccountrelatedtothedistribution.TheexpansionbuttonwillopentheMicrosoftDynamicsGPAccountEntrywindow.Thebalancetype,whetherdebitorcredit,isalsodisplayed. TheAssignedfielddisplaysthetotaldistributionamountinvalueandpercentagethathasbeenassigned. TheUnassignedfielddisplaystheremainingdistributionamountthatistobeassignedinvalueandpercentage. Intheassignmentlistview,anarrowbeforetheNumberfieldindicatesthattheanalysisinformationdisplayedisfortheselectedassignment.Eachassignmentcreatedforthedistributionisdisplayedseparately. Inthelistwindow,enterthetransactiondistributionamountinfunctionalororiginatingcurrency,byvalueoronapercentagebasis. TheNumberfielddisplaysthenumberoftheassignment. TheOriginatingorFunctionalAmountfieldintheassignmentlistview,displaystheassignmentintheoriginatingorthefunctionalcurrencybasedontheoptionyouselectedintheCurrencyView.EntertheamounttoassignintheOriginating/FunctionalAmountfield.Assignmentscanbeenteredinthefunctionalororiginatingcurrency. Note Youcanentertheassignmenteitherinvalueorpercentageterms. EntertheassignmentinpercentagevalueintheAssign%field.Initially,a singleassignmentiscreatedbydefault.Youcanoverwritetheassignment withmorethanoneassignment. Youcansaveanalysisinformationforadistributioneveniftheassignmentisnot100%.However,youcanpostatransactionwithpartialassignmentsonlyifyouhaveoptedtoallowpartialassignmentsduringpostingforthemoduleyou’reworkingin.RefertoSettingupassignmentoptionsformoreinformation. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes ifrequired.RefertoCreatinganaliasformoreinformation. EnterreferenceinformationfortheassignmentintheReferencefield. ChooseDeleteRowtodeleteasinglerowintheassignmentListView.You cannotchoosethisoptionifonlyasingleassignmenthasbeenentered. ChooseRemainingtoaddoneassignmentfortheremainingunassignedamount. Thenewassignmentwillensurethatthetotalassignedamountequalsthe distributionamount.Forexample,thedistributionamountis$100and you’veenteredfourassignmentsthattotal$75.WhenyouchooseRemaining, afifthassignmentfortheremainingvalue,$25iscreated.Thisbuttonis notavailableifthedistributionfieldisblankorhasazerovalue. ChooseDefaulttoloadthecurrentsetupinformationspecifiedforthe accountclassintheAccountingClassMaintenancewindowandcreateasingle assignment.Thefollowingprocesseswilloccur: Fixed,Required,andOptionalTransactionDimensions(includinghidden transactiondimensions)willbeinstalled. Alltheassignmentsthatyouhavecreatedforthecurrentdistribution willberemovedandcreateasingleassignmentthatisequaltothe distributionamountwillbecreated. IftheanalysistypeischangedtoorfromNotAllowed,transaction dimensionswillbeaddedorremoved. Transactiondimensionsthathavebeendeletedwillberemoved. TheTrxDimensionfielddisplaystransactiondimensionsfortheaccount classthatthedistributionaccountislinkedto.Onlytransaction dimensionsthathavebeensetasRequired,Fixed,orOptionalaredisplayed. TheTransactionDimensionDescriptionfielddisplaysthedescriptionofthe TransactionDimensionthatyou’veenteredintheTransactionDimension Maintenancewindow. EnterorselectthecodeforeachAlphanumerictransactiondimensioninthe Alphanumericcolumn.Ifyou’vemarkedtheShowvalidcodecombinationsin trnsandbudgetsoptionintheAnalyticalAccountingOptionswindow,then thelookupwindowwilldisplayonlythosecodesthathaveavalid combinationwiththecodesyouhavealreadyselectedforthetransaction. Note Securityaccesstouseatransactiondimensioncodeisgrantedautomaticallytotheuserwhocreatedthecodeduringtransactionentry. EnteratransactiondimensioncodeintheNumeric,Yes/NoorDatefieldfor aNumeric,BooleanorDatetypeTransactionDimension. ChooseOKtosaveyourchangesandclosethewindow.Theanalysis informationthatyouhaveenteredisvalidatedwhenyouchooseOK.Referto Validatingtransactionsandcorrectingerrorsformoreinformation. ChooseSavetosavetheanalysisinformationyouhaveenteredandclearthe window.AvalidationtakesplacewhenyouchooseSaveintheAnalytical GeneralTransactionEntrywindow.RefertoValidatingtransactionsand correctingerrorsformoreinformation.Youcansavetheanalysis informationwitherrorsorwithoutupdatingchangesmadetotheaccount class. ChooseCleartocleartheinformationfromtheAnalyticalGeneral TransactionEntrywindow. ChooseValidatetovalidatetheanalysisinformationofthedistribution displayedinthewindow.Ifchangesaremadetotheaccountclassinthe AnalyticalAccountingsetuporerrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogwindowwillopenwhereyou canviewtheerrorsorchanges.RefertoValidatingtransactionsandcorrectingerrorsformoreinformationaboutvalidation. ChoosePrinttoprinttheerrorreport.ChooseOKtoclosethewindowandreturntotheAnalyticalGeneralTransactionEntrywindow. ToviewthechangestotheaccountclasschoosetheDefaultbuttoninthe AnalyticalGeneralTransactionEntrywindow.DoubleclickonanAnalytical AccountingerrortoopentheAnalyticalAccountingGeneralTransactionEntry windowwherethespecificerrorwillbehighlighted ChoosetheprintericonbuttontoprinttheAnalyticalAccountingeditlist forthecurrentdistributiondisplayedorforalldistributionsofthe transactionlinkedtoanaccountclass.TheAnalyticalAccountingValidation LogreportwhichdescribestheAnalyticalAccountingerrorsalsoisprinted. Ifyoupostareversingtransactionorreverseanexistingtransaction,the analysisinformationiscopiedfromthetransactiontothereversed transactionwiththechangeinbalancetype,whetherdebitorcredit. IfyouvoidatransactionthathasbeenpostedtoGeneralLedger,a reversingtransactioniscreatedalongwithanyanalysisinformation assignedtotheoriginaltransaction. OnpostingClearingJournals,analysisinformationthathasbeenenteredfor thetransactionswillnotbeposted.Also,novalidationwilltakeplacefor thedistributionaccounts,eveniftheaccountsarelinkedtoanaccount class.Topostanalysisinformation,usethegeneralTransactionEntry window(Transactions>>Financial>>General). Validatingtransactionsandcorrectingerrors Youcanvalidateatransactiondocumentbyselectingthetransactioninthe relevant AnalyticalAccountingTransactionEntrywindowandchoosingAdditional>> RunValidationorbypressingCTRL+R.Youcanvalidateatransaction distributionbychoosingOK,SaveorValidate,onlyifithasanamount. Thevalidationprocessverifiesthefollowinginformation: Theassignmentsthatyou’vecreatedconformtotheassignmentoptionsyou havesetupforthemodule. Codesarespecifiedforalltransactiondimensionsthathavearequired status. Thecodecombinationsarevalid. AllthealphanumericcodeshaveaccesstotherelevantuserIDand distributionaccount. Thataccountsassociatedwiththetransactionarestilllinkedtoanaccount class. Thetransactiondimensionsandcodeshavenotbeendeletedfromthesetup. ThemulticurrencyinformationforAnalyticalAccountingandMicrosoft DynamicsGPisthesame. Thereisadistributionrecordandatleastoneassignmentrecordforall theMicrosoftDynamicsGPdistributions. Alldistributions,assignmentsandcodeslinktoexistingMicrosoftDynamics GPdistribution. Changesthatweremadetotheanalysistypeofthetransactiondimensionare invalid. Thevalidationroutinetakesplaceinthefollowingstages: StageoneAtthefirststage,changesinsetupareverified.Ifany changeshavebeenmade,thenyoumustclicktheDefaultbuttoninthe AnalyticalTransactionEntrywindowtoupdatethewindowwithchanges. StagetwoAtthesecondstage,thevalidationroutinecheckswhether codecombinationsarevalidandselectedcodesexistandhavetherequired accesstouserIDandaccount;ifcodeshavebeenenteredforrequired transactiondimensionsandifassignmentsequalthetransactiondistribution amount.Thispartofvalidationtakesplaceonlyafterallerrorsthatare indicatedatthefirststagehavebeencorrected. Whenyoupostageneraltransaction,avalidationtakesplacefortheentire document.Thedocumentispostedifnoerrorsarefoundinthetransaction. Iferrorsarefoundwhilepostingageneralentrytransaction,the transactionwillnotbeposted.TheAnalyticalAccountingValidationLog windowwillopen.TheMicrosoftDynamicsGPerrorswillbelistedfirstin thewindowandthentheAnalyticalAccountingerrors. WerecommendthatyouresolvetheMicrosoftDynamicsGPerrorsbeforeyou correcttheAnalyticalAccountingerrors. TocorrectanAnalyticalAccountingerror,double-clickontherelevant errortoopentheAnalyticalGeneralTransactionEntrywindow.Thespecific distributionwheretheerrorexistsisdisplayed. EnteringanalysisinformationforQuickJournals Usethefollowinginformationtoenteranalysisinformationfordistribution accountsintheAnalyticalQuickJournalEntrywindow.TheAnalyticalQuick JournalwindowissimilartotheAnalyticalGeneralTransactionEntry window.RefertoEnteringanalysisinformationforGeneralLedger transactionsformoreinformation. ToenteranalysisinformationforQuickJournals OpentheAnalyticalQuickJournalEntrywindow. (Transactions>>Financial>>QuickJournal>>ChoosetheAnalytical Accountingbutton) (Transactions>>Financial>>QuickJournal>>Additional>> AnalyticalTransactionorCTRL+T) TheAnalyticalQuickJournalEntrywindowwillopenonlyifyouhaveenteredanaccountandamountinthescrollingwindowoftheQuickJournalEntrywindow. TheAnalyticalQuickJournalEntrywindowdisplaysthefirstaccountlinkedtoaclassIDintheaccountsscrollingwindow. Enterorselectadistributionnumber.IfyouclickOffsettoopenthe AnalyticalTransactionEntrywindowandlookup,onlyonedistributionis displayed.Ifthewindowandlookupwindowareopenedfromthemain distributionaccount,thenonlythemaindistributionaccountsare displayed. ChooseBrowsetoviewtheremainingdistributions.Ifyoubrowsewhenthe mainaccountisdisplayed,youcannotviewthecontrolaccountdistribution. Similarly,ifyouchoosetobrowsewhenthecontrolaccountisdisplayed, youcannotviewthemainaccountdistribution. Thetotalnumberofdistributions,includingallaccountsofthedocumentlinkedtoanaccountclassisdisplayedintheDistributionoffield. EnterthepercentagetoassignintheAssign%field.Youcanviewthetotal oftheassignmentsinpercentage.Assignmentcanbegiveninamountor percentage. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes ifrequired.RefertoCreatinganaliasformoreinformation. EnterareferencefortheassignmentintheReferencefield. ChooseRemainingtoaddoneassignmentfortheunassignedbalanceamount. Youcanassignanamountinanewassignmentlineandyoucanmodifythe assignmentline. ChooseDefaulttoremovealltheassignmentsforagivendistributionline andtocreateanewassignmentamountof100%.RefertoEnteringanalysis informationforGeneralLedgertransactionsformoreinformationaboutthe Defaultbutton. TheTrxDimensionfieldwilldisplaytransactiondimensionsfortheaccount classtowhichthedistributionaccountislinked.Transactiondimensions thathavebeensetasRequired,Fixed,orOptionalwillbedisplayed. ThedefaulttransactiondimensionsaredisplayedintheTrxDimensionCodefield. Enterthetransactiondimensioncodeforanalphanumerictransaction dimensionintheAlphanumericfield.Youcanclickthealphanumericlinkto opentheTransactionDimensionCodewindowtoviewinformationaboutan existingcode.TheAlphanumericcolumnisavailableonlyforanalphanumeric transactiondimension Securityaccesstouseatransactiondimensioncodeisgrantedautomaticallytotheuserwhocreatedthecodeduringtransactionentry. EnteratransactiondimensioncodeintheNumeric,Yes/NoorDatefieldforaNumeric,BooleanorDatetypeTransactionDimension. ChoosetheShowbuttontoviewthedescriptionofthetransactiondimensions intheTrxDimensionfield.Youcanviewthedescriptionofatransaction dimensioncodeintheTrxDimensionCodeDescriptionfield. WhenyouopentheAnalyticalQuickJournalEntrywindowfromany distributionline,youcanusetheOffsetAcct.buttontoassignan AnalyticalAccountingassignmenttoanoffsetaccount.TheOffsetAcct. buttonisnotavailableifthecontroltotaliszero.Controltotalisthe nettotalofdebitsandcredits. WhenyouclickOffsetAcct.,theMainbuttonbecomesavailable.Youcan switchbetweenthemainandoffsetaccountsandenterAnalyticalAccounting assignmentbyclickingthisbutton. Iftheoffsetaccountislinkedtoanaccountclass,andthecontroltotal isnotentered,thecontroltotalamountiscalculatedwhenyouchoosePost orSaveandtheAnalyticalTransactionEntrywindowopens. ChoosetheprintericonbuttonintheQuickJournalEntrywindowtoprint theQuickJournalEntryeditlistandtheAnalyticalAccountingeditlist.A validationtakesplacefortheentiredocumentbeforetheAnalytical Accountingassignmentinthedistributionaccountsisprinted.Assignments witherrorsaswellastheoneswithouterrorswillbeprinted. ChooseOKtosavethechangesandtoclosethewindow.ChooseContinueto closethewindoworNotokeepthewindowopen. ChooseCleartocleartheentriesyou’vemadeinthewindow. Whenyoupostaquickjournal,avalidationtakesplacefortheentire document.ThedocumentwouldbepostedifnoerrorsoccurintheMicrosoft DynamicsGPtransactionandintheAnalyticalAccountingassignments.You canprinttheQuickPostingJournalandtheAnalyticalAccountingposting journalreportsifyouclosetheQuickJournalEntrywindowafterposting. RefertoValidatingtransactionsandcorrectingerrorsformore information. EnteringanalysisinformationforMiscellaneousChecks UsetheAnalyticalMiscellaneousCheckEntrywindowtoenteranalysis informationforthedistributionaccountsusedinmiscellaneouschecks.You cancreateassignments,entertransactiondimensioncodesandreferencesfor accountsthatarelinkedtoanaccountclass.TheAnalyticalMiscellaneous CheckEntrywindowdoesnotsupportmulticurrencysincemiscellaneouschecks donotsupportmulticurrency. TheAnalyticalMiscellaneousCheckEntrywindowopensautomaticallywhenyou pressTABintheMiscellaneousChecks(Transactions>>Financial>> MiscellaneousChecks)windowinthefollowinginstances: Ifanaccountislinkedtoanaccountclassandnoanalysisinformationhas beenenteredfortheaccountearlier. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation suchasaccountoramountortypeofamountcreatedpreviouslyforsuch line. Theanalysisinformationisdeletedifthedistributionlineisdeleted,and youdonotpostthedocument.Theanalysisinformationyou’veenteredis validatedbeforeyoupostthetransaction.RefertoValidatingtransactions andcorrectingerrorsformoreinformation. Note Theanalyticalinformationformiscellaneouscheckscannotbevoidedsince youcannotvoidmiscellaneouschecks. ToenteranalysisinformationforMiscellaneousChecks: OpentheAnalyticalMiscellaneousCheckEntrywindow. (Transactions>>Financial>>MiscellaneousCheck>>CTRL+Tor Additional>>AnalyticalTransaction) RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformation. IMAGE–AAMC.jpg AscreenshotofacomputerDescriptionautomaticallygenerated Youcanalsoedittheanalysisinformationyou’veenteredintheAnalytical MiscellaneousCheckEntrywindowbeforeyoupostthetransaction. Analysisinformationinbatches Thefollowingsectiondealswithinformationspecifictobatches.Toenter analysisinformationforindividualtransactions,refertoEntering analysisinformationforGeneralLedgertransactions. ToprinttheAnalyticalAccountingEditListandAnalyticalAccountingerror listalongwiththeMicrosoftDynamicsGPeditlistforaselectedbatch, choosetheprintericonbuttonintheAnalyticalTransactionEntrywindow. YoucancorrecttheAnalyticalAccountingerrorsbyselectingthebatchand thencorrectingeachofthetransactionsthathaveerrors. WhenyoupostabatchfromtheBatchEntrywindow(Transactions>> Financial>>Batches),avalidationwilltakeplaceforallthe transactionssavedinthebatch.MicrosoftDynamicsGPandAnalytical AccountingtransactionswithouterrorswillbepostedandtheAnalytical AccountingGeneralPostingreportwillbeprintedalongwiththeMicrosoft DynamicsGPreports.Iferrorsarefoundduringthevalidationprocess,an errorlistreportisprintedlistinganalysiserrorsforthetransaction distributionsinthebatchbeingposted.Youcancorrecttheerrorsby modifyingthetransactionsinthewindowwherethetransactionoriginated from. Ifyoudeleteasingleorrecurringusebatchoratransactionwithinsuch batches,theanalysisinformationenteredforthetransactiondistributions inthebatchorforthetransactionalsowillbedeleted. YoucansaveatransactioninabatchwithAnalyticalAccountingerrorsbut cannotpostthetransaction. Forarecurringbatch,theanalysisinformationofthebatchlastposted willberetainedandwillupdateeachsubsequentbatchthatisposted, unlesschangesaremadetotheanalysisinformationinthebatch. Analysisinformationthatoriginatedinthesubsidiarymodulescanbeviewed intheGeneralLedger.Suchinformationcanbemodifiedpriortoupdating GeneralLedger. Voidinganunpostedtransaction YoucanvoidatransactionsavedinGeneralLedgerusingtheTransaction Entrywindow.Youalsocanvoidtransactionsthatoriginatedinother modulesinthiswindow,ifyou’vemarkedtheVoid/CorrectingofSubsidiary TransactionsoptionintheGeneralLedgerSetupwindow(Administration>> Setup>>Financial>>GeneralLedger).Theanalysisinformationforthe transactionvoidedintheGeneralLedgerwillnotbeupdatedinthe subsidiarymodule. Whenyouvoidatransactionwithanalysisinformationandclosethe TransactionEntrywindow,theAnalyticalAccountingPostingJournalwillbe printedalongwiththeMicrosoftDynamicsGPPostingJournal.TheAnalytical AccountingPostingJournalwillonlydisplaythejournalnumberandthe accountforthetransaction.Whenyouvoidatransactioninabatch,the analysisinformationforthevoidedtransactionwillbedeleted. Backingoutapostedtransaction YoucanbackoutatransactionpostedinGeneralLedgerusingtheGeneral LedgerTransactionEntrywindow.Youalsocanbackoutapostedtransaction thatoriginatedinasubsidiarymoduleusingtheTransactionEntrywindow, ifyou’vemarkedtheVoid/CorrectingofSubsidiaryTransactionsoptionin theGeneralLedgerSetupwindow(Administration>>Setup>>Financial >>GeneralLedger). Whenyoubackoutapostedtransactionwithanalysisinformation,the transactiondimensioncodesinthepostedtransactionwillbecopiedfrom thebackedouttransactiontothenewtransactionthatiscreated.You cannotopentheAnalyticalGeneralTransactionEntrywindowforthebacked outtransaction.Theanalysisinformationwillnotbevalidatedwhenyou postthebackedouttransaction. Backingoutandcorrectingapostedtransaction YoucanbackoutandcorrectatransactionpostedinGeneralLedgerusing theGeneralLedgerTransactionEntrywindow.Youcanalsobackoutand correctapostedtransactionthatoriginatedinasubsidiarymoduleinthis window,ifyou’vemarkedtheVoid/CorrectingofSubsidiaryTransactions optionintheGeneralLedgerSetupwindow(Administration>>Setup>> Financial>>GeneralLedger). Whenyoubackoutandcorrectapostedtransactionwithanalysis information,thetransactiondimensioncodesinthepostedtransactionwill becopiedtothereversingtransactionthatiscreated.Youcannotopenthe AnalyticalGeneralTransactionEntrywindowforthebackedouttransaction. Theanalysisinformationwillnotbevalidatedwhenyoupostthebackedout transaction. Also,anewcorrectingtransactioniscreatedusingthedebitsandcredits oftheoriginaltransaction.However,theanalysisinformationwillnotbe copiedtothecorrectingtransaction,whichwillbetreatedasanew transaction.Youneedtoenteranalysisinformationforthenewtransaction inGeneralLedger.RefertoEnteringanalysisinformationforGeneral Ledgertransactionsformoreinformation. Copyingapostedtransaction Whenyoucopyasavedorpostedtransaction,theanalysisinformationfor thesourcetransactionwillnotbecopiedtothenewtransaction.Youneed toenteranalysisinformationforthenewtransactionintheGeneralLedger. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformation. VoidingaQuickJournalentry YoucanvoidasavedQuickJournalentryusingtheQuickJournalEntry window. WhenyouvoidatransactionwithanalysisinformationandclosetheQuick JournalEntrywindow,theAnalyticalAccountingPostingJournalwillbe printedalongwiththeMicrosoftDynamicsGPPostingJournal.TheAnalytical AccountingPostingJournalwilldisplayonlythejournalnumberandthe accountforthetransaction.Whenyouvoidatransactioninabatch,the analysisinformationforthevoidedtransactionwillbedeleted. Analysisinformationforwriteoffs Whenyouprocesswriteoffsforunderpaymentsoroverpayments,theAnalytical Accountingvalidationprocesswilltakeplace.Ifthedistributionaccounts forthewriteoffsarelinkedtoanaccountclassID,thedefaultanalysis codesfortheaccountclasswillbeloadedforthedistributionaccounts. TheAnalyticalAccountingvalidationwillnotrunifthedistributionsare linkedtoanaccountclassID,butthedefaultcodesfortheaccountclass IDtowhichthedistributionsarelinkedarenotspecified. TheAnalyticalTransactionEntrywindowwillnotopenwhenyouprocess writeoffsfromtheWriteOffDocumentswindow.Asingleassignmentof100 percentwillbecreatedforeverydistributionaccountthatislinkedtoan accountclass. Whenyouprocesswriteoffs,theAnalyticalAccountingPostingJournalis printed,alongwiththeMicrosoftDynamicsGPPostingJournal,ifyouhave markedtheoptiontoprintthereportinthePostingSetupwindow (Administration>>Setup>>Posting>>Posting). IfyouhavemarkedthePostThroughGLoptionforReceivablesApplyDocsin the PostingSetupwindow,theAnalyticalAccountingvalidationtakesplaceand the AnalyticalAccountingPostingJournalisprintedalongwiththeMicrosoft DynamicsGPPostingJournalwhenyouprocessawriteoff.Ifthedefault codesforthedistributionaccountslinkedtoanaccountclassarenot entered,theAnalyticalValidationlogwillbeprinteddisplayingthe errors,andthetransactionwillnotbepostedtotheGeneralLedger. Seriespostingandmasterposting WhenyouselectmultiplebatchestopostfromtheSeriesPostingorMaster Postingwindow,batcheswithanalysisinformationarevalidated.Iferrors arefoundinthebatch,thestatusofthebatchautomaticallychangesto available. WhenyouchoosetheMarkAllbutton,onlyGeneralLedgerbatcheswithout AnalyticalAccountingerrorsareselected.YoucanprinttheAnalytical ErrorLogtoviewandcorrecttheAnalyticalAccountingerrorsintheother GeneralLedgerbatches,beforeyoucanselectthemforposting. TheAnalyticalAccountingPostingJournalisprintedforalltransactions thathavebeensuccessfullypostedineachbatch. Adjustinganalysisinformationinpostedtransactions Youcanenteroreditanalysisinformationforalljournalentriesposted fromGeneralLedger,irrespectiveoftheiroriginatingmodule. InthecaseofBalanceBroughtforwardjournalentries,youcanenterthe analysisvaluesonlyfortransactiondimensionsotherthanalphanumeric.The analysisdataforalphanumerictransactiondimensionsisconsolidatedand broughtforwardwhenyouperformtheyear-endclose.RefertoYear-endclose forAnalyticalAccountingformoreinformation. Youcanalsochangethenumberofassignmentsandthevalueofeach assignmentforentriesthathaveexistinganalysisinformation.Thus,any analysisinformationthatyouhaveenteredforapostedtransactionina module,say,ReceivablesManagementorPayablesManagement,canbeadjusted afteryou’vepostedthetransactionfromGeneralLedger.Youcanaddor removetransactiondimensions,andalsochangethetransactiondimension codesforthosedimensionsthathavetheAllowAdjustmentsoptionmarkedon theTransactionDimensionMaintenancewindow.RefertoDefiningtransaction dimensionsformoreinformation. Youcanmodifytheanalysisinformationforajournalentryasoftenas required.Onceyoupostanadjustment,theanalysisinformationthatyou’ve enteredwilloverridethepreviousanalysisinformation. Note Analyticalinformationcanbeadjustedonlyforthosedistributionaccounts ofajournalentrythatarelinkedtoanaccountingclassatthetimeof adjustment. Toadjustanalysisinformationinpostedtransactions: OpentheAnalyticalAdjustmentEntrywindow. (Transactions>>Financial>>AnalyticalAccounting>>EditAnalysis) Entertheopenyearforwhichtoviewtransactions.Allopenyearsforthecompanyarelistedinthedropdown. Enterorselectthejournalentrynumberforwhichtoenteroreditthe analysisinformation.Thefollowingvaluesdefaultonselectingajournal entry: TheTransactionDatefielddisplaysthetransactiondateofthejournalentry.Anyadjustmentstotheanalysisinformationwillalsohavethetransactiondate. TheAuditTrailCodefielddisplaystheAnalyticalAccountingaudittrailcodeiftheselectedjournalentryhasexistinganalysisinformation.Thisfieldisblankifnoanalysisinformationexistsfortheselectedjournalentry. TheDistributionfielddisplaysthefirstdistributionaccountoftheselectedjournalentry.Youcanviewalldistributionsforajournalentry,however,youcanadjustanalysisinformationonlyforthosedistributionsthatarelinkedtoanaccountingclass. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamountintheoriginatingorfunctionalcurrencybasedontheoptionselectedinthecurrencyview.Youcannoteditthisamount. Tip Choosetheexpansionbuttontoviewmulticurrencyinformationiftheoriginatingcurrencydiffersfromthefunctionalcurrency.IftheAnalyticalAdjustmentEntrywindowisopenedforaunitaccount,thecurrencyiconisnotdisplayed.Youcannoteditthemulticurrencyinformation,andconversionsforadjustedassignmentswilltakeplaceusingthesamerate. TheCompanyIDfielddisplaystheIDforthecurrentcompany. TheAccountfielddisplaystheaccountrelatedtothedistribution.TheexpansionbuttonwillopentheMicrosoftDynamicsGPAccountEntrywindow.Thebalancetype,whetherdebitorcredit,isalsodisplayed. TheAssignedfielddisplaysthetotaldistributionamountinvalueandpercentagethathasbeenassigned.Thisfieldisblankifnoanalysisinformationexistsfortheselectedjournalentry. TheUnassignedfielddisplaysthedistributionamountthatisnotassignedinvalueandpercentage. Intheassignmentlistview,enterthetransactiondistributionamountfor anassignmentinfunctionalororiginatingcurrency,byvalueorona percentagebasis.Eachassignmentcreatedforthedistributionisdisplayed separately. TheNumberfielddisplaysthenumberoftheassignment.Whenyouenteranewassignmentforanaccountthatalreadyhasoneassignment,theanalyticalinformationfromthefirstassignmentautomaticallydefaultsontothenewassignment.Youcaneditthisinformation. AnarrowbeforetheNumberfieldindicatesthattheanalysisinformationdisplayedisfortheselectedassignment. TheOriginatingorFunctionalAmountfielddisplaystheassignmentsoriginallypostedfortheselectedaccount.EnteroredittheamountassignedintheOriginating/FunctionalAmountfield.YoucanenterassignmentsinthefunctionalororiginatingcurrencybasedontheoptionyouselectedintheCurrencyView. TheAssign%fielddisplaystheassignmentsoriginallypostedfortheselectedaccount.Youcanoverwritetheseassignments. Youcanentertheassignmenteitherinvalueorpercentageterms. AliasfieldDisplaysthealias.TheAlphanumericfieldinthescrollingwindowdisplaysthetransactiondimensioncodesthatareassociatedwiththealiasforthetransactiondimensionsdisplayed.Youcanchangethesecodesifrequired.RefertoCreatinganaliasformoreinformation. TheReferencefielddisplaystheinformationenteredfortheexistingassignments.Youcanchangethisinformationforexistingassignments,andaddnewreferenceinformationforanynewassignmentsthatyoucreate. Theassignmentoptionyou’vesavedforGeneralLedgerdetermineswhetherthedistributionamountmustbeassignedfully,orcanbeassignedpartially.RefertoSettingupassignmentoptionsformoreinformation. ChooseDeleteRowtodeleteaselectedrowintheassignmentlistview.Youcannotchoosethisoptionifonlyasingleassignmenthasbeenentered. ChooseRemainingtoaddoneassignmentfortheremainingunassignedamount. Thenewassignmentwillensurethatthetotalassignedamountequalsthe distributionamount.Forexample,thedistributionamountis$100and you’veenteredfourassignmentsthattotal$75.WhenyouchooseRemaining, afifthassignmentfortheremainingvalue,$25iscreated.Thisbuttonis notavailableifthedistributionfieldisblankorhasazerovalue. ChooseDefaulttoloadthecurrentsetupinformationspecifiedforthe accountclassintheAccountingClassMaintenancewindowandcreateasingle assignment.Thefollowingprocesseswilloccur: Fixed,Required,andOptionalTransactionDimensions(includinghidden transactiondimensions)willbeinstalled. Alltheassignmentsthatyouhavecreatedforthecurrentdistribution willberemovedandasingleassignmentthatisequaltothe distributionamountwillbecreated. IftheanalysistypeischangedtoorfromNotAllowed,transaction dimensionswillbeaddedorremoved. Transactiondimensionsthathavebeendeletedwillberemoved. EnterorselectanexistingtransactiondimensionintheTrx.Dimension fieldtoaddittotheanalyticalaccountifrequired.Youcanonlyselect transactiondimensionswhoseanalysistypeissetasRequired,Fixed,or Optionalfortheaccountclassthatthedistributionaccountislinkedto. Youcanalsoremoveatransactiondimensionfromthescrollingwindowifitisnolongerneeded. TheTransactionDimensionDescriptionfielddisplaysthedescriptionofeachTransactionDimensionthatislisted. Enteroreditthetransactiondimensioncodeforeachtransactiondimension listedintheTrxDimensionfieldifrequired.Enteringacodeisoptional, exceptforthosetransactiondimensionsthathavetheanalysistypesetto Required. Youcanaddnewalphanumericcodesontheflyifyou’veselectedthatoptionintheTransactionDimensionMaintenancewindow.YoucanonlyeditanalphanumericcodethattheuserIDyou’reloggedinasandtheselecteddistributionaccount,bothhaveaccessto.RefertoSettingupuseraccesstocodes,andSettingupaccountaccesstocodesformoreinformation. ChooseValidatetovalidatetheanalysisinformationoftheanalytical accountdisplayedinthewindow.TheAnalyticalAccountingValidationLog Reportisdisplayediferrorsarefoundintheanalysisinformationentered. RefertoValidatingadjustmentsandcorrectingerrorsformore information. ChoosetheprintericontoprinttheAnalyticalAdjustmentEntryeditlist forthecurrentdistributiondisplayedorforalldistributionsofthe journalentrythatcanbeadjusted.TheAnalyticalAccountingValidationLog reportwhichdescribestheAnalyticalAccountingerrorsalsoisprintedif errorsexist. ChooseCleartoclearallthevaluesenteredthatyou’venotsaved.If you’vesavedanychangestoaselectedjournalentry,youcannotclearthis windowuntilyou’vepostedordeletedsuchsavedchanges. ChooseSavetosavethechangesyou’vemadetotheanalysisinformationof alltheanalyticalaccountsofthejournalentry.Youcanonlysavechanges foronejournalentryatatime.Youmustpostordeletethesechanges beforeyoucanmakechangestoanotherjournalentry. TheanalysisinformationthatyouhaveenteredisvalidatedwhenyouchooseSave.Youcansavewitherrors,butyoucannotpostuntilalltheerrorshavebeencorrected. ChoosePosttopostyourchangesandclosethewindow.Theanalysis informationthatyouhaveenteredisvalidatedwhenyouchoosePost.Youcan postapartialassignmentifyouhaveallowedpartialassignmentsinGeneral LedgerontheAssignmentSetupwindow. Note Untilyoupostanadjustment,theanalysisinformationlastpostedwiththe journalentrywillbeavailableforinquiryandreporting. ChooseDeletetodeleteanyadjustedanalyticalinformationforthejournal entry.Anyanalyticalinformationenteredforthejournalentrywhenitwas lastpostedwillberetained. Validatingadjustmentsandcorrectingerrors YoucanvalidateanadjustmentbychoosingtheAdditional>>Run ValidationorbypressingCTRL+R.Youcanalsovalidateanadjustmentby choosingtheOK,SaveorValidatebuttons. Iferrorsarefoundwhileposting,theadjustmentwillnotbeposted.The AnalyticalAccountingValidationLogwindowwillopen,listingallthe errorsfound. TocorrectanAnalyticalAccountingerror,double-clickontherelevant errortoopentheAnalyticalAdjustmentEntrywindow.Thespecific distributionwheretheerrorexistsisdisplayed.Youcanpostthe adjustmentonlyafteralltheerrorshavebeenresolved. Thevalidationprocessverifiesthefollowinginformationforeach analyticalaccountthathasbeenadjusted: Thetransactiondimensionsoftheanalyticalaccountareactiveorhavenot beendeleted. Transactiondimensioncodeshavebeenenteredforallthosetransaction dimensionswhereCodeRequiredDuringAdjustmenthasbeenmarkedonthe TransactionDimensionMaintenancewindow. Thetransactiondimensioncodesusedareactive. Theanalyticalaccounthasaccesstothetransactiondimensioncodesthat havebeenentered. Theusermakingtheadjustmentshasaccesstothetransactiondimension codesthathavebeenentered. Thecombinationbetweenthetransactiondimensioncodesofthealphanumeric transactiondimensionsisvalid. IfFullAssignmentisoptedforinGeneralLedger,thenthetotalofall assignmentsenteredfortheanalyticalaccountequalsthedistribution amountoftheaccount. Viewingdetailjournalentrieswithanalysisinformation UsetheAnalyticalAccountingDetailJournalEntryInquirywindowtoview analysisinformationofanaccountforthecurrentyearorforaclosedyear fromtheTransactionEntryZoomwindow.RefertoTransferringanalysis informationforclosedyearstohistoryformoreinformationonyearend closingprocess. ThiswindowonlywilldisplaythosedistributionaccountsofaJournalEntry thatcompriseanalysisinformation. Toviewdetailjournalentrieswithanalysisinformation: OpentheAnalyticalAccounting–DetailJournalEntryInquirywindow. (Inquiry>>Financial>>Detail>>SelectanaccountandYear>> ClicktheJournalEntrylink>>Selectaccount>>CTRL+T) (Inquiry>>Financial>>HistoryDetail>>SelectanaccountandYear >>ClicktheJournalEntrylink>>Selectaccount>>CTRL+T) TheAnalyticalDetailInquirywindowdisplaysallanalysisinformationthathasbeenenteredforthedistributionaccount.TheJournalEntryfielddisplaystheJournalNumber. TheReportingLedgerfielddisplaysthereportingledgerassignedtothe GeneralLedgertransactionintheGeneralLedgertransactionentrywindow (Transactions>>Financial>>General).RefertotheGeneralLedger documentationformoreinformation. ThisfieldisavailableonlyifyouhavemarkedtheAllowcheckboxfortheReportingLedgeroptionintheGeneralLedgerSetupwindow(Administration>>Setup>>Financial>>GeneralLedger). EnterorselectadistributionfortheJournalEntry. TheAccountfielddisplaystheaccountrelatedtothedistribution.Choose theexpansionbuttontoopentheMicrosoftDynamicsGPAccountEntrywindow. TheAuditTrailCodefielddisplaystheAnalyticalAccountingAuditTrailCode. Note AnAuditTrailCodeiscreatedforeachJournalEntrymadeinAnalyticalAccounting.ThisAuditTrailisseparatefromtheonecreatedbyDynamicsGP. TheTransactionDatefielddisplaysthetransactiondateoftheselected JournalEntry TheCompanyIDfielddisplaystheIDforthecurrentcompany. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamount intheoriginatingorfunctionalcurrencybasedontheoptionselectedin theCurrencyView.Choosetheexpansionbuttontoviewmulticurrency informationiftheoriginatingcurrencydiffersfromthefunctional currency.WhentheAnalyticalAccounting-JournalEntryInquirywindowis openedforUnitAccounts,thecurrencyinformationwillnotbeavailable. ChooseExpandtodisplayallanalysisinformationenteredforthe distributionaccountinthelistwindowwhichincludesassignments, referenceinformationenteredperassignment,transactiondimensionsand theircodes. ChooseCollapsetodisplayanalysisinformationenteredperassignment. Youalsocanviewallinformationenteredforeachassignmentorjust referenceinformationthatmayexist.Choosetheplusbutton(+)available nexttoeachassignmenttoviewallanalysisinformationenteredforan assignmentorchoosetheminusbutton(-)toviewonlyreference information. Viewingjournalentrieswithanalysisinformation YoucanviewanalysisinformationforpostedtransactionsintheAnalytical AccountingJournalEntryInquirywindow. Toviewjournalentrieswithanalysisinformation: OpentheAnalyticalAccounting-JournalEntryInquirywindow. (Inquiry>>Financial>>JournalEntryInquiry>>CTRL+T) (Inquiry>>Financial>>AnalyticalAccounting>>JournalEntry) TheJournalEntryfielddisplaystheJournalNumberselected.Enteror selectaJournalEntryNumberofanopenYear. TheReportingLedgerfielddisplaysthereportingledgerassignedtothe GeneralLedgertransactionintheGeneralLedgertransactionentrywindow (Transactions>>Financial>>General).RefertotheGeneralLedger documentationformoreinformation. ThisfieldisavailableonlyifyouhavemarkedtheAllowcheckboxfortheReportingLedgeroptionintheGeneralLedgerSetupwindow(Administration>>Setup>>Financial>>GeneralLedger). Youcanbrowseandsortbythefollowingoptions: JournalEntryYoucanbrowseanalysisinformationenteredforeachJournalEntry. AuditTrailCodeYoucanbrowseanalysisinformationbasedontheAuditTrailCodeofaJournalEntry. PostingDateYoucanbrowseanalysisinformationbyPostingDate. ChooseOKtoclosethewindow. AnalyticalAccountingchecklinks Checkinglinksexaminestables,checkingcorrespondinginformationin relatedtablesinAnalyticalAccountingandMicrosoftDynamicsGPand,if possible,changingthedatatomatchthecorrespondingdatainatable. Tochecklinks: EnsurethatallusersareloggedoutofMicrosoftDynamicsGP.Toviewwhich usersareintheMicrosoftDynamicsGPsystemandwhere,choose Administration>>Setup>>System>>UserActivity. Takeabackupofallyourdatabases. Alwaystakeabackupbeforecheckinglinks. OpentheAnalyticalAccountingCheckLinkswindow (Administration>>Maintenance>>AnalyticalAccountingCheckLinks). Selectthetablegroupstochecklinksfor,whetherAAOpenandHistory Transactions,AAWorkTransactions,orboth. ChooseInserttoinsertthehighlightedlogicaltablesintheSelected Tableslist. ChooseAlltoInsertallfilesfromtheLogicalTableslistintothe SelectedTableslistsoyoucanchecklinksforallfiles. ChooseRemovetoremoveanytablefromtheSelectedTableslist,highlight thetablenameandchooseRemove. ChoosePreviewtoprinttheAAFileMaintenanceErrorLogReport-Preview. ChooseCanceltoClosethewindow.Ifyouinsertedtablegroupnamesinto theSelectedTableslist. TotalNumberofrecordsfielddisplaysthetotalnumberofrecordswithinthetablesintheSelectedTableslist. ChooseProcesstochecklinksfortheselectedtablesandprinttheCheck LinksReport. TheReportDestinationwindowwillappear,andyoucanspecifywherethe CheckLinksReportshouldbeprinted.IfyoumarkFile,selectthe appropriatetableformatandenterthereportfilename. TheCheckLinksReportwilldisplayanyinformationthatwasre-created. WerecommendthatyousendtheCheckLinksReporttothescreen,and thenprintitifnecessary,becauseitmaybeverylarge.Eachreport canonlybeprintedonceeachtimeyouchecklinks,soitsagoodidea tosendthereporttoafileaswell. Todeterminewhatinformationtore-enter,usetheTableDescriptionswindow (Administration>>ResourceDescriptions>>Tables)toviewinformation forthetableyoucheckedlinksfor,thenuseawindowthataccessesthe tabletoreenterinformation. Tip YoumaywanttocreateareportusingReportWriterthatlistsallfieldsincludedinthetablethatyoucheckedlinksfor.Thisreportcanserveasavaluablereferencetool.Formoreinformation,refertotheReportWritermanual. CopyingAnalyticalAccountingInformationforGeneralJournal UsetheCopyJournalEntrywindowtocopyanalyticalaccountinginformation forpostedtransaction. Tocopyanalyticalaccountinginformationforgeneraljournal: OpencopytheTransactionEntrywindow. (Transactions>>Financial>>General) ChooseCopy.TheCopyJournalEntrywindowwillopen. IntheCopyJournalEntrywindow,selecttheyearthatthetransaction you’recopyingwasposted. Selectthejournalentrynumberforthetransactionthatyou’recopying. MarktheCopyAnalyticalAccountinginformationoption. ChooseOK.TheCopyJournalEntrywindowwillclose.Thenewtransaction willappearintheTransactionentrywindowalongwiththeanalytical accountinginformation.Modifytheanalyticalaccountinginformationas necessary. Chapter5:PayablesManagementTransactions YoucanenterandviewanalysisinformationfortransactionsinPayables Management.Youcancreateassignments,entertransactiondimensioncodes, andalsoviewanalysisinformationcreatedforadocument.Youalsocansave transactionswithanalysisinformationtoasingleorrecurringbatchbefore postingthebatch.Analysisinformationcreatedfortransactionscanbe validatedatanytimebeforetheyareposted. YoucanopentheAnalyticalTransactionEntrywindowonlyifAnalytical Accountinghasbeenactivated.RefertoActivatingAnalyticalAccounting formoreinformationaboutactivatingAnalyticalAccounting. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforpayablestransactions Enteringanalysisinformationformanualpayments Processingbatchesofcomputercheckswithanalysisinformation Enteringanalysisinformationwhileapplyingdocuments Unapplyingadocument Applyingunpostedcreditmemos,returnsandpayments Unapplyingunpostedcreditmemos,returnsandpayments Voidingdocumentswithanalysisinformation Viewinganalysisinformationforpayablestransactions Enteringanalysisinformationforpayablestransactions Youcancreateassignmentsandentertransactiondimensioncodesfor accountsthatarelinkedtoanaccountclassfromthePayablesTransaction Entrywindow.ThisinformationcanbeenteredintheAnalyticalPayables TransactionEntrywindow. TheAnalyticalPayablesTransactionEntrywindowopensautomaticallyfrom thePayablesTransactionEntryDistributionwindowinthefollowing instances: IftheaccountislinkedtoanaccountclassandtheAnalyticalPayables TransactionEntrywindowhasnotbeenopenedevenoncefortheaccount. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation suchasaccountoramountortypeofamountcreatedpreviouslyforsuch line. IfyoudeleteadocumentfromthePayablesTransactionEntrywindow,the analysisinformationthatexistsforthedocumentwillalsobedeleted. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Analysis informationenteredpreviouslyisdeletedwhenthedistributionsare re-created. IfyouselectDefaultinthePayablesTransactionEntryDistributionwindow, allanalysisinformationcreatedforthedocumentwillbedeleted. Toenteranalysisinformationforpayablestransactions: OpentheAnalyticalPayablesTransactionEntrywindow. (Transactions>>Purchasing>>TransactionEntry>>ChoosetheAnalyticalAccountingbutton) (Transactions>>Purchasing>>TransactionEntry>>CTRL+TorAdditional>>AnalyticalTransaction) (Transactions>>Purchasing>>TransactionEntry>>Taxexpansionbutton>>CTRL+TorAdditional>>AnalyticalTransaction) (Transactions>>Purchasing>>TransactionEntry>>Distributionsbutton>>CTRL+TorAdditional>>AnalyticalTransaction) RefertoEnteringanalysisinformationforGeneralLedgertransactionsformoreinformationaboutenteringtheanalysisinformation. Enteringanalysisinformationformanualpayments Youcanalsoenteranalysisinformationformanualpaymentsusingthe AnalyticalPayablesManualPaymentEntrywindow. IfyoudeleteadocumentfromthePayablesManualPaymentEntrywindow,the analysisinformationthatexistsforthedocumentalsowillbedeleted. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Analysis informationenteredearlierisdeletedwhenthedistributionsare re-created. IfyouselectDefaultonPayablesTransactionEntryDistributionwindow,all analysisinformationcreatedforthedocumentwillbedeleted. TheAnalyticalPayablesManualPaymentEntrywindowwillopenautomatically fromthePayablesTransactionEntryDistributionwindow,whenyoupressTAB fromarowinthefollowinginstances: •IftheaccountislinkedtoanaccountclassandtheAnalyticalPayables ManualPaymentEntrywindowhasneverbeenopenedfortheaccount. •Ifchangesaremadetoadistributionlinethataffectsanalysis informationenteredpreviouslyfortheline.Theseincludechangingthe account,amountordebittocreditorviceversa,asthiswilldeletethe previouslyenteredanalysisinformationandcreateasingleassignmentof 100percent. Toenteranalysisinformationformanualpayments: OpentheAnalyticalPayablesManualPaymentEntrywindow. (Transactions>>Purchasing>>ManualPayments>>Choosethe AnalyticalAccountingbutton) (Transactions>>Purchasing>>ManualPayments>>CTRL+Tor Additional>>AnalyticalTransaction) (Transactions>>Purchasing>>ManualPayments>>Distributions>> CTRL+TorAdditional>>AnalyticalTransaction) IMAGE–AAPMT.jpg TheAnalyticalPayablesTransactionEntrywindowdisplaysthedistribution accountselected.Toviewotherdistributions,enterorselecta distributionnumber. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationabouttheenteringanalysisinformation. Processingbatchesofcomputercheckswithanalysisinformation Youcanenteranalysisinformationfordistributionsthatarecreatedafter acomputercheckrunonlyintheGeneralLedger.TheAnalyticalTransaction EntrywindowcannotbeopenedfromanyoftheMicrosoftDynamicsGPwindows wherecomputerchecksareposted. Forcomputerchecks,theoptionPostThroughGeneralLedgerfilesunder PostingSetupwillnotbeavailable.Thisistoensurethatanalysis informationfordistributionaccountslinkedtoanaccountclassiscreated beforeupdatingGeneralLedgerHistory. Averificationtakesplacetocheckifanyofthedistributionaccountsare linkedtoanaccountclassinthefollowinginstances: WhenyouprintchecksfromthePrintPayablesCheckswindow (Transactions>>Purchasing>>PrintChecks) WhenyoupostabatchfromthePostPayablesCheckswindow (Transactions>>Purchasing>>PostChecks) WhenyoupostabatchfromtheProcessPayablesCheckswindow (Transactions>>Purchasing>>ProcessRemittance) Ifthedistributionaccountsarelinkedtoanaccountclass,thenthe defaultcodesthataresetfortheaccountclasswillbeassignedtothese distributionaccounts.Asingleassignmentwillbecreatedforeach distributionaccountthatislinkedtoanaccountclass. TherewillbenoAnalyticalAccountingvalidationduringacomputercheck runorwhileprintingacheque. IfyouvoidchecksinthePostPayablesCheckwindow,allthedistributions forthepaymentwillbedeletedinMicrosoftDynamicsGPandthepayment willmovetohistory.Anyanalysisinformationthatexistsforthepayment willalsobedeleted. Enteringanalysisinformationwhileapplyingdocuments Youcanenteranalysisinformationfordistributions,ifany,createdafter postedpayments,creditmemosandreturnsdocumentsareappliedintheApply PayablesDocumentswindow(Transactions>>Purchasing>>ApplyTo).You canenteranalysisinformationintheAnalyticalApplyPayablesDocuments window. Analysisinformationcanbeenteredfordistributionscreatedforterms taken,writeoffs,realizedgainorrealizedlosswhenpostedcredit documents,returnsandpaymentsareappliedagainstinvoices,ifthe distributionaccountsarelinkedtoanaccountclassintheAnalyticalApply PayablesDocumentswindow.TheAnalyticalApplyPayablesDocumentswindow willopenwhenyouchooseOKintheApplyPayablesDocumentswindow.This wouldbeapplicableevenifdistributionsarecreatedaftertransactionsare autoapplied. TheAnalyticalApplyPayablesDocumentwindowwillalsoopenifyouchange theCustomerIDorDocumentNo.intheApplyPayablesDocumentswindow. IftheAnalyticalApplyPayablesDocumentswindowhasbeenopenedatleast once,youcanopenitanytimethereafterbypressingCTRL+Torchoosing Additional>>AnalyticalTransactionbeforethedistributionsareposted. TheAnalyticalApplyPayablesDocumentswindowwillopendisplayingthe firstofthedistributionaccountscreatedduringtheprocessofapplythat havebeenlinkedtoanaccountclass. Ifyou’vemarkedtheShowvalidcodecombinationsintrnsandbudgetsoption intheAnalyticalAccountingOptionswindow,thenthelookupwindowwill displayonlythosecodesthathaveavalidcombinationwiththecodesyou havealreadyselectedforthetransaction. RefertoEnteringanalysisinformationforpayablestransactionsformore informationaboutenteringanalysisinformation. Unapplyingadocument Whenyouunapplypostedcreditmemos,returnsorpayments,theentries relatingtotermstaken,writeoffs,realizedgainorlossarereversed. Analysisinformationmustbeenteredforthesedistributionaccountsifthey arelinkedtoanaccountclass.Youcanenteranalysisinformationinthe AnalyticalApplyPayablesDocumentswindow.Thewindowopenswhenyouchoose OKintheApplyPayablesDocumentswindow. Theanalysisinformationenteredfordistributionaccountsrelatingtoterms taken,writeoffs,realizedgainorlosswillbevalidatedbeforethese entriesareposted.ErrorsdetectedwillbedisplayedintheAnalytical AccountingValidationLog. YouwillnotbeabletoclosetheApplyPayablesDocumentwindowwithout enteringallrequiredanalysisinformationforthedistributionaccounts linkedtoanaccountclass. Applyingunpostedcreditmemos,returnsandpayments Youcanenteranalysisinformationforcreditmemos,returnsandpayments appliedinthePayablesTransactionEntryandPayablesManualPaymentEntry windowsusingtheAnalyticalPayablesTransactionEntryorAnalytical PayablesManualPaymentEntrywindows.TheAnalyticalPayablesTransaction EntryorAnalyticalPayablesManualPaymentEntrywindowswillopenwhenyou selectOKintheApplyPayablesDocumentswindow. AnalysisinformationenteredfortheAccountsPayableaccountinthe PayablesTransactionEntryorManualPaymentsEntrywindowsbeforethe creditmemo,returnorpaymentisapplied,willbedeletedifdistributions arecreatedfortermstaken,writeoffs,andrealizedgainorloss. Unapplyingunpostedcreditmemos,returnsandpayments Ifyouunapplyunpostedcreditmemos,returnsandpaymentsthatwere applied,priortoposting,analysisinformationenteredforthedistribution accountsrelatingtotermstaken,writeoffsandrealizedgainorloss accountswillbedeleted. Voidingdocumentswithanalysisinformation WhenyouvoiddocumentsintheVoidHistoricalPayablesTransactionwindow (Transactions>>Purchasing>>VoidHistoricalTransaction)ortheVoid OpenPayablesTransactionwindow(Transactions>>Purchasing>>Void OpenTransaction),allanalysisinformationenteredforthedocumentduring transactionentrywillbecopiedwiththeexceptionofthebalancetypeof eachdistributionaccountlinkedtoanaccountclass.Thebalancetypeof eachdistributionaccountwillbereversed. TheAnalyticalTransactionEntrywindowcannotbeopenedpriortovoidinga documentintheVoidHistoricalPayablesTransactionorVoidOpenPayables Transactionwindows. TheAnalyticalAccountingPostingJournalwillprintaftertheMicrosoft DynamicsGPreports,ifyou’veselectedtheoptionunderPostingSetup.This reportwilldisplayallanalysisinformationforthevoidedtransaction. Viewinganalysisinformationforpayablestransactions Youcanviewanalysisinformationforpayablestransactionsinthe AnalyticalPayablesTransactionEntryzoomwindow.TheAnalyticalinquiry windowwillonlydisplaydistributionaccountsofadocumentthatarelinked toanaccountclass. Toviewanalysisinformationforpayablestransactions: OpentheAnalyticalPayablesTransactionEntryzoomwindow. (Inquiry>>Purchasing>>TransactionbyVendor/Document>>Selecta documentandzoomontheDocumentNumber>>Additional>>Analytical Transaction) (Inquiry>>Purchasing>>TransactionbyVendor/Document>>Select documentandzoomtoDocumentNumber>>Distributionsbutton>> Additional>>AnalyticalTransaction) TheAnalyticalPayablesTransactionEntryzoomwindowdisplaysallanalysis informationcreatedforadistributionaccount. RefertoViewinganalysisinformationforPurchaseOrderProcessing documentsformoreinformationaboutviewinganalysisinformationfor transactions. Chapter6:PurchaseOrderProcessingTransactions YoucanenteranalysisinformationfortransactionsinPurchaseOrder Processingandsaveanalysisinformationforabatch. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforpurchaseordersandreceipts Enteringanalysisinformationforpurchaseorders Analysisinformationforadjustingentries Postingtransactionswithanalysisinformation Postingabatchwithanalysisinformation PostingthroughtoGeneralLedgerfortransactionposting ViewinganalysisinformationforPurchaseOrderProcessingdocuments Viewinganalysisinformationforpurchaseorders CopyingAnalyticalAccountingInformationforPurchaseOrderorPurchase OrderLineItems Enteringanalysisinformationforpurchaseordersandreceipts TheAnalyticalReceivingsTransactionEntryandtheAnalyticalPurchasing InvoiceEntrywindowswillopenautomaticallywhenyoupressTABfromarow inthePayablesTransactionDistributionEntrywindowinthefollowing instances: IftheaccountislinkedtoanaccountclassandtheAnalyticalTransaction Entrywindowhasnotbeenopenedevenoncefortheaccount. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation enteredpreviouslyforsuchline.Theseincludechangingtheaccountor amountordebittocreditorcredittodebit,asthiswilldeletethe previouslyenteredanalysisinformationandcreateasingleassignmentof 100percent. IfyoudeleteadocumentintheReceivingsTransactionEntrywindoworthe PurchasingInvoiceEntrywindow,theanalysisinformationenteredforthe documentalsowillbedeleted. IfyouvoidanunposteddocumentintheReceivingsTransactionEntryor PurchasingInvoiceEntrywindows,analysisinformationcreatedforthe documentwillbedeleted. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Ifthe transactiondateisaltered,analysisinformationcreatedpreviouslyis deletedwhenthedistributionsarerecreated. Toenteranalysisinformationforpurchaseordersandreceipts: OpentheAnalyticalReceivingsTransactionEntryorAnalyticalPurchasing InvoiceEntrywindows. (Transactions>>Purchasing>>ReceivingsTransactionEntry>>Choose theAnalyticalAccountingbutton) (Transactions>>Purchasing>>ReceivingsTransactionEntry>>Enter vendoritem>>CTRL+TorAdditional>>AnalyticalTransaction) (Transactions>>Purchasing>>Enter/MatchInvoice>>Choosethe AnalyticalAccountingbutton) (Transactions>>Purchasing>>Enter/MatchInvoice>>Enterquantity invoiced>>CTRL+TorAdditional>>AnalyticalTransaction) RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationonenteringanalysisinformationfortransactions. YoucanvalidateatransactionbypressingCTRL+TorbychoosingAdditional>>RunValidationinthefollowingwindows: PayablesTransactionEntry PayablesManualPaymentsEntry ApplyPayablesDocuments ReceivingsTransactionEntry PurchasingInvoiceEntry RefertoValidatingtransactionsandcorrectingerrorsformoreinformationaboutvalidation. Iferrorsaredetectedinthetransaction,theAnalyticalAccountingValidationLogwindowwillopendisplayingallerrorsdetectedbythevalidationroutine. Tip YoucanselectView>>IncompleteorErroneousDistributions,tobrowsethroughthedistributionaccountsintheAnalyticalTransactionEntrywindowwhichareincompleteorhaveerroneousinformation. Enteringanalysisinformationforpurchaseorders Youcanenteranalysisinformationforinventory,purchasesordropship accountslinkedtoalineitemwhileenteringapurchaseorder.The informationwilldefaultwhenyoureceivetheselineitemsintheReceivings TransactionEntrywindow. YoucanopentheAnalyticalPurchaseOrderEntrywindowfromthePurchasing ItemDetailEntrywindowinthefollowinginstanceiftheaccountislinked toanaccountclass: •Ifchangesaremadetoadistributionlinethataffectsanalysis informationsuchasaccountoramountenteredpreviouslyforsuchline.This willdeleteandrefreshthepreviouslyenteredanalysisinformationand createasingleassignmentof100percent. IfyoudeleteadocumentoradistributionlineinthePurchaseOrderEntry orthePurchasingItemDetailEntrywindow,theanalysisinformationentered forthesamewillalsobedeleted. YoucannoteditthePurchaseOrderEntryorthePurchasingItemDetailEntry windowwhiletheAnalyticalPurchaseOrderEntrywindowisopen. Inthecaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Ifthe transactiondateisaltered,analysisinformationcreatedpreviouslyis deletedwhenthedistributionsarerecreated. Note AnalysisinformationisnotcopiedwhenyouchoosetocopyPOlinesfrom anotherPOtothecurrentPO.Youmustenterfreshanalyticalinformation forthenewpurchaseorder. Toenteranalysisinformationforpurchaseorders: OpentheAnalyticalPurchaseOrderEntrywindow. (Transactions>>Purchasing>>PurchaseOrderEntry>>Enterorselect apurchaseorder>>ChoosetheAnalyticalAccountingbutton) (Transactions>>Purchasing>>PurchaseOrderEntry>>Enterorselect apurchaseorder>>CTRL+TorAdditional>>AnalyticalTransaction) (Transactions>>Purchasing>>PurchaseOrderEntry>>Enterorselect apurchaseorder>>ItemorVendorItemexpansionbutton>>Choosethe AnalyticalAccountingbutton) (Transactions>>Purchasing>>PurchaseOrderEntry>>Enterorselect apurchaseorder>>ItemorVendorItemexpansionbutton>>CTRL+Tor Additional>>AnalyticalTransaction) WhenyouopentheAnalyticalPurchaseOrderEntrywindowfromthePurchasingItemDetailEntrywindow,itdisplaysonlytheaccountfortheselecteditem. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationonenteringanalysisinformationfortransactions. YoucanvalidatetheanalysisinformationbypressingCTRL+Rorbychoosing Additional>>RunValidationinthePurchaseOrderEntryorthePurchasing ItemDetailEntrywindows.RefertoValidatingtransactionsandcorrecting errorsformoreinformationaboutvalidation. Analysisinformationforadjustingentries AdjustingentriesarepostedtoGeneralLedgerforeachitemthathasits currentcostchangedandusestheAveragePerpetualvaluationmethod. Adjustingentriesarealsopostedforquantitysoldtransactionsrelatingto thepurchasereceiptofitemsthatusetheAveragePerpetual,LIFO Perpetual,orFIFOPerpetualvaluationmethod.Suchentriesarecreatedin thefollowinginstances: Theuserselectstorevalueinventorywhenpostingapurchasinginvoice wheretheinvoicecostdiffersfromtheshipmentcost. TheAdjustCostsutilityisusedtoeditapurchasereceiptrecord’scost. APurchaseOrderlineitemischangedtoastatusofClosedwhenits QuantityShippedisgreaterthantheQuantityInvoiced,whenQuantity Invoicedisnotzero. Apurchasereceiptisinsertedintoanexistingpurchasereceiptstack. WhensuchadjustingentriesaregeneratedinGeneralLedger,default transactiondimensioncodesareloadedandasingleassignmentiscreated fordistributionaccountsthatarelinkedtoanaccountclass.Youcan modifythedefaultanalysisinformation,beforepostingthroughGeneral Ledger.RefertoEnteringanalysisinformationforGeneralLedger transactionsformoreinformation. IfyouhavemarkedtheoptionPostThroughGeneralledgerFilesinthe PostingSetupwindow(Administration>>Setup>>Posting>>Posting), oryouhavemarkedtheoptionPostthroughtoGeneralLedgerforTrxPosting intheAnalyticalAccountingOptionswindow(Administration>>Setup>> Company>>Analytical Accounting>>Options),thetransactionorbatchisposteddirectly throughGeneralLedgerwithdefaultanalysisinformationfortheadditional distributions.YoucanmodifythisinformationintheAnalyticalAdjustment Entrywindowifrequired.RefertoAdjustinganalysisinformationinposted transactionsformoreinformation. Postingtransactionswithanalysisinformation Whenyoupostatransactionwithanalysisinformationfromthefollowing windows,avalidationwilltakeplace: PayablesTransactionEntry PayablesManualPaymentsEntry ReceivingsTransactionEntry PurchasingInvoiceEntry WhenyouclosetheApplyPayablesDocumentswindow,analysisinformation createdforthedocumentinthewindowwillbevalidated. RefertoValidatingtransactionsandcorrectingerrorsformore information.InadditiontoAnalyticalAccountinginformation,Microsoft DynamicsGPinformationwillalsobevalidatedbeforethetransactionis posted. TheAnalyticalPostingJournalwillbeprintedafteratransactionisposted orafterclosingtheApplyPayablesDocumentswindowifspecifiedunder PostingSetup. Postingabatchwithanalysisinformation YoucanenteranalysisinformationfortransactionswithinaPayablesor PurchasingBatch.RefertoEnteringanalysisinformationforpurchase ordersandreceiptsformoreinformationaboutenteringanalysis information. YoucanprinttheAnalyticalAccountingEditListandAnalyticalAccounting ValidationLogtocheckiferrorsexistintheanalysisinformationalong withtheMicrosoftDynamicsGPEditListforaselectedbatchbychoosing theprintericonbutton. WhenyoupostabatchfromthePayablesManagementwindoworthePurchase OrderProcessingwindow,avalidationtakesplaceforallthetransactions savedinthebatch.RefertoValidatingtransactionsandcorrectingerrors formoreinformationaboutthevalidationprocess.MicrosoftDynamicsGPand AnalyticalAccountingtransactionswithouterrorsareposted.TheAnalytical PostingJournalisprinted,ifspecifiedunderPostingSetup,alongwiththe MicrosoftDynamicsGPreports.Iferrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogreportisprintedlisting theanalysiserrorsforthetransactionsinthebatchbeingposted.Youcan correcttheerrorsbyeditingthetransactionsinthewindowwherethe transactionoriginatedfrom. Ifyoudeleteasingleorrecurringusebatchoratransactionwithinsuch batches,theanalysisinformationenteredforthetransactionsinthebatch orforthetransactionwillalsobedeleted. YoucansaveatransactioninabatchwithAnalyticalAccountingerrorsbut youcannotpostthetransaction. Forarecurringbatch,theanalysisinformationofthebatchlastposted willberetainedandwillupdateeachsubsequentbatchthatisposted, unlesschangesaremadetotheanalysisinformationinthebatch. WhenyouprinttheAnalyticalPostingJournal,detailedanalysisinformation ofallaccountswillbeprinted.Thiswouldalsoincludeaccountswith errors.TheAnalyticalValidationLogreportdetailingallAnalytical Accountingerrorswillalsobeprinted.YoucancorrectAnalytical Accountingerrorsbyopeningthebatchandthencorrectingthetransactions thathaveerrors. PostingthroughtoGeneralLedgerfortransactionposting IndividualtransactionsandbatchespostedfromPayablesManagementwill automaticallyupdatetheappropriatepostingaccountsinGeneralLedgerif youhavemarkedthefollowingoptions,andiftherearenoAnalytical AccountingandMicrosoftDynamicsGPerrors: PostthroughGeneralLedgerfilesunderPostingSetup(Administration>> Setup>>Posting>>Posting);and PostthroughtoGeneralLedgerforTrxPosting(Administration>>Setup >>Company>>AnalyticalAccounting>>Setup) RefertoSettinguppostingoptionsforAnalyticalAccountingformore informationaboutAnalyticalAccountingpostingsetup. Whilepostingindividualandbatchtransactions,AnalyticalAccountingor MicrosoftDynamicsGPerrorsmayexistwhichwouldpreventthetransaction orbatchfromupdatingtheappropriatepostingaccountsinGeneralLedger. Forexample,defaultcodesmaynotbeassignedforRequiredtransaction dimensionsintheaccountclassthatthedistributionaccountsofFixedor Variableaccountsarelinkedto.Thetransactionorbatchwillupdatethe GeneralLedger.Youmustcorrecttheerrorsinthetransactionorbatchin theGeneralLedgerfromtheTransactionEntrywindow(Transactions>> Financial>>General)beforethepostingaccountscanbeupdated. TheAnalyticalAccountingandMicrosoftDynamicsGPerrorswillbedisplayed intheAnalyticalAccountingValidationLogReportwhichwillprintafter thetransactionorbatchupdatesPayablesManagement. ThetransactionandbatchwillupdatethePayablesManagement.Youwillbe abletoviewanalysisinformationthatoriginatedforthetransactionor batchinPayablesManagementfromtherelevantInquirywindows. ViewinganalysisinformationforPurchaseOrderProcessingdocuments YoucanviewanalysisinformationcreatedfortransactionsinPurchaseOrder ProcessingintheAnalyticalPurchasingInvoiceInquiryZoomwindow. Youcanviewtheassignments,transactiondimensioncodesandreference notesthathavebeencreatedforindividualtransactiondistributionsin thiswindow. ToviewanalysisinformationforPurchaseOrderProcessingdocuments: OpentheAnalyticalPurchasingInvoiceInquiryZoomwindow. (Inquiry>>Purchasing>>PurchaseOrderDocs>>PurchasingInvoice InquiryZoom>>CTRL+TorAdditional>>AnalyticalTransaction) (Inquiry>>Purchasing>>PurchaseOrderDocs>>Receivings TransactionInquiryZoom>>CTRL+TorAdditional>>Analytical Transaction) TheAnalyticalPostingInquirywindowdisplaysallanalysisinformation createdforadistributionaccount.Thefirstdistributionaccountofthe documentlinkedtoanaccountclassisdisplayed.Enterorselecta distributionnumbertoviewanalysisinformationforotherdistribution accounts. IfyouselectaspecificaccountinthePurchasingDistributionInquiry Zoom,theAnalyticalPostingInquirywindowwilldisplayanalysis informationrelatingtotheselectedaccount. TheDocumentTypeandNumberfieldsdisplaythevaluesfromtheReceivings TransactionInquirywindoworthePurchasingInvoiceInquiryzoom. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamount intheoriginatingorfunctionalcurrencybasedontheoptionyouselected intheCurrencyView.Clicktheexpansionbuttontoviewmulticurrency informationiftheoriginatingcurrencydiffersfromthefunctional currency. TheDocumentDatedisplaysthedateofthedocumentandwilldefaultfrom theReceivingsTransactionInquiryorPurchasingInvoiceInquiryZoom. TheCompanyIDfielddisplaystheIDofthecurrentcompany. ClickExpandtodisplayallanalysisinformationenteredforthe distributionaccountintheassignmentlistwindow.Thisincludes assignments,referenceinformationenteredperassignment,transaction dimensionsandtheircodes. ClickCollapsetodisplayonlyassignmentsandreferenceinformationentered perassignmentforthedistributionaccount. Youalsocanviewallinformationenteredforeachassignmentorjust referenceinformationthatmayexist.Choosetheplusbutton(+)available nexttoeachassignmenttoviewallanalysisinformationenteredforan assignmentorchoosetheminusbutton(-)toviewonlyreferenceinformation thatmayexist. ChooseOKtoclosethewindow. Viewinganalysisinformationforpurchaseorders Youcanviewtheanalysisinformationyou’veenteredforapurchaseorderin theAnalyticalPurchaseOrderInquirywindow. Toviewanalysisinformationforpurchaseorders: OpentheAnalyticalPurchaseOrderInquiryZoomwindow. (Inquiry>>Purchasing>>PurchaseOrderDocuments/PurchaseOrderItems >>ChoosethePONumberlink>>CTRL+TorAdditional>>Analytical Transaction) Transactions>>Purchasing>>ReceivingsTransactionEntry>>Selecta purchaseorderinthescrollingwindow>>ChoosethePONumberlink>> CTRL+TorAdditional>>AnalyticalTransaction) (Transactions>>Purchasing>>ReceivingsTransactionEntry>>Select apurchaseorderinthescrollingwindow>>ChoosethePONumberlink>> VendorItemExpansionbutton>>CTRL+TorAdditional>>Analytical Transaction) RefertoViewinganalysisinformationforpayablestransactionsformore informationonviewinganalysisinformationfortransactions. CopyingAnalyticalAccountingInformationforPurchaseOrderorPurchaseOrderLineItems UsetheCopyaPurchaseOrderwindowtocopyanalyticalaccounting informationfromanexistingpurchaseorder. TocopyanalyticalaccountinginformationforpurchaseorderorPurchase OrderLineItems: OpenPurchaseOrderEntrywindow. (Transactions>>Purchasing>>PurchaseOrderEntry>>Actions>> CreateandCopyNewPO) (Transactions>>Purchasing>>PurchaseOrderEntry>>entera purchaseorder>>Actions>>CopyPOLinestoCurrentPO) ChooseActionsandselectCreateandCopyNewPOorCopyPOlinestoCurrent POtoopentheCopyPurchaseOrderwindow. EnterorselectapurchaseorderwithastatusofNew,Released,orChange Ordertocopy. MarktheCopyAnalyticalAccountinginformationoption. Choosecopy.Theanalyticalaccountinginformationiscopiedfromthe originatingdocumenttonewdocument. Chapter7:ReceivablesManagementTransactions FortransactionsinReceivablesManagement,youcancreateassignmentsand entertransactiondimensioncodesforthedistributionaccountsthatare linkedtoanaccountclass.Youcansavetransactionswithanalysis informationtoasingleorrecurringbatchpriortopostingthebatch.Also, youcanviewanalysisinformationcreatedfortransactionsintheAnalytical Inquirywindows.Theprocessofvalidatingtransactionswithanalysis informationisalsoexplained. YoucanopentheAnalyticalTransactionEntrywindowonlyifAnalytical Accountinghasbeenactivated.RefertoActivatingAnalyticalAccounting formoreinformationaboutactivatingAnalyticalAccounting. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforreceivablesdocuments Enteringanalysisinformationforcashreceipts Enteringanalysisinformationforapplieddocuments Unapplyingadocument Applyingunpostedcreditmemos,returnsandpayments Unapplyingunpostedcreditmemos,returnsandpayments Voidingorwaivingdocumentswithanalysisinformation EnteringanalysisinformationforNSFcharges Validatingtransactionsandcorrectingerrors Postingtransactionswithanalysisinformation Postingabatchwithanalysisinformation PostingthroughortoGeneralLedger ViewinganalysisinformationinReceivablesManagement Enteringanalysisinformationforreceivablesdocuments Youcanenterassignmentsandtransactiondimensioncodesforreceivables documentsusingtheAnalyticalReceivablesTransactionEntrywindow. WhenyoupressTABfromafieldintheSalesTransactionDistributionEntry window(Transaction>>Sales>>TransactionEntry),underthefollowing instances,theAnalyticalReceivablesTransactionEntrywindowwillopen: Ifanaccountislinkedtoanaccountclassandnoanalysisinformationhas beenenteredfortheaccountearlier. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation enteredpreviouslyfortheline.Theseincludechangingtheaccount,amount ordebittocreditorviceversa,asthiswilldeletethepreviouslyentered analysisinformationandcreateasingleassignmentof100percent. IfyoudeleteadocumentfromtheReceivablesTransactionEntrywindow,the analysisinformationthatexistsforthedocumentwillalsoberemoved. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Ifthe transactiondateismodified,analysisinformationcreatedpreviouslyis deletedwhenthedistributionsarere-created. IfyouselectDefaultintheSalesTransactionEntryDistribution,all analysisinformationcreatedforthedocumentwillbedeleted. Toenteranalysisinformationforreceivablesdocuments: OpentheAnalyticalReceivablesTransactionEntrywindow. (Transaction>>Sales>>TransactionEntry>>AnalyticalAccounting button) (Transaction>>Sales>>TransactionEntry>>Additional>> AnalyticalTransaction) (Transaction>>Sales>>TransactionEntry>>Distributions>> AnalyticalAccountingbutton) (Transactions>>Sales>>TransactionEntry>>Distributions>> Additional>>AnalyticalTransaction) (Transactions>>Sales>>TransactionEntry>>Taxexpansionbutton >>Additional>>AnalyticalTransaction) Toenteranalysisinformationforreceivablestransactions,refertoEnteringanalysisinformationforGeneralLedgertransactions. Enteringanalysisinformationforcashreceipts YoucanenteranalysisinformationforcashreceiptsusingtheAnalytical CashReceiptsEntrywindow. IfyoudeleteadocumentfromtheCashReceiptsEntrywindow,theanalysis informationthatexistsforthedocumentalsowillberemoved. Formulticurrencytransactions,achangeinthetransactiondatere-creates distributionsduetoachangeintheexchangerate.Ifthetransactiondate ismodified,analysisinformationcreatedpreviouslyisdeletedwhenthe distributionsarere-created. IfyouchooseDefaultintheCashReceiptsDistributionEntrywindow,all analysisinformationcreatedforthedocumentwillbedeleted. IntheCashReceiptsDistributionEntrywindow,theAnalyticalCashReceipts EntrywindowwillopenautomaticallywhenyoupressTABfromarowinthe followinginstances: Ifanaccountislinkedtoanaccountclassandnoanalysisinformationhas beenenteredfortheaccountearlier. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation enteredpreviouslyfortheline.Theseincludechangingtheaccount,amount ordebittocreditorviceversa,asthiswilldeletethepreviouslyentered analysisinformationandcreateasingleassignmentof100percent. RefertoEnteringanalysisinformationforreceivablesdocumentsformore informationaboutcreatinganalysisinformation. Enteringanalysisinformationforapplieddocuments Youcanenteranalysisinformationfordistributionscreated,ifany,after apostedcreditmemo,returnorpaymentisappliedintheApplySales Documentswindow(Transactions>>Sales>>Apply)usingtheAnalytical ApplySalesDocumentswindow. Whenpostedcreditmemos,returnsorpaymentsareappliedtosalesdocuments orotherdebitdocuments,distributionswillbecreatedfortermstaken, writeoffs,taxrebate,andrealizedgainorrealizedloss.Ifthese distributionaccountsarelinkedtoanaccountclass,youmustenter analysisinformationfortheaccounts. TheAnalyticalApplySalesDocumentswindowwillopenwhenyouselectOKin theApplySalesDocumentswindow,orifdistributionsarecreatedwhenyou automaticallyapplysalesdocuments. TheAnalyticalApplySalesDocumentwindowalsowillopenifyouchangethe customerIDordocumentno.intheApplySalesDocumentswindow. InAnalyticalAccounting,voidedandapplieddocumentswillupdateGeneral Ledger,ifyoumarkedthePostThroughGeneralLedgeroptioninthePosting Setupwindow(Administration>>Setup>>Posting>>Posting). IftheAnalyticalApplySalesDocumentswindowhasbeenopenedatleast once,youcanopenitlaterfromtheAdditionalmenu.ChooseAdditional>> AnalyticalTransactionorCTRL+Tbeforethedistributionsareposted. TheAnalyticalApplySalesDocumentswindowwilldisplaythefirstofthe distributionaccountscreatedduringtheapplyprocessthathavebeenlinked toanaccountclass. Ifyou’vemarkedtheShowvalidcodecombinationsintrnsandbudgetsoption intheAnalyticalAccountingOptionswindow,thenthelookupwindowwill displayonlythosecodesthathaveavalidcombinationwiththecodesyou havealreadyselectedforthetransaction. RefertoEnteringanalysisinformationforreceivablesdocumentsformore informationaboutenteringanalysisinformation. Unapplyingadocument Whenyouunapplypostedcreditdocuments,returnsandpayments,entries relatingtotermstaken,writeoffs,realizedgainorlossarereversed.You mustenteranalysisinformationforthesedistributionaccountsifsuch accountsarelinkedtoanaccountclass.Youcanenteranalysisinformation intheAnalyticalApplySalesDocumentswindowwhichwillopenwhenyou chooseOKintheApplySalesDocumentswindow. Theanalysisinformationenteredfordistributionaccountsrelatingtoterms taken,writeoffs,realizedgainorlosswillbevalidatedbeforethese entriesareposted.ErrorsdetectedwillbedisplayedintheAnalytical AccountingValidationLog. RefertoPostingtransactionswithanalysisinformationformore information. YoucanclosetheApplySalesDocumentwindowonlyafterenteringall requiredanalysisinformationforthedistributionaccountslinkedtoan accountclass. Applyingunpostedcreditmemos,returnsandpayments Youcanenteranalysisinformationforcreditmemos,returns,andpayments appliedintheReceivablesTransactionEntryandCashReceiptsEntrywindows intheAnalyticalReceivablesTransactionEntryorAnalyticalCashReceipts Entrywindowsrespectively.TheAnalyticalReceivablesTransactionEntryor AnalyticalCashReceiptsEntrywindowswillopenwhenyouselectOKinthe ApplySalesDocumentswindow. IfyouhavecreatedanalysisinformationfortheAccountsReceivableaccount intheReceivablesTransactionEntryorCashReceiptsEntrywindowspriorto applyingthecreditmemo,returnorpayment,suchinformationwillbe deletedifdistributionsarecreatedfortermstaken,writeoffs,realized gainorloss.Youwillhavetore-enteranalysisinformationforthe AccountsReceivableaccount. Unapplyingunpostedcreditmemos,returnsandpayments Beforeposting,ifyouunapplyunpostedcreditmemos,returnsandpayments, intheApplySalesDocumentswindow(Transaction>>Sales>>Transaction Entry>>ApplyorTransactions>>Sales>>CashReceipts>>Apply), theanalysisinformationenteredforthedistributionaccountsrelatingto termstaken,writeoffsandrealizedgainorlossaccountswillbedeleted. Voidingorwaivingdocumentswithanalysisinformation Ifyoumakechangestothetermstakenorwriteoffamountbeforevoidinga creditdocumentintheApplySalesDocumentswindow(Transactions>>Sales >>Apply),extradistributionsmaybecreated.Aftervoiding,default codeswillbeloadedforthedistributionsthathavebeencreated. TheAnalyticalTransactionEntrywindowcannotbeopenedpriortovoidinga documentintheReceivablesPostedTransactionMaintenancewindow. TheAnalyticalAccountingPostingJournalswillbeprintedalongwiththe MicrosoftDynamicsGPreports,ifyou’veselectedtheoptionunderPosting Setup. Thisreportwilldisplayallanalysisinformationrelatingtothevoided transaction. EnteringanalysisinformationforNSFcharges WhenyoumarkacheckasNonSufficientFunds(NSF)intheReceivables PostedTransactionMaintenancewindow(Transactions>>Sales>>Posted Transactions),analysisinformationmayhavetobeenteredfordistribution accountsrelatingtotheNSFCharge,ifsuchaccountsarelinkedtoan accountclass. WhenyouchooseOKintheAutoPostNSFDebitChargewindow,theAnalytical AutoPostNSFDebitChargewindowwillopendisplayingthefirstofthe distributionaccountsrelatingtotheNSFChargethatislinkedtoan accountclass(asperthedistributionsequence). RefertoEnteringanalysisinformationforreceivablesdocumentsformore informationaboutenteringanalysisinformation. IftheAnalyticalAutoPostNSFDebitChargewindowhasbeenopenedatleast once,youcanopenitanytimethereafterfromtheAdditionalmenu.Choose Additional>>AnalyticalTransactionorCTRL+Tbeforethedistributions areposted. TheanalysisinformationenteredfordistributionaccountsrelatingtoNSF chargeswillbevalidatedbeforetheseentriesareposted.Errorsdetected willbedisplayedintheAnalyticalAccountingValidationLog. RefertoPostingtransactionswithanalysisinformationformore information. YoucanclosetheAutoPostNSFDebitChargeswindowonlyafterenteringall requiredanalysisinformationforthedistributionaccountslinkedtoan accountclass. Analysisinformationthatexistsforthecashreceiptwillbecopied,except forthebalancetypewhichwillbereversed. RefertoVoidingorwaivingdocumentswithanalysisinformationformore informationaboutvoidingdocuments. Validatingtransactionsandcorrectingerrors Youcanusethefollowingwindowstovalidateatransaction.Fromthe Additionalmenu,chooseAdditional>>RunValidationorCTRL+T: ReceivablesTransactionEntry CashReceiptsEntry ApplySalesDocuments AutoPostNSFDebitCharge RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. Iferrorsaredetectedinthetransaction,theAnalyticalAccounting ValidationLogwindowwillopen,displayingallerrorsdetectedbythe validationroutine. YoucanselectView>>IncompleteorErroneousDistributions,tobrowse thedistributionaccountsintheAnalyticalTransactionEntrywindowthat areincompleteorhaveerrors. TocorrectanAnalyticalAccountingerror,double-clickontheerrortoopen therelevantAnalyticalTransactionEntrywindow.Thespecificdistribution inwhichtheerrorexistsisdisplayed. Postingtransactionswithanalysisinformation WhenyoupostatransactionfromtheReceivablesTransactionEntryorthe CashReceiptsEntrywindow,avalidationwilltakeplace. Also,whenyouclosetheApplySalesDocumentsorAutoPostNSFDebitCharge window,analysisinformationcreatedforthetransaction/documentwillbe validated. Inadditiontoanalysisinformation,MicrosoftDynamicsGPdataalsowillbe validatedbeforethetransactionisposted. Iferrorsarefoundwhilepostingatransaction,thetransactionwillnotbe posted.TheAnalyticalAccountingValidationLogwindowwillopen,listing theMicrosoftDynamicsGPerrorsfirstandthentheAnalyticalAccounting errors. WerecommendthatyouresolvetheMicrosoftDynamicsGPerrorsfirst,and thentheAnalyticalAccountingerrors. TocorrectanAnalyticalAccountingerror,double-clickontheerrortoopen therelevantAnalyticalTransactionEntrywindow.Thespecificdistribution inwhichtheerrorexistsisdisplayedwhichyoucanthencorrect. TheAnalyticalPostingJournalwillbeprinted,alongwiththeMicrosoft DynamicsGPPostingreportsifspecifiedunderPostingSetup. Postingabatchwithanalysisinformation WhenyoupostabatchfromReceivablesManagement,avalidationwilltake placeforallthetransactionssavedinthebatch.MicrosoftDynamicsGPand AnalyticalAccountingtransactionswithouterrorswillbepostedandthe AnalyticalPostingJournalwillbeprinted,alongwiththeMicrosoft DynamicsGPreportsifspecifiedinthePostingSetupwindow.Iferrorsare foundduringthevalidationprocess,theAnalyticalAccountingValidation Logreportwillbeprintedlistinganalysiserrorsforthetransactionsin thebatchbeingposted.Youcancorrecttheerrorsbymodifyingthe transactionsinthewindowwherethetransactionoriginatedfrom. Ifyoudeleteasingleorrecurringusebatchoratransactionwithinsuch batches,theanalysisinformationenteredforthetransactionsinthebatch orforthetransactionalsowillbedeleted. YoucansaveatransactioninabatchwithAnalyticalAccountingerrorsbut cannotpostthetransaction. Forarecurringbatch,theanalysisinformationofthebatchlastposted willberetainedandwillupdateeachsubsequentbatchthatisposted, unlesschangesaremadetotheanalysisinformationinthebatch. YoucanprinttheAnalyticalAccountingEditListandAnalyticalAccounting ValidationLogReportalongwiththeMicrosoftDynamicsGPEditListfora selectedbatchbychoosingtheprintericonbutton. WhenyouprinttheAnalyticalPostingJournal,detailedanalysisinformation ofallaccountswillbeprintedincludingaccountswitherrors.The AnalyticalValidationLogreportdetailingallAnalyticalAccountingerrors alsowillbeprinted.YoucancorrectAnalyticalAccountingerrorsby openingthebatchandthencorrectingeachofthetransactionsthathave errors. PostingthroughortoGeneralLedger Ifyou’vemarkedthefollowingoptions,individualtransactionsandbatches postedfromReceivablesManagementwillautomaticallyupdatetheappropriate postingaccountsinGeneralLedger,iftherearenoAnalyticalAccounting andMicrosoftDynamicsGPerrors. PostthroughGeneralLedgerfilesunderPostingSetup(Administration>> Setup>>Posting>>Posting) PostthroughtoGeneralLedgerforTrxPosting(Administration>>Setup >>Company>>AnalyticalAccounting>>Setup) Whilepostingindividualandbatchtransactions,errorsmightexistin AnalyticalAccountingorMicrosoftDynamicsGPinformationthatpreventthe transactionorbatchfromupdatingtheappropriatepostingaccountsin GeneralLedger.Forexample,defaultcodesmaynothavebeenassignedfor requiredtransactiondimensionsintheaccountclasstowhichthe distributionaccountsofFixedorVariableaccountsarelinked.The transactionorbatchwillupdateGeneralLedger. YoumustcorrecttheerrorsinthetransactionorbatchinGeneralLedger fromtheTransactionEntrywindow(Transactions>>Financial>>General) beforethepostingaccountscanbeupdated. ThetransactionandbatchwillupdateReceivablesManagement.Youcanview analysisinformationthatoriginatedforthetransactionorbatchin ReceivablesManagementfromtherelevantInquirywindows. TheAnalyticalAccountingandMicrosoftDynamicsGPerrorswillbedisplayed intheAnalyticalAccountingValidationLogReportwhichwillprintafter thetransactionorbatchupdatesReceivablesManagement. ViewinganalysisinformationinReceivablesManagement YoucanviewanalysisinformationenteredfortransactionsinReceivables ManagementintheAnalyticalReceivablesTransactionInquiryZoomwindow. TheAnalyticalInquirywindowwilldisplayonlydistributionaccountsofa documentthatarelinkedtoanaccountclass. ToviewanalysisinformationinReceivablesManagement: OpentheAnalyticalReceivablesTransactionInquiryZoomwindow. (Inquiry>>Sales>>TransactionbyCustomer/TransactionbyDocument >>Additional>>AnalyticalTransaction) WhentheAnalyticalTransactionInquirywindowopens,allanalysisinformationcreatedforadistributionaccountwillbedisplayed. Thefirstdistributionaccountofthedocumentlinkedtoanaccountclassis displayed.Enterorselectadistributionnumbertoviewanalysis informationofotherdistributionaccounts. Note IfyouselectaspecificaccountintheReceivablesDistributionInquiryZoom,theAnalyticalPostingInquirywindowwilldisplayanalysisinformationrelatingtosuchaccount. TheDocumentTypeandNumberfieldsdisplayvaluesfromtheReceivablesTransactionInquiryzoomorCashReceiptsInquiryzoom. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamount intheoriginatingorfunctionalcurrencybasedontheoptionyouhave chosenintheCurrencyView.Clicktheexpansionbuttontoview multicurrencyinformationiftheoriginatingcurrencydiffersfromthe functionalcurrency. TheDocumentDatefielddisplaysthedateofthedocumentfromthe ReceivablesTransactionInquiryzoomorCashReceiptsInquiryZoom. TheCompanyIDfielddisplaystheIDofthecurrentcompany. ChooseExpandtodisplayallanalysisinformationenteredforthe distributionaccountinthelistwindow.Thisincludesassignments, referenceinformationenteredperassignment,transactiondimensionsand theircodes. ClickCollapsetodisplayonlyassignmentsandreferenceinformationentered perassignmentforthedistributionaccount. Youalsocanviewallinformationenteredforeachassignmentorjust referenceinformationthatmayexist.Choosetheplusbutton(+)available nexttoeachassignmenttoviewallanalysisinformationenteredforan assignmentorchoosetheminusbutton(-)toviewonlyreferenceinformation thatmayexist. Chapter8:SalesOrderProcessingTransactions Youcanenterandviewanalysisinformationsuchasassignments,transaction dimensioncodesandreferenceinformationfortransactionsenteredinSales OrderProcessing.Youcansavetransactionswithanalysisinformationina SalesBatchbeforeposting.Theanalysisinformationyouhaveenteredwill bevalidatedbeforeposting. YoucanenteranalysisinformationinSalesOrderProcessingonlyfromthe SalesTransactionEntrywindow(Transactions>>Sales>>Sales TransactionEntry)andforSalesInvoicesandSalesReturns. YoucanopentheAnalyticalTransactionEntrywindowonlyifAnalytical Accountinghasbeenactivated.RefertoActivatingAnalyticalAccounting formoreinformation. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforaninvoiceorreturn Analysisinformationinre-createddistributions Analysisinformationfordepositsreceivedagainstanorder Deletionofanalysisinformationoninvoicetransfertobackorder Validatingtransactionsandcorrectingerrors Postinganinvoiceorreturnwithanalysisinformation Postingabatchwithanalysisinformation PostingthroughtoGeneralLedgerfortransactionposting Voidingtransactionswithanalysisinformation Viewinganalysisinformationforsalesdocuments CopyingAnalyticalAccountingInformationforSalesOrder Enteringanalysisinformationforaninvoiceorreturn YoucanenteranalysisinformationforaninvoiceorreturnintheSales TransactionEntrywindow(Transactions>>Sales>>SalesTransaction Entry)usingtheAnalyticalSalesTransactionEntrywindow. IfyoudeleteaninvoiceorreturnfromtheSalesTransactionEntrywindow, theanalysisinformationthatexistsforthedocumentwillalsoberemoved. Ifyoudeleteanitemnumberfromaninvoiceorreturn,analysisinformation thatexistsfordistributionaccountsrelatingtotheitemnumberdeleted willalsoberemoved. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Ifthe transactiondateisaltered,analysisinformationcreatedpreviouslyis deletedwhenthedistributionsarerecreated. IfyouselectDefaultintheSalesDistributionEntrywindow,allanalysis informationcreatedfortheinvoiceorreturnwillbedeleted. TheAnalyticalSalesTransactionEntrywindowwillopenautomaticallywhen youpressTABfromafieldintheSalesDistributionEntrywindow,inthe followinginstances: IftheaccountislinkedtoanaccountclassandtheAnalyticalSales TransactionEntrywindowhasnotbeenopenedevenoncefortheaccount. Ifchangesaremadetoadistributionlinethataffectsanalysisinformation enteredpreviouslyforsuchline.Theseincludechangingtheaccountor amountordebittocreditorviceversa,asthiswilldeletethepreviously enteredanalysisinformationandcreateasingleassignmentof100percent. Inaninvoice,youcanenteranalysisinformationfortheCostofGoodsSold (COGS)andInventoryaccountsoftherelevantitemnumbersenteredinthe invoice,ifsuchaccountsarelinkedtoanaccountclasseventhoughthese accountsarenotdisplayedintheSalesDistributionEntrywindow.However, youcannotcreateassignmentsforsuchaccountsastheamountthatupdates theseaccountscanbedeterminedonlyaftertheinvoiceisposted. Toenteranalysisinformationforaninvoiceorreturn: OpentheAnalyticalSalesTransactionEntrywindow. (Transactions>>Sales>>SalesTransactionEntry>>Analytical Accountingbutton) (Transactions>>Sales>>SalesTransactionEntry>>Additional>> AnalyticalTransactionorCTRL+T) (Transactions>>Sales>>SalesTransactionEntry>>Distributions >>AnalyticalAccountingbutton) (Transactions>>Sales>>SalesTransactionEntry>>Distributions >>Additional>>AnalyticalTransactionorCTRL+T) Thedistributionaccountsofeachitemnumberlinkedtoanaccountclassthatyouenteronaninvoiceorreturn,willbeaddedtothetotaldistributionsintheAnalyticalSalesTransactionEntrywindowonlyafteryoutabofftheLineItemintheSalesTransactionEntrywindow. TheAnalyticalSalesTransactionEntrywindowwillopenonlyifyouhavespecifiedatleastoneitemnumberwithaunitcostmorethanzerofortheinvoiceorreturn. ThefirstofthedistributionaccountsintheSalesDistributionEntry windowthatislinkedtoanaccountclassisdisplayedintheAnalytical SalesTransactionEntrywindow.Toviewotherdistributions(otherthanthe COGSandInventoryAccountsincaseofaninvoice)enterorselecta distributionnumberorusethebrowsebuttons. YouviewaspecificdistributionaccountlinkedtoanaccountclassbyselectingthataccountpriortoopeningtheAnalyticalSalesTransactionEntrywindow. ThesequenceofdistributionsintheAnalyticalSalesTransactionEntrywindowmaynotcorrespondtothesequenceintheSalesDistributionEntrywindowasonlyaccountslinkedtoanaccountclassaredisplayedhere. IfonlytheCOGSandInventoryAccountsofanInvoicearelinkedtoanaccountclass,theAnalyticalSalesTransactionEntrywindowwillopendisplayingthefirstofsuchaccountslinkedtoanaccountclass. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformationfortransactions. ChooseCogs/InvtoviewtheCostofGoodsSoldandInventoryaccountsofan Invoice,linkedtoanaccountclass.Thefirstoftheseaccountslinkedto anaccountclasswillbedisplayedwhenyouselectthisbutton.Thesequence inwhichtheCostofGoodsSoldandInventoryAccountswillbedisplayed willbebasedontheorderinwhichitemnumbersaredisplayedonthe invoice.ToviewtheotherCOGSandInventoryAccountslinkedtoanaccount class,youcanusethebrowsebuttonorenterorselectthedistribution numberintheDistributionfield.ChooseMAINtoviewthedistribution accountsdisplayedintheSalesDistributionEntrywindowthatarelinkedto anaccountclass. Foraninvoice,sincetheamountthatupdatestheCOGSandInventoryaccountscanbedeterminedonlyaftertheinvoiceisposted,thefieldsandscrollingwindowsrelatingtoamountandassignmentwillnotbeavailableinrelationtotheseaccounts. TheCogs/Invbuttonwillnotbeavailableinthefollowinginstances: IftheCOGSandInventoryaccountsarenotavailableundertherelevantsetup,suchasItemorCustomerorPostingoriftheseaccountsarenotlinkedtoanaccountclass. Ifnon-inventoryitemsareenteredonaninvoice. Iftheunitcostfordrop-shipitemsintheSalesTransactionEntrywindowiszero. IftheitemnumberselectedintheSalesTransactionEntrywindowismarkedasismarkedasMiscCharges/Services/FlatFeeonItemMaintenancewindow IftheDocumentTypeofthetransactionisReturn.InthecaseofSalesReturns,theCOGSandInventoryaccountswillformpartofthedistributionaccountsdisplayedintheSalesDistributionEntrywindow.Youcanenteranalysisinformationincludingassignmentsfortheseaccountsifrequired,inthesamemannerastheotherdistributionaccountsdisplayedintheSalesDistributionEntrywindowthatarelinkedtoanaccountclass. IfyouhaveenteredKitItemsonaninvoice,additionordeletionofacomponentitemfromtheSalesKitOptionswindow(Transactions>>Sales>>SalesTransactionEntry>>ItemNumberexpansionbutton>>Kits)mayincreaseordecreasetheCOGSandInventoryAccountsdisplayedintheAnalyticalSalesTransactionEntrywindow,iftheaccountsconcernedarelinkedtoanaccountclass. IfyouhaveenteredKitItemsonareturn,additionofacomponentitemintheSalesKitOptionswindowmayincreasetheCOGSandInventoryAccountsdisplayedintheAnalyticalSalesTransactionEntrywindow,iftherelevantaccountsarenotalreadydisplayedandarelinkedtoanaccountclass. ChooseOKtoclosethewindow.Avalidationwilltakeplacewhenyouchoose OK.RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. ChooseSavetosavetheanalysisinformationyou’veenteredandclearthe window.AvalidationtakesplacewhenyouchooseSaveintheAnalytical SalesTransactionEntrywindow.RefertoValidatingtransactionsand correctingerrorsformoreinformationaboutvalidation. Youcansavetheanalysisinformationwitherrorsorwithoutupdatingchangesmadetotheaccountclass. ChooseCleartocleartheinformationyouhaveenteredbutnotsaved. ChooseValidatetovalidatetheanalysisinformationofthedistribution accountdisplayedinthewindow.Ifchangesaremadetotheaccountclassor errorsarefoundduringthevalidationprocess,theAnalyticalAccounting ValidationLogwindowwillopendisplayingthechangesanderrors.Double clickanAnalyticalAccountingerrortoopentheAnalyticalSales TransactionEntrywindowwherethedistributionaccountcomprisingtheerror isdisplayed. YoucanselectView>>IncompleteorErroneousDistributions,tobrowsethroughthedistributionaccountswhichareincompleteorhaveerroneousinformation. ClicktheprintericonbuttontoprinttheAnalyticalAccountingEditList whichwilldisplayanalysisinformationofthedistributionaccount currentlydisplayedorforalldistributionaccountsoftheInvoiceor Returnthatarelinkedtoanaccountclass.TheAnalyticalAccounting ValidationLogreportdescribingtheAnalyticalAccountingerrors,ifany, inbriefisalsoprinted. Analysisinformationinre-createddistributions Beforepostingasalesinvoice/return,ifchangeslistedbelowaremadeto theexistinginformationforthesedocuments,distributionswillbe re-created.Thiswillautomaticallydeletetheexistinganalysisinformation fordistributionaccountslinkedtoanaccountclass.Analysisinformation enteredforCOGSandInventoryaccountsofaninvoiceisnotaffectedby thesechanges. Windowname Changesmade SalesTaxSummaryEntryorSalesLineItemTaxDetailEntrywindow ChangeinordeletionofaTaxDetailID,TotalSalesandTaxAmount;SelectingDefaultorDeleteintheSalesTaxSummaryEntrywindow. SalesItemDetailEntrywindow ChangestotheShippingaddressorthetaxscheduleassignedtothisaddress;ChangetotheItemTaxScheduleID;ChangeinSalespersonID;Distributionswillalsobere-creatediftheTotalInvoiceorSalesAmountisaltered. SalesPaymentTermsEntrywindow ChangeinDiscountPercent;ChangeinTermsDiscountAvailableorPaymentTermsAmount(thiswillre-createdistributionsifDefaultisselectedintheSalesDistributionEntrywindowafterchanges);DeletionofTermsDiscountorPaymentTermsPercentorAmount;(wouldre-createdistributionsifDefaultisselectedintheSalesDistributionEntrywindowafterchanges) SalesCustomerDetailEntrywindow Changestothepaymentterms. SalesTaxScheduleEntrywindow Changeintaxschedules;Changeintaxstatus.Forexample,fromtaxabletonontaxable;PricelevelintheSalesItemDetailEntrywindow;ChangeinUnitPrice,ExtendedPrice,andInvoiceQuantityintheSalesItemDetailEntrywindoworSalesTransactionEntrywindow. SalesCommissionEntrywindow ChangeinSalespersonID,PercentofSale(providedtheTerritoryIDremainsunchanged),CommissionPercentandCommissionAmount;AdditionordeletionofaSalespersonID;Deletionofcommissiondistributions;AmendingordeletingCommissionSaleAmount. SalesPaymentEntrywindow ChangeinCashAccountintheCheckbookSetupwindow.Thedistributionswillbere-createdonlyifyouselectDefaultintheSalesDistributionEntrywindow;DeletionoflineitemintheSalesTransactionEntrywindow. SalesTradeDiscountEntrywindow ChangeinTradeDiscount. SalesTransactionEntrywindow AmendingtheTradeDiscountpercentoramount;Inclusionordeletionoffreightandmiscellaneouscharges;ChangeordeletionofAmountReceived;EnteringordeletinganamountontheTermsDiscountTakenfield. SalesTransactionEntrywindow(SelectingtheShowDetailoption) Changestothefollowingcouldre-createdistributions:InvoiceQuantity,UnitPrice,ExtendedPrice,EnteringaMarkDownintheSalesMarkdownEntrywindow,PriceLevel,ShipToAddressID(affectstaxcalculations),SiteID(affectstaxcalculationsifmethodofshippingisPickup). InthecaseofanalysisinformationenteredfortheCOGSandInventoryAccountsofaReturn,thefollowingchangespriortopostingwouldresultinare-creationofsuchinformation: Windowname Changesmade SalesItemDetailEntryorLineItemDetailEntrywindows ChangeinUnitCost SalesReturnedQuantitiesEntrywindow ChangestoReturnQuantityType.Forexample,splittingthequantityreturnedbetweenReturnedandDamaged,aftertheentirequantitywasassignedtoReturned. SalesKitOptionswindowIfKitItemsareenteredontheReturn DeletionofacomponentitemfromtheSalesKitOptionswindow.Thiscouldresulteitherinachangeindistributionamountorremovalofadistributionaccount. Analysisinformationfordepositsreceivedagainstanorder ForadepositreceivedagainstanorderintheSalesTransactionEntry window,distributionsrelatingtothedepositwillbecreatedinGeneral Ledgeraftertheorderissaved. Ifthedistributionaccountsrelatingtothedepositarelinkedtoan accountclass,youcanenteranalysisinformationforsuchaccountsonlyin theGeneralLedger.RefertoEnteringanalysisinformationforGeneral Ledgertransactionsformoreinformation. YoucannotopentheAnalyticalSalesTransactionEntrywindowfromtheSales TransactionEntryorSalesPaymentEntrywindows.Also,novalidationwill takeplacewhenyousavetheorder. Deletionofanalysisinformationoninvoicetransfertobackorder Ifyoutransferaninvoicequantityfullyorpartlytoabackorder,the analysisinformationenteredforthedocument,includingtheCOGSand Inventoryaccounts,willbedeleted. Youwillhavetore-createanalysisinformationwhenthebackorderis subsequentlyconvertedtoaninvoice. RefertoEnteringanalysisinformationforaninvoiceorreturnformore informationaboutenteringanalysisinformation. Validatingtransactionsandcorrectingerrors Youcanvalidateanalysisinformationenteredforaninvoiceorreturnin theSalesTransactionEntrywindow,beforepostingbychoosingCTRL+Tor Additional>>RunValidation. RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. Iferrorsaredetectedinthedocument,theAnalyticalAccountingValidation Logwindowwillopendisplayingallerrorsdetectedbythevalidation routine. YoucanselectView>>IncompleteorErroneousDistributions,tobrowse throughthedistributionaccountsintheAnalyticalSalesTransactionEntry windowwhichareincompleteorhaveerroneousinformation. TocorrectanAnalyticalAccountingerror,double-clickintherelevant errortoopentheAnalyticalSalesTransactionEntrywindow.Thespecific distributioninwhichtheerrorexistsisdisplayedwhichyoucanthen correct. Postinganinvoiceorreturnwithanalysisinformation WhenyoupostaninvoiceorreturnfromtheSalesTransactionEntrywindow, analysisinformationcreatedforthedocumentwillbevalidated. InadditiontoAnalyticalAccountinginformation,MicrosoftDynamicsGPdata willalsobevalidatedbeforethetransactionisposted. Iferrorsarefoundwhilepostingtheinvoiceorreturn,thetransaction willnotbeposted.TheAnalyticalAccountingValidationLogwindowwill openlistingtheMicrosoftDynamicsGPerrorsfirstandthentheAnalytical Accountingerrors. WerecommendthatyouresolvetheMicrosoftDynamicsGPerrorsfirstand thentheAnalyticalAccountingerrors. TocorrectanAnalyticalAccountingerror,double-clickontherelevant errortoopentheAnalyticalSalesTransactionEntrywindow.Thespecific distributioninwhichtheerrorexistsisdisplayedwhichyoucanthen correct. TheAnalyticalPostingJournalwillbeprintedalongwiththeMicrosoft DynamicsGPPostingreportsifspecifiedunderPostingSetup. Postingabatchwithanalysisinformation YoucanenteranalysisinformationfortransactionswithinaSalesBatch (Transactions>>Sales>>SalesBatches).RefertoEnteringanalysis informationforaninvoiceorreturnformoreinformation. YoucanprinttheAnalyticalAccountingEditListandAnalyticalAccounting ValidationLogReport(iferrorsexistinanalysisinformation)alongwith theMicrosoftDynamicsGPEditListforaselectedbatchbychoosingthe printericonbutton. WhenyoupostabatchfromSalesOrderProcessing,avalidationwilltake placeforallthetransactionssavedinthebatch.RefertoValidating transactionsandcorrectingerrorsformoreinformationaboutthe validationprocess.MicrosoftDynamicsGPandAnalyticalAccounting transactionswithouterrorswillbepostedandtheAnalyticalPosting Journalwillbeprinted,ifspecifiedunderPostingSetupalongwiththe MicrosoftDynamicsGPreports.Iferrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogreportwillbeprinted listinganalysiserrorsforthetransactionsinthebatchbeingposted.You cancorrecttheerrorsbycorrectingthetransactionsinthewindowwhere thetransactionoriginated. Ifyoudeleteabatchoratransactionwithinabatch,theanalysis informationenteredforthetransactionsinthebatchorforthetransaction willalsobedeleted. YoucansaveatransactioninabatchwithAnalyticalAccountingerrorsbut cannotpostthetransaction. WhenyouprinttheAnalyticalPostingJournal,detailedanalysisinformation ofallaccountswillbeprinted.Thiswouldincludeevenaccountswith errors.TheAnalyticalValidationLogreportdetailingallAnalytical Accountingerrorswillalsobeprinted.YoucancorrectAnalytical Accountingerrorsbyopeningthebatchandthencorrectingeachofthe transactionsthathaveerrors. PostingthroughtoGeneralLedgerfortransactionposting Ifyouhavemarkedthefollowingoptions,individualtransactionsand batchespostedfromSalesOrderProcessingwillautomaticallyupdatethe appropriatepostingaccountsinGeneralLedgeriftherearenoAnalytical AccountingandMicrosoftDynamicsGPerrors. PostthroughGeneralLedgerfilesunderPostingSetup(Administration>> Setup>>Posting>>Posting);and PostthroughtoGeneralLedgerforTrxPosting(Administration>>Setup >>Company>>AnalyticalAccounting>>Setup) Whilepostingindividualandbatchtransactions,AnalyticalAccountingor MicrosoftDynamicsGPerrorsmayexistwhichwouldpreventthetransaction orbatchfromupdatingtheappropriatepostingaccountsinGeneralLedger. Forexample,defaultcodesmaynotbeassignedforRequiredTransaction DimensionsintheaccountclasstowhichthedistributionaccountsofFixed orVariableaccountsarelinked.Thetransactionorbatchwillupdatethe GeneralLedger.Youmustcorrecttheerrorsinthetransactionorbatchin GeneralLedgerfromtheTransactionEntrywindow(Transactions>> Financial>>General)beforethepostingaccountscanbeupdated. TheAnalyticalAccountingandMicrosoftDynamicsGPerrorswillbedisplayed intheAnalyticalAccountingValidationLogReportwhichwillprintafter thetransactionorbatchupdatesSalesOrderProcessing. ThetransactionandbatchwillupdateSalesOrderProcessing.Youcanview analysisinformationthatoriginatedforthetransactionorbatchinSales OrderProcessingfromtherelevantInquirywindows. Voidingtransactionswithanalysisinformation IfyouvoidanunpostedinvoiceorreturnintheSalesTransactionEntry window,theanalysisinformationenteredforthedocumentwillbedeleted. IfyouvoidaninvoiceorreturnpostedfromSalesOrderProcessingfrom ReceivablesPostedTransactionMaintenancewindow(Transactions>>Sales >>PostedTransactions),analysisinformationcreatedfortheinvoiceor returnwillbecopiedforeachdistributionaccountlinkedtoanaccount classwiththeexceptionofthebalancetype.TheBalancetypeofeach distributionaccountwillbereversed. Youcanviewtheanalysisinformationforavoidedinvoiceorreturnin GeneralLedger(Transactions>>Financial>>General). IfpostedfromtheGeneralLedger,theanalysisinformationofthevoided documentcanbeviewedbyzoomingtothesourcedocumentintheFinancial Inquirywindows.YoucanopentheAnalyticalAccountingInquirywindowfrom theReceivablesTransactionInquiryZoomchoosingAdditional>>Analytical TransactionorCTRL+T). Viewinganalysisinformationforsalesdocuments YoucanusetheAnalyticalSalesTransactionInquiryZoomwindowtoview analysisinformationthatyouhaveenteredforinvoicesorreturnsinSales OrderProcessing. Toviewanalysisinformationforsalesdocuments: OpentheAnalyticalSalesTransactionInquiryZoomwindow. (Inquiry>>Sales>>SalesDocuments>>ClickDocumentNumberlink >>Additional>>AnalyticalTransaction) (Inquiry>>Sales>>SalesDocuments>>ClickDocumentNumberlink >>Distributions>>Additional>>AnalyticalTransaction) TheAnalyticalSalesTransactionInquiryZoomwindowdisplaysalltheanalysisinformationyou’vecreatedforadistributionaccount. Thefirstdistributionaccountofthedocumentlinkedtoanaccountclassis displayed.Toviewanalysisinformationofotherdistributionaccounts, enterorselectadistributionnumber. IfyouselectaspecificaccountintheSalesDistributionInquiryZoom,theAnalyticalSalesInquirywindowwilldisplayanalysisinformationrelatingtosuchaccount. TheinformationintheDocumentTypeandNumberfieldwillcorrespondtothatintheSalesTransactionInquiryzoom. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamount intheoriginatingorfunctionalcurrencybasedontheoptionyouhave chosenintheCurrencyView.Clicktheexpansionbuttontoview multicurrencyinformationiftheoriginatingcurrencydiffersfromthe functionalcurrency. TheDocumentDatedisplaysthedateofthedocumentandwilldefaultfromtheSalesTransactionInquiryzoom. TheCompanyIDfielddisplaystheIDofthecurrentcompany. ClickExpandtodisplayallanalysisinformationenteredforthe distributionaccountinthelistwindow.Thiswouldcompriseassignments, referenceinformationenteredperassignment,transactiondimensionsand theircodes. ClickCollapsetodisplayonlyassignmentsandreferenceinformationentered perassignmentforthedistributionaccount. Youalsocanviewallinformationenteredforeachassignmentorjust referenceinformationthatmayexist.Choosetheplusbutton(+)available nexttoeachassignmenttoviewallanalysisinformationenteredforan assignmentorchoosetheminusbutton(-)toviewonlyreference information. ChooseOKtoclosethewindow. CopyingAnalyticalAccountingInformationforSalesOrder UsetheCopyaSalesOrderwindowtocopyanalyticalaccountinginformation fromonesalesorderdocumenttoanother. Tocopyanalyticalaccountinginformationforsalesorder: OpenCopyaSalesOrderwindow. (Transaction>>Sales>>SalesTransactionEntry>>enterasalesorder number>>Actions>>Copy) ChooseActionsandselectcopytoopentheCopyaSalesOrderwindow. Enterorselectthedocumentnumberforthedocumentthatcontainsthe informationtocopy. MarktheCopyAnalyticalAccountinginformationoption. Choosecopy.Theanalyticalaccountinginformationiscopiedfromthe originatingdocumenttothenewdocument. Note AnalyticalAccountinginformationiscopiedonlyforinvoiceandReturntypeofdocumentsintheSalesTransactionEntrywindow. Chapter9:InventoryTransactions UsethefollowinginformationtocreateanalysisinformationforInventory transactions. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforinventorytransactions Enteringanalysisinformationduringtransferentry Enteringanalysisinformationforvarianceaccounts Postinginventorytransactions Batchposting Seriesposting PostthroughGeneralLedgerfortransactionposting Viewinganalysisinformationforinventorytransactions Enteringanalysisinformationforinventorytransactions Youcanenteranalysisinformationsuchastransactiondimensioncodesand referenceinformationforinventorytransactions.Youcannotcreate assignmentsastheExtendedCostofadocumentcanbedeterminedonlyafter thetransactionisposted. Youcanenteranalysisinformationforadjustment,varianceandtransfer transactionsandviewtheItemNumber,SiteID,BalanceType,andthe Inventoryand/orOffsetaccounts.Thisispossibleonlyifsuchaccountsare linkedtoanaccountclassintheAnalyticalItemTransactionEntry, AnalyticalItemTransferEntryorAnalyticalStockCountEntrywindow. TheAnalyticalItemTransaction/Transfer/StockCountEntrywindowwillonly displaythosedistributionaccountsattachedtoanitemnumberthatare linkedtoanaccountclass. ForInventorytransactions,theAnalyticalTransactionEntrywindowswill openwhenyouTABofftheItemlineintheItemTransaction,ItemTransfer orStockCountEntrywindows.Thiswillonlyhappenifoneorbothofthe distributionaccountsassociatedwiththeitemnumberarelinkedtoan accountclass,andifthewindowhasnotbeenpreviouslyopenedforsuch accounts. Ifyouaretrackinginventoryitemsbyserialorlotnumbers,theAnalytical TransactionEntrywindowwillopenautomaticallywhenyoupressTABonly afteryouclosetheItemSerial/LotNumberEntrywindow. IntheInventoryBatchEntrywindow,iftheoptionPosttoGeneralLedger isnotmarkedinthePostingSetupwindow(Administration>>Setup>> Posting>>Posting),theAnalyticalTransactionEntrywindowwillnotopen whenyouTABoffanitemlineintheItemTransactionorItemTransferEntry window. TheAnalyticalTransactionEntrywindowwillopenautomaticallyonlyonce exceptinthefollowinginstances. TheSiteIDischangedinthescrollingwindowoftheItemTransactionEntry window. TheFromand/orToSiteIDarechangedinthescrollingwindowintheItem TransferEntrywindow. Thequantityischangedfrompositivetonegativeorfromnegativeto positiveintheItemTransactionEntrywindow. Thevariancequantityischangedfrompositivetonegativeorfromnegative topositiveintheStockCountEntrywindow. ThedistributionaccountischangedintheDistributionwindow.Inthiscase theanalysisinformationthatyouenteredwillbedeleted. ChangeinquantitytypeintheItemTransferEntrywindow. YoucanalsoopentheAnalyticalTransactionEntrywindowfromtheItem TransactionorItemTransferorStockCountEntrywindowsandthe DistributionwindowsfromAdditional>>AnalyticalTransactionEntryorby usingCTRL+T. IfthequantityofanitemnumberintheItemTransactionorItemTransfer windowshasnotbeenspecified,theAnalyticalTransactionEntrywindowwill notopenautomaticallyfromAdditional>>AnalyticalTransactionEntryor usingCTRL+T. IntheStockCountEntrywindow,ifthevariancequantityiszero,the AnalyticalTransactionEntrywindowwillnotopenautomaticallyfrom Additional>>AnalyticalTransactionEntryorbyusingCTRL+T. IfyoudeletethequantityspecifiedforanitemnumberintheItem Transaction,ItemTransferorStockCountEntrywindows,theanalysis informationcreatedforsuchitemnumberalsowillbedeleted. Toenteranalysisinformationduringtransactionentry: OpentheAnalyticalItemTransactionEntrywindow. (Transactions>>Inventory>>TransactionEntry>>Analytical Accountingbutton) (Transactions>>Inventory>>TransactionEntry>>CTRL+Tor Additionalmenu>>Additional>>AnalyticalTransactionEntry) (Transactions>>Inventory>>StockCountEntry>>Analytical Accountingbutton) (Transactions>>Inventory>>StockCountEntry>>CTRL+T>> Additional>>AnalyticalTransactionEntry) TheAnalyticalItemTransactionEntrywindowdisplaysthefirstdistributionaccountoftheItemNumberselectedthatislinkedtoanaccountclass.Toviewotherdistributionsenterorselectadistributionnumber.Thedistributionlookupdisplaysalldistributionaccountsofthetransactionlinkedtoanaccountclass. TheAccountfieldwilldisplaythedistributionaccountforwhichanalyticalinformationisbeingentered.Thedescriptionoftheaccount,assetupintheAccountMaintenancewindow,willappearinthenextline.ClicktheAccountexpansionbuttontoopentheAccountEntrywindow. Thebalancetypeoftheaccount,whetherdebitorcredit,willbedisplayednexttotheaccount. IntheReferencefield,enterreferenceinformationfortheaccount. TheItemfieldwilldisplaytheitemnumberofthedistributionaccountforwhichyouareenteringanalysisinformation.ThiswillappearasadefaultvaluefromtheItemTransactionEntrywindow. TheSiteIDoftheitemnumberasdisplayedintheItemTransactionEntrywindowwillbedisplayed. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes, ifrequired.RefertoCreatinganaliasformoreinformation. ChooseDefaulttoloadthecurrentsetupinformationspecifiedforthe accountclassintheAccountingClassMaintenancewindowandcreateasingle assignment. TheTrxDimensionfielddisplaysTransactionDimensionsoftheaccountclasstowhichthedistributionaccountislinked.OnlyTransactionDimensionswhichhavebeensetasFixed,Required,orOptionalwillbedisplayed. TransactiondimensionswhicharesettoHideintheAccountingClassMaintenancewindowwillnotbedisplayed.RefertoSettingupanaccountclassformoreinformation. TheTrxDimensionDescriptionfielddisplaysthedescriptionofthetransactiondimension. Enterorselectanalphanumerictransactiondimensioncodeinthe Alphanumericcolumn.Youcanaddanewalphanumerictransactiondimension codeifyouhaveselectedtheCreateNewCodesOnTheFlyoptioninthe TransactionDimensionMaintenancewindow. Note TheAlphanumericcolumnisavailableonlyforanalphanumerictransactiondimension. ThedescriptionoftheAlphanumericTransactionDimensionCodeisdisplayedintheTransactionDimensionCodeDescriptionfield. EnteraTransactionDimensionCodeintheNumeric,Yes/NoorDatefieldif theTransactionDimensionisNumeric,BooleanorDate. Selectthetypeofaccountthatyouwanttobrowsethroughforeachitem numberenteredintheItemTransactionEntrywindow,fromthefollowing: AlltobrowsethroughtheInventoryandOffsetaccountsforeachitemnumberifitislinkedtoanaccountclass. InventorytobrowsethroughtheInventoryaccountofeachItemNumberifitislinkedtoanaccountclass. OffsettobrowsethroughtheOffsetaccountofeachitemnumberifitislinkedtoanaccountclass. Note TheRadioGroupwillfurtherfilteraccountsifyouselectView>>IncompleteorErroneousDist. ChooseOKtosaveandclosethewindow. ChooseSavetosavetheanalysisinformationyouhaveenteredandclearthe window. Youcansaveanalysisinformationwitherrors,butyoucannotpostthem. ChooseContratoswitchbetweentheinventoryaccountandtheoffsetaccount oftheitemnumberthatiscurrentlydisplayedintheAnalyticalItem TransactionEntrywindow.ThisispossibleonlyifboththeInventoryand Offsetaccountsofanitemnumberarelinkedtoanaccountclass. Ifonlyoneaccountofanitemnumberislinkedtoanaccountclass,amessageappearswhenyouselecttheContrabutton. ChooseValidatetovalidatethedistributiondisplayedinthewindow.If changesaremadetotheaccountclassinsetuporerrorsarefoundduring thevalidationprocess,theAnalyticalAccountingValidationLogwindowwill opendisplayingtheerrorsorchangesidentified.Youcanviewthechanges totheaccountclassbyselectingtheDefaultbuttonintheAnalyticalItem TransactionEntrywindow. Note AnalysisinformationwillalsobevalidatedifyouselectOKorSaveintheAnalyticalItemTransactionEntrywindow. Youcanchoosetosaveanalysisinformationwitherrorsorwithoutupdatingchangesmadetotheaccountclass. YoucanvalidateadocumentintheItemTransactionEntrywindowbyusingtheoptionsCTRL+RorAdditional>>RunValidation. RefertoValidatingtransactionsandcorrectingerrorsformoreinformationaboutvalidation. ChoosethePrintdrop-downtoprinttheAnalyticalAccountingEditlistfor thedistributioncurrentlydisplayedinthewindoworforalldistributions ofthetransactionlinkedtoanaccountclass.Iferrorsaredetected,the AnalyticalValidationLogisalsoprinted. IfyoudeleteatransactionintheItemTransactionwindow,theanalysis informationyouenteredforthetransactionwillbedeleted. Youcannotinsertordeletearow,orchangetheSiteIDordistribution accountsintheItemTransactionEntrywindowiftheAnalyticalItem TransactionEntrywindowisopen. Enteringanalysisinformationduringtransferentry YoucanenteranalysisinformationforinventorytransfersintheAnalytical ItemTransferEntrywindow. Toenteranalysisinformationduringtransferentry: OpentheAnalyticalItemTransferEntrywindow. (Transactions>>Inventory>>TransferEntry>>AnalyticalAccounting button) (Transactions>>Inventory>>TransferEntry>>CTRL+TorAdditional >>AnalyticalTransferEntry) Enterorselectthedistributionnumberforthedistributionaccount. TheCompanyIDfieldwilldisplaythecompanyinwhichthetransactionistakingplace. TheAccountfieldwilldisplaythedistributionaccountforwhichthe Analyticalinformationisbeingenteredandthebalancetypeoftheaccount, whetherdebitorcredit.Thedescriptionoftheaccount,assetupinthe AccountMaintenancewindow,willappearinthenextline.ClicktheAccount expansionbuttontoopentheMicrosoftDynamicsGPAccountEntrywindow. IntheReferencefield,enterreferenceinformationupto30charactersfor theaccountordistribution. Thebalancetypeoftheaccount,whetherdebitorcredit,willbedisplayednexttotheaccount. TheItemfieldwilldisplaytheitemnumberforthedistributionaccountforwhichyouareenteringanalysisinformation.ThiswillappearasadefaultvaluefromtheTransferEntrywindow. TheFromSiteIDandToSiteIDoftheItemNumberintheInventoryTransferEntrywindowaredisplayed. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes ifrequired.RefertoCreatinganaliasformoreinformation. ChooseDefaulttoloadthedefaulttransactiondimensioncodesifyou overwritethecodesofRequiredorOptionalAlphanumericTransaction Dimensionswhilecreatinganalysisinformation. Thetransactiondimensionsfortheaccountclasstowhichthedistribution accountislinkedaredisplayedinthescrollingwindow.Onlytransaction dimensionswhichhavebeensetasFixed,Required,orOptionalwillbe displayed.TransactiondimensionswhicharesettoHideintheAccounting ClassMaintenancewindowwillnotbedisplayed.RefertoSettingupan accountclassformoreinformation. EnterorselectatransactiondimensioncodeintheAlphanumericcolumn. EnteranumerictransactiondimensioncodeintheNumericfield. MarkorunmarktheYes/NocheckboxintheYes/Nocolumn. EnteradatetypetransactiondimensionsintheDatefield. ThedescriptionofthetransactiondimensionisdisplayedintheTransactionDimensionDescriptionfield. ThedescriptionofthealphanumerictransactiondimensioncodewillbedisplayedintheTransactionDimensionCodeDescriptionfield. Selectthetypeofaccountthatyouwanttobrowsethroughfromthe following: Alltobrowsethroughtheinventoryandoffsetaccountsforeachitemnumberifitislinkedtoanaccountclass. Inventorytobrowsethroughtheinventoryaccountofeachitemnumberifitislinkedtoanaccountclass. Offsettobrowsethroughtheoffsetaccountofeachitemnumberifitislinkedtoanaccountclass. ChooseContratoswitchbetweentheoffsetaccountandtheinventoryaccount oftheitemnumberthatiscurrentlydisplayedintheAnalyticalTransaction Entrywindow.Thisbuttonisavailableonlyifboththeinventoryandthe offsetaccountsforanitemnumberarelinkedtoanaccountclass. ChooseSavetosavetheanalysisinformationforthedistribution. ChooseCleartocleartheinformationyouhaveentered. ChooseValidatetovalidatethedistributiondisplayedinthewindow.You canalsovalidatetransactionsbychoosingCTRL+RorfromAdditional>>Run validation.RefertoValidatingtransactionsandcorrectingerrorsfor moreinformationaboutthevalidationprocess. ChoosethePrintdrop-downlisttoprintinformationforthedistribution displayedinthewindoworforalldistributions. IfyoudeleteatransactionintheInventoryTransferwindowtheanalysis informationyouenteredforthetransactionwillalsobedeleted. Youcannotinsertordeletearow,orchangetheSiteIDordistribution accountsintheItemTransferEntrywindowiftheAnalyticalItemTransfer Entrywindowisopen. Enteringanalysisinformationforvarianceaccounts Youcancreateanalysisinformationforvariancetransactionsinthe AnalyticalStockCountEntrywindow.ThewindowcanbeopenedfromtheStock CountEntrywindowbychoosingAdditional>>AnalyticalTransactionEntry orCTRL+T. Youcanenteranalysisinformationsuchastransactiondimensioncodesand referenceinformationforthetransactionsinthiswindow.Referto Enteringanalysisinformationforinventorytransactionsformore informationaboutenteringanalysisinformationforinventorytransactions. IfyouchooseClearCountintheStockCountEntrywindow,theanalysis informationyou’veenteredforthetransactionalsowillbedeleted. YoucannotchangethequantityordistributionaccountsintheStockCount EntrywindowortheUnitofMeasureintheStockCountUnitofMeasure windowormakechangesintheStockCountSerial/LotNumberEntrywindowif theAnalyticalStockCountEntrywindowisopen. Postinginventorytransactions WhenyoupostatransactionwithanalysisinformationfromtheItem TransactionorItemTransferwindoworprocessaStockCountScheduleinthe StockCountEntrywindow,avalidationtakesplaceforthedocument. IfselectedinPostingsetup,theAnalyticalPostingJournalswillbe printedalongwiththeMicrosoftDynamicsGPJournal.Ifnoerrorsarefound duringthevalidationprocess,thedocumentwillbeposted. IferrorsaredetectedintheMicrosoftDynamicsGPorAnalyticalAccounting transactions,theAnalyticalValidationLogwindowwillopendisplayingall theerrors.YoucandoubleclickonanAnalyticalAccountingerrortogoto therelevantdistributionintheAnalyticalTransactionEntrywindow.You cannotzoomtoaMicrosoftDynamicsGPwindowfromtheAnalyticalValidation Log. WerecommendthatyoucorrecttheMicrosoftDynamicsGPerrorsfirstbefore correctingtheAnalyticalAccountingerrors. IntheStockCountEntrywindow,ifAutopostStockCountVariancesisnot marked,theanalysisinformationcreatedwillupdatetheItemTransaction EntrywindowwhenyouprocesstheStockCountSchedule. Batchposting YoucanprinttheAnalyticalAccountingEditListalongwiththeMicrosoft DynamicsGPEditListfromtheInventoryBatchEntrywindow.TheAnalytical ValidationLogisalsoprintedifthereareanyAnalyticalAccountingerrors inthetransactionsinthebatch. YoucanalsoprinttheAnalyticalAccountingEditListfromtheItem TransactionorItemTransferEntrywindow. Analysisinformationthathasbeencreatedfortransactionsinaninventory batchwillnotbepostedifthePosttoGeneralLedgeroptionisnotmarked intheInventoryBatchEntrywindow. IftheoptionPosttoGeneralLedgerismarked,theanalysisinformation enteredfortransactionsinabatchwillbevalidatedwhenyouchoosePost. TransactionsthatdonothaveanyMicrosoftDynamicsGPorAnalytical Accountingerrorswillbeposted.TheAnalyticalPostingJournalwillbe printedwiththeMicrosoftDynamicsGPPostingJournalsifspecifiedin Postingsetup.Iferrorsarefoundduringthevalidationprocess,the AnalyticalValidationLogreportwillbeprinted.RefertoValidating transactionsandcorrectingerrorsformoreinformation. Whenyoudeleteasingleorrecurringusebatchoratransactionwithinsuch batches,theanalysisinformationyou’veenteredforthetransaction distributionsinthebatchorforthetransactionwillalsobedeleted. Forrecurringbatches,youmustenteranalysisinformationeachtimethe batchisposted. Seriesposting WhenyoupostmultiplebatchesfromtheSeriesPostingwindow,batcheswith analysisinformationarevalidated.Youcanmodifytheanalysisinformation createdfortransactionsinabatchbeforeposting. Whenyoupostbatches,transactionswithoutanyerrorswillbeposted. Transactionswitherrorswillnotbepostedandtheerrorswillbelistedin theAnalyticalValidationLog.Theerrorsmustbecorrectedbeforeyoupost thetransactionsagain. TheAnalyticalPostingJournalisprintedforalltransactionsthatare successfullypostedineachbatch. PostthroughGeneralLedgerfortransactionposting Ifyouhavemarkedthefollowingoptions,onlinetransactionsandbatches postedfromInventorywillautomaticallyupdatetheappropriateposting accountsinGeneralLedgeriftherearenoAnalyticalAccountingand MicrosoftDynamicsGPerrors. PostthroughGeneralLedgerfilesunderPostingSetup(Administration>>Setup>>Posting>>Posting);and PostthroughtoGeneralLedgerforTrxPosting(Administration>>Setup>>Company>>AnalyticalAccounting>>Setup) Whilepostingonlineandbatchtransactions,AnalyticalAccountingor MicrosoftDynamicsGPerrorsmayexistwhichwouldpreventthetransaction orbatchfromupdatingtheappropriatepostingaccountsinGeneralLedger. Forexample,defaultcodesmaynotbeassignedforRequiredTransaction DimensionsintheaccountclasstowhichthedistributionaccountsofFixed orVariableaccountsarelinked.Thetransactionorbatchwillupdatethe GeneralLedger.Youmustcorrecttheerrorsinthetransactionorbatchin GeneralLedgerfromtheTransactionEntrywindow(Transactions>> Financial>>General)beforethepostingaccountscanbeupdated. TheAnalyticalAccountingandMicrosoftDynamicsGPerrorswillbedisplayed intheAnalyticalAccountingValidationLogReportwhichwillprintafter thetransactionorbatchupdatesSalesOrderProcessing. ThetransactionandbatchwillupdateSalesOrderProcessing.Youcanview analysisinformationthatoriginatedforthetransactionorbatchinSales OrderProcessingfromtherelevantInquirywindows. Viewinganalysisinformationforinventorytransactions UsetheAnalyticalInventoryTransactionInquirywindowtoviewtheanalysis informationthathasbeencreatedforaccountsassociatedwithanItem NumberintheItemTransactionorItemTransferorStockCountEntry windows. Youcanviewtransactiondimensioncodesandotherrelatedinformationsuch asreferencenotescreatedfortheaccounts. Asingleassignmentequaltothetransactiondistributionamountwillbe displayedforeachdistributionaccountlinkedtoanaccountclass,which canbeviewedintheAnalyticalInventoryTransactionInquirywindow. Toviewanalysisinformationforinventorytransactions: OpentheAnalyticalInventoryTransactionInquirywindow. (Inquiry>>Inventory>>ItemTransaction>>SelectanItemNumber>>Additional>>AnalyticalTransaction) TheAnalyticalInventoryInquirywindowdisplaysthefirstdistributionoftheItemNumberselectedthatislinkedtoanaccountclass. TheDocumentTypefieldDisplaysthetypeoftransaction. TheNumberfieldDisplaysthedocumentnumber. TheItemfieldDisplaystheitemnumberrelevanttotheaccountdisplayed.TheSiteIDfieldDisplaysthesiteIDoftheitemnumber. EnterorselectthedistributionintheDistributionfield.TheDistribution lookupwillonlydisplaythosedistributionsthatarelinkedtoanaccount class. TheAccountfieldwilldisplaytheaccountforwhichyouareviewing analysisinformation.Thedescriptionfortheaccountisdisplayedinthe nextline.TheexpansionbuttonwillopentheMicrosoftDynamicsGPAccount Entrywindow. Thedistributionamountisdisplayedinthefunctionalamountfield.The typeofbalance,whethercreditordebit,isdisplayednexttothe FunctionalAmountfield. Thetransactiondateofthedocumentselectedisdisplayedinthe TransactionDatefield. TheCompanyIDfielddisplaystheIDforthecurrentcompany. SelecttheExpandbuttontoviewallanalysisinformationcreatedforthe distributionaccountinthelistwindow.Thiswouldcompriseassignments (alwayssingle),referenceinformation,transactiondimensionsandtheir codes. SelecttheCollapsebuttontoviewonlyassignmentsandreference information. Youcanalsoviewallinformationcreatedforeachaccountorjustreference informationthatmayexist.Selectthe+/-buttonsavailablenexttothe assignmenttoviewallanalysisinformationcreatedfortheaccountoronly referenceinformationthatmayexist. Selectthetypeofaccountthatyouwanttobrowsethroughfromthefollowing: AllYoucanbrowsethroughtheinventoryandoffsetaccountsforeachitemnumberifitislinkedtoanaccountclass. InventoryYoucanbrowsethroughtheInventoryaccountofeachitemnumberifitislinkedtoanaccountclass. OffsetYoucanbrowsethroughtheOffsetaccountofeachitemnumberifitislinkedtoanaccountclass. ChooseContratoswitchbetweentheInventoryaccountandtheOffsetaccount oftheItemNumberthatiscurrentlydisplayedintheAnalyticalInventory Inquirywindow.ThisispossibleonlyifboththeInventoryandOffset accountsofanItemNumberarelinkedtoanaccountclass. IfonlyoneaccountofanItemNumberislinkedtoanaccountclass,a messageappearswhenyouclicktheContrabutton. Clicktheprintericonbuttontoprintinformationforthedistribution displayedintheInquirywindoworforalldistributionsofthedocument thatarelinkedtoanaccountclass. ChooseOKtoclosethewindow. Chapter10:FixedAssetTransaction AnalyticalTransferMaintenancewindowisusedtomaintaininformationon theassettransferforFixedAssetmodule.Youcanviewthetransaction dimensioncodesanddescriptionforthetransactiondimensioncodesfor fixedassettransactions.YoucanenterorselecttheAliasdetailsinthe AnalyticalTransferMaintenancewindow. FortransactionsinFixedAsset,youcancreateassignmentsandenter transactiondimensioncodesforthedistributionaccountsthatarelinkedto anaccountclass.Youcansavetransactionswithanalysisinformationtoa singleorrecurringbatchpriortopostingthebatch.Theprocessof validatingtransactionswithanalysisinformationisalsoexplainedinthe AnalyticalfixedAssetTransactionEntrywindow. Thisinformationisdividedintothefollowingsections: EnteringAnalysisinformationforAssetTransfer EnteringanalysisinformationforFixedAssetTransaction ViewinganalysisinformationforFinancialDetail ViewinganalysisinformationforAssetAccount ViewinganalysisinformationforTransfer EnteringAnalysisinformationforAssetTransfer UsetheAnalyticalTransferMaintenancewindowtoentertheanalytical informationforassetstransferredfromonelocation,structureID,account number,ormasterassetIDtoanother. Toenteranalysisinformationonassettransfer OpentheAnalyticalTransferMaintenancewindow. (Transactions>>FixedAsset>>Transfer>>enterorselectanasset ID>>Additional>>AnalyticalTransactionorCTRL+T) (Transactions>>FixedAssets>>Transfer>>enterorselectanasset ID>>G/LAccountsexpansionbutton>>ExpandTransfer>>Analytical AccountingButton) TheDistributionfielddisplaysthefirstdistributionaccountoftheItem NumberselectedoneoftheaccountassociatedtoAssetID.Toviewother distributions,enterorselectadistributionnumber.Selectthe distributionlookupbuttontoviewallthedistributionaccountsofthe transactionlinkedtoanaccountclassintheAnalyticalAssetAccount Lookupwindow. TheCompanyIDfieldwilldisplaythecompanyinwhichthetransactionistakingplace. TheAccountfieldwilldisplaythedistributionaccountforwhichanalytical informationisbeingentered.Thedescriptionoftheaccount,assetupin theAccountMaintenancewindow,willappearinthenextline.Clickthe AccountexpansionbuttontoopentheMicrosoftDynamicsGPAccountEntry window. Thebalancetypeoftheaccount,whetherdebitorcredit,willbedisplayednexttotheaccount. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes, ifrequired.RefertoCreatinganaliasormoreinformation. TheTrxDimensionfielddisplaysTransactionDimensionsoftheaccountclass towhichthedistributionaccountislinked.OnlyTransactionDimensions whichhavebeensetasFixed,Required,orOptionalwillbedisplayed. TransactiondimensionswhicharesettoHideintheAccountingClass Maintenancewindowwillnotbedisplayed.RefertoSettingupanaccount classformoreinformation. TheTrxDimensionDescriptionfielddisplaysthedescriptionofthetransactiondimension. Enterorselectanalphanumerictransactiondimensioncodeinthe Alphanumericcolumn.Youcanaddanewalphanumerictransactiondimension codeifyouhaveselectedtheCreateNewCodesOnTheFlyoptioninthe TransactionDimensionMaintenancewindow. Note TheAlphanumericcolumnisavailableonlyforanalphanumerictransactiondimension. ThedescriptionoftheAlphanumericTransactionDimensionCodeisdisplayedintheTransactionDimensionCodeDescriptionfield. EnteraTransactionDimensionCodeintheNumeric,Yes/NoorDatefieldif theTransactionDimensionisNumeric,BooleanorDate. ChooseOKtosaveandclosethewindow. ChooseSavetosavetheanalysisinformationyouhaveenteredandclearthe window. ChooseValidatetovalidatethedistributiondisplayedinthewindow.If changesaremadetotheaccountclassinsetuporerrorsarefoundduring thevalidationprocess,theAnalyticalAccountingValidationLogwindowwill opendisplayingtheerrorsorchangesidentified.Youcanviewthechanges totheaccountclassbyselectingtheDefaultbuttonintheAnalyticalItem TransactionEntrywindow. Note AnalysisinformationwillalsobevalidatedifyouselectOKorSaveintheAnalyticalFixedAssetSetupwindow. Youcanchoosetosaveanalysisinformationwitherrorsorwithoutupdatingchangesmadetotheaccountclass. YoucanvalidateadocumentintheItemTransactionEntrywindowbyusingtheoptionsCTRL+RorAdditional>>RunValidation. RefertoValidatingtransactionsandcorrectingerrorsformoreinformationaboutvalidation. ChoosethePrintdrop-downtoprinttheAnalyticalAccountingEditlistfor thedistributioncurrentlydisplayedinthewindoworforalldistributions ofthetransactionlinkedtoanaccountclass.Iferrorsaredetected,the AnalyticalValidationLogisalsoprinted. EnteringanalysisinformationforFixedAssetTransaction UsetheAnalyticalFixedAssetTransactionEntrywindowstoenteranalysis informationfortransactionsforFixedAssetmodule.Thewindownamedepends uponthepathwhereyouopenthiswindow. Youcanenterassignmentsandtransactiondimensioncodesforfixedasset documentsusingtheAnalyticalFixedAssetTransactionEntrywindow.Also, youcanviewanalysisinformationcreatedfortransactionsintheAnalytical Inquirywindows. YoucanopentheAnalyticalTransactionEntrywindowonlyifAnalytical Accountinghasbeenactivated.RefertoActivatingAnalyticalAccounting formoreinformationaboutactivatingAnalyticalAccounting. Incaseofmulticurrencytransactions,achangeinthetransactiondate re-createsdistributionsduetoachangeintheexchangerate.Ifthe transactiondateismodified,analysisinformationcreatedpreviouslyis deletedwhenthedistributionsarere-created. ToenterAnalyticalFixedAssetTransactionEntry OpentheAnalyticalFixedAssetTransactionEntrywindow. (Cards>>FixedAsset>>Book>>selectBookIDandenterAsset ID>>AnalyticalAccountingIcon.) (Cards>>FixedAsset>>Book>>selectBookIDandenterAsset ID>>Additional>>AnalyticalTransactionorCTRL+T) (Cards>>FixedAsset>>Book>>selectBookIDandenter AssetID>>Distributions>>FinancialDetailMaintenance>>Analytical AccountingIcon)(Cards>>FixedAsset>>Book>>selectBookIDand enterAssetID>>Distributions>>FinancialDetailMaintenance>> Additional>>AnalyticalTransactionorCTRL+T) (Administration>>Routines>>FixedAssets>>GLPosting>>Analytical AccountingIcon) (Administration>>Routines>>FixedAssets>>GLPosting>> Additional>>AnalyticalTransactionorCTRL+T) TheDistributionfielddisplaysthefirstdistributionaccountoftheoneof theaccountassociatedtoAssetID.Toviewotherdistributionsforthe transaction,enterorselectadistributionnumber. ThesequenceofdistributionsintheAnalyticalFixedAssetTransactionEntrywindowmaynotcorrespondtothesequenceintheFixedAssetEntrywindowbecauseonlyaccountslinkedtoanaccountclassaredisplayedintheAnalyticalPayrollTransactionEntrywindow. Inthelistwindow,enterthetransactiondistributionamountinfunctional ororiginatingcurrency,byvalueoronapercentagebasis. EntertheassignmentinpercentagevalueintheAssign%field.Initially,a singleassignmentiscreatedbydefault.Youcanoverwritetheassignment withmorethanoneassignment. Youcansaveanalysisinformationforadistributioneveniftheassignmentisnot100%.However,youcanpostatransactionwithpartialassignmentsonlyifyouhaveoptedtoallowpartialassignmentsduringpostingforthemoduleyou’reworkingin.RefertoSettingupassignmentoptionsformoreinformation. SelectanaliasintheAliasfield.TheAlphanumericfieldinthescrolling windowdisplaysthetransactiondimensioncodesthatareassociatedwiththe aliasforthetransactiondimensionsdisplayed.Youcanchangethesecodes ifrequired.RefertoCreatinganaliasformoreinformation. EnterreferenceinformationfortheassignmentintheReferencefield. ChooseDeleteRowtodeleteasinglerowintheassignmentListView.You cannotchoosethisoptionifonlyasingleassignmenthasbeenentered. ChooseRemainingtoaddoneassignmentfortheremainingunassignedamount. Thenewassignmentwillensurethatthetotalassignedamountequalsthe distributionamount.Forexample,thedistributionamountis$100and you’veenteredfourassignmentsthattotal$75.WhenyouchooseRemaining, afifthassignmentfortheremainingvalue,$25iscreated.Thisbuttonis notavailableifthedistributionfieldisblankorhasazerovalue. ChooseDefaulttoloadthecurrentsetupinformationspecifiedforthe accountclassintheAccountingClassMaintenancewindowandcreateasingle assignment.Thefollowingprocesseswilloccur: Fixed,Required,andOptionalTransactionDimensions(includinghidden transactiondimensions)willbeinstalled. Alltheassignmentsthatyouhavecreatedforthecurrentdistribution willberemovedandcreateasingleassignmentthatisequaltothe distributionamountwillbecreated. IftheanalysistypeischangedtoorfromNotAllowed,transaction dimensionswillbeaddedorremoved. Transactiondimensionsthathavebeendeletedwillberemoved. Enterorselectthecodeforeachalphanumerictransactiondimensioninthe alphanumericcolumn.Ifyou’vemarkedtheShowvalidcodecombinationsin trnsandbudgetsoptionintheAnalyticalAccountingOptionswindow,then thelookupwindowwilldisplayonlythosecodesthathaveavalid combinationwiththecodesyouhavealreadyselectedforthetransaction. EnteratransactiondimensioncodeintheNumeric,Yes/NoorDatefieldfor aNumeric,BooleanorDatetypeTransactionDimension. ChooseOKtosaveyourchangesandclosethewindow.Theanalysis informationthatyouhaveenteredisvalidatedwhenyouchooseOK.Referto Validatingtransactionsandcorrectingerrorsformoreinformation. ChooseSavetosavetheanalysisinformationyouhaveenteredandclearthe window.AvalidationtakesplacewhenyouchooseSaveintheAnalytical GeneralTransactionEntrywindow.RefertoValidatingtransactionsand correctingerrorsformoreinformation.Youcansavetheanalysis informationwitherrorsorwithoutupdatingchangesmadetotheaccount class. ChooseCleartocleartheinformationfromtheAnalyticalGeneral TransactionEntrywindow. ChooseValidatetovalidatetheanalysisinformationofthedistribution displayedinthewindow.Ifchangesaremadetotheaccountclassinthe AnalyticalAccountingsetuporerrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogwindowwillopenwhereyou canviewtheerrorsorchanges.RefertoValidatingtransactionsand correctingerrorsformoreinformationaboutvalidation. ToviewthechangestotheaccountclasschoosetheDefaultbuttoninthe AnalyticalGeneralTransactionEntrywindow.DoubleclickonanAnalytical AccountingerrortoopentheAnalyticalAccountingGeneralTransactionEntry windowwherethespecificerrorwillbehighlighted. ChoosetheprintericonbuttontoprinttheAnalyticalAccountingeditlist forthecurrentdistributiondisplayedorforalldistributionsofthe transactionlinkedtoanaccountclass.TheAnalyticalAccountingValidation LogreportwhichdescribestheAnalyticalAccountingerrorsalsoisprinted. ViewinganalysisinformationforFinancialDetail YoucanviewanalysisinformationforfinancialdetailintheAnalytical FinancialDetailInquirywindow. Toviewanalysisinformationforfinancialdetail OpentheAnalyticalFinancialDetailInquirywindow (Inquiry>>FixedAssets>>FinancialDetail>>enterorselectan assetID>>selectabookID>>selectaline>>Additional>> AnalyticalTransactionorCTRL+T) EnterorselectanassetIDandselectabookID. SelectatransactionandselectAdditionalandchooseAdditional>> AnalyticalTransactionorCTRL+TtoopentheAnalyticalFinancialDetail Inquirywindow. IntheAnalyticalFinancialDetailInquirywindow,clicktheaccount expansionbuttontoopentheAccountEntrywindowtoenterorselectan aliasforanaccount. ChooseOKtoclosetheAnalyticalFinancialDetailInquirywindow. ViewinganalysisinformationforAssetAccount YoucanviewanalysisinformationforassetaccountintheAnalyticalAsset AccountInquirywindow. Toviewanalysisinformationforassetaccount OpentheAnalyticalAssetAccountInquirywindow (Inquiry>>FixedAssets>>General>>enterorselectanassetID>> Gotobutton>>Account>>Additional>>AnalyticalTransactionor CTRL+T) EnterorselectanAssetIDintheAssetInquirywindow. ChoosetheGotobuttontoselecttheAccountoption. SelectAdditionalandchooseAdditional>>AnalyticalTransactionor CTRL+TtoopentheAnalyticalAssetAccountInquirywindow. IntheAnalyticalAssetAccountInquirywindow,clicktheaccountexpansion buttontoopentheAccountEntrywindowtoenterorselectanaliasforan account. ChooseOKtoclosetheAnalyticalAssetAccountInquirywindow. ViewinganalysisinformationforTransfer YoucanviewanalysisinformationforTransferAssetsintheAnalytical TransferInquirywindow. Toviewthetransferanalysisinformation OpenAnalyticalTransferInquirywindow (Inquiry>>FixedAssets>>Transfer>>enterorselectassetID>> Additional>>AnalyticalTransactionorCTRL+T) EnterorselectanAssetIDintheAssetInquirywindow. SelectAdditionalandchooseAdditional>>AnalyticalTransactionor CTRL+TtoopentheAnalyticalTransferInquirywindow. IntheAnalyticalTransferInquirywindow,clicktheaccountexpansion buttontoopentheAccountEntrywindowtoenterorselectanaliasforan account. ChooseOKtoclosetheAnalyticalTransferInquirywindow. Chapter11:BankReconciliationTransactions YoucanenterandviewanalysisinformationfortransactionsinBank Reconciliation.Thiswouldcomprisecreatingassignmentsandentering transactiondimensioncodesforaccountsthatarelinkedtoanaccount class. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforbanktransactionsandreceipts Voidingtransactionsorreceipts Enteringanalysisinformationforbanktransfers Voidingbanktransfers Enteringanalysisinformationforreconcileadjustments Validatingtransactionsandcorrectingerrors Postingtransactionswithanalysisinformation Enteringanalysisinformationfordeposits ViewinganalysisinformationinBankReconciliation Enteringanalysisinformationforbanktransactionsandreceipts Youcancreateassignments,entertransactiondimensioncodes,andreference informationforaccountsthatarelinkedtoanaccountclassinthe AnalyticalBankTransactionEntrywindow.Youcanmodifytheanalysis informationthatyouhaveenteredatanytimebeforepostingthedocument. TheAnalyticalBankTransactionEntrywindowopensautomaticallywhenyou pressTABfromarowintheBankTransactionEntrywindowinthefollowing instances: IfthedistributionaccountislinkedtoanaccountclassandtheAnalytical BankTransactionEntrywindowhasnotbeenopenedevenoncefortheaccount andifallrequiredfieldshavebeenenteredintheBankTransactionEntry window. TheAnalyticalBankTransactionEntrywindowalsoopensautomaticallyIfthe followingchangesaremade: Changeindistributionaccountotherthanthecheckbookaccount. Changeincheckbookamount. Changeinamountofotherdistributionaccounts. Changefromdebittocreditorviceversa. Changeinamountfrompositivetonegativeorviceversa. Thesechangeswouldresultinadeletionoftheanalysisinformationcreated previouslyfortherelevantaccount. IfyouclearanunpostedtransactionorreceiptfromtheBankTransaction Entrywindow,theanalysisinformationthatexistsforthetransactionor receiptwillbedeleted. IfyouchoosetoclearpreviousentriesafteryouchangetheOptionorType intheBankTransactionEntrywindowtheanalysisinformationthatexists forthecheckbookaccountandallotherdistributionaccountsthatare linkedtoanaccountclasswillbedeleted. Ifyouchoosetocontinueusingentriesinanewtransactionafterchanging the OptionintheBankTransactionEntrywindow(exceptforachangefromEnter TransactiontoEnterReceiptorviceversa),analysisinformationentered forthecheckbookaccountandallotherdistributionaccountsthatare linkedtoanaccountclasswillbedeleted. Ifyouchangethecreditcardassignedtoareceipt,forwhichthecheckbook isdifferentfromtheoneoriginallyassignedtothereceipt,analysis informationthatexistsforthecheckbookaccountwillbedeleted. Inthecaseofmulticurrencytransactions,thefollowingchangeswilldelete theexistinganalysisinformationforatransactionorreceipt: Changefromoriginatingtofunctionalcurrency(ifenteringreceipt). ChangeincurrencyIDduetoachangeinthecheckbookID. ChangeinexchangerateintheExchangeRateEntrywindow. ChangeintheratetypeIDintheExchangeRateEntrywindow.Inthiscase, distributionsarere-creatediftheratetypeIDselectedisfroma differentexchangeratetableIDthantheoneoriginallyassignedtothe transaction. Changeintransactiondate. Toenteranalysisinformationforbanktransactionsandreceipts: OpentheAnalyticalBankTransactionEntrywindow. (Transactions>>Financial>>BankTransactions>>Analytical Accountingbutton) (Transactions>>Financial>>BankTransactions>>Additional>> AnalyticalTransactionorCTRL+T) TheAnalyticalBankTransactionEntrywindowwillonlydisplaydistributionaccountsofatransactionorreceiptthatarelinkedtoanaccountclass. Forexample,ifachecktransactionhastwodistributionaccountsofwhichonlyoneislinkedtoanaccountclass,thenthedistributionaccountlinkedtotheaccountclasswillbedisplayedintheAnalyticalBankTransactionEntrywindow.Ifthereismorethanonedistributionaccountlinkedtoanaccountclass,theywillbedisplayedintheAnalyticalBankTransactionEntrywindowasperthedistributionsequence.Youcanenterorselectthedistributionaccountyouwanttoview. YoucanalsoviewaspecificdistributionaccountintheBankTransactionEntrywindowlinkedtoanaccountclass,byselectingtheaccountpriortoopeningtheAnalyticalBankTransactionEntrywindow. RefertoEnteringanalysisinformationforGeneralLedgertransactionsformoreinformationaboutenteringanalysisinformation. Voidingtransactionsorreceipts WhenyouvoidatransactionorreceiptintheBankTransactionEntrywindow, theanalysisinformationenteredforthedocumentduringtransactionentry willbecopiedwiththeexceptionofthebalancetype.Thebalancetypeof eachdistributionaccountlinkedtoanaccountclasswillbereversed. Youcannotmodifytheanalysisinformationofthecheckbookaccountand otherdistributionaccountspriortovoiding.However,ifyouhavemade changestodistributionaccountsotherthanthecheckbookaccountpriorto voidingthataffectstheanalysisinformationenteredpreviouslyforsuch accountsduringtransactionentry,suchinformationwillbedeleted.You mustre-enteranalysisinformationfortheseaccountspriortovoidingthe transactionorreceipt. Thechangesmadetoadistributionlinethatwouldresultinadeletionof analysisinformationincludechangingtheaccountoramountordebitto creditorviceversaorpositiveamountstonegativeorviceversa. Whenyouvoidatransactionorreceipt,theanalysisinformationentered priortovoidingwillbevalidated.ReferPostingtransactionswith analysisinformationformoreinformationaboutvalidation. Enteringanalysisinformationforbanktransfers Youcanenterassignments,transactiondimensioncodesandreference informationforbanktransfersintheAnalyticalBankTransferEntrywindow. Note BesuretofollowthetabsequencewhileenteringtransactionsintheBank TransferEntrywindow,tocreateanalysisinformation.Youmaylosedataif thetabsequenceisnotfollowed. TheAnalyticalBankTransferEntrywindowwillonlydisplaycheckbook accountsthatarelinkedtoanaccountclass. TheAnalyticalBankTransferEntrywindowopensautomaticallywhenyoupress TABfromafieldinthefollowinginstances: TheTransferToCheckbookIDfieldifeitherorboththeTransferFromor TransferToCheckbooksarelinkedtoanaccountclassandtheAnalytical Bank TransferEntrywindowhasnotbeenopenedpreviouslyforsuchaccount.The AnalyticalBankTransferEntrywindowwillopenautomaticallyinthis instanceonlyifbothCheckbookIDsandtheamounthavebeenspecifiedin theBankTransferEntrywindow. TheTransferFromorTransfertoCheckbookIDfields,ifthereisachange inthecheckbookIDthatresultsinachangeinthedistributionaccount. Theamountfield,ifthereisachangeinthebanktransferamount. IfyouclearanunpostedtransferfromtheBankTransferEntrywindow,the analysisinformationthatexistsforthetransferwillbedeleted. Inthecaseofmulticurrencytransactions,thefollowingchangeswilldelete theexistinganalysisinformationofatransfer: TheTransferFromCheckbookischangedtoafunctionalcurrencycheckbook. ChangeinexchangerateintheExchangeRateEntrywindow. ChangeintheRateTypeIDintheExchangeRateEntrywindow.Inthiscase, distributionsarere-creatediftheRateTypeIDselectedisfroma differentexchangeratetableIDthantheoneoriginallyassignedtothe transaction. Changeintransferdate. Toenteranalysisinformationforbanktransfers OpentheAnalyticalBankTransferEntrywindow. (Transactions>>Financial>>BankTransfers>>AnalyticalAccounting button) (Transactions>>Financial>>BankTransfers>>CTRL+TorAdditional >>AnalyticalTransaction) ReferEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Voidingbanktransfers Whenyouvoidabanktransfer,theanalysisinformationthatwasenteredfor thetransferwillbecopied,alongwithachangeinthebalancetype.The balancetypewillbereversed.Youcannotmodifytheanalysisinformation forthetransferpriortovoiding. Enteringanalysisinformationforreconcileadjustments YoucanenteranalysisinformationforanadjustmentintheReconcileBank Adjustmentswindow(Transactions>>Financial>>Reconcile>> Transactions>> Adjustments>>Selectanadjustment>>CTRL+TorAdditional>> AnalyticalTransaction),ifthecheckbookaccountand/oradjustmentaccount arelinkedtoanaccountclass.TheAnalyticalReconcileEntrywindowwill onlydisplayaccountsofanadjustmentlinkedtoanaccountclass. Youcanenteranalysisinformationforoneadjustmentatatime.Tocreate analysisinformationforaspecificadjustment,selecttheadjustmentprior toopeningtheAnalyticalReconcileEntrywindow. TheAnalyticalReconcileEntrywindowopensautomaticallywhenyoupressTAB fromafieldintheReconcileBankAdjustmentswindow,inthefollowing instances: Eitherorboththedistributionaccountsoftheadjustmentarelinkedtoan accountclassandtheAnalyticalReconcileEntrywindowhasnotbeenopened previouslyforsuchadjustment. Changeindistributionaccountofanadjustment Changeinadjustmentamount Analysisinformationenteredforadjustmentswillbedeletedif reconciliationinformationoftheCheckbookisdeletedfromtheReconcile BankStatementswindow.Also,ifyoudeletearowintheReconcileBank Adjustmentswindow,analysisinformationthatyou’veenteredfor distributionaccountsofthatrowwillbedeleted. Inthecaseofmulticurrencytransactions,thefollowingchangeswilldelete theanalysisinformationenteredforanadjustment: ChangeintheRateTypeIDintheExchangeRateEntrywindow.Inthiscase, distributionsarere-creatediftheRateTypeIDselectedisfroma differentexchangeratetableIDthantheoneoriginallyassignedtothe transaction. ChangeinExchangeRateintheExchangeRateEntrywindow. ChangeinDate. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Validatingtransactionsandcorrectingerrors Youcanvalidateatransactionfromthefollowingwindowsbychoosing Additional>>RunValidationorCTRL+R. BankTransactionEntry BankTransferEntry ReconcileBankAdjustments RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. IntheReconcileBankAdjustmentswindow,youcanvalidatetheanalysis informationenteredonlyforindividualadjustments.Tovalidatean adjustment,selecttheadjustmentandchooseCTRL+TorAdditional>>Run Validation. Youcanvalidateanyanalysisinformationenteredbeforevoiding.Iferrors aredetectedduringvalidation,theAnalyticalAccountingValidationLog windowwillopendisplayingtheerrors. YoucanselectView>>IncompleteorErroneousDistributions,tobrowse throughthedistributionaccountsintheAnalyticalTransactionEntrywindow whichareincompleteorhaveerroneousinformation. TocorrectanAnalyticalAccountingerror,double-clickontherelevant errortoopentherelevantAnalyticalTransactionEntrywindow.Thespecific distributioninwhichtheerrorexistsisdisplayedwhichyoucanthen correct. Iferrorsaredetectedintheanalysisinformationyouhaveenteredfor adjustments,youcansavesuchinformationwitherrors.However,the checkbookcannotbereconciledtillyouhaverectifiedtheseerrors. Postingtransactionswithanalysisinformation Whenyoupostatransactionortransferorreconcileacheckbook,the analysisinformationyouhaveenteredwillbevalidated. RefertoValidatingtransactionsandcorrectingerrorsformore information.InadditiontoAnalyticalAccountinginformation,Microsoft DynamicsGPdatawillalsobevalidatedbeforethetransactionortransfer ispostedorthecheckbookisreconciled. Iferrorsarefoundwhilepostingatransactionortransfer,thetransaction ortransferwillnotbeposted.TheAnalyticalAccountingValidationLog windowwillopenlistingtheMicrosoftDynamicsGPerrorsfirstandthenthe AnalyticalAccountingerrors. TocorrectanAnalyticalAccountingerror,double-clickontherelevant errortoopentherelevantAnalyticalTransactionEntrywindow.Thespecific distributioninwhichtheerrorexistsisdisplayedwhichyoucanthen correct. Iferrorsaredetectedwhilereconcilingacheckbook,theywillbelistedin theAnalyticalAccountingValidationLogReport.Youwillhavetoselectthe appropriateadjustmentintheReconcileBankAdjustmentswindowandcorrect theerrorsbeforethecheckbookcanbereconciled. WerecommendthatyouresolvetheMicrosoftDynamicsGPerrorsfirstand thentheAnalyticalAccountingerrors. TheAnalyticalPostingJournalwillbeprintedalongwiththeMicrosoft DynamicsGPPostingreportsifspecifiedunderPostingSetup. Enteringanalysisinformationfordeposits Ifdistributionsarecreatedforrealizedgainorlossaccountswhenyou postdepositsfromtheBankDepositEntrywindow(Transactions>> Financial>>BankDeposits),theAnalyticalBankDepositwindowwillopen automaticallyifanyoftheseaccountsarelinkedtoanaccountclass.Refer toEnteringanalysisinformationforbanktransactionsandreceiptsfor moreinformationaboutenteringanalysisinformation. TheAnalyticalBankDepositEntrywindowwillonlydisplaydistribution accountsthatarelinkedtoanaccountclass. Afteryouhaveenteredanalysisinformationfortherelevantaccounts,a validationwilltakeplacewhenyouchoosePost.Ifthereareerrorsinthe analysisinformation,theAnalyticalValidationLogwillopendisplayingthe AnalyticalAccountingerrors.RefertoPostingtransactionswithanalysis informationformoreinformation. TheAnalyticalPostingJournalwillprintafteryoupostthedeposits,if youhaveselectedtheoptioninthePostingSetup. ViewinganalysisinformationinBankReconciliation Youcanviewanalysisinformationyou’veenteredfortransactionsinthe BankTransactionEntry,BankTransferEntryandReconcileBankAdjustments windowsintheAnalyticalinquirywindow. YoucanopentheAnalyticalinquirywindowfromtheBankTransactionEntry zoomortheBankTransferEntryzoomintheCheckbookRegisterInquiry window. ToviewanalysisinformationinBankReconciliation: OpentheAnalyticalBankTransactionEntryZoomorBankTransferEntryzoom window. (Inquiry>>Financial>>CheckbookRegister>>BankTransactionEntry ZoomorBankTransferEntryZoom>>Additional>>AnalyticalTransaction orCTRL+T) TheAnalyticalBankReconInquirywindowdisplaysallanalysisinformation createdforadistributionaccount. Thefirstdistributionaccountofthedocumentlinkedtoanaccountclassis displayed.Enterorselectadistributionnumbertoviewanalysis informationofotherdistributionaccounts. IfyouselectaspecificaccountintheBankTransactionEntryZoom,the AnalyticalBankReconInquirywindowwilldisplayanalysisinformation relatingtosuchaccount. TheDocumentTypeandNumberfieldwilldefaultfromtheBankTransaction EntryorBankTransferEntryZoom. TheOriginatingorFunctionalAmountfielddisplaysthedistributionamount intheoriginatingorfunctionalcurrencybasedontheoptionyouhave chosenintheCurrencyView.Clicktheexpansionbuttontoview multicurrencyinformationiftheoriginatingcurrencydiffersfromthe functionalcurrency. TheDocumentDatefielddisplaysthetransaction/transferdateofthe documentfromtheBankTransactionEntryorBankTransferEntryzoom. TheCompanyIDfielddisplaystheIDofthecurrentcompany. ClickExpandtodisplayallanalysisinformationenteredforthe distributionaccountinthelistwindow.Thisincludesassignments, referenceinformationenteredperassignment,TransactionDimensionsand theircodes. ClickCollapsetodisplayonlyassignmentsandreferenceinformationentered perassignmentforthedistributionaccount. Youalsocanviewallinformationenteredforeachassignmentorjust referenceinformationthatmayexist.Theplusorminusbuttonsavailable nexttoeachassignmentallowyoutoviewallanalysisinformationentered foranassignmentoronlyreferenceinformationthatmayexist. Chapter12:CashbookBankManagementTransactions Youcanenterandviewanalysisinformationforpayments,deposits,bank transfers,andcashreceiptsenteredinCashbookBankManagement.Youcan createassignmentsandentertransactiondimensioncodesforaccountsthat arelinkedtoanaccountclass. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforpaymentsanddeposits Enteringanalysisinformationforbanktransfers Enteringanalysisinformationforbanktransfercharges Enteringanalysisinformationforcashreceipts Enteringanalysisinformationforwriteoffs,termstaken,andrealized gain/loss Enteringanalysisinformationfordistributions Postingtransactions Validatingtransactionsandcorrectingerrors Voidingtransactions ViewinganalysisinformationinCashbookBankManagement Enteringanalysisinformationforpaymentsanddeposits Youcanenteranalysisinformationforpaymentsanddepositsthatareina batchinCashbookBankManagement.TheAnalyticalTransactionEntrywindow willopenautomaticallywhenyouTABoutfromtheamountfieldinthe PaymentsorDepositswindow,ifanyoftheaccountsusedinthetransaction distributionsarelinkedtoanaccountclassandifanalysisinformationhas notbeenenteredforthetransaction.YoucanalsoopentheAnalytical TransactionEntrywindowfromtheDistributionswindowforpaymentsand deposits. TheAnalyticalPayment/DepositTransactionEntrywindowwillopen automaticallyifyoumakethefollowingchangesinthePaymentsorDeposits window: AmountIfyouchangetheamount,andthechequeordepositcontainsonly onetransaction,theanalysisinformationcreatedearlierforthepaymentor receiptwillbedeleted.WhenyouopentheAnalyticalPayment/Depositwindow aftersavingthechanges,itwilldisplaythefirstdistributioncreatedfor thetransactionwiththeamountfielddisplayingthenewamount.Ifthe chequeordepositismadeupofmultiplelinesofreceiptsthathavebeen changed,theanalysisinformationcreatedforthelineofreceiptwillbe deleted.Thiswouldincludetheaccounttowhichtheamountisdebitedor credited,thetaxaccount,andthecheckbookaccount.Asingleassignment equaltothenewdebitorcreditamountwillbecreated.Transaction dimensionsanddefaulttransactiondimensioncodesspecifiedfortheaccount classtowhichthecheckbookaccountislinked,willbeloadedinthe AnalyticalPayment/DepositTransactionEntrywindow. DistributionaccountTheanalysisinformationcreatedforthe distributionaccountwillbedeletedifthereisanychangeinthe distributionaccount. CreditororDebtorIDTheanalysisinformationcreatedforthedebtoror creditorcontrolaccountwillbedeleted,evenifthecontrolaccounthas notbeenchanged.TheAnalyticalDepositwindowwilldisplayinformation relatingtothenewdebtororcreditorcontrolaccount. Changingpositiveamounttonegativeamountornegativeamount topositiveamountTheanalysisinformationcreatedforthelineor receiptaffectedbythechangewillbedeleted.Thiswouldincludethe accounttowhichtheamountisdebitedorcredited,thetaxaccount,andthe checkbookaccount.Asingleassignmentequaltothenewdebitorcredit amountwillbecreated.Transactiondimensionsanddefaulttransaction dimensioncodesspecifiedfortheaccountclasstowhichthecheckbook accountislinkedwillbedisplayedintheAnalyticalPayment/Deposit TransactionEntrywindow. TaxamountAnalysisinformationenteredforthetaxamountwillbe deletedifanychangesaremade. TaxscheduleAnalysisinformationenteredforthetaxschedulewillbe deletedifanychangesaremade. Toenteranalysisinformationforpaymentsanddeposits: OpentheAnalyticalTransactionEntrywindow. (Transactions>>Financial>>BankManagement>>Batches>>Payments button>>CTRL+TorAdditional>>AnalyticalTransaction) (Transaction>>Financial>>BankManagement>>Batches>>Deposits button>>CTRL+TorAdditional>>AnalyticalTransaction) (Transaction>>Financial>>BankManagement>>Batches>> Payments/Depositsbutton>>Distributionbutton>>CTRL+TorAdditional >>AnalyticalTransaction) Theinformationforthefirstdistributionaccountthathasbeenlinkedto anaccountclassisdisplayedwhenyouopenthewindow.Informationrelevant totheaccountassociatedwiththecreditor,debtororGLtransaction selectedinthescrollingwindowofthePayments/Depositswindowwillappear ifthechequecomprisesasinglelineorthedepositcontainsonlyasingle receipt. Formultiplelinesorreceipts,youcancreateanalysisinformationfora specificlineorreceiptdisplayedinthescrollingwindow. Youcanenteranalysisinformationfortheremainingaccountsbyselecting theappropriatedistributionintheDistributionlookuporbyenteringa distributionnumberintheDistributionfield. Youcandeletetheanalysisinformationthatyouhaveenteredforabatch, cheque,ordepositbeforepostingit.Thiswilldeletealldatasuchas assignments,transactiondimensioncodes,andreferenceinformationthatyou enteredforthetransaction. IfyoudeleteaspecificrowinthescrollingwindowofthePayment/Deposit window,allanalysisinformationenteredforthetransactionwillbe deleted.InthePaymentwindow,ifyouhavenotenteredachequeamount, thenasingleassignmentequaltotherevisedamountwillbecreated.The transactiondimensionsanddefaulttransactiondimensioncodesspecifiedfor theaccountclassthatthecheckbookaccountislinkedtowillbedisplayed intheAnalyticalPayment/DepositEntrywindow. IfataxscheduleisdeletedfromanexistingGeneralLedgerpaymentor deposit,theanalysisinformationcreatedforthetaxaccountwillbe deleted.IfyoudeletethetaxamountintheTaxLookupwindow,theanalysis informationenteredwillalsobedeleted. YoucanprinttheAnalyticalAccountingEditListfromtheAnalytical TransactionEntrywindowbychoosingtheprintericonbutton. YoualsocanprinttheAnalyticalAccountingEditListbeforeyouposta batchintheBatchEntrywindowbychoosingtheprintericonbutton.A validationwilltakeplacewhenyouprinttheeditlist.Ifthereareany errors,theAnalyticalErrorReportwillbeprintedaftertheAnalytical AccountingEditlist.TheAnalyticalAccountingEditlistwillprintthe paymentsanddepositsalongwiththedistributions,assignments,andcodes. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Enteringanalysisinformationforbanktransfers YoucanenteranalysisinformationforbanktransfersintheAnalyticalBank TransferEntrywindow. Toenteranalysisinformationforbanktransfers: OpentheAnalyticalBankTransferEntrywindow. (Transactions>>Financial>>BankManagement>>BankTransfers>> CTRL+TorAdditional>>AnalyticalTransactionEntrywindow) (Transactions>>Financial>>BankManagement>>BankTransfers >>Distributionbutton>>CTRL+TorAdditional>>Analytical Transaction) TheAnalyticalBankTransferEntrywindowwilldisplayinformationrelevant tothefirstdistributioncreatedforthetransfer.Ifyouselectedarowin eitherofthescrollingwindows,orplacedthecursoronanyfieldinthe BankTransferEntrywindow,theAnalyticalBankTransferEntrywindowwill displaytheinformationforthefirstdistributioncreatedforthetransfer. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. IntheBankTransferEntrywindow,ifachangeismadetotheamount,the analysisinformationcreatedfortheaccountwhichhasbeenaffectedbythe changewillbedeleted.Forexample,iftheTransferFromamountischanged, theanalysisinformationyouenteredfortheFromCheckbookwillbedeleted. Ifyoudeleteabanktransfer,theanalysisinformationcreatedfortheFrom andToCheckbookAccountsandtheBankChargesAccountwillbedeleted. Ifyoudeletearowinthescrollingwindow,theanalysisinformation createdforthetransactionwillalsobedeleted. IfyoudeletedatarelatedtobankchargesintheBankTransferCharges window,theanalysisinformationcreatedforthebankchargesaccountwill alsobedeleted. Enteringanalysisinformationforbanktransfercharges TheAnalyticalBankTransferChargeswindowwillopenautomaticallywhenyou pressTABfromtheAmountfieldintheBankTransferChargeswindowforthe firsttime,ifalltherequiredinformationisentered.Thiswillhappen onlyifanyoftheaccountsusedinthetransactionarelinkedtoanaccount classandifanalysisinformationhasnotbeenenteredfortheaccounts. YoucanopentheAnalyticalBankTransferChargeswindowbychoosingCTRL+T intheBankTransferChargeswindow(Transactions>>Financial>>Bank Management>>BankTransfer>>BankTransferscharges)toenteranalysis information. TheAnalyticalBankTransferChargeswindowwillopenautomaticallyifa changeismadeinthebankchargesamountorbankchargesaccountinthe BankTransferChargeswindow. Analysisinformationcreatedforabankchargesaccountwillbedeletedif theamountofchargesisalteredintheBankTransferChargeswindow. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Enteringanalysisinformationforcashreceipts YoucanenteranalysisinformationforcashreceiptsintheAnalyticalCash Receipts Entrywindow.ThiswindowwillopenautomaticallywhenyoupressTABfrom theAmountfieldintheCashReceiptswindowforthefirsttime.Thiswill happenonlyifanyoftheaccountsinthetransactionarelinkedtoan accountclassandifanalysisinformationhasnotbeenenteredforthe accounts. YoucanopentheAnalyticalCashReceiptsEntrywindowbychoosing Transactions>>Financial>>BankManagement>>CashReceipts>> CTRL+TorAdditional>>AnalyticalTransaction. YoucanalsoopentheAnalyticalCashReceiptsEntrywindowfromthe Distributionswindowforcashreceipts(Transactions>>Financial>> BankManagement>>CashReceipts>>Distributions>>Additional>> AnalyticalTransactionorCTRL+T). Youcanusethebrowsebuttontoviewtheotherdistributionsandenter analysisinformation.YoualsocanselectadistributionintheDistribution LookuporenterthedistributionnumberintheDistributionfieldtoviewit inthescrollingwindow. TheAnalyticalCashReceiptsEntrywindowwilldisplayinformationforthe accountthathasbeenlinkedtoanaccountclass.Ifmorethanoneaccount inthetransactionhasbeenlinkedtoanaccountclass,thenthiswindow willdisplayinformationforthefirstofsuchaccounts. ChooseSavetosavethetransactionsyouhaveenteredintheAnalyticalCash ReceiptsEntrywindow. IfyouclearatransactionintheCashReceiptswindow,theanalysis informationenteredforthetransactionwillbedeleted. IfyouclosetheCashReceiptswindowwithoutpostingthetransaction,the analysisinformationenteredforthetransactionwillalsobedeleted. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Enteringanalysisinformationforwriteoffs,termstaken,andrealizedgain/loss Youcanenteranalysisinformationforwriteoffs,termstakenandrealized gain/lossifthepaymentorreceipthasbeenapplied.Youcanopenthe AnalyticalTransactionEntrywindowfromthePayment/Depositswindowand CashReceiptswindowbychoosingCTRL+TorAdditional>>Analytical Payment/DepositTransactionEntry. WhenapaymentorreceiptisappliedinthePayment/Depositwindoworthe CashReceiptswindow,analysisinformationcanbeenteredforaccounts relatingtowriteoffs,termstaken,andrealizedgain/lossiftheyare linkedtoanaccountclass. WhenyoureturntothePaymentwindowafterapplyingapayment,a verificationwilltakeplacetocheckifanyamountexistsforwriteoffs, termstaken,orrealizedgain/lossortaxdistributions.Ifitdoesexist, andiftheaccounttowhichtheamountistobedebitedorcreditedis linkedtoanaccountclass,theAnalyticalPaymentTransactionEntrywindow willopen.Thiswindowwilldisplayinformationrelatingtothefirstof suchaccountsincasethereismorethanoneaccount. Analysisinformationthathasbeenenteredforthecreditor’scontrol accountbeforethetermstaken,writeoffsorrealizedgain/lossisentered willbedeleted.Asingleassignmentforthereviseddistributionamount willbecreated.Thetransactiondimensionsanddefaulttransaction dimensioncodefortheaccountclassthatthecreditorcontrolaccountis linkedtowillbedisplayedintheAnalyticalPaymentTransactionEntry window. WhenyoureturntotheDepositwindowafterapplyingareceipt,a verificationwilltakeplacesimilartopayments.Youcanenteranalysis informationfortermstaken,writeoffs,orrealizedgain/lossbeforesaving thereceipt. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Enteringanalysisinformationfordistributions Youcanenteranalysisinformationforthedistributionscreatedfor transactionsinCashbookBankManagement.TheAnalyticalAccountingwindow canbeopenedfromtheDistributionswindowsthatopenfromthefollowing windows: PaymentsEntry DepositsEntry BankTransferEntry BankTransferCharges CashReceiptsEntry RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. Postingtransactions Avalidationwilltakeplacewhenyouposttransactionsinthefollowing windows: CBMBatchEntry BankTransferEntry CashReceiptsEntry AtransactioncanbepostedonlyafteryouclosetheAnalyticalTransaction Entrywindow. Afterpostingtransactions,theAnalyticalAccountingpostingjournalis printed.Ifthereareerrorsinthetransactions,theAnalyticalAccounting errorlistisprinted. IfyouselectedtoprintcashreceiptsintheCheckbookSetupwindow(Cards >>Financial>>BankManagement>>Setup>>Checkbooks),a validationwilltakeplacewhenyouchoosePost.Ifyouhavenotselectedto printcashreceipts,avalidationtakesplacewhenyouchoosePost.If errorsarefound,theAnalyticalAccountingValidationLogwindowwillopen listingtheMicrosoftDynamicsGPerrorsfirstandthentheAnalytical Accountingerrors. Whenyoupostabanktransfer,thebankchargedistributionsarevalidated firstandifanyerrorsarefound,thentheAnalyticalAccountingValidation Logwindowwillopen. Validatingtransactionsandcorrectingerrors YoucanvalidateanalysisinformationforpaymentsinthePaymentswindowby choosingAdditional>>RunValidationorbypressingCTRL+R.Validation canonlybedoneforasingletransactionatatime. Youcanvalidateanalysisinformationfordepositsbyselectingareceipt andchoosingCTRL+RorAdditional>>RunValidation. AnalysisinformationforbankchargescanbevalidatedwhentheBankCharges windowisopen,bychoosingCTRL+R. YoucanvalidateanalysisinformationfortransactionsintheCashReceipts windowbychoosingAdditional>>RunValidationorCTRL+R RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. Voidingtransactions WhenyouvoidatransactionintheTransactionReconcileorTransaction Inquirywindows,theanalysisinformationenteredforthattransactionwill bereversed.Forexample,youvoidatransactionCBPay001intheTransaction Reconcile(Transactions>>Financial>>BankManagement>>Reconcile >>OK)or TransactionInquiry(Inquiry>>Financial>>BankManagement>> TransactionInquiry)windows.Thistransactionwillhaveassignmentsinthe AnalyticalTransactionEntrywindow.Whenyouvoidthetransaction,a reverseentrywillbecreatedinMicrosoftDynamicsGPandalsoreverse assignmentswillbecreatedinAnalyticalAccounting.TheAnalyticalVoiding postingjournalwillalsobeprintedwhenyouclosetheBankTransaction Inquirywindow. ThiswillhappenonlyfortransactionsvoidedinthePaymentInquiry/Voidor DepositInquiry/Voidwindow. ViewinganalysisinformationinCashbookBankManagement Youcanviewtheanalysisinformationthatyouhaveenteredfortransactions inCashbookBankManagementintheAnalyticalInquirywindow. TheAnalyticalInquirywindowcanbeopenedbychoosingCTRL+TorAdditional >>AnalyticalTransactionafterzoomingtoadocumentorchoosingvoidin theTransactionInquiryorTransactionReconcilewindow. YoucanalsoopentheAnalyticalInquirywindowforcashreceiptsbyzooming onacashreceiptintheDepositInquirywindowandchoosingAdditional>> AnalyticalTransaction. ToviewanalysisinformationinCashbookBankManagement: OpentheAnalyticalInquirywindow. (Inquiry>>Financial>>BankManagement>>TransactionInquiry>> Void>>CTRL+T) TheAnalyticalInquirywindowwilldisplayanalysisinformationforthe firstdistributioncreatedforthetransaction.Choosethebrowsebuttonto viewtheremainingdistributionsorclicktheDistributionlookup.Youcan alsoviewtheotherdistributionsbyenteringthenumberintheDistribution field.Toviewtheanalysisinformationforaparticularreceipt,youcan selectthereceiptintheDepositwindowandthenopentheAnalytical Inquirywindow. Ifyouareviewingabanktransfer,theTransferFromandTransferto Checkbookswillbedisplayed.Thebanktransfernumberrelevanttothe transactionthatyouareviewingwillalsobedisplayed.Ifyouareviewing banktransfercharges,thebanktransfernumber,checkbookIDandcharge numberwillbedisplayed. Ifyouareviewingacashreceipt,thereceiptnumberwillbedisplayed. Ifadepositcontainsmultiplelinesofreceipts,youcanviewanalysis informationforaspecificlineofreceipt.Ifthecursorisonaspecific transactionintheDepositInquirywindow,theninformationfortheaccount associatedwiththedebtororcreditorortheGeneralLedgertransaction willbedisplayed. TheAnalyticalInquirywindowwilldisplaytheanalysisinformationfora distributionaccountindetail,whenopenedinitially.Theamountassigned invalueandpercentageterms,thetransactiondimensions,transaction dimensioncodesandreferenceinformationwillalsobedisplayed. Chapter13:ElectronicBankManagement Youcanenterandviewanalysisinformationforbanktransactions,bank transfers,writeoffs,andtermstakentransactionsenteredinElectronic BankManagement. Thisinformationisdividedintothefollowingsections: Enteringanalysisinformationforbanktransactions Enteringanalysisinformationformatchedtransactions Enteringanalysisinformationforwriteoffsandtermstaken Enteringanalysisinformationfordistributions Enteringanalysisinformationforbanktransfers Postingtransactions ViewinganalysisinformationinElectronicBankManagement Enteringanalysisinformationforbanktransactions Youcancreateassignments,entertransactiondimensioncodes,andreference informationforbanktransactions,ifanyoftheaccountsusedinthe transactionarelinkedtoanaccountclass,intheAnalyticalBank TransactionEntrywindow. TheAnalyticalBankTransactionEntrywindowwillopenautomaticallythe firsttimewhenyousavethetransactionamountintheBankTransaction Entrywindowandalsointhefollowinginstances: Anewtransactionisbeingcreated. Theaccount/sassociatedwiththetransactionarelinkedtoanaccount class. Analysisinformationhasnotbeencreatedforsuchaccounts. AllrequiredfieldshavebeenfilledintheBankTransactionEntrywindow. TheAnalyticalBankTransactionEntrywindowwillopenautomaticallyifyou makethefollowingchangesintheBankTransactionEntrywindow: Changeintheamount(incaseofunmatchedtransactions). Changeindistributionaccount(incaseofGeneralLedgerpaymentsand receipts). SelectingaGeneralLedgerdistributionaccountafteramatchedGeneral Ledgertransactionisunmatched. ChangeinDebtororCreditorID(incaseofunmatchedPayablesManagement andReceivablesManagementpayments/receipts). Changeintaxschedule(incaseofunmatchedGeneralLedgerpaymentsand receipts). ChangeintaxamountintheTaxLookupwindow(incaseofunmatchedGeneral Ledgerpaymentsandreceipts). Inalltheseinstances,theanalysisinformationcreatedfortheoriginal entrywillbedeleted. TheAnalyticalAccountingTransactionwindowwillnotopenifthe transactionamountiszerointheBankTransactionEntrywindow,evenifthe accountsassociatedwiththetransactionarelinkedtoanaccountclass,as nodistributionswouldbecreated. IfyoudeleteatransactionwithanalysisinformationintheBankTransaction Entrywindow,alltheanalysisinformationfortherelevanttransactionwill alsobedeleted. Ifyoudeleteataxscheduleoralterthetaxamountforatransactionwith analysisinformationintheBankTransactionEntrywindow,theanalysis informationforthetaxaccountsandthecheckbookaccountwillbedeletedanda singleassignmentequaltotherevisedamountwillbecreated. Toenteranalysisinformationforbanktransactions: OpentheAnalyticalBankTransactionEntrywindow. (Transactions>>Financial>>BankManagement>>Reconciliation>> SelectStatement>>Transactions>>CTRL+TorAdditional>>Analytical Transaction) TheAnalyticalBankTransactionEntrywindowdisplaysinformationforthe firstdistributionaccountthathasbeenlinkedtoanaccountclass.Toview otherdistributions,enterorselectadistributionnumber.Youcanalsouse thebrowsebuttonstoviewtherequireddistribution. Inthecaseofmulticurrencytransactions,thewindowwilldisplaythe transactionamountoftheaccountdisplayed,andtheassignmentscreatedfor theaccountintheoriginatingcurrency. RefertoEnteringanalysisinformationforGeneralLedgertransactionsfor moreinformationaboutenteringanalysisinformation. ChooseSavetosavetheinformationyouhaveentered. Youcanvalidateindividualtransactionswithanalysisinformationinthe BankTransactionEntrywindowbyselectingatransactionandchoosing CTRL+R.Youcanvalidateallthetransactionswithanalysisinformationby choosingCTRL+RorAdditional>>RunValidation.Ifnoerrorsaredetected duringthevalidationprocess,thereconciliationispostedandthe AnalyticalAccountingPostingJournalisprinted.Iferrorsaredetected, theAnalyticalValidationLogisprinted.RefertoValidatingtransactions andcorrectingerrorsformoreinformation. Enteringanalysisinformationformatchedtransactions WhenyoumatchtransactionsintheMatchTransactionswindow(Transactions >>Financial>>BankManagement>>Reconciliation>>Transactions >>MatchTrans),andchooseOK,theAnalyticalBankTransactionEntry windowwillopen.Thewindowwillopenonlyiftheholdingaccountislinked toanaccountclass,andifthetransactionhasbeenfullymatched. Thetransactiondimensionsandanyexistingdefaulttransactiondimension codesrelevanttotheholdingaccountwillbedisplayed. Analysisinformationcreatedforanyaccountotherthanthecheckbook accountintheBankTransactionswindow,thatisnotrelatedto distributionscreatedaftermatchingtransactions,isdeletedwhenyouclose theMatchTransactionswindow.Analysisinformationcreatedfortaxaccounts intheTaxLookupwindowwillalsobedeleted. Youcanviewtheanalysisinformationcreatedforamatchedtransaction beforeitisposted,intheAnalyticalBankTransactionEntrywindow. Whenyouunmatchamatchedtransactionbeforepostingthereconciliation, analysisinformationforthetransactionapartfromtheanalysisinformation forthecheckbookaccountwillbedeletedonclosingtheMatchTransaction window. Analysisinformationfortransactionsthathavebeenpartiallymatchedwill bedeleted.Theinformationwillonlybedeletedifthetransactionisfully matched,orthetransactionortaxamountisdeletedorifthedistribution ortaxaccountisnolongerlinkedtoanaccountclass. Iftheholdingaccountofthematchedtransactionsislinkedtoanaccount class,andAutoMatchiscompletedsuccessfully,amessagewillappearthat analysisinformationneedstobeenteredforthematchedtransactions.Refer toEnteringanalysisinformationforbanktransactionsformore informationaboutenteringanalysisinformation.Analysisinformationthat wascreatedfortransactionsbeforeAutoMatchwasrunwillbedeletedafter AutoMatchiscompleted. Enteringanalysisinformationforwriteoffsandtermstaken IfyouapplyapaymentorreceiptintheBankTransactionEntrywindow,then analysisinformationmustbecreatedforaccountslinkedtoanaccount class,forwriteoffsandtermstaken. Analysisinformationwillbecreatedforwriteoffsandtermstakenwhenyou closetheApplyPayables/Salesdocumentswindowifanyamountisentered,andif theaccountsarelinkedtoanaccountclass. Analysisinformationthatexistsfordebtor/creditorcontrolaccountbefore enteringtermstakenorwriteoffs,willbedeleted.Asingleassignmentequalto thenewdistributionamountiscreated.Thewindowwilldisplaythetransaction dimensionsanddefaulttransactiondimensioncodesfortheaccountclassthat thecreditor/debtorcontrolaccountislinkedto. Enteringanalysisinformationfordistributions YoucanenteranalysisinformationfordistributionsinElectronicBank Management.TheAnalyticalTransactionEntrywindowwillopenfromthe Distributionswindowsthatopenfromthefollowingwindows: BankTransactionsEntry BankTransfers YoucanpressCTRL+TorchooseAdditional>>AnalyticalTransactiontoopen theAnalyticalTransactionEntrywindow.Thewindowwillonlyopenifthe accountselectedintheDistributionswindowislinkedtoanaccountclass. RefertoEnteringanalysisinformationforbanktransactionsformore informationaboutenteringanalysisinformation. Enteringanalysisinformationforbanktransfers Youcanenteranalysisinformationforbanktransfersiftheaccountsarelinked toanaccountclass,usingtheAnalyticalBankTransferEntrywindow.Youcan opentheAnalyticalBankTransferEntrywindowbyselectinganaccountinthe scrollingwindoworplacingthecursoronanyfieldintheBankTransferEntry window(Transactions>>Financial>>BankManagement>>BankTransfers) andpressing CTRL+TorbychoosingAdditional>>AnalyticalTransaction.TheAnalytical BankTransferEntrywindowwilldisplaythefirstdistributionaccountofthe transactionthatislinkedtoanaccountclass. Inthecaseofmulticurrencytransactions,thewindowwilldisplaythe transactionamountoftheaccountdisplayed,andtheassignmentscreatedfor theaccountintheoriginatingcurrency. RefertoEnteringanalysisinformationforbanktransactionsformore information. Ifthereisachangeintheamountofthebanktransfer,theanalysis informationthatexistsfortheaccountrelatedtothetransferwillbedeleted. Youmustenteranalysisinformationagainforthetransferbeforeitisposted. Youcanthevalidateanalysisinformationthatyouhavecreatedforbank transferschoosingCTRL+RorAdditional>>RunValidation.Iferrorsarefound duringthevalidationprocess,theAnalyticalErrorwindowopens,displayingthe error.RefertoValidatingtransactionsandcorrectingerrorsformore informationaboutvalidation. Postingtransactions WhenyoupostareconciliationfromtheSelectStatementwindow (Transactions>>Financial>>BankManagement>>Reconciliation), analysisinformationcreatedfortransactionsintheBankTransactionEntry windowisvalidated.Ifnoerrorsaredetectedduringthevalidation process,thereconciliationispostedandtheAnalyticalAccountingPosting Journalisprinted.Iferrorsaredetected,theAnalyticalErrorReportis printedaftertheAnalyticalAccountingEditList.Thereconciliationcanbe postedonlyifnoerrorsarefoundduringthevalidationprocess. ViewinganalysisinformationinElectronicBankManagement Youcanviewanalysisinformationcreatedforbanktransactionsandbank transfersintheAnalyticalInquirywindow.Thewindowcanbeopenedfrom theTransactionInquirywindowonlyifyouhaveselectedaspecific transaction. Toviewanalysisinformationforbanktransactionsandbanktransfers: OpentheAnalyticalBankTransferEnquirywindow. (Inquiry>>Financial>>BankManagement>>ReconcileInquiry>> TransactionInquiry>>CTRL+TorAdditional>>AnalyticalTransaction) (Inquiry>>Financial>>BankManagement>>BankTransfers>>CTRL+ TorAdditional>>AnalyticalTransaction) TheAnalyticalInquirywindowdisplaystheanalysisinformationrelatedto thefirstdistributionaccountofthetransactionthathasbeenlinkedtoan accountclass.IfyouselectedamatchedtransactionintheTransaction Inquirywindow,theanalysisinformationwouldrelatedtotheholding accountand/orcheckbookaccountifitislinkedtoanaccountclass. Theanalysisinformationforadistributionaccountisdisplayedindetail. Thisincludestheamountassignedinvalueandpercentageterms,transaction dimensions,transactiondimensioncodesandreferenceinformation. Chapter14:DirectDebitsAndRefundsTransactions Youcancreateanalysisinformationfordirectdebitsanddirectdebit refunds,whenyouprocessDirectDebitsandRefundstransactions.This informationisonlyfordefaulttransactiondimensioncodesthatare assignedtoRequired,FixedandOptionalTransactionDimensionsofthe accountclassthatthetransactiondistributionaccountsusedinprocessing arelinkedto.Forthetransactiondistributionsthatarecreatedon processing,asingleassignmentequaltothedistributionamountiscreated bydefault.Theanalysisinformationwillbecreatedduringprocessingand youcanmodifydefaultinformationinGeneralLedger. InDirectDebitsandRefunds,therewillbenovalidationofanalysis information.However,youwillnotbeabletopostabatchthatoriginates fromDirectDebitandRefundsfromGeneralLedgerifthereareerrorsinthe defaultanalysisinformation,suchasatransactiondimensioncodehasnot beenspecifiedforaRequiredtransactiondimension.Thisbatchwillnot updatepostingaccountsfromGeneralLedgeruntilyouenteracodeforthe transactiondimension. Thisinformationisdividedintothefollowingsections: Analysisinformationfordirectdebitsandrefunds PostingthroughtoGeneralLedgerfortransactionposting Viewinganalysisinformationfordirectdebitsandrefunds Analysisinformationfordirectdebitsandrefunds IntheSelectDirectDebitswindow(Transactions>>Sales>>Select DirectDebits),whenyouselectabatchfordirectdebitandrefundsand chooseProcess,thepaymentsanddebitmemosarecreatedanddefault transactiondimensioncodesloadedandassignmentscreatedfordistribution accountsthatarelinkedtoanaccountclass. Youcancreatemultipleassignmentsormodify/entertransactiondimension codesforthedistributionaccountslinkedtoanaccountclassinGeneral Ledgerafterprocessing.ReferEnteringanalysisinformationforGeneral Ledgertransactionsformoreinformation. PostingthroughtoGeneralLedgerfortransactionposting ForDirectDebitsandRefunds,theoptionPostthroughGeneralLedgerfiles underPostingSetup(Administration>>Setup>>Posting>>Posting)is unavailable.TransactionspostedfromDirectDebitsandRefundsmustbe postedfromGeneralLedger. Viewinganalysisinformationfordirectdebitsandrefunds YoucanviewdefaultTransactionDimensioncodesandassignmentsoftransaction distributionaccountscreatedafterprocessingdirectdebitsandrefundsfrom theSalesDistributionInquiryZoomwindow. (Inquiry>>Sales>>TransactionbyCustomerorTransactionbyDocument>> Selectareceivablesdocument>>DocumentNumberlink) ReferViewinganalysisinformationinReceivablesManagementformore informationaboutviewinganalysisinformation. Chapter15:AnalysisinformationforU.S.Payrolltransactions Youcanenterandviewanalysisinformationfortransactionsenteredinthe U.S.Payrollseries.Youcancreateassignmentsandentertransaction dimensionsandcodesbyassigningadefaultaliastoeachemployee.The defaulttransactiondimensioncodesassociatedwiththealiasisdisplayed forU.S.Payrolltransactions.Youalsocanassignadefaultaliasto displaytransactiondimensioninformationassociatedwiththealiasfora batchofU.S.PayrolltransactionsintheMassPayrollTransactionsEntry window.Youcanmodifytheanalysisinformationbeforepostingthe transactions.Multilevelqueryanddistributionqueriescanbeusedtoview analysisinformationfortheemployees. Thisinformationisdividedintothefollowingsections: Understandinganalysisinformationforpayrolltransactions Definingdefaultdimensionsforpayrolltransactions Enteringanalysisinformationforpayrolltransactions Viewinganalysisinformationforpayrolltransactions Understandinganalysisinformationforpayrolltransactions Youcanenterandviewanalysisinformationforpayrolltransactionsifyou haveregisteredPayrollintheRegistrationwindow(Administration>> Setup>>System >>Registration),andenabledtransactiondimensionsforpayrollinthe AnalyticalAccountingOptionswindow.BesuretomarkthePostinDetail optionforthePayrollseriesinthePostingSetupwindow.RefertoSetting uppostingoptionsforAnalyticalAccountingformoreinformation. WithAnalyticalAccountingforPayroll,youcan: Assignanaliastoacombinationofpostingtype,employee,department, position,andcodeintheAnalyticalPayrollDefaultDimensionswindow. Viewandmodifythedefaultanalysisinformationforapayrolltransaction beforeposting. Viewtheassignmentsinpercentageorhoursfortransactionsotherthan overheadtransactions.Inthecaseofoverheadtransactions,youcanview thisinformationinGeneralLedger. CreateandrunqueriesusingtheDistributionQuerywizardandthe MultilevelQuerywizardtoviewanalysisinformationforselectedemployees. Definingdefaultdimensionsforpayrolltransactions YoucanassignanAnalyticalAccountingaliastoacombinationofposting type,employee,department,positionandcodeforthedefaultdimensionin theAnalyticalPayrollDefaultDimensionswindow.Thedefaulttransaction dimensioncodesassociatedwiththealiasisdisplayedwhenyouentera transactionforthespecificcombination. Todefinedefaultdimensionsforpayrolltransactions: OpentheAnalyticalPayrollDefaultDimensionswindow. (Administration>>Setup>>Posting>>PayrollAccounts>> AnalyticalAccountingbutton) (Administration>>Setup>>Posting>>PayrollAccounts>> Additional>>PayrollDefaults) (Administration>>Setup>>Posting>>AnalyticalAccountingDefault Dimensionsbutton) SelectapayrollpostingaccounttypeinthePayrollPostingTypefield.ThepostingtypesavailableintheU.S.Payrollmoduleareavailableforselection.RefertoU.S.Payrolldocumentationformoreinformation. SelecttheemployeeID. SelectthedepartmentcodeintheDepartmentfield. SelectthepositioncodeinthePositionfield. SelectthepaycodeintheCodefield. SelectanaliasintheAliasfieldasthedefaultaliasfortheemployeeIDandpayrollcombinationdefinedinthiswindow. EnterapercentageforthealiasinthePercentagefield.Youcanenterapercentagevaluebetween0to100%. ChooseOKtosavetheinformationandclosethewindow. Enteringanalysisinformationforpayrolltransactions YoucanenterormodifyanalysisinformationassignedtoU.S.payroll transactions. Formanualchecks,aswellasforPayCodetypeofcomputerchecks,youcan viewandchangethedefaultanalysisinformationduringtransactionentry. ForDeductionandBenefittypeofcomputerchecks,youcaneditthedefault analysisinformationonlyafteryouhaveperformedtheCalculateChecks process. InthePayrollMassTransactionEntrywindow,youcanenteranaliasto assigndefaultanalyticalinformationtoaselectedrangewithinapayroll batch. Toenteranalysisinformationforpayrolltransactions: OpentheAnalyticalPayrollTransactionEntrywindow. (Transactions>>Payroll>>TransactionEntry>>AnalyticalAccounting button) (Transactions>>Payroll>>TransactionEntry>>Additional>> AnalyticalTransaction) (Transactions>>Payroll>>TransactionEntry>>Ctrl+T) (Transactions>>Payroll>>TransactionEntry>>Selectatransaction inthescrollingwindow>>AnalyticalAccountingbutton) (Transactions>>Payroll>>TransactionEntry>>Selectatransaction inthescrollingwindow>>DimensionsButton) (Transactions>>Payroll>>TransactionEntry>>Selectatransaction inthescrollingwindow>>Additional>>AnalyticalTransaction) (Transactions>>Payroll>>TransactionEntry>>Selectatransaction inthescrollingwindow>>Ctrl+T) (Transactions>>Payroll>>ManualCheck>>DistributionsButton >>AnalyticalAccountingButton) (Transactions>>Payroll>>PayrollPostingEdits>>Analytical AccountingButton) TheDistributionfielddisplaysthedistributionaccountselectedinthe PayrollTransactionEntrywindow.Toviewotherdistributionsforthe transaction,enterorselectadistributionnumber.Thefieldnamedepends uponthepathfromwhichyouopenthiswindow. ThesequenceofdistributionsintheAnalyticalPayrollTransactionEntrywindowmaynotcorrespondtothesequenceinthePayrollTransactionEntrywindowbecauseonlyaccountslinkedtoanaccountclassaredisplayedintheAnalyticalPayrollTransactionEntrywindow. FunctionalAmountDisplaysthedistributionamountinthefunctionalcurrency. AssignedDisplaysdistributionamount,hoursorunitsbasedonthepaytypeassociatedwiththecode. UnassignedDisplaystheremainingdistributionamountthatistobeassignedinvalueandpercentage. AccountTheAccountfielddisplaystheaccountrelatedtothedistribution.TheexpansionbuttonwillopentheMicrosoftDynamicsGPAccountEntrywindow.Theaccountdescriptionisalsodisplayed. TheEmployee,Department,Position,CodeandPostingTypefieldsdisplaytheemployeeID,department,position,paycodeandthepayrollpostingtypeforthedistribution. SelectHours/UnitsorthePercentageastheassignmenttypetoassignvalues tothedistributionamount. Hours/UnitsThisoptionisautomaticallyselectedandavailableforpaytypesthatarecalculatedonhourlyorunitbasis.Ifthisoptionismarked,youcanentertheAnalyticalAccountingdistributionsbasedonhours/units. PercentageSelectthisoptiontoentertheAnalyticalAccountingdistributionsbasedonpercentages.Thisoptionisautomaticallyselectedforpaytypesotherthanhoursorunits. Note Iftheoptionhours/unitsisselectedautomaticallyforadistributionandyouchangethedefaultassignmenttypetopercentage,anassignmentof100%iscreatedbasedonyoursetupsinthelinkedaccountsclass. Intheassignmentlistview,anarrowintheNumberfieldindicatesthattheanalysisinformationdisplayedisfortheselectedassignment.Eachassignmentcreatedforthedistributionisdisplayedseparately. Inthelistwindow,enterthehoursorunitsbyvalueorbypercentagedependingontheassignmenttypeselected. NumberDisplaystheassignmentnumber. Hours/UnitsDisplaysthehoursorunitsfortheselectedassignmentbasedonthedefaultpercentagesetupintheAnalyticalPayrollDefaultDimensionswindow.Youcanmodifythisinformationifrequired. Assign%DisplaysthepercentagebasedonyourselectionsintheAnalyticalPayrollDefaultDimensionswindow.Youcanmodifytheassignmentpercentageifrequired. Youcansaveanalysisinformationforadistributioneveniftheassignmentisnot100%.However,youcanpostatransactionwithpartialassignmentsonlyifyouhaveoptedtoallowpartialassignmentsduringpostingforthePayrollmodule.RefertoSettingupassignmentoptionsformoreinformation. AliasDisplaysthealiasforeachassignmentbasedonthedefaultaliasdefinedintheAnalyticalPayrollDefaultDimensionswindow.Youcanselectadifferentaliasifrequired. EnterthereferenceinformationfortheassignmentintheReferencefield. TheTrxDimensioncolumndisplaystransactiondimensionsoftheaccountclassthatthedistributionaccountislinkedto.OnlytransactiondimensionsthathavebeensetasRequired,Fixed,orOptionalaredisplayed. TheAlphanumericcolumndisplaysthedimensioncodesassignedtothecorrespondingtransactiondimensionintheAliasMaintenancewindowandtothetransactiondimensionsoftheaccountclassofthedistributionaccountintheAccountingClassMaintenancewindow. EnteratransactiondimensioncodeintheNumeric,Yes/NoorDatefieldfor aNumeric,BooleanorDatetypeTransactionDimension. ChooseDeleteRowtodeleteasinglerowintheassignmentListView.You cannotchoosethisoptionifonlyasingleassignmenthasbeenentered. ChooseRemainingtoaddoneassignmentfortheremainingunassignedamount. Thenewassignmentwillensurethatthetotalassignedamountequalsthe distributionamount.Forexample,ifthedistributionamountis$100and youhaveenteredfourassignmentsthattotal$75.Whenyouchoose Remaining,afifthassignmentfortheremainingvalue,$25iscreated.This buttonisnotavailableifthedistributionfieldisblankorhasazero valueorifthedistributionamountisfullyassigned. ChooseDefaulttoloadthecurrentsetupinformationspecifiedforthe accountclassintheAccountingClassMaintenancewindowandcreateasingle assignment.Thefollowingprocesseswilloccur: Fixed,Required,andOptionalTransactionDimensions(includinghidden transactiondimensions)willbeinstalled. Alltheassignmentsthatyouhavecreatedforthecurrentdistribution willberemovedandcreateasingleassignmentthatisequaltothe distributionamountwillbecreated. IftheanalysistypeischangedtoorfromNotAllowed,transaction dimensionswillbeaddedorremoved. Transactiondimensionsthathavebeendeletedwillberemoved. ChooseOKtosaveyourchangesandclosethewindow.Theanalysis informationthatyouhaveenteredisvalidatedwhenyouchooseOK. ChooseValidatetovalidatetheanalysisinformationofthedistribution displayedinthewindow.Ifchangesaremadetotheaccountclassinthe AnalyticalAccountingsetuporerrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogwindowwillopenwhereyou canviewtheerrorsorchanges.RefertoValidatingtransactionsand correctingerrorsformoreinformationaboutvalidation. ChoosePrinttoprinttheerrorreport.ChooseOKtoclosethewindowandreturntotheAnalyticalPayrollTransactionEntrywindow. ChooseCleartoclearthevaluesdisplayedintheAnalyticalPayroll TransactionEntrywindow. ChooseValidatetovalidatetheanalysisinformationofthedistribution displayedinthewindow.Ifchangesaremadetotheaccountclassinthe AnalyticalAccountingsetuporerrorsarefoundduringthevalidation process,theAnalyticalAccountingValidationLogwindowwillopenwhereyou canviewtheerrorsorchanges.RefertoValidatingtransactionsand correctingerrorsformoreinformationaboutvalidation. ChooseSavetosavethedefaultormodifiedanalysisinformationyouhave entered. ChoosetheprintericonbuttontoprinttheAnalyticalAccountingeditlist forthecurrentdistributiondisplayedorforalldistributionsofthe transactionlinkedtoanaccountclass.TheAnalyticalAccountingValidation LogreportwhichdescribestheAnalyticalAccountingerrorsalsoisprinted. Viewinganalysisinformationforpayrolltransactions YoucanusetheAnalyticalPayrollTransactionEntryZoomwindowtoview analysisinformationforpayrolltransactionsgeneratedfromtheU.S. Payrollmodule. Toviewanalysisinformationforpayrolltransactions: OpentheAnalyticalPayrollTransactionEntryZoomwindow. (Inquiry>>Payroll>>CheckHistory>>Distributionsbutton>> Selectadistributionaccount>>AnalyticalAccountingbutton) (Inquiry>>Payroll>>CheckHistory>>Selectatransaction>> Additional>>AnalyticalTransaction) TheAnalyticalPayrollTransactionEntryZoomwindowdisplaysallanalysisinformationcreatedforadistributionaccount.Thefirstdistributionaccountofthedocumentlinkedtoanaccountclassisdisplayed.Enterorselectadistributionnumbertoviewanalysisinformationforotherdistributionaccounts. Choosetheplusbutton(+)availablenexttoeachassignmenttoviewall analysisinformationenteredforanassignmentorchoosetheminusbutton (-)toviewonlyreferenceinformationthatmayexist. ChooseOKtoclosethewindowafterviewingtheinformationrequired. Seealso MicrosoftDynamicsGPAnalyticalAccounting MicrosoftDynamicsGPAnalyticalAccountingPart3:Routines,InquiriesandReports MicrosoftDynamicsGPAnalyticalAccountingGlossary Feedback Submitandviewfeedbackfor Thisproduct Thispage Viewallpagefeedback Inthisarticle