Thursday, 19 December 2013

Error in Cash Journal

Scenario: Cash journal balance difference between Current period and today's balance. Cash journal as per Current period.




When I click on Today




There is a difference of Rs 450, and this entry was posted on 11/11/2013.

 


 

It is reflecting in the system but balance is not reducing.

 

FS10N – balance is 136441 as on 19/11/2013




In FBL3N


 


Solution:  Go to SE38












Click on Yes

 

Run the report RFCJ1 to delete the balance table TCJ_BALANCE. This table exists for performance reasons only. The balance table is regenerated when the cash journal is used. Now check the balance in the cash journal - the balance displayed corresponds to the actual total of the line items.    

Wednesday, 18 December 2013

General ledger planning


General ledger planning

1: What is the planning (budgeting) that you maintain in your General Ledger?


2: Do you plan on a monthly, quarterly, or annual basis?


3: How do you distribute planned amounts to individual planning periods (for example, equal distribution among periods, seasonal distribution)?


4: Does your planning take into consideration non-financial (statistical) data?

Tuesday, 17 December 2013

Hello

Hello All,

Sorry for not posting anything on my blog as I was away for my marriage.

Hope you are making your presence felt in SAP World.

I am back, hope to see your wishes :D

With loads of love

- Vani

Saturday, 9 November 2013

Chart of Accounts Handling - Implementation Question

Hello All,

Here are some of the questions which are generally asked by an SAP FI consultant to an account manager involved in SAP Implementation.

1: Please provide your current Chart of Accounts.
   
   
2: Describe how the account number is built and define the various fields it contains.
   
   
3: Define if this current COA is sufficient for future needs, and if it reflects the Corporate view of a COA.
   
   
4: Please provide an Organization Chart of your enterprise.
   
   
5: How many periods do you define in a fiscal year? Can you provide a schedule of period closing for the past, current and next year?
   
   
6: Do your general ledger accounts fall into discrete number ranges (for example, cash accounts are 1000 - 1999)?
   
   
7: Can you define groups of general ledger accounts that require similar information on the master record?
   
   
8: Will creation and maintenance of the general ledger accounts be done at the corporate level or at the local/company code level?
   
   
9: Do you currently use templates or prototypes to create general ledger accounts?
   
   
10: How many retained earnings accounts do you maintain per company code?
   
   
11: How many reconciliation (control) accounts do you need for each sub-ledger (A/R, A/P, Assets)?    An example would be for Accounts Payable, you may wish to have two reconciliation accounts, one for domestic payable and one for foreign payable.
   
   
12: Do you wish to retain line item detail for every general ledger account?  If not, what are the exceptions?  Which accounts do you wish to have open item managed (for example: Bank accounts)?


The list of question are infinite but I suggest you to prepare answers for the same and I will upload the answers of mine later.

Friday, 8 November 2013

Second List - Consultants List for SAP FI Freshers


Hello,

Here is the second list for consultants who may help you as freshers. The first list of consultants is also available here

Thursday, 7 November 2013

How to bring Profit Center on the F-02 Screen

Scenario: We need to bring profit Center on the following screen.


Solution: Go to OBC4; select the FSV of your organization.


Double click on Field Status groups


And then double click on G004, and then go to additional account assignments and then do page down and make Profit Center as Req. Entry.
Then you will be able to see the Profit Center as shown in the below screen.