Small and medium business | Business Central, N...

Multi Currency Sales Invoice Lines

(0) Share

Report

Posted on by rcboiler

1,236

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

MahGah 15,583 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,464 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

look this

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

DAniele

Was this reply helpful? Yes No
Suggested answer

Amit 2,561 on at

Like (0)

Report
Copy link

Link copied!

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

erpconsultors.com/.../

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No