Google
 

Friday, December 31, 2010

SAP Account Payable

  1. Accounts Payable

  1. Define Acct group with screen layout (Vendors)
  • Tcode: OBD3
  • Explanation:
  • When creating a vendor master need to specify vendor account group
  • Vendor account group determine:
    • Vendor account number
    • vendor number is assigned or externally by the user
    • Whether it's a onetime account
    • Which fields are ready for input when creating & changing customer master (Field status)






  1. Enter Accounting clerk identification code for customers
  • Tcode: SPRO – FA – ARAP – CA – MR – Preparation for creating customer master record – Enter accounting clerk identification code
  • Data: 01 (Mohit)
  • Explanation:
    • Enter identification code (01) & clerk name (Mohit) for a company code (100)
    • Code entered in customer master record
    • Helpful in evaluation






  1. Define Industries
  • Tcode: Tcode: SPRO – FA – ARAP – CA – MR – Preparation for creating customer master record – Define industries
  • Explanation:
    • Define industry
    • Specify what industry a business partner belongs to by entering industry key in customer master record.
    • Helpful in evaluation, e.g. generate customer list for a industry




  1. Vendor Match Codes
  • Tcode: OB50
  • Path: FA- AR/AP – Vendor a/c – Master Data – Match codes – Maintain match codes for vendor
  • Explanation:
    • Match codes used to find vendor in the database
    • Can define our own match codes


  1. Extending Vendors to Additional Company codes:
  • Tcode: FK15 (if same client)
  • Tcode: FK15 + FK16 (if different client)
  • Explanation
    • Multiple company code scenarios. Some vendors shared by company codes. Need to extend a vendor say existing in 730 to company code 766






  1. Define Sensitive fields
  • Sensitive fields like vendor bank details. Changes to these fields should be confirmed by another user
  • Confirmation of vendor master changes: FK08 and FK09
  • Path: FA – AR/AP – Vendor a/c – Master data – Preparation for creating vendor master data






  1. Payment Block Reasons for Vendor Invoices
  • Path: FA-AR/AP – BT- OP- OP Global settings – Payment block reasons
  • Explanation:
    • Vendor invoices can be blocked for payment. Here we define reason for blocking vendor invoices for payment
    • To block Invoice : FB02







  1. Payment block on a Vendor invoice by Payment terms
  • Path: FA – AR/AP – BT – OP – OPGS – Payment block reasons – Define default values for payment block




  1. Release vendor Invoices blocked for payment
  • Tcode: MRBR




  1. Create number range for vendor accts
  • Tcode: XKN1
  • Explanation:
    • Can create internal or external number range.
    • Internal : System automatically allot the number
    • External: User assigns the number in the specified range.






  1. Assign number range to Vendor Acct group
  • Tcode: OBAS
  • Explanation:
    • We assign number ranges created in (XKN1) to vendor account group (OBD3). Thus vendor number for this vendor a/c group can be selected from this range






  1. Delete Vendor / Customer Master Data
  • Tcode: OBR2
  • Explanation:
    • Used to delete customer master data
    • Can be deleted only for company codes not flagged as productive
    • Can delete customer master record only if no transaction exists in it





     
  1. Maintain terms of Payment for vendors and customers
  • Tcode: SPRO-FA-AR/AP-BT-Out going Invoices-Maintain Terms of Payment
  • Tcode: OBB8
  • Explanation:
    • Payment term assign to Vendor master record
    • Payment term proposed when entering a vendor document
    • E.g.: 60 days, 5% cash discount if paid in 30 days
    • Can also define default payment block for some payment terms



     


  1. Define terms of payment for installment payment
  • Tcode: OBB9
  • Tcode: SPRO-FA-AR/AP-BT-Out going Invoices-Maintain Terms of Payment
  • Explanation:
    • Installment payment to vendor invoice.
    • Define three terms of payment in (maintain terms of payment). Now map two of them to one of them in OBB9

     


  1. Define Accts for cash discount taken
  • Tcode: OBXU
  • Tcode : SPRO-FA-AR/AP-BT-Out going Invoices-Define cash discount base for outgoing Invoices
  • Tcode: Cash discount granted: OBXI
  • Explanation
    • Cash discount received from vendors posted here






  1. Define Accts for exchange rate diff
  • Tcode: OB09




  1. Define Accts for rounding differences
  • Tcode: OB00




  1. Define acct for bank charges (vendors)
  • Tcode: OBXK






  1. Define acct for payment diff ( manual outgoing)
  • Tcode: OBXL






  1. Down Payment Made to vendors
  • Configure Down Payment made to vendor: OBYR / FBKP
  • Vendor Down payment Request: F-47
  • Post Vendor Down Payment: F-48
  • Post Non PO Vendor invoice : FB60
  • Clear Vendor Down payment : F-54





  1. Duplicate Invoice Check
  • Tcode: SPRO – MM – LIV – Incoming Income – Set check for duplicate Invoice





  1. Creating a vendor master Record
  • Create Vendor Master: FK01
  • Transfer customer/ Vendor master data from source company code to target company code: SE38 - RFBIDE10/RFBIKR10
  • Display changes to customer / vendor master data: SE38- RFDABL00 or RFKABL00
  • Find duplicate customer master data: SE38 - RFDKAG00
  • Find duplicate vendor master data: SE38- RFKKAG00
  • Create vendor master record centrally : XK01
  • Change Vendor Master record: XK02
  • Display Vendor Master record: XK03
  • Block /Unblock Vendor Master : XK05
  • Mark vendor for deletion (Deleted by a special program) : XK06
  • Explanation << Refer TFIN notes>>
  • Account Group:
  • While creating customer / vendor we have to provide account group. Account group controls:
    • Number range of the accounts
    • Status of the fields in the master records
    • If the account is a onetime account
  • If a customer is also a vendor the APP and the dunning program can clear open items against each other. For this :
    • Enter the vendor account number in the customer account, or vice versa.
    • Select the field clearing with customer / vendor






Previous AcctLegacy system acct number
Sort KeyAssignment field value
Tolerance GroupTolerances with in which this vendor can transact
Payment MethodMethod by which this vendor accept payment




  1. Post Non PO based Vendor Invoice
  • Tcode: FB60
  • Explanation:
    • To post no PO based vendor invoices








  1. Post Manual Payment to Vendor and not generate payment media (iDoc, check)
  • Tcode: F-53
  • Explanation:
    • Vendor outstanding invoices are paid in APP (F110). Some invoice not paid can be paid manually in Tcode F-53








  1. Displaying Vendor Account balance
  • Tcode: FK10N
  • Explanation:
    • To display vendor a/c balance






  1. Displaying / Releasing Vendor Invoices
  • Tcode: FBL1N
  • Explanation:
    • To display vendor a/c line items, Invoices, credit memos, payments etc
    • In SAP we can block / release documents for payments
    • Block invoice for payment @ FB60. Release invoice for payment FBL1N. Double click invoice - click to change mode - remove payment block






  1. Automatic Payment Program (Incoming & Outgoing Payments)
  • Tcode: F110
  • Explanation:
  • << Refer TFIN>>


I have tested the proposed configuration change, please find below my findings:

Option 1:

Payment MethodHouse bankRankingCurrencyComments
IHSB211EURFor payment method I all EURO payments from HSB21
IHSB222BlankFor payment method I, all payments other than EURO from HSB22
IHSB233USDFor payment method I, USD payments from HSB22






  1. Define Number Range for Checks
  • Tcode: FA(N) – AR/ AP – BT – Outgoing Payments – Automatic outgoing payments – Payment Media – Check Management
  • Explanation:
    • Can think of each check lot as a Check Book






  1. Manual Clearing of Vendor open Items
  • Tcode: F-44
  • Explanation:
    • Manually clear vendor documents ( Invoice, Credit Memos etc)
    • Double click & deselect all - Select 2/more documents to be cleared. - Save
    • No real posting but a clearing document is created






  1. Display Purchase Order
  • Tcode: ME23N
  • Change PO : ZMMME22 or ME22N
  • Search for a PO : ME2B





  1. PO-based Vendor invoice/credit memo/Planned Delivery Cost
  • Tcode: MIRO
  • Explanation:
    • You enter the data from the vendor invoice in the system. As you do this, you compare the data with the suggested quantities and values for each item. If differences occur, you make any necessary corrections
    • Planned Delivery Costs are costs incurred over and above the cost of the material and include such costs as freight, handling and customs duties. Costs will be classified into categories posted to a separate GL account - Freight and Customs Duties, for example. Planned delivery costs have the advantage that delivery costs are included in the valuation of the material at time of Goods Receipt.
    • In PO Reference select: + Planned Delivery cost
    • A Credit Memo is received from a trade vendor and the Credit Memo is posted with reference to a Purchase Order and serves as a cancellation of the Invoice Receipt. Posting a credit memo always leads to a debit posting on the vendor account. When you post a credit memo, the total quantity in the purchase order history is reduced by the credit memo quantity.
    • Imp: Select Credit Memo on transaction drop down box on top of screen
  • Display/Change PO-Based Vendor Document : MIR4
  • Park Invoice: MIR7




