New General ledger


Issue No.: 1
The user is not getting the drop-down list of G/L accounts that he defined through FS00 while posting through transaction code FB50/F-02. 

While entering a transaction, the user usually presses F4 to select a G/L account from the chart of account (COA). The SAP R/3 system displays all available accounts that are created for the desired company code and COA in question. If the user is not getting the G/L account in the drop-down list, try one of the following:

1. Check if the G/L accounts have been created in the company code you are posting.
2. Make sure you have selected the correct company code in T-code FB50.
3. The drop-down has a personal list and a global list. If you are in the personal list, switch to the global list.

Issue : 2
How can you add a new column in an open item clearing transaction with T-code F-03? Right now you have a document number, document date, document type, posting key, and amount. You need to add a posting key and amount in the transaction fields in the screen.


1. Go to the Clearing G/L Account Process Open Item screen using T-code F-03 from the menu bar.
2. Select --Settings and Change line layout
3. Select the Create button.
4. Give the line layout a name and description, and press Enter
5. Select the Insert after button to view the available fields.
6. Select the required field by double-clicking on that field. The required field is automatically listed under your own layout.
7. Repeat the process for each field required to create your layout and save.
8. Go back to the Clearing G/L Account Process Open Item screen, and select the Editing option button under the line layout variant for the G/L account clearing transaction.
9. Give your variant a name and save.

Issue No.: 3
The user wants to add a trading partner as selection criteria in the F-03 screen. This does not come with the
standard screen.

You are using transaction code F-03 to clear open items for a particular G/L account. While offsetting debit transactions with credits, depending upon business requirements, the user will select one of the selection options provided in that screen. The SAP R/3 system will pull all open items based on the selection criteria. The standard SAP R/3 system comes with very limited selection criteria; however, you can include a new selection field and change the sequence of the selection criteria. To add a new selection field or change the selection criteria sequence, you have to configure the SAP R/3 system through transaction code O7F1.

Issue No.: 4
There are a few G/L accounts where line item displays are not activated. The client would like to see what
entries are actually hitting these accounts. 

There are two possible solutions regarding this problem. SAP recommends the first solution because only standard means are used. The second solution requires the usage of a correction report and is therefore a consulting solution.

Standard solution:
1. Create a new account and set the options according to your requirements. Be sure to set the line item display indicator (SKB1-XKRES).
2. Transfer the items from the old account to the new account. You can only do this for accounts that you cannot automatically post to. As an alternative, you can transfer the balance completely.
3. Lock the old account for postings.
Consulting solution:
1. Manipulate all documents that were posted in the past. You can use the correction program RFSEPA01
(contained in the standard system as of release 3.0D). Read the document carefully.
2. For releases prior to 3.0D, a corresponding correction program is available on SAPSERV3.
While creating the G/L account, utmost care should be taken with the open item management and line item management attributes of the G/L account.

Issue No.: 5
While creating G/L accounts, some of the G/L accounts were wrongly kept as open item management. Now the
user wants to remove open item management functionality through transaction code FS02, but the system is giving the following error message: "This account does not balance to zero."



System Response:
You cannot switch the open item management specification on or off with this transaction.

Procedure:
If you want to switch this function on retroactively for a certain account, you should create a new account with
the correct setting and use this to make a transfer posting of existing items.

While creating the G/L master, you have to pay utmost attention to the setting of G/L master attributes. The situation here
is changing the attribute of G/L accounts after posting the transaction. For this, you have two options:

 Standard solution:
1. Create a new G/L account.
2. Transfer the account balance from the old G/L account to the new G/L account.
3. Switch off open item management for the old account and retransfer the G/L balance from the new account to the old account.

Without making the account balance zero, you can't switch an open item attribute of a G/L account.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCURledOQGiPE3gzf5z5BsbF0n0BUsZSldBNIEupjnM9So3IlfgLhgt17hjyKtsxqbZMW2yIavD8XQ2JTgZdNobBbwWzgQGdlCHKfvFZQHGgYCu3NI-bGe0dDjT7pO-5UKZZu5CyJXNCg/s320/New+Bitmap+Image.bmpConsulting solution:
As an alternative, the user could try program RFSEPA03, depending on his SAP release. The user may have to copy the program to the "Z" program and remove the piece of code that prevents its use. Before adopting this procedure,make sure the user reads the program documentation and related SAP advice.

