Skip to main content
Business Central forum
Suggested answer

Multi Currency Sales Invoice Lines

editSubscribe (0) ShareShare
ReportReport
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?

Categories:
  • 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)"

    erpconsultors.com/.../

    Regards

    Amit Sharma

    www.erpconsultors.com

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

    Hi

    look this

    community.dynamics.com/.../sales-invoice-doesn-t-convert-amount-to-lcy

    DAniele

  • 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.

    pastedimage1670460374772v1.png

    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.

    pastedimage1670460591475v2.png

    Hope this helps as well.

    Thanks

    ZHU

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

    Hi

    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…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans