JD Edwards EnterpriseOne Applications - Oracle

1y ago
7 Views
2 Downloads
2.23 MB
354 Pages
Last View : 27d ago
Last Download : 3m ago
Upload by : Lilly Kaiser
Transcription

JD EdwardsEnterpriseOneApplicationsAccounts Payable ImplementationGuideRelease 9.2

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideRelease 9.2Part Number: E63890-14Copyright 2011, 2021, Oracle and/or its affiliates.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protectedby intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate,broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering,disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please reportthem to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, thenthe following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed oractivated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to oraccessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to theapplicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display,disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integratedsoftware, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computerdocumentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. Theterms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights aregranted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended foruse in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardwarein dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safeuse. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarksor registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced MicroDevices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. OracleCorporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, andservices unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsiblefor any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicableagreement between you and Oracle.

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideContentsPreface . i1Introduction to JD Edwards EnterpriseOne Accounts Payable1Accounts Payable Overview . 1Accounts Payable Business Processes . 1Accounts Payable Integrations . 2Accounts Payable Implementations . 4Business Interface Integration Objects . 62Setting Up the Accounts Payable System9Understanding System Setup for Accounts Payable . 9Setting Up Constants for Accounts Payable . 10Setting Up UDCs for Accounts Payable . 13Setting Up Next Numbers for Accounts Payable . 19Setting Up AAIs for Accounts Payable . 203Setting Up the Accounts Payable System for Automatic PaymentProcessing27Understanding the Setup for Automatic Payment Processing . 27Setting Up Payee Control . 28Setting Up Payment Instruments and Print Programs . 30Setting Up a Print Sequence for Payments . 33Setting Up Payment Information by Business Unit . 34Preventing the Company Name from Printing on Payments . 35Setting Up the System for EFT Payments . 36Setting Up the System for EDI Payments . 37Masking and Configurable Unmasking for Bank Account Numbers . 384Setting Up Payment Formats41Understanding Payment Formats . 41

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuidePrerequisites . 42Setting Up Standard Payment Formats . 425Entering Supplier Information53Understanding Supplier Master Information . 53Common Fields Used in This Chapter . 54Entering Supplier Master Information . 55Using the Supplier Self Service Program . 63Setting Up Multiple Bank Accounts for Suppliers . 66Assigning Payment Instrument and GL Account Relationships . 69Updating the Approver and Category Code 7 Fields . 71Verifying YTD Voucher Amounts . 726Processing Accounts Payable Vouchers77Understanding Voucher Processing . 77Entering Standard Vouchers . 81Processing Logged Vouchers . 112Processing Recurring Vouchers . 116Processing Prepayments . 1227Processing Batch Vouchers127Understanding Batch Voucher Processing . 127Prerequisite . 128Processing Batch Vouchers . 128Working with Batch Vouchers . 133Purging Processed Batch Vouchers . 1378Processing Inbound EDI Vouchers139Understanding EDI Voucher Processing . 139Transferring Inbound EDI Voucher Transactions . 141Purging Processed Inbound EDI Vouchers . 1439Preparing Vouchers for Payment145Understanding AR/AP Netting . 145Reviewing and Approving Changes to Controlled Data . 146

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideCalculating Withholding . 148Determining Cash Requirements . 151Using Speed Status Change to Review and Revise Vouchers . 15310Processing Automatic Payments161Understanding the Automatic Payment Process . 161Creating Payment Groups . 163Working With Payment Groups . 176Voiding Automatic Payments and Vouchers . 191Copying Payments to a Diskette . 19311Processing Outbound EDI Payments197Understanding the Outbound EDI Payments Process . 197Transferring Outbound Payment Transactions . 197Updating Processed Transactions . 199Purging Processed Outbound EDI Payments . 20012Processing Accounts Payable Drafts201Understanding Draft Processing . 201Prerequisites . 203Closing Paid Drafts . 204Posting Closed Drafts . 20413Processing Manual Payments207Understanding the Manual Payments Process . 207Entering Manual Payments with Voucher Match . 209Entering Manual Payments Without Existing Vouchers . 217Printing Manual Payments . 219Deleting and Voiding Manual Payments . 22014Using Positive Pay225Understanding Positive Pay . 225Prerequisites . 225Generating the Positive Pay Text File . 225Copying Positive Pay Text Files . 227

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation Guide15Creating As Of Reports229Understanding As Of Processing . 229Generating the Date File . 229Running the As-Of Open A/P Summary Report . 231Running the As-Of A/P Detail with Remarks Report . 233Running the As-Of Open A/P Details with Aging Report . 23416Verifying Data Integrity for Accounts Payable237Understanding Accounts Payable Integrity Reports . 237Running the A/P to G/L by Batch Report . 237Running the A/P Payments to G/L by Batch Report . 238Running the A/P to G/L by Offset Account Report . 239Running the A/P Payments to A/P w/Update Report . 240Correcting Out-Of-Balance Conditions . 24117Purging Accounts Payable Records245Understanding How to Purge Records from Your Accounts Payable System . 245Purging Closed AP Records . 24618Processing T5018 for Canada249JD Edwards EnterpriseOne T5018 Processing Overview . 249Understanding the Payroll Processing for T5018 . 251Understanding the A/P Method for T5018 . 251Understanding Sources of Information for T5018 Forms . 252Verifying Supplier Setup . 254Entering Supplier Information for T5018s . 256Processing T5018s for Foreign Suppliers . 258Combining Suppliers with Duplicate Tax IDs . 259Managing Company Information . 260Combining Company Information for T5018 Processing . 262Working with Payroll for T5018 . 264Clearing the T5018 Tax and Work Files . 266Building the T5018 Workfile . 267Reviewing Records in the T5018 Workfile Table . 269Previewing T5018 Workfile . 271Working With the Write T5018 Media Program . 273

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation Guide19Appendix A - Mapping Voucher Transactions to Batch Input Tables279Mapping Fields in the Voucher Transactions - Batch Upload Table (F0411Z1) . 279Mapping Fields in the Journal Entry Transactions - Batch File Table (F0911Z1) . 304Mapping Fields in the Voucher Transactions Batch Upload - Voucher Match Automation Table (F0411Z1T) . 31520Appendix B - Delivered Workflow for JD Edwards EnterpriseOneAccounts Payable319Delivered Workflow for JD Edwards EnterpriseOne Accounts Payable . 31921Appendix C - JD Edwards EnterpriseOne Accounts Payable Reports321JD Edwards EnterpriseOne Accounts Payable Reports: A to Z . 321JD Edwards EnterpriseOne Accounts Payable Reports: Selected Reports . 32522Appendix D - Delivered User Defined Objects for Accounts Payable(Release 9.2 Update)341. 341Accounts Payable Notifications . 341Accounts Payable Orchestrations . 342

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation Guide