Issue No.: 6
The user has posted the documents without a business area. Now he wants to update them. You know that once a document is posted, the business area cannot be changed in the document overview. How can you solve this issue?

To update the business area, you have two options:

 With the help of ABAP, you can update the business area in the posted document's BSIS table.

Or you could just reverse the original entry and repost the entry with business all the necessary details.
It is advisable to use the second option.


Issue No.: 7
The user is posting monthly entries through T-code FBS1 and reversing them on the first of the next month through T-code F-81. The user wants to automate the reversal procedure.

SAP solutions do come with automatic reversal of accrual entries, but the user has to execute transaction code F-81 for accrual reversal. Accrual entries are made through transaction code FBS1. SAP R/3 includes functionality to enter reversal dates while posting transactions. Once you are executing transaction code F-81, SAP R/3 will provide a list of accrual entries to be reversed. Instead of executing transaction code F-81 manually at an interval, you can create a batch job with a suitable variant and schedule it.

Issue No.: 8
A company code was assigned to an alternative COA. While creating a new G/L, the user keyed the alternative
G/L in the G/L master. But while saving, the following error occurred: "Alternative Account number already
assigned to account xxxxxx, cannot save." What would be the reason and how can you solve this?


The error is due to the assignment of the operating G/L account to the country COA. You can't assign multiple operating G/L accounts to one country COA G/L account. The relation between the operating G/L and country COA G/L is 1:1. When you are creating the G/L account with reference from some existing account, the alternative COA is also copied here; however, the country COA G/L is already assigned to an operating COA G/L account. This rule is not valid for group COA G/L accounts.

Issue No.: 9
After a transaction was posted, the client learned that an account that was classified as a balance sheet account should have been a P&L account. Now the client wants to reclassify the G/L account. Is this possible?

The reclassification of G/L accounts from a balance sheet account to a P&L account or vice versa is possible. Here are the
steps for such a conversion:
1. You can reclassify a G/L account when its balance is zero. So clear all open items and bring your account balance to zero.
2. Through T-code FS00, change the account type from a BS account to a P&L account. In a standard SAP system, you will get an error message. Note the message numbers.
3. Change the message control by following this menu path: SPRO → Cross-Application Components → Bank Directory → Change Message Control (transaction code OBA5).
4. Enter FH in the Area box (note that this is just an example) and press Enter for the next screen. In the New Entries: Overview of Added Entries screen, enter the two message numbers from step 2 and set the message to W (for Warning).

5. Once you have completed step 4, reclassify your G/L account as mentioned in step 2 This time, the system will issue a warning message and your account will be reclassified once you save your changes.
6. If your books of accounts are closed for the previous year, run program SAPF0110 to carry forward your balance to
the new year.The reclassification of G/L accounts is advisable at either the end or beginning of the year.


Issue No.: 10
While analyzing accounts, the user found that certain document numbers are not appearing or are missing. For
example, number range 17 is assigned to document type KA, which has the range 1700000000–1799999999 valid up to 9999. The current status shows that the next available number is 1790000000. During analysis, the user found that documents 1780000000–1780000010 are missing.
The user wants to know why document numbers are missing.

There are several reasons for missing document numbers. Here are two scenarios for this issue:
1. One possible reason could be that these documents were initially parked and later deleted. In this case, those document numbers cannot be reused.
2. The documents probably don't exist. SAP solutions will set aside numbers for use when the system detects multiple document creation. If someone is creating documents, the system will make available, for example, the next 10 numbers, "reserving them," in essence. If the user only creates eight documents, two document numbers will be missing.

You may use the following programs/reports to find out the reason for the missing documents:

  •  Program RFVBER00 provides a list of transactions that failed while updating the database.
  •  Program RFBNUM00 shows gaps in the FI number range.



Issue No.: 11
The user has reported that the system is not splitting document type SA but is splitting other document types.

In the standard configuration, document type SA is assigned to transaction type 0000, to which no splitting rule is assigned. In these circumstances, the system is expecting that you will enter an account assignment while entering a business transaction.

See how your system is configured in the following menu path:


  •  Financial Accounting (New) → General Ledger Accounting (New) → Business Transaction → Document Splitting → Classify document types for document splitting
  •  Financial Accounting (New) → General Ledger Accounting (New) → Business Transaction → Document Splitting → Classify GL account for document splitting


Issue No.: 12
A company code was assigned to an alternative COA. While creating a new G/L, the user keyed the alternative
G/L in the G/L master. But while saving, the following error occurred: "Alternative Account number already
assigned to account xxxxxx, cannot save." What would be the reason and how can you solve this?


The error is due to the assignment of the operating G/L account to the country COA. You can't assign multiple operating G/L accounts to one country COA G/L account. The relation between the operating G/L and country COA G/L is 1:1. When you are creating the G/L account with reference from some existing account, the alternative COA is also copied here; however, the country COA G/L is already assigned to an operating COA G/L account. This rule is not valid for group COA G/L accounts.


Issue No.: 13
The user is posting monthly entries through T-code FBS1 and reversing them on the first of the next month through T-code F-81. The user wants to automate the reversal procedure.

SAP solutions do come with automatic reversal of accrual entries, but the user has to execute transaction code F-81 for accrual reversal. Accrual entries are made through transaction code FBS1. SAP R/3 includes functionality to enter reversal dates while posting transactions. Once you are executing transaction code F-81, SAP R/3 will provide a list of accrual entries to be reversed. Instead of executing transaction code F-81 manually at an interval, you can create a batch job with a suitable variant and schedule it.


Issue No.: 14
The user has posted the documents without a business area. Now he wants to update them. You know that once a document is posted, the business area cannot be changed in the document overview. How can you solve this issue?

To update the business area, you have two options:

 With the help of ABAP, you can update the business area in the posted document's BSIS table.

Or you could just reverse the original entry and repost the entry with business all the necessary details.
It is advisable to use the second option.



Issue No.:15
While creating G/L accounts, some of the G/L accounts were wrongly kept as open item management. Now the
user wants to remove open item management functionality through transaction code FS02, but the system is giving the following error message: "This account does not balance to zero."



System Response:
You cannot switch the open item management specification on or off with this transaction.

Procedure:
If you want to switch this function on retroactively for a certain account, you should create a new account with
the correct setting and use this to make a transfer posting of existing items.

While creating the G/L master, you have to pay utmost attention to the setting of G/L master attributes. The situation here
is changing the attribute of G/L accounts after posting the transaction. For this, you have two options:

 Standard solution:
1. Create a new G/L account.
2. Transfer the account balance from the old G/L account to the new G/L account.
3. Switch off open item management for the old account and retransfer the G/L balance from the new account to the old account.

Without making the account balance zero, you can't switch an open item attribute of a G/L account.

Consulting solution:
As an alternative, the user could try program RFSEPA03, depending on his SAP release. The user may have to copy the program to the "Z" program and remove the piece of code that prevents its use. Before adopting this procedure,make sure the user reads the program documentation and related SAP advice.



Issue No.: 16
there are a few G/L accounts where line item displays are not activated. The client would like to see what
entries are actually hitting these accounts. 

There are two possible solutions regarding this problem. SAP recommends the first solution because only standard means are used. The second solution requires the usage of a correction report and is therefore a consulting solution.

Standard solution:
1. Create a new account and set the options according to your requirements. Be sure to set the line item display indicator (SKB1-XKRES).
2. Transfer the items from the old account to the new account. You can only do this for accounts that you cannot automatically post to. As an alternative, you can transfer the balance completely.
3. Lock the old account for postings.
Consulting solution:
1. Manipulate all documents that were posted in the past. You can use the correction program RFSEPA01
(contained in the standard system as of release 3.0D). Read the document carefully.
2. For releases prior to 3.0D, a corresponding correction program is available on SAPSERV3.
While creating the G/L account, utmost care should be taken with the open item management and line item management attributes of the G/L account.

Issue No.: 5
The user wants to add a trading partner as selection criteria in the F-03 screen. This does not come with the
standard screen.

You are using transaction code F-03 to clear open items for a particular G/L account. While offsetting debit transactions with credits, depending upon business requirements, the user will select one of the selection options provided in that screen. The SAP R/3 system will pull all open items based on the selection criteria. The standard SAP R/3 system comes with very limited selection criteria; however, you can include a new selection field and change the sequence of the selection criteria. To add a new selection field or change the selection criteria sequence, you have to configure the SAP R/3 system through transaction code O7F1.


