Skip navigation

Several new enhancements have been released for the EnterpriseOne financial modules.

 

FASB/Revenue Recognition: Allow customers to comply with the FASB/Revenue Recognition standard.  These enhancements are in addition to the previously delivered Revenue Recognition enhancements.  Accounts Receivable customers will now be able to:

  • Utilize a batch process to recognize all the review for an invoice
  • Recognize less, more, or none of the revenue for an invoice
  • Remove an invoice from the recognition process
  • Reverse a previous recognition
  • Run integrity reports over the recognition data

 

More information can be found in knowledge document: E1:03B: New Enhancement Release 9.1 and 9.2 – FASB/Revenue Recognition (Doc ID 2165868.1)

 

Expense Management: Two new enhancement were added to allow entering summary expense reports and enter credit card expenses for both tablet and smartphone:

 

  • Entering a Summary Expense Using the Mobile Expense Entry
    • You enter a summary receipt expense when you have multiple expense items on a single receipt. For example, while on a business trip, you might receive a single bill from your hotel that includes charges for your lodging and several meals. You use the summary expense process to enter these types of expenses on an expense report.
  • Entering Credit Card Expenses Using the Mobile Expense Entry
    • If your organization is set up to enable you to automatically include expenses from your credit card(s) on your expense report, you can view and select credit card expenses to add to your expense report.

 

More information can be found in knowledge document: E1: 09E: New Enhancement As Of Release 9.2 – Enter Summary Expense Reports and Enter Credit Card Expenses (Doc ID 2165589.1)

 

Accounts Receivable: Allow zero or negative value receipts to be included in the automatic receipts process in order to resolve the following issues:

  • To clear a credit memo with a negative value receipt.
  • To match a negative or zero value receipt to several invoices and credit memos that add up to a negative or zero amount.
  • To clear a zero dollar invoice with a zero value receipt.

 

More information can be found in knowledge document: E1: 03B: New Enhancement As Of Release 9.2 – Process Negative Receipts Using Automatic Receipts (R03B50) (Doc ID 2165328.1)

Do you collect Security Deposits for your leases, keys, utility or any variety of options?  Did you know that JD Edwards EnterpriseOne Real Estate Management can assist you with maintaining and recording this information as well as refunding the full or partial deposit when the time comes to return the monies to the tenant?

 

The Security Deposit requirements can be entered in Security Deposit Maintenance (P1565).  It is also possible to create an invoice if necessary for the customer to submit this deposit.  This invoice will not be created in Accounts Receivable. 

 

The actual security deposit is entered in RE Cash Receipts (P15103) with a Bill code associated with Security Deposits. 

 

The Security Deposits Required vs. Received report can be run to verify all required deposits have been received or which are still pending.

 

When ready to refund the deposit, there are a number of options.  It can be refunded in full or partially depending on the processing options of the Security Deposit Refund Application (R15654).  This means there is an option to refund only a portion of the deposit if there are open invoices that a portion of this balance needs to be applied to.

 

It is necessary to use RE Cash Receipts to apply this balance to the open invoices.

 

How to Manage Security Deposits in Real Estate Management (Doc ID 1469834.1) provides more detailed instructions on how to use this functionality.

Financial Integrity reports are an integral part of the JD Edwards EnterpriseOne General Accounting system. Running integrity reports helps you: 

  • To supplement your internal balancing procedures. 
  • To locate potential balancing problems and data inconsistencies. 
  • Ensure that your system functions correctly and that tables remain in balance. 
  • Enables you to correct any problems in a timely and efficient manner. 

 

You should run integrity reports at these times: 

  • During new Software Installation. 
  • During Data Conversion. 
  • Daily, if necessary. 
  • At the end of the fiscal period. 
  • At the end of the fiscal year.

 

The more often you run integrity reports, the easier it is to determine when a problem occurred. Consequently, this provides huge benefits to business, reduces downtime and assists with growing audit, compliance and regulatory pressures.

 

The General Accounting Integrity Reports can be classified into four categories: 

  • Batch Header Reports - Identify discrepancies between the Batch Control Records table (F0011) and the Account Ledger (F0911) table. 
  • Out-of-Balance Reports - Identify whether transactions within a company are in balance, whether Accounts Balance (F0902) match with Account Ledger (F0911) on a period-by-period basis and if Intercompany settlement accounts are in balance. 
  • Chart of Account Reports – Locate inconsistencies within chart of accounts. 
  • Multicurrency – Identify discrepancies within Foreign Account Balances (F0902).

 

 

For more information on how to run and troubleshoot the General Accounting Integrities, you may refer to  How To Troubleshoot EnterpriseOne General Ledger Integrity Issues (Doc ID 1541001.1).

Farahd -Oracle

Manual Reconciliation

Posted by Farahd -Oracle Mar 2, 2016

Bank accounts, selected expense accounts, and other general ledger accounts in the General Accounting system can be reconcile by the system. After performing the initial setup requirements, the accounts can easily reconcile on a periodic basis.

 

Manual reconciling of the accounts consists of the following steps:

  • Reconciling voided payment or receipts with zero amounts automatically (optional).
  • Creating or refreshing the reconciliations worktable for unreconciled transactions.
  • Performing the manual reconciliation for bank accounts, transit accounts, or clearing accounts.

 

Instead of manually reconcile voided payments and receipts, time can be save during the account reconciliation by running a program to automatically reconcile voided payments and those with zero amounts. The system selects payments that were voided manually or during automatic payment processing.

 

The Auto Reconcile Void Payment Program and Auto Reconcile Void Receipts marks voided payments and receipts as reconciled and updates the Account Ledger table (F0911). The program should be run before the Refresh Reconciliation File program to create the reconciliation worktable so that zero- amount and voided payments are not included in the worktable.

 

The Refresh Reconciliation program copies the unreconcile transaction detail from all reconcilable accounts from the Account Ledger table (F0911) into the Account Ledger Reconciliation worktable (F0911R).

 

Each time a new reconciliations worktable is created, the system removes all previous reconciled in the table and replaces them with new transactions that were entered since the last table was created.

 

When the reconciliation is completed, the system updates the reconciled transactions in the Account Ledger Reconciliation worktable (F0911R) and the Account Ledger table (F0911).

 

You can read more about the manual reconciliation process in document Overview of Clearing Account Reconciliation (Doc ID 1461344.1).

JD Edwards EnterpriseOne One View Reporting is a real time operational reporting solution designed specifically for end users. An intuitive interface empowers users to access and personalize transactional data into lists, charts, graphs, and tables. With One View Reporting, users can select the data fields and perform specific data selection from within JD Edwards EnterpriseOne applications and leverage the layout capabilities within Oracle BI Publisher to define the report output formatting. It was first introduced with JD Edwards EnterpriseOne Applications release 9.1 and later it was also offered for Applications release 9.0.

 

One View Reporting enables end users to create and run One View reports based on Business Views using search criteria in applications (standard or custom Find Browse Forms) or even in Data Browser. These reports are typically specific to the user or role and are those that the user will run on a daily, weekly, or other periodic basis as part of their normal activities. With this type of report users are allowed a high degree of personalization regarding data selection, sequencing, data columns included, and data visualization (charts, tables, graphs). These end-user reports improve user productivity by providing users with better visibility into operational data as part of their standard day-to-day business process. Common use cases are customer reports, supplier reports, sales reports, and employee reports.

 

Together with the One View reporting feature a number of dedicated standard One View Applications and Reports were added for various JD Edwards EnterpriseOne modules. In Financial Management new One View Applications were added for General Accounting, Accounts Payable and Accounts Receivable. Standard One View Reports for various use cases are delivered with each One View Application.

 