JD Edwards EnterpriseOne ApplicationsPrefaceAccounts Payable Implementation GuidePrefaceWelcome to the JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide.AudienceThis guide is intended for implementers and end users of the JD Edwards EnterpriseOne Accounts Payable system.JD Edwards EnterpriseOne ProductsThis implementation guide refers to these JD Edwards EnterpriseOne products from Oracle: JD Edwards EnterpriseOne Accounts Receivable. JD Edwards EnterpriseOne Address Book. JD Edwards EnterpriseOne Advanced Cost Accounting. JD Edwards EnterpriseOne Fixed Assets. JD Edwards EnterpriseOne General Accounting. JD Edwards EnterpriseOne Grower Management. JD Edwards EnterpriseOne Procurement.JD Edwards EnterpriseOne Application FundamentalsAdditional, essential information describing the setup and design of the system appears in a companion volume ofdocumentation called JD Edwards EnterpriseOne Financial Management Application Fundamentals 9.2 Implementationguide.Customers must conform to the supported platforms for the release as detailed in the JD Edwards EnterpriseOneminimum technical requirements. See document 745831.1 (JD Edwards EnterpriseOne Minimum TechnicalRequirements Reference) on My Oracle umentDisplay?id 745831.1In addition, JD Edwards EnterpriseOne may integrate, interface, or work in conjunction with other Oracle products. Referto the cross-reference material in the Program Documentation at http://oracle.com/contracts/index.html for Programprerequisites and version cross-reference documents to assure compatibility of various Oracle products.Note: "Getting Started with JD Edwards EnterpriseOne Financial Management Application Fundamentals, JDEdwards EnterpriseOne Financial Management Application Fundamentals Implementation" in the JDEdwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide .Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website atwww.oracle.com/pls/topic/lookup?ctx acc&id docacc .http://i

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuidePrefaceAccess to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. Forinformation, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trs if you are hearing impaired.Related InformationFor additional information about JD Edwards EnterpriseOne applications, features, content, and training, visit the JDEdwards EnterpriseOne pages on the JD Edwards Resource Library located at:http://learnjde.comTo navigate to this page from the My Oracle Support home page, click the Knowledge tab, and then click the Tools andTraining menu, JD Edwards EnterpriseOne, Welcome Center, Release Information Overview.ConventionsThe following text conventions are used in this document:ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associated with an action, or terms defined intext or the glossary.ItalicsItalic type indicates book titles, emphasis, or placeholder variables for which you supply particularvalues.MonospaceMonospace type indicates commands within a paragraph, URLs, code in examples, text that appearson the screen, or text that you enter.ii

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideChapter 1Introduction to JD Edwards EnterpriseOne AccountsPayable1Introduction to JD Edwards EnterpriseOneAccounts PayableAccounts Payable OverviewAn accounts payable department has many responsibilities to fulfill to ensure that payments to suppliers are made ontime and the needs for flexibility in the organization are met:Managing Supplier RelationshipsThe accounts payable department is responsible for creating and maintaining a partnership with each supplier toensure that all terms and conditions of the relationship are met.Processing InvoicesThe accounts payable department receives invoices and records liabilities and corresponding expenses or assets.Often, the accounts payable department will have to match vouchers with invoices and purchase orders from otherdepartments such as purchasing.Processing PaymentsThe accounts payable department ensures that payments are made in the most timely, accurate, and efficient mannerpossible. Before paying its suppliers, the accounts payable department needs to consider several factors, such as thedue date of the invoice, whether a discount can be taken, and the amount of cash on hand versus the amount due tosuppliers.Accounts Payable Business ProcessesThis process flow illustrates the Accounts Payable business processes:1

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideChapter 1Introduction to JD Edwards EnterpriseOne AccountsPayableAccounts Payable IntegrationsThe JD Edwards EnterpriseOne Accounts Payable system works with other JD Edwards EnterpriseOne systems toensure that all payables transactions and information are fully integrated into accounts payable.This graphic illustrates the systems that integrate with the JD Edwards EnterpriseOne Accounts Payable system:2

