FI Errors and Probable Solutions These are some of the issue for which probable solutions are given, hope they are helpful : Scenario 1: I have configured FBZP, Fi12 for house bank. But when I am doing payment run in F110 I am getting following error: Company codes X1YZ/X1YZ do not appear in proposal 05/03/2006 REMI2. Diagnosis No data exists for the specified paying company code X1YZ and the specified sending company code X1YZ in payment proposal 05/03/2006 REMI2. System response The payment proposal cannot be edited. Procedure Check the flow trace and payment proposal list in order to determine why the specified company codes are not contained in the
proposal Solution : * That’s generic error for payment run, check whether there are any due items as on date (tcode fbl1n). You can also change the baseline date there and rerun it. if you still get same error.. Check the proposal log, you will find the reason. * Try to see first whether any open items exist. By using FBL1N. Scenario 2: How to make the payment through automatic payment program, through F110 .What are the prerequisites? Solution : For Down payments to be paid using APP we have create a Down Payment request F-47. Scenario 3: While doing APP, after, " the payment proposal has been created message " if edit proposal is selected, selected, I am getting the error error as
"Company code ABC/ABC do no appear in "Company the proposal " Solution : This type of error comes when your Payment proposal doesn't have any items to process. Check the parameters and ensure invoices are due as on run date.
hii while i m doing f-32 for f or customer clearing then system showing error msg... "In company code 1000, the number range 80 is missing for the year 2009" how we will set number range? range? Thanks & Regards Rekha shrama
SAUBA G Posts: 221 Registere d: 2/2/07 Forum Points: 312 Top of Form Bottom of Form
Sayya d
Re: number range missing during f-32 Posted: Jul 18, 2009 6:43 AM in response to: Rekha Sharma
Reply
hi use T code FBN1,OBH1 or OBH2 Saubag
Re: number range
Reply
Habib Pa... Posts: 115 Registere d: 7/25/06 Forum Points: 58 Top of Form Bottom of Form
missing during f-32 Posted: Jul 18, 2009 7:43 AM in response to: SAUBAG hi Go to T.Code FBN1 enter C.Code 1000 and select chagne option. add number ranges for 80 with applicable range. reg S. Habib Pasha Pages: 1
Scenario 4 : While posting customer invoice (FB70) why system asks for G/L account? As per accounting rules customer is debited and Customer reconciliation a/c is credited that ends double entry book keeping rule. Why one more G/L account on top of Recon a/c, which is posted automatically? Solution : * Entry gets posted to Customer a/c through reconciliation account. You have to give a GL a/c for revenue. Your entry would be Customer (Reconciliation a/c) Dr To Revenue Cr * Reconciliation is a fictious entry so you cannot consider as an entry to be entered by the user. This rule is derived from the fact that 'we cannot enter/post directly to RECON account'. That is why system needs a GL account to make
the account balance as zero. Manual entry could be: Customer a/c Dr To Domestic Sales a/c (Sales invoiced posted) Recon entry is automatically made once you post this entry since you have configured your RECON in the IMG. Scenario 5 : I am unable to figure out how to attach my GL Accounts to my company code [copied chart of accounts, have my own company code, assigned my company code to the chart of accounts]. Solution : You can attach the GL Accounts by just filling the details in the company code segment of the GL A/c. Hence you can use that gl a/c for your co code. But that would be individually creating the accounts. Right?? How about creating all
accounts at one shot. Create in FS00 Scenario 6 : Difference between Standard Hierarchy and Alternate Hierarchy. Solution : Standard Hierarchy is basic structure of company but alternative hierarchy is just for reporting or temporary usage. Scenario 7: I have created depreciation keys (diminishing balance) and assigned to asset classes respectively. But at the time of asset master creation the system ask for Useful Life of the asset while my understanding is that in diminishing balance method there is useful life, just percentage is defined. Solution : Useful life is required for depreciation change. Normally a company with WDV depreciation may want to write off its assets which have crossed their useful life in 2 or 3 installments.
This is achieved by depreciation change, where after useful life, a new method takes over. Scenario 8 : I have some conceptua conceptuall problem in Internal Order. Solution : Internal order can only take a statistical posting & cost centre shall take a true posting when the relevant internal order is defined as statistical I/O IN T. code KO01(CONTROL DATA ) tab. So while making a posting in FB50 and assigning both I/O & COST CENTRE as relevant cost object in the transaction you shall get the stated status of these 2 cost object. Scenario 9 : In fb50, in the details tab, only if I tick 'calculate tax' will the the tax tax get get calculated. calculated. Our user wants this to happen always (by default), i.e. he does not want to tick this for each transaction. Is there any setup to be done for the tax to get calculated always?
Solution : Even now you are not clear. T_Code FB50 is used for posting GL account only. I fail to understand how you can calculate tax which is generally from purchase / vendor or Sales / Customer oriented through FB50. In case of local distribution, if we forget to pay taxes on certain items and we need to pass tax entries, then such a case is needed. This can be achieved thru default parameter id for that particular user through transaction code SU3. In SU3, in Parameters Tab put "XTX" in Parameter ID column and in Parameter Value column put "X". Scenario 10 : We have an issue here where by the system is calculating the tax for an invoice with a wrong tax base amount. How do i change the tax base amount? I get the tax rates from VERTEX and they are showing right. Where does the system pull this tax base amount for
an Invoice and how can I change it. Solution : Kindly check this: spro - financial accounting - f.a global setting with holding setting - extended with holding setting -- calculation -- with holding tax type . Check your withholding tax type, go in it and check the setting. Tips by : Viji Get help for your SAP FI/CO problems Do you have a SAP FI/CO Question? SAP Books SAP Certification, Interview Questions, Functional, Basis Administration and ABAP Programming Reference Books SAP FICO Tips SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum Best regards, SAP Basis, ABAP Programmin Programming g and Other IMG Stuff
http://www.sap-img.com
Hello Gurus, For a normal invoice posting in FB60, I defined the vendor terms as net 30 days. But when I make a credit posting for the same vendor the transaction is posted with 001 days. Could you please tell me the settings of payment terms in this case for a credit transaction to the vendor. Regards Kishore Naidu Micha el Gerar d ...
Re: Credit Transaction Pay terms Posted: Jul 16,
Reply
Posts: 361 Registere d: 12/19/08 Forum Points: 986 Top of Form Bottom of Form
2009 8:38 AM in response to: Naidu_2009 Hi Kishore, In your vendor master, check the Credit memo terms. Goto FK02 Give the vendor number and company code Select PAYMENT TRANSACTIONS from Company Code data If required, change the credit memo terms to a suitable one. Regards,
Mike
is thr any t.code by which we can check on which gl the open item management tick available on our chart of account in fs00...?
phaneen dra Reddy Posts: 1,082 Registere d: 4/10/07 Forum Points: 1,280 Top of Form
Re: open item management tick status for all gl Posted: Jul 16, 2009 7:19 AM in response to: Rekha Sharma
Reply
Hi please check the table SKB1and field XOPVW
Bottom of Form
Vuppala Venkata ... Posts: 901 Registere d: 3/17/06 Forum Points: 1,748 Top of
Thanks & Regards Phaneendra
Re: open item management tick status for all gl Posted: Jul 16, 2009 7:20 AM in response to: Rekha Sharma
Reply
Hi, Open item managed tick is available in the Company code level and not in chart of account level.
Form Bottom of Form
Go through with the TCODE :FSS0, which is a GL Master at company code level , in that first f irst tab "Control data" tab, you can see that. Table for this is SKB1 and the field is XOPVW VVR
Dhar aD Posts: 4 Registere d: 7/14/09
Re: open item management tick status for all gl Posted: Jul 16, 2009 8:40 AM in response to:
Reply
Forum Points: 0 Top of Form Bottom of Form
Mallavajjula ra...
Posts: 15 Registered: 2/6/09 Forum Points: 8 Top of Form
Bottom of Form
Rekha Sharma Rekha, Please go to Tcode se16 and put input table name as a BSIS and BSAS (for cleared items), you will come to know how many G/L Account have a active open item management. Field name for the same is XOPVWIndicator: Open item management? Re: open item management tick status for all gl
Reply
Posted: Jul 16, 2009 8:54 AM in response to: Rekha Sharma Hi, 1. First got to the transaction se16 , give table T001 and give the COA in the field KTOPL then derive all the respective CC(BUKRS) assigned in it. 2. Then Go to SKB1 and give all the field values in BUKRS which are derived above and flag the field XOPVW as "x" and execute Now you are going to get all
the OI mgmt enabled GL accounts for a particular COA. Definately this is going to resolve your Querry.
Dear Gurus: In your real implementations implementations in the US, how the tax configuration for sales, use and purchase taxes is done? - Do you use tax calculation wihin SAP or use external tax calculation package such as vertex? Points available for answers from real implementations implementations in the US.
Thanks in advance. sunil bahunap ati Posts: 496 Registere d: 7/25/07 Forum Points: 1,294 Top of Form Bottom of Form
Re: US Tax Configuration Procedure Posted: Aug 3, 2007 10:51 PM in response to: Mohan Das
Reply
I worked in two Different project where both the methods are used One of my project all the things for the sales and use tax were configured in the system. In an other one project we used Sabrix software for the sales and use tax. My personal
experience says that use the bolt on software like sabrix is much more convinent to use than maintaining all the different tax codes and jursidcation and rates and changing them in sap. If its in sabrix or vertex then those organisation provide you with the changed information and easier to maintain than in sap. Assign points if helpful
Important Tables in SAP FI Financial Accounting Table Name Description Financial Accounting FBAS BKPF GJAHR BSEG GJAHR / BUZEI BSIP WAERS / BLDAT /
Important Fields
Financial Accounting “Basis” Accounting Document Header
BUKRS / BELNR /
Accounting Document Segment
BUKRS / BELNR /
Index for Vendor Validation of Double
BUKRS / LIFNR /
Documents BELNR / GJAHR / BUZEI BVOR Inter Company Posting Procedure GJAHR / BELNR EBKPF Accounting Document Header (docs from GJHAR / GLEBK External Systems) FRUN Run Date of a Program KLPA Customer / Vendor Linking NKOAR / PNTYP
XBLNR / WRBTR / BVORG / BUKRS / GLSBK / BELNR /
PRGID NKULI / NBUKR / / VKULI / VBUKR /
VKOAR KNB4 KNB5 MABER KNBK BANKL / BANKN KNC1 GJHAR KNC3 GJAHR / SHBKZ
Customer Payment History Customer Master Dunning Data
KUNNR / BUKRS KUNNR / BUKRS /
Customer Master Bank Details
KUNNR / BANKS /
Customer Master Transaction Figures
KUNNR / BUKRS /
Customer Master Special GL Transactions KUNNR / BUKRS / Figures
LFB5 MABER LFBK BANKL / BANKN LFC1 GJHAR LFC3 GJHAR / SHBKZ VBKPF BELNR / GJHAR
Vendor Master Dunning Data
LIFNR / BUKRS /
Vendor Master Bank Details
LIFNR / BANKS /
Vendor Master Transaction Figures
LIFNR / BUKRS /
Vendor Master Special GL Transactions
LIFNR / BUKRS /
Figures Document Header for Document Parking
AUSBK / BUKRS /
FBASCORE
Financial Accounting General Services “Basis”
KNB1 LFA1 LFB1 SKA1 SKAT SAKNR
Customer Master (Company Code) Vendor Master (General Section) Vendor Master (company Code Section) G/L Account Master (Chart of Accounts) G/L Account Master (Chart of Accounts –
KUNNR LIFNR LIFNR KTOPL SPRAS
Description) Accounts Blocked by Dunning Selection
KOART / BUKRS /
Dunning Data (Account Entries)
LAUFD / LAUFI /
MAHNS KONKO / MABER MHNK KOART / BUKRS /
/ BUKRS / BUKRS / SAKNR / KTOPL /
KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS)
General Ledger Accounting: Basic Functions- G/L Accounts
SKAS SAKNR / SCHLW
G/L Account Master (Chart of Accounts – SPRAS / KTOPL /
SKB1 FI-GL-GL (FBSC) FIGLREP TSAKR FI-GL-GL (FFE) KOMU
Key Word list) G/L Account Master (Company Code) BUKRS / SAKNR General Ledger Accounting: Basic Functions - R/3 Customizing for G/L Accounts Settings for G/L Posting Reports MANDT Create G/L account with reference BUKRS / SAKNR General Ledger Accounting: Basic Functions - Fast Data Entry Account Assignment Templates for G/L KMNAM / KMZEI Account items
FI-AR-AR (FBD)
Accounts Receivable: Basic Functions - Customers
KNKA
Customer Master Credit Management : Central Data Customer Master Credit Management : Control Area Data Credit Management : FI Status data
KUNNR
Accounting Data – A/R and A/P
RELID / SRTFD /
KNKK KNKKF1 KKBER / REGUL RFRR SRTF2
KUNNR / KKBER LOGSYS / KUNNR /
Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) General Sections
Transactions –
PAYR HKTID / RZAWE / PCEC HKTID / STAPL
Payment Medium File
ZBUKR / HBKID /
Pre-numbered Check
CHECT ZBUKR / HBKID /
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments F111G
Global Settings for Payment Program for MANDT Payment Requests Cash Management Line Items in Payment KEYNO Requests Payment Requests KEYNO
FDZA PAYRQ
What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?
As far as general ledger master data is concerned, con cerned, the following tables are involved : Table name : SKB1 : G/L Account Master ( Company Code) Fields: BUKRS : Company Code SAKNR : G/L Account Table name : SKA1 : G/L Account Master Master ( Chart of Accounts ) Fields: KTOPL : Char of Accounts SAKNR : G/L Account Table name : SKAT : G/L Account Master Master Record ( Chart of Accounts : Description ) Fields: SPRAS : Language KTOPL : Char of Accounts SAKNR : G/L Account *-- Viji Balakrishnan Fast Links: CO-AA Tables •
Important Tables in SAP CO
•
Important Tables in SAP AA
Get help for your SAP FI/CO problems Do you have a SAP FI/CO Question? SAP Books SAP Certification, Interview Questions, Functional, Basis Administration and ABAP Programming Reference Books SAP FICO Tips SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum Best regards, SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective respective companies. The site www.sap-img.com www.sap-img.com is in no way affiliated with SAP AG. Every effort is made to ensure the content integrity. integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com www.sap-img.c om or the content authors.
Hi, We have done GR for an Asset PO and thereafter the asset got depriciated. Later, no invoice received from vendor for this PO and hence decided to close the open GR/IR account.
We tried doing MR11, but as asset already got capitalised and depriciated, its not allowing us to post account maintainence entry - Givinbg error "Dep area 10 conflicts with net book value rule" We cannot even reverse GR as the Asset is being used. probable solution could be to remove direct posting flag for GR/IR clearing account and then to make a maual entry by debiting GR/IR account and crediting "gain from vendor a/c" and later to maually clear the open items.
Please advise. Thanks, Pavan. Hello, I would like to prevent the creation of DME file in Proposal Step of Payment Run (F110). Is it possible to suppress "Create Payment Medium" checkbox? Many Thanks mahesh badrinar ... Posts: 27 Registere
Re: F110 How to prevent the creation of DME file in Proposal Step
Reply
d: 6/19/09 Forum Points: 44 Top of Form Bottom of Form
Sonali A Tamb
Posted: Jul 14, 2009 7:09 AM in response to: ZARA99 hi , Kindly note that the DME file will not be created during the prposal run it will be created during the payment run. kindly check FDTA (dme administration)after administration)after the proposal run for the confirmation
Re: F110 How to prevent the
Reply
at Posts: 40 Registere d: 7/2/09 Forum Points: 64 Top of Form Bottom of Form
creation of DME file in Proposal Step Posted: Jul 14, 2009 8:44 AM in response to: ZARA99 Hi, Just do not tick the "Create Payment Media" checkbox during proposal run. The matter will be solved. Regards Sonali T