General Accounting

 

  • One View G/L Inquiry (P09219). One View G/L Inquiry can be used to analyze General Ledger transactions. It is based on the One View G/L Inquiry (F0911-F0901-F0006) Business View (V09219), which includes columns from the Account Ledger table (F0911), Account Master table (F0901), and Business Unit Master table (F0006).
  • One View Account Balance Inquiry application (P09217). One View Account Balance Inquiry can be used to report on account balances. It is based on the One View Account Balance Inquiry business view (V09217), which includes columns from the Account Balance table (F0902), F0901, and F0006.

 

Accounts Receivable

 

  • One View Customer Ledger Inquiry application (P03B2022). One View Customer Ledger Inquiry uses the One View Customer Ledger Inquiry Business View (V03B11I) (which includes columns from the Customer Ledger table (F03B11) and Customer Line of Business Master table (F03012)) to analyze the Customer Ledger.
  • One View Customer Receipt/Draft Inquiry application (P03B720). One View Receipt/Draft Inquiry should be used to inquire on Receipt/Draft transactions. It is based on the One View Receipt Draft Inquiry Business View (V03B720), which includes columns from the Receipt Detail table (F03B14), Receipt Header table (F03B13), and Customer Master table (F03012).

 

Accounts Payable

 

  • One View Supplier Ledger Inquiry application (P042022). One View Supplier Ledger Inquiry can be used to analyze supplier ledger transactions. It is based on the One View Supplier Ledger Inquiry Business View (V042022), which includes columns from the Accounts Payable Ledger table (F0411), Supplier Master table (F0401), and the Address Book table (F0101).
  • One View Supplier Payment Inquiry application (P04720). One View Supplier Payment Inquiry can be used to inquire on supplier payment transactions. It is based on the One View Supplier Payment Inquiry Business View (V04720), which includes columns from the Payment Detail table (F0414), Payment Header table (F0413), F0401, and F0101.

 

Additional details about this feature can be found in the following documents:

 

  • One View Reporting for JD Edwards EnterpriseOne (Doc ID 1464568.2)
  • JD Edwards EnterpriseOne One View Reporting Now Available for 9.0 (Doc ID 1522883.1)

 

For a complete reference check the guides.

One View Financial Statement (OVFS) is a feature of JD Edwards EnterpriseOne One View Reporting for Financials. The OVFS feature enables you to select the account groupings, time frames, and balances that you want to include in your financial statements, and to format the financial statement output. This ability to design and generate financial statements frees the financial department staff from reliance on the IT department to maintain their financial statements.

 

As with other One View reports, you can generate the financial statement in a graph, table, and other formats. However, OVFS enables the financial department staff far more flexibility than relying on only the One View Reporting for Financials capabilities already provided in the JD Edwards EnterpriseOne system. For example, you can design balance sheets, income statements, statements of operations, statements of activities, variance analyses, and more. You can design financial statements to report on or analyze data in the Account Master (F0901), Account Balances (F0902), and Business Unit Master (F0006) tables.

 

For more information, please review One View Financial Reporting New Enhancement For Release 9.2 (Doc ID 2059874.1).

2015 Year-End 1099 is fast approaching!  The information below provides you with list to help you have a successful 1099 season:

  • September/October 2015
    • Get familiar with our EnterpriseOne 1099 knowledge resources (they share ALL training a new 1099 user will need).
      • Bookmark - Troubleshooting Assistant: 1099 Year End Processing (Doc ID 1594456.2)
      • Bookmark - VIP - How To Verify Supplier and Company Setup for 1099 Year End Processing [Video] (Doc ID 661098.1)
  • November 2015
    • Get ready for ESU release to come by middle of December 2015.
      • IMPORTANT!! Read 1099 Year-End ESU: Resolving 1099 Processing Errors Due to ESU Install - HowTo Obtain, Install and Verify Installation of the ESU (Doc ID 1596756.1)
        • Tip - VIP - Must do full force merge to "replace" all objects.
        • Tip - VIP - All Suppliers and Companies MUST have a Tax ID populated in Address Book for combining 1099 table builds to work properly!
  • December 2015
    • Estimated ESU Delivery (by mid December)
      • Bookmark - Important Yearly 1099 Year End Processing Bug/ESU Information For JD Edwards EnterpriseOne [Video]
  • January 2016
    • Printing your 1099s
  • February 2016
    • If you have less than 250 1099s, print 1099 to file to the I.R.S to meet deadline.
    • Note - Use electronic filing even if under 250 1099s as it saves time and office supply stock expense.
  • March 2016
    • Electronic Filing to I.R.S
  • April 2016 thru May 2016
    • Learn how to create 1099 corrections, if required.
  • Season will be complete!

Please subscribe to 2015 1099 - "Get Ready Campaign" - Live Growing Discussion for the 2015 Tax Reporting Season! community discussion and get the latest information.

In an earlier blog we discussed how you can use the Autocash functionality to save time as you can set it up to apply cash receipts to A/R invoices automatically. However,
sometimes you receive money from clients in forms that cannot be processed through your Autocash setup (and this does not happen frequently enough to add to your setup).


For these situations, where you cannot use bulk processing, you can use either of the following cash receipt entry programs:

  • Standard Receipts (P03B102)
  • Speed Receipts (P03B0001)


Regardless of which program you use to enter manual receipts, there are three steps to the process:

  1. Enter the receipt
  2. Review the receipt, and revise it if necessary
  3. Post the receipt

 

Before you can enter a receipt, make sure that the following is set up:

  • Set up these AAIs and make sure that the G/L accounts attached to them exist and can be used by the G/L Post (R09801):
    • RKD for discounts taken.
    • RCxxxx, where xxxx is the chargeback G/L offset code, for the chargeback A/R trade account.
    • RAxx, where xx is the write-off reason code.
    • RN, for the deduction suspense account.
  • Set up these UDC tables for any reason codes you want to use:
    • 00/DE for discount reason codes
    • 03B/CB for chargeback reason codes
    • 03B/RC for write-off reason codes
    • 03B/CR for deduction reason codes      

 

When you create a receipt, the system creates at least two records in the following tables:

  • A receipt header record that stores the amount of the receipt, the check number, receipt and general ledger dates, and so on. The system stores receipt header records in the Receipts Header table (F03B13).  There is only ever one record per receipt in this table.
  • A receipt detail record that stores the amount of the receipt that is applied to each invoice. The system stores receipt detail records in the Receipts Detail table (F03B14). There is one record for each invoice matched on the receipt, and one for each standalone record (write-off, deduction, or chargeback), and one for any amount left unapplied


In the receipt header there are two date fields:

      • the Receipt Date
      • the G/L Date


The Receipt Date field can be set to the date on which you enter the receipt into the system, or it can be set to the date on the customer’s check, or to the date on which the EFT payment from the customer came in, for example. However, the system does not use this date field for anything, so it is for informational purposes only.


The G/L date on the other hand is used for the following:

      • exchange rate calculations,
      • to determine whether a discount is earned, and
      • to update account information when you post the receipt. 

 

Because the system uses the general ledger date for so many reasons, you cannot change the general ledger date after you enter the receipt, even if the receipt is not
posted yet.


To apply a receipt manually to an invoice, you need to use something called a Type Input Code. This Type Input Code will automatically calculate amounts to apply for payments, discounts, write-offs, chargebacks, and deductions. The following Type Input Codes are available:

      • 10: Simple Invoice Match
      • 11: Invoice Match with Automatic Chargeback for Discount Amount
      • 15: Invoice Match with Write-Off
      • 16: Invoice Match with Chargeback
      • 17: Invoice Match with Deduction
      • 25: Stand-alone write-off
      • 26 (Stand-alone chargeback)
      • 27 (Stand-alone deduction)


