Creation of Set Of Books

Creation of Set Of Books :

Navigation :

            General Ledger,  Vision Operations ( USA ) à Setup à financials àBooks à Define

            Query for the existing one  ( Ctrl + F11  and down arrow key )

Set of Books : Vision Operations (USA)

 Copy the following into some notepad )

Chart of Accounts :  Operations Accounting Flex

Retained Earnings : 01-000-3310-0000-000

Translation Adjustment : 01-000-3500-0000-000

Create new set books from the above

Set of Books : Test_29_Apr_SOB                  Short Name : Test_29_Apr_SOB ( same or any one )

Desc : as desired

Chart of Accounts : Operations Accounting Flex  ( from the above copied one )      Functional Currency : USD

Calendar

            Name : Accounting                 future period : 1 ( auto )

            Period Type : Month ( auto )

            Retained Earnings : 01-000-3310-0000-000   ( copy the previously taken into notepad )

Translation Adjustment : 01-000-3500-0000-000  ( copy the previously taken into notepad )

           

            Company         : 01

            Department      : 000

            Account           : 3310

            Sub Account    : 0000

            Product            : 000

            Paste the above one by one from the above

Retained Earnings :      01-            000-                        3310-      0000-                        000

                                    Company- Department- Account- Sub Account- Product

            Select OK

            Similarly Translation Adjustment

Translation Adjustment : 01-000-3500-0000-000  Paste into respective fields as above

Select OK

Note : The above set of books information will be stored into the table called

            GL_SETS_OF_BOOKS_V

select * from GL_SETS_OF_BOOKS_V where trunc(creation_date)=trunc(sysdate)

Legal Entity :

create the organization         

           

Navigation :

Inventory Vision Operations ( USA ) à Setup à Organizations à Organizations  à New

Name : Test_29_APR_LE

Location : REG10_SRNAGAR ( select from existing Ctrl + F11 )

Save the  above

Organization Classification :

Name : GRE / Legal Entity                                           select Enabled

Save the above

Select Others ( link between Set Of Books and Legal Entity )

  Select :  Legal entity accounting  

Press Tab

Set of Books : Test_29_Apr_SOB  ( supply the above created set of books ) OK à OK à Yes or save

                                                                          

Note : The above information will be stored into the table called :

HR_ORGANIZATION_UNITS_V

select * from  HR_ORGANIZATION_UNITS_V  where  trunc(creation_date)=trunc(sysdate)

Operating Unit :

Creating Operating Unit

Create the organization of Organization Classification as Operating Unit

Navigation

Inventory Vision Operations ( USA ) à Setup à Organizations à Organizations  à New

Name : Test_29_APR_OU

Location : REG10_SRNAGAR ( select from existing Ctrl + F11 )

Save the  above

Organization Classification :

Name : Operating Unit                                                 select Enabled

Save the above

Select Others ( link between Set Of Books, Legal Entity   and  operating unit  )

Select :  Operating Unit Information  

Press Tab

Set of Books : Test_29_Apr_SOB  ( supply the above created set of books ) OK and save

Legal Entity : Test_29_APR_LE

Set Of Books : Test_29_Apr_SOB ( auto )

Click on OK  and  Save it ( Yes )

Inventory Organization :

It is a place where actual business transactions takes place ( called as transaction point )

Inventories  can be classified into two

1)      Master Inventory                                   

2)      Child Inventory

Master Inventory : It defines the total products. It is a logical one

Child Inventory : It defines the particular products ( quantity and type ). It is a physical one

Eg :

                                                                           SONY

                           IND                                         USA                                      UK

HYD                MUMB            PUNE                 NY   WSH                 LOND              X

In the above suppose Sony is manufacturing computers and may 100 models

At different locations doing business for particular models.

Eg : at HYD  may be   50 models

        at MUMB may be 70 models

       at NY  may be        100 models

       at   WSH may be    90 models

       at   X  may be 20 models

here total 100 Models is a Master Inventory  and

50, 70, 100, 90, 20 are Child Inventory

First step We have to identify the Master and Child based on Company Name.

( SONY, LOGTECH, LG, SAMSUNG )

How to Identify the Master and Child based on Company Name.

ORG_ORGANIZATION_DEFINITIONS and MTL_PARAMETERS

The tables provides, Multi Organizations information.

ORG_ORGANIZATION_DEFINITIONS  table provides All High Level information such as Business Group, Set Of Books, Legal Entity, Operating Unit

MTL_PARAMETERS  table provides actual inventory information such as INV OrG

For example

            Name of the business group  : Vision Corporation

Back End Process

Step1 :

            select * from HRFV_BUSINESS_GROUPS where BUSINESS_GROUP_NAME = 'Vision Corporation'

            Get the BUSINESS_GROUP_ID

                        ( or )

                       

            BUSINESS_GROUP_ID = 202

Step2 :

select * from ORG_ORGANIZATION_DEFINITIONS  where BUSINESS_GROUP_ID =202

Get the ORGANIZATION_CODE form the above ( select any one as desired eg;  M7 )

ORGANIZATION_CODE = M7

Step 3:

select * from MTL_PARAMETERS where ORGANIZATION_CODE = 'M7'

get the MASTER_ORGANIZATION_ID from the above result

MASTER_ORGANIZATION_ID = 204

Step4 :

select * from ORG_ORGANIZATION_DEFINITIONS  where ORGANIZATION_ID = 204

Front End Process:

In pending

Sub Inventory :

Creation of Sub Inventory :

                       

Navigation

Inventory Vision Operations ( USA ) à Setup à Organizations à Sub Inventories à M1 ( Inv Org Name )

Name : REG10_SINV ( allows only 9 chars ) ( Name as desired ) ( Copy this name into note pad )

Desc : as desired          Status : Active              Locator Control : Dynamic Entity        Type : Storage

The above sub inventory information is available in table called : MTL_SECONDARY_INVENTORIES

select * from MTL_SECONDARY_INVENTORIES where trunc(creation_date) = trunc(sysdate)

Create the Storage Location :

Eg :

Row     Rack    Bin

   1    -     A    -    2

   2    -     A    -    1

   1    -     B    -    4

   2    -     A    -     3

1)      Create the Flex fields for the above

2)      Create the Stock Location

1) Create the Flex fields for the above requirement

Navigation

System Administrator à Application à Flex Fields à Key à Segments

Application : Inventory                        FlexField Title : Stock Locators ( use down arrow key  to get )

Un Freeze FlexField Definition             OK                 Period ( . )

Select Segments 

In the Required only Row,  Rack  and Bin.  Hence disable the ( Displayed and Enabled for remaining )

Make Value set as empty for Row, Rack, Bin

To set the fields as mandatory select the field and open

Eg :

            Row and Rack as Mandatory

            Select Row and Open ,   check the Required

Save the above and freez the FlexField Definition,  OK  à compile à OK à OK

Copy the Flex Field Title (Stock Locators )  into note pad (Stock Locators) : it is a mapping to Stock locator

2) Create the Stock Location

            Select locator Row :

Inventory Vision Operations ( USA ) à Setup à Organizations à Stock Locators à M1 ( Inv Org Name )

Select New

Locator ( Click here ) : Row :1            Rack : A          Bin: 1

Locator : 1.A.1

Status : Active

Save and Close

Status : Active

Subinventory : REG10_SINV

Again go to Sub inventory ( query for REG10_SINV )

Select locators ( 1.A.1 )

Locator Information will be stored into the table called : MTL_ITEM_LOCATIONS