Welcome Guest Login SignUp








JDE News

Live Radio


Latest Updated Posts
JDE TECHNICAL 2020-01-27 21:52:46

FAQ - Frequently Asked Questions on Table Conversion (TC) in JDE E1 2020-01-10 09:50:09

What is MVC Architecture? 2020-01-08 03:26:12

Power Forms in JDE E1 2019-12-29 12:59:17

Difference Between EDI Process and Z files 2019-12-10 11:32:31

test 2019-07-06 14:18:19

Flex Accounting in JDE EnterpriseOne

Dated: 2019-03-09 22:16:37

Difference between 9.0 to 9.2 version jde

Dated: 2018-03-24 01:56:02

Month closing/End activity in S&D module

Dated: 2018-01-06 10:22:56

Massive change of Planning Code

Dated: 2017-09-22 13:53:45

UDC Problem - Reg...

Dated: 2017-06-12 07:57:07

What is the difference between RIS and ZJDE versions in Reports?

Dated: 2017-01-03 01:50:49

JDE Sales and Distribution (S and D) Interview Questions

Dated: 2016-10-06 23:13:51

Oracle JD Edwards Finance Functional Certification

Dated: 2016-09-17 03:17:44

ERP Implementation Project Cycle

Dated: 2016-07-13 01:49:53

Purchase Requisition open quantity gets doubled upon canceling the PO line

Dated: 2014-02-11 03:28:49
 Click here to Start a new topic
JDE Forum Comments/Reviews/Queries
448 day(s) ago   #343
Name: Admin
Category: Functional
Location: Singapore
Date: 2019-03-09 22:16:37


Flex Accounting in JDE EnterpriseOne

Flexible sales accounting is used to create a flexible format for account numbers in your chart of accounts. Flexible account numbers use the standard J.D. Edwards format, which has three segments, business unit.object.subsidiary. The flexible format lets you customize each segment of the account number.

For example, you might use a format that includes more information, such as, salesperson, branch, sales territory, and other address book category codes. Or, you can set up the structure of the flexible account number based on how you track the performance of items and customers through sales detail and the general ledger.

The standard J.D. Edwards account structure is formatted with the following segments:

*** * Business unit
*** * Object account
*** * Subsidiary account
*** * Subledger

Flexible format accounts have the same segments. The length of all segments cannot exceed 34 characters. Each segment of the flexible format account has a character limit:

Business unit 12 characters
Object account 6 characters
Subsidiary account 8 characters
Subledger 8 characters

To create a flexible account number, you define one or more of these segments. To do this, you associate one or more pieces of information with each segment. Each piece of information is associated with a field and is stored in one of the following tables:

*** * Address Book Master (F0101)
*** * Price Adjustment Ledger File (F4074)
*** * Item Master (F4101)
*** * Item Branch File (F4102)
*** * Sales Order Header File (F4201)
*** * Sales Order Detail File (F4211)

To associate information with a segment, you must know the data item name that J.D.Edwards has defined for the corresponding field in the table.
You cannot define an object segment. You must define the object account through AAIs.

The subledger account is not visible online, but is stored in the Account Ledger table (F0911).

You activate flexible sales accounting through the processing options for the Sales Update program (R42800).

You can define a flexible account number only for the following base sales order management AAI tables:

*** * 4220 (Cost of Goods Sold)
*** * 4230 (Sales)
*** * 4240 (Inventory)
*** * 4250 (Sales Tax Payable)

When the system searches for an account for these AAIs, it searches the Sales Flex Accounting table (F4096) as follows:

*** * The system checks for a flexible account number that has been defined for a specific AAI and a specific company.
*** * If no account has been defined for a specific AAI and a specific company, the system checks for an account that has been defined for a specific AAI and company 00000.

Advanced Pricing AAIs -

You can define a flexible account number for only the following advanced pricing AAI tables:

*** * 4270 (Adjustments)
*** * 4280 (Accruals)

This is all about the basics of Flex accounting in JDE.
798 day(s) ago   #340
Name: Ravi
Category: Functional
Date: 2018-03-24 01:56:02


Difference between 9.0 to 9.2 version jde

Can you please note demarcation between 9.0 9.1& 9.2 jde version . Also show dmmais triggered inventory, sales & procurement in jde
875 day(s) ago   #322
Name: Neeraj
Category: Functional
Date: 2018-01-06 10:22:56


Month closing/End activity in S&D module

