• No results found

Assign same G/L account to two different plants from two different company codes belongs to same Chart of Accounts

N/A
N/A
Protected

Academic year: 2022

Share "Assign same G/L account to two different plants from two different company codes belongs to same Chart of Accounts"

Copied!
47
0
0

Loading.... (view fulltext now)

Full text

(1)

Assign same G/L account to two different plants from two different

company codes belongs to same Chart of Accounts

Automatic Account Determination

VAISHNAVI JINDAM 6/18/21 SAP MM-FI Integration

(2)

VAISHNAVI JINDAM

Automatic Account Determination

Scenario

Assign Same G/L account to two different plants of two company codes if two Company Codes are belongs to Same Chart of Accounts

Create Chart of account

SPRO-> SAP Reference IMG->Financial Accounting->General Ledger accounting->Master data->G/L accounts->Preparation->Edit Chart of account List

Chat of Account

Company Code1

Company Code2

Plant

Plant

Valuation Group Code

G/L account

Account Category

Reference Valuation

Class Material

Type

Material

Goods Issue

Invoice Posting

(3)

VAISHNAVI JINDAM Define Company Code

SPRO-> SAP Reference IMG->Enterprise Stricture->Definition->Financial Accounting->Edit, Copy, Delete, Check company code

Click on Edit Company Code Data

Click on “New Entries”

(4)

VAISHNAVI JINDAM Enter Below Details

Click on “Next Entry” to enter address details

(5)

VAISHNAVI JINDAM

(6)

VAISHNAVI JINDAM Click on Save

If we are not getting transport request number click on as below and give short description and save

(7)

VAISHNAVI JINDAM Assign Company Code to Chart of Account

SPRO-> SAP Reference IMG->Financial Accounting->General Ledger accounting->Master data->G/L accounts->Preparation->Assign company code to Chart of accounts

(8)

VAISHNAVI JINDAM Define Plant:

SPRO-> SAP Reference IMG->Enterprise Stricture->Definition->Logistics-General->Define, Copy, Delete, Check Plant-> Define Plant

Define Storage Location

SPRO-> SAP Reference IMG->Enterprise Stricture->Definition->Material Management->Maintain Storage Location

(9)

VAISHNAVI JINDAM Enter plant

Enter Storage location

Define Purchase organization:

SPRO-> SAP Reference IMG->Enterprise Stricture->Definition->Material Management-> Maintain Purchase Organization

(10)

VAISHNAVI JINDAM Define Purchase Group:

SPRO->SAP Reference IMG->Material Management->Purchasing->Create Purchase Groups

Assignments

Assign plant to company code

SPRO-> SAP Reference IMG->Enterprise Stricture->Assignment->Logistics general-> Assign plant to company code

Assign Purchasing Organization to company code

SPRO-> SAP Reference IMG->Enterprise Stricture->Assignment->Material Management->Assign Purchasing Organization to company code

(11)

VAISHNAVI JINDAM Assign Purchasing Organization to plant

SPRO-> SAP Reference IMG->Enterprise Stricture->Assignment->Material Management->Assign Purchasing Organization to plant

Maintain Fiscal year variant

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Maintain Fiscal year variant

(12)

VAISHNAVI JINDAM Assign company code to fiscal year variant

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Assign company code to fiscal year variant

Define Variants for open posting periods

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Define Variants for open posting periods

Assign Variants to company code

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Assign Variants to company code

(13)

VAISHNAVI JINDAM Define Open and Close Posting Periods

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Open and Close Posting Periods

Enter posting period variant and values

Define Field status variants

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fields->Define Field status variants

Assign company code to field status variants

SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Regenerate CDS views and field mapping->Ledgers->Fields->Assign company code to field status variants

(14)

VAISHNAVI JINDAM Define account group

SPRO-> SAP Reference IMG->Financial Accounting->General Ledger accounting->Master data->G/L accounts->Preparation->Define account group

Define Retained Earnings Account

SPRO-> SAP Reference IMG->Financial Accounting->General Ledger accounting->Master data->G/L accounts->Preparation->Define Retained Earnings Account

Select your Chat of accounts

(15)

VAISHNAVI JINDAM SPRO-> SAP Reference IMG->Financial Accounting->Financial accounting global settings->Global parameters for company code->Enter global parameters