Issue :17
How can you add a new column in an open item clearing transaction with T-code F-03? Right now you have a document number, document date, document type, posting key, and amount. You need to add a posting key and amount in the transaction fields in the screen.

1. Go to the Clearing G/L Account Process Open Item screen using T-code F-03 from the menu bar.
2. Select --Settings and Change line layout
3. Select the Create button.
4. Give the line layout a name and description, and press Enter
5. Select the Insert after button to view the available fields.
6. Select the required field by double-clicking on that field. The required field is automatically listed under your own layout.
7. Repeat the process for each field required to create your layout and save.
8. Go back to the Clearing G/L Account Process Open Item screen, and select the Editing option button under the line layout variant for the G/L account clearing transaction.
9. Give your variant a name and save.



Issue No.: 18
My client raised a PO at USD 13 for 50 qty. A goods receipt MIGO transaction was done at that price. Now my client wants to do a MIRO transaction at USD 14 for 50 qty.

This situation can be handled in two different ways: (1) price difference or (2) reversing MIGO and repost MIGO with correct price.

1. At the time of the MIRO transaction, you have an option to post a price difference. In the MIRO transaction, enter the G/L account for price difference and amount (i.e., $1).

2. Reverse the MIGO entry, make changes in the PO, then once again do the MIGO and MIRO transactions. 

Issue No.: 19
The user is not getting the drop-down list of G/L accounts that he defined through FS00 while posting through transaction code FB50/F-02. 

While entering a transaction, the user usually presses F4 to select a G/L account from the chart of account (COA). The SAP R/3 system displays all available accounts that are created for the desired company code and COA in question. If the user is not getting the G/L account in the drop-down list, try one of the following:

1. Check if the G/L accounts have been created in the company code you are posting.
2. Make sure you have selected the correct company code in T-code FB50.
3. The drop-down has a personal list and a global list. If you are in the personal list, switch to the global list.

Issue No.: 20
The user is trying to create a vendor for a particular company code. In the initial screen for the customer, the company code was set to the default and the user is trying to create another company code.

  
For rapid data entry, some important parameters such as company code and controlling area are set as the default while setting the user profile. If the security role allows, the user can reset or define his own parameters through transaction code SU01. In transaction code SU01, you will find a Parameter tab; this is where you make all default settings. Check the default value for parameter ID BUK. If you don't want any default values, remove them.

Issue No: 21

Default Profit center Via 3KEH & FAGL3KEH
I have defaulted the profit center of a particular Bank G/L Account via these 2 transactions.
Now the new entries, whatever  taking place are getting displayed in fbl3n when we choose a specific profit center.

But what about the existing entries in that G/L Account? Those are not getting displayed profit center wise.


1      SAP Profit center Authorization check

2     SAP Note : Note 1331317 - EhP3: Authorization check for profit center

Activate fuctional Mode by basis - FIN_GL_CI_1
Symptom
You map Profit Center Accounting in new General Ledger Accounting and, in future, you want to execute an authorization check for the profit center within the FI document entry, document display and for other selected FI posting transactions. You require information about maintaining the default values for the authorization object K_PCA in transaction SU24.
Other terms
SU24, PCFG, profile generator, K_PCA
Reason and Prerequisites
You imported Enhancement Package 3, the business function FIN_GL_CI_1 and then activated the authorization check for the profit center.
Solution
Call transaction SU24 in your development system.
Load the attached file into your system by choosing "Upload". Select the "Customer data" option for the upload.
           Do NOT activate the "Originals only", "SAP data", "Copy SAP Data to Customer Table" and "Replace Instd of Insert/Modify" options. Otherwise, the system deletes all of the settings that you have already maintained for the transactions listed in the file.
           
After you have imported the file successfully, change the following transactions:
FB01
FB02
FB03
FB05
FB08
FB1D
FB1K
FB1S
FBB1
FBU3
FV60
Change the default value for the authorization object K_PCA in the "Check" column from "NO" to "YES". In the field CO_ACTION, enter the default value "2003" for transactions FB03 and FBU3, and enter the default value "2076" for all other transactions. In transaction SU24, entries already exist for the listed transactions for the authorization object K_PCA. If you changed these entries automatically by uploading the data file, the settings that you maintained for the relevant transactions would be lost for other authorization objects.