Contents
1 Introduction to JD Edwards EnterpriseOne Contract and Service Billing
- JD Edwards EnterpriseOne Contract and Service Billing Overview
- JD Edwards EnterpriseOne Contract Billing Business Processes
- JD Edwards EnterpriseOne Service Billing Business Processes
- JD Edwards EnterpriseOne Contract and Service Billing Integrations
- JD Edwards EnterpriseOne General Accounting
- JD Edwards EnterpriseOne Accounts Payable
- JD Edwards EnterpriseOne Accounts Receivable
- JD Edwards EnterpriseOne Payroll and Time Accounting
- JD Edwards EnterpriseOne Work Orders
- JD Edwards EnterpriseOne Equipment/Plant Management
- JD Edwards EnterpriseOne Real Estate Management
- JD Edwards EnterpriseOne Service Management
- JD Edwards EnterpriseOne Address Book
- JD Edwards EnterpriseOne Advanced Contract Billing
- JD Edwards EnterpriseOne Contract and Service Billing Implementation
2 Setting Up JD Edwards EnterpriseOne Contract Billing and Service Billing
- Setting Up JD Edwards EnterpriseOne Contract Billing and Service Billing
- Understanding Setup Requirements
- Understanding Multicurrency Setup
- Understanding Revenue Recognition Setup for Contract and Service Billing Invoices
- Setting Up Billing Constants
- Understanding Billing Constants
- Understanding Independent Revenue and Invoice Amounts
- Understanding Draft and Final Invoice Numbering
- Understanding Constants for Multicurrency
- Prerequisites
- Forms Used to Set Up Billing Constants
- Setting Up Billing Constants
- Setting Up Company Exceptions
- Setting Up Draft and Final Invoice Numbering
- Setting Up UDCs
- Tax Explanation Codes (00/EX)
- Component Codes (48/CM)
- Adjustment Reasons (48/AR)
- Business Unit (Job) Class (00/11)
- Cost Pool (00/12)
- Work Order Class (00/W7)
- Change Status (52/CH)
- Contract Status (52/CS)
- Change Order Category Codes 1 - 2 (52/A1 - A2)
- Billing Line Category Codes 3 - 5 (52/A3 - A5)
- Contract Category Codes 1 - 5 (52/01 - 05)
- Contract Category Codes 11 - 15 (52/11 - 15)
3 Setting Up Table Information
- Understanding Billing Rate and Markup Rules
- Understanding Searches for Billing Rate and Markup Rules
- Setting Up Billing Rate and Markup Rules
- Setting Up Tax Derivation Rules
- Setting Up G/L Offset and Retainage Rules for JD Edwards EnterpriseOne Service Billing
- Setting Up AAIs for Billing
- Understanding Financial AAIs for Billing
- Understanding Billing AAIs for Contracts
- Understanding Billing AAIs
- Actual Revenue Account (4811) - Required
- Tax Liability Account (4815)
- Taxable Receivables Accounts (4822 and 4823)
- Accrued Revenue Account (4831)
- Accrued Receivable Account (4832)
- Work In Progress Account (4841) and Cost of Goods Sold Account (4842)
- Revenue Margin Accounts (4871 and 4872)
- Invoice Margin Accounts (4873 and 4874)
- Not-to-Exceed Offsets (4851 and 4852)
- Understanding Key Types and Table Keys for Billing AAIs
- Understanding Major Keys for Billing AAIs
- Understanding Minor Keys for Billing AAIs
- Understanding AAI Processing for Invoice and G/L Journal Generation
- Understanding Base Rules
- Understanding Reallocation Rules
- Prerequisites
- Common Fields Used in This Section
- Forms Used to Set Up Automatic Accounting Instructions for Billing
- Setting Processing Options for Billing AAIs (P48S95)
- Setting Up AAI Base Rules
- Setting Up AAI Reallocation Rules
- Setting Up Component Rules
- Setting Up Fees
4 Setting Up Invoice Processing
- Setting Up Sequence and Summarization Rules
- Setting Up Invoice Print Version Cross References
- Setting Up Invoice Formats
5 Understanding Accounting for the Billing Cycle
- Billing AAI Rules
- Base Rules
- Reallocation Rules
6 Understanding the Multicurrency Time Accounting Process
- System Setup
- Considerations for Setting Up Company Options in JD Edwards EnterpriseOne Human Capital Management
- Considerations for Setting Up JD Edwards EnterpriseOne General Accounting Constants
- Considerations for Setting Up Currency Exchange Rates
- Considerations for Setting Up UDC 48/MT (Markup Generation Type)
- Considerations for Setting Up the Time Entry MBF Processing Options (P050002A)
- Considerations for Setting Up a Billing Rate and Markup Table
- Considerations for Setting Up Employee Payroll Information
- Time Entry
- Workfile Generation
- Examples: Multicurrency Timecard Entries
7 Understanding Retainage Calculations for JD Edwards EnterpriseOne Contract Billing
- Understanding Retainage Calculations for JD Edwards EnterpriseOne Contract Billing
- Retainage in A/R with No Deferred Taxes
- Retainage in A/R with Deferred Taxes
- Retainage in G/L with No Deferred Taxes
- Retainage in G/L with Deferred Taxes
- Retainage on a Partially Complete Contract with No Schedule of Values on the T and M Billing Line
- Retainage on a Partially Complete Contract with a Schedule of Values on the T and M Billing Line
- Multiple Percentages Complete with No Schedule of Values on the T and M Billing Line
- Multiple Percentages Complete with a Schedule of Values on the T and M Billing Line
- Multiple Percentages Complete with Retainage Rules and with a Schedule of Values on the T and M Billing Line
- Retainage with a Discount
- Retainage on a Partially Complete Contract with a Discount
8 Understanding Not-To-Exceed Calculations
- Example Setup
- Revenue Generation for One Workfile Transaction
- Invoicing with Revenue Recognition for One Workfile Transaction
- Revenue Generation for Two Workfile Transactions
- Invoicing with Revenue Recognition for Two Workfile Transactions
9 Setting Up Contracts
- Understanding Contracts
- Understanding Billing Types
- Understanding Change Orders
- Understanding Revisions to Contract Billing Lines
- Understanding Multicurrency Contracts
- Creating a Contract
- Understanding Contract Master Information
- Alternate Tax Rate/Area Assignment Functionality in Contracts
- Assigning Category Codes to Contracts
- Assigning the Customer and Contract Type
- Parent and Child Relationships
- Assigning an Invoice Format Code to a Contract
- Defining NTE Rules
- Defining Retainage for a Contract
- Changing a Contract
- Deleting a Contract
- Understanding Detail Fee Processing
- Understanding Data Relationships and Contracts
- Prerequisites
- Form Used to Create a Contract
- Setting Processing Options for Contract Master Revisions (P5201) (Release 9.2 Update)
- Setting Up Contract Master Information
- Understanding Contract Master Information
- Assigning Not-to-Exceed Rules
- Defining Retainage Rules For Contracts
- Defining Bill-When-Paid Requirements
10 Defining Independent Contract Billing Lines
- Understanding Independent Contract Billing Lines
- Defining Contract Billing Lines for Lump Sum
- Understanding Lump Sum Billing Lines
- Understanding How Lump Sums Calculate Billing Amounts
- Understanding Recurring Billing Amounts
- Prerequisite
- Forms Used to Define Contract Billing Lines for Lump Sum
- Setting Processing Options for Contract Billing Line Details (P5202)
- Defining a Lump Sum for Manual Calculation
- Defining a Lump Sum to Calculate Billing Amounts
- Defining Recurring Billing Amounts
- Defining Contract Billing Lines for Unit Price
- Defining Contract Billing Lines for Milestone Billing
- Defining Contract Billing Lines for Progress Billing
- Completing a Milestone or Progress Billing Event
- Changing a Previously Billed Progress Billing Line
- Defining Contract Billing Lines for T and M or Cost Plus
11 Defining Dependent Contract Billing Lines
- Understanding Dependent Contract Billing Lines
- Understanding Prepayments for Contracts
- Defining Contract Billing Lines for Direct and Rated Draws
- Defining Contract Billing Lines for Fees
- Defining a Contract Billing Line for Components
- Defining a Contract Billing Line for Applied Burdens
- Defining a Contract Billing Line for Labor Burden
- Defining Revenue-Only Contract Billing Lines
12 Managing the Workfile
- Understanding the Workfile
- Generating the Workfile
- Reviewing Workfile Transactions
- Revising Workfile Transactions
- Understanding Workfile Transaction Revisions
- Multicurrency Processing of Workfile Revisions
- Adding G/L Transactions to the Workfile
- Changes to the Markup for a Workfile Transaction
- Ad Hoc Workfile Transactions
- Workfile Transaction Holds
- Non-T and M Revenue Workfile Transaction Revisions
- Workfile Transaction Splits
- Workfile Transaction Reextension
- Understanding Workfile Revisions for Burdening and Reburdening Transactions
- Forms Used to Revise Workfile Transactions
- Adding Existing G/L Transactions to the Workfile
- Changing the Markup for a Workfile Transaction
- Entering Ad Hoc Workfile Transactions
- Assigning a Hold Status to Workfile Transactions
- Revising Non-T and M Revenue Workfile Transactions
- Splitting Workfile Transactions
- Running the Workfile Re-extension Program
- Setting Processing Options for Workfile Re-extension (R481202)
- Understanding Workfile Transaction Revisions
- Revising Workfile History
- Understanding Workfile History
- Understanding the Workfile History Purge Program
- Forms Used to Revise Workfile History
- Moving a Workfile Transaction to the Workfile History Table
- Setting Processing Options for Workfile History Inquiry (P4812H)
- Moving a Transaction Out of History
- Running the Workfile History Purge Program
- Setting Processing Options for Workfile History Purge (R48S999)
13 Recognizing Revenue
- Understanding Revenue Recognition
- Versions and Modes for G/L Journal Generation
- Interactive Versions in G/L Journal Generation
- Types of Journal Entries
- Document Types for Revenue Recognition
- Journal Reclassification
- Understanding G/L Batches for Revenue Recognition
- Combining Revenue Recognition and Invoicing
- Revenue Reconciliation
- Reconciliation for Timing Differences
- Reconciliation for Independent Revenue and Invoice Markup
- Revenue and Invoicing for Contract Billing Lines
- Revenue Reversal
- Generating the Revenue Workfile
- Generating Preliminary G/L Journal Entries
- Reviewing and Revising Preliminary G/L Journal Entries
- Creating Final G/L Journal Entries
- Posting G/L Batches
- Rebuilding the Contract Revenue Summary Table for Contract Billing
14 Processing Invoices
- Understanding Invoice Processing
- Common Fields Used in This Chapter
- Invoice Generation
- Invoice Maintenance and Processing
- Sequence and Summarization Rules for JD Edwards EnterpriseOne Service Billing Transactions
- Journal Reclassification
- Associated G/L Batch Processing
- Document Types for Invoice Processing
- Multicurrency Processing of Invoice Generation
- Generating Invoices Automatically for JD Edwards EnterpriseOne Service Billing
- Understanding Invoice Generation for JD Edwards EnterpriseOne Service Billing
- Prerequisites
- Running the Invoice Generation Program for JD Edwards EnterpriseOne Service Billing
- Setting Data Selection for Invoice Generation for JD Edwards EnterpriseOne Service Billing
- Setting Processing Options for Invoice Generation (R48121) for JD Edwards EnterpriseOne Service Billing
- Generating Invoices Automatically for JD Edwards EnterpriseOne Contract Billing
- Understanding Invoice Generation for JD Edwards EnterpriseOne Contract Billing
- Prerequisites
- Running the JD Edwards EnterpriseOne Contract Billing Invoice Generation Program
- Setting Data Selection for JD Edwards EnterpriseOne Contract Billing Invoice Generation
- Setting Processing Options for Invoice Generation (R52121) for JD Edwards EnterpriseOne Contract Billing
- Reviewing Invoice Batches
- Understanding Invoice Batches
- Forms Used to Review Invoice Batches
- Setting Processing Options for Batch Review (P48221)
- Reviewing Invoice Batches for JD Edwards EnterpriseOne Service Billing
- Reviewing Invoices for JD Edwards EnterpriseOne Service Billing
- Reviewing Invoice Details for JD Edwards EnterpriseOne Service Billing
- Reviewing Invoice Details for JD Edwards EnterpriseOne Contract Billing
- Reviewing Summarized Invoice Information for a Time and Material Contract Billing Line
- Reviewing Summarized Invoice Information for a Unit Price Contract Billing Line
- Reviewing Summarized Invoice Information for a Lump Sum Contract Billing Line
- Revising Invoice Information
- Deleting Invoice Information
- Understanding the Deletion of Invoice Information
- Understanding the Removal of Invoices to a New Batch
- Understanding the Removal of a Workfile Transaction from an Invoice Pay Item
- Forms Used to Delete Invoice Information
- Moving Invoices to a New Batch
- Removing a Workfile Transaction from a Service Billing Invoice Pay Item
- Removing a Workfile Transaction from a T and M Invoice Pay Item
- Adding Invoice Information
- Understanding the Manual Creation of Invoice Information
- Understanding the Addition of Transactions to an Invoice
- Forms Used to Add Invoice Information
- Creating an Invoice Batch Manually
- Creating a New Invoice in a Batch for JD Edwards EnterpriseOne Contract Billing
- Adding Existing Workfile Transactions to an Invoice
- Adding Existing G/L Transactions to an Invoice
- Adding Ad Hoc Workfile Transactions to an Invoice
- Creating Credit Memos
- Creating Invoice Journal Entries
- Understanding Preliminary Invoice Journal Entries
- Understanding the Journal Edit Register
- Understanding Dates
- Understanding Final Invoice Journal Entries
- Forms Used to Create Invoice Journal Entries
- Setting Processing Options for Journal Generation (R48131)
- Setting Processing Options for Journal Edit Register (R48300)
- Creating Preliminary Invoice Journal Entries
- Printing the Journal Edit Register for Invoice Journal Entries
- Revising Override Dates
- Setting Processing Options for Create A/R Entries (R48199)
- Creating Final Invoice Journal Entries
- Posting Invoice Batches
- Printing Invoices
- Understanding Invoice Printing
- Understanding Invoice Print Versions
- Understanding Invoice Design
- Prerequisites
- Forms Used to Print Invoices
- Setting Processing Options for Invoice Print (R48504)
- Assigning an Override Invoice Print Version for JD Edwards EnterpriseOne Service Billing
- Assigning an Override Invoice Print Version for JD Edwards EnterpriseOne Contract Billing
- Printing Invoices Automatically
- Printing a Batch of Invoices Manually
- Processing Retainage for JD Edwards EnterpriseOne Service Billing
- Understanding Retainage for JD Edwards EnterpriseOne Service Billing
- Understanding Retainage Release for JD Edwards EnterpriseOne Service Billing
- Forms Used to Process Retainage for JD Edwards EnterpriseOne Service Billing
- Recalculating Retainage for JD Edwards EnterpriseOne Service Billing
- Releasing Retainage for JD Edwards EnterpriseOne Service Billing
- Processing Retainage for JD Edwards EnterpriseOne Contract Billing
- Understanding Retainage for JD Edwards EnterpriseOne Contract Billing
- Understanding Retainage Release for JD Edwards EnterpriseOne Contract Billing
- Forms Used to Process Retainage for JD Edwards EnterpriseOne Contract Billing
- Revising Retainage Amounts for JD Edwards EnterpriseOne Contract Billing
- Recalculating Retainage for JD Edwards EnterpriseOne Contract Billing
- Releasing Retainage for a Contract or Change Order for JD Edwards EnterpriseOne Contract Billing
- Releasing Retainage for a Contract Billing Line
- Working with Invoice History (Release 9.2 Update)
- Understanding Invoice History
- Understanding Printing Invoices from History
- Understanding Final Invoice Voids
- Reviewing Revenue Recognition for Contracts
- Forms Used to Work with Invoice History
- Printing Invoices from History
- Reviewing Invoice History for a JD Edwards EnterpriseOne Contract Billing Invoice
- Reviewing Detailed Invoice History for a JD Edwards EnterpriseOne Contract Billing Invoice
- Setting Processing Options for the Contract Billing Line Status Program (P52200)
- Reviewing the Status of a Contract (Release 9.2 Update)
- Voiding a Final Invoice
- Voiding a Retainage Release Invoice for JD Edwards EnterpriseOne Service Billing
15 Processing Vouchers for JD Edwards EnterpriseOne Service Billing
- Understanding Voucher Processing for JD Edwards EnterpriseOne Service Billing
- Understanding Voucher Batches
- Generating Vouchers Automatically
- Reviewing Voucher Information
- Deleting Voucher Information
- Creating Voucher Journal Entries
- Understanding Preliminary Voucher Journal Entries
- Understanding Final Voucher Journal Entries
- Prerequisite
- Form Used to Create Voucher Journal Entries
- Generating Preliminary Voucher Journal Entries
- Printing the Journal Edit Register for Voucher Journal Entries
- Setting Processing Options for Create A/P Entries (R48197)
- Generating Final Voucher Journal Entries
- Posting Voucher Batches
16 Reviewing Control Reports
- Understanding Control Reports
- Control Reports
- The Workfile Control Report
- The Workfile History Control Report
- The G/L Link to Account Ledger Control Report
- The Account Ledger to G/L Link Control Report
- The Workfile to G/L Link Control Report
- The G/L Link to Workfile Control Report
- The Invoice Summary to Workfile Control Report
- The Invoice Summary to Customer Ledger Control Report
- The Customer Ledger to Invoice Summary Control Report
- Running Control Reports
- Setting Processing Options for Invoice Summary to Workfile Control Report (R48S751)
17 Appendix A - Field Derivations for the Billing Detail Workfile (F4812)
18 Appendix B - JD Edwards EnterpriseOne Contract and Service Billing Reports
- JD Edwards EnterpriseOne Contract and Service Billing Reports: A to Z
- JD Edwards EnterpriseOne Contract and Service Billing Reports: Selected Reports
- R48096B - Billing Rate / Markup Table Listing
- R48127 - Tax Derivation Table Listing
- R48128 - G/L Offset and Retainage Table Listing
- R48139 - Revenue Journal
- R48405 - Workfile Print
- Processing Options for Workfile Print (R48405)
- R4860 - Component Table Listing
- R48S412 - Workfile Transaction Exception Report
- R48S496 - Billing Rate / Markup Table to Expire
- Processing Options for Billing Rate / Markup Table to Expire (R48S496)
- R48S95 - Billing AAIs Table Listing
- Processing Options for Billing AAIs Table Listing (R48S95)
- R48TW - Workfile Totals Report
- R5201 - Contract Print
- Processing Options for Contract Print (R5201)
- R52412 - Workfile Transactions by Contract
- R52425 - Contract History Report
- Processing Options for Contract History Report (R52425)