Hi,
Please do as specified in Note 377853 - FBCJ: Opening and closing balance.
Summary
Symptom
This note is an advice note for the FI cash journal. It answers the following questions:
How is the opening balance of a period calculated in the cash journal?
How is the closing balance calculated?
What are the relevant notes?
Additional key words
Cash journal, opening balance, closing balance, fiscal year balance carryforward, balance table, balance carryforward
Cause and prerequisites
None
Solution
General notes:
If you want to create and execute a new cash journal, then you need the required Customizing to do this, among other things you must also specify a G/L account to which the documents from the cash journal should be posted. It is recommendable to create a new account for this, however, you can also use an existing account.
In the latter case, you must bring the corresponding G/L account in the general ledger to balance 0 using a manual clearing entry at the start of the exclusive postings via the cash journal. Then change the account to "Post automatically only" in the master record, and then you can use the cash journal as an opening balance to repost the amount that is posted to the clearing account,and you then have the corresponding amount as the first posting.
The first time you use the cash journal, therefore, the cash journal is balanced to zero as well as the assigned G/L account in this currency (the account itself needs not be managed in the cash journal currency).
Note:
Please absolutely make sure that flag "Balances in local currency only"
is NOT set in the master record of the assigned G/L account!
For performance reasons, the system updates a balance total for the particular day that updates the cash on hand for this day in parallel to the individual postings for every posting in the cash journal. The information in this balance table is therefore redundant since you can obtain it at any time from the line items of the individual postings.
Calculating the opening balance
The system then reads the balance table to determine the opening balance and searches for the next entry that is before the starting date of the display period. This is generally the preceding day.
If there is such an entry, then the system displays it as the opening balance for the display period.
If the system does not find any preceding entry in the balance table or if the balance table is blank (for example, due to deletion by report RFCJ1 from Note 197898), then the entire document table of the cash journal runs, and the system calculates the balance until then in the cash journal. For this purpose, please implement Note 419959.
Caution:
This logic is new as of Note 371936 (R/3 Support Package 25 for Release 4.6B or 14 for Release 4.6C)
Up to then, when the system could not find a balance entry (in the balance table), the system read the fiscal year balance carryforward of the corresponding fiscal year in the relevant G/L account, and then it summed up all postings based on this from the first day of the fiscal year until the first day of the display period.
The procedure was similar on the first day of a new fiscal year: Here the system used the fiscal year carryforward as an opening balance directly and not the last preceding entry in the balance table.
This was no longer viable since inconsistancies could quickly arise due to a late fiscal year balance carryforward as well as posting to the G/L account with cash journals of several currencies. Therefore, check whether there really was a balance of zero when first using the cash journal.
Calculating the closing balance
The closing balance results from opening balance plus the total of the line items of the display period.
If this invoice is incorrect for a display period, there may be an inconsistancy within the documents. In this case, execute report RFCJ5 from Note 374505 (provided you are in a company code which is not subject to the (extended) withholding tax - if the latter is the case, contact SAP).
If the closing balance does not correspond with the opening balance of the display period that directly follows, then there is an incorrect entry in the balance table. In this case, execute report RFCJ1 from Note 197898 for the corresponding cash journal to remove this entry.
Relevant notes
197898 "FI cash journal: Difference betw.balance & line itm"
It contains report RFCJ1 for resetting the balance table
R/3 Support Package 15 (Rel.4.6B), R/3 Support Package 7 (Rel.4.6C)
323990 "FBCJ: wrong balance aftr deletng cash journal doc"
R/3 Support Package 15 (Rel.4.6B), R/3 Support Package 7 (Rel.4.6C)
324051 "FBCJ: Wrong balance aftr reversing cash journal doc"
R/3 Support Package 15 (Rel.4.6B), R/3 Support Package 7 (Rel.4.6C)
326619 "FBCJ: Wrong balance after resetting balance table"
R/3 Support Package 16 (Rel.4.6B), R/3 Support Package 7 (Rel.4.6C)
333222 "FBCJ: incorrect balance after check deposit"
R/3 Support Package 8 (Rel.4.6C only)
368409 "FBCJ: incrrct balance calcultn (46B:HP22, 46C:HP11)"
R/3 Support Package 25 (Rel.4.6B), R/3 Support Package 14 (Rel.4.6C)
371936 "FBCJ: Incorrect balance for fiscal year carryfwd"
R/3 Support Package 25 (Rel.4.6B), R/3 Support Package 14 (Rel.4.6C)
374505 "FBCJ: Amount changed in document -> wrong balance"
It contains report RFCJ5 for adjusting documents
R/3 Support Package 25 (Rel.4.6B), R/3 Support Package 15
(Rel.4.6C)
"419959 FBCJ: Falscher Saldo nach Geschäftsjahresübergang"
Source code corrections
Header Data
Release Status: Released for Customer
Released on: 12.07.2001 22:00:00
Priority: Recommendations/additional info
Category: Consulting
Primary Component: FI-BL-PT-CJ Cash Journal
Releases
Software
Component Release From
Release To
Release And
subsequent
SAP_APPL 46 46B 46B X
SAP_APPL 46C 46C 46C X
SAP_BASIS 46C 46D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.