Description
This program carries out the foreigncurrency valuation
for accounts that are managed on an openitem basis.
The foreign currency valuation can be carried out in the local currencyand the parallel currency (group currency, hard currency, and so on).
The valuation is carried out on an individual basis. This means thatthe individual items are considered for the valuation, andspecifically, only those that are still open at the key date. Ifadjustment and reverse postings are required as a result of thevaluation, the program carries out these postings if required. Youenter the posting date for these postings before each valuation.
The result of the valuation is required for creating the financialstatements. You must therefore carry out the valuation before thegrouping of receivables and payableswith program SAPF101. You can however also carry out the valuations atother times, in order to determine the current value of receivables andpayables in foreign currency. Note thefollowing in each case:

• If you carry out a valuation as part of the preparations for the
financial statements, select the field "Valuation for FS preparations".The exchange rate difference from thevaluation is then noted in the document item. This is necessary for thefollowing reasons:
During payment clearing, or a new valuation, only the exchange ratedifference that is not already shown in the financial statements shouldbe posted.
If you value according to the strict lowestvalue principle
, you must retain the valuation difference from the previousvaluation run in order to establish whether there has been arevaluation or a devaluation.

• If you carry out a valuation that is not part of the financial
statement preparations, the valuation difference should not be noted inthe document item. You should therefore not select the field "Valuationfor FS preparations".
Valuation postings have to be reversed in the following cases:

• You have not carried out the valuation as part of the financial
statement preparations.

• Items that are cleared at the current date, but that were still open at
the key date were considered for the valation. These items must bevalued in order to establish their value at the key date for thecurrent financial statements.
The exchange rate difference postings are generated per general ledgeraccount and other criteria, such as currency and business area. Thedetermination of the expense or revenue account is done however fromthe valuation per general ledger account. For the posting, the systemrequires the specification of the accounts to which the expense orrevenue from the valuation should be posted. The balances of thereceivables and payables accounts are corrected by postings to separateaccounts. You display the receivables and payables accounts with therelevant adjustment accounts in the financial statements.
Process flow:
The open items of the customer, vendor, and general ledger accounts areread and balanced according to account and currency. The currency typefor the valuation is defined from the balance determined.
The balance can also be determined cross-account per group term (groupnumber).
The items are summarized under the invoice reference and valuedaccording to the method selected.
The valuation differences are saved in the documents in case avaluation that affects the financial statements is carried out.
The valuation differences are totaled and posted directly. For avaluation that affects the financial statements, only the cleareddocuments are reversed, otherwise, all postings are reset.
You can carry out the foreign currency valuation in various currencies,for example, company code currency, group currency, and so on. You canenter a valuation method for each currency. If no method has beenentered, no valuation is carried out. For example, you value the openitems in foreign currency using method M1 in company code currency, andwith method M2 in the hard currency.
For a valuation in an alternative valuation area, specify the requiredvaluation area (for example US-GAAP). US-GAAP). The accountdetermination is then carried out with the selected valuation area. Thevaluation differences are also saved, but have no effect for paymentclearing.
The postings in the alternative valuation area are reset automatically.
The valuation method defines amongst other things, the valuationprocedure (lowest value principle, strict lowest value principle), theexchange rate determination, and the summary of items for units thatcan be valued.

Precondition
The required valuation method has been defined. Check whether thisprerequisite has been fulfilled.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF
You have defined the account numbers for the expense and revenue fromthe valuation in the system. You should also define the numbers of thefinancial statement adjustment accounts for the receivables andpayables accounts. Check whether this prerequisite has been fulfilled.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF
For each foreign currency, an exchange rate isdefined in the system. Check whether this prerequisite has beenfulfilled.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF
The posting keys are already defined in the standardsystem.
If you use an alternative valuation area, this must have been created.
IF &DEVICE& = 'SCREEN'
Proceed
ENDIF
You must also have entered the account determination for thealternative valuation area.

