Skip to main content
Business Central forum
Suggested answer

Multi Currency Sales Invoice Lines

editSubscribe (0) ShareShare
Posted on by 1,112

Table 133 can be used to get sales invoice line details (PowerBI, Excel, etc...) but all of the values are in the invoice currency (not the local currency).  Is there a table that has the line details in the local (base) currency?

  • Suggested answer
    Amit_Sharma Profile Picture
    Amit_Sharma 2,545 on at
    RE: Multi Currency Sales Invoice Lines

    Use G/L Entry table or Cust. Ledger Entry Table and field is "Sales (LCY)"


    Amit Sharma

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,180 Super User on at
    RE: Multi Currency Sales Invoice Lines


    look this


  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,978 Super User on at
    RE: Multi Currency Sales Invoice Lines

    Hi,Table 133 is Sales Invoice Line (113), there is no problem with the table.


    Then you can use the field suggested by MahGah to calculate the amount in your local currency. But it's on table Sales Invoice Header (112). It needs to be linked with Document No.


    Hope this helps as well.



  • Suggested answer
    MahGah Profile Picture
    MahGah 15,395 on at
    RE: Multi Currency Sales Invoice Lines


    As far as I know table 133 is "incoming document" and has no financial data.

    Table 112 is Posted Sales invoice. In that table you can see a field named "Currency Factor" you can use that to convert your data to your local currency

    Or for line you can use table 113 then from table 112 find the "Currency Factor" then convert the amount to local currency.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…


Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans