Skip navigation

Forecast Consumption is a planning tool that is a mystery to a many folks in the planning world. There is specific set-up and understanding required to achieve the goal of consuming forecast on end item sales. This topic is for users of Single or Multi-facility Planning (MPS/MRP) wishing to understand what Forecast Consumption is and the required set-up, to and being able to read the MRP time series confidently.

 

Is your interest piqued? For more details see Forecast Consumption for EnterpriseOne (Doc ID 625964.1). This document will outline the time series descriptions (and how to read them) when using Forecast Consumption and will cover the correct setup, process, and most importantly, an understanding to whether Forecast Consumption will satisfy your planning needs. Readers will learn that Forecast Consumption allows the requirements planning system to take into account both forecasts and total customer sales when planning and use the greater of the two to calculate planning period requirements.  When looking at the planning horizon, the system will use the forecast quantity in the later periods to drive planning requirements.

Cash basis accounting is an accounting method that recognizes revenue when cash is “received” and expenses are recognized, when cash is “paid” out. This particular accounting method shows only cash that is actually received or disbursed during a particular accounting period. The Cash Basis Accounting is in contrast to the Accrual Basis of Accounting, where revenues are recognized when they are “earned” and expenses are matched to revenues or the accounting period when they are “incurred”. So even though Cash Basis Accounting may not be in compliance with accounting's matching principle, it is relatively simpler than the Accrual Basis Accounting and might be required to use due to a requirement in an oil well lease, venture capital, or partnership.


The timing of receipts and disbursements might differ from the period of operating activities. Therefore, the period during which cash basis transactions are recorded might differ from the period during which transactions are recorded for accrual accounting.


The JD Edwards EnterpriseOne product by default maintains Accrual entries in the AA (Actual Amount) ledger. When you use Cash Basis accounting, the system generates parallel transactions from the AA ledger and updates the AZ (Cash Basis) ledger.


Understanding Accrual Entries


Transactions involving the receipt and disbursement of money occur as receipts and payments in the EnterpriseOne Accounts Receivable and EnterpriseOne Accounts Payable systems. For accrual entries, the system creates debits and credits to the bank account in the F0911 table for these batch types:


  • K: Automatic payments
  • M: Manual payments with match
  • W: Manual payments without match
  • RB: Receipts

 

The system creates the entry as one sided with a document type of PK, PN, or PT for Accounts Payable and RC or RK for Accounts Receivable. It then creates a balancing entry in the accounts payable and accounts receivable trade accounts with a document type of AE automatic entry. Because the system creates both documents in the same batch, the batch is in balance and can be posted without error.


Understanding Cash Basis


In order to determine the best business practices, you must understand how the system creates cash basis entries for the JD Edwards EnterpriseOne General Accounting, JD Edwards EnterpriseOne Accounts Payable, and JD Edwards EnterpriseOne Accounts Receivable systems.


The Create Cash Basis Entries program (R11C850) always creates cash basis entries for Account Ledger transactions, regardless of the batch type, and then launches additional programs to create accounts payable and accounts receivable balancing entries for batches K, M, W, and RB.


For payments (Accounts Payable transactions) and receipts (Accounts Receivable transactions) , the system:


  • Excludes general ledger transactions for the corresponding expense and revenue accounts because those document types (such as PV and RI) are in UDC 00/DX.
  • To balance the cash basis entry, the system automatically runs the Create Cash Basis Entries - A/P (R11C854) and Create Cash Basis Entries - A/R (R11C853) programs to retrieve the expense and revenue accounts.

 

  You can run Cash Basis program (R11C850) to create cash basis entries in following ways:


  • Running R11C850 independently from menu or batch versions


When you setup cash basis accounting for the first time, you should run the Create Cash Basis Entries program from the menu instead of from the General Ledger Post program. All transactions that were previously entered must be processed for cash basis accounting; therefore, the program requires additional processing time and might run more efficiently during off-peak hours. If you create cash basis entries periodically, such as weekly, monthly, or quarterly, you can control when to create cash basis entries by running the Create Cash Basis Entries program from the menu or batch versions independently.


  • General Ledger Post Report program (R09801) calling Cash Basis (R11C850)


