Go to main content
1/27
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Accounts Payable
1.1
Accounts Payable Overview
1.2
Accounts Payable Business Processes
1.3
Accounts Payable Integrations
1.4
Accounts Payable Implementations
1.4.1
Global Implementation Steps
1.4.2
Accounts Payable Implementation Steps
1.5
Business Interface Integration Objects
2
Setting Up the Accounts Payable System
2.1
Understanding System Setup for Accounts Payable
2.2
Setting Up Constants for Accounts Payable
2.2.1
Understanding Accounts Payable Constants
2.2.2
Forms Used to Set Up Accounts Payable Constants
2.2.3
Setting Up Accounts Payable Constants
2.3
Setting Up UDCs for Accounts Payable
2.3.1
Voucher Document Type Codes
2.3.2
Matching Document Type Codes
2.3.3
Payment Status Codes (00/PS)
2.3.4
Payment Instrument Codes (00/PY)
2.3.5
Special Handling Code - AP Pymt (00/HC)
2.3.6
1099 Processing Codes (04/TR and 01/07)
2.3.7
Bank Type Codes (00/BT)
2.3.8
Replaced Character (04/RC)
2.3.9
Special Character (04/SC)
2.4
Setting Up Next Numbers for Accounts Payable
2.4.1
Understanding Next Numbers for Accounts Payable
2.4.2
Forms Used to Set Up Next Numbers for Accounts Payable
2.4.3
Setting Up Accounts Payable Next Numbers
2.5
Setting Up AAIs for Accounts Payable
2.5.1
Understanding Accounts Payable AAIs
2.5.1.1
Payables Bank (PB)
2.5.1.2
Payables Trade (PC)
2.5.1.3
Payables Discounts Available/Lost (PKD/PKL)
2.5.1.4
Voucher Logging Expense/Trade (PP/PQ)
2.5.1.5
Example of Voucher Logging
2.5.1.6
Drafts Payable (PD)
2.5.1.7
1099s for G/L Method (PX)
2.5.2
Setting Up Accounts Payable AAIs
3
Setting Up the Accounts Payable System for Automatic Payment Processing
3.1
Understanding the Setup for Automatic Payment Processing
3.2
Setting Up Payee Control
3.2.1
Understanding Payee Control
3.2.1.1
Limitations
3.2.1.2
Setup
3.2.2
Form Used to Set Up Payee Control
3.2.3
Setting Processing Options for A/P Payee Control Server - Processing Options (X0450)
3.2.3.1
Levels
3.2.3.2
Option
3.3
Setting Up Payment Instruments and Print Programs
3.3.1
Understanding the Assignment of Print Programs to Payment Instruments
3.3.2
Prerequisites
3.3.3
Forms Used to Set Up Payment Instruments and Print Programs
3.3.4
Assigning Print Programs to Payment Instruments
3.4
Setting Up a Print Sequence for Payments
3.4.1
Understanding Print Sequences
3.4.2
Form Used to Set Up a Print Sequence for Payments
3.4.3
Setting Up a Payment Sequence
3.5
Setting Up Payment Information by Business Unit
3.5.1
Understanding How to Print Payment Information by Business Unit
3.5.2
Forms Used to Set Up Payment Information by Business Unit
3.5.3
Setting Up Payment Information to Print by Business Unit
3.6
Preventing the Company Name from Printing on Payments
3.6.1
Understanding How to Prevent the Company Name from Printing on Payments
3.6.2
Form Used to Prevent the Company Name from Printing on Payments
3.6.3
Preventing the Company Name from Printing on Payments
3.7
Setting Up the System for EFT Payments
3.8
Setting Up the System for EDI Payments
4
Setting Up Payment Formats
4.1
Understanding Payment Formats
4.2
Prerequisites
4.3
Setting Up Standard Payment Formats
4.3.1
Understanding Standard Payment Formats
4.3.2
Setting Processing Options for Print Automatic Payments - Standard Format (R04572)
4.3.2.1
Translation
4.3.2.2
Defaults
4.3.2.3
Select
4.3.2.4
Print
4.3.3
Setting Processing Options for Print Automatic Payments - Draft Format (R04572N)
4.3.3.1
Address
4.3.3.2
Payment
4.3.3.3
Print
4.3.4
Setting Processing Options for Create A/P Bank Tape - PPD Format (R04572T1)
4.3.4.1
EFT
4.3.4.2
Print
4.3.4.3
Tape
4.3.5
Setting Processing Options for Create A/P Bank Tape - CTX Format (R04572T2)
4.3.5.1
Process
4.3.5.2
Print
4.3.5.3
Tape
4.3.6
Setting Processing Options for Create A/P Bank Tape - EDI Format (R47052T)
4.3.6.1
Defaults
4.3.6.2
Print
4.3.7
Setting Processing Options for Print Automatic Payments - Subcontract Processing (R04572J)
4.3.7.1
Translation
4.3.7.2
Address
4.3.7.3
Payment
4.3.7.4
Print
4.3.8
Processing Option for Create A/P Bank File - IAT Format Program (R04572T3)
4.3.8.1
Process
4.3.8.2
Print
4.3.8.3
Tape
5
Entering Supplier Information
5.1
Understanding Supplier Master Information
5.2
Common Fields Used in This Chapter
5.3
Entering Supplier Master Information
5.3.1
Understanding Supplier Master Information
5.3.1.1
Revising Supplier Master Information
5.3.1.2
Deleting Supplier Master Records
5.3.2
Understanding the Pre-Note Code Check Box on the Supplier Master Revision Form
5.3.3
Understanding How to Set Up Suppliers for Withholding
5.3.4
Forms Used to Enter Supplier Master Records
5.3.5
Setting Processing Options for Supplier Master Revision (P04012)
5.3.5.1
Entry
5.3.5.2
Defaults
5.3.5.3
Versions
5.3.6
Setting Processing Options for Supplier Master MBF - PO (P0100043)
5.3.6.1
Outbound
5.3.7
Entering Supplier Master Records
5.3.7.1
Vouchers
5.3.7.2
G/L Distribution
5.3.7.3
Tax Information
5.3.8
Assigning Bank Accounts to Suppliers
5.4
Using the Supplier Self Service Program
5.4.1
Understanding the Supplier Self Service Program
5.4.2
Form Used to Update Supplier Information Using Supplier Self Service
5.4.3
Setting Processing Options for Supplier Self Service (P04012SS)
5.4.3.1
Versions
5.4.4
Using the Supplier Self Service Program
5.5
Setting Up Multiple Bank Accounts for Suppliers
5.5.1
Understanding the Process for Setting Up Multiple Bank Accounts for Suppliers
5.5.2
Understanding How to Activate a Bank Account as a Vendor Record Type
5.5.3
Forms Used to Set Up Multiple Bank Accounts for Suppliers
5.5.4
Setting Up Multiple Bank Accounts for Suppliers
5.6
Assigning Payment Instrument and GL Account Relationships
5.6.1
Understanding the Process for Assigning Payment Instrument and GL Account Relationships
5.6.2
Form Used to Assign Payment Instrument and GL Account Relationships
5.6.3
Assigning Payment Instrument and GL Account Relationships
5.7
Updating the Approver and Category Code 7 Fields
5.7.1
Understanding the Update Approver Cat Code 7 Report
5.7.1.1
Example of Approver Number and Category Code 7 Update
5.7.2
Running the Update Approver/Cat Code 7 Report
5.7.3
Setting Processing Options for Update Approver/Cat Code 7 (R04802)
5.7.3.1
Process
5.8
Verifying YTD Voucher Amounts
5.8.1
Understanding YTD Voucher Amounts
5.8.1.1
Updating YTD Voucher Amounts
5.8.2
Understanding Computation Methods
5.8.2.1
Computation Method 1
5.8.2.2
Computation Method 2
5.8.3
Running the Update YTD Voucher Amount (R04820A) Program
5.8.4
Setting Processing Options for Update YTD Voucher Amount (R04820A)
5.8.4.1
Date Options
5.8.4.2
Processing
5.8.4.3
Currency
6
Processing Accounts Payable Vouchers
6.1
Understanding Voucher Processing
6.1.1
Posting Vouchers
6.1.2
Revising Posted Vouchers
6.2
Entering Standard Vouchers
6.2.1
Understanding Standard Vouchers
6.2.1.1
The Header and Detail Areas of a Voucher
6.2.1.1.1
Alternate Tax Rate/Area Assignment Functionality (Release 9.1 Update)
6.2.1.2
Payment Terms
6.2.1.3
Entering GL Distribution Based on a Model
6.2.1.4
Entering Vouchers with Discounts
6.2.1.5
Entering Debit Memos
6.2.1.6
Entering Invoices and Vouchers Out of Balance
6.2.1.7
Revising Unposted Vouchers
6.2.1.8
Deleting Unposted Vouchers
6.2.2
Understanding Additional Voucher Entry Methods
6.2.2.1
Speed Voucher Entry (P0411SV)
6.2.2.2
Multiple Voucher Entry Programs
6.2.2.3
Multi Company-Single Supplier
6.2.3
Understanding the Voucher Entry Master Business Function (MBF)
6.2.4
Prerequisites
6.2.5
Forms Used to Enter Standard Vouchers
6.2.6
Setting Processing Options for Standard Voucher Entry (P0411) (Release 9.1 Update)
6.2.6.1
Display
6.2.6.2
Currency
6.2.6.3
Manual Payments
6.2.6.4
Purchasing
6.2.6.5
Voucher Match
6.2.6.6
Multi Company
6.2.6.7
Multi Vouchers
6.2.6.8
Logging
6.2.6.9
Prepayments
6.2.6.10
Versions (Release 9.1 Update 2)
6.2.6.11
Process
6.2.6.12
Edits
6.2.6.13
Pay When Paid (Release 9.1 Update 2)
6.2.7
Setting Processing Options for Voucher Entry MBF (P0400047)
6.2.7.1
Defaults
6.2.7.2
Date Edits
6.2.7.3
Currency
6.2.7.4
Manual Payments
6.2.7.5
Purchasing
6.2.7.6
Logging
6.2.7.7
Interop
6.2.8
Using Real-Time Summarization in the Standard Voucher Entry Program (P0411)
6.2.9
Entering Standard Vouchers
6.2.10
Entering GL Distribution Information
6.2.11
(POL) Entering Additional Voucher Information for Poland
6.2.12
Entering Additional Information for Grower Contracts
6.2.13
Setting Processing Options for Speed Voucher Entry (P0411SV)
6.2.13.1
Payments
6.2.13.2
Versions
6.2.13.3
Pay When Paid
6.2.14
Entering Speed Vouchers
6.2.15
Entering Multiple Voucher for a Single Supplier
6.2.16
Entering Multiple Vouchers for Multiple Suppliers
6.2.17
Entering Vouchers for Multiple Companies and a Single Supplier
6.3
Processing Logged Vouchers
6.3.1
Understanding Logged Voucher Processing
6.3.1.1
Redistributing Logged Vouchers
6.3.1.2
Redistributing a Purchase Order Voucher
6.3.2
Prerequisites
6.3.3
Forms Used to Process Logged Vouchers
6.3.4
Entering Logged Vouchers
6.3.5
Setting Processing Options for Voucher JE Redistribution (P042002)
6.3.5.1
Defaults
6.3.5.2
Versions
6.3.6
Redistributing a Logged Voucher
6.3.7
Entering Expense Accounts
6.4
Processing Recurring Vouchers
6.4.1
Understanding Recurring Vouchers
6.4.1.1
Revising Recurring Vouchers
6.4.1.2
Canceling Recurring Vouchers
6.4.1.3
Adding Recurring Information to an Existing Transaction
6.4.1.4
Printing the Recurring Voucher
6.4.1.5
(COL) Vouchers Saved in a Foreign Currency
6.4.2
Understanding the Recycle Process
6.4.2.1
The Recycle Process
6.4.3
Prerequisites
6.4.4
Forms Used to Enter Recurring Vouchers
6.4.5
Entering Recurring Voucher Information
6.4.6
Running the Recycle Recurring Vouchers Report
6.4.7
Setting Processing Options for Recycle Recurring Vouchers Report (R048101)
6.4.7.1
Defaults
6.4.8
Running the Recurring Voucher Report
6.4.9
Setting Processing Options for Recurring Voucher Report (R04305)
6.5
Processing Prepayments
6.5.1
Understanding Prepayments
6.5.1.1
Example of Entering and Paying Prepaid Vouchers
6.5.2
Prerequisites
6.5.3
Forms Used to Process Prepayments
6.5.4
Entering Prepayment Vouchers
6.5.5
Closing Out Negative Pay Items for Prepaid Vouchers
7
Processing Batch Vouchers
7.1
Understanding Batch Voucher Processing
7.1.1
Integration with Oracle Demantra Predictive Trade Planning
7.2
Prerequisite
7.3
Processing Batch Vouchers
7.3.1
Understanding the Batch Voucher Process
7.3.1.1
Errors in Processing
7.3.1.2
Improving Processing Time
7.3.1.3
Posting Processed Batch Vouchers
7.3.2
Prerequisite
7.3.3
Running the Batch Voucher Processor Report
7.3.4
Setting Processing Options for Batch Voucher Processor Report (R04110ZA)
7.3.4.1
Select
7.3.4.2
Process
7.3.4.3
Messages
7.3.4.4
Defaults
7.3.4.5
Versions
7.3.4.6
Batch Approval
7.3.4.7
Auto Post
7.4
Working with Batch Vouchers
7.4.1
Understanding the Batch Voucher Revisions Program
7.4.1.1
Alternate Tax Rate/Area Assignment Functionality (Release 9.1 Update)
7.4.1.2
Voucher Match Automation (Release 9.1 Update)
7.4.2
Forms Used to Work with Batch Vouchers
7.4.3
Setting Processing Options for Batch Voucher Revisions (P0411Z1)
7.4.3.1
Defaults
7.4.3.2
Dates
7.4.3.3
Currency
7.4.3.4
Manual Cks
7.4.3.5
Journal Entry
7.4.3.6
Display
7.4.3.7
Entry Type
7.5
Purging Processed Batch Vouchers
7.5.1
Understanding Purging Processed Batch Vouchers
7.5.2
Running the Purge Batch Voucher Entries Report
8
Processing Inbound EDI Vouchers
8.1
Understanding EDI Voucher Processing
8.1.1
Understanding the Mapping Requirements for Processing Inbound EDI Vouchers
8.2
Transferring Inbound EDI Voucher Transactions
8.2.1
Understanding the Edit/Create Voucher Program
8.2.2
Running the Processing Options for Edit/Create Voucher Program
8.2.3
Setting Processing Options for Edit/Create Voucher (R47041)
8.2.3.1
Processing
8.2.3.2
Default Option
8.2.3.3
Default Values
8.2.3.4
Logging
8.2.3.5
Auto Process
8.3
Purging Processed Inbound EDI Vouchers
8.3.1
Understanding the Purge Inbound Vouchers Report.
8.3.2
Running the Purge Inbound Vouchers Report
9
Preparing Vouchers for Payment
9.1
Understanding AR/AP Netting
9.2
Reviewing and Approving Changes to Controlled Data
9.2.1
Understanding the Process for Reviewing and Approving Changes to Controlled Data
9.2.1.1
Printing Changes to Controlled Data
9.2.1.2
Purging Approved Payee Control Records
9.2.2
Forms Used to Review and Approve Changes to Controlled Data
9.2.3
Reviewing and Approving Changes to Controlled Data
9.2.4
Printing Changes to Controlled Data
9.2.5
Purging Approved Payee Control Records
9.3
Calculating Withholding
9.3.1
Understanding Calculating Withholding
9.3.1.1
Reporting Withheld Amounts
9.3.2
Understanding the Process to Pay Withheld Amounts
9.3.3
Prerequisites
9.3.4
Running the Calculate Withholding Report
9.3.5
Setting Processing Options for Calculate Withholding (R04580)
9.3.5.1
Pay Status
9.3.5.2
G/L Offset
9.3.5.3
Tax Authority
9.4
Determining Cash Requirements
9.4.1
Understanding the Cash Requirements Report
9.4.2
Running the Cash Requirements Report
9.4.3
Setting Data Selection for Cash Requirements Report
9.4.4
Setting Processing Options for Cash Requirements Report (R04431)
9.4.4.1
Print
9.4.4.2
Aging
9.4.4.3
Process
9.5
Using Speed Status Change to Review and Revise Vouchers
9.5.1
Understanding the Speed Status Change Program
9.5.1.1
Reviewing Vouchers
9.5.1.2
Revising Vouchers
9.5.1.3
Splitting Vouchers
9.5.1.4
(ITA) Splitting Vouchers
9.5.1.5
Setting Up Existing Vouchers for Withholding
9.5.2
Forms Used to Review and Revise Vouchers Using Speed Status Change
9.5.3
Setting Processing Options for Speed Status Change (P0411S)
9.5.3.1
Pre-Load Data
9.5.3.2
Payment Terms
9.5.4
Revising an Individual Pay Item
9.5.5
Revising Multiple Vouchers
9.5.6
Splitting Vouchers for Payment
10
Processing Automatic Payments
10.1
Understanding the Automatic Payment Process
10.2
Creating Payment Groups
10.2.1
Understanding the Create Payment Control Groups Program
10.2.2
Understanding Vouchers with Discounts
10.2.3
Understanding Next Numbers for Create Payment Control Groups
10.2.4
Prerequisites
10.2.5
Running the Create Payment Control Groups Program
10.2.6
Setting Data Sequence for Create Payment Control Groups
10.2.6.1
Example of Data Sequenced by Business Unit
10.2.6.2
Example of Data Sequence by Due Date and Payment Creation by Voucher
10.2.7
Setting Processing Options for Create Payment Control Groups (R04570)
10.2.7.1
Dates
10.2.7.2
Amounts
10.2.7.3
Printing
10.2.7.4
Process By
10.2.7.5
Summarize
10.2.7.6
Report
10.2.7.7
Bank Tape
10.2.7.8
Withholding
10.3
Working With Payment Groups
10.3.1
Understanding the Process to Work with Payments
10.3.2
Understanding the Review Process for Payment Groups
10.3.3
Understanding the Process to Revise Unprocessed Payments
10.3.4
Understanding the Write Process
10.3.4.1
Writing Payments for EFT Payment Groups
10.3.4.2
Record Reservation for Payments
10.3.4.3
Payment ID Using Next Numbers
10.3.5
Understanding the Reset Process
10.3.6
Understanding the Process to Remove Processed Payments
10.3.7
Understanding the Update Process
10.3.7.1
Reviewing, Approving, and Posting Payments
10.3.8
Forms Used to Work With Payment Groups
10.3.9
Setting Processing Options for Work With Payment Groups (P04571)
10.3.9.1
Print
10.3.9.2
Update
10.3.9.3
Display
10.3.9.4
Currency
10.3.9.5
Process
10.3.9.6
BACS
10.3.10
Splitting a Payment
10.3.11
Revising the Value Date of a Payment
10.3.12
Revising Control Information for a Payment Group
10.3.13
Writing Payments
10.4
Voiding Automatic Payments and Vouchers
10.4.1
Understanding the Process to Void Automatic Payments and Vouchers
10.4.1.1
Voiding an Automatic Payment and Its Vouchers
10.4.2
Forms Used to Void Automatic Payments and Vouchers
10.4.3
Voiding Automatic Payments and Vouchers
10.5
Copying Payments to a Diskette
10.5.1
Understanding the Process to Copy Payments to a Diskette
10.5.1.1
Additional Tape Copy Options
10.5.2
Forms Used to Copy Payments to a Diskette
10.5.3
Setting Processing Options for Copy Bank Tape File to Tape (P0457)
10.5.3.1
BACS
10.5.3.2
Program
10.5.3.3
Version
10.5.4
Setting Processing Options for Copy Bank File to Diskette (P0457D)
10.5.4.1
Defaults
10.5.4.2
Data
10.5.5
Reviewing and Changing the Status and Detail for a Tape Table
10.5.6
Copying a Tape Table to Diskette
11
Processing Outbound EDI Payments
11.1
Understanding the Outbound EDI Payments Process
11.2
Transferring Outbound Payment Transactions
11.2.1
Understanding the Copy to Outbound EDI Files Program
11.2.2
Running the Copy to Outbound EDI Files Report
11.2.3
Setting Data Selection for the Copy to Outbound EDI Files Report
11.3
Updating Processed Transactions
11.3.1
Understanding the Update as Sent Program
11.3.2
Running the Update as Sent Program
11.4
Purging Processed Outbound EDI Payments
11.4.1
Understanding the Purge EDI Files Report
11.4.2
Running the Purge EDI Files Report
12
Processing Accounts Payable Drafts
12.1
Understanding Draft Processing
12.1.1
Example of Paying Drafts
12.1.2
Voiding Paid Drafts
12.1.3
Reviewing Paid Drafts
12.2
Prerequisites
12.3
Closing Paid Drafts
12.3.1
Understanding How to Close Paid Drafts
12.3.2
Forms Used to Close Paid Drafts
12.3.3
Closing Paid Drafts
12.4
Posting Closed Drafts
12.4.1
Understanding the Process to Post Closed Drafts
12.4.2
Running the Post Outstanding Drafts Program
12.4.3
Setting Processing Options for Post Outstanding Drafts (R04803)
12.4.3.1
Process
12.4.3.2
Currency
13
Processing Manual Payments
13.1
Understanding the Manual Payments Process
13.1.1
Payment With Existing Voucher
13.1.2
Payment Without Existing Voucher
13.1.3
Revising Unposted Manual Payments
13.1.4
Reviewing Manual Payments
13.1.5
Approving and Posting Manual Payments
13.2
Entering Manual Payments with Voucher Match
13.2.1
Understanding Manual Payments with Voucher Match
13.2.1.1
Using the Select Open Pay Items Form
13.2.2
Forms Used to Enter Manual Payments With Voucher Match
13.2.3
Setting Processing Options for Payment With Voucher Match (P0413M)
13.2.3.1
Defaults
13.2.3.2
Display
13.2.3.3
Processing
13.2.3.4
Currency
13.2.3.5
Print
13.2.3.6
Voids
13.2.3.7
Inquiry
13.2.3.8
Netting
13.2.4
Entering Manual Payments With Voucher Match
13.2.5
Selecting Pay Items for a Manual Payment
13.3
Entering Manual Payments Without Existing Vouchers
13.3.1
Understanding Manual Payments Without Existing Vouchers
13.3.2
Prerequisite
13.3.3
Forms Used to Enter Manual Payments Without Voucher Match
13.3.4
Entering Manual Payments Without Voucher Match
13.4
Printing Manual Payments
13.4.1
Understanding How to Print Manual Payments
13.4.2
Forms Used to Print Manual Payments
13.4.3
Printing Manual Payments With Voucher Match
13.4.4
Printing Manual Payments Without Voucher Match
13.5
Deleting and Voiding Manual Payments
13.5.1
Understanding How to Delete and Void Manual Payments
13.5.1.1
Voiding the Vouchers Associated with the Payment
13.5.1.2
Using the Payment Without Match Program to Void Manual Payments
13.5.2
Prerequisite
13.5.3
Forms Used to Delete and Void Manual Payments With or Without Voucher Match
13.5.4
Voiding Manual Payments
14
Using Positive Pay
14.1
Understanding Positive Pay
14.2
Prerequisites
14.3
Generating the Positive Pay Text File
14.3.1
Understanding the Generate Positive Pay Text File Program
14.3.2
Running the Generate Positive Pay Text File
14.3.3
Setting Processing Options for Generate Positive Pay Text File (R04586)
14.3.3.1
Process
14.4
Copying Positive Pay Text Files
14.4.1
Understanding the Text File Processor Program
15
Creating As Of Reports
15.1
Understanding As Of Processing
15.2
Generating the Date File
15.2.1
Understanding the Date File Generation Report
15.2.2
Running the Date File Generation Report
15.2.3
Setting Processing Options for Date File Generation (R04901A)
15.2.3.1
Process
15.3
Running the As-Of Open A/P Summary Report
15.3.1
Prerequisite
15.3.2
Generating the As-Of Open A/P Summary Report
15.3.3
Setting Processing Options for As-Of Open A/P Summary Report (R04413C)
15.3.3.1
Aging
15.3.3.2
Print
15.4
Running the As-Of A/P Detail with Remarks Report
15.4.1
Understanding the As-Of A/P Detail with Remarks Report
15.4.2
Prerequisite
15.4.3
Generating the As-Of A/P Detail with Remarks Report
15.4.4
Setting Processing Options for As-Of A/P Detail with Remarks (R04423C)
15.4.4.1
Print
15.5
Running the As-Of Open A/P Details with Aging Report
15.5.1
Understanding the As-Of Open A/P Details with Aging Report
15.5.2
Prerequisite
15.5.3
Generating the As-Of Open A/P Details with Aging Report
15.5.4
Setting Processing Options for As-Of Open A/P Details with Aging (R04423D)
15.5.4.1
Aging
15.5.4.2
Print Options
16
Verifying Data Integrity for Accounts Payable
16.1
Understanding Accounts Payable Integrity Reports
16.2
Running the A/P to G/L by Batch Report
16.2.1
Understanding the A/P Orig Doc to G/L by Batch Report
16.2.1.1
Balance Test
16.2.1.2
Pay Status Test
16.2.2
Printing the A/P Orig Doc to G/L by Batch Report
16.3
Running the A/P Payments to G/L by Batch Report
16.3.1
Understanding the A/P Payments to G/L by Batch Report
16.3.2
Printing the A/P Payments to G/L by Batch Report
16.4
Running the A/P to G/L by Offset Account Report
16.4.1
Understanding the A/P to G/L by Offset Account Report
16.4.2
Printing the A/P to G/L by Offset Account Report
16.5
Running the A/P Payments to A/P w/Update Report
16.5.1
Understanding the A/P Payments to A/P w/Update Report
16.5.2
Printing the A/P Payments to A/P w/Update Report
16.5.3
Setting Processing Options for A/P Payments to A/P w/Update (R04713)
16.5.3.1
Process
16.6
Correcting Out-Of-Balance Conditions
16.6.1
Report Amounts Do Not Net to Zero
16.6.2
Batch Was Posted Out of Balance Without Automatic Offset Entries
16.6.3
Invalid Journal Entry Was Posted to an AP Account
16.6.4
Data Records Are Damaged
16.6.5
G/L Offset Code Was Changed
16.6.6
AP Control Account Was Changed
16.6.7
The F0411 Table and F0414 Table are Out of Balance
16.6.8
General Ledger Transactions Are Out of Balance
17
Purging Accounts Payable Records
17.1
Understanding How to Purge Records from Your Accounts Payable System
17.1.1
System Administrator Responsibilities
17.1.2
Prerequisites
17.2
Purging Closed AP Records
17.2.1
Running the Purge Closed A/P Records Program
17.2.2
Setting Data Selection and Sequence for Purge Closed A/P Records
17.2.2.1
Data Selection
17.2.2.2
Data Sequencing
17.2.3
Setting Processing Options for Purge Closed A/P Records (R04800)
17.2.3.1
Select
18
Processing T5018 for Canada (Release 9.1 Update)
18.1
JD Edwards EnterpriseOne T5018 Processing Overview
18.1.1
T5018 Process Flow
18.2
Understanding the Payroll Processing for T5018
18.3
Understanding the A/P Method for T5018
18.3.1
Address Book Category Code 01/07
18.3.2
Record Identification Type Codes (H00/TA)
18.4
Understanding Sources of Information for T5018 Forms
18.5
Verifying Supplier Setup
18.5.1
Understanding Supplier Setup
18.5.2
Understanding Legal Names of T5018 Suppliers
18.5.2.1
Example of Legal Names
18.5.3
Understanding Mailing Names and Addresses for T5018 Suppliers
18.5.4
Understanding Tax IDs for T5018 Suppliers
18.6
Entering Supplier Information for T5018s
18.6.1
Forms Used to Enter Supplier Information for T5018s
18.6.2
Setting Up Mailing Information and the Code 07 Field (AC07) for a Supplier
18.6.3
Setting Up a Legal Name for a Supplier
18.7
Processing T5018s for Foreign Suppliers
18.7.1
Understanding T5018 Processing for Foreign Suppliers
18.7.2
Form Used to Process T5018s for Foreign Suppliers
18.7.3
Identifying Foreign Suppliers for T5018s
18.8
Combining Suppliers with Duplicate Tax IDs
18.8.1
Understanding Suppliers with Duplicate Tax IDs
18.8.2
Form Used to Combine Suppliers with Duplicate Tax IDs
18.8.3
Combining Suppliers with Duplicate Tax IDs
18.9
Managing Company Information
18.9.1
Understanding Company Information
18.9.1.1
Company Address Book Numbers
18.9.1.2
Company Address Book Records
18.9.2
Forms Used to Manage Company Information
18.9.3
Setting Up a T5018 Contact Name
18.9.4
Entering a Phone Number
18.10
Combining Company Information for T5018 Processing
18.10.1
Understanding Company Tax Relationships
18.10.1.1
Companies with the Same Tax ID
18.10.1.2
Example of Combining Companies for T5018 Processing
18.10.2
Form Used to Combine Companies for T5018 Processing
18.11
Working with Payroll for T5018
18.11.1
Understanding the Account Number Setup for Company and Contractors
18.11.2
Understanding the Changes to the Canadian Tax Info by EE Program
18.11.3
Understanding the Convert Tax History Type in F0713/F0716/F06146/F06156 to C Program
18.11.4
Understanding the Payroll Build T5018 Workfile Program
18.11.5
Running the Convert Tax History Type in F0713/F0716/F06146/F06156 to C Program
18.11.6
Running the Payroll Build T5018 Workfile Program
18.11.7
Setting Processing Options for Convert Tax History Type in F0713/F0716/F06146/F06156 Program (R77601)
18.11.7.1
Process
18.11.8
Setting Processing Options for Payroll Build T5018 Workfile Program (R77603)
18.11.8.1
Process
18.12
Clearing the T5018 Tax and Work Files
18.12.1
Understanding the Clear T5018 Workfile Program
18.12.2
Understanding the Clear T5018 Tax File Program
18.12.3
Running the Clear T5018 Tax File Program
18.12.4
Running the Clear T5018 Workfile Program
18.13
Building the T5018 Workfile
18.13.1
Understanding the Build T5018 Workfile - A/P Program
18.13.2
Prerequisites
18.13.3
Running the Build T5018 Workfile - A/P Program
18.13.4
Setting Processing Options for Build T5018 Workfile - A/P Program (R04614)
18.13.4.1
Process
18.14
Reviewing Records in the T5018 Workfile Table
18.14.1
Understanding T5018 Workfile Record Review
18.14.2
Form Used to Review Records in the T5018 Workfile Table
18.14.3
Reviewing Records in Workfile
18.15
Previewing T5018 Workfile
18.15.1
Understanding the Preview T5018 Workfile Program
18.15.2
Common Error Messages on T5018 Workfile Report
18.15.3
Running the Preview T5018 Workfile Report
18.15.4
Setting Processing Option for the Preview T5018 Workfile Report (R04612)
18.15.4.1
Edits
18.16
Working With the Write T5018 Media Program
18.16.1
Understanding the Write T5018 Media Program
18.16.1.1
Testing T5018 Form Alignment on the Printer
18.16.1.2
Using Multiple Versions of the Write T5018 Media Program
18.16.2
Prerequisite
18.16.3
Form Used to Print T5018 Return with the Write T5018 Media Program
18.16.4
Printing T5018 Returns
18.16.5
Setting Processing Options for the Write T5018 Media Program (P04615)
18.16.5.1
T5018
18.16.5.2
Version
A
Mapping Voucher Transactions to Batch Input Tables
A.1
Mapping Fields in the Voucher Transactions - Batch Upload Table (F0411Z1)
A.1.1
Required Fields
A.1.2
Optional Fields
A.1.3
Ignored Fields
A.1.4
Fields Reserved for Users
A.1.5
Required Fields for Processing Discounts
A.1.6
Required Fields for Processing Payments
A.1.7
Required Fields for Processing Taxes
A.1.8
Required Fields for Processing Currency
A.1.9
Fields Reserved for Voucher Match Automation (Release 9.1 Update)
A.2
Mapping Fields in the Journal Entry Transactions - Batch File Table (F0911Z1)
A.2.1
Required Fields
A.2.2
Optional Fields
A.2.3
Ignored Fields
A.2.4
Required Fields for Processing Currency
A.2.5
Required Fields When Using the Advanced Cost Accounting System
A.2.6
Required Fields When Using the Advanced Cost Accounting System to Analyze Profitability
A.3
Mapping Fields in the Voucher Transactions Batch Upload - Voucher Match Automation Table (F0411Z1T) (Release 9.1 Update)
B
Delivered Workflow for JD Edwards EnterpriseOne Accounts Payable
B.1
Delivered Workflow for JD Edwards EnterpriseOne Accounts Payable
B.1.1
Voucher Batch Approval
B.1.1.1
Description
B.1.1.2
Workflow Objects
C
JD Edwards EnterpriseOne Accounts Payable Reports
C.1
JD Edwards EnterpriseOne Accounts Payable Reports: A to Z
C.1.1
Integrity Reports
C.2
JD Edwards EnterpriseOne Accounts Payable Reports: Selected Reports
C.2.1
R04305 - Voucher Journal Report
C.2.2
Processing Options for Voucher Journal Report (R04305)
C.2.2.1
Print Options
C.2.3
R04311 - Manual Payment Journal Report
C.2.4
Data Selection for Manual Payment Journal Report
C.2.5
Processing Options for Manual Payment Journal (R04311)
C.2.5.1
Print
C.2.6
R04413 - A/P Summary Report
C.2.7
Data Sequence for A/P Summary Report (R04413)
C.2.8
Processing Options for A/P Summary Report (R04413)
C.2.8.1
Aging
C.2.8.2
Print
C.2.9
R04423A - A/P Detail by Supplier with Remarks and Net Amounts
C.2.10
Data Selection for A/P Detail by Supplier with Remarks and Net Amounts
C.2.11
Data Sequence for A/P Detail by Supplier with Remarks and Net Amounts
C.2.12
Processing Options for A/P Detail by Supplier with Remarks and Net Amounts (R04423A)
C.2.12.1
Print Options
C.2.13
R04423B - A/P Detail with Aging
C.2.14
Data Selection for A/P Detail with Aging
C.2.15
Data Sequence for A/P Detail with Aging
C.2.16
Processing Options for A/P Detail with Aging (R04423B)
C.2.16.1
Aging
C.2.16.2
Print Options
C.2.17
R04424 - Payment Details
C.2.18
Data Sequence for Payment Details
C.2.19
Processing Options for Payment Details (R04424)
C.2.19.1
Print Formats
C.2.20
R04428A - A/P Detail by Approver with Remarks
C.2.21
Processing Options for A/P Detail by Approver with Remarks (R04428A)
C.2.21.1
Print
C.2.22
R04428B - A/P Detail by Approver with Aging
C.2.23
Processing Options for A/P Detail by Approver with Aging (R04428B)
C.2.23.1
Aging
C.2.23.2
Print
C.2.24
R04830 - Update Payment Instrument Program
C.2.25
Processing Option for Update Payment Instrument Program (R04830)
C.2.25.1
Process
C.2.26
R04578 - Payment Analysis Report
C.2.27
Processing Options for Payment Analysis Report (R04578)
C.2.27.1
Print
C.2.28
R04601 - Suspected Duplicate Payments
C.2.29
Data Sequence for Suspected Duplicate Payments
C.2.30
Processing Options for Suspected Duplicate Payments (R04601)
C.2.31
R04602 - Supplier Analysis
C.2.32
Data Sequence for Supplier Analysis
C.2.33
Processing Options for Supplier Analysis (R04602)
C.2.33.1
Currency
C.2.34
R09313 - Payment Register
C.2.35
Data Sequence for Payment Register
C.2.36
Processing Options for Payment Register (R09313)
C.2.37
R09450 - Supplier/Customer Totals by G/L Account
C.2.38
Processing Options for Supplier/Customer Totals by G/L Account (R09450)
C.2.38.1
Display
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.