Tuesday, August 7, 2018

Accounting Entries during Goods Receipt and Invoice Receipt


Standard PO:

During GR (MIGO)                                              
     (BSX) RM Stock Account                          DR      10000.00
     (WRX) GR/IR Clearing A/c                       CR       9000.00
     (FR1) Freight Clearing A/c                      CR       1000.00
                                          
During IR (MIRO)                                      
     GR/IR Clearing A/c                                DR      9000.00
     Freight Clearing A/c                              DR      1000.00
     VAT Receivable A/c                               DR        360.00
     Vendor Account                                     CR    10360.00

Subcontracting PO:

During GR (MIGO)                                              
     (BSX) Assembly Stock A/c                        DR      5000.00
     (BSV) Change in Stock A/c                       CR      5000.00
     (FRL) Subcontracting Charges A/c            DR      1000.00
     (GBB-VBO) GR/IR Clearing A/c                 CR      1000.00
     (GBB-VBR) Component Consumption A/c  DR      4000.00
     (BSX) Component Stock A/c                     CR      4000.00
                                          
During IR (MIRO)                                      
     GR/IR Clearing A/c                                 DR      1000.00
     Vendor Account                                      CR      1000.00


Consignment PO:

During GR (MIGO)                                              
     No FI Entry will be generated during GR                               
                                          
During TP (MIGO)         Transfer to own Stock (Qty = 10)                            
    
     (BSX) Stock Account                               DR      1000.00
     (KON-Blank) Consignment Liability A/c   CR      1000.00
                                          
During GI (MIGO)          GI from Consignment Stock (Qty = 10)                               
     (GBB-VBR) Consumption Account             DR      1000.00
     (KON-Blank) Consignment Liability A/c    CR      1000.00
                                          
During IR (MRKO)                                               
     Consignment Liability A/c                       DR      1000.00
     Vendor Account                                      CR      1000.00

Pipeline PO:

No PO and No GR

During GI (MIGO)          GI from Pipeline Stock (Qty = 10)                                     
     (GBB-VBR) Consumption Account             DR      1000.00
     (KON-PIP) Pipeline Liability A/c               CR      1000.00
                                          
During IR (MRKO)                                               
     Pipeline Liability A/c                               DR      1000.00
     Vendor Account                                       CR      1000.00


Asset PO:

During GR (MIGO)                                              
     (Asset Accounting) Capital WIP A/c          DR      100000.00
     (WRX) GR/IR Clearing A/c                        CR      100000.00
                                          
During IR (MIRO)                                      
     GR/IR Clearing A/c                                 DR      100000.00
     Vendor Account                                      CR      100000.00


Service PO:

During SES (ML81N)                                           
     (GBB-VBR) Service Expense A/c               DR      10000.00
     (WRX) GR/IR Clearing A/c                       CR      10000.00
                                          
During IR (MIRO)                                      
     GR/IR Clearing A/c                                 DR      10000.00
     Service Tax Receivable A/c                     DR       1200.00
     Service Tax Receivable A/c                     DR          24.00
     Service Tax Receivable A/c                     DR          12.00
     Vendor Account                                      CR     11236.00

SAP MM Consignment Procurement Process / Vendor Consignment Process


Vendor Consignment
Vendor Consignment is a process wherein the supplier provides materials and stocks them in the purchaser’s premises.
 The material remains in the books of the supplier (vendor) until the same is withdrawn from the stock of the consignment and put to use.
The inventory gets transferred to the books of the purchaser only when the same is removed from the consignment stock.
The supplier (vendor) would not invoice the purchaser initially when they come into the premises of the purchaser. The purchaser is liable to pay the supplier (Vendor) only when the stock is withdrawn (consumed).
Key Points of Vendor Consignment process in SAP
        
Ø  Consignment has been designed as a special procurement type in SAP
Ø  The consignment stock is not valuated till the time it is consumed or withdrawn, since theoretically, it lies in the books of the supplier (Vendor)
Ø  The consignment material number is the same as that of a material in unrestricted stock in the purchaser’s books
Ø  Since the sourcing of a material can happen from multiple parties, the consignment stock is maintained at the level of each supplier or vendor.
Ø  The price of the consignment is maintained in the purchasing info records (PIR) of the info category, Consignment
Ø  When the withdrawal happens from the consignment stock of a supplier, the goods receipt in the purchaser’s books happens at the price maintained in the purchasing info records of type consignment for that vendor and material combination.
Ø  The goods receipt against a consignment purchase order is always non valuated
        
    Basic Configuration Steps for Vendor Consignment Process in SAP
      1. Activate Purchasing Info Record for Info category as Consignment. The Configuration transaction code for the same is OMEV.

      2.  Configure the special procurement type 10. This is done in IMG Node:
IMG>Production>Material Requirement Planning>Master Data>Define Special Procurement Type
3. Assign the special procurement type in the material master. The Master Data transaction code for the same is MM02. This is done in MRP2 view of the material master. This is optional.

4. Create a purchasing info record (PIR) of the category, Consignment. This is done using the transaction code ME11.This is mandatory.


1.      5. Maintain Output Condition Records for Output type KONS with Transaction Code MRM1