After you create cash basis entries, you can ensure that your AZ ledger has the most up to date information as cash is received or disbursed by activating a processing option in the General Ledger Post program (R09801) under the Cash Basis Tab. To activate the cash basis processing option, you designate the version of the Create Cash Basis Entries program that you want to run. You can activate the cash basis processing option in versions of the General Ledger Post program for these batch types only:


    • G: General ledger
    • K: Automatic payments
    • M: Manual payments with match
    • W: Manual payments without match
    • RB: Cash Receipts


For more information on Cash Basis Accounting setup, detailed examples of how cash basis records are created for cash receipts and manual payments, please refer to the following KM documents:


  • Overview of Cash Basis Accounting (Doc ID 1458454.1)
  • Frequently Asked Questions regarding Cash Basis Accounting (Doc ID 1462188.1)

Are you investigating Vertex Q Series for Payroll and/or Sales & Use Tax to meet your business needs? Or, are you currently working with Vertex Q Series for Payroll and/or Sales & Use Tax?  Check out the wealth of information available in Vertex Knowledge Center for JD Edwards EnterpriseOne (Doc 1676973.2).

 

This document provides assistance with setup, configuration, reference and troubleshooting information related to Vertex Q Series tax software being used with the JD Edwards EnterpriseOne applications. In addition to providing easy access to knowledge documents, our knowledge center provides step-by-step start to finish instructions useful for understanding how to complete the integration of Vertex Q Series with JD Edwards EnterpriseOne, along with implementing corresponding features and functionality.

 

Both technical and functional users will find the knowledge center information helpful.  We cover  both configuration and testing details (integration), and functional aspects of relevant JD Edwards EnterpriseOne features and functionality (implementation).

 

The Overview page provides immediately useful information.  More specific and logically grouped knowledge documents (Payroll Tax, Sales & Use Tax, technical, Bugs, etc.) are provided via the "Reference & Resolve" tab.

 

The Integrate & Implement tab guides you through the process of integration and implementation of the Vertex Q Series Tax software with your JD Edwards EnterpriseOne applications.

 

Be sure to mark the Vertex Knowledge Center for JD Edwards EnterpriseOne (Doc 1676973.2) as a favorite document.


Read the Attitude@Altitude blog for a concise definition for what makes JD Edwards EnterpriseOne Applications and Tools 9.2 release so exciting.

 

This latest release provides transformational business solutions to allow companies to innovate in the digital economy, new industry solutions to achieve competitive advantage, and enhanced choices of platform and deployment options that enable companies to run their business their way.

 

Start with the blog, then drill down into detail information on LearnJDE>New Releases and Initiatives.

 

What JD Edwards Experts are Telling Customers About Release 9.2

In interviews with Quest’s Q&A Magazine, JD Edwards product experts explain some of the new products and features available to customers in the Applications and Tools 9.2 releases.

Robert Monahan, Vice President of Product Management, discusses how the new releases give customers innovative ways to transform their businesses and realize competitive advantages.

Internet-connected devices and their roles in scenarios for gaining competitive advantage are the topics of the interview with Angela Enyeart, Product Management Director, and Keith Sholes, Product Management director. Gain a better understanding of the range of opportunities these devices, together with JD Edwards software, offer to customers.


Tech Spotlight: Installation and Upgrade

The installation and upgrade process for 9.2 is significantly different from what is was in previous releases.

Find detailed install and upgrade information on LearnJDE > New Releases and Initiatives > Installation and Upgrade 9.2. This overview highlights the install/upgrade differences between 9.2 and 9.1.

For every step in the install and upgrade process for 9.2, the Installation and Upgrade 9.2 information provides links to the associated documentation.


Note. Take advantage of a series of new upgrade workshops.

An important innovation for 9.2 is the Simplified Upgrade process. Read about it here.

 

LearnJDE – Content Central for JD Edwards EnterpriseOne 9.2

Join the crowd of LearnJDE users! Yep, it’s a crowd – we have had thousands of hits on the New Releases and Initiatives section of LearnJDE since release 9.2 became generally available on October 6, 2015.