S_ALR_87009895VAT ReportUse this SAP transaction to view VAT reporting and to post VAT settlement.

Transaction is run at month end after transactions have been completed. When settlement is run the balances of the 11005001 output tax and 22010000 input tax accounts are zeroed out and the balance of each is moved to the 12600000 VAT Settlement account.
SM35 Batch Input MonitoringUse this SAP transaction to monitor and process batch input sessions to post all the applicable documents and perform all the database updates.



 

SAP_Asset Accounting



  1. Asset Accounting
  1. SAP Asset Accounting Configuration


Copy Reference Chart of DepreciationOAP1
Change Name of Chart of Depreciation

Delete Depreciation Areas not needed
OAP1
Assign chart of Depreciation to Company codeOAB1
Specify number assignment across company codes (optional)AO11
Specify Account Determination

Explanation : Enter account determination key & it's description
Tcode: SPRO – FA(N)- AA – Org structure – Asset Classes – Specify account determination
Create Screen Layout RuleTcode : SPRO – FA(N) –AA – Org Structure – Asset Class – Create screen layout rule
Define screen Layout rule for Asset Master Data

Explanation : Screen layout defined for each key created in earlier step
Tcode: OA77
Define Asset Number Range IntervalAS08
Asset Class

Explanation:

  • Asset Class defined at client level
  • They apply to all company codes
  • Assign: Account Determination, Screen Layout rule, Number Range Assignment, Whether AC is blocked
Tcode : OAOA
Define Depreciation Areas

Explanation: Define type of value managed for acquition / net book value. Some options only +ve value / zero allowed etc
Tcode: SPRO – FA(N) – AA- Valuation – Depreciation areas – Define Depreciation Areas
Specify transfer of APC ( Acquition & Production cost) values

Explanation: Transfer asset values from specified depreciation area to another depreciation area
Tcode : OABC
Specify Transfer of Depreciation TermsTcode: OABD
Determine Depreciation Term for the Asset Class

Explanation: Determine depreciation terms ( Depreciation Key + Useful Life + Screen Layout rule) for the Asset Class
Tcode : OAYZ
Deactivate Asset Class at client LevelTcode: AM05
Define how depreciation areas post to GL

Explanation: Options:

  1. Depreciation post to GL a/c in real time
  2. No depreciation posted to GL
  3. Post Depreciation & APPC periodically
  4. Post depreciation only
Tcode: SPRO – FA(N) – AA – Integration with GL – Define how depreciation areas post to GL
Maintain Depreciation Key

