KB 945955- Guidelines to follow when you generate EFT files ...

Describes troubleshooting tips to use when you generate Electronic Funds Transfer (EFT) files or EFT Prenote files in Electronic Funds Transfer for Payables ... Skiptomaincontent Products Microsoft365 Office Outlook MicrosoftTeams OneDrive OneNote Windows MicrosoftEdge more... Devices Surface PCaccessories Mobile Xbox PCGaming HoloLens Hardwarewarranties What'snew Account&billing Account MicrosoftStore&billing Templates Moresupport Communityforums Microsoft365Admins SmallBusinessAdmins Developer Education Reportasupportscam MicrosoftDynamicsGP2015DynamicsGP2013DynamicsGP2010DynamicsGP2016DynamicsGP2018DynamicsGPMore...Less KB945955 Appliesto:MicrosoftDynamicsGP(Allversions) INTRODUCTION ThisarticlecontainsguidelinestofollowwhenyougenerateElectronicFundsTransfer(EFT)filesorEFTprenotefilesinElectronicFundsTransferforPayablesManagementinMicrosoftDynamicsGP10.0andhigherversions,andReceivablesManagementinMicrosoftDynamicsGP2010andhigherversions.   MoreInformation Followtheseguidelines togenerateEFTfilesorEFTprenotefiles: NoteBeforeyoufollowtheinstructionsinthisarticle,makesurethatyouhaveacompletebackupcopyofthedatabasethatyoucanrestoreifaproblemoccurs. OPTION1:PreauthorizationrequiredforEFT Ifyouselectedthe PayablesPrenoteRequiredcheckboxorReceivablesPrenoteRequiredcheckbox,theEFTprenotefilewillneedtobegeneratedfirstbeforethesystemwillgeneratearegularEFTfile. TogenerateanEFTprenotefile,followthesesteps: OntheCardsmenu,pointtoFinancial,andthenclickCheckbook. IntheCheckbookMaintenancewindow,entertheappropriatecheckbookIDintheCheckbookIDbox,andthenclickEFTBank. IntheCheckbookEFTBankMaintenancewindow,clickPayablesOptions.(orReceivablesOptions) IntheEFTPayablesOptions (orReceivablesOptions)area,verify ifthe PayablesPrenoteRequired (orReceivablesPrenoteRequired)checkboxisselected.Ifthe PayablesPrenoteRequired (orReceivablesPrenoteRequired)checkboxisselected,followtheappropriatemethod: Method1:Clicktoclearthe PayablesPrenoteRequired (orReceivablesPrenoteRequired)checkboxto notrequireaprenotefile. Method2:Click GeneratePrenotes toproceedtogeneratetheprenotefileifrequiredbythebank. ClickOK twotimestoclosethewindows,andthenclick Save. OPTION2: EFTPaymentdoesnotpullforvendor Certainfieldsbetweenthecheckbookandvendor(orcustomer)mustmatchinorderfortheEFTfileorEFTprenotefiletogenerate.Thesefieldsincludethe CurrencyID(ifyouhavemulticurrencyinstalled),CountryCode,andBankCountry/Region.Thesefieldsarenotrequired,butiftheyarefilledinoneitherside,theothersidemustmatch.Toverify,useonethefollowingsteps: OntheCardsmenu,pointto Financial,andthenclick Checkbook. IntheCheckbookMaintenancewindow, selecttheappropriatecheckbookIDinthe CheckbookIDbox. VerifyifaCurrencyIDisfilledinornotontheCheckbookMaintenancewindow.TakenoteoftheCurrencyIDfield. ClickEFTBank. IntheCheckbookEFTBankMaintenancewindow,takenoteofwhattheBankCountry/Regionfieldissetto,andifaCountryCodeisfilledin. Click OK toclosethewindow,andthenclick Save. NowverifythatthesefieldshavethesamevaluesontheVendororCustomer.FollowthemethodbelowdependingonwhetheryouaretryingtogenerateanEFTfileforPayablesorReceivables: Payables:OntheCardsmenu,selectPurchasingandclickVendor. Receivables:OntheCardsmenu,selectSalesandclickCustomer. IntheVendorMaintenance(orCustomerMaintenance)window,selecttheappropriateVendorID(orCustomerID). ClicktheAddressbuttonandselecttheappropriateAddressIDusedforEFT. VerifythevalueintheCountryCodefieldmatcheswhatyoufoundonthecheckbookabove.(Thisisnotarequiredfield,soit must matchorbeblankon bothsides.) Click EFTBank. IntheVendor(orCustomer)EFTBankMaintenancewindow,verifywhatvalueisinthe BankCountry/RegionfieldandtheCurrencyID fieldtomakesurethesevaluesmatchwhatyoufoundonthecheckbook.Changeanyvaluesasneeded. ClickOK toclosetheVendor(orCustomer)EFTBankMaintenancewindow.Click Save toclosetheVendor(orCustomer)AddressMaintenancewindow. IntheVendorMaintenance(orCustomerMaintenance)window,clickthe Optionsbutton. VerifythevalueintheCurrencyIDfield,andtheCheckbookIDfield. (Note:ForReceivables,youwillfindtheCheckbookIDontheAccountstab,nottheOptionstab.) ClickOKtoclosethewindow.ClickSavetoclosetheVendorMaintenancewindow. NowtesttheEFTfileorEFTprenotefileagain. OPTION3:ErrorwhentryingtogenerateEFTfile: Ifyoudonotspecifyabankfileformat,youreceivethefollowingerrormessagewhenyoutrytogeneratetheEFTfile: Theselectedcheckbookisnotsetupwiththepayablesfileformat.TheEFTfilecannotbegenerated. Theselectedcheckbookisnotsetupwiththereceivablesfileformat. TheEFTfilecannotbegenerated. YoumustspecifyabankfileformattogeneratetheEFTfile.Todothis,followthesesteps: OntheCardsmenu,pointto Financial,andthenclickCheckbook. IntheCheckbookMaintenancewindow,entertheappropriatecheckbookIDintheCheckbookIDbox. ClickEFTBank,andthenclickPayablesOptions(orReceivablesOptions dependingonifyouareworkingwithEFTforPayablesorEFTforReceivables). IntheFileFormat area,clickthelookupbuttontoselectanEFTfileformatIDfortheSingleFormatifonlyusingoneformatforallvendors(orcustomers)orBasedonVendorifyouareusingdifferentformatsfordifferentvendors(orcustomers). Note ClicktheblueexpansionarrowbuttonnexttotheformatfieldstodrillbacktotheEFTFileFormatMaintenancewindow.OryoucankeyanewIDrightinthiswindowandthesystemwillpromptyouifyouwouldliketoaddthisasanewformat.OrtonavigatedirectlytotheEFTFileFormatwindow,pointto FinancialontheCardsmenu,andthenclickEFTFileFormat. ClickOK twotimestoclosethewindows,andthenclick Save. OPTION4:ErrorwhentryingtogenerateEFTfile: IfyoudonotspecifyapathofthelocationwhereyouwanttosavetheEFTfileoutputortheprenotefileoutput,youreceivethefollowingerrormessagewhenyoutrytogeneratetheEFTfile: TheEFTfilecouldnotbegeneratedinthepathspecifiedforPayablesPrenoteFileinCheckbookEFTPayablesOptions. TheEFTfilecouldnotbegeneratedinthepathspecifiedforReceivablesPrenoteFileinCheckbookEFTReceivablesOptions. YoumustspecifythepathofthelocationwhereyouwanttosavetheEFTfileoutputortheprenotefileoutput.Todothis,usethestepsbelow: OntheCardsmenu,pointtoFinancial,andthenclickCheckbook. IntheCheckbookMaintenancewindow,entertheappropriatecheckbookIDintheCheckbookIDbox. ClickEFTBank. ClickPayablesOptions(orReceivablesOptionsdependingonifyouareusingEFTforPayablesorEFTforReceivables). IntheDefaultOutputFilesarea,specifythelocationwhereyouwanttosavetheEFToutputfiletoforallthreelinesevenifyouwon'tbeusingthem. Note:Ifthisisanewsetup,werecommendtoalwaysgeneratethetestEFTfilestoa localdrivefirsttomakesurethefilewillgeneratewhileyoutest.Oncethefilegeneratestoalocaldrive,thenyoucanchangethepathsfortheoutputfilestoashareddriveifneededandverifyitstillworks.Thismethodtakesanypermissionsissueswiththeshareddriveoutofthepicturewhileyoutest.) Note:Intheoutputpaththatyouchoose,makesurethefoldersorfilenameyousavetodonothaveanyspaces,periods,numbersorspecialcharacters(periods,dashes,etc).Forexample,ifyounamedthefile'prenote1.txt'or'prenote1.txt',youshouldmakeit'prenote.txt'instead(removingthenumber). OrifthepathisJ://Payables/Payments/Jane.Doe/Payment.txt,theperiodintheJane.Doefolderwouldcauseanissue.  Testsavingtojust J://Payables/Payments/payment.txtinsteadtomakesureitworksatthisfolderlevelonthesamedrive.  Makesurethepathisnottoomanyfoldersdeep.(lessthan3folders) MakesurethepathisnotlongerthanthevisiblelengthofthefieldintheGPwindow. IfusingWebclient,makesuretotestonthethickclient. Note:Ifyouwouldlikethefilenametohaveanextension,enteritrightintheoutputfilepath.Forexample,namethefileas'prenote.txt'ifyouwantthe.txtextensionontheoutputfile. Ifusingamappeddrive,makesuretheusercansaveanyotherfiletothatlocationmanually.  Ifusingamappeddrive,makesurethedriveismappedtothesameletteroneachworkstation.  Ifusingamappeddrive,makesurethedriveismappedonthenetworktothesameletter.  ConsultyourlocalITstaffforfurtherassistancewithpermissionswithinyourownenvironmenttosharedlocations. Usersshouldhave'fullcontrol'access. ClickOK twotimestoclosethewindows,andthenclick Save. OPTION5: EFTfiledoesnotgenerateforspecificcheckbookID IfthecheckbookIDcontainsanyspecialcharacters,suchasadash(-),aslashmark(/),oranapostrophe('),useadifferentcheckbookIDorcreateanewcheckbookIDthathasnospecialcharacters. AfteryougenerateEFTfilesorEFTprenotefilesbyusingadifferentcheckbookIDoranewcheckbookID,youmustchangethecheckbookIDinalltables.Todothis,useoneofthefollowingmethods. Method1 UsethecheckbookmodifiertooltochangethecheckbookIDinalltablesbyusingtheProfessionalServicesToolsLibrary. Method2 UseanSQLquerytooltochangethecheckbookIDinalltables.Todothis,followthesesteps: StartSQLServerManagementStudio.Todothis,seethe"HowtostartaSQLquerytool"section. RunthefollowingscripttolocatealltablesthatcontaintheCheckbookIDfield(CHEKBKID). select*fromsysobjectso,syscolumnsc whereo.id=c.id ando.type='U' andc.name='CHEKBKID' orderbyo.name RunthefollowingscripttochangethevalueofthecheckbookIDonalltablesthatusethecheckbookID. updatesetCHEKBKID=''whereCHEKBKID='' NoteInthisscript,theplaceholderisaplaceholderforthenewcheckbookIDthathasnospecialcharacters.TheplaceholderisaplaceholderforthepreviouscheckbookID. OPTION6: ErrorwhengeneratingEFTfile: IfyourecentlyupgradedtoMicrosoftDynamicsGP10.0orGP2010,youmayreceivethefollowingerrormessage: Thebank/countryassignedtothevendorsremittoaddressismissingorinactive.Assignthebank/countryregiontotheaddressoractivatetheformat. Ifyoureceivethiserrormessage,checkthePM20000(PM_Transaction_Open)tabletomakesurethatthevendoraddressesintheVADCDTROcolumnarethesameaddressesforthevendorsintheearlierversion.TheVADCDTROcolumninthePM20000tablemustmatchtheVADCDTROcolumninthePM00200(PM_Vendor_Master)tableforeachvendor.Todeterminewhichvendorgeneratestheerrormessage,useoneofthefollowingmethods.Method1 InMicrosoftDynamicsGP,pointtoPurchasingontheCardsmenu,andthenclickVendor. IntheVendorMaintenancewindow,entertheappropriatevendorIDintheVendorIDbox. IntheAddressIDsarea,clicktheRemitTohyperlink,andthenclickanaddressIDinthepop-upwindow. Method2 StartSQLServerManagementStudio. Runthefollowingscriptagainstthecompanydatabase. UpdatePM20100setVADCDTRO='REMITTO'whereVENDORID='' NoteInthiscode,theplaceholderisaplaceholderfortheactualvendorID. MakesurethattheVADCDTRO(VendorAddressCode-RemitTo)columninthePM20000tablematchestheVADCDTROcolumninthePM00200table.Additionally,makesurethattheVADCDTROcolumninthePM20100(PM_Apply_To_OPEN_OPEN_temporary)tablematchestheVADCDTROcolumninthePM00200tableandinthePM20000(PM_Transaction_Open)table. OPTION7: EFTfiledoesnotgenerate,noerror.  IfyourecentlyupgradedtoMicrosoftDynamicsGP10.0orGP2010fromaGP9.0orpriorversion,youmustmanuallyenterthebanknameinthe BankNamebox. NoteTheBankName boxdoesnotexistinMicrosoftDynamicsGP9.0andpriorversions. TomanuallyenterthebanknameintheBankNamebox,followthesesteps: OntheCardsmenu,pointtoPurchasing,andthenclickVendor. IntheVendorMaintenancewindow,entertheappropriatevendorIDintheVendorIDbox. ClickAddress,andthenclickEFTBank. IntheBankNamebox,entertheappropriatename. ClickOK,andthenclick Save. ClosetheVendorAddressMaintenancewindow. IntheVendorMaintenancewindow,click Save. MOREINFORMATION   Commonly AskedQuestions: Q1:WhendoesasupportcaseforEFTassistancebecomeaconsultingexpense?HowlongcanIkeepanEFTsupportcaseopen? A1:SettinguptheEFTfileformatwouldbeconsideredaconsultingexpense.Eachsupportincidentshouldbescopedtoaddress1fieldorerrormessagepercase.Eachnewquestionorerrormessagethatcanberesearchedseparatelyfromtheoriginalscopedefinedinthecaseshouldbeputonanewsupportcase.SoifthebankrejectsthetestEFTfileandgivesyouanewerrormessagetotroubleshoot,weaskthatyouopenanewsupportcaseforthenewissue.TheseguidelinesarepublishedintheEbankingconfiguratorsectionofKB850201: 850201GuidelinesthatMicrosoftsupportprofessionalsusetodeterminewhenasupportcasebecomesaconsultingengagementforReportWriter,SmartListBuilder,SQLscripts,BusinessAlerts,VBScript,Modifier/VBAandeBankingConfiguratorFileshttp://support.microsoft.com/help/850201Q2:HowdoyouinstallEFTforPayablesorEFTforReceivables?Andhowdoyouverifyitisworking? A2:EFTforPayableswasmovedintothecoredictionaryinMicrosoftDynamicsGP10.0andhigherversions,andEFTforReceivableswasmovedintothecoredictionaryinMicrosoftDynamicsGP2010andhigher.Therefore,thereisnoseparateinstallationanymore.Theonlyrequirementisthatthemoduleislistedinyourregistrationkeys. ToactivateEFT,clickonToolsundertheMicrosoftDynamicsGPmenu,pointtoSetup,pointtoSystemandclickRegistration.MakesuretheappropriatemoduleofEFTPayablesorEFTReceivablesismarkedasappropriate.  Toverifyitisworkingfortherespectivemodule,clickonCards,pointtoPurchasing(orSales),andclickonVendor(orCustomer).EnteraVendorID(orCustomerID)andclickontheAddressbutton.IfyouseeabuttonnamedEFTBANKinthelowerrightcorneroftheVendor(orCustomer)AddressMaintenancewindow,thenEFTisworking. Q3:Areyouabletosend'invoice'informationintheEFTfile? A3:Yes,thisiscalledthe'Addenda'line.YouwillneedtomapouttheLineTypeforthe'Addenda'lineontheEFTfileformataccordingtoyourbank'sspecifications.Asmanyaddendalineswillprintforhowevermanyinvoicesmakeupthepayment. AddendalinesonastandardNACHAformattypicallystartwitharecordtypecodeof'7'. Q4:AreyouabletosendmultipleaddendalinesintheEFTfile? A4: Yes.ThefunctionalityforaddendalinesworksdifferentlyindifferentversionsofDynamicsGP,sotheanswerwilldependonwhatversionyouareusing.InGP10.0,youareabletosendonly0or1addendalineperpayment.GP10.0doesnothavefunctionalitytoincludemultipleaddendalinesforonepayment.InGP2010RTM,youareonlyabletosend0orAlladdendalinesperpayment.HoweverinGP2010SP2,additionalfunctionalitywasaddedsoyoucansend0,1,orAlladdendarecordsforeachpaymentbyutilizingthenewlyaddedcheckboxfor"DetailLineAddenda"foundontheEFTFileFormatMaintenancewindow.MoreinformationonthistopiccanbefoundinKB2551488. 2551488MultipleAddendaLinesintheEFTfileinMicrosoftDynamicsGPhttp://support.microsoft.com/help/2551488Q5:Areyouabletoputmultipleinvoicenumbersinoneaddendaline? A5:No.Eachaddendalinewouldstoretheinformationforeachinvoicethatmakesupthepayment.Soforexample,ifyouhave6invoicesthatmakeupthepayment,youwouldget6addendalinesifyouchosetoincludealltheaddendalines.Thereisnofunctionalitytoincludeall6invoicenumbersonthesameaddendalineatthistime. Q6:AreyouabletoconfigureanyEFTfileformattoproducea"CheckPrintingFile"format?(ManybanksarenowofferingthisservicetoprintchecksandrequireanXMLformatwhereeachaddendalinewouldbeinit'sownremittanceformat.) A6:Youareonyourowntotest.  Atthistime,MicrosoftDynamicsGPdoesnotofferorsupport"CheckPrintingFile"formatssinceitisacustomizedfileandnotatrue'EFT'fileformat. Itisforadifferentservicethatisprovidedbyyourbank.  TheEFTfunctionalityinDynamicsGPiscodedtoachievetheEFTfileformatsthatareincludedoutofthebox,sotheremaybesomerequirementsyoumayormaynotbeabletoachieve.YouwouldneedtotestonyourowntoseeiftheformatyouneedcanbedoneinDynamicsGPwiththecurrentEFTfunctionality,ornot. Ifyouopenasupportcase,youcanexpectthesameassistancewithadvisingononefieldoroneerrormessagepersupportincident. Oftentimesadexteritycustomizationmaybeneeded,whichisoutsideofregularsupportguidelines.  Onerequirementwehaveseenforanxmlformat, whereeachremittanceinformationislistedinit'sowngroupingwouldneedadexteritycustomizationtoachieve.We encourageyoutovoteonthisproductsuggestionintheMicrosoftIdeas productsuggestiondatabasesothisfunctionalitycanbereviewedforafutureenhancement.Q7:DoestheEFTbankinginformationflowthroughanupgrade? A7:Thebankinginformationonthevendorandthecheckbookarebroughtthroughtheupgrade.ThebankinginformationonthevendorwillbewrittentotheSY06000tableandwillusethevendor'smainaddressfoundontheVendorMaintenancecard.TheonlyinformationthatisnotbroughtthroughtheupgradeistheEFTfileformat.Youwillneedtore-setuptheEFTfileformatinGP10.0orGP2010,byeithersettingitupfromscratchyourself,orpickingfromoneofthestandardformatsalreadysuppliedinthepick-list.ItmaybehelpfultomakescreenprintsofthefileformatsetupinGP9.0toreferto.GP10andGP2010havestandardfileformatsavailabletochoosefrom,aspublishedbytheNationalAutomatedClearingHouse(NACHA).Wecodetothesestandardpublishedformats,soifyourbankrequiresanyotherformat,oracustomizationtothestandardformat,wewouldconsiderthattobeaconsultingrequest.Q8:WhatEFTfileformatsaresuppliedinGP2010andGP2013? A8:GP10.0andGP2010andGP2013offertenstandardEFTfileformatsthatarepublishedaccordingtothestandardrequirementssetbythefederalbankingagenciesandNationalAutomatedClearingHouse(NACHA).Oneuser-definedfileformatisalsoavailablesotheusercansetituphowevertheywish.UsethebelowKBtoseehowtheBankGroupsinGP9.0correspondtothenewFileFormatsofferedinGP10.0andGP2010: 945789HowEFTforPayablesManagementbankgroupsinMicrosoftDynamicsGP9.0correspondtoEFTformattypesinMicrosoftDynamicsGP10.0http://support.microsoft.com/help/945789 ThisKBarticleshowshowthetablesarecross-referencedfromversionGP9.0toGP10.0andGP2010:Q9:WhatifmybankusesafileformatthatvariesslightlyfromoneofthestandardformatsofferedinGP? A9:TheEFTfileformatsavailableinMicrosoftDynamicsGParesetuptofollowtheUSGovernmentandNACHA(NationalAutomatedClearingHouseAssociation)publishedformats.Thesearepublishedstandardrequirements.ThefileformatscurrentlyofferedinMicrosoftDynamicsGParecodedtoachievetherequiredfieldsinthesestandardformats. Therefore,ifyourbankrequiresaformatthatvariesslightlyfromoneofthestandardformatsofferedinGP,oramoreupdatedversionofaformat,youmayneedtopursueaconsultingserviceforthecustomization. Inthemeantime,youcouldcheckwiththebanktoseeiftheywouldmakeanexception,oracceptanyotherformatsthatDynamicsGPcando(suchasoneofthestandardNACHAformats),oredittheEFTfileinNotepadbeforesendingittothebank.  YoucansearchtheMicrosoftISVCentralfindanISVthatmayofferanEFTproductcompatiblewithDynamicsGPorcouldhelpyouachieveacustomizationtomeetyourneeds: Pleasealsoenter aProductSuggestionintheIdeas linksoMicrosoftcantrackitandconsiderthisnewfunctionalityforafutureenhancement.  Q10:MybankdoesnotuseanyoftheEFTFileformatslistedinGP.HowcanIcreateanewformattocomplywithmybank? A10:Youcanusethe user-definedEFTfileformattocreateyourownformat.However,youareresponsibleforsettingitupandtestingit.Microsoftisnotabletosupportyourcustomformat.Wewillhelpyouwithonefieldorerrormessagepercase. Youcanalsotrytosetuptheformatyourself.Ifyoutacklethisyourself,wesuggestsettingupanothersampleformatusingoneoftheformatsinthesystemsuchasthePPDorCCDfileformatandusethatasareferencesoyoucanseehowthefieldsaremappedandyoucanmirroryourformatthesameway(orstartwiththePPDorCCDformatandmodifyitasneeded).Thisshouldhelpyouaccomplishmostfields.However,allthefieldsyouneedmaynotbeavailable,ormayappeartobeavailablebutdon'twork(suchascountsortotals). Justbecauseyoucanselectatable/fieldinalinedoesnotmeanthatitwillwork. (Forexampleputtingcheckinformationinan'addenda;line.) Youwouldhavetotestittoverify. Youwillneedtotestonyourowntoverifywhatfieldsworkinwhatlines. TheformatinDynamicsGPwerecodedaccordingtotherequiredfieldsineachlineperthestandardpublishedformatsbytheNationalAutomatedClearingHouseAssociation(NACHA). YoucanvisitNACHA.orgtoviewtherequiredfieldsforeachstandardformat. Q11:HowdoyousetupsettlementlinesfortheEFTFileformat?(Orthebankisaskingforatotaldebitorcreditlineinthefooterthatwilloffsetthefile.) A11:AsettlementlineisbasicallywherethebankisaskingfordebitandcreditlinesintheEFTfilethatwillbalanceeachotherout.Youcanhaveonesettlementlineperdetailline,oronesettlementlineforthewholefile.ThebelowKBshowsyouhowtocorrectlysetuponesettlementlineforthewholefile: 2026313SettlementLinecalculatesincorrectlyintheElectronicFundsTransfer(EFT)fileforPayablesManagementinMicrosoftDynamicsGPhttp://support.microsoft.com/help/2026313Q12:WhatisanIATformat? A12:TheIATformatsareprovidedtoaccommodatechangesintheIAT(InternationalACHTransaction)rulesasmandatedbytheNACHAandOFACorganizationsforusewithinternationalACHfiles.   TheIATformatcontains7addendalines,whereeachlineiscodedtoincludespecificTransaction,companyorvendorinformation.  Notethatthe'Remittanceaddenda'linewasnotcodedinthisformatsinceitisnotrequiredinformationinthestandardpublishedformat. Youwouldnotbeabletosubstituteanyoftheother7addendalinestoincludetheremittanceinformation(ie.invoicesthatmakeupthepayment.) VisitNACHA.orgtoviewthestandardpublishedformatandrequiredfields. Q13:WhatdoesPPDandCCDmeanforthestandardUSNACHAfiles?Whatdoesthe+meannexttoeach?  A13:Thesetypesmean: PPDmeans'Prearrangedpaymentanddeposits'.Usedtocreditordebitaconsumeraccount.Popularlyusedforpayrolldirectdepositsandpreauthorizedbillpayments. CCDmeans'Corporatecreditordebit'.Primarilyusedforbusinesstobusinesstransactions. The+nexttoeachfileformatmeansthatthefileformatincludesmappingfortheAddendaLineType. Q14:WhyistheBank/TransitRoutingnumberintheEFTfilesetsetto10digitsifmostUSroutingnumbersareonly9digitslong?  WheredoIenterthecheckdigitforthebankroutingnumber?  A14:TheTransitRoutingnumberfieldismeanttoholdthe9digitsoftheroutingnumber,plusthe1CheckDigitnumberbehindit,foratotalof10digitsintheBankTransitroutingnumberfield.Thebankmaysplitthesetwofieldsseparatelyonyourbankspecifications,soyoucanchooseifyouwanttolumpthemtogetherinonefieldinyourEFTfilemapping(as10digits),orsplitthemoutastwofields.Forexample,mapthebanktransitroutingnumberasonefieldthatis9digitslong,andthenmapanotherfieldas1digitandhard-codeitasaconstanttothevalueyouneed(usually1).  Q15:HowdoIhandletheBankTransitRouting numberwhenitisonly8digitslonginCanada? A15:Canadausedtohavean8digitroutingnumber,butchangeditto9digitstomatchtheUnitedStates.Theyjustaddeda0inthefrontoftheexisting8digitroutingnumber.  Also,itmayfliptheroutingnumberaroundinRM/PMEFTfileformatsforCanada. Youcanonlykey8charactersanditassumesyouareenteringitdirectlyfromaCanadiancheque,wheretheMICRnumberlisted isBBBBBAAA,whereBBBBisa5digittransitorbranchnumber,andtheAAAistheinstitutionnumber. SoGPassumesitwasenteredthiswayandflipsaroundforyousoitis0+AAA+BBBBBintheEFTfile. (Andright-justifiedandpaddedwithaleadingzerotobe9digitslong.)  Sobeawarethatthelast3digitswillbemovedtothefront,withthepaddedleadingzero. Soifyouenter45678123(BBBBBAAA),itwillgetflippedaroundto0+123+45678inthefile. YouwillwanttoenteritinGPwiththefirst3digitsattheend. Soifyouhave12345678,youwillenter45678123(BBBBBAAA)inGP.  SeeKB2535946forfurtherdetails: http://support.microsoft.com/help/2935946 Q16:Whydon'tthe'count'linesworkinallthelinetyperows?  A16:Unfortunately,thecountfieldsmaybeavailabletoselectinthemappingforanyline,buttheydonotworkinalltheLineTypesatthistime.   AddendaCount-onlyworksintheAddendaLinetype.ThiscountfielddoesnotworkintheDetailline,orBatchControllineorFileControlline. LineCount,DetailCount,Detail+AddendaCount,DetailCount,TotalNumberofDebits,TotalNumberofCreditswillonlyworkintheBatchControlandFileControllines.ThesefieldswillnotworkinFileheader,DetailorAddendalines. Thisiscurrentlybydesignandwillbeconsideredasafutureenhancement. Q17:Thebankisaskingmetoaddpadblocksor'blockcount10'totheEFTfileformat.Whatdoesthatmean? A17:PadBlockingor'blockcounts'requires EFTfilestohaveacertainnumberoflinesinitormultipleoflinesinthefilecreated.Forexample,iftheyrequireaPadBlockof10,thismeansthattheywantthefiletobeinmultiplesof10lines.Soifthefileis22lines,thesystemwillneedtoadd8dummylinessothetotallinecountofthefileis30.Or,ifthefileis49lineslong,thenthesystemwouldonlyneedtoadd1dummylinetogetthefiletobe50lines.Thetotalnumberoflinesofthefileneedstobeinamultipleof10. 1.OpentheEFTFileformatinDynamicsGP(Cards|Financial|EFTfileformat) 2. SelectthefileformatID.  3.Intheupperrightsection,markthecheckboxfor'AddPadBlocks'.  4.Definethepadcharacter,numberofpaddedcharactersandblockcountrequiredbyyourbank. Themostcommonscenarioistopada'9'characterinblocksof10. Thiswould beenteredas:      Padcharacter:  9      Numberofpadchars: 94  (widthoflineneeded)      Padlinesinmultipleof:10  (blockcount) Q18:IfavaluedoesnotfilltheentirefieldintheEFTfile,howdoyoufilltherestofthefieldwithzeroesorspaces? A18:IntheEFTFileMaintenancewindow,thereisa PadCharfieldoneachline.Leavethisfieldblankifyouwantthefieldtohavespaces.Orputa0inthisfield,ifyouwishfortheunusedportionofthefieldtobepaddedwith0's.Thezeroeswillbepaddedintheremainderofthefieldbasedonwhetheryousetthedatainthefieldtoberightorleftjustified.Q19:InthePMPaidTransactionHistoryfile,thereisafieldcalledthe'TransactionDescription'.Thisfieldprintsblankanddoesn'tpullthedescriptionfromtheinvoice. HowcanIgetthetransactiondescriptionfromtheinvoiceintheAddendaline? (orthePO#,orthefulldocumentamountoftheinvoice,etc.) A19:TheEFTfileisforelectronicpayments,andthereforeisalwayslookingforthemappedfieldsfromtheperspectiveofthepaymentrecord.  Soifyoupullthe'TransactionDescription'fieldfromthePMPaidtransactionhistoryfileontotheAddendaline,itislookingforthepayment,nottheinvoice,soitwillprintblank(sincethepaymentisnotpostedyet).  TheonlyinvoiceinformationyoucangetpullontotheAddendlineistheinvoiceinformationthatisontheapplyrecordtothepaymentinthethe'PMApplytoHistory'table.  ThisincludesonlytheInvoicedocumentnumber,invoicedate,discountsandnetpaidamount. Youcannotgettothetransactiondescriptionassociatedwiththeinvoice,orPO#,orfulldocumentamount,etc.asthesearenotsupported atthistime.  Seemoreinformationin: http://support.microsoft.com/help/2956922 Q20:Howdoyougetthedocumentnumberfortheinvoicetoprintintheaddendaline? A20:TogettheDocumentNumberfortheinvoice,youwillneedtomapitasfollows: TABLE:PMAPPLYTOHISTORYFILE FIELD:APPLYTODOCUMENTNUMBER Seemoreinformationin:  http://support.microsoft.com/help/2956922Q21:IhavekeyedmultipleinvoicestoonevendorinMicrosoftDynamicsGP.SomeoftheinvoiceswerekeyedtoanAddressIDwithbankinginformationandsomeoftheinvoiceswerekeyedtoanAddressIDwithoutEFTbankinginformation.WhenIbuildthecheckbatchorEFTbatch,itdoesnotworkthewayIexpect.HowdotheinvoicespullintothecheckandEFTbatches? A21:ThefunctionalityforhowcheckandEFTbatchespullhaschangedacrossversionsofMicrosoftDynamicsGPasfollows: MicrosoftDynamicsGP10.0-Ifyoubuildthecheckbatchfirst,boththecheckandeftinvoiceswillpullin.Thework-aroundistobuildtheEFTbatchfirstandthenthecheckbatchcanbebuiltlast. MicrosoftDynamicsGP10.0SP2-ThesystemwillreadandusetheREMITTOAddressIDsavedontheVendorMaintenancecard.Unfortunately,itdoesnotreadtheAddressIDactuallykeyedonthespecificinvoice.Thiswasloggedasqualityissue#64038. MicrosoftDynamicsGP2010RTMandlaterversions(lasttestedonGP2018) -IfavendorhasbothacheckandEFTtypeinvoicekeyed,thennothingwillpullinifyoubuildthecheckbatchfirst.YoumustbuildtheEFTbatchfirstandthenthecheckbatch.Thisisthecurrentdesign.Ifyouwouldliketoseethisdesignchangedinfutureversions,pleaselogaproductsuggestion. Q22:Howdoyoulogaproductsuggestion? A22:TheDevelopmentteamhascreatedaproductsuggestiondatabasenamedMSConnect.Theydoreadeachandeveryproductsuggestionenteredandgiveitapriorityratingbasedonseveralcriteriasuchas: Isitdatadamaging? Howmanycustomershavevotedforthis? Isthereawork-around? Willitconflictorbreakotherfunctionality? Doesitviolateanyfederalorstandardregulations? Aftereachsuggestionisgivenapriorityrating,itstaysinthedatabasesothatothercustomerscanalsovoteonitovertime.Themorevotesitgets,thehigherinpriorityitwillgo,soyourvotesdocountandareveryimportant.ThisdatabaseisusedtodeterminewhatenhancementscustomerswouldliketoseeinfutureversionssopleaselogproductsuggestionsintheIdeasproductsuggestiondatabase.Q23:HowdoIgettheFileCreationDateinJuliandateformat? (Forexample,theJuliandateformatis‘0yyddd’whereyyisthelasttwodigitsoftheyearandthedddisthedayoftheyearthatthatdatefallsonoutof365days.  Soforexample,September24th,2011wouldbein011267inJulianformat.) A23:ToaccomplishtheJuliandateformat,youwouldhavetoutilizetwofieldsasfollows: a.OpentheEFTfileformatandselecttheFileHeaderlinetype. b.ClickontheFileCreationDatefield.Setittoalengthof'1'andmapittoa Constantvalueof0. c.ClicktoputyourcursoronthenextlineandinthetopmenubarclickonEditandchooseInsertRowanditwillinsertanewrowabovethelineyourcursorison. d.Inthenewfield,nameit'FileCreationDay'andmapitasSystemDate.ThenexpandthelineandfortheDateFormat,chooseeitherYY+DayNumberorjustDayNumberasneeded. (NotallbanksrequiretheYY.)Q24:WhenIkeyamanualpaymentinPayablesandmarktheEFTcheckbox,whyaretheseshowingupintheSafePayfileasacheck? A24:IfthevendorisnotsetupforEFT,thenthesystemwilltreatthemanualpaymentasacheckandincludeitintheSafePayfile,evenifyoumarkitasanEFTtypewhenyoukeyedthemanualpayment.ItwillstillbetreatedasachecknomatterwhatforvendorsnotsetupwithEFT.Thework-aroundsaretousethe'cash'typeinsteadofEFTfornon-EFTvendors,orsetthevendorupwithEFTandthenrekeythemanualpayment.The'cash'typeisnotincludedintheSafePayupload.  IfthevendorissetupforEFT,thesystemwilldefaulttotheEFTcheckboxautomaticallyanditwillnotbeincludedintheSafePayfile.Q25:CanMicrosoftprovidealistofbanksthatusespecificEFTFileformats? A25: Microsoftisnotabletocertifywhichbanksusewhichformats,duetoliabilityreasonsandalsoduetothefactthatbanksareever-changingwhichformatstheyuse,whichmakesmanagingthatinformationimpossible.Certainbanksalsomayrequirespecificfieldsthatarenot'required'onthestandardpublishedformat.Therefore,youmustcontactthebankdirectlytoseewhatformatstheywillacceptandprovideyouwitharequirementsdocumentfortheformattheyrequire.ThenyouwillhavetomodifyaformatintheEFTFileFormatwindowinMicrosoftDynamicsGPtoseeifthedeviatedfieldispossibleornot.ContactMicrosoftDynamicsGPforaconsultingengagementifyouneedtohavethefilecustomizedtopullinformationthatisnotreadilyavailable.Q26:ThebankwillnotacceptmyEFTfilebecausethesequencenumberintheEFTfilenameis-0001andwealreadyuploadedanEFTfilewiththatsamesequencenumbertoday.Thenextfilewegeneratedwasalsogeneratedwiththesame-0001sequencenumber. A26:ThenamingconventionfortheEFTfiles(onMicrosoftDynamicsGP10.0andhigherversionsforEFTPayables, andMicrosoftDynamicsGP2010andhigherforEFTReceivables) iscomprisedasfollow: EFTFILENAME+CHECKBOOKID+DATE+SEQUENCENUMBER+EXTENSION(ifdesignated) TheEFTFILENAMEispulledfromthefilenamedesignatedinthePayablesOptionsorReceivablesOptionstabfortheoutputpathsonthecheckbook. Ifnoextensionsuchas.txtisdesignatedhere,thennoextensionwillbeaddedtotheresultingEFTfilegenerated. TheCHECKBOOKIDistheCheckbookIDusedonthecheckrun. TheDATEisthesystemdate. TheSEQUENCENUMBERwillincrementofftheotherEFTfilessavedtothesamepath/folderwiththesamename.ThesequencenumberwillincrementaccordinglyforthenextEFTfilegenerated.SoifyougeneratedanEFTfiletodaywiththesequencenumberof-0001.AnotherEFTfilegeneratedtodaywillincrementto-0002savedtothesamelocation.However,ifyoudeletethefirstfilewiththe-0001sequencenumberfirst,thenthesecondfilewillnotseeitandstartoverandusethe-0001sequencenumberagain.Thisisaproblemwithmostbanksastheywillconsideritaduplicatefile.Whenyougenerateafilethenextday,thedatewillchange,soitwillstartoverat-0001again. SobesurenottodeletetheEFTfilesfromthelocationthefilesarebeingsavedtoifyougeneratemorethanoneEFTfileperday.Q27:CanIhavecreditmemo'sshowontheEFTfile? A27:No.Thecreditmemoisappliedtotheinvoiceasaseparateprocess. TheEFTfileisonlypayingthe'netamount'remainingthatisdue.ThereforethecreditmemoinformationisstoredinadifferenttableandnotavailabletobepulledintotheEFTfile.Q28:IfIvoidtheEFTpayment,willthecreditmemoautomaticallyunapplyfromtheinvoicetoo? A28:InMicrosoftDynamicsGP10.0andMicrosoftDynamicsGP2010,whenyouvoidapayment,onlythenetamountofthepaymentwillbecomeopenagain.Thecreditmemoremainsintactagainsttheinvoice.(Note: ThisfunctionalitywaschangedinMicrosoftDynamicsGP2013.) InMicrosoftDynamicsGP2013,whenyouvoidtheEFTpayment,thecreditmemowillalsobeunappliedfromtheinvoiceatthesametime.Q29:IntheCheckbookEFTBankMaintenancewindow,howdoestheCommunicationTypeandApplicationfieldswork?WillGPautomaticallyuploadmyfiledirectlytothebank? A29:MicrosoftDynamicsGPhasnoautomaticwaytosendthefiletoyourbank.TheCommunicationTypeisusedtoeitherlaunchtheprogramtousetouploadtheEFTtothebank,oropentheinternetlinkforyourbanktouploadtheEFTfile.GPisjustopeningthesoftwareorlinkforyou,butcan'tgoanyfurther.Yourprogramorbank'ssoftwarewilltakeoveratthatpoint,oryoumustmanuallyproceedtouploadthefile.Youshouldcheckwithyourbank,assome bank'ssoftwaremayhavefunctionalitytoautomaticallygrabthefilefromaspecifiedlocation,butthataccomplishedforthefunctionalitypresentinyourbank'ssoftware. Q30:WhenIimportinanEFTFileformatforPayables,thePayablestablesarenotlisted.ReceivablestablesarelistedforTableName.Isthisabug? A30:Thisissue#61119wascorrectedinSP3forMicrosoftDynamicsGP2010. OryoucanupdatetheSERIEScolumnontheEFTFileFormatdirectlyintheSQLTabletopointtoPayablesManagement,byexecutingthebelowscriptagainstthecompanydatabaseinSQLServerManagementStudio: updateCM00103setSERIES=4whereEFTFormatID='XXX' --EntertheEFTFileFormatIDfortheXXXPlaceholderabovebeforeexecutingthisscript.FortheSeries,Payables=4andReceivables=3.Q31:WhatversionoftheISO20022formatisavailableinMicrosoftDynamicsGP? A31:OnlyVersion1oftheISO20022format(PAIN001.001.01) iscurrentlyavailableinMicrosoftDynamicsGP.Unfortunately,Version2orVersion3arenotavailableatthistimeandwouldbeconsideredaproductenhancement.IfyouwouldliketoseethenewerversionsofthisformataddedtoMicrosoftDynamicsGPinthefuturesuchasVersion3(PAIN001.001.03),pleaseclickonthelinkbelowandvoteonthis productsuggestionandaddanycommentssothiscanbereviewedandconsideredforafuturerelease. Q32:Howdoyougeta'UniqueFileCreationNumber'generatedforeachnewEFTfile? A32:TheUniqueFileNumberfunctionalityisauniquenumberperEFTfilegenerated.Ifselectedonseverallinetypes,thesamenumberwillprintineachline,andincrementeachtimeanewEFTfileisgenerated.ThisnumberisalreadyavailableinMicrosoftDynamicsGPbymappingthefieldasfollows: EFTNextFileNumber Mapsto:DataField Table:CheckbookElectronicFundsTransferMaster Field:EFTNextFileNumber Note: Thebankprenotefilegeneratedwillprintzeroesinthisfield. Seemoreinformationin:  http://support.microsoft.com/help/2956922Q33:WhataresomeothercustomfieldscommonlyrequestedforEFT? A33:InformationonothercustomfieldscommonlyrequestedforEFTfilecanbefoundinKB2956922.Q34: CanIgetan'addendacount'intheDetaillinetoachievetheCTXfileformat? A34: No,atthistime,youarenotabletocount/sumuntilafterthelinesarelisted. Therefore,youwouldnotbeabletocounttheaddendalinesintheDetaillinesincetheyareprintedaftertheDetailline,soyouwouldnotbeabletoachievetheCTXformat. Youroptionswouldinclude: 1)run'onecheckperinvoice'insteadof'onecheckpervendor',andhardcodetheaddendacount=1intheEFTfileformat. Or2)askthebankiftheywouldmakeanexceptionoracceptanyotherNACHAformatsuchastheCCDorPPDformat. (Manybankshaveacceptedthe'detail+addenda'countinafooterlineinstead.)Or3)seekouta3rdpartyproductthatallowsthisfunctionalityor4)adexteritycustomization.    SUBSCRIBERSSFEEDS Needmorehelp? Expandyourskills ExploreTraining Getnewfeaturesfirst JoinMicrosoftInsiders Wasthisinformationhelpful? Yes No Thankyou!Anymorefeedback?(Themoreyoutellusthemorewecanhelp.) Canyouhelpusimprove?(Themoreyoutellusthemorewecanhelp.) Whataffectedyourexperience? Resolvedmyissue Clearinstructions Easytofollow Nojargon Pictureshelped Other Didn'tmatchmyscreen Incorrectinstructions Tootechnical Notenoughinformation Notenoughpictures Other Anyadditionalfeedback?(Optional) Submitfeedback Thankyouforyourfeedback! ×