6. Maintain the automatic account assignment for material posting. The below transaction need to be maintained in the configuration transaction code OBYC. This is Mandatory.
         a. Consignment Payables: KON
         b. Expense/Revenue from Consignment Material Consumption: AKO
         c. Offsetting entry for Inventory Posting: GBB – VBR




Consignment Process Steps in SAP
The consignment process steps in SAP are fairly simple. It involves creating a purchase order, doing a good receipt and a withdrawal of the stock from Vendor’s books. The last step in the consignment process for a vendor is the settlement of the vendor’s liability. The steps are highlighted as:

1.      Procurement
Create a Purchase Info Record for Material Vendor combination (ME11) with info category as consignment.
Create a Purchase Order with Item Category as “K” for consignment item. This ensures that a Goods Receipt to this purchase order results in vendor consignment stock and an invoice cannot be posted based on Goods Receipt alone. The net price of the PO is usually zero.
Goods Receipt based on the purchase order is done using the standard transaction code MIGO.
The stock is posted as consignment stock without value. The same would reflect as a special stock for the vendor.



The stock can be either,
1. Unrestricted-use stock
2. Quality inspection stock
3. Blocked stock

     Since the material lies in the purchaser’s premises, the same would be reflected in terms of quantity at a storage location as well till the time the same is consumed for use.
    The same can be checked in the standard stock reports in transaction code like MMBE and    MB54 – Display Consignment Stocks

     There is no accounting document which is created when the GRN is done in case of a consumption purchase order.


2.      Consumption – Consumption of consignment material happens when goods issue is done with item category K.
 The price at which the goods issue will be done will be picked from the purchasing info record which has been created for consignment for the material and vendor combination.

 In this particular case, to elaborate the process a production order was created and a goods issue was done with the item category K against the production order. Generally the consignment materials are part of Bill of Materials (BOM).

Goods issue document is posted in such a case when activity confirmation is done for the production order through transaction code CO15.


     In the above case, the price is picked from the purchasing info record which would have been created for the material and vendor combination.

3.  Settlement – The next step in the vendor consignment process is the settlement of the vendor liability. This is done through transaction code MRKO

     This would display the withdrawals from the consignment stock which have taken place and for which the liability for the vendor has not been created. You also have the option to check the accounting entries for the withdrawals for consumption made from the consignment stock for a vendor.


     After analysing the unsettled withdrawals, you can create the vendor liabilities by selecting Settle from the main screen. This will settle the outstanding entry in Consignment Account Payables account and create a vendor liability. The price of vendor liability creation will happen at the Info Record Price.
     Accounting Entries
 1. At the time of Goods Receipt – No Accounting entries are generated at the time of goods receipt
 2. Transfer the Consignment Stock to own stock- Transfer Posting –411 K –T Code MIGO-Transfer Posting
Consignment Payable A/c  CR     (Account Assignment OBYC-KON)
Stock Account –BSX – Debit

 3. At the time of Withdrawal or Consumption of Consignment Stock –

 (a)     The material is valuated at moving average Price     (Price Control in Material Master is “V”)

                          Consumption Account DR            (Account Assignment OBYC-GBB-VBR)
                         To Consignment Payable A/c       (Account Assignment OBYC-KON)
               The unit value of material comes from the Info record Price for material vendor combination for info category Consignment
(b)   The material is valuated at standard price (Price Control in Material master is “S)

                     Consumption A/c DR                                   (Account Assignment OBYC-GBB-VBR)
                      To Consignment Payable A/c                     (Account Assignment OBYC-KON)
                      Price Difference A/c (Dr/Cr)                        (Account Assignment OBYC-AKO)
Note:
Ø  An alternate way to SAP transaction flow could be when Goods Receipt is made without reference to a purchase order using movement type 501 K.
Ø  Material can also be issued to a cost center directly instead of a 2 step process of withdrawal and then issue to a cost center. The Movement type would be 201 K. Refer Goods Issue from Inventory to Cost Center (Manufacturing Consumption)

Ø  An accounting document is generated only during stock withdrawal. The price is picked up from Consignment Info Record. During Goods Receipt no accounting document is generated.



Monday, August 6, 2018

Difference between PB00 and PBXX condition types

PB00 - This condition is determined via access sequence from info record or contract or Schedule Agreement(SA) or Request for Quotation (RFQ) etc.
means if any record for material and vendor is defined then system will search that record first and pull the price of PB00 in the PO
PBXX - if you have not defined any info or contract etc then system will suggest PBXX in PO so you can manually enter the price for PO.

Major Difference between PB00 and PBXX
1. Condition maintained in PB00 is time dependent whereas PBXX is time independent.2. Condition type PB00 – used for IR, RFQ, Contract, Schedule Agreement    Condition type PBXX – used for PO.

Some Standard Conditions:
PB00  Gross Price (info record, contract, scheduled Agreement)
PBXX Gross Price (PO)
FRA1  Freight
RA00  Discount on net
RA01  Discount on Gross
ZA00  Surcharge on net
SKT0  Surcharge / discount
ZPB0  Rebates
MWVS Input Tax
MWAS Output Tax
BASB Base Amount
RM0000 Calculation Schema or Pricing Procedure (PB00 & PBXX)
RM0002 Calculation Schema or Pricing Procedure (PB00)

Business scenarios where allowing negative stock in SAP

  Here are the primary business scenarios where allowing negative stock can be justified: Backflushing in Production (Especially in...