cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor/Customer banlance confirmation

Former Member
0 Kudos

hi

Can any one tell me about Vendor/Customer banlance confirmation basically for 31st march with balance conformation letter send to party, is it any transaction for this activity in stander SAP Report.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello

If you have a large number of customers or vendors, you can use the function Group customers or Group vendors when creating the balance confirmation.

You can find this function in the Accounts Receivable or Accounts Payable screen under Periodic processing ® Print correspondence ® Balance confirmation ® Group customers or vendors.

This program enables you to group your customer and vendor accounts in intervals of a specific size or in a specific number of intervals. The grouping can only ever be applied to one company code.

You could, for example, divide your customers into five equal-sized intervals. The system creates this grouping and then gives you a list of the interval divisions together with the number of customer accounts contained in each division. You can then create five different variants for balance confirmation program by simply entering in the Customer field the interval divisions created by the system. You can then let these balance confirmation programs run parallel in the background.

Balance Confirmation

Purpose

Obtaining the balance confirmation – a part of balance sheet preparation for the year-end – corresponds to the activity of an accounts receivable accountant. The customer has the following options:

· Confirm total balances

· Not confirm the total balances

· Confirm or not confirm individual items

· Not give a reply, or to specify reasons why the accountant cannot process the balance confirmation

For paper balance confirmations, the reasons for differences or comments were usually entered on the reverse of the confirmation for individual items. The paper confirmation was then sent back to both the SAP accounting clerk and also the auditor.

With SAP Biller Direct this function is now available in the Internet as a balance confirmation at the current date, or at any specified date.

By using this process your business partner can compare the open items at the current date with his accounting.

Prerequisites

· You have made the settings in the customer master data as described in Entries in the Customer Master Data.

· To enable an e-mail to be sent to the external auditor, you have made the following settings:

¡ With the configuration tool Extended Configuration Management (XCM) (see section Configuring the Web application with XCM) you have activated the option for sending an e-mail to the auditor.

¡ You have entered the e-mail address of the external auditor in Customizing for Financial Accounting. You do this under Accounts Receivable and Accounts Payable ® Business Transactions ® Closing ® Count ® Balance Confirmation Correspondence ® Define Reply Addresses for Balance Confirmation

¡ You have entered the company code address data in Customizing for Financial Accounting. You do this under Financial Accounting Global Settings ® Company Code ® Enter Global Parameters

Process Flow

...

1. Your business partner logs on to SAP Biller Direct.

2. He then chooses Balance Confirmation in the menu bar.

A standard letter to your business partner is then displayed with the request that the balance be checked for agreement with the books of the business partner. An itemization of the open items is attached. This means the open items are displayed at the current date (key date) having the same details as the usual open item display. They contain, in addition to open bills credits, payments and on account payments, non-cleared down payments and bills of exchange.

3. To display the bill details, your business partner clicks on the PDF symbol.

4. To confirm individual items or enter a note on them, your business partner selects Yes or No. For each line item he can enter a comment explaining any differences.

5. To make the confirmation easier, your business partner can either print the list or download it in Excel or CSV format.

6. To reply to the communication, your business partner chooses Reply.

He can either confirm agreement of the balances or comment on any differences. In doing so, he can supply the individual items with appropriate notes, or enter a general remark.

7. Once your business partner has selected confirmed, no confirmation or no reply, the balance confirmation is sent to the accounting clerk. If you have made the necessary settings, an e-mail is also sent to the external auditor.

Result

You receive a balance confirmation. The result of the balance confirmation is sent as a text e-mail to the accounting clerk assigned in the SAP system and to the external auditor.

Reg

assign points if useful

Former Member
0 Kudos

Hi

I have a doubt, after executing in TCOde:F.1A, only number of vendors is displayed, but not the balances .If I want the Print Out , how the same can be executed. Pls explain

Regards

Veena Kunthe

Former Member
0 Kudos

hi,

can change letter data & company log please guide