JD Edwards EnterpriseOne ApplicationsAccounts Payable Implementation GuideChapter 1Introduction to JD Edwards EnterpriseOne AccountsPayableThese systems integrate with the JD Edwards EnterpriseOne Accounts Payable system, as described:JD Edwards EnterpriseOne General AccountingThis system debits and credits various general ledger accounts are when a voucher and payment are processed.When you enter a voucher, the system debits the general ledger expense account and credits the accounts payabletrade account. When you pay the voucher, the system debits the accounts payable trade account and credits the bankaccount. The system creates vouchers in the JD Edwards EnterpriseOne Procurement system when you match apurchase receipt to the supplier invoice.JD Edwards EnterpriseOne ProcurementThis system creates vouchers when you match a purchase receipt to the supplier invoice.JD Edwards EnterpriseOne Contract Service BillingThis system accumulates cost transac

JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide 19 Appendix A - Mapping Voucher Transactions to Batch Input Tables 279 Mapping Fields in the Voucher Transactions - Batch Upload Table (F0411Z1) .

Related Documents:

4.2.1 JD Edwards EnterpriseOne Inventory Management and JD Edwards EnterpriseOne Configurator 4-3 4.2.2 JD Edwards EnterpriseOne Product Data Management and JD Edwards EnterpriseOne Configurator 4-4 4.2.3 JD Edwards EnterpriseOne Shop Floor Management and JD Edwards EnterpriseOne Configurator 4-5

Welcome to the JD Edwards EnterpriseOne Applications Capital Asset Management Implementation Guide. Audience This guide is intended for implementers and end users of the JD Edwards EnterpriseOne Capital Asset Management system. JD Edwards EnterpriseOne Products This implementation guide refers to these JD Edwards EnterpriseOne products from Oracle:

solution for implementing Oracle Database in Amazon RDS for use with JD Edwards EnterpriseOne. When designing your JD Edwards EnterpriseOne footprint, consider the entire lifecycle of JD Edwards EnterpriseOne on AWS, which includes complete disaster recovery. Disaster recovery is not an afterthought, it's encapsulated in the design fundamentals.

Welcome to the JD Edwards EnterpriseOne Tools Report Printing Administration Technologies Guide. This guide has been updated for JD Edwards EnterpriseOne Tools release 9.2.x. For details on documentation updates, see the JD Edwards EnterpriseOne Tools Net Change for Tools Documentation Library Audience

JD Edwards EnterpriseOne Tools BI Publisher for JD Edwards . - Oracle . EnterpriseOne.

Welcome to the JD Edwards EnterpriseOne Applications Integration with Primavera Contract Management Implementation Guide. Audience This guide is intended for implementers and end users who are integrating JD Edwards EnterpriseOne with the Primavera Contract Management system. Oracle Products This implementation guide refers to these Oracle .

Review, approve, reject, and comment on requisition self service orders. JD Edwards EnterpriseOne Mobile Smartphone Applications Customers using Applications 9.0 and 9.1 releases with Tools 9.1.x can still use the JD Edwards EnterpriseOne Mobile Smartphone Applications for iPhone, Android, an

What is JD Edwards EnterpriseOne 9 The history of JD Edwards began from 1977. J.D. Edwards was acquired by PeopleSoft Inc. in 2003. In 2005, Oracle acquired PeopleSoft, and with it the JD Edwards applications and technology. JD Edwards EnterpriseOne is a suite of enterprise resource planning (ERP) software that is now