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

Multi Currency Sales Invoice Lines

(0) Share

Report

Posted on by rcboiler

1,202

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,529 on at

Like (0)

Report

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 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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,397 on at

Like (0)

Report

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,557 on at

Like (0)

Report

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