General Ledger

The Insight General Ledger SmartViews™ are designed to create great looking financial reports in minutes, with full drill down to transactions. Each SmartView is capable of aggregating vast quantities of data into meaningful management information at incredible speeds, including live actual versus budget variance analysis. Real time ad hoc inquiry can also be performed, providing immediate answers to the most complex financial questions.

SmartViews™ Include:

• Summary Balances
• GL Transactions
• 52 Week Accounting

Accounts Receivable

Improve cash collections and drive predictable cash-flow forecasting with the Accounts Receivable SmartSet™.  The SmartViews™ in this series are capable of doing everything: From DSO analysis; on-the-fly aged debt reporting; invoice and receipt matching; instant profiling of customer activity; and payment patterns using “as of” reporting. Finally, view important KPIs, such as “percent paid late,” number of voids or write-offs, and receipts processed per day.

SmartViews™ Include:

• Receipts
• Integrated Invoices and Receipts
• "As of" Integrated Invoices and Receipts

Accounts Payable

Maximizing available discounts, reducing late fees and quickly spotting overpayments are just a few of the benefits of using the Accounts Payable SmartSet™. Match invoice and payments on a single SmartView™ or consolidate AP activity data across the enterprise to identify opportunities to negotiate better deals and favorable discounts. Alternatively, perform live aging of payments by group vendor invoices in real-time in a manner that’s not possible in JD Edwards.

SmartViews™ Include:

• Summary Balances
• GL Transactions
• 52 Week Accounting

Fixed Assets

Fixed asset schedules for huge asset volumes can be run in seconds with the Fixed Asset SmartSet™. Grouping and viewing assets by project, business unit, category code, and parent/child is easy. This also includes the ability to drill-down to instantly scrutinize the asset transactions, including depreciation, transfers, splits and disposals. Determine which assets are underutilized that could be transferred or scrapped with integration into other manufacturing, inventory and project SmartViews™.

SmartViews™ Include:

• Fixed Asset Balances
• GL Transactions
• FA Supplemental Data

Budgeting & Forecasting

The Insight Budgeting & Forecasting SmartSet™ works directly with the JD Edwards data using the Insight Budgeting workflow technology. Each SmartView™ dynamically transforms to control what each person can view, input and approve. Once finalized, the results can be uploaded back into the JD Edwards system, and used symbiotically with other financial SmartViews™ to perform “actual versus budget” reporting and to make budget revisions.

Advanced Cost Accounting

The Advanced Cost Accounting SmartSet™ gives instant access to revenue, cost and activity data in a single view with full drill-down. Immediately see which markets, product lines, and customers are having positive and negative effects on your bottom line. This can be done by using real-time trend charts, ranking analysis and consolidated reports. Compare multiple cost allocation models to improve profit margins and activity-based costing to highlight key costs affecting your net income.

SmartViews™ Include:

• ACA Balances
• Cost Assignments
• GL Transactions

Tax

Run flexible, customized inquiries over any aspect of the JD Edwards tax information with the Tax SmartSet™. Reduce tax penalties due to late or incorrect sales tax returns. Easily perform real-time consolidations by GL date range, cost center, project, tax authority and customer. Highlight issues such as missing or inconsistent tax amounts with drill-down to originating transactions for further detail.

SmartViews™ Include:

• Tax Detail
• Summary Taxes

Currency Restatement

Perform instant currency restatements into any currency in real-time using the Currency Restatement SmartSet™. Utilizing the native JD Edwards currency rate data, this collection of SmartViews™ perform live calculations to derive unrealized exchange gains and losses, and produce re-stated financial statements on-the-fly. Not only do they improve the accuracy of reporting but also they reduce the number of foreign currency transactions held in JD Edwards.

Inventory

Improve inventory turns and material usage with the Inventory SmartSet™. Analyze last-in, purchase and standard cost to predict cost variances and take corrective action. Quickly summarize by “cost type” and determine the availability and valuation of inventory. Highlight quantity and cost variances, view “on-hand versus available inventory,” discover the impact of obsolete inventory, monitor monthly average inventory turns, and more.

Templates Include:

• "As of" Balances
• Inventory Cycle Count
• Item Balance Summary

Sales

Proactively manage orders and backlogs with the Sales SmartSet™.  Consolidate by business unit, territory or product family to gain holistic views into which customers and products are driving revenue and margins. Scrutinize customer revenue, ordering habits and payment history to align buying behavior with optimal payment terms. Use graphical SmartViews™ to monitor and trend key sales indicators to spot and drill-down on exceptions.

Templates Include:

• Sales Detail
• Transportation
• Sales Ledger

Purchasing

The Purchasing SmartSet™ helps establish favorable vendor relationships and improved discounting through better visibility of purchasing information. Compare supplier cost and performance, displaying early, late or on-time delivery percentages that can be used to re-allocate orders to preferred suppliers. Easily track “days between” orders and receipts to indentify lead-time trends. Quickly perform Received Not Vouchered reconciliations.

Templates Include:

• Stock Purchase Orders
• Received Not Vouchered
• Receipt Routing Ledger

Warehouse Management

JDE Warehouse Management is an integral part of the manufacturing and distribution processes. It works together with inventory and manufacturing modules to manage inventory items and the products that companies produce and ship. Some sample reports include: Warehouse Inventory, Inventory Replenishment, Picked Inventory Listing, Storage Information, and Location Setup.

Templates Include:

• Item UOM
• Location Detail
• Warehouse Requests
• Warehouse Suggestions

Manufacturing

Optimize your entire manufacturing process from product definition and costing, through work order and capacity management, to cost and variance analysis with the Manufacturing SmartSet™. Improve shop floor scheduling with real-time graphical analysis of work order schedules and work center capacity. Drill-down in real-time to Bills of Materials, work orders, item master, and item availability for rapid identification of raw material usage and availability issues.

SmartViews™ Include:

• PDM Bill of Material
• PDM Cost Components
• Work Order Parts List

Manufacturing Resource Planning

Use the MRP SmartSet™ to assess the impact of upcoming demands as well as monitoring current and future supply. Highlight issues that are out of sync with forecast parameters, such as items on backlog due for upcoming production. Use graphical SmartViews™ to evaluate trends and resolve capacity constraints in real-time. Improve organization-wide visibility of MPS, MRD, DRP and CRP with summary level SmartViews™ that provide a quick snapshot of the business operations.

SmartViews™ Include:

• Forecast Detail
• PDM Routing
• Vendor Schedule Commitments

Purchasing

The Purchasing SmartSet™ helps establish favorable vendor relationships and improved discounting through better visibility of purchasing information. Compare supplier cost and performance, displaying early, late or on-time delivery percentages that can be used to re-allocate orders to preferred suppliers. Easily track “days between” orders and receipts to indentify lead-time trends. Quickly perform Received Not Vouchered reconciliations.

SmartViews™ Include:

• Stock Purchase Orders
• Received Not Vouchered
• Receipt Routing Ledger

Inventory

Improve inventory turns and material usage with the Inventory SmartSet™. Analyze last-in, purchase and standard cost to predict cost variances and take corrective action. Quickly summarize by cost type and determine the availability and valuation of inventory. Highlight quantity and cost variances, view on-hand versus available inventory, discover the impact of obsolete inventory, monitor monthly average inventory turns, and more.

SmartViews™ Include:

• "As of" Balances
• Inventory Cycle Count
• Item Balance Summary

Sales

Proactively manage orders and backlogs with the Sales SmartSet™.  Consolidate by business unit, territory or product family to gain holistic views into which customers and products are driving revenue and margins. Scrutinize customer revenue, ordering habits and payment history to align buying behavior with optimal payment terms. Use graphical SmartViews™ to monitor and trend key sales indicators to spot and drill down on exceptions.

SmartViews™ Include:

• Sales Detail
• Transportation
• Sales Ledger

Human Resources

Benefit from on-demand EEO, FLSA, headcount and turnover reporting with the Human Resource SmartSet™.  Combine aggregated employee details and counts by ethnic group, benefit group, supervisor and DBO for up-to-the-minute analysis. View and analyze employee enrollments by plan ID, provider/trustee, benefit group, and others to expose data inconsistencies. See the effects of pay increases or benefit changes instantly using “what-if” analysis.

SmartViews™ Include:

• Employee Benefits
• Employee Detail
• Position Budget Detail

Payroll

The Payroll SmartSet™ offers great payroll-related content over DBA transaction detail, paycheck history, pay stub information, and more. Analyze unprocessed and processed time cards to expose miscoding budget overruns. Drill-down from payroll transactions to supporting GL entries. View both employee and employer tax records for multiple tax types in a single SmartView™. Pivot DBA codes for immediate access to available vacation and sick time information.

SmartViews™ Include:

• Pay Check DBA History
• Payroll History
• Canadian Taxes by Period

Time Sheet

Analyze labor hours, rates, expenses and billings with the Time Sheet SmartSet™. Review timecard information by job, batch or practically any other dimension in the Employee Master or Employee Transaction Detail file. Analyze trends, perform “what-if” analysis or manage exceptions. Perform ad-hoc inquiries over labor, recharge and equipment time and drill-down to the supporting GL entries in summary and detail.

SmartViews™ Include:

• Current Detail
• History GL Transactions
• Integrated Detail

Job Cost

Empower project managers to run their business with less reliance on Finance or IT with the Job Cost SmartSet™. Run fast Job Cost schedules that aggregate live project information in a single SmartView™.   Drill-down to related GL, payroll, sub-contracts, and contract billing transactions in other SmartViews™. Analyze ongoing job performance by project, manager or region. Benefit from exception-based analysis over important attributes like schedule delays and commitment costs.

SmartViews™ Include:

• Summary Balances
• GL Transactions
• Profit Recognition

Capital Asset Management

Improve repair schedule predictions to ensure optimal part supply and labor levels with the Capital Asset Management SmartSet™. Within a single SmartView™, see maintenance, cycle definitions, statuses and service drivers. See visual representations of service schedules and capacity dynamically update as requirements change. Analyze equipment usage and maintenance metrics to help drive improved equipment uptime.

SmartViews™ Include:

• Asset Balances
• Equipment Part List
• Work Order Labor Details

Contract & Service Billing

Improving cash flow by decreasing Days Billings Outstanding.  Increase profitability by identifying potential contract and billing issues before they are invoiced.  These are just two benefits of using the Contract and Service Billing SmartSet™. Highlight variances, exceptions and overages for time and material costs, schedule of values and margins. Analyze historical contract performance to highlight items that affect profit margins for ongoing improvement to contract definitions.

SmartViews™ Include:

• Contract Detail
• Integrated Service Billing
• Invoice Summary

Homebuilder Sales

The Homebuilder Sales SmartSet™ transforms sales, lot, and option data into actionable management information.  Aggregate cost information by option and plan across multiple communities to uncover opportunities for increasing overall profit margins. Analyze performance by community, area, manager, plan or any other indicator. Summarize lot counts at the community of area level. The simple interface to these powerful SmartViews™ is a must for all homebuilders.

SmartViews™ Include:

• Lot Master
• Lot Proceed Detail
• Sales Summary

Property Management

For real estate companies, the Property Management SmartSet™ just hits the mark. Compare and contrast the most profitable properties and tenant types. Understand which properties and tenants provide the best cash flow.  Monitor billing status and payment history in meaningful ways such as by tenant, property or lease manager. Reduce errors and improve tenant relationships with more accurate billings by eliminating missing lease headers, incomplete lease information or mistakes in expense allocations.

SmartViews™ Include:

• Lease Billings Master
• Occupancy Details
• Tenant Logs

CRM

The Customer Relationship Management SmartSet™ provides users with a real time view into their organization's sales cycle. Instantly view information about leads, prospects, opportunities, activities, and qualification information. Review the details of a lead or opportunity, then drill down to see the planned and actual activities that have taken place as part of the effort to close the business. Gain a better understanding of what the sales force is doing, and how your processes can be improved.

SmartViews™ Include:

• Activities
• Lead Qualification
• Opportunity Cost

Service Management

Use the Service Management SmartSet™ to gain real-time visibility into the customer install base, as well as the maintenance schedules, cases, and work orders associated with them.  Get immediate information about the status of installed equipment and plan for upcoming maintenance. Analyze the problems being experienced with equipment and gain understanding of how to reduce those problems in the future.

SmartViews™ Include:

• Contract Master
• Equipment Parts List
• Work Order Labor Details

Month-End Close

Speeding up the month-end close is the primary goal of this SmartSet™. The real-time, interactive nature of the SmartViews™ ensures that data integrity and reconciliation issues are quickly spotted and resolved. Equally, being able to provide instant flash reports to the business means decision-makers get reports before the close so any exceptions can be addressed much faster. The ad-hoc inquiry provides immediate answers to issues that always seem to appear during the close and, of course, a comprehensive management reporting capability to produce great-looking report packs.

Order-to-Cash

An effective sales order process delivers lower order processing costs, better customer service and improved cash flow for better receivables management. The Order-to-Cash SmartSet™ is designed to achieve exactly that: Everything from managing the order, its fulfillment, inventory availability, invoicing, revenue collection, and General Ledger integrity. This is all optimized through a series of integrated SmartViews™ to create a single seamless view of this essential business operation.

Employee Lifecycle

Data management and validation is a significant component of the Employee Lifecycle SmartSet™. Online exception reports quickly validate benefit setup, employee enrollment, time entry information, and more. By proactively maintaining clean data, everything from processing the payroll to W2 production is streamlined, resulting in shorter processing times and happier employees. Use powerful analysis tools to provide real-time summary and detailed views of employee payments, benefit accruals, employer and employee tax allocations and payments. Truly understand the drivers of employee turnover to improve hiring and retention practices.

Supplier Management

The Supplier Management SmartSet™ helps to continually improve supplier performance, enabling ongoing operational efficiency and lower costs. High-level history reports identify the key metrics needed to drive supplier performance. Real-time visibility of receipt metrics allows for better identification and management of receipt variances. Live monitoring of critical purchase order parameters means issues can be resolved as they occur, rather than waiting for the end of the month. Finally, SmartViews™ identify in-process variances in cost, delivery, and quality before they become bigger problems.

Procure-to-Pay

Delivering lower costs, driving better supplier performance, implementing more efficient payment processing, and greater discounts from on-time payments are just a few of the benefits of using the Procure-to-Pay SmartSet™. Benefit from real-time analysis of requisition and quote information to better manage the requisition process in less time. Get immediate visibility of incomplete orders, availability issues, and item ledger inconsistencies that can save big dollars and hundreds of hours of time. See critical supplier performance data to select the right supplier for the right products. Optimize the payables process to benefit from bigger discounts and reduced payment processing costs.

Forecast-to-Make

Some of the most challenging areas in manufacturing are effective MRP, scheduling, capacity - as well as cost and variance accounting. Gain control of your manufacturing costs with this online SmartSet™ that provides critical information throughout your manufacturing process. Easily navigate online from "where-used" to BOM tree structure to supporting routings - gaining immediate understanding of PDM information. Slice-and-dice product costing information, optimize demand forecasting using elegant graphical views, and unlock key material and capacity information to maximize efficiency to reduce overall costs. Proactively uncover issues, such as late completions, scrap, incorrect statuses, and "data keying" errors before they are posted to the GL. This includes the ability to identify cost variances and time entry problems.

Lean Accounting

Lean principles continue to transform accounting practices. This optimized “Lean” Accounting SmartSet™ provides meaningful methods for improving growth and profits. First, new insights can be gained by looking at your operations from parallel perspectives – such as value streams. Second, profitability can be greatly improved through better management of sales and inventory. Finally, education of your workforce through tools – like balanced management scorecards – can drive your business to greater expansion and success.

Order-to-Ship

Optimized inventory means having the right products on hand to fulfill orders, without stocking unnecessary products that tie-up valuable cash. The Order-to-Ship SmartSet™ provides online tools to monitor and maximize inventory turns, reduce waste, and improve customer service - thereby improving overall profitability. Quickly view availability of multiple items across multiple branch plants, in a single view, for rapid customer response and improved inventory management. Predict and adjust for backordered stock, late-ships, and short-ships - improving customer service levels. Predicatively identify issues effecting shipment for in-process resolution and improved customer response.

Capital Asset Management

Optimized equipment maintenance processing shortens cycle times, improves scheduling and labor consumption, and significantly lowers overall cost. The Capital Asset Management SmartSet™ delivers end-to-end visibility to critical areas for continuous improvement and immediate cost reduction. Proactively validate equipment master data, improve repair schedule prediction to ensure optimal part supply and labor levels. Optimize preventative maintenance with real-time monitoring of usage metrics. Determine immediate schedule and capacity impact of service order with easy-to-use graphical views and more.

Real Estate

The real estate industry SmartSet™ is geared to improving how real estate companies can resolve key JD Edwards reporting and business process issues. With detailed analysis by tenants, properties, buildings, lease types, lease status and more, this SmartSet™ covers all areas of finance, including Tenant AR. Development companies can also benefit from project-centric content such as Job Costing.

SmartViews™ Include:

• GL Summary Balances
• Live Tenant Invoices and Receipts
• Job Status Inquiry

Construction & Engineering

More than ever, construction and engineering companies must manage costs and control margins. The Construction and Engineering SmartSet™ help achieve exactly that: It offers the most comprehensive collection of SmartViews™ available.  It covers all construction and engineering activity, including project management, finance, human capital management, and asset lifecycle. Real-time visibility of key project parameters such as Job Cost, commitments, subcontractor performance, and service billing are just some of the benefits of this industry-leading solution.

SmartViews™ Include:

• Profit Recognition
• Integrated Service Billing
• Employee Detail

Homebuilder

Homebuilders are able to benefit from a SmartSet™ that’s been specifically designed for the unique inquiry, consolidation and reporting needs of the industry. Access vital homebuilder sales data by area, community, lots, as well as design center option information. Perform job cost and accounts payable analysis, produce elegant management reporting packs from the General Ledger, and so much more.

SmartViews™ Include:

• Homebuilder Option Analysis
• Homebuilder Sales Summary and Detail
• Lot Master Reporting

Inventory

The Inventory SetSmart™ contains SmartViews™ that can quickly reconcile the inventory data from JD Edwards World and EnterpriseOne to the General Ledger. A drill-down feature can access the underlying journal entries and Cardex information. Each SmartView™ can be configured to display all or just some of the information from the GL Account Ledger and Cardex files. For manufacturing companies, summarized journal entries for a manufacturing process (finished goods inventory, raw material inventory, and labor) using the same GL accounts can be summarized and compared to the inventory Cardex.

Received Not Vouchered / GNRI

Reconciling Received Not Vouchered/GRNI has never been easier with this great SmartSet™, which automatically matches the PO receipt and voucher amounts to the GL Account Ledger. It’s even capable of handling purchase orders and vouchers that are voided or reversed by linking in inventory receipt information. Users will be able to see orphaned transactions, as well as matching entries. An additional SmartView™ is available for the AAIs, where you can see which accounts are being used for each type of PO receipt or voucher transaction.

Accounts Payable

The Accounts Payable SmartSet™ solves problems with the JD Edwards Accounts Payable reconciliation process – automatically matching voucher and payment amounts to the GL Account Ledger amount. Instantly drill-down to the underlying journal entry, voucher and payment details, including other parts of the AP and GL information. Variances can often be the result of incorrect GL accounts being used and this can be quickly checked using the financial AAI SmartView™.

Fixed Assets

The Fixed Asset SmartSet™ summarizes GL Balances, GL Transactions and Fixed Asset Balances all into a single, unified SmartView™. This allows the user to see all the GL activity in asset accounts and identify how these transactions have been represented in the Fixed Assets system. View all or only those accounts (or assets) that have variances in the current month or for any period in the past. The SmartSet™ allows you to see all of this information by detailed journal entry line item, asset number, or summarization. Also, highlight the GL entries that were intentionally skipped in the Fixed Assets system.

