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

Multi Currency Sales Invoice Lines

(0) Share

Report

Posted on by rcboiler

1,122

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

All responses (4)

Answers (0)

Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

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 9,274 Super User 2024 Season 1 on at

Like (0)

Report

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 75,942 Super User 2024 Season 2 on at

Like (0)

Report

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.

Thanks

ZHU
Suggested answer

MahGah 15,433 on at

Like (0)

Report

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.