Skip to Content

Report for exchange difference amount for vendor

Hi Colleagues,

We're on project and our customer wants to see the on report the sum of the amount when they post a document in another currency. Here is an example:

The screenshot below is the document with the company code currency. The third line is the amount of exchange currency but they want the sum of this amount with the payment vendor line item. In this case is debit vs. credit but there are many reports that SAP can sum this kind of amount with no signal.

Is there any report that we can show this amount?

Thank you.

JPA

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 18, 2015 at 02:54 PM

    HI JPA,

    Unfortunately, there is no such ready made report, you may need to have a bespoke report.

    May be you can consider

    Vendor Number

    Name

    Paid Currency

    Paid currency amount

    Local Currency Amount

    Payment document number

    House Bank

    Account ID

    Exchange Rate gain / loss amount

    Predominantly, you can use REGUP and REGUH tables.

    Kind Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi JPA,

      We had similar report, mostly they are based on BKPF, BSEG, REGUP and REGUH tables.

      If you believe, it can be addressed through queries, you may please give a try.

      Please note BSEG table cannot be included in the queries. However, vendor should be available in REGUP/REGUH tables.

      Hope this helps.

      Kind Regards,

      Ravi

  • Posted on Dec 04, 2015 at 12:29 PM

    Hi Mr. Ravi,

    Thank you in your reply. Yes, at this ECC 600 version, the BSEG table can't be assigned to queries.But on S/4 HANA we can.

    We'll try to do by tables mentioned by you.

    Thanks.

    JPA

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.