There is much more to processing standard receipts than can be included, so if you need more information, please have a look at the following knowledge articles:

      • E1: 03B: How To Create and Manage Manual Receipts In EnterpriseOne Accounts Receivable (P03B102, P03B0001) (Doc ID 1451219.1)
      • E1: 03B: FAQ - Frequently Asked Questions on Accounts Receivable Manual Receipts (P03B102, P03B0001) (Doc ID 625851.1):

You use JD Edwards EnterpriseOne Contract and Service Billing to bill customers for services and goods rendered. JD Edwards Contract and Service Billing offers a suite of features to accommodate the intricacies of both interdivisional and customer billing.  Have you ever wondered which one may be more suited for your billing needs?

 

How To Understand the Difference Between Service Billing (48S) and Contract Billing (52) In EnterpriseOne (Doc ID 626871.1) helps you to decide which application or a combination of applications will work best for your billing needs.  This document gives you a comparison of the major billing processes such as Workfile Generation, Revenue Generation, Invoice Generation and Creating AR and GL Entries.  It also show the major functionality differences in setup and Invoice Generation and highlights some of the advantages and disadvantages of Service Billing and Contract Billing.

The Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) created a joint standard regarding the recognition of revenue.

 

Revenue recognition is the accounting rule that defines revenue as an inflow of assets, not necessarily cash, in exchange for goods or services. It requires the revenue to be recognized at the time, but not before, it is earned. You use revenue recognition to create G/L entries for income without generating invoices.

 

Generally, you use revenue recognition when:

  • You have finished the work and you have earned the income, but you do not need to bill a customer yet.
  • You want income statements and balance sheets to reflect the amounts earned for a realistic picture of the company's financial status.
  • You need to reallocate internal costs.
    • To calculate revenue (actual or accrued) for the current period, you must create G/L journal entries. The amounts related to these entries appear on the income statements and balance sheets when you complete the revenue recognition process. You can use the recognized revenue amounts for projections and to review the profitability or liability of specific departments in the organization.

     

More information on this new enhancement can be found in New Enhancement For FASB – Revenue Recognition in Contract Service Billing For Release 9.1 (Doc ID 2030133.1).

NewFeature.pngThe Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) created a joint standard regarding the recognition of revenue.

 

Business processes and financial standards outline when you can recognize revenue for the amounts you bill to customers. You cannot recognize revenue for billed amounts or Cost of Goods Sold (COGS) amounts associated with the billing amount until the performance obligation to the customer is satisfied.


Every company and each of their customers must agree to the terms that constitute the completion of a performance obligation. Performance obligations can be satisfied in different ways and at different times. Examples include:

 

  • Retail
    • The customer takes possession of the goods and is billed at the time of the sale. The performance obligation is complete and revenue is recognized at billing.
  • Services
    • Services are completed for a customer and they sign off on the work. The performance obligation is complete at the time the customer signs off on the work and revenue is recognized at billing.
  • Distribution
    • Goods are shipped to a customer and they are billed at the same time. The performance obligation is not complete until the customer takes possession of the goods and accepts them as complete. Therefore, you cannot recognize revenue at the time of billing.
    • The system accounts for the billing amount as a performance liability. Once the customer takes possession and accepts the goods, the revenue is recognized and the performance liability cleared. Any COGS amounts associated with the billing amount is also considered a performance liability and can only be recognized once the performance obligation is complete.
  • Construction
    • In some industries, such as construction, customers are billed for portions of the contract that are complete, or for time and materials as they occur. Revenue recognition is tied to the terms of the
      contract for each type of billing line. Some billing lines can be recognized immediately and others may be considered a performance liability until other terms have been met.

For more information, please review New Enhancement For FASB – Revenue Recognition in Accounts Receivable For Release 9.1 (Doc ID 2030115.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.