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

Post a Comment