Activate Account assignment objects
Tcode: SPRO- FA(N) – AA – Integration with GL – Additional account assignment activate account assignment objects
Specify Account assignment typeACSET
Assign GL accountTcode: AO90




  1. Copy reference chart of depreciation
  • Tcode: EC08
  • Explanation:
    • COD is a list of depreciation areas
    • COD must be assigned to a company code
    • SAP provides ref. COD which we need to copy & create our own COD
    • Can delete depreciation areas not used








  1. Specify description of chart of depreciation
  • Tcode: SPRO-FA - AA-Org structure-Copy Ref. COD










  1. Copy / Delete Depreciation areas
  • Tcode: SPRO-FA- AA-Org structure-Copy ref. COD
  • Explanation:
    • Delete unwanted depreciation areas






  1. Assign Input tax indicator for Non taxable acquition
  • Tcode: OBCL
  • Explanation:
    • Assign input tax indicator to company code. System uses the indicator for non taxable transactions ( asset acquit ion) posted to taxable a/c








  1. Assign Chart of Depreciation to Company code
  • Tcode: OAOB








  1. Specify Account Determination
  • Tcode: SPRO-FA-AA-Org. Structure-Asset Classes-Specify a/c determination
  • Explanation:<< Refer TFIN>>
    • Account determination link an Asset Master Record to the GL using the Asset class




  1. Create screen layout rule
  • Tcode: SPRO-FA-AA-Org structure-Asset Classes-Create Screen layout rules
  • Explanation:
    • Screen layout rules determine fields to be displayed ( required/ optional/hidden) in AMR




  1. Define Asset number range interval
  • Tcode: AS08




  1. Define Asset Classes
  • Tcode: OAOA
  • Explanation: << Refer TFIN>>
    • Every asset to be assigned to exactly one Asset Class






  1. Integration with GL
  • Tcode: SPRO-FA-AA-Integration with GL-Define how depreciation areas post to GL
  • Explanation:
    • System can post APC (Acquition & Production Cost) of one depreciation area online. Usually this is Book Dep. 01
    • Transactions from other depreciation areas can be posted periodically to GL if required






  1. Assign G/L accounts
  • Tcode: A090
  • Explanation: << Refer TFIN>>








  1. Specify financial statement versions for asset reports
  • Tcode: OAYN






  1. Specify Document Type for Posting of Depreciation
  • Tcode: AO71
  • Explanation:
    • Standard doc. type AF is used for depreciation posting
    • <, Refer TFIN>>








  1. Specify intervals & posting rules
  • Tcode: OAYR
  • Explanation:
    • Define how often ( monthly, quarterly, semi annually, annually) depreciation is posted
    • Account Assignment (Cost Center Posting …) rule for the depreciation posting run








  1. Define depreciation areas
  • Tcode: SPRO-FA-AA-Valuation-Depreciation Areas- Define Depreciation areas
  • Explanation:
    • As COD is copied. Depreciation areas defined in COD are used






  1. Specify transfer of APC values
  • Tcode: OABC
  • Explanation:
    • In this field, you specify the reference depreciation area that provides values to another depreciation area. The system transfers the posting amounts of any transactions that affect acquisition and production costs from this area to the dependent area. A depreciation area can only adopt values from an area which has a smaller key than itself. No transfer is therefore possible to area 01








  1. Determine Depreciation areas in the Asset class
  • Tcode: OAYZ
  • Explanation:
    • << Refer TFIN>>






  1. Specify Memo Value
  • Tcode: OAYI
  • Explanation:
    • Here define memo value for each dep area / company code
    • Memo value is the amount that is not depreciated to have value of an asset that has exceeded its useful life
    • Memo value activated by an indicator in the asset class
    • Memo value ensure fully depreciated assets with NBU of zero are shown in all legal reports






  1. Specify asset classes which will not take memo value into account
  • Tcode: OAAW








  1. Define Depreciation Area currency
  • Tcode: OAYH






  1. Calculation sequence for depreciation
  • Tcode: AOBK
  • Explanation:






  1. Unplanned Depreciation
  • Tcode: OABU
  • Explanation:
    • Specify depreciation areas where unplanned depreciation can be allowed








  1. Define base method
  • Tcode: SPRO-FA-AA-Dep-Valuation Method-Dep Key- Calculation Method- Define base Method / Define declining balance method / Define Maximum amount method / Define multilevel method / Period Control Method
  • Tcode : AFAMP
  • Explanation:
    • Define declining balance method.
    • Assign declining balance method to the depreciation keys










  1. Maintain depreciation key
  • Tcode: AFAMA
  • Explanation:
    • <<Refer TFIN>>






  1. Assign Accounts
  • Tcode: AO99








  1. Asset Accounting:
  • Create Asset: AS01
  • Explanation:
    • General Master Data: This part of the master record contains concrete information about the fixed asset.
    • Data for Calculating Asset Values: You can specify depreciation terms in the asset master record for each depreciation area in the chart of depreciation.
    • Use the reference field if you'd like to create an asset master record that is similar to another asset master record.
    • Number of similar assets; this function enables you to create multiple similar assets in one master transaction. These assets initially differ from each other only by their main and/or sub-number
    • Capitalized on: This date is the default for the asset value date when the first acquisition is posted




  1. Change AMR : AS02
  • Explanation:
    • To change asset master record created in AS01
    • To update asset scrap value
    • No depreciation calculation during asset shut down: Click time dependent data - Select asset shutdown- click further intervals – click new intervals – Back & save. To re- commission the asset - simply repeat the above step entering the date for the recommencement of asset and deactivate the shutdown before saving. Accordingly the depreciation will not be calculated from the period between the date of the first interval and the date of the second interval






  • Display AMR : AS03






  • Lock AMR : AS05
  • Explanation:
    • Set this indicator, if you want to prevent further acquisitions from being posted to this asset. Once the blocking indicator is set, you can no longer post acquisitions to this asset. Asset transfers and asset retirement postings to blocked fixed assets are still possible.






  • Delete AMR : AS06
  • Explanation:
    • You can delete an asset master record to which no postings have been made.










  • Create Sub Asset : AS11
  • Explanation:
    • The main asset number represents the asset as a whole. Parts of assets can be represented by different sub-numbers






  • Create Group Asset Master Record: AS21




  • Asset Explorer : AW01N
  • Explanation:
    • This function shows all the values of a fixed asset. Planned values are displayed, as well as values already posted
  • Choose the pushbutton above the overview tree, to reach the display transaction for asset master data.
  • To navigate between depreciation areas in the overview tree, select the depreciation area you want. Icons indicate the type of depreciation area. The icon indicates a real depreciation area, and the icon indicates a derived depreciation area.
  • Select a transaction line (bottom of screen) and choose display FI document in order to see the associated document in Financial Accounting. In the financial document, using menu option Environment ® Original Document you will see the purchase order that was used to purchase the asset.


