SAP FAQ: SAP FI

Showing posts with label SAP FI. Show all posts

SAP - FI AR : Configuration of Dunning - Customer / Vendor

SAP Dunning, which is mainly used in processing of collecting the customer payments.

Sometimes your business partners may fall behind on payments. You can send them a payment reminder or a dunning notice to remind them of their outstanding debts. The R/3 System allows you to dun business partners automatically. The system duns the open items from business partner accounts in which the overdue items create a debit balance.

The dunning program selects the overdue open items, determines the dunning level of the account in question, and creates a dunning notice. It then saves the dunning data created for the items and accounts affected.

You can use the dunning program to dun both customers and vendors. It may be necessary to dun a vendor if he or she has a debit balance as a result of a credit memo. If a customer is also a vendor, you can offset the account balances against one another.

Click on Dunning for downloading the "Configuration of Dunning - Customer / Vendor"

Points for ECC 6.0 FI Certification - NEW GL

1. Possibilities with New GL:

· Legal and Management Reporting

· Extensibility (extended data structure by default - with customer fields)

· Account Balancing with Any characteristics

· Simple Mapping of Parallel Valuation (possible to manage multiple "books" (->ledgers)

· Reduction of TCO

· Transparency and Uniformity

· Segment Reporting (with online document split in real time)

· Real-Time Integration CO=>FI (time consuming recon activities omitted)

2. Above possibilities not available in Classic GL

3. Do I have to use the new GL

· Optional: for existing SAP customers – during upgrade Classic GL (GLT0) remains active at first

· For initial installations New GL Ledger is active by default in mySAP ERP

4. Activating the NGL Accounting:

· Automatic in initial installation

· It is at client level – applicable across all CC'

· TCODE: FAGL_ACTIVATION

· Result in system-wide changes to the easy access menu and screen and customizing paths

· Conventional Financial Accounting paths will initially remain available – can hide with program RFAGL_SWAP_IMG_OLD

5. Ledger Definition:

· SAP provides leading ledger "0L" and summary table – FAGLFLEXT with the standard system

· Leading ledger gets many of its control parameters from the CC – automatically comes to LL

· LL manages additional local currencies & FYV & PPV which are assigned to CC

· There is exactly only one leading ledger

· Only the values from LL are posted on to CO in standard system

· Addition to LL, you can define other non-leading ledger

· You can assign different alternate currencies &/ FYV, PPV to NLL

6. Summary / Total Table:

· Every reporting is from this table only

· It has extended database

· New GL Total Table (FAGLFLEXT) updates more char/data than the Classic GL Total Table (GLT0)

· New standard fields included:

i. CC

ii. PC

iii. Segment

· It can extended with additional fields – both predefine SAP fields and entirely new fields

· To add this – have to add to account assignment block

· Extending the block will lock out all other transactions

7. Scenarios – Definition and Assignment:

· Scenario defines which fields are updated in the ledgers (in GL view) during a posting (from other application component)

· Scenario provided by SAP:

i. Cost center update - FIN_CCA - sender & receiver CC

ii. Preparation for consolidation - FIN_CONS - consolidation transaction type & trading partner

iii. Business area - FIN_GSBER - sender & receiver BA

iv. Profit center update - FIN_PCA - PC & Partner PC

v. Segmentation - FIN_SEGM - segment, partner segment & PC fields

vi. COS accounting - FIN_UKV - sender & receiver FA

· Scenarios should be associated with the types of Ledgers (LL, NLL (N1), NLL (N2))

· Scenarios available in customizing - provided scenarios assigned to ledgers in customizing

· A ledger (LL) can be assigned one or more scenarios, or even all six at once

· Can not define your own scenarios

· Scenarios do not have to be assigned to non-leading ledgers

· You do not need one ledger for each scenario

· Multiple/non-leading ledgers are useful for modeling different accounting rules

· Values recorded in non-leading ledgers not record in CO module

· If you don't assign scenarios to a ledger (or to multiple ledgers) - segment B/S will not be possible

8. Entry View and GL View:

· When NGL active Financial accounting document always has two views

· You can also see the document in NLL in GL view

· Entry: view of how a document also appears in the sub ledger views / sub ledgers (AR/AP/AA/Taxes)

· General: view of how a document only appears in GL - only for GL and not for sub ledgers

9. S – A & F' I:

· In general, nothing has changed regarding the entry of the documents

· Dependencies have also remained:

i. Expense account is defined as primary cost element in CO and therefore requires a CO relevant account assignment during entry

ii. CO object is used to derive PC and FA

iii. Now new with ERP: A segment can now be derived from PC

10. S – A & F' II:

· If corresponding scenario not assigned – no entities are inherited to GL (neither LL / NLL)

· Effects of missing scenario will be like – if you call up B/S you can see the amount in exp account – but the same not allocated to scenarios – so segment B/S not possible

11. S – A & F' II:

· Scenario assignment is not capable of creating a "zero balance position" for any given entity – because all the terms not passed to all the line items so segment B/S not possible – this function can be possible using the document splitting with active inheritance

12. Use of segment entity:

· Segment field is one of the standard account assignment objects available in mySAP ERP to run analyses for "objects" below CC Level.

· Objective is to give a detail look at the various business activities- segment reporting - IAS14

· BA / PC can be used as alternatives – segment is in addition to BA & PC

13. Deriving a segment:

· Segment assigned in the PC Master record

· Segment posted automatically when PC posted

· There is no "dummy segment posting"

· If the PC does not have a segment, there is no segment account assignment either

· Default is derive segment from profit center – using BAdI , customer can develop their own derivation solutions

· BAdI : FAGL_DERIVE_SEGMENT

14. To post, analyze, and display document segments in NGL you have to perform below activities:

· Definition of the segment

· Derivation of the segment - from PC

· Maintain the FSV & FSG of corresponding FI doc - make 'segment' field to 'optional entry'

· Maintain the field status of the posting key - " "

· Display the segment field using layout in the document display

· Define the scenarios : scenarios has to be defined for LL - if not segment will only be visible in entry view

15. Document Splitting:

· Motivation: to create segment financial statements

· Assumption:

i. Operative process (of document entry) must not be disturbed (changed) by the online split

ii. When a vendor line item list is called, of course, there should still be only one open item for the invoice.

· Splitting doesn't happen in sub ledgers – happens only in GL account level

16. Steps involved in DS:

· Passive split

· Active (rule-based) split

· Clearing line/zero balance formation by document

17. Passive split:

· During clearing the account assignments of the items to clear are inherited to clearing line items

· Cannot be customized

18. Active split: (rule – based)

· System splits document due to splitting rules (provided or custom define)

· Can be configured

19. Clearing lines / zero balance formation by document:

· System creates new clearing line automatically to achieve a split

· Can control this process with the "zero balance flag"

20. Splitting procedure:

· Is the total of all splitting rules of all business transactions.

· Defines how and under which circumstances split will be performed

· Means, each procedure defines how each item category will be handled in the individual business transactions

i. Business transaction: is a general breakdown of actual business process that SAP provides and that is assigned a wide variety of item categories

ii. Business transaction variant: is a specific version of the predefined business transaction provided by SAP and (technical) modeling of a real business process for document splitting.

iii. Item category: is (technical) map of the posted line items – describes the items that appear within a document – derived from among other things, GL account categories – semantic description of document split.

iv. An individual splitting rule defines which item categories can be split and at the same time defines which foundation can be used

· Every GL has to be categorized into one of the item category

· GL account is associated with the item category

21. Splitting rule TCODE: GSP_RD

22. Splitting rules are not for CC – it is defined at client level

23. Document splitting characteristics:

· After defining how you want to split – now define which characteristics to use for splitting in GL accounting

· System proposes logical document splitting characteristics based on the assigned scenarios

· If you elect to use additional splitting chars, you should manage these chars in at least one Ledger

· Activate:

i. Zero balance flag – if you plan to use char to create FS. Balance of the involved entities is then always 0 for every posting, ensuring "entity balancing"

ii. Mandatory flag – has the two meanings:

1. It is an extension of the field status for accounts in which the char can not be entered during doc entry and for accounts that cannot be controlled through the field status.

2. It is a check as to whether a business process-equivalent business transaction variant was selected (which determines whether a splitting rule can be found)

24. Activating document splitting and inheritance:

· Splitting is first activated client-wide in customizing

· In a further step you can activate/deactivate splitting in each CC

· Inheritance: means when you create customer invoice from a revenue line – entities (such as BA / segment) are projected to the customer and tax lines in the GL View

· Default account assignment can be used to replace all account assignments that could not be derived from the posting with a constant "value"

25. Splitting procedure 0000000012 is the defaulted procedure provided by SAP

26. There is no reason why you shouldn't activate inheritance when splitting is active.

· If you didn't use inheritance, you'd have to define "rules" for the business processes to ensure that the account assignment are inherited – to achieve a zero balance in order to post the item

· Activation of inheritance is a first practical step to enable documents with active splitting, without any other customizing activities.

· Inheritance is performed online and at the line item level.

Need to stop depreciation posting on some assets

Our client want to stop depreciation posting on some particualr assetsbecause these assets are not in use & need to be disposed in future.

What to do to stop depreciation posting on some assets ?

Set the shutdown indicator for these assets and assure that shutdown is considered by the assigned depreciation key.

I have tried this option already but the result is that it is reversing all the depreciation posted in previous month of current year.

My issue resolved. I used shut down option.

Calculation of Depreciation for Tax for India

In India, there is a requirement that the Depreciation for Income Tax should be calculated based on the date of Acquisition. If an asset has been acquired before or on completion of 180 days of a Financial Year, than the calculation of Depreciation is allowed for full year. If the asset has been acquired after 180 days , depreciation is allowed only for 180 days. Hence for an asset acquired on 25/09/2009, system should allow calculation of depreciation from 01/04/2009, assuming that the fiscal year starts from 01/04/2009 and ends on 31/03/2009. However, if the asset is acquired on 07/10/2009, the system should allow depreciation from 01/10/2009. Sap has delivered standard depreciation keys for the same in reference chart of depreciation for India 0IN.

But if the asset has been acquired on 01/10/2009, still the asset has to be depreciated from 01/04/2009, since the asset has been acquired for less than 180 days into the fiscal year. The system is working fine for asset capitalized on 25/09/2009 and 07/10/2009. But we are not able to map the same if asset is capitalized on 01/10/2009 and 02/10/2009. For these two dates, the depreciation should start from 01/04/2009.

I have checked the period control setting and calender assignments and everything seems to be in place. How can we tackle the issue?

The same has been resolved.I Created a new assignment in Period Control IT for my fiscal year variant. For month 10, i added a new line item with no of days as 2 in addition to no of days as 31 for month 10.

Accounting Entries for MM, FI related

What should be my accounting entry in procurement?

For Domestic Procurement of Raw Material

During GR

Material Stock Dr.

GR/IR clearing Cr.

During Excise Invoice Credit

Cenvat Account Dr.

Cenvat Clearing Cr.

During Invoice Verification

Cenvat Clearing Dr.

GR/IR Clearing Dr.

Vendor Payable Cr.

For Domestic procurement of Capital Goods

During GR

Material Stock Dr.

GR/IR clearing Cr.

During Excise Invoice Credit

Cenvat Account Dr. (50%)

Cenvat On-hold Dr. (50%)

Cenvat Clearing Cr.

During Invoice Verification

Cenvat Clearing Dr.

GR/IR Clearing Dr.

Vendor Payable Cr

Subsequent of Capital Goods

Cenvat Account Dr. (50%)

Cenvat On-hold Cr. (50%)

For Import Procurement of Raw Material

During Customs Duty Clearing invoice

Custom Clearing Dr.

Custom Payable Cr.

During GR

Material Stock Dr.

GR/IR clearing Cr.

During Excise Invoice Credit

Cenvat Account Dr.

Custom Clearing Cr.

During Invoice Verification

GR/IR Clearing Dr.

Vendor Payable Cr.

For Excise Duty Credit of Raw Material without PO

Cenvat Account Dr.

Cenvat Clearing Cr.

For Excise Duty Reversal through Excise JV

Cenvat Clearing Dr.

Cenvat Account Cr.

What should be my accounting entry when the goods are issued through MM and excise invoice is created (J1IS & J1IV)?

During Excise Invoice Creation

Cenvat Suspense Account Dr.

Cenvat payable Cr.

For TR6C Challan

PLA Account Dr.

PLA on hold Account Cr.

During Fortnightly Utilization

Cenvat payable Dr.

Cenvat Account Cr.

PLA Account Cr.

Note: Cenvat Suspense Account should be cleared appropriately using FI JV's.

What should be my accounting entry in subcontracting reversal / Recredit?

For Subcontracting Challan Reversal

Cenvat Reversal Dr.

Cenvat Account Cr.

For Subcontracting Challan Recredit

Cenvat Account Dr.

Cenvat Reversal Cr.

What should be my accounting entry in SD ?

For Factory Sale

During Billing Document

Customer Account Dr.

Sales Account Cr.

Cenvat Suspense Account Cr.

During Excise Invoice Creation

Cenvat Suspense Account Dr.

Cenvat payable Cr.

For TR6C Challan

PLA Account Dr.

PLA on hold Account Cr.

During Fortnightly Utilization

Cenvat payable Dr.

Cenvat Account Cr.

PLA Account Cr.

For Stock Transfer through SD

No Accounting entries for Performa Billing Document

During Excise Invoice Creation

Cenvat Suspense Account Dr.

Cenvat payable Cr.

For TR6C Challan

PLA Account Dr.

PLA on hold Account Cr.

During Fortnightly Utilization

Cenvat payable Dr.

Cenvat Account Cr.

PLA Account Cr.

Note: Cenvat Suspense Account should be cleared appropriately using FI JV's.