The information in New Releases and Initiatives will answer key questions about new features, technology, and upgrade processes, and help prevent issues before they occur. 

It's that time of year again for year-end processing (W2, T4, etc.).  The Year-End ESUs for US and CA 2015 Year-End processing are available.

 

ESU Info:

2015 Year End Electronic Software Update (ESU) Information for US (W-2s) and Canadian (T4s) (Doc ID 743162.1)


All year-end information is available on the Information Center: Payroll Year End Processing in the JD Edwards EnterpriseOne US, Canadian and Australia/New Zealand Payroll Products (Doc ID 1377566.2).

On November 10, 2015, JD Edwards EnterpriseOne announces the availability of Phase 1 of the ACA Health Coverage Information Returns for releases 9.0 and later.  ACA Health Coverage Information Returns support new employer reporting requirements under the Affordable Care Act health care law.  Under the Affordable Care Act, applicable large employers – those with 50 or more full-time employees, including fulltime equivalent employees – are required to take some new actions. These employers must file information returns with the IRS and also provide statements to full-time employees about health coverage the employer offered or to show the employer didn’t offer coverage.  All applicable large employers are required to report health coverage information for the first time in early 2016 for calendar year 2015.


Refer to Oracle JD Edwards EnterpriseOne Announces ACA Health Coverage Information Returns – Phase 1 Availability (Doc ID 2076180.1) for ESU information.

Competency Management within the JD Edwards EnterpriseOne Human Resources module will allow you to feel confident that your organization is competent.

 

Competency Management is defined as a method of categorizing and tracking the qualifications that employees possess that make them competent to perform their job duties.


There are two types of competencies:

  • Employee
  • Job


Employee competencies pertain to skills, education, languages, certifications, licenses and training, etc.  While job competencies are more broad and can consist of communication, accounting, safety, training and much more.


The benefits of utilizing competency management are:

  • Provide clear, detailed expectations for employees
  • Illustrate how each employee fits into the organization
  • Create a searchable database
  • Job requirements are consistent within organizational levels
  • Assess employee performance compared to job requirements
  • Assist in creating the employees career goals and objectives


To learn more about JD Edwards EnterpriseOne Competency Management Fundamentals, refer to the Advisor Webcast:  Competency Management Fundamentals.  By accessing the link for the webcast information you can obtain the power point presentation as well as the recorded session.

Do you have an invoice or voucher batch that should have posted, but it did not complete?  Posting issues could be caused by many reasons but there are several things to look for when determining if you can use the built in functionality to assist you in being able to finish posting your batch.

After entering a Manual Billing (P1511) batch or running Recurring Billing Generation (R15100) and processing the batch, you may find that the  Post Invoice/Voucher (R15199) did not fully post the batch.  At this point it is necessary to determine the issue.  Check to see if there is a message in the Employee Workcenter or a message on the Post (R09801E) report. Verify which records in the batch may have posted, Real Estate  (F1511B) will have a D in the posted field if the records are posted, the F03B11 will also have a D and the F0911 will have a P. At this time, if the F1511B is posted and the F03B11 and F0911 are not posted, there are two built-in functionalities in JDE EnterpriseOne that may help you resolve the issue and either delete or post the batch.

The available built-in functionality to you assist this situation includes:

  1. Running  RE Post Invoice or RE Post Vouchers (R15199) with setting Processing Option 2 set to include posted records.
  2. Batch Delete (R15806) to start over with the batch

If the F1511B is posted and the F03B11 and/or the F0911 are partially posted, it is necessary for more advanced troubleshooting. At this point please refer to the following KM article:

  • How to Correct a Partially Posted Batch in Real Estate Management (Doc ID 636580.1)

Is your fiscal year-end is fast approaching? If so, you might want to review information pertinent to encumbrance/commitment accounting as it pertains to JD Edwards EnterpriseOne.

 

An encumbrance accounting system allows you to reserve budgeted funds for outstanding obligations. In EnterpriseOne Procurement, an encumbrance is represented by an open purchase order or contract. Since funds are typically expended on a fiscal year basis, an encumbrance should be relieved in the same fiscal year in which it was encumbered.

 