NoteThe Parameters tab page contains information such as the depreciation key, useful life and index specifications used.


Note: More Functions:
You can use Call asset reports (for example, asset list, asset history sheet).
You can choose Translate currency amounts to have the system translate currencies. If you call reports in Asset Accounting after using this function, the reports are displayed in the currency you selected.






  • Create Down Payment for Asset: F-48
  • Explanation:
    • Posting the down payment.
    • Posting the corresponding closing invoice
    • Clearing the down payment with the closing invoice






  • Asset Acquition from Vendor : F-90

     




  • Asset acquit ion with automatic offsetting entry : ABZON
    • Explanation: << Check Top Jobs>>



       
  • Asset Retirement with revenue to customers : F-92



     
  • Retirement with Revenue without Customer : ABAON



     
  • Retirement due to Asset Scrapping : ABAVN

     
  • Intracompany Transfers : ABUMN
    • Explanation: There are basically three reasons why you might need to carry out an Intracompany transfer within a company code. One reason is if changes are made to organizational structures (reclassification of asset classes, changes to business areas or profit centers, and so on). Second, an Intracompany transfer might be necessary if account assignments are incorrect (for example, incorrect asset class).



       
  • Post the Post-Capitalization : ABNAN
    • Explanation: Post-capitalization represents subsequent corrections to the acquisition and production costs (APC) of a fixed asset. An example of when you need this type of correction is if you neglect to add expenditures and costs linked with the acquisition or assembly of an asset to its APC in a fiscal year that is now closed. This example can apply to both part assets and entire complex fixed assets








  1. Write-Ups
  • Tcode: ABZU
Explanation: A write-up is generally understood to be a subsequent change to the valuation of an asset (reversal of depreciation). Write-ups increase the book value of a fixed asse