Written By : Getahun Teferi SAP Functional and Business Consultant Electrical and Computer Engineer Certified SAP Digital Badge in SAP S_4HANA Cloud - Support and Success Essentials for SAP Consultant
FICO ISSUES WITH SOLUTION
Understanding an issue is most important step to provide quality & precise solution. Ask for more information if issue description or details are not sufficient to understand the problem.
Generally, business users provide the actual documents, scenarios. If not, then ask for the same. The content this page describes some SAP FI & CO- Issues with Solutions as follows:
1. SAP GENERAL
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.
Solution: 1
While entering a transaction, the user usually presses F4 to select a G/L account from the chart of account (COA). The SAP S/4 HANA 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
I.Check if the G/L accounts have been created in the company code you are posting.
II. Make sure you have selected the correct company code in T-code FB50.
III.The drop-down has a personal list and a global list. If you are in the personal list, switch to the global list.
2. GENERAL LEDGER (G/L) ACCOUNTING
Issue No:2
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.
Solution: 1
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 their 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: 3
My client raised a PO at BIRR 1300 for 50 qty. A goods receipt MIGO transaction was done at that price. Now my client wants to do a MIRO transaction at BIRR 1400 for 50 qty.
Solution: 3
This situation can be handled in two different ways:
(1) price difference or
(2) reversing MIGO and repost MIGO with correct price.
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).
Reverse the MIGO entry, make changes in the PO, then once again do the MIGO and MIRO transactions.
Issue No:4
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.
Solution:4
Go to the Clearing G/L Account Process Open Item screen using T-code F-03 from the menu bar.
- Select Settings and Change line layout.
- Select the Create button.
- Give the line layout a name and description, and press Enter.
- Select the Insert after button to view the available fields.
- Select the required field by double-clicking on that field. The required field is automatically listed under your own layout.
- Repeat the process for each field required to create your layout and save.
- 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.
Give your variant a name and save.
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.
Solution: 5
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 S/4 HANA system will pull all open items based on the selection criteria. The standard SAP S/4 HANA system comes with very limited selection criteria; however, you can include a new selection field and change the sequence of the selection. To add a new selection field or change the selection criteria sequence, you have to configure the SAP S/4 HANA system through transaction code O7F1.
Issue No: 6
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.
Solution: 6
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:
Create a new account and set the options according to your requirements. Be sure to set the line-item display indicator (SKB1-XKRES).
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.
Lock the old account for postings.
Consulting solution:
Manipulate all documents that were posted in the past. You can use the correction programRFSEPA01 (contained in the standard system as of release 3.0D). Read the document carefully.
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: 7
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."
Solution: 7
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:
Create a new G/L account.
Transfer the account balance from the old G/L account to the new G/L account.
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. Theuer 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: 8
The client processed a bank statement and one of the line items in the bank statement overview in transaction FEBA shows the status as "Complete." However, the client used a wrong posting rule here. How can you change to the correct posting rule and process the transaction again so that the status is changed to "Posted "
Solution: 8
There are two ways to handle this situation:
With a reverse bank reconciliation posting document.
By deleting the bank statement from the SAP S/4 HANA system. To delete the bank statement, follow these steps:
In T-code SM38, enter RFEBKA95 and execute the program. It will open the posted bank statement.
Deselect all and select the statement that is wrongly posted to delete it.Repost the bank statement through T-code FF67.
Issue No: 9
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?
Solution:9
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: 10
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.
Solution:10
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.: 11
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?
Solution:11
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.: 12
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?
Solution:12
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:
You can reclassify a G/L account when its balance is zero. So, clear all open items and bring your account balance to zero.
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.
Change the message control by following this menu path: SPRO → Cross-Application Components → Bank Directory → Change Message Control (transaction code OBA5).
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).
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.
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: 13
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 range1700000000 –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.
Solution:13
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:
One possible reason could be that these documents were initially parked and later deleted. In this case, those document numbers cannot be reused.
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: 14
What is ranking order in an APP?
Solution:14
Ranking order represents priority assignments to each house bank. This helps the APP choose the house bank for payment in case there is more than one bank account satisfying the payment program parameters.
3. ACCOUNTS PAYABLE (AP)
Issue No:15
The client printed 50 checks, of which 10 checks are spoiled or torn. Now the client wants to reprint the checks using the same APP. Is this possible? Or do you have to void those checks that are spoiled or torn?
Solution:15
There may be times when the payment run has successfully posted payment documents and generated checks, but for some reason or other, the checks are not valid. In this situation, you have to void all of the printed checks and reprint them. To void and reprint, follow these steps:
Execute transaction code FCH7. You may navigate to FCH7 through the payment run. Execute transaction code F110, enter the payment run ID and run date, then follow the menu path: Environment → Check information → Change → Reprint Check (t-codeFCH7).
Enter the following details
Paying company code
House bank
Account ID
Number of the check to be voided
Void reason code
New check number
Choose the path: Check → Reprint from the menu.
You must follow this process in a situation where you have issued checks, but the checks are lost in post.
Issue No: 16
While posting outgoing payments through T-code F-53, the client received the error message ‘The entry 1210 is missing in table T043G’ and the system did not allow the posting payment document.
Solution:16
The SAP S/4 HANA system returns this error when it doesn't find vendor/customer tolerance for your company code. In this example, you are processing an outgoing payment for a company code for which the vendor tolerance group is not defined. Create vendor tolerance through transaction code OBA3 (menu path: Financial Accounting → Accounts Receivable and Accounts Payable → Business Transactions → Outgoing Payments → Manual Outgoing Payments → Define Tolerances (Vendors)) for your company code.
Issue No: 17
A vendor has requested that charges for services and materials be paid through separate bank accounts. For example, Vendor X supplies both services and materials and maintains two bank accounts—one for services and another for materials. The vendor requests that your client pay for services through bank account XXXXX and materials through bank account YYYYY. Is this possible when payments are made through an APP?
Solution:17
A vendor may have multiple bank accounts. The SAP system provides the functionality to store and use information from multiple vendor bank accounts in the Payment transactions screen of the vendor master general data via transaction code FK03.
Issue No: 18
A client posted a new document using T-code FBR2. Using T-code F110, payment was also posted for this invoice. After this transaction, it was found that the discount base was wrong, and the system had taken the value based on the reference document. How can you reverse a payment posting and change the baseline date?
Solution :18
You have posted a vendor invoice through transaction code FBR2. This transaction code is used to post a new document with reference to an existing document. While posting a new document through transaction code FBR2, SAP SAP S/4HANA will copy all of the fields from the reference document; however, you can change whatever is needed. After having posted the vendor invoice, you also processed payment for the said document. To correct the baseline date, you have to correct the vendor document. Follow these steps to resolve this: Cancel the payment check via transaction code FCH8 (if the check is in your possession). This transaction voids the check, resets the clearing process, and reverses the payment document. Reverse the vendor document and post a new document with the correct discount base date.
Issue No.: 19
A user made an advance payment of INR 20000 through a special G/L transaction and deducted withholding taxes, at 2% (Rs. 400.00). Later the user received an invoice for Rs. 30000. Now the client wants to deduct withholding tax on the balance amount, i.e., Rs. 10000, not on the entire amount. If the user uses T-code F-43, it deducts the tax on the full invoice value of Rs. 30000, which is Rs. 600, whereas the user wants the advance payment taken into account and wants to pay Rs. 200 (Rs. 600-Rs. 400). The user needs to deduct the tax on the entire amount at the time of invoice posting. While adjusting the advance payment against the invoice, the SAP R/3 system will reverse the tax you have deducted. However, the user needs to make the following configuration in the payment withholding type for this tax reversal to take place: Follow the menu path: IMG → Financial Account Global setting → Withholding tax → Extend withholding tax → Calculation → Withholding Tax Type → Define withholding tax type for payment posting. Select the withholding tax type. At the bottom is a Central invoice window, in which the user will select the last radio button— Central inv. prop.
Issue No: 20
The user wants to print a check for a vendor down payment. To use T-code F-58, the system needs an open item. When the user makes an advance payment, there will not be any open items in the vendor account.
Solution 20:
Transaction code F-58 is used to process payment for existing open items. This transaction code can't be used for processing advance payments. You have two options to handle this situation:
(1) create an advance payment request and pay through an APP or
(2) create an advance payment document through transaction code F-48 and print a check through transaction code FBZ5. Here are the steps for both options:
Option 1: Create a down payment request through transaction code F-47. Run the payment program through transaction code F110
Option 2: Use transaction code F-48 for advance payment to vendors. Based on the posted document number, print a check using transaction code FBZ5
Issue No.: 21
The user wants to make a check payment for petty expenses like stationery, travel, etc. Transaction code F-02 provides facility to capture check information. Without check information, the user can't do bank reconciliation. The user is wondering if there is any workaround to deal with this situation. The user can use transaction code F-53 with doc type GZ (General Payments). In the Post Outgoing Payment: Header Data screen, the user has to provide bank data and the check number in the assignment field. After entering this information, the user can switch screens using F-02. To switch the screen, the user must follow these steps:
From the system menu, choose Go to → Document overview
After selecting Document overview, the user will get a new screen, in which he can enter expenses by entering the posting key and expenses G/L accounts. For bank reconciliation, the user can choose internal algorithm 15 or 13 for the system to check the assignment field for check numbers.
Issue No.: 22
In transaction code F-33 (bills of exchange discounting), the user entered all data. When this is executed, the user receives a message that A/C No. 400400 (Interest account) requires an assignment to a CO object. What does this mean?
Solution:22
When a controlling area is active, the user has to assign a valid cost object while posting expenses. In this case, bank interest is an expenses account, while posting selects a valid cost object.
Issue No: 23
The user has executed transaction code F110 to pay 50 vendors, but he only has 20 checks left. Hence, when he ran the program, it printed the checks with random numbers.
Solution:23
Now the problem is he is unable to cancel the payments, as there is no check number. How can he reprint or cancel the checks?
Issue No: 24
While posting a transaction through T-code F-58, the user sees this error message: "Changes for vendor XXXXXX not yet confirmed.
Solution: 24
" In SAP configuration, you define certain fields as sensitive to have proper control and tracking on master data changes. If the user changes these sensitive field(s), someone other than the user who changed the master data has to confirm these changes. Until such confirmation, the SAP system does not allow any transactions with that trading partner. For example, you configure payment term as a sensitive field. To accommodate business requirements, user XXXXX updates the payment term with a new payment term ID. In order to carry out any transactions with this business partner, the changes have to be approved by another user.
To confirm this change, the user has to use transaction code FK09. Follow this procedure before executing transaction code F-58.
Issue No: 25
It is not possible to post multiple customers in transaction code FB70. Can you use F-21?
Solution 25:
After starting with FB70 and making as many entries as you wish, if you need to post to other customer accounts you can press F6, which switches you back to the "old-style" data entry screen where you can post to as many other customer accounts as you wish using the old "posting key" method.
4. ASSETS MANAGEMENT (AM)
Issue No: 26
During data migration, the client forgot to transfer two assets whose book values are zero. Now the client wants to bring those assets to the asset portfolio for reporting purposes. The client needs both acquisition cost and accumulated depreciation in FI, including information from the AM module. As the data migration is already done and the company code in question is already in the Go-live stage, how can you bring these two assets to FI—including the Asset module?
Solution: 26
The solution for this ticket would be:
Set the company code status to "1" Asset data transfer not yet completed.
Update legacy data using T-code AS91.
Enter the acquisition cost and accumulated depreciation using T-code OASV.
Issue No: 27
The user wants to transfer an asset from one asset class to another asset class. A depreciation expense of the new asset class is assigned to another account determination. The user wants to transfer APC, accumulated depreciation, and depreciation expenses to G/L accounts that are assigned to the new asset class. Transaction code ABUMN has fields for ACP and accumulated depreciation. The user is wondering how depreciation expenses will be transferred from the old accounts to the new account.
Solution: 27
Through transaction code ABUMN, you can reclassify assets. In the reclassification process, you can only transfer APC and accumulated costs to a new asset class with immediate effect. Depreciation expenses will be transferred to the new G/L when you run depreciation. However, during the depreciation run, you can't transfer previous depreciation expenses that were already charged to the cost center. But you can transfer current-year depreciation to the new depreciation expenses account. While entering the transaction in transaction code ABUMN, enter in the value date field the date on which you want to transfer your expenses to the new account.
Issue No.: 29
After the depreciation run, the user changed the capitalized date and the depreciation start date in the asset master. After making changes in the asset master, the user once again ran depreciation in "repeat run" mode. But changes made to the asset master did not hit depreciation, and the difference value is appearing as a planned value when checked in T-code AW01N.
Solution: 29
If you are making any changes in the asset master that affect depreciation that is already posted, you must follow this procedure:
Recalculate depreciation using T-code AFAR.
Repeat the depreciation run using T-code AFAB.
Issue No: 30
The user wants to post a transaction in the year 2008 through transaction code F-90. While posting the transaction, the system returns the following error:
Solution :31
"You cannot post to asset in company code 9999 fiscal year 2008 Message no. AA347."
Diagnosis:
A fiscal year change has not yet been performed in Asset accounting for company code 9999.
Procedure:
Check the asset value date.
It looks like the user entered an asset acquisition in fiscal year 2008 for company code 9999, for which the assets accounting (AA) fiscal year change has not been carried out.
For AA, it is required that the user carry out the fiscal year change before entering a transaction in the new year.
Run transaction code AJRW to change the fiscal year. The latest date you can run this transaction code is the last business day of a financial year.
Issue No: 32
The user wants to move assets to another class because the assets were created under the wrong asset class. The old asset is capitalized on 08/01/2008. Since the depreciation key is 000, there is no depreciation running for that asset.
Solution :32
Now the user wants to transfer the asset to another class, so the old asset is removed (or may be retired) with an acquisition date of 08/01/2008, so that the depreciation expenses can be calculated from 08/01/2008.
This is a case of reclassification of assets. In transaction code ABUMN, = enter the APC and the accumulated cost along with an asset value date of 08/01/2008.
In the receiver asset master screen, enter the desired depreciation key and the depreciation start date.
Issue No: 33
Is it possible to integrate the sale of assets with the SD module? It will involve some sales tax and also the client wants to generate an invoice in the SAP solution. Can the SD module be used for this?
Solution :33
Follow these steps for selling assets with integration with the SD module:
Retire the asset without customer (T-code ABAON). This will credit the APC and debit the clearing account (which is a P&L account).
Then take a non-valuated material for asset sale purpose and sell the same using SD. Make sure you have a separate pricing procedure/SD document type, etc., where the account key ERL will post to the clearing account mentioned in step 1. You can collect sales tax/excise, etc., as usual.
Issue No: 34
While creating assets under asset class XXXX, the user is getting default depreciation terms and the system does not allow changing depreciation terms. The user does not want the default depreciation key. How can you resolve this situation?
Solution :34
It sounds as if the depreciation key has been set as the default for the asset class. Check this in the IMG by doing the following:
Go to the Depreciation Areas screen layout using T-code OA21. This transaction determines how fields of depreciation areas in the asset master behave. This transaction code controls whether or not fields are editable.
Determine depreciation areas in an asset class using T-code OAYZ. This transaction code determines screen layout of the asset class and depreciation keys assigned to that asset class.
Issue No: 35
When you retire an asset, you only want the depreciation that has been posted to be reversed, i.e., accumulated depreciation up to the last month has to be reversed. However, the system is also taking the current month's unplanned depreciation into consideration when reversing accumulated depreciation and hence the profit and loss is calculated incorrectly. How can this be changed?
Solution:35
You assign the period control method in the depreciation key. The period control method controls how depreciation will be calculated during acquisition, retirement, etc. Check the period control method assigned to your depreciation key, which in turn is assigned to the asset master.
Issue No.: 36
The user is trying to create an asset master using transaction code AS01. He is able to see fields in the General, Time dependent, and Allocations tabs, but is not finding fields in the Depreciation Area tab. As a result, the user is unable to specify the depreciation key and life of an asset.
Solution:36
Check your screen layout for depreciation areas (transaction code AO21).
In T-code OAYZ, make sure that the depreciation areas are activated and a depreciation key is assigned. Also, check the screen layout rule for the depreciation area. It is the last column in the table after useful life and index. This is where you enter the depreciation screen layout.
Suppose that during year end, the period for both March and April are open and the depreciation run for April is also executed. The asset year closing for the previous year is not done. Now an adjustment in depreciation is to be made in the previous year (for the March period) and the user has to run depreciation once again for March. Is this possible?
Solution :36
Run a depreciation recalculation (transaction code AFAR) before you execute another depreciation run.
Issue No: 37
The user acquired his first set of assets in the month of February 2008 and is trying to run depreciation starting from February. While running depreciation, the system returns the following message: "According to the posting cycle, you should post period 001 next. Either enter period 001, which corresponds to the posting cycle, or request an unplanned posting run explicitly for this parameter."
Solution:37
If your posting cycle is monthly, then your SAP solution expects depreciation to run for every period in sequential order. So, you can't run February until you have completed the January depreciation run. Since you have acquired assets in the month of February, you are not running depreciation for the month of January. However, SAP is expecting you to run depreciation for January also. To overcome this, you have to do one of the following:
(1) run depreciation for the month of January and then the month of February or
(2) select the unplanned posting run for February. The unplanned run lets you skip over periods (in instances like this).
5. COST CENTER ACCOUNTING (CCA)
Issue No: 38
The canteen cost center costs (for example, Rs. 10,000) were to be allocated to other receiving cost centers with "No. of Employees" as the statistical key figure. The canteen cost center also has some employees, so it is becoming both the sender and the receiver for itself. The problem is that when trying to allocate the costs through the distribution method, the system is first allocating some portion of the costs (for example, Rs. 500) back to the canteen cost center and then reallocating the costs to the other cost centers, so that in the end, the debit and the credit balances for the canteen cost center is showing Rs. 10,500 (10,000 + 500). When trying the assessment method, however, the system is sending the portion of the canteen cost center costs back (Rs. 500), it is not reallocating them to the other cost center, and the debit side is showing Rs. 10,500 while the credit side is only showing Rs. 10,000.
Solution:38
When defining assessment, be sure to check the check box for iterative. This will repeatedly allocate the costs to other cost centers until the balance becomes zero.
Issue No: 39
A client posted an entry to 0001 cost center instead of 4000. Now the client wants to correct the posting without revising the document. How can the correction be done without reversing the document.
Solution:39
Using T-code KB11N, you can repost the costs from one cost center to another cost center.
6. PROFIT CENTER ACCOUNTING (PCA)
Issue No :40
While posting the AP balance to PCA through transaction code 1KEK, the user found that some of the line items are posted to a dummy profit center. The user is expecting these to go to specific profit centers.
Solution: 40
A customer and vendor balance consists of open items, i.e., those that are yet to offset. While transferring balances, the system looks for profit centers from the offsetting entry. In the case of open items, the system will not find an offsetting entry and will post line items to a dummy profit
