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

Page Visits:-415110 (Since:-January-2014)

Oracle JD Edwards EnterpriseOne Main Topic Category

JDE Forum Comments/Reviews/Query
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.
795 day(s) ago   #342
Name: Admin
Category: Functional
Location: Singapore
Date: 2018-03-27 09:53:35


Difference between 9.0 to 9.2 version jde

Hi Ravi,

Thanks for your query!

You can find net change document on oracle support for difference between JDE 9.0 and 9.2 versions.
Hope this helps.

Thank U.
797 day(s) ago   #341
Name: Wayneskype
Category: Technical
Date: 2018-03-25 22:32:49



Hello and bye
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
892 day(s) ago   #319
Name: Donette
Category: Technical
Date: 2017-12-20 06:21:36


Getting Logs of Running Interactive Applications in JDE EnterpriseOne

online loans direct lenders loans online with monthly payments payday loans online bad credit payday loans no credit check
910 day(s) ago   #316
Name: Admin1.
Category: CNC
Location: Singapore
Date: 2017-12-02 03:32:04


SQL query

Hi Gopal,
This is not recommended, you may encounter integrity issues.
By the way may I know which which JDE version your are on?

925 day(s) ago   #312
Name: SimonAmerica
Category: CNC
Date: 2017-11-17 12:22:22



Can Interactive Versions (IVs) Be mapped to run locally?

Page:[First] | 1 2 3 4 5 ...[>>]
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