G/L Account balance display FS10n

FS10N - is the the transaction code used for GL Account Balance Display.
Difference in Last year Closing balance and Current year Opening Balance

• This will be corrected after running carry forward programme FAGLGVTR (for ECC 6.0)
• Rerun the f.16 in test mode, this might generate the posting which would fix the disbalance

Note 402917 - If the opening balance does not correspond to the closing balance of the previous year on an account even after a repeated balance carryforward, you must always check whether you are dealing with a retained earnings account. If so, then you should check for inconsistencies in your system. And then you can activate the parameter for individualbalances retained earnings account during the start process of the balance carryforward program SAPFGVTR. You then receive a list of all P+L accounts with single values, which are balanced for the value of the retained earnings account. This means that you can reproduce and check the balance on the retained earnings account.

Asset number not displaying in report
SE16 for table BSEG will display asset number with the account balance.

Special fields on FS10N:
FS10N > Settings>Special Fields
This would promt a warning message stating that this would change a cross client table.

For example, if you make a change at client 800, it will change the setting on other table ( client 000 up to client 999). So, always discuss with ABAP folks before these configurations are changed.

Difference between FS10n ad FBL3n

FBL3N – Display Change Line Items (gives the open item list)
FS10N – Display Acct Balances (gives the balance of transaction figure)

To say it very plain - Transaction FS10N displays balances, this balance could include many different asset numbers, drill down required for individual asset numbers. FBL3N displays detail, drill down not required.

In case you find that balances in the 2 transactions dont match:
1. Line item display was switched on after there had already been postings to the account (Check your master record for changes in FSS4 and see if the line item display was changed at any point. )
2. Archiving has been done (archiving line items but obviously keeping the account balance correct). It can be very time consuming, but you can always use SE16 on table BSEG (with your company code and account number as selection fields) to check the actual line items. Line item display uses one of the index tables (BSIS) and there can be differences between that and the actual document database, which SE16 will show you.
3. Check search criteria of FBL3N
4. Check the G/L account whether it is enabled to Line Item Display
5. Run the programm SAPF190 to check the gap
6. Check for your user role, if you have the complete authorization objects for T Codes FS10N and FBL3N. Please take the help of your Basis Consultant for that.
7. Execute the report TFC_COMPARE_V2 from SE38 and also see the program documentation (blue information button) on the selection screen of the report.
8. Run transaction SE38 and execute program RFSEPA01

Document Number Range

The document number range in SAP is used to define the allowable range (number interval) in which an SAP document number must be positioned and cannot overlap. It is used in all SAP modules, for example in Material Management (MM), we must assign a number range to Purchase Requisition (PR), Request For Quotation (RFQ), Purchase Order (PO), Outline Agreement documents, etc; in Sales Distribution (SD) we must assign a number range to Quotation, Sales Order, Delivery Order, Billing documents, etc. In FI module we must also assign number range to several FI documents, such as Customer Invoice, Customer Credit Memo, Customer Payment, Vendor Invoice, Vendor Credit Memo, Vendor Payment, G/L Account Posting documents.

The number range can be:

• Internal numbering: SAP R/3 stores the last used document number from the number range in the field “current number” and takes the subsequent number for the next document.

• External numbering: The user enters the original document number. The numbers usually are not used in sequence and therefore the system cannot store a “current number”. The numbers may be alphanumeric.

In FI module, the document number range has to be defined for the year in which it is used. Document number ranges can be defined:

• until a fiscal year in the future: At the beginning of each fiscal year the system continues to take the next number after the “current number”. It does not restart at the lower limit.

• per fiscal year: At the beginning of each fiscal year the document numbering starts again at the lower limit. This helps to avoid reaching the upper limit of a range.

We can assign one or more document types to each number range. In Document Type configuration we must define number range to be used for that document type.

Business Process associated with SAP FI module

Posting Keys

Posting Key is a 2 digit key to control line items. Posting Key config controls.

