Skip to Content

How to do query which will convert local currency in system currency in SAP B1?.

Hi all,

I have many Goods Receipt PO which are in 2 currencies, ones are in local currency and other ones are in system currency.

I want to do query which will display all documents in system currency.

How can I do that query which will convert local currency in system currency in SAP B1?

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 27, 2017 at 03:26 PM

    Hi Johan,

    It works, I used SC.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27, 2017 at 12:54 PM

    Hi,

    All document (header and row) tables contain monetary values in threes:

    1. Value in document currency. For example OINV.DocTotal, INV1.LineTotal
    2. Value in foreign currency. For example OINV.DocTotalFC, INV1.TotalFrgn
    3. Value in system currency. For example OINV.DocTotalSy, INV1.TotalSumSy

    The bad news is, these fields do not have uniform naming conventions, so you may have to do some searching to find the right ones.

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded