Vendor Account Statement

[msshihab1987]

Hi Friends,

Is it possible to show the customer line item in a vendor account statement. For the testing purpose i have assigned one customer into a vendor, by line item level we can see the both vendor and customer line item(in FBL1N by flagging Customer Item ). I need to generate a consolidated account statement of these vendor.

Thanks & Regards

Shihab

[sanilbhandari]

Hi

We have a scenario where our customers are also vendors for us and we are sending statements for the customers where line items for vendors are included. We have maintained the customer-vendor clearing in the master data in General Data tab by assigning the vendor and customer account in the respective masters and by maintaining the clearing with customer and vendor respectively under the payment tab of company code view.

We have made a copy of correspondence SAP06 and using the standard print program, RFKORD10, we are printing both the items in the output. You of course need to set up the correspondence type for your company code.

Thanks & Regards

Sanil Bhandari

[msshihab1987]

HI Sanil,

Thank you for your kind replay,

So you mean to say that , we have to customize the existing standard print program.

Shihab

[sanilbhandari]

Hi

We have just set up a custom form and assigned it to standard print program RFKORD10. Configuration has been done for our own correspondence type for our company codes.

The below link will be useful to you for configuration steps for Correspondence:

Let me know if you need any further inputs.

Thanks & Regards

Sanil Bhandari

[former_member781832]

Hi Mr. Sanil,

We have the same requirement as you mentioned above. It would be much helpful to refer your configuration steps. No link is attached above or not showing. Could you share again.

[former_member827712]

Hi Mr.sanil

This option available in FBL1N . You can run together from Fbl1n .but you must be configure in the master data as customer from XK01 or from editing XK02

Best regards

[Former Member]

Hi Shihab,

As per my knowledge we don't have any standard report in SAP to meet your requirements.  You can use FBL1N to consolidate the balance of both vendors and customers. Otherwise you have to take help of Abap consultant and modify the standard vendor balance report as per your requirement.  Thank you.

Regards,

Inthiyaz