Please provide and explain what activities are required to do month or year closing/End
981 day(s) ago   #299
Name: Omar Frausto
Category: Functional
Date: 2017-09-22 13:53:45


Massive change of Planning Code

Hi everyone! I was looking through the forums and I couldn`t find any related to this. We have hundreds of part numbers on the system, and we need to change the Planning Code, what we need to know it`s if there is a way to change the planning code in a massive way. This means, change the planning code of the hundreds of codes at the same time (It¬īs the same for all), without having to change it one by one. I appreciate your help.
1083 day(s) ago   #286
Name: Santosh
Category: Functional
Date: 2017-06-12 07:57:07


UDC Problem - Reg...

not found in User Defined Code 40 PC? When i am preparing SO (or) PO (or) anything the above error message is coming. Anyone rectify this step by step... Rgds, Santosh
1243 day(s) ago   #249
Name: Admin1
Category: Functional
Location: Singapore
Date: 2017-01-03 01:50:49


What is the difference between RIS and ZJDE versions in Reports?

This post explains the difference between the RIS and ZJDE versions of Reports in JD Edwards EnterpriseOne.

RIS Versions:
RIS versions are RAPID START versions that Oracle has preconfigured specific data selection and processing options for. If you are on 8.11 SP1, there is a post installation job called Data Configuration Workbench that allows you to choose which country versions you want or if you don`t want Rapid Start. Rapid Start essentially is a way to get up and running quickly with some data based on the country`s needs.

ZJDE Versions:
ZJDE are the STANDARD versions that come with default values.
1332 day(s) ago   #237
Name: Admin
Category: Functional
Location: Singapore
Date: 2016-10-06 23:13:51


JDE Sales and Distribution (S and D) Interview Questions

Important Questions from INVENTORY management

Q1. What fields can be at item master level and what can be at branch plant level.
  • Following fields are defined on Item master: - Inventory cost level, sales price level, Purchase price level and Std UOM conversion.
  • Item Branch plant can have specific fields to various warehouse locations like GL class, category codes & such
  • Location for the item has to be defined for Item Branch plant combination. In addition, lot / serial numbers are for specific Branch plants.
Q2.Tables in Inventory
  • F4101 Item Master
  • F4102 Item Branch File
  • F4108 Lot master
  • F4111 Item ledger file
  • F41021 Item location file
  • F4105 Item Cost file
  • F4106 Item Base price file
  • F41112 as of file
Q3. What is last in, weighted average and standard cost method?

For last-in (01), the system interactively updates amount based on the last cost of the item at the time of receipt. Last-in, purchasing, and lot costs are updated by the Receipts program.For weighted average (02), the system calculates and updates this amount by adding transaction quantities together, adding transaction costs together, and dividing the total cost by the total quantity. Allowing the on-hand quantity to be negative is not compatible with using the weighted average cost function. If you use standard costs (07), the system might create journal entries for the variance, based on AAI item 4141.

Q4. Explain about cost levels in item master

A code that indicates whether the system maintains cost for the item, a different cost for each branch plant, or a different cost for each location and lot within a branch plant.

Valid codes are -
1:- Item level
2:- Item Brach Only
3: - Item Brach / Location/ Lot

Q5. What is AS-of file?

Item as of file is F41112. Typically all inventory transactions are recorded in Item ledger file. We can run item as-of generation program which accumulates monthly numbers and stores it in monthly bucket in F41112 file. Hence inventory reporting can be based on item as of file for previous month figure and can go to item ledger file for current month transactions.

Q6. When does cost get populated in cardex?

Cost is populated in cardex at the time of Purchase Receipt and Inventory adjustment. Confirm shipment and Sales update. All the transaction related to stock items is updated in cardex.

1351 day(s) ago   #235
Name: Srikanth Reddy
Category: Functional
Date: 2016-09-17 03:17:44


Oracle JD Edwards Finance Functional Certification

Hi All, I am planning to go for Oracle JD Edwards Financials Certification. If anyone has information on this (like material, dumps, information on exam and other guidelines) kindly share. Thanks, Srikanth Reddy
1417 day(s) ago   #228
Name: MJ
Category: Functional
Location: Australia
Date: 2016-07-13 01:49:53


ERP Implementation Project Cycle

The normal life-cycle of an ERP Implementation Project shall consist of the following milestones:-
  1. Business Process Study: Regular interactions with the client grow in order to understand the various business processes and the way they are presently carried out.
  2. Pre-Implementation Training: A pre-implementation training, detailing the concepts and features, shall be given to all the end-users at the client site. This shall improve the lead time in collecting the inputs for the preparation of specifications.
  3. Requirement Analysis: The requirements of the client are collected, using the SRS (Software Requirements Specification) form, to further the process study.
  4. GAP Analysis: In relation to Information Technology, this analysis points out the differences or gaps that exist between the standard capabilities of the desired system & the expectations of the client. The deliverable is a GAP Report.
  5. BMR (Business Mapping Report): This follow-up of the GAP Analysis should address the identified solution(s) for the gap areas.
  6. Project Plan: This milestone shall set the actual plan for execution and roll out for the roles and task allocations.
  7. Installation of Software: The Vanilla installation of the complete software should now be carried out to ascertain the infrastructure preparedness at the client site.
  8. Customization of Forms & Reports: The Client`s requirement as to the customization of forms (user interfaces) and reports (existing as well as new requirements) are addressed here.
  9. Migration of Historical Data: Beyond the opening balance incorporation, if the client desires to bring the historical data, this step will be required to plan the conversion and clean up - prepare the data for the new environment.
  10. Design of Routines & Workarounds: Though this is not a milestone, the additional routine and workaround requirements (as identified in the GAP & BMR) shall be addressed through this step.
  11. Setup & Configuration: The new environment shall be setup based on the SRS and the software shall be configured (on different deployment methods) fully.
  12. Testing Environment: A testing environment (a simulation of the live environment) shall be created in the new software to enable the end-users to acquaint and equip themselves for beginning in the live environment.
  13. End-User Training: The next milestone shall be giving training to the end-users on the setup, configuration, transaction processing and report generation. This shall be the post-implementation training phase.
  14. System Walk-Through: This milestone requires entry of sample transactions by the end-users in the testing environment.
  15. Go Live: This is the Sign-Off phase where the project gets implemented.
  16. Post Implementation Support: An immediate support commitment, subsequent to the implementation, and the detailed modes of support, etc., are given to the client.
Source: - jdetech
2300 day(s) ago   #140
Name: TechZone
Category: Functional
Location: Singapore
Date: 2014-02-11 03:28:49


Purchase Requisition open quantity gets doubled upon canceling the PO line

Generating PO from Blanket order with maximum extended amount (i.e.: 9999999999999.99) and then cancel the PO, the Purchase Requisition (PR) open quantity is doubled.

We are facing this issue in Xe release.
Anyone can advise whether this issue fixed in latest release?

2434 day(s) ago   #126
Name: Alex
Category: Functional
Location: India
Date: 2013-09-30 19:42:04


Set up for Backorder in Sales

Hi All

Recently we faced issues which have been mostly related to various setup for Backorders. Found a good document on oracle support under Doc ID 763476.1

Below table shows link between different options and is quite useful and handy in checking if any setup is missing or incorrect.

Thanks & Regards
JDE E1 Distribution.
2523 day(s) ago   #115
Name: Duster
Category: Functional
Location: India
Date: 2013-07-03 03:18:44


How to Prevent Availability and On-Hand Quantity from Going Negative?

Hello everyone,

We have been facing the issue of Negative Availability and On-Hand Quantity intermittently. So tried searching KG for any solution or documentation and found one very useful article over there - ID 633966.1

How to Prevent Availability and On-Hand Quantity from Going Negative

Oracle JDE E1 Functional
2760 day(s) ago   #92
Name: TechZone
Category: Functional
Location: Canada
Date: 2012-11-08 09:14:20


Activities for Year End Colsing JDE EnterpriseOne

The year end closing process consists of many tedious, cumbersome and time consuming tasks. Although this process is a necessary evil, you donít have to go it alone.

Financials Activities
* A/R Close
* A/P Update
* 1099 Process
* GL Close
* Fixed Assets
* Updating Processing Option

HR/Payroll Activities

* Year End ESUís
* Rollovers
* Processing W2′s
* Electronic Filing for W2′s
* Forms Alignment

2867 day(s) ago   #76
Name: Duster
Category: Functional
Location: India
Date: 2012-07-24 19:04:19


Working with Print Message

Hello guys,

Can anyone tell me the exact steps on how set up and use Print Message. I want to use it print a block of text on the purchase order print report.

Thanks in advance.
JDE Functional
JDE EnterpriseOne Distribution.
2887 day(s) ago   #61
Name: Nexus
Category: Functional
Location: India
Date: 2012-07-04 01:12:46


Purchase order - partial receipt of amount

There is an OS purchase order with a quantity of 1 ,amount of 30,000.00. Is there a way to receive this in 3 amounts as invoiced 15,000 , 7500,7500
If I try to receive it in the P4312 when I change the first amount from 30,000 to 15,000 and receive the whole amount gets received.
I can receive partial amounts if I change the quantity to a a figure of less than 1 i.e .25 .30
Is this the only way to handle this kind of receipt? Is it possible to leave the quantity as 1 and still receive partial amounts?

JDE Functional
2966 day(s) ago   #55
Name: JDE Geek
Category: Functional
Location: India
Date: 2012-04-16 22:23:01


EnterpriseOne (E1) Fine Cut Task Views

We have found that users take advantage of the menu filtering, which is referred to as ďFine CutĒ. Moving these from one environment to the next can be done through OMW or by copying some files. It has been easier just to copy the files.

Here they are:

F9000-Task Manager
F9001-Task Relationships
F9002-Task Alternate Descriptions
F9005-Variant Description
F9006-Variant Detail
3159 day(s) ago   #37
Name: TZ
Category: Functional
Location: India
Date: 2011-10-06 18:01:29


JDE EnterpriseOne Record Locks

This file (F00095) is located in the data library and contains keys to records that are "in use" by users on the system. Usually it is applied to records that are in the middle of changing data that the system doesnít want other users to change at the same time. The contents of this file can be accessed using the P00095 application.
3177 day(s) ago   #26
Name: rey
Category: Functional
Location: NY
Date: 2011-09-18 22:40:39


Create your own or View ShortCodes for JDE Fastpath

JD Edwards Fastpath is one of the biggest places where people type in program names, and there it pops up.
There are lots of fastpath codes which we use, for e.g. AAI, OMW, UDC, DD, ACCT etcÖ!

Have you imagined you can put your own FastPath short codes too!

JD Edwards Fastpath references UDC codes in the UDC type Fast Path Commands (00/FP) for Fast Path if Task Explorer is pointing to the OneWorld tables.
If Task Explorer is pointing to the Solution Explorer tables, the system references UDC codes in UDC type ActivEra FastPath (H90/FP) instead.
You can see all the FastPath codes in these UDCís for your reference.
The Description 2 of the UDC denotes where the Application or Menu resides.
You can get the Task ID of the application and use it if you need to open an Application from the fastpath (e.g. 3/GH9052).
For Menuís, enter the Menu Name (e.g. G5503B) in Desc2 of the UDCís. Add an entry into the UDCís (H90/FP or 00/FP), and restart EnterpriseOne; your fastpath short codes start working.
3182 day(s) ago   #10
Name: MJ
Category: Functional
Location: SG
Date: 2011-09-13 00:45:39


Checklist Before publishing financial statements

Are you running all the necessary reports before publishing financial statements?

All reports should be run at least monthly. Where possible, it is recommended that all reports should be run weekly, and scheduled on a night attendant. The Unposted Batches Report should be run and all relevant batches be posted before publishing financial statements.

Financial Integrity Reports
AR to GL by Batch
AR to Account Balance by Account ID
AR to GL Receipts

A/P Original Doc to G/L by Batch
A/P Payments to G/L by Batch
A/P to G/L by Offset Account
A/P Payments to A/P w/ Update

Unposted Batches
Transactions to Batch Headers
Batch to Detail

Company by Batch Out of Balance
Batches Out of Balance
Companies in Balance
Intercompany Accounts in Balance
Accounts Without Business Units
Account Balance Without Account Master
Transactions Without Account Master
Account Balance to Transactions

Fixed Assets to GL
Unposted Fixed Asset Transactions
Fixed Asset Transaction Integrity
GL to Fixed Assets Integrity

3281 day(s) ago   #8
Name: rey
Category: Functional
Location: sing
Date: 2011-06-06 19:59:06


Reverse Confirm Shipment

Anyone having any idea how to reverse confirm shipment, as user did it mistakenly. Thanks in advance for your valuable advice.
Post Comments/Queries
* Please keep the forum clean.  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
JDE List JDE Source    JDE Upgrade JDE Fusion     The CNC Guy     Itz about ERP JDE Dev JDE Tech
E1 Tips & Tricks JDE CNC JDE Tips IT Toolbox JDE Tech Tips JDE ERP JDE Advisor JDE Wikipedia
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in