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

Package tracking data on Sales Invoice - Can't find that field in Salesinvoices table

(0) Share

Report

Posted on by mmarques

Hi all,

I'm trying to make a report in Power BI and I can't find the field marked in red in the salesinvoices table. Does anyone know how I could get the Package tracking information?

Thanks!

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 81,365 Super User 2025 Season 1 on at

Like (1)

Report

RE: Package tracking data on Sales Invoice - Can't find that field in Salesinvoices table

Hi, as MahGah mentioned, this field just not display on the page you connect to in Power BI.

One of the options is to publish a new page to the WebService, and another option is to customize a new API page.

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

Hope this will help.

Thanks.

ZHU
Suggested answer

MahGah 15,437 on at

Like (1)

Report

RE: Package tracking data on Sales Invoice - Can't find that field in Salesinvoices table

Hi

This is because that field did not publish through webservice. My assumption is that you published page 132 in order to use in Power BI

Go to Webservice then try Action -> New Document -> Create Dataset. Then try to use different options. The goal is that you use page 132 then get to the screenshot that you can select different fields to publish. Then you can select that field to publish and show up.

First try Edit and then see if you can find the Sales Invoice header web service then add the field to it if it worked.