Skip navigation

Oracle_updated.png#Simplify and #Automate your #JDEdwards EnterpriseOne 9.2 experience by leveraging the latest capabilities. Learn more in this whitepaper – http://bit.ly/2wO2T0Z

LearnJDE_new.pngNow is the time to migrate from #JDEdwards World to EnterpriseOne 9.2. Visit this LearnJDE page to know everything about EnterpriseOne 9.2 - https://bit.ly/2QX0c4i

Reader.pngThis new KM document talks about purging data in Sales Order workfile tables:  Price Adjustment History Work File (F40UI74), SO Header Cache File (F42UI01), SO Detail Cache File MBF (F42UI11) and Sales Order Detail Cache 2 MBF (F42UI12). Doc ID 2637738.1. http://ora.cl/AP3wE

Reader.pngAfter updating Approval Routing codes, users are unable to edit open Purchase Orders, receiving "Invalid Approval Route Code Warning". This new KM document explains the functionality and workarounds. Doc ID 2637702.1. http://ora.cl/nV18Z 

Reader.pngThis new KM document explains where tax information (tax rate/area and tax explanation code) default from when performing a Voucher Match in P4314. Doc ID 2636625.1. http://ora.cl/Zs4eK

Reader.pngThis new KM document explains the process to create a service request for Sales Order Entry in AIS and override the Address to map the variable for the override address. Doc ID 2636567.1. http://ora.cl/km43u

As of JD Edwards EnterpriseOne Release 9.2, Oracle delivers a new functionality to determine how discounts are applied to partial payments.

 

A new processing option has been added to Known Invoice Match With Amount (R03B50D) and Known Invoice Match Without Amount (R03B50E) to determine how discounts are applied to partial payments.

 

Processing Option “Discount on Partial Payments”: Use this processing option to specify whether to apply discounts when the payment amount is less than the open amount of the invoice:

    Blank: Apply discounts for partially paid invoices. This works in conjunction with the processing option Discounts Recognition Method.

    1: Ignore discounts for partially paid invoices.

 

The new functionality is available as of JD Edwards EnterpriseOne release 9.2 and delivered via ESU. Install the latest ESU for Bug 30514617: DISCOUNTS ARE TAKEN WHEN INVOICE IS NOT PAID WHEN RUN R03B551/R03B50/R03B50D to obtain the new enhancement.

 

Please see the following Knowledge Documents for more information see New Enhancement – New Processing Option Discount on Partial Payments when Running Auto Cash (R03B50D/R03B50E) (Doc ID 2638014.1).

Forecast Consumption by Customer enhances the ability of a supplier to meet the requirements from large customers.

 

When working with large customers, you might want to consider the demand for each customer separately and plan production quantities accordingly.

 

You can set up the system to net forecasts and sales orders for a particular customer separately, so that you can plan more accurately for the specific demand coming from individual customers.

 

If you do not use the forecast consumption by customer functionality, you compare total sales with total forecast for a particular time period without considering individual customers.

 

Calculating the difference between total forecast and sales yields a different result than calculating the difference between forecast and sales for an individual customer.

 

To use forecast consumption by customer, you have to enter a forecast for a specific customer.

 

In this case, the forecast record has a customer number in the Customer Number field.

 

Based on the customer number, the system can search for sales orders with matching customer numbers in the ship-to or sold-to field to calculate the remaining demand for the customer.

 

You specify whether the system uses to the ship-to or sold-to field from the sales order by setting a processing option or by defining a customer address relationship.

 

When you run the MRP/MPS Requirements Planning program, you can set up the program to use forecast consumption by customer.

 

You can use this functionality for items that are defined with planning fence rule C, G or H. You cannot use forecast consumption logic for process items.

 

When you run the MRP/MPS Requirements Planning program and have activated the Forecast Consumption by Customer functionality, the program calculates the net difference between forecast and sales orders for a period for individual customers.

 

The process consists of these steps:

  • Check the Item Branch record for the item to see that the time fence rule is set to C, G or H.
  • Read the Forecast File table (F3460) and the Sales Order Header File table (F4201) record for each customer.
  • Compare sales orders and forecast for each customer to determine which is greater.
  • The greater value of the two is written to the F3460 as a new forecast record with a forecast type that indicates that it is the result of a Forecast Consumption by Customer calculation

 

You can use the MPS Time Series program (P3413) to review the results of the calculation. The net forecast that results from the Forecast Consumption by Customer calculation is displayed as the adjusted forecast quantity (-FCST).

 

Forecast Consumption by Customer Calculation these tables illustrate the different results that are reached, depending on whether you differentiate by customer. The first table demonstrates the results of a calculation that does not differentiate by customer:

 

CustomerSales OrderForecastGreater of Forecast and Sales Order
A10080
B400375
C700750
Total120012051205

