Allocation of Receivables and Payables According to Remaining Life: Generating Postings in fi

Use

The transfer postings to be generated are saved in a batch input session. In the next activity, you process this session.

Procedure

1. Call up the transaction using the menu path as follows:

Menu Path	Choose System ® Services ® Batch Input ® Sessions
Transaction Code	SM35

2. Choose the tab page.

Depending on the status of your session, you can view the session again on the appropriate tab.

3. Select your session, then choose Process.
4. In the dialog box, select Display errors only, then choose Process.

The system tells you that processing was completed successfully.

5. Choose Session overview.

Your session should now have the status Processed.

6. Choose until the overview tree appears.
7. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Receivable ® Document ® Display
Transaction Code	FB03

8. Enter the following data:

Field	Data
Document number	Noted document number + 1

9. Choose .

The posting appears as follows on the Document Overview screen:

Credit ® Account 140020 (domestic customer receivables with remaining life of more than one year)

Debit ® Account 140099 (domestic customer receivables)

10. Choose until the overview tree appears.

To see what happens in Accounts Payable, you can now enter a vendor invoice with a remaining life of more than one year in the same way.

Execute the program for allocation again, this time for account type K (vendor).

Allocation of Receivables and Payables According to Remaining Life: Executing Programs in fi

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Receivable ® Periodic Processing ® Closing ® Regroup ® Receivables/payables
Transaction Code	F101

2. Enter the following data:

Field	Europe	North America
Company code	1000	3000
Balance sheet key date	Last day of current period	Last day of current period
Sort method	SAP	SAP
Selections tab
Customer	1174	3176
Postings tab
Carry out postings	Select	Select
Batch input session name	SAPF101	SAPF101
Document type	DR	DR
Posting date	Last day of current period	Last day of current period
Posting period	Current period	Current period

3. Choose .

If any warning messages appear, choose .

The system displays a log that lists the postings that were carried out.

· 1. page: Valuation of domestic receivables with remaining life of more than one year (for selected items)

· 2. page: Valuation of all receivables with remaining life of more than one year (for

selected items)

· 3. page: Valuation of all receivables in selected company code with

remaining life of more than one year (for selected items)

· 4. page: Valuation of all company codes (for selected items)

· 5. page: List of documents to be generated with posting date and document number and specification of batch input session



If you had also carried out the report for payables, the system would have evaluated payables with remaining lives of more than one and more than five years.

4. Choose until the overview tree appears.

Allocation of Receivables and Payables According to Remaining Life: Entering Invoices in fi

Use

In this process, you enter a customer invoice with a remaining life exceeding one year. For this reason, and according to the 4th EU directive, the item must be transferred to a special account if it is still open at the end of the period.

You post the invoice directly in Financial Accounting, there is no integration with the Sales and Distribution application. This makes it easier to post backdated invoices.

Procedure

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Receivable ® Document Entry ® Invoice
Transaction	FB70, FBL5, FD03



Make sure that the correct company code is specified.

If the system displays the Enter company code dialog box, enter the following data:

Field	Europe	North America
Company code	1000	3000

Otherwise, choose Environment ® Set company code and confirm the dialog box Exit processing with Yes. In the dialog box, enter 1000 (Europe) or 3000 (North America).

Choose .

2. If the worklists are not displayed, choose Tree on.
3. On the Basic Data tab, enter the following data:

Field	Europe	North America
Customer	1174	3176
Invoice date	Today’s date -1 month	Today’s date -1 month
Posting date	Today’s date -1 month	Today’s date -1 month
Amount	100,000.00 (gross amount, including tax on sales/purchases)	100,000.00 (gross amount, including tax on sales/purchases)
Currency/rate (defaulted)	EUR	USD
Calculate tax	Select	Select
Tax code (defaulted)	AN	S1



If any warning messages appear, choose .

4. Choose Screen variants for items ® With business area.
5. Enter the following data:

Field	Europe	North America
Payment tab
Pmnt terms	Empty	Empty
Days (first field)	720 days	720 days
Days (other fields)	Empty	Empty
Table
G/L account	800200	800200
D/C (defaulted)	Credit	Credit
Amount in doc. curr.	100,000.00	100,000.00
Business area	1000	1000



