Transcription
Oracle PayablesUser’s GuideRELEASE 11VOLUME 1March 1998
Oracle Payables User’s Guide, Release 11The part number for this user’s guide is A58473–01 .Copyright 1988, 1998All rights reserved. Printed in the U.S.A.Primary Authors: Amy Beaulieu, Christina RavagliaMajor Contributors: Victoria Anderson, Christopher Andrews, Lauren Scott, Rob WaldContributors: Geoffrey Arone, J. Tim Ball, D. Yitzik Brenman, C. Sean Chen, Helen Chung, AlanFletcher, Joe Murphy, Emilio Hernandez, Subir Hira, Shaun Kaneshira, Evelyn Neumayr, DanaSpradley, Inderpreet WadhwaThe Programs (which include both the software and documentation) contain proprietaryinformation of Oracle Corporation; they are provided under a license agreement containingrestrictions on use and disclosure and are also protected by copyright, patent and other intellectualproperty law. Reverse engineering of the Programs is prohibited. No part of this document may bereproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose,without the express written permission of Oracle Corporation.The information contained in this document is subject to change without notice. If you find anyproblems in the documentation, please report them to us in writing. Oracle Corporation does notwarrant that this document is error free.RESTRICTED RIGHTS LEGENDPrograms delivered subject to the DOD FAR Supplement are ’commercial computer software’ and use,duplication and disclosure of the Programs shall be subject to the licensing restrictions set forth in theapplicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal AcquisitionRegulations are ’restricted computer software’ and use, duplication and disclosure of the Programsshall be subject to the restrictions in FAR 52.227–14, Rights in Data –– General, including Alternate III(June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.”The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or otherinherently dangerous applications. It shall be licensee’s responsibility to take all appropriate fail–safe,back up, redundancy and other measures to ensure the safe use of such applications if the Programsare used for such purposes, and Oracle disclaims liability for any damages caused by such use of thePrograms.Oracle is a registered trademark and Context, Enabling the Information Age, Oracle7, Oracle8, OracleApplication Object Library, Oracle Alert, Oracle Discoverer, Oracle Financials, Oracle Work in Process,Oracle Workflow, SmartClient, PL/SQL, SQL*Calc, SQL*Forms, SQL*Loader, SQL*Menu, SQL*Net,SQL*Plus, SQL*Report, SQL*ReportWriter, and SQL*QMX are trademarks or registered trademarks ofOracle Corporation.All other company or product names are mentioned for identification purposes only, and may betrademarks of their respective owners.
ContentsVOLUME 1PrefacePreface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvChapter 1Payables Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 – 1Payables Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 – 2Payables Workbenches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 – 2Chapter 2Payables Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Setting Up Oracle Payables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Choosing a Set Of Books . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payment Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payment Terms Window Reference . . . . . . . . . . . . . . . . . . . . .Invoice Tolerances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tax Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tax Names Window Reference . . . . . . . . . . . . . . . . . . . . . . . . .Withholding Tax Details Window Reference . . . . . . . . . . . . .Withholding Tax Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Maintain Tax & Certificates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Maintain Tax & Certificates Window Reference . . . . . . . . . . .Invoice Approvals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Approvals Window Reference . . . . . . . . . . . . . . . . . . .Distribution Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .QuickCodes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .QuickCodes Window Reference . . . . . . . . . . . . . . . . . . . . . . . .Interest Rates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Expense Report Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Contents2–12–22 – 102 – 122 – 142 – 172 – 202 – 232 – 252 – 282 – 302 – 322 – 342 – 362 – 402 – 432 – 442 – 462 – 48i
Expense Report Templates Window Reference . . . . . . . . . . .Signing Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reporting Entities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reporting Entity Window Reference . . . . . . . . . . . . . . . . . . . .Income Tax Regions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Income Tax Regions Window Reference . . . . . . . . . . . . . . . . .Financials Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Financials Options Window Reference . . . . . . . . . . . . . . . . . .Accounting Methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Options Window Reference . . . . . . . . . . . . . . . . . . .Automatic Payment Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Automatic Payment Programs Window Reference . . . . . . . .Payment Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payment Formats Window Reference . . . . . . . . . . . . . . . . . . .Countries and Territories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Banks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining Banks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining Bank Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining and Maintaining Payables Payment Documents . .Banks Window Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Bank Accounts Window Reference . . . . . . . . . . . . . . . . . . . . . .Payment Documents Window Reference . . . . . . . . . . . . . . . .Bank Branch Validation by Country . . . . . . . . . . . . . . . . . . . . .Bank Account Validation by Country . . . . . . . . . . . . . . . . . . .Bank Charges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Bank Transaction Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Controlling the Status of AP Accounting Periods . . . . . . . . . . . . .Account Segments for Expense Reporting . . . . . . . . . . . . . . . . . . .Account Segments for Expense Reporting WindowReference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Aging Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Special Calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Voucher Numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Setting Up Web Employees Expense Reporting . . . . . . . . . . . . . .Expense Reporting Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Descriptive Flexfields in the Enter Receipts Window . . . . . . . . . .Web Employees Expense Report Spreadsheet . . . . . . . . . . . . . . . .Setting Up Web Expense Reports Using Web ApplicationDictionary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Setting Up Credit Card Programs . . . . . . . . . . . . . . . . . . . . . . . . . .iiOracle Payables User’s Guide2 – 492 – 552 – 562 – 572 – 592 – 612 – 632 – 652 – 732 – 782 – 792 – 1052 – 1062 – 1092 – 1102 – 1142 – 1162 – 1172 – 1192 – 1242 – 1262 – 1282 – 1342 – 1372 – 1392 – 1432 – 1442 – 1452 – 1502 – 1512 – 1532 – 1552 – 1572 – 1632 – 1692 – 1852 – 1912 – 1962 – 199
Chapter 3Credit Card Code Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Code Sets Window Reference . . . . . . . . . . . . . . .Credit Card Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Programs Window Reference . . . . . . . . . . . . . . .Credit Card GL Account Sets . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Profiles Window Reference . . . . . . . . . . . . . . . . .Credit Cards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Cards Window Reference . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Transaction Employee Workflow . . . . . . . . . . . .Credit Card Transaction Manager Workflow . . . . . . . . . . . . .Setting Up Credit Cards Using Web Application DictionaryPayables Implementation Information . . . . . . . . . . . . . . . . . . . . . .Customizing Your Supplier Letters . . . . . . . . . . . . . . . . . . . . .Implementing the Invoice Payments Descriptive Flexfield .Setting Up Custom Payment Programs . . . . . . . . . . . . . . . . . .Setting Up Custom Payment Formats . . . . . . . . . . . . . . . . . . .Using the Evergreen Check Laser Format . . . . . . . . . . . . . . . .Customizing Automatic Withholding Tax . . . . . . . . . . . . . . . .Using the Multiple Organization Support Feature . . . . . . . .Setting Up Print Styles and Drivers for the SupplierMailing Labels Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2 – 2022 – 2042 – 2052 – 2062 – 2072 – 2082 – 2102 – 2132 – 2142 – 2152 – 2202 – 2272 – 2292 – 2292 – 2322 – 2322 – 2362 – 2382 – 2412 – 242Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Suppliers and Supplier Sites Window Reference . . . . . . . . . .Reviewing and Adjusting Suppliers . . . . . . . . . . . . . . . . . . . . . . . .Finding Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Adjusting Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Identifying Duplicate Suppliers . . . . . . . . . . . . . . . . . . . . . . . . . . . .Supplier Merge Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Taxpayer ID Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tax Registration Number Validation . . . . . . . . . . . . . . . . . . . . . . . .Supplier Audit Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Supplier Merge Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Purchase Order Header Updates Report . . . . . . . . . . . . . . . . . . . .3–13–23 – 103 – 133 – 343 – 343 – 353 – 353 – 393 – 393 – 423 – 433 – 453 – 463 – 46Contents2 – 243iii
Chapter 4ivInvoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Invoice Distributions . . . . . . . . . . . . . . . . . . . . . . . . .Entering Invoice Distributions Manually . . . . . . . . . . . . . . . .Prorating Freight and Miscellaneous Charges . . . . . . . . . . . .Entering Invoice Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Purchase Order Matched Invoices . . . . . . . . . . . . . . . . . .Matching to Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . .Recording Price Corrections . . . . . . . . . . . . . . . . . . . . . . . . . . .Final Matching Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . .Credit and Debit Memos . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Credit/Debit Memos . . . . . . . . . . . . . . . . . . . . . . . . .Matching Credit/Debit Memos to Purchase Orders andInvoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Clearing a Credit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Foreign Currency Invoices . . . . . . . . . . . . . . . . . . . . . . . .Manual Exchange Rate Entry . . . . . . . . . . . . . . . . . . . . . . . . . .GL Daily Rates Table Default Exchange Rate Entry . . . . . . . .AutoRate Exchange Rate Entry . . . . . . . . . . . . . . . . . . . . . . . . .Mixed Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Taxes on Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Freight on Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Invoices for Suppliers Subject to Income TaxReporting Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Updating 1099 Information . . . . . . . . . . . . . . . . . . . . . . . . . . . .Holds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Applying Holds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Releasing Holds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Approval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Submitting Online Approval for Invoices . . . . . . . . . . . . . . . .Submitting Online Approval for Invoice Batches . . . . . . . . .Payables Approval Program . . . . . . . . . . . . . . . . . . . . . . . . . . .Scheduling Invoice Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Scheduled Payments Window Reference . . . . . . . . . . . . . . . .Discounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Assets Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Project Related Invoices and Distributions . . . . . . . . . . .Purchasing Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Integrated Supplier and Purchasing Information . . . . . . . . .Purchase Order Matching . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Purchase Order Shipment and Distribution Matching . . . . .Oracle Payables User’s Guide4–14–24–54–54–74–94 – 114 – 124 – 144 – 184 – 224 – 224 – 234 – 274 – 284 – 284 – 294 – 294 – 324 – 334 – 534 – 554 – 574 – 604 – 604 – 644 – 694 – 714 – 714 – 724 – 744 – 764 – 794 – 814 – 834 – 844 – 854 – 864 – 86
Two–, Three–, and Four–way Matching . . . . . . . . . . . . . . . . .PO Default and QuickMatch Invoices . . . . . . . . . . . . . . . . . . .Payment on Receipt . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Variances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Variance Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining Accrual and Variance Accounts . . . . . . . . . . . . . . . .Closing Purchase Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Receipt Accrual . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Purging Payables and Purchasing Information . . . . . . . . . . .Procurement Card Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Credit Card Program Overview . . . . . . . . . . . . . . . .Credit Card Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Transactions Window Reference . . . . . . . . . . . . .Oracle Inventory Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Tracking Inventory Movement Statistics in Payables . . . . . .Entering Recurring Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Defining a Recurring Invoice Template . . . . . . . . . . . . . . . . . .Creating Recurring Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . .Recurring Invoices Window Reference . . . . . . . . . . . . . . . . . .Prepayments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Prepayments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Applying Prepayments to Invoices . . . . . . . . . . . . . . . . . . . . .Unapplying Prepayments . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Cancelling Prepayments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Expense Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Expense Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Entering Foreign Currency Expense Reports in theExpense Reports Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Applying Holds to Expense Reports . . . . . . . . . . . . . . . . . . . .Applying Advances Against Expense Reports . . . . . . . . . . . .Modifying and Reviewing Existing Expense Reports . . . . . .Paying Expense Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Expense Reports Window Reference . . . . . . . . . . . . . . . . . . . .Oracle Web Employees Expense Reporting . . . . . . . . . . . . . . . . . .Payables Invoice Import Program . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Invoice Import Parameters . . . . . . . . . . . . . . . . . . . .Purging Expense Reports or Invoices You Have Imported .Resolving Payables Invoice Import Exceptions . . . . . . . . . . .Invoice Import Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Import Exceptions Report . . . . . . . . . . . . . . . . . . . . . .Invoice Import Prepayments Applied Report . . . . . . . . . . . . .Contents4 – 874 – 884 – 894 – 894 – 914 – 924 – 934 – 934 – 944 – 954 – 954 – 964 – 974 – 994 – 994 – 1004 – 1014 – 1034 – 1064 – 1104 – 1114 – 1124 – 1154 – 1164 – 1204 – 1234 – 1254 – 1264 – 1274 – 1294 – 1334 – 1344 – 1414 – 1434 – 1524 – 1554 – 1554 – 1574 – 1584 – 163v
Payables Open Interface Import . . . . . . . . . . . . . . . . . . . . . . . . . . . .Submitting Payables Open Interface Import . . . . . . . . . . . . . .Payables Open Interface Import Parameters . . . . . . . . . . . . . .Payables Open Interface Import Troubleshooting . . . . . . . . .Payables Open Interface Purge Program . . . . . . . . . . . . . . . . .Payables Open Interface Outbound Advice . . . . . . . . . . . . . .Open Interface Invoices Window . . . . . . . . . . . . . . . . . . . . . . .Payables Open Interface Workflow . . . . . . . . . . . . . . . . . . . . .Payables Open Interface Report . . . . . . . . . . . . . . . . . . . . . . . .Reviewing and Adjusting Invoices . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Finding Invoice Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Finding Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Invoice Distributions . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Payment Information in the Invoice WorkbenchPayments Window (of the Invoice Workbench) Reference . .Reviewing Invoice Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Calculating a Supplier or Supplier Site Balance . . . . . . . . . . .Adjusting Invoice Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Adjusting Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Adjusting Prepayments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Adjusting Invoice Distributions . . . . . . . . . . . . . . . . . . . . . . . .Adjusting Scheduled Payments . . . . . . . . . . . . . . . . . . . . . . . .Cancelling Invoices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Identifying Duplicate Invoices . . . . . . . . . . . . . . . . . . . . . . . . .Resolving Duplicate Invoices . . . . . . . . . . . . . . . . . . . . . . . . . .Adjustment Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Adjustment Chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Prepayment Adjustment Chart . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Distribution Adjustment Chart . . . . . . . . . . . . . . . . . .Invoice Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Invoice Holds Window Reference . . . . . . . . . . . . . . . . . . . . . . . . . .Match to PO Window Reference . . . . . . . . . . . . . . . . . . . . . . . .Invoice Batches Window Reference . . . . . . . . . . . . . . . . . . . . . . . . .Invoices Window Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Distributions Window Reference . . . . . . . . . . . . . . . . . . . . . . . . . . .viOracle Payables User’s Guide4 – 1654 – 1674 – 1704 – 1714 – 1724 – 1724 – 1734 – 1734 – 1764 – 1844 – 1854 – 1864 – 1864 – 1894 – 1904 – 1904 – 1924 – 1924 – 1934 – 1954 – 1964 – 1994 – 1994 – 2054 – 2064 – 2084 – 2094 – 2104 – 2104 – 2124 – 2134 – 2194 – 2214 – 2234 – 2264 – 2294 – 238
Chapter 5Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Creating Single Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Recording Manual Payments and Wire Transfers . . . . . . . . .Paying Invoices with Quick Payments . . . . . . . . . . . . . . . . . . .Paying Invoices with Clearing Payments . . . . . . . . . . . . . . . .Paying Invoices From the Invoice Workbench . . . . . . . . . . . . . . . .Paying Invoices in Payment Batches . . . . . . . . . . . . . . . . . . . . . . . .Initiating Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . .Building Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Modifying Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . . .Formatting Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Printing Payment Batch Checks . . . . . . . . . . . . . . . . . . . . . . . .Confirming Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . .Finding Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . . .Troubleshooting a Payment Batch . . . . . . . . . . . . . . . . . . . . . .Commonly Asked Payment Batch Questions . . . . . . . . . . . . .Why An Invoice May Not Be Paid In A Payment Batch . . . .Cancelling Payment Batches . . . . . . . . . . . . . . . . . . . . . . . . . . .Printing a Preliminary Payment Register . . . . . . . . . . . . . . . .Printing a Final Payment Register . . . . . . . . . . . . . . . . . . . . . .Printing Separate Remittance Advice . . . . . . . . . . . . . . . . . . . .Creating Foreign Currency Payments . . . . . . . . . . . . . . . . . . . . . . .Stopping or Voiding Foreign Currency Payments . . . . . . . . .Creating Zero–Amount Payments . . . . . . . . . . . . . . . . . . . . . . . . . .Electronic Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Creating Electronic Funds Transfer Payments withoutthe Oracle EDI Gateway . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Creating Electronic Payments with the Oracle EDI GatewayTroubleshooting Electronic Payment Batches . . . . . . . . . . . . .Future Dated Payment Method . . . . . . . . . . . . . . . . . . . . . . . . . . . .Automatic Clearing for Future Dated Payments Utility andReport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing and Adjusting Payments . . . . . . . . . . . . . . . . . . . . . . . .Payment Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Finding Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reviewing Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Updating Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Updating Invalid Payment Distribution GL Accounts . . . . .Stopping Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Voiding Payments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Contents5–15–25–25–45–75–95 – 125 – 155 – 175 – 185 – 205 – 215 – 225 – 265 – 275 – 285 – 315 – 325 – 335 – 335 – 345 – 345 – 385 – 415 – 425 – 445 – 445 – 475 – 495 – 505 – 565 – 585 – 585 – 605 – 615 – 625 – 645 – 655 – 66vii
Escheating Checks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reconciling Payments with Oracle Cash Management . . . . . . . .Payment Batches Window Reference . . . . . . . . . . . . . . . . . . . . . . .Payments Window Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5 – 695 – 705 – 725 – 78IndexVOLUME 2Chapter 6Foreign Currency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Foreign Currency Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Cross Currency Payments for Fixed–Rate Currencies . . . . . .Accounting for Fixed–Rate Payments . . . . . . . . . . . . . . . . . . .AutoRate Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6–16–26–76–96 – 11Chapter 7Posting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Posting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Transfer to General Ledger Program (Posting) . . .Posting to Other General Ledger Systems . . . . . . . . . . . . . . . .Posting to Oracle General Ledger . . . . . . . . . . . . . . . . . . . . . . .Posting When You Use Oracle Cash Management . . . . . . . . .Posting When You Use Accrual Basis Accounting . . . . . . . . .Posting When You Use Cash Basis Accounting . . . . . . . . . . .Posting When you Use Combined Basis Accounting . . . . . .Posting When You Use Multiple Currencies . . . . . . . . . . . . . .Intercompany Accounting When You Use Oracle GeneralLedger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Payables Transfer to General Ledger Parameters . . . . . . . . . .Reconciling Payables Activity . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7–17–27 – 147 – 157 – 167 – 187 – 187 – 227 – 257 – 25Reports, Programs, and Listings . . . . . . . . . . . . . . . . . . . . . . . . . . .Submitting Standard Reports, Programs, and Listings . . . . . . . .Request Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Automatic Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Submitting Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Cancelling Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Monitoring Requests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8–18–28–28–38–48–48–5Chapter 8viiiOracle Payables User’s Guide7 – 277 – 297 – 35
Common Report Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . .Common Report Headings . . . . . . . . . . . . . . . . . . . . . . . . . . . .Programs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Credit Card Transaction Validation and Exception Report . .Credit Card Invoice Interface Summary . . . . . . . . . . . . . . . . .Mass Additions Create Program . . . . . . . . . . . . . . . . . . . . . . . .Unposted Invoice Sweep Program . . . . . . . . . . . . . . . . . . . . . .Update Income Tax Details Utility and Report . . . . . . . . . . . .Submitting Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Distribute Employee Card Transaction Verifications . . . . . . .Distribute Manager Card Transactions Approvals . . . . . . . .Supplier Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .New Supplier/New Supplier Site Listing . . . . . . . . . . . . . . . .Supplier Balance Revaluation Report . . . . . . . . . . . . . . . . . . . .Supplier Mailing Labels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Supplier Paid Invoice History Report . . . . . . . . . . . . . . . . . . .Supplier Payment History Report . . . . . . . . . . . . . . . . . . . . . .Suppliers Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Income Tax Forms and Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . .1099 Reporting Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1096 Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1099 Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1099 Invoice Exceptions Report . . . . . . . . . . . . . . . . . . . . . . . .1099 Payments Report . . . . . . . . . . . .
are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Oracle is a registered trademark and Context, Enabling the Information Age, Oracle7, Oracle8, Oracle Application Object Library, Oracle Alert, Oracle Discoverer, Oracle Financials, Oracle Work in Process,
