. “Be Mi... ACH Payment Configuration Product of www.sapficoconsultant.com© 2014 sapficoconsultant.com. All rights reserved. No part of this material should be reproduced or transmitted in any form, or by any means, electronic or mechanical including photocopying, recording or by any information storage retrieval system without permission in writing from www.sapficoconsultant.com “SAP" is a trademark of SAP AG, Neurottstrasse 16, 69190 Walldorf, Germany. SAP AG is not the publisher of this material and is not responsible for it under any aspect. Warning and Disclaimer While every precaution has been taken in the preparation of this material, www.sapficoconsultant.com assumes no responsibilty for errors or omissions. Neither is any liability assumed for damages resulting from the use of the information or instructions contained herein. It is further stated that the publisher is not responsible for any damage or loss to your data or your equipment that results directly or indirectly from your use of this product. www.sapficoconsultant.com Page 2 SAP ACH Payment configurationTable of Contents Introduction 1. Update company number in House Bank 5 2. Update company number in the company code detail... 4, Set up Paying Company codes for Payment Transactions. 5. Set up Payment Methods per country for Payment Transactions 6. Set up Payment Methods per Company code for Payment Transactions.. 7. Set up Bank determination for Payment Transactions.. 2A 8. Adjust Note to Payee 27 30 9. Create/Assign Selection Variants 10. ACH Output ‘yaw. sapficoconsultant.com Page 3 ‘SAP ACH Payment configurationIntroduction ACH format creates payment media for domestic payments in the USA. Incoming and outgoing payments in US are supported. ACH format is in accordance with version 004000 and conforms to the specifications of the National Automated Clearing House Association (NACHA). So let us configure the ACH Payment format using the payment medium workbench ‘nw sapficoconsultant.com Page 4 ‘SAP ACH Payment configuration1, Update company number in House Bank SAP Customizing Implementation Guide > Financial Accounting (New) > Bank Accounting > Bank Accounts > Define House Banks [ Tove gat Goto sptem He e (8 Ce@ DMR BHSe TAR View Cluster Maintenance: Initial Screen (rnd wantenance Daeg New Entres Click on ‘nw sapficoconsultant.com Page 5 ‘SAP ACH Payment configurationUpdate the following: © peewee akc Symon oe, +a cee cae ccoomE Deeg verse ceany cose morn Sree mona r) es | ‘Scroll down, Page 6 ‘SAP ACH Payment configurationG pekven EE gow Seecen Umer Solem te eo, 48 Cee cue oooo mm Click on www. sapficoconsultant.com Page 7 ‘SAP ACH Payment configurationUpdate company number agsmcnre corer ade (5902) Woreon ua. Eines Eas Howse ak Cepank WA, ‘Bank c fs) usa er son Gigank Accounts Double click Ciiokon Nem Ets www. sapficoconsultant.com Page 9 ‘SAP ACH Payment configurationUpdate the following: ] taevew Est Get Sencan utes Sm ee oe” «a Coe ome cece mm Click on & XS www. sapficoconsultant.com Page 10 ‘SAP ACH Payment configuration2. Update company number in the company code details SAP Customizing Implementation Guide > Financial Accounting (New) > Financial Accounting Global Settings (New) > Global Parameters for Company Code > Enter Global Parameters © Table vew Edt Goto Choose tines Envronment System — Help @ (8 C@G@ SAR 5058 ' HOB Change View "Company Code Global Data": Overview VaoREE ocd) company Name jew county |crey_ Langue | |2102\Horzon ued ‘Jiew York ps uso EN + Double click on 9102 © ble vew Est Goto choose ites Enyronment Sistem Heb e 48 CO@ CHR BHLH BHO ‘Change View "Company Code Global Data"; Details ‘ZI Aédtonaioaa «> B congay code (502) Horo ie Yor coawytey 05) careney [5B] Lao.ae way we ‘Aesoinng orton Chat of Accs Pout raniaccts conean ea ce cols oor) real voent 2 c8cte ional cacee Company code spruce )_—_VAT Ratton Ho ‘nw sapficoconsultant.com Page 11 ‘SAP ACH Payment configurationClick Environment > Additional Data www. sapficoconsultant.com Page 12 ‘SAP ACH Payment configurationTE addrional data system Heb © (0 ©@@ CHK 2008 8H OB _————— = ss cero fh = ‘Pants Abroad Not Requred | [Tax Without Rounding Tolerance || UC Tax with Transition Date | | ‘Tax Entry for Ex. Rate n (Generate KDT Item when Paying | | ‘Ledger Group for Tax Posting r [EXTRASTAT materal number) | ‘Shopper's Auth. Symbol 1) (Authentfcaton code GUSDEC | iReprng pity name ((NTRASTAT) Reprtngprty chy (INTRASTAT) Page down by clicking © www. sapficoconsultant.com Page 13 ‘SAP ACH Payment configuration[© addtional data System Heb @ *}¢8/CCe@ SHR ANHS AH OB www. sapficoconsultant.com Page 14 ‘SAP ACH Payment configurationUpdate the Company number as shown below = Maintenance of Additional Data for Company Code 9102 oe, *}(8 eee Shh ones mm OR (DneeerommsTaT | ware 7 Tx nrber USA TOO) ice) Note: The 10 digit company number does not fit in the above field hence we will have to update the company number in Step number 9 (Create/Assign the variants). click @ Click on & The remaining steps are for the Payment program set up ‘yaw. sapficoconsultant.com Page 15 ‘SAP ACH Payment configuration3. Set up all company codes for Payment Transactions SAP Customizing Implementation Guide > Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for Payment Program > Set Up All Company Codes for Payment Transactions Click on New Entres Update the following:- © Table View Edt Goto Selection tities System Hep @ 7/148: C@@ CHR HHH5 BE OB New Entries: Details of Added Entries vas Company Code [8102] contol data Sending company code Paying company code (9102| B® et eee Pemeth sot (ah decor ad tleances Toleance dye fr payabie vtpog pt wth cs dom . acca dsc [Wendors So. Gl tansactos to be pad ee) ‘nw sapficoconsultant.com Page 16 ‘SAP ACH Payment configurationClick on & 4. Set up Paying Company codes for Payment Transactions SAP Customizing Implementation Guide > Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions -> Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for Payment Program > Set Up Paying Company Codes for Payment Transactions Click on New Entres www.sapficoconsultant.com Page 17 SAP ACH Payment configurationUpdate the following:- Te vew Gat Geto Selection Utes Stem Heb © 74a Coe@ CuK ODeS Bm OM New Entries: Details of Added Entries vasa aco cote (953) Moron &convany codes] (int ox Meer avout neamea Samet cous nary avout fr eutgong seyret 00 ]us0 Na exange ate cteees a Bxate OF, (a Payment) Sonate saynant or each et te oyre fem Form orth Payment Ave ‘Swot |r Dtacomoanyg shet frm sireot =| 5. Set up Payment Methods per country for Payment Transactions SAP Customizing Implementation Guide > Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions -> Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for Payment Program -> Set Up Payment Methods per Country for Payment Transactions ‘nw sapficoconsultant.com Page 18 ‘SAP ACH Payment configurationTbe view Et Goto Selecton Utes Sytem Heb eo, +)48 CO@ BHR HHH AM) + Canote to Payee by 0: Double click cose) od (+ ¢ eee one coo mn Om a os ee rae aoe? ater sted Rees bone ets Carer reset Domenwenene soa Celia taer vamos Caerg amen oo ‘Thecur enerRecte Ce meas Chara ae sar cae age - comcen naan www. sapficoconsultant.com Page 19 ‘SAP ACH Payment configuration‘Scroll down © yonver mt foo Serco eee opt hw e —_+48 eee ow 00s BHiOE rete rae meet ate sent (het sme pet seamen (ourebuecntor ante ‘et ena ae Trcsot tbe ees Covtence oe ean sn Note to Payee by Or Double click www. sapficoconsultant.com Page 20 ‘SAP ACH Payment configuration© pole View 6k Goto Seacton tlbes system Heb © (8 Ce CHk BHH0 BH OB Change View "Note to Payee by Origin": Overview Prwetes BROBR RR Ooty sane corm) eta] eee + Gi Cmrences Alowed Emon! ceed + Eatote to paye by OF This is a very important step - SAP ACH CTX must exist as shown above. 6. Set up Payment Methods per Company code for Payment Transactions SAP Customizing Implementation Guide > Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions -> Outgoing Payments > Automatic Outgoing Payments -> Payment Method/Bank Selection for Payment Program > Set Up Payment Methods per Company Code for Payment Transactions Click on New Entres www.sapficoconsultant.com Page 21 SAP ACH Payment configurationUpdate the following: TF Tae ven Get Goo Seecan tes Spten Heb oe; «9 Cee Cam SHalmn On rae ren. Prmcuatied =) enka (0170) www. sapficoconsultant.com Page 22 ‘SAP ACH Payment configuration(© Tile vew Est Goto Seecton Uber Stem Heb e” *]}¢8 €ee hw onde BH OR wo fom Sioarot_~[rat os 53 | Click on www. sapficoconsultant.com Page 23 ‘SAP ACH Payment configuration7. Set up Bank determination for Payment Transactions SAP Customizing Implementation Guide > Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Method/Bank Selection for Payment Program > Set Up Bank Determination for Payment Transactions © Table View Edt Goto Selection Utes System Hebb @ *\48 ©@@ BHR OHHH Display View "Bank Selection": Overview Dabo structure Bank Selection > Eank Selection ~ aRanking Order ace a 4a + PaRank Accounts ps Horton Led B Select TE Table View Edt Goto Selection titties System Help @ “48 €@@ BHR BHH8 HO Dialog Structure ~ iank Selection + Caranking Order + Capank Accounts Double click CRankno Order ‘nw sapficoconsultant.com Page 24 ‘SAP ACH Payment configurationClick on New Entres Update the following:- & Tobe view Eee Goto Selection Uttities System Heb @ 7 (48 ©G@ BHK HH49 BHF OB VEER Dabog structure | paying co. code aes Paying co. code [8462] + GiRankong Order + CBank Accounts Double click Ci8rk Accounts Update the following:- www. sapficoconsultant.com Page 25 ‘SAP ACH Payment configuration© be vew Got Goto secon ties Stem Heb eo, +48 Cee BNR BHoe BD oO! Click on Double click Sl*vaisble Amounts Cok on | New ES www. sapficoconsultant.com Page 26 ‘SAP ACH Payment configurationUpdate the following:- GE able view Est Goto Seecton tines System Heb @ (8 ©G@ BNK BNS8 7H 08 New Entries: Overview of Added Entries VERB Payng comvany code [02] Howeon tsa Bank accounts | Aable Arounts, ‘GxAvatibe Amounts House ba. Acoun.. Days Currency Avaibe fr outgong Scheduled ncomng pa... 3] Vale Date lem crr_ 993 uso a Espense/ Charges tick on The remaining steps are for the payment medium workbench configuration. 8. Adjust Note to Payee SAP Customizing Implementation Guide -> Financial Accounting ->Accounts Receivable and Accounts Payable Business Transactions Outgoing Payments > Automatic Outgoing Payments > Payment Media > Make Settings for Payment Medium Formats from Payment Medium Workbench > Adjust Note to Payee Here you can use Customizing and/or function modules to change a note to payee. The note to payee that you configure in Customizing is made up of four line types. The most important of these is type 1. This consists of the usual note to payee lines www.sapficoconsultant.com Page 27 SAP ACH Payment configuration(with invoice number, date, and amount, for example), as well as sub-types 5 and 6. Type 6 controls whether control levels are to be created with the selected header in the various company codes that are settled with this payment. Type 5 specifies whether a text for the alternative payee - if one exists - is to be created as a header for the whole note to payee. Note to payee line types 2 and 3 specify the internal (payment document number, for example) and extemal (account number in the business partner's accounts, for example) references respectively. Under type 4, you specify what sort of note to payee is to be created if the space defined by the format is not sufficient and a payment advice note is created. The payment advice note thus replaces the specifications under type 1 We use sap standard Note to payee © 48 C0@ Cue SHOO An OR (Change View “Note to payee”: Overview PE moms BROBTE (Gowoot os Po ilnegedeoeaen ‘nw sapficoconsultant.com Page 28 ‘SAP ACH Payment configurationeven G2 Goto Sekcon utter Soten ap oe, 48 C0@ ONk Sonn BH OB Tee ven Es Soo soho he Seton Heb es cee cum once an Os BL vont. | ent 00 www. sapficoconsultant.com Page 29 ‘SAP ACH Payment configuration© Tae ven e 748 ©0@ ONE DNOD AD OR (Change View “Language-Dependent Note to Payee": Overview P nvm OBO BBB o sade me Spon Bee Seger atone BRS p EI Mp DON Space AGH Evo — \anqane Dependent tt Payee Iara To neo. Segment we ee to pretext 9. Create/Assign Selection Variants SAP Customizing Implementation Guide > Financial Accounting Accounts Receivable and Accounts Payable > Business Transactions -> Outgoing Payments > Automatic Outgoing Payments > Payment Media > Make Settings for Payment Medium Formats from Payment Medium Workbench + Create/Assign Selection Variants ‘nw sapficoconsultant.com Page 30 ‘SAP ACH Payment configuration“Spe ee be _ . © /4a/eee CHE COOE aE Double cick” SG _ oe coe Due Sooo an Om www. sapficoconsultant.com Page 31 ‘SAP ACH Payment configurationUpdate 21 in co. code 9102 and press enter e *4H/©0e Dum onoD Em oR Click on Yes iaoososos9Dsss99909000 Select ‘yaw. sapficoconsultant.com Page 32 ‘SAP ACH Payment configurationyornt Eée Goto Stem Heb © 48 C@@ SNK HOSS TDOB Click www. sapficoconsultant.com Page 33 ‘SAP ACH Payment configuration© vara got goto sytem Heb eo”) 48 ©¢@ Fuk OnSe\ mn OB fun ae Ienefeaton ‘Crepes —————————S———— ee (@Pament Serrary (Weer tog (emp comm [Payment Document Vataton -Faymene summary yest [ (Ciscren outst www. sapficoconsultant.com Page 34 ‘SAP ACH Payment configuration© yore Ese Gon Sytem Hed (C——+( a eee Ome anasimnie fl Press enter www. sapficoconsultant.com Page 35 ‘SAP ACH Payment configurationF wae Ete goto Sate Heb oe }¢e coe@cmm anosimnie Click on www. sapficoconsultant.com Page 36 ‘SAP ACH Payment configuration[= Maintain Variant: Report SAPFPAYM, Variant Zi © 48 CO@ OMK HAS ED OB Parbstes 5 A un Oat [ 1 Foreign xch Ref id Forvgn xc Reference fomacoromngiete fam) Payment Surmar Layout screen ACH Batch hdr. Company description:- This will help update the type of payment = Vendor payment Company identification: Must be entered here since the company code configuration global parameters for Tax number (TIN)- PAVAL - T001Z is only a 9 digit field, which we saw earlier (screen shot shown below) ‘yaw. sapficoconsultant.com Page 37 ‘SAP ACH Payment configuration‘© Maintenance of Additional Data for Company Code 9102 oe, +18 eee cme nnoo mn el! www. sapficoconsultant.com Page 38 ‘SAP ACH Payment configurationWe therefore update the company number in the company identification shown below © arnt Esk Gato Stem Hed *]48\COe@ CHR DDAL EDCS © ‘Maintain Variant: Report SAPFPAYM, Variant Zi Prvewes eB un bate = eration Page 39 ‘SAP ACH Payment configuration www.sapficoconsultant.com© yout gar goto Stem Hed oe, +)4 eee Suu DDoS mm OC! Payment urea yt 7 Ciseee ov Default location or folder can be specified here for storing the file on your computer or a shared folder on the presentation system. www. sapficoconsultant.com Page 40 ‘SAP ACH Payment configuration© yet gt Goto Stem heb ef 40 Cee Ome nnonimn www. sapficoconsultant.com Page 42 ‘SAP ACH Payment configuration© variant Edit Goto System Help @ | *}(8'CG@ | 2HR HHHLS 25 OB Maintain Variant: Report SAPFPAYM, Variant Zi Click © ‘yaw. sapficoconsultant.com Page 43 ‘SAP ACH Payment configurationTE varant Got Goto Sytem He @ 748 COC CHK BOSS TAOB (ata Mesum Exchange [Brayment Sumerary Bererto9 (payment Document valdaton output to he system Fle vame rancelFA\ACH Flas www. sapficoconsultant.com Page 44 ‘SAP ACH Payment configurationeed GE vyunt Est Goto Enfonmert Sytem Heb e( (9 eee Dum neDelD www. sapficoconsultant.com Page 45 ‘SAP ACH Payment configuration© yorant Eat goto sytem Heb © 48 C@@ CNW 5585 BH OB ‘arane aebtes J un Oat — erefeaton| co Pres un The above path is incase a default is required. We remove the defaults since we do not want any default path www. sapficoconsultant.com Page 46 ‘SAP ACH Payment configuration© yornt foe Goto Stem ue eo, *}¢@ Cee che Soon BReR et foe tn Click on www. sapficoconsultant.com Page 47 ‘SAP ACH Payment configurationThe ACH configuration is done ‘yaw. sapficoconsultant.com Page 48 ‘SAP ACH Payment configuration10. ACH Output The ACH file is generated as follows in transaction code F110. i 4234 S67BRIAL PASH FOBTOLCTE TORE WA PORIZON LTD, 5200n0Rzz0N ‘OIRECT DePOsiT 0123436789CTXVENOOR_ pw 141215 100000000000000 2200000000082252322 "0000500000 ‘ooostrinity internat 1000000000000: ‘Fostsasoo-Ny *00"NV. eeeNy “2 '3141215°1 2100010000001 7051"4-00400"000009000" 0"P*?\ Gs*RA“AV*NV"20141215"1211"0°%"004020\ST*820°0001\ 00020000001, ‘70sepmsc*5000, odve =Ach“cTx 01 **DA"121 21911 *1013345678* 01 -*DA"42232322°°VEN\ENT*2\ 00020000001 ‘708 wen“or*siLL1 "3000, 00" 5000.00", 00\'st*50001 \GE*1=0\1EA"1"000000000\ ‘00s0000001, §290d990050900090009905a900a990000900030000001234596789, "0000001, 790000000000500000 '000001 00000005 '9999999999999999999999999999999999999999999099999999999909999999999990999999999999990909090909, io ‘434567 0141215121 FODALOICT Ibark W. \VENDOR_PYM-— this was ‘The compdny number is shown in 2 places above (It comes fromthe House bank definition and also in the defaulf we set in the variant Vendor Bank number Vendor name ‘yaw. sapficoconsultant.com Page 49 ‘SAP ACH Payment configuration