To simplify this process, we have not defined a cost element for account 800200, which means that you do not need to assign a CO object, for example, an order number. You do not therefore need an additional account assignment. The system does not transfer the data to Profit Center Accounting.

6. Choose .

The system displays the address of the customer. If you want to display the open items for this customer or the bank details, choose OIs or Bank Details.

7. Choose Simulate.

The Document Overview screen appears and you can see your posting with the document items.

8. Choose .
9. Make a note of the document number.
10. Choose until the overview tree appears.
11. In the Exit Editing dialog box, choose Yes.

Valuation of Open Items in Foreign Currency: Displaying Documents

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Payable ® Document ® Display
Transaction Code	FB03

2. Enter the document number that you noted in the previous activity.

This is the document that was posted after the first foreign currency valuation.

3. Choose .

The document is displayed in foreign currency. The amounts are therefore zero.

4. Choose Choose.
5. In the dialog box, choose 1 SAP (Amount in document and local currency).

The amounts are now displayed in the company code currency.

6. Choose until the overview tree appears.

Additional Demo Information in fi

We entered fictitious exchange rates for 1999 for USD/EUR in the system. To maintain the rates yourself, proceed as follows:

1. Call up the transaction as follows:

Menu Path	Tools ® AcceleratedSAP ® Customizing ® Edit Project
Transaction Code	SPRO, OB08

2. Choose SAP Reference IMG.
3. Choose General Settings
® Currencies.
4. Choose the activity Enter Exchange Rates.
5. Choose New Entries.
6. Enter the following data:

Field	Data
ExRt	EURX
Valid from	Any
Indir. quot.	Any
From (currency)	USD
To (currency)	EUR

7. Choose .
8. If the system prompts you to enter a transport request, choose in the dialog box.
9. Enter the following data:

Field	Data
Short description	Current exchange rate

10. Choose .
11. Choose .

The system informs you that the data was saved.

12. Choose until the overview tree appears.

Valuating Open Items in Foreign Currency: Posting Exchange Rate Differences

Use

In this procedure, you valuate items in foreign currency at the end of a period in order to post gains or losses from currency valuations. To simplify the demo, you only run the program for an item you have just posted. That way, other IDES users can also go through the demo with their own documents.

If you ran the program for all open items in foreign currency, then all items posted to accounts that have open item management would be valuated. The valuation is carried out based on the individual value principle. Only individual items that are still open on the key date are considered for the valuation.

Prerequisites

The demo valuation method that is used for foreign currency valuation of open items is based on the lowest value principle. This means a valuation is only carried out using the lowest exchange rate. It might, therefore, be necessary to enter appropriate rates in Customizing before you post the vendor invoice. The following additional data is required for this example:

Field	Europe	North America
Date	01.09.1999	01.09.1999
Exch. rate type	EURX	EURX
From	USD	USD
To	EUR	EUR
Rate	1.07910	1.07910
Date	Last day of current period	Last day of current period
Exch. rate type	EURX	EURX
From	USD	USD
To	EUR	EUR
Rate	1.06910	1.08910

For more information about this process, see .

Procedure

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Payable ® Periodic Processing ® Closing ® Valuate ® Open Items in Foreign Currency
Transaction Code	F.05

2. Enter the following data:

Field	Europe	North America
Company code	1000	3000
Evaluation key date	Last day of current period	Last day of current period
Valuation method	DEMO	DEMO
Valuation in curr.type	10	10
Postings tab page
Bal.sheet preparation valuatn	Select	Select
Creating postings	Select	Select
Batch input session name	User name	User name
Posting date	Last day of current period	Last day of current period
Selections tab page
Valuate vendor open items	Select	Select
Vendor	1560	4940
Document number	Document number from the previous transaction	Document number from the previous transaction

3. Choose .

The system issues a list of the invoices you have posted in foreign currency. The translation rate and the rate used to valuate the amount are displayed. The furthest column to the right contains a valuation difference.

4. Make a note of the document number.
5. Choose Postings.

The posting for the loss from currency valuation is:

Debit ® Account 230010 (expense from currency valuation)

Credit ® Account 161099 (foreign vendor receivables (adjustment account).



For a valuation that does not affect the balance sheet, all postings are reversed on the reversal date.

6. Choose until the overview tree appears.

Valuating Open Items in Foreign Currency: Posting Exchange Rate Differences in fi

Use

In this procedure, you valuate items in foreign currency at the end of a period in order to post gains or losses from currency valuations. To simplify the demo, you only run the program for an item you have just posted. That way, other IDES users can also go through the demo with their own documents.

If you ran the program for all open items in foreign currency, then all items posted to accounts that have open item management would be valuated. The valuation is carried out based on the individual value principle. Only individual items that are still open on the key date are considered for the valuation.

Prerequisites

The demo valuation method that is used for foreign currency valuation of open items is based on the lowest value principle. This means a valuation is only carried out using the lowest exchange rate. It might, therefore, be necessary to enter appropriate rates in Customizing before you post the vendor invoice. The following additional data is required for this example:

Field	Europe	North America
Date	01.09.1999	01.09.1999
Exch. rate type	EURX	EURX
From	USD	USD
To	EUR	EUR
Rate	1.07910	1.07910
Date	Last day of current period	Last day of current period
Exch. rate type	EURX	EURX
From	USD	USD
To	EUR	EUR
Rate	1.06910	1.08910

For more information about this process, see .

Procedure

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Payable ® Periodic Processing ® Closing ® Valuate ® Open Items in Foreign Currency
Transaction Code	F.05

2. Enter the following data:

Field	Europe	North America
Company code	1000	3000
Evaluation key date	Last day of current period	Last day of current period
Valuation method	DEMO	DEMO
Valuation in curr.type	10	10
Postings tab page
Bal.sheet preparation valuatn	Select	Select
Creating postings	Select	Select
Batch input session name	User name	User name
Posting date	Last day of current period	Last day of current period
Selections tab page
Valuate vendor open items	Select	Select
Vendor	1560	4940
Document number	Document number from the previous transaction	Document number from the previous transaction

3. Choose .

The system issues a list of the invoices you have posted in foreign currency. The translation rate and the rate used to valuate the amount are displayed. The furthest column to the right contains a valuation difference.

4. Make a note of the document number.
5. Choose Postings.

The posting for the loss from currency valuation is:

Debit ® Account 230010 (expense from currency valuation)

Credit ® Account 161099 (foreign vendor receivables (adjustment account).



For a valuation that does not affect the balance sheet, all postings are reversed on the reversal date.

6. Choose until the overview tree appears.

Valuating Open Items in Foreign Currency: Entering Invoices in Foreign Currency in fi

Use

You now post a vendor invoice in foreign currency so that you can valuate open items in foreign currency in the next transaction.

You post the invoice directly in Financial Accounting, there is no integration with MM (Materials Management). This makes it easier to post backdated invoices.

Procedure

1. Call up the transaction as follows:

Menu Path	Accounting ® Financial Accounting ® Accounts Payable ® Document Entry ® Invoice
Transaction	FB60, FBL1



Make sure that the correct company code is specified.

If the system displays the Enter company code dialog box, enter the following data:

Field	Europe	North America
Company code	1000	3000

Otherwise, choose Environment ® Set company code and confirm the dialog box Exit processing with Yes. In the dialog box, enter 1000 (Europe) or 3000 (North America).

Choose .

2. If the worklists are not displayed, choose Tree on.
3. On the Basic Data tab, enter the following data:

Field	Europe	North America
Vendor	1560	4940
Invoice date	15.03.2000	15.03.2000
Posting date	15.03.2000	15.03.2000
Amount	12,000.00 (gross amount, including tax on sales/purchases)	12,000.00 (gross amount, including tax on sales/purchases)
Currency/rate	USD	EUR
Calculate tax	Select	Select
Tax code	V9	I0



If any warning messages appear, choose .

4. Choose Screen variants for items ® With cost center.
5. Enter the following data:

Field	Europe	North America
G/L account	415000	415000
D/C (defaulted)	Debit	Debit
Amount in doc. curr.	12,000.00	12,000.00
Tax code	V9	I0
Cost center	1000	1000

6. Choose .

Business area 9900 is entered in the table automatically.

Account 415000 requires an assignment to a CO object, since it is defined as a cost element. Therefore you require an additional account assignment, for example cost center 1000.

The system displays the address of the vendor.

7. Choose Simulate.
8. Choose .
9. Make a note of the document number.
10. Choose .
11. In the Exit Editing dialog box, choose Yes.