Populating Flexfiled Value Set

Posted on by

Populating Flexfiled Value Set

1. Company Segment Values

1.  Open the segment Values window.

General Ledger :  Setup > Financials > Flexfields > Key > Values

2.  Provide the following information on Find window.

Field
 Value
Application General Ledger
Title Accounting Flexfield
Structure FASS_AFF
Segment Company

1.1.    Click on Find

1.2.    Enter the following information

Value Description Enabled Parent Qualifiers: Allow budgeting/ posting
01 SOFTSERVICES Yes   Yes, Yes
02 HWSERVICES Yes   Yes, Yes

Note: Make sure that you have given the appropriate qualifiers and Define Child Ranges button will only be active when you will mark the value as Parent by enabling Parent check box.

1.3.    Save the data.

1.8.    Close the form and on closing a request will be submitted for compilation.

1.9.    Click on OK Button.

1.10.  Check the status of request.

2. Cost Center Segment Values

2.1.    Open the segment Values window.

General Ledger :  Setup > Financials > Flexfields > Key > Values

2.2.    Provide the following information on Find window.

Field Value
Application General Ledger
Title Accounting Flexfield
Structure FASS_AFF
Segment Cost

2.3.    Click on Find Button.

2.4.    Enter the following information.

Value Description Enabled Parent Qualifiers: AllowBudgeting / Posting
000 Unspecified Yes   Yes, Yes
001 ADMINISTRATION Yes   Yes, Yes
002 Finance Yes   Yes, Yes
003 IT Yes   Yes, Yes
004 HR Yes   Yes, Yes
005 Production Yes   Yes, Yes
006 COSTING Yes   Yes, Yes

2.5.    Save the data.

2.6.  Check the status of request.

3. Account Segment Values

3.1.    Open the segment Values window.

General Ledger :  Setup > Financials > Flexfields > Key > Values

Field Value
Application General Ledger
Title Accounting Flexfield
Structure FASS_AFF
Segment Cost

3.2.    Provide the following information on Find window.

3.3.    Click on Find Button.

3.4.    Enter the Natural Account data as shown blow.

Or Click Here  and download Data Loader file to upload Accounts data through data loader.

3.6.    Save the data.

3.7.    Close the form and on closing a request for compilation will be submitted.

3.8.    Click on OK Button.

3.9.    Check the status of request.