Output
The results of the valuation are sorted according to company code,account type, general ledger account, and customer/vendor account. Theitems are output under the current reconciliation account, but thetransfer posting for the valuation is made to the originalreconciliation account. Where the reconciliation account has beenchanged, a list of the accounts used during posting is printed for eachnew reconciliation account.
You can determine the degeree of detail of the list using the valuationmethod.
At item level, the exchange rate used is printed if the item wasdevalued or revalued. The exchange rate is specified with zero if theexchange rate type required cannot be found in the exchange rate table.
If no new valuation on the basis of the valuation method selected ispossible, for example, a revaluation is not permitted, "*1" is enteredin the exchange rate field. If, using the lowest value principle, anitem that has already been valued is revalued at the acquisition rate,this is marked with "*2".
If the item was cleared after the key date, "+" is entered at the endof the line. The valuation postings for these items are automaticallyreversed by the program: The realized exchange rate is reset and thenew difference is posted to the expense or revenue account for realizedexchange rate differences.
The valuation results are summarized per customer/vendor account. Inthe summary, the valuation method and currency are output. Forexample, 100 USD is valued in company code currency (DEM), and groupcurrency (SFR).
The valuation results are then output compressed according to generalledger account, account type, company code, and total per run.
The documents posted, including their document number, are printed. Ifno document number is entered, this is a problem for posting theforeign currency valuation. The error code in the document number fieldindicates the error long text that is printed after the posting table.To correct the error, you can post the defective posting manually usingtransaction "Post valuation" (FBB1), and then rectify the cause of theerror.
For a valuation that affects the financial statements, the defectivepostings are written in a batch input session. This must be processedlater, otherwise differences arise on the adjustment account if thedocument is cleared.
If you require a microfiche line, the following is printed in thevariable part:
Field name,,,,Output length
Company code,,,,4 places
Group indicator,,,,6 places
Account type,,,,1 place
G/L account,,,,10 places
Account number,,,,10 places
Business area,,,,4 places
If the postings could not be carried out because the informationrequired, for example, the account numbers or posting keys, was notdefined in the system, this error is displayed at the end of the list.Maintain the numbers for the revenue and expense account.
Example for valuation postings
An invoice for 100 USD is posted in local currency, 170 DEM.
At the key date, the item is valued at an exchange rate of 1.50.
A valuation expense of ( 150 - 170 ) 20 DEM arises. This is posted as
follows:
Expense acct to FS adjustment acct at key date
230010 140099 20 DEM
For a valuation that affects the financial statements, the valuation
difference is noted in the item. When the invoice is cleared later, the
valuation difference is also cleared.
For a valuation that does not affect the financial statements, all
postings are reversed at the reversal date. You can specify a special
period as the reversal period.
Expense acct to FS adjustment acct at key date
230010 140099 20 DEM
Reversal
140099 230010 20 DEM
For a valuation that affects the financial statements, the cleareditems that were still open at the key date are also similarly reversed.Since clearing has already been carried out, the program has to resetthe valuation for these items itself.
Example of reversal in the case of a valuation that affects the
financial statements:
Transaction Posting
1.Invoice 100 USD 160 DEM
2.Payment 100 USD 157 DEM 230000 real. ex.rate dif.exp. 3 DEM
Bank 157 DEM
Customer 160-DEM
3.Valuation at 1.56 230010 Exp. from valuation to 4 DEM
140099 Adj. acct 4-DEM
Reverse posting foll.month 140099 Adj. acct to 3 DEM
230000 real.ex.rate dif.exp. 3-DEM
Posting of difference from 140099 Adj. acct to 1 DEM
valuation and realization (4-3) 280000 real.ex.rate dif.rev. 1-DEM

Further_hints
You can only run the program once at any one time for each companycode. If the program does not run successfully, the block remains andmust be manually deleted:
Delete the entries in table TBKOW that have the content "SAPF100".
Alternatively, you can create a report variant for SAPF100, and set theparameter "Adjustment run". The parameter is not visible and thereforeyou have to use a variable.