Accounts Receivable

For Accounts Receivable, the AR SmartSet™ automatically matches invoice and receipt amounts to the GL Account Ledger amount. Users of JD Edwards World and EnterpriseOne can use Reconciler to see orphaned transactions in both AR and the GL. These are immediately highlighted together with matching entries that contain variances. By using Reconciler’s drill-down feature, journal entry, invoice and receipt details are shown side-by-side to explain the issues. A SmartView™ provides access to all the financial AAIs to see if something in their setup is causing reconciliation issues.

Payroll

Reconciling Payroll to the General Ledger is now easier and more reliable with this reconciliation template. It integrates Payroll information (F0618 and F06116) and GL Transactions (F0911) to determine variances for T2 documents and identify reconciling items. A GL audit can also be done for other payroll document types.

General Ledger

The Insight General Ledger templates provide Oracle users with the ability to create fantastic summary or detailed reports in minutes with full drill down through chart of accounts hierarchies and onwards to the supporting transactions. Reports can be run for individual companies, departments or cost centres, any combination of these, or, across multiple sets of books or ledgers. Massive amounts of data can be aggregated into statutory report layouts, budget monitoring or ad hoc inquiries at incredible speeds. Templates are available for both 11i and R12.

Templates Include:

• GL Balances
• GL Transactions

Accounts Receivable

The Accounts Receivable SmartSet™ brings together transaction analysis, customer balances and aged debt into a series of templates.  Invoice and receipt information is brought together to rapidly identify not only activity and payment patterns by customer but also by GL segment. Instant analysis of aged debt can be performed across the entire organization, for departments, cost centres or groups of customers. Accounts Receivable managers can monitor activity, process performance and master data to optimise efficiency of the Accounts Receivable function through a range of templates which report on customer master data, receivables activities and collections.

Templates Include:

• Invoices and Receipts
• Aged Debt by GL Segment
• Invoice Details
• Invoice Distributions
• Receipts and Applications
• Customer Accounts
• Activities
• Notes
• Collections R12

Accounts Payable

Identifying opportunities to negotiate better deals by analyzing top suppliers and areas of spend becomes incredibly easy using the Accounts Payable SmartSet™. Alternatively easily identify duplicate or over payments, view transaction currencies or analyse tax by matching invoices and payments on a single template. The performance of the Accounts Payable department can also be rapidly monitored by running ad hoc inquiries to view late payments, aged invoices and discounts taken.

Templates Include:

• Invoices and Payments
• Checks
• Aged AP
• Expenses
• Procurement Cards
• Payments
• Supplier Master data

Fixed Assets

Analyze assets by book, categories, ownership, age, and many other groupings in the Fixed Asset SmartSet™.  Understanding Net Book Values and depreciation costs becomes easy for high volumes of assets with drill down to the asset and subledger transactions to scrutinize additions or depreciation charges.

Templates Include:

• Asset Listing
• Depreciation Details
• Net Book Value Schedule
• Asset Transactions

Project Accounting

Using the Projects SmartSet™ analyse profitability, expenditure and revenue across projects for the entire enterprise in just a few minutes. Alternatively group projects by type, categories, manager, customer or classification codes at the project or task level with drill down to the transaction details in functional or entered currencies. Actuals, budgets and commitments are easily compared to ensure projects are on track.

Templates Include:

• Project Profitability
• Project Expenditure
• Project Revenue
• Project Commitments

Purchasing

The Purchasing SmartSet™ provides instant access to purchasing activity and compliance in a single view with full drill down. Immediately improve negotiation capability through visibility of spend by supplier and item categories across the organization. Help enforce compliant behavior by monitoring invoices without purchase orders, invoices with post approved orders, or those without matching delivery information. Identify bottlenecks in the process by comparing creation and approval dates using days between functionality.

Templates Include:

• Purchase Orders
• Requisitions
• Matching