In this calculation, you aggregate all of the sales orders and all of the forecasts for an item and compare the totals with each other. In this case, the total forecast is greater than the total sales order quantity. Therefore, the forecast becomes the total demand.

 

This table demonstrates the results of a calculation that nets each individual sales order against a forecast with matching customer number:

CustomerSales OrderForecastGreater of Forecast and Sales Order
A10080100
B400375400
C700750750
Total1250

In this calculation, the sales order and forecast quantities are not totaled. Instead, each sales order is compared to a matching forecast. The greater quantity in each comparison is added to the total demand. In this case, the total demand is greater than if the first method had been used.

 

Forecast Consumption by Customer Considerations

In order to use Forecast Consumption by Customer, you need to consider:

  • Set up a forecast type for forecast consumption by customer in the UDC table 34/DF (Forecast Type).
  • Set up a version of the MRP/MPS Requirements Planning program by using these processing options:
    • Set the Forecast Consumption Logic processing option for using forecast consumption by customer.
    • Specify the forecast type to be used for forecast consumption by customer.
    • Specify whether the system uses the sold-to or the ship-to number on the sales order when searching for sales orders to net against a forecast.

 

    If you use multi facility planning, set up a version of the Master Planning Schedule - Multiple Plant by using these processing options:

  •         Set the Forecast Consumption Logic processing option for using forecast consumption by customer.
  •         Specify the forecast type to be used for forecast consumption by customer.
  •         Specify whether the system uses the sold-to or the ship-to number on the sales order when searching for sales orders to net against a forecast.
  •         Specify whether the system treats inter plant demand as customer demand consumes the forecast.
  •         Ensure that the items for which you are creating a requirements plan are defined with planning fence rule C, G or H.

 

For more information on Forecast Consumption Logic by Customer please see Forecast Consumption for EnterpriseOne (Doc ID 625964.1).

LearnJDE_new.pngNow you can easily meet all user interface related business requirements with #JDEdwards EnterpriseOne Personalization framework. Check our LearnJDE page for more information - http://bit.ly/2WbE2ie

QuestIcon2.pngTo take advantage of the additional features available in #JDEdwards EnterpriseOne, Miller Zell migrated from #JDEdwards World to EnterpriseOne. Read their migration story - http://bit.ly/3d4MmpW

QuestIcon2.pngRead the interview of the IT Director of Clayton County Water Authority, about the company’s upgrade to #JDEdwards EnterpriseOne 9.2 and their use of #Orchestrations. Read full interview here - http://bit.ly/2wZ1hl4

Oracle_updated.png#Simplify and #Automate your #JDEdwards EnterpriseOne 9.2 experience by leveraging the latest capabilities. Learn more in this whitepaper – http://bit.ly/2wO2T0Z

Reader.pngThis new KM document explains the purpose of the Freeze Rule (FREZ) field in the Location Master table (F4100) used in Warehouse Management. Doc ID 2636091.1. http://ora.cl/Sr8oT

Reader.pngThis new KM document explains how you can change the domain name of a web server in Server Manager to a new domain name. Doc ID 2635944.1. http://ora.cl/o6bU1

Reader.pngWondering which JDK to install on your new 64-bit web development client? This new document has the guidelines. Doc ID 2635922.1. http://ora.cl/BF8oP

Reader.pngWhen deleting an Item/Supplier relationship from P43090, it is also deletes the record from the Item/Supplier Catalog table (F41061). This new KM document explains the functionality. Doc ID 2635869.1. http://ora.cl/55dB0

LearnJDE_new.pngRead real-life examples of customer successes to know how you can leverage #JDEdwards digital framework to drive innovation in your business. Browse our LearnJDE Use Cases page - http://bit.ly/2RGxupg

QuestIcon2.pngLearn about #JDEdwards new application for Project Status Inquiry from Ward Quarles in this Quest Oracle Community webinar on March 19 - http://bit.ly/386xJ1J

Collab20white.pngCome learn more about the options you have for empowering your users to be informed and act using mobile devices. Attend this COLLABORATE session on April 20 at 4:30 PM. http://bit.ly/2w51WkX

Collab20_blk.pngDid you know that you can reinvent your #JDEdwards system using #UXOne framework? Plan to attend this COLLABORATE session on April 22 to learn about UX One - http://bit.ly/3cFZyBz

Collab20.pngThis session will review some industry specific business problem where Joint Venture Management would provide much needed functionality. Attend this COLLABORATE session on April 21 at 9:15 AM. http://bit.ly/2IDJMJM

Connect with #JDEdwards on Instagram to be updated with the latest news and events information. https://www.instagram.com/oraclejdedwards/Instagram.png

Collab20.pngMaximize the value of your #JDEdwards investments at COLLABORATE 20 conference. Register today. #C20LV http://bit.ly/37pkSrQ