• Whether the posting is debit or credit.
• The type of account the entry will be made to. (G/L, Customer, Vendor, Assets, Material)
• Posting key for reversal, if document is reversed.
• Screen Layout – Fields can be suppressed, required or optional.
• Field status can be controlled using Posting Key Field status as well as Field status Group assigned to G/L.

Maintain Accounting Configuration : Posting Keys List
Posting keys	Name	Debit\Credit	Account Types
1	Invoice	Debit	Customer
2	Reverse Credit Memo	Debit	Customer
3	Bank Charges	Debit	Asset
4	Other Receivables	Debit	Customer
5	Outgoing payment	Debit	Customer
6	Payment Difference	Debit	Customer
7	Other Clearing	Debit	Customer
8	Payment Clearing	Debit	G\L Account
9	SPL G\L Debit	Debit	Customer
10	G\L postings	Debit	G\L Account
11	Credit Memo	Credit	Customer
12	Reserve Invoice	Credit	Customer
13	Reserve Charges	Credit	Customer
14	Other Payables	Credit	Vendor
15	Incoming payment	Credit	Customer
16	Payment Difference	Credit	Asset
17	Other Clearing	Credit	Customer
18	Payment Clearing	Credit	Customer
19	SPL G\L Credit	Credit	Customer
21	Credit Memo	Debit	Vendor
22	Reverse Invoice	Debit	Vendor
24	Other Receivables	Debit	Vendor
25	Outgoing payment	Debit	Vendor
26	Payment Difference	Debit	Vendor
27	Clearing	Debit	Vendor
28	Payment Clearing	Debit	Vendor
29	SPL G\L Debit	Debit	Vendor
31	Invoice	Credit	Vendor
32	Reverse Credit Memo	Credit	Vendor
34	Other Payables	Credit	Vendor
35	Incoming payment	Credit	Vendor
36	Payment Difference	Credit	Vendor
37	Other Clearing	Credit	Vendor
38	Payment Clearing	Credit	Asset
39	SPL G\L Credit	Credit	Vendor
40	Debit Entry	Debit	G\L Account
50	Credit Entry	Credit	G\L Account
70	Debit Asset	Debit	Asset
75	Credit Asset	Credit	Asset
80	Inventory Taking	Debit	G\L Account
81	Cost	Debit	G\L Account
82	inventory Difference	Debit	G\L Account
83	Price Difference	Debit	G\L Account
84	Consumption	Debit	G\L Account
85	Change in Stock	Debit	G\L Account
86	GR\IR Debit	Debit	G\L Account
89	Stock inwd movement	Debit	Material
91	Cost	Credit	G\L Account
92	inventory Difference	Credit	G\L Account
93	Price Difference	Credit	G\L Account
94	Consumption	Credit	G\L Account
95	Change in Stock	Credit	G\L Account
96	GR\IR Credit	Credit	G\L Account
99	Stock Outwd Movement	Credit	Material

G/L posting : F-02

Posting Your Transactions.

SAP Menu

- Accounting

- Financial Accounting

- General Ledger

- Document Entry

- F-02 - General Posting

We have a dialogue box,

Document Date:                      Type: SA                                 Company Code: VG01

Posting Date:                          period: Current Month         Currency Rate: USD

Document Number:                                                                Transaction date:

Psk'y:40 Account: 110000

(Note: 40- Debit G/L Account {Cash})

Next screen is: Account: 800000

50 - Credit G/L Account (Revenue)

Document Menu --> display

Save it.

General Ledger Account

Creating G/L Account:

SAP Menu

Purpose:

Creating 2 G/L Accounts (Cash 110000, Revenue 800000)

- Accounting

- Financial Accounting

      - General Ledger

                  - Master Records

                              - Individual Processing

                                                - FS00-Centrally

- G/L Account No.

- Company Code

- Open G/L account (Top left side)

- Create with Reference

You can see:

Reference Account G/L account       #  110,000 Company Code  #   3000 Click Yes

- Control Data

- Account currency – USD

- Posting without Tax allowed

- Line item display

- Short key

- Save It.

Do the same thing for the G/L Account: 800000