Once all the above settings are created and the same has reflect in the above path as below

(16)

VAISHNAVI JINDAM Create G/L account:

TCODE: FS00

Create Reconciliation account

(17)

VAISHNAVI JINDAM

(18)

VAISHNAVI JINDAM Click save

(19)

VAISHNAVI JINDAM Create Stock Account:

TCODE: FS00

(20)

VAISHNAVI JINDAM Click Save

(21)

VAISHNAVI JINDAM Create GR/IR Clearing account

TCODE: FS00

Click save

(22)

VAISHNAVI JINDAM Define Plant Parameters:

SPRO->SAP Reference IMG->Material Management->Inventory Management and Physical Inventory-

>Plant Parameters

(23)

VAISHNAVI JINDAM Maintain Controlling Area

SPRO->SAP Reference IMG->Enterprise Structure->Definition->Controlling->Maintain Controlling Area

Click new entries

TCODE: OMSY Select company code

(24)

VAISHNAVI JINDAM Give current year and month then enter and save

TCODE: OMX3: Assignment of material ledger types to valuation area Select plant as valuation area

TCODE: OMX1:Active Material Ledger

TCODE: OMX2: Define Material Ledger Type Click new entries and Give plant

Define settings for ledger and currency types

SPRO->SAP Reference IMG->Financial Accounting->Financial Accounting Global Settings->Ledgers-

>Ledger->Define settings for ledger and currency types

Click ok->select ledger-OL->select currency conversion settings->click ok Copy from SG05 and make entry for Company code then click ok

(25)

VAISHNAVI JINDAM TCODE: OMX1:Active Material Ledger

Check for plant

Now Material ledger is in active state

Production Startup:

Set Valuation area as Productive TCODE: CKMSTART

Execute

(26)

VAISHNAVI JINDAM TCODE: OMS2

Select plant and click on quantity and value update Select quantity and value update

Create Material Type

SPRO->SAP Reference IMG->Logistics-General->Material Master->Basic Settings->Material Types-

>Define Attributes of material type

(27)

VAISHNAVI JINDAM Created Material Type: ZMAT

Select ZMAT and click on Quantity/Value update Update Quantity/Value for your plant

Define Number range for each material type:

SPRO->SAP Reference IMG->Logistics-General->Material Master->Basic Settings->Material Types-

>Define Number Ranges for each material type

(28)

VAISHNAVI JINDAM Create Group and number range:

Search Material type and Click on below highlighted button-assign element to group to assign ZMAT Material type to number range

(29)

VAISHNAVI JINDAM Click Ok

(30)

VAISHNAVI JINDAM Business Partner:

Create Account Group (OBD3):

SPRO->SAP Reference IMG->Financial Accounting->Accounts Receivable and Payable->Vendor Accounts->Master Data->Preparation of creating vendor master data->Define account groups with screen layout (vendors)

Create Number Range for Account Group (XKN1):

SPRO->SAP Reference IMG->Financial Accounting->Accounts Receivable and Payable->Vendor Accounts->Master Data->Preparation of creating vendor master data->Create number ranges for vendor accounts

Assign Number Range to account groups (OBAS):

SPRO->SAP Reference IMG->Financial Accounting->Accounts Receivable and Payable->Vendor Accounts->Master Data->Preparation of creating vendor master data->Assign Number range to vendor account groups

(31)

VAISHNAVI JINDAM Define Business Partner Number Range:

SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner-

>Basic Settings->Number Ranges and Groupings->Define number ranges

Assign Business Partner Number range to Grouping:

SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner-

>Basic Settings->Number Ranges and Groupings->Define Groupings and assign number ranges

Link Grouping and Account Group:

SPRO->SAP Reference IMG->Cross Application Components->Master Data Synchronization-

>Custom/Vendor integration->Business Partner Settings->Settings for vendor integration->Field assignment for vendor integration->Assign Keys->Define number assignment for direction BP to vendor

****If you want to use same number range for BP and Vendor then Select same number range****

(32)

VAISHNAVI JINDAM Business Partner related paths are captured below

Action Path

Create Account Group (OBD3) SPRO->SAP Reference IMG->Financial

