Posting Example Warehouse Concept 4 

Use

The posting example shows the effects of business transactions in the Materials Management (FI) component on the FI G/L accounts and on updating in the Funds Management component.

Prerequisites

The example presupposes certain prerequisites. Please be aware of these prerequisites.

Posting lines that are only statistically updated are flagged in column S (statistical).

Prerequisites for posting example

Settings

For more information, see:

Master data

Material valued with a moving average price

In the SAP Library under Control of Material Valuation.

Assignments for account assignment derivation

Commitment item defined in the G/L account

In the SAP Library under FM Account Assignment Logic and Assignment Commitment Item to G/L Account.

Funds centers are assigned to the cost centers

In the SAP Library under FM Account Assignment Logic and Integration with Cost and Project Controlling.

Customizing settings

Update Profile 100

In the FM IMG under Actual and Commitment Update/Integration ® General Settings ® Assign Update Profile to FM Area.

In the SAP Library under Update Profile.

Account assignment specification: Standard setting (CO assignment and account allocation not binding)

In the FM IMG under Actual and Commitment Update/Integration ® General Settings ® Make Other Settings.

GR/IR updating: MM invoice receipt

Value-added tax display: Gross value-added tax

Control of purchase orders/requisitions not assigned to an account: "Warehouse funds center"

Control goods issue: "Stock allocation statistical"

Transaction types budget relevant? X

In Funds Management (FM) IMG under Actual and Commitment Update/Integration ® Integration ® Inventory Management Integration ® Select transaction types

Transaction goods issue? X

Deductible input tax

In the Financial Accounting IMG under Financial Accounting Global Settings ® Taxes on Sales/Purchases ® Calculation ® Define Tax Codes for Sales and Purchases.

Cash discount posting: GR gross, IR net

In the Financial Accounting IMG under Financial Accounting Global Settings ® Document ® Document Header ® Overview.

 

Warehouse Concept 4

Procurement to warehouse (without account assignment):

Business transaction

FI G/L accounts

Funds Management

Debit

Credit

Funds center

Commitment item

Purchase requisition

   

Warehouse

Commitment item from balance sheet account (without tax)

Purchase orders

   

Warehouse

Commitment item from balance sheet account (without tax)

Goods receipts

always valuated!

Stock

at purchase order price

     
 

GR/IR

   
 

(Freight clearing)

   
 

(Customs clearing)

   

Invoice parking

       

Save invoice completely

   

Warehouse

Commitment item from balance sheet account (without tax)

Invoice receipts

Invoiced amount = Order amount

GR/IR

 

 

Warehouse

Commitment item from balance sheet account

 

Vendor

   

Additional posting lines at invoice receipt if:

Input tax

(Input tax)

 

(Warehouse)

(Commitment item from balance sheet account)

Freight clearing

(Freight clearing)

 

(Warehouse)

(Commitment item from balance sheet account)

Customs clearing

(Customs clearing)

 

(Warehouse)

(Commitment item from balance sheet account)

Invoiced amount > Order amount

(also with unplanned delivery costs) and insufficient stock coverage)

(Stock)

 

(Warehouse)

(Commitment item from balance sheet account)

(Price differences)

 

(Warehouse)

(Commitment item from balance sheet account)

Invoiced amount < Order amount

(also with unplanned delivery costs) and insufficient stock coverage)

 

(Stock)

(Warehouse)

(Commitment item from balance sheet account)

 

(Price differences)

(Warehouse)

(Commitment item from balance sheet account)

Small differences GR/orders to DN)

Small differences

 

Cost center

Expenditure commitment item from small differences account (incl. tax)

 

Small differences

Cost center

Revenue commitment item from small differences account (incl. tax)

Differences due to exchange rate rounding

Differences due to exchange rate rounding

 

Cost center

Expenditure commitment item from differences due to exchange rate rounding account

 

Differences due to exchange rate rounding

Cost center

Revenue commitment item from differences due to exchange rate rounding account

Exchange rate differences

Exchange rate differences

 

Warehouse

Commitment item from balance sheet account

 

Exchange rate differences

Warehouse

Commitment item from balance sheet account

Cash discount (net procedure)

Cash discount clearing

 

 

 

 
 

Stock

Warehouse

Commitment item from balance sheet account

 

Price differences

Warehouse

Commitment item from balance sheet account

Subsequent debit invoice

Subsequent adjustment, no amount change

(Dependent on current stock situation)

(Stock)

 

(Warehouse)

(Commitment item from balance sheet account)

(Price differences)

 

(Warehouse)

(Commitment item from balance sheet account)

(Input tax)

 

(Warehouse)

(Commitment item from balance sheet account)

   

Vendor

 

Credit memo

All postings from invoice receipt and subsequent debit invoice mirror inverted depending on current stock situation.

 

Inventory Management - Goods Issue

Business transaction

FI G/L accounts

Funds Management

Debit

Credit

Funds center

Commitment item

S

Reservations

   

No update: You can, however, manually include an FM account assignment that is then included in the consumption.

Consumption

 

Consumption

 

Cost center

Expenditure commitment item from consumption account

 

 

Stock

Warehouse

Commitment item from balance sheet account

X

Returns from warehouse

 

valuated

Stock

 

Warehouse

Commitment item from balance sheet account

X

 

Consumption

Cost center

Expenditure commitment item from consumption account

 

Inventory

Too much warehouse space

Stock

 

Warehouse

Commitment item from balance sheet account

X

 

Inventory differences

Cost center

Revenue commitment item from inventory differences account

 

Stock shrinkage

Inventory differences

 

Cost center

Expenditure commitment item from invent o ry differences account

 

 

Stock

Warehouse

Commitment item from balance sheet account

X

Scrapping

Damage cases

Expense from scrapping

 

Cost center

Expenditure commitment item from scrapping account

 

 

 

Stock

Warehouse

Commitment item from balance sheet account

X

 

Inventory Management - Stock Transfer

Business transaction

FI G/L accounts

Funds Management

Debit

Credit

Funds center

Commitment item

S

Stock transfer

Receiving standard priced managed material is cheaper

Expense from stock transfer

 

Cost center

Expenditure commitment item from stock transfer account

 

Stock

 

Warehouse

Commitment item from balance sheet account

X

 

Stock

Warehouse

Commitment item from balance sheet account

X

Receiving standard priced managed material is more expensive

Stock

 

Warehouse

Commitment item from balance sheet account

X

 

Stock

Warehouse

Commitment item from balance sheet account

X

 

Revenue from stock transfer

Cost center

Revenue commitment item from stock transfer account

 

 

Inventory Management - Revaluation

Business transaction

FI G/L accounts

Funds Management

Debit

Credit

Funds center

Commitment item

S

Revaluation

Valuation price is too low

Stock

 

Warehouse

Commitment item from balance sheet account

X

 

Revenue from revaluation

Cost center

Revenue commitment item from revaluation account

 

Valuation price is too high

Expense from revaluation

 

Cost center

Expenditure commitment item from revaluation account

 
 

Stock

Warehouse

Commitment item from balance sheet account

X