Collab20.pngLearn everything about new features available in #JDEdwards 9.2 that will help you to simplify and automate your business processes. Attend this COLLABORATE session on April 21 presented by Keith Sholes - http://bit.ly/2IqHVHY

Reader.pngThis new KM document answers the question about whether or not UPC numbers must be populated on the Storage/Shipping Row Exit from Item master (P4101) in order to send an EDI 856 Outbound Advance Shipping Notice to their customer after Ship Confirm. Doc ID 2635370.1. http://ora.cl/7nx5Y

Reader.pngThis new KM document lists primary differences in Address Book auditing functionality between JD Edwards EnterpriseOne and JD Edwards World. Doc ID 2635338.1. http://ora.cl/YO2gm

Reader.pngThis new KM document explains how to disallow undefined E1 users or disabled E1 users from accessing E1 protected resources on Jas servers where SSO with Windows Native Authentication through Oracle Access Manager is enabled. Doc ID 2634964.1. http://ora.cl/3vp4n

Reader.pngThis new KM document provides some options to change the date format in License Plate Segments (P46L010). Doc ID 2634543.1. http://ora.cl/bB3Px

Collab20.pngNow is the time to take advantage of the many benefits offered by #JDEdwards 64-bit platform. Attend this COLLABORATE session on April 20 to know how you can easily make the leap. Details - http://bit.ly/2TpDeo9

LearnJDE_new.pngReceive critical business information on-the-go and act upon it immediately using #JDEdwards #Notifications. Know more about it on our LearnJDE page - http://bit.ly/2PNPwVa

remark.jpgThe remark field (RMK) in the F0411Z1 table is used to populate generic information on the voucher into the F0411 table when the voucher is created using Voucher Match Automation.  This is a generic field that can be used by customers to provide further details on the transaction created at voucher match.  There is no edit or validation on this data item, so users can input any information in this field to further describe the transaction being created, as long as it is within the 30 character limit defined in the data dictionary.  Voucher Match Automation has recently been enhanced to change the functionality of how this field is populated in the F0411 from the F0411Z1 when either a blank value was entered or a manual input was entered either by the user or from a 3rd party system that creates the F0411Z1 record. Prior to this fix, if a blank value was populated in the RMK field in the F0411Z1 table, the Supplier’s Name would always be populated in the F0411 created when running Voucher Match Automation. If multiple F0411Z1 records were processed and the RMK value was manually populated, the same value was populated in all F0411 records that was created.  Normally, when using the Interactive Application (P4314), this value would default from the value input on the PO Header (F4301) and can be manually overridden by the user after selecting the receipt/order to match.  A change was made in the following objects to allow further flexibility when creating a voucher using Voucher Match Automation:

 

Voucher Match Automation Driver UBE - R4304010

Generate Automatic Voucher Match Cache - B4304000

 

After this fix, if a blank value is populated in the F0411Z1 table, this blank value will be retained when Voucher Match Automation is ran and the F0411 record is created.  If the RMK field is populated in the F0411Z1 table, either manually by the end user or is brought in from a 3rd party system, this value will be populated in the F0411 table for each F0411Z1 record processed.  This provides further flexibility for customers to properly populate this generic text field in the F0411 to provide more details on the voucher created. Please reference KM Document E1: 43: Voucher Match Automation Retains Blank Value in Remark (RMK) in Voucher Transactions - Batch Upload (F0411Z1) and Accounts Payable Ledger (F0411) (Doc ID 2388687.1 for further details. This includes the link to Bug 27894875 : VOUCHER MATCH AUTOMATION BLANK REMARK IN F0411 & F0411Z1, which fixed this issue.

Oracle_updated.pngThis is the year for #JDEdwards World customers to embrace EnterpriseOne 9.2. See the new eBook to understand the benefits of migrating to become a digital business. http://bit.ly/2SVEBLu

LearnJDE_new.pngEnable process automation with #JDEdwards EnterpriseOne digital platform components like Orchestrator and Notifications. Check our new LearnJDE page for more details -  http://bit.ly/38wkgk1

Reader.pngThis new KM document outlines the process to reverse consumption in Outbound Inventory Management using Reverse Consumption (P42I031). Doc ID 2634042.1. http://ora.cl/na4tX

Reader.pngThis new KM document explains, with an example, of how to create variables from JSON output values in connector output. Doc ID 2634028.1. http://ora.cl/R0e1G

Reader.pngThis new KM document details the steps needed to promote a User Defined Object (UDO) such as a grid format from one environment to another using the Object Management Workbench Web application (P98220W). Doc ID 2633915.1. http://ora.cl/Q5m8G

Reader.pngThere isn't an application in the Fixed Asset System that automatically takes two or more assets and combines them into a single asset, but this new KM document will assist when multiple assets need to be combined into a single asset. Doc ID 2633883.1. http://ora.cl/SV8oZ

QuestIcon2.pngKnow the most significant recent updates of #JDEdwards #Orchestrator in this Quest Oracle Community SIG session on March 13. Details here - http://bit.ly/3975L7f

QuestIcon2.pngJoin this Quest webinar to learn about #JDEdwards new application for Project Status Inquiry from Ward Quarles. It is scheduled on March 19. http://bit.ly/386xJ1J

KathieS -Oracle

LearnJDE: UX One

Posted by KathieS -Oracle Mar 6, 2020

LearnJDE.png#JDEdwards #UXOne provides an intuitive and modern interface that gives immediate access to the data and ability to quickly respond. Learn more on our LearnJDE page - http://bit.ly/38difK9

YouTube.pngSubscribe to the #JDEdwards YouTube channel and press the bell icon to receive notifications for latest videos - http://bit.ly/JDEonYouTube

Collab20.pngLooking to streamline your #JDEdwards 9.2 upgrade process? Join this COLLABORATE20 session on April 22 detailing latest upgrade improvements that can automate and speed-up your upgrade. #C20LV http://bit.ly/2veXrUF

Reader.pngIf auditing of a table was incorrectly configured in a web environment (e.g. JDV920), you can correct it to audit for the standard environment (e.g. DV920) using the steps provided in this new KM document. Doc ID 2633881.1. http://ora.cl/xB053

Reader.pngAdvanced Procurement Pricing did not use a separate AAI for Advanced Price Adjustments. Functionality has been added to create separate General Ledger (F0911) journal entries for procurement price adjustments. When a procurement voucher is created with the new 4371 AAI configured, the system saves the actual cost and adjustment amounts in separate accounts associated with this AAI in the General Ledger table (F0911). Doc ID 2643177.1. http://ora.cl/ZT45C

Reader.pngThe EDI 820 outbound payment information CTX format (R47052T) has been enhanced to print the invoice number details in RMR segment. Doc ID 2640754.1. http://ora.cl/Jz2Ve

Reader.pngA new enhancement has been delivered that facilitates the deletion of credit card details associated to an employee when the employee record is deleted from the system. Doc ID 2638021.1. http://ora.cl/uq59y

YouTube.pngAccelerate your journey to becoming a #digital enterprise with #JDEdwards EnterpriseOne 9.2 solutions – http://bit.ly/2Tt3YTD

Collab20.pngExplore the benefits of #JDEdwards EnterpriseOne 9.2 with Bob Monahan and Gary Grieshaber in this COLLABORATE 20 session on April 20. #C20LV http://bit.ly/2HZ9CYe

Collab20white.pngJoin #JDEdwards on March 19 for a pre-COLLABORATE 20 Attendee orientation webinar to get all your questions about the event answered. Details here - http://bit.ly/2VwmBbQ

QuestIcon2.pngDiscover how to empower your business users with #JDEdwards Orchestrator studio in this Quest Oracle Community SIG meeting scheduled on March 13. More details here - http://bit.ly/3975L7f

Reader.pngA new processing option for “Discount on Partial Payments” has been added to Known Invoice Match With Amount (R03B50D) and Known Invoice Match Without Amount (R03B50E) to determine how discounts are applied to partial payments. Use this processing option to specify whether to apply discounts when the payment amount is less than the open amount of the invoice. Doc ID 2638014.1. http://ora.cl/fX134

Reader.pngA new enhancement has been delivered to display the Business Unit in the Multi Voucher Applications. The Business Unit (MCU) field has been added to the grid of the Multi Voucher-Single Supplier (P041017), Multi Company-Single Supplier (P041016) and Multi Voucher-Multi Supplier (P041017) applications. Doc ID 2637997.1. http://ora.cl/He4l6

Reader.pngA new enhancement has been delivered to provide Record Reservation functionality for invoices (P03B2002/P03B102).  This functionality ensures that invoices that are in use in one application are locked and cannot be updated in another application. This document provides the ESU information to obtain the functionality and a link to the guide section in the Accounts Receivable Implementation guide. Doc ID 2637994.1. http://ora.cl/Me3cZ

Reader.pngThis new KM document describes changes implemented in License Plate Processing (P46L10) for Picking Optimization. Doc ID 2637450.1. http://ora.cl/KH3CN

YouTube.pngWatch this YouTube tutorial to know how to define and generate distribution ledgers for #JDEdwards financial reporting - http://bit.ly/2VszlQH

Collab20.pngValuable tips and insights directly from #JDEdwards customers at COLLABORATE 20. Register with Quest Oracle Community today to get early bird benefits #C20LV http://bit.ly/37pkSrQ

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.