Accounting->Accounts Receivable and Payable-

>Vendor Accounts->Master Data->Preparation of creating vendor master data->Define account groups with screen layout (vendors)

Create Number Range for Account Group (XKN1) SPRO->SAP Reference IMG->Financial

Accounting->Accounts Receivable and Payable-

>Vendor Accounts->Master Data->Preparation of creating vendor master data->Create number ranges for vendor accounts

Assign Number Range to account groups (OBAS) SPRO->SAP Reference IMG->Financial

Accounting->Accounts Receivable and Payable-

>Vendor Accounts->Master Data->Preparation of creating vendor master data->Assign Number range to vendor account groups

Define Business Partner Number Range SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner->Basic Settings->Number Ranges and Groupings->Define number ranges

Assign Business Partner Number range to Grouping

SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner->Basic Settings->Number Ranges and Groupings->Define Groupings and assign number ranges

Link Grouping and Account Group SPRO->SAP Reference IMG->Cross Application Components->Master Data Synchronization-

>Custom/Vendor integration->Business Partner Settings->Settings for vendor integration->Field assignment for vendor integration->Assign Keys-

>Define number assignment for direction BP to vendor

BP Role SPRO->SAP Reference IMG->Cross Application

Components->SAP Business Partner->Business Partner->Basic Settings->Business Partner Roles-

>Define BP Roles

Create customizing view BUSD

If want to make any field as mandatory or optional or hide based for BP role we can do in below path

SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner->Basic Settings->Field Groupings-

>Configure Field Attribute per BP role If we want to select externally we need to select

flexible group and de-select “same number range”

SPRO->SAP Reference IMG->Cross Application Components->Master Data Synchronization-

>Custom/Vendor integration->Business Partner Settings->Settings for vendor integration->Field assignment for vendor integration->Assign Keys-

(33)

VAISHNAVI JINDAM Or else you get the error as below because

different account groups have different number ranges

>Define number assignment for direction BP to vendor

Identification category and type SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner->Basic Settings->identification numbers-

>Define identification Categories

SPRO->SAP Reference IMG->Cross Application Components->SAP Business Partner->Business Partner->Basic Settings->identification numbers-

>Define identification types

Create Partner Roles SPRO->SAP Reference IMG->Material Management->Purchasing->Partner

Determination->Partner Roles->Define Partner Roles

Assign Partner Roles to Account Group SPRO->SAP Reference IMG->Material Management->Purchasing->Partner Determination->Partner Roles->Define Permissible partner roles per account group Define Partner Schema SPRO->SAP Reference IMG->Material

Management->Purchasing->Partner

Determination->Partner settings in supplier master record->Define partner schemas Assign Partner Schema to account groups SPRO->SAP Reference IMG->Material

Management->Purchasing->Partner

Determination->Partner settings in supplier master record->Assign Partner Schemas to account groups

Create another company code in the same as above and the same has been captured below

Action Path

Define Company SPRO-> SAP Reference IMG-

>Enterprise Stricture->Definition-

>Financial Accounting->Edit, Copy, Delete, Check company code

KUSH,RUSH

Define Plant SPRO-> SAP Reference IMG-

>Enterprise Stricture->Definition-

>Logistics-General->Define, Copy, Delete, Check Plant-> Define Plant

PDIL,RDIL

Define Storage Location SPRO-> SAP Reference IMG-

>Enterprise Stricture->Definition-

SB01-RW

SB02-Semi finished SB03- finished

(34)

VAISHNAVI JINDAM

>Material Management-

>Maintain Storage Location RB01-RW

RB02-Semi finished RB03- finished Define Purchase organization SPRO-> SAP Reference IMG-

>Enterprise Stricture->Definition-

>Material Management->

Maintain Purchase Organization

CORG,RORG

Define Purchase Group: SPRO->SAP Reference IMG-

>Material Management-

>Purchasing->Create Purchase Groups

ZPU,RPU

Assign plant to company code SPRO-> SAP Reference IMG-

>Enterprise Stricture-

>Assignment->Logistics general->

Assign plant to company code

PDIL to KUSH RDIL to RUSH

Assign Purchasing Organization to company code

SPRO-> SAP Reference IMG-

>Enterprise Stricture-

>Assignment->Material

Management->Assign Purchasing Organization to company code

CORG to KUSH RORG to RUSH

Maintain Fiscal year variant SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Maintain Fiscal year variant

K4

Assign company code to fiscal year variant

SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Assign company code to fiscal year variant

KUSH to K4 RUSH to K4

Define Variants for open posting periods

SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Define Variants for open posting periods

POST,ROST

Assign Posting Variants to company code

SPRO-> SAP Reference IMG-

>Financial Accounting->Financial

POST to KUSH ROST to RUSH

(35)

VAISHNAVI JINDAM accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Assign Variants to company code

Define Open and Close Posting Periods

SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fiscal year and Posting periods->Posting Periods->Open and Close Posting Periods

Define Field status variants SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fields-

>Define Field status variants

GLFL, RGFL

Assign company code to field status variants

SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Regenerate CDS views and field mapping->Ledgers->Fields-

>Assign company code to field status variants

KUSH to GLFL RUSH to RGFL

Edit Chart of account List SPRO-> SAP Reference IMG-

>Financial Accounting->General Ledger accounting->Master data-

>G/L accounts->Preparation-

>Edit Chart of account List

CHAC

Assign company code to Chart of accounts

SPRO-> SAP Reference IMG-

>Financial Accounting->General Ledger accounting->Master data-

>G/L accounts->Preparation-

>Assign company code to Chart of accounts

KUSH to CHAC RUSH to CHAC

Define Account Group SPRO-> SAP Reference IMG-

>Financial Accounting->General Ledger accounting->Master data-

>G/L accounts->Preparation-

>Define account group

1. RECO-

RECONCILATION A/C per AP/AR

2. MATL-Material Management account 3. INCO-Income

statement account

(36)

VAISHNAVI JINDAM Define Retained Earnings

Account

SPRO-> SAP Reference IMG-

>Financial Accounting->General Ledger accounting->Master data-

>G/L accounts->Preparation-

>Define Retained Earnings Account

Enter global parameters SPRO-> SAP Reference IMG-

>Financial Accounting->Financial accounting global settings-

>Global parameters for company code->Enter global parameters 1. Create Reconciliation

account per AP/PR 2. Create Stock Account 3. Create GR/IR Clearing

account

FS00

Reconciliation-4400 Stock account-5500 GR/IR account-5501

Define Plant parameters SPRO->SAP Reference IMG-

>Material Management-

>Inventory Management and Physical Inventory->Plant Parameters

PDIL,RDIL

Maintain Controlling arear SPRO->SAP Reference IMG-

>Enterprise Structure-

>Definition->Controlling-

>Maintain Controlling Area

ADIL,RDIL

Active Material Ledger account OXM1 CKMSTART Enter current year & month

against company code

OMSY Company Code: KUSH,RUSH

Assignment of material ledger types to valuation area

OMX3 Plant: PDIL

Plant: RDIL

Active Material Ledger

OMX1

Define Material Ledger Type OMX2 Define settings for ledger and

currency types

SPRO->SAP Reference IMG-

>Financial Accounting->Financial Accounting Global Settings-

>Ledgers->Ledger->Define settings for ledger and currency types

Production startup

Set Valuation area as Productive

CKMSTART

Quantity and Value update OMS2

Create material MM01

Create BP BP

Create Purchase Order ME21N Create Goods Receipt MIGO Create invoice Receipt MIRO

(37)

VAISHNAVI JINDAM Give valuation class to WRX,

BSX

OBYC

Define Number Assignment for Accounting Documents

SPRO->SAP Reference IMG->

Material Management-

>Inventory Management and Physical Inventory->Number Assignment->Define Number Assignment for Accounting Documents

Steps to use same G/L account for two different plants belongs to two different company codes are having same Chart of account:

Valuation Area:

The valuation area is an Organizational level at which material valuation is done; the valuation area is defined as

Valuation area= company code

Complete stocks of that particular material in the company code are evaluated together

Valuation area= one plant

Define Valuation area level:

SPRO -> SAP reference IMG->Enterprise Structure->Definition->Logistics general->Define valuation level

Define Valuation Control: (OMWM)

SPRO -> Material Management -> Valuation and Account Assignment -> Account

Determination -> Account Determination Without Wizard->Define Valuation Control

(38)

VAISHNAVI JINDAM

This is required if business is having more than one company code in that we can group

different plant from different Company codes to have same G/L accounts

Group together valuation areas

SPRO -> Material Management -> Valuation and Account Assignment -> Account

Determination -> Account Determination Without Wizard->Group together valuation areas Valuation areas are grouped with the objective of simplifying the management of the standard accounts table by minimizing the number of entries.

Along with other factors, the valuation grouping code determines the G/L Accounts, to which a goods movement is posted (Automatic Account Determination).

The valuation grouping code makes it easier to set the automatic account determination.

Within the chart of accounts, we assigned the same valuation grouping code to the valuation areas.

Since we want to assign to the same G/L account, we assigned the same valuation grouping code to the valuation areas.

I created VAGC Valuation Group Code and assigned it to RDIL and PDIL Plants

RDIL belongs to RUSH CC and PDIL belongs to KUSH CC

(39)

VAISHNAVI JINDAM

Define Valuation Class

SPRO -> Material Management -> Valuation and Account Assignment -> Account Determination -> Account Determination Without Wizard->Define Valuation Class Valuation Class:

The Valuation class is a group of material with the same G/L account/ Group of material having

same account determination is called valuation class.

When you create a material master record, you must assign the material to a valuation class.

The valuation class is assigned to a material at the plant level.

The choices for valuation class are dependent on the material type. In general, several valuation classes can be allowed for one material type. Also, the same valuation class could be allowed for different material types. - The link between the valuation class and the material type is the account category reference. The account category reference is assigned to a material type. - The G/L account determined for the material is carried out according to the settings for its valuation class.

We can group the different materials with the same properties into the valuation calls so that there is no need to control a separate stock account for each material.

All the materials with the same type are assigned to one valuation class.

Various materials with the same material type are assigned to different valuation classes.

(40)

VAISHNAVI JINDAM

Create Account Category reference:

Created Two valuation classes R001 and K001 and assigned to ACR1

Assign ACR to Material Type:

Copy GL accounts from one CC to another CC in FS00 itself

Select Source company code

(41)

VAISHNAVI JINDAM

The reconciliation, stock and GR/PR account are getting copy to RUSH

Select G/L account and click on copy

Mention target company code

In the same way copy all three G/L account

(42)

VAISHNAVI JINDAM

Configure Automatic Postings

SPRO -> Material Management -> Valuation and Account Assignment -> Account

Determination -> Account Determination Without Wizard->Configure Automatic Postings

(43)

VAISHNAVI JINDAM

(44)

VAISHNAVI JINDAM

(45)

VAISHNAVI JINDAM

Created material 4500045562

TCODE: MM60

Created Vendor 100001039

TCODE: LFA1

Created Purchase Order 4500000977

TCODE: EKKO

Goods Receipt posted 5000000521

(46)

VAISHNAVI JINDAM

Invoice Receipt posted

5105600246

PO status

PO History

(47)

VAISHNAVI JINDAM

Thank you for Reading!

References

Related documents

Results in Table 2 summarises the amount of LF quantified in different fractions and the corresponding LP activity. LP activity can be used to gauge the efficiency of

▪ Close to zero latency ▪ Multi-threading SAP® SYSTEM SAP® SYSTEM CLOUD APPLICATIONS EVENT MESSAGING CLOUD APPLICATIONS EVENT MESSAGING IPAAS SOLUTIONS ASAPIO Integration

Media messages had little impact on the prediction of body image or body- change strategies adopted by adolescent boys, with media influencing strategies only to decrease weight and

14 | P a g e These results show that the activities Free Play (subjects where provided with equipment including a Frisbee, football, tennis balls and rackets,

Solution: AVEVA’s Asset Life Cycle Information Management solution; AVEVA’s Control of Work solution; AVEVA Enterprise Asset Management™.. Asset Visualisation

In the unlikely event of the main director being unavailable when training is going ahead, appropriate information about how to organise and run a course is available in the terms

It Ain’t Necessarily So: Checking Charts for Robustness (with A. Lunzer) November 2014 IEEE Vis Conference Paris, France Tools for Teaching Data Science May 2014 Women in