The terms commitment and encumbrance are interchangeable in EnterpriseOne Procurement applications. The term commitment is typically used for non-stock purchasing or managing contracts. The term encumbrance is typically used in conjunction with services and expense based purchasing.

 

The system tracks encumbrances and actual amounts logged against each pertinent account number for the fiscal year to determine the remaining budget available.

 

Encumbrances versus Actual Amounts - points to remember:

  • An encumbered expense is one that pertains to an ‘open’ purchase order. Encumbered amounts are tracked in the Account Balances file (F0902) using ledger type PA.
  • An actual expense is one that represents an actual cost incurred. Actual amounts are tracked in the F0902 using ledger type AA.
  • An encumbered amount becomes an actual amount when a purchase order is either:
    • Received via the Enter Receipts By Item or Enter Receipts by Order application (P4312) then Matched to the receipt(s) using the Voucher Match to Open Receipts application (P0411/P4314) using a 3-way match.  The resulting voucher batch, batch type V, is posted.
    • Matched to the purchase order using the Voucher Match to Open Receipts application (P0411/P4314) via a 2-way match. The resulting voucher batch, batch type V, is posted.

 

Encumbrance dates to remember:

  • An expense is encumbered as of the G/L Date entered on the purchase order detail line (F4311).
  • An encumbrance is relieved as of the G/L Date assigned to the journal entries created by P4312 or P4314 or as of the date the purchase order is cancelled.

 

The cancel date for a purchase order line is recognized as the date the cancellation occurs. However, the cancel date is not maintained in any file. If you run the repost, the commitment date is used as the cancel date.

 

For an outline of process flows for Two-Way Match for Commitments and Encumbrances, Three-Way Match for Commitments and Encumbrances and Purge/Rebuild/Repost see Commitment/Encumbrance Best Practices (Doc ID 646593.1)

 

When troubleshooting issues related to encumbrances and/or commitments, it is always beneficial to ensure the most up-to-date objects for the related processes are installed in your environment.  See Change Assistant Pre-Defined Query For Encumbrance / Commitment Objects (Doc ID 1945124.1).

 

If encumbrance amounts display incorrectly in Encumbrance Inquiry (P40230A) or Budget Comparison (P09210A), review Checklist for Troubleshooting Commitment/Encumbrance Integrity Issues (Doc ID 657403.1).

 

At fiscal year-end you must either close or rollover all open purchase orders to the next fiscal year. The Encumbrance Rollover program (R4317) is an automated batch process you can use to:

  • Cancel all open purchase order lines in the prior year.
  • Roll over open purchase order lines and amounts from the prior fiscal year to the new year.

 

For information about R4317, please see Encumbrance Rollover (R4317) (Doc ID 625473.1).

Do you have preset trade-in values for certain products but the customer doesn't always have a trade-in when they order the product? 

 

You can maintain two adjustment schedules where one excludes the trade-in allowance and the other includes the trade-in allowance. When an order is entered for an item that is eligible for a trade-in allowance, the schedule that excludes the trade-in allowance will default in, but if the sales person entering the order determines the client has a trade-in, they can change the adjustment schedule that defaults on the line to pull in the trade-in allowance.

 

Review the our knowledge document How to Retrieve a Trade-in Allowance Using a Second Adjustment Schedule (Doc ID 2061768.1) for the setup and processing of the two allowances.

Pre-printed forms for ACA 1095-C reporting will not be supported.  Both JD Edwards World and EnterpriseOne are taking advantage of creating the 1095-C forms by using existing embedded BI Publisher functionality.

 

If you are unfamiliar with BIP, now is the time to prepare. Please refer to Important Information Regarding Printing Health Coverage Information Returns and Oracle BI Publisher (Doc ID 2065467.1)

 

Also, the following documents can assist in getting familiar with BIP.

 

  • Setting Up the Embedded BI Publisher Solution for JD Edwards EnterpriseOne (Doc ID 1148227.1)
  • Embeded BI Publisher Phase 1 and 2 ESUs (Doc ID 649178.1)
  • BI Publisher for JD Edwards EnterpriseOne (Doc ID 789074.1)

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.