Share
ReportHi!
Could someone please tell me how to download Jobs list w/ Dimensions in Business Central 365 ver 17?
Thanks in advance!
KyShrestha
Categories:
You’re offline. This is a read only version of the page.
10
Hi!
Could someone please tell me how to download Jobs list w/ Dimensions in Business Central 365 ver 17?
Thanks in advance!
KyShrestha
You can download Job list with dimension at once. I mean you don't have to combine two data.
Describe tables as below and check ON "Dimension as columns" field on configuration package.
This is a sample data of job.
Downloaded Excel have dimension data like below.
I hope this helps you.
Thank you.
S.Kawamura
As two lists that you could combine later. Try creating a configuration package. Include the jobs table (167) and also the default dimension table (352). With the second table use the ability to add a filter and add the “Table ID” field. Use the filter value of 167. Now export to excel using the dedicated button.
In excel you can then combine the two together using a vlookup so you have one list with multiple columns per dimension. Worth noting that job tasks can have their own dimensions separate to the main job record
It would be possible to have both global dimensions as fields on the job card or jobs list pages. It would require a small development though
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (