web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Fields and Values not pulling through with Configuration Package

(0) ShareShare
ReportReport
Posted on by 55

Hello,

I've set up 'n configuration package to import into a Payroll Journal Batch. Dimensions are included in the journal batch..

pastedimage1659447235556v2.png
Excel File


pastedimage1659447348357v3.png
Payroll Configuration Package


pastedimage1659448497398v8.png

pastedimage1659448547144v9.png
General Journal Payroll Batch with Dimension values not pulling through


The problem is:

1) Certain Dimension fields and the values from the Excel sheet are not pulling through to the Payroll Journal Batch. The only value that pulled through is: D_Cost Center (CC): 01. These fields are not pulling through with the values:

D_Class
Dimension Department
Demension_Filed Run
D_Region
D_Process Code

pastedimage1659447641421v5.png


pastedimage1659447491237v4.png



I've tried to use the Code or the Name in the Excel sheet. The Configuration Package settings, 'Dimension as Columns' is checked:

pastedimage1659448326528v7.png 


I'm not sure if mapping needs to be set up, as all the columns names are correct in the excel sheet..

Any idea why certain fields and values are not pulling through?

Thanks

I have the same question (0)
  • JacoBosch Profile Picture
    55 on at

    Thanks, this helped :-)

  • JacoBosch Profile Picture
    55 on at

    Awesome thanks, taking of 'Dimension as Columns, and adding it back did the magic

  • JacoBosch Profile Picture
    55 on at

    Hi ZHU

    Thanks for this. Was very usefull :-)

  • Suggested answer
    YUN ZHU Profile Picture
    96,368 Super User 2025 Season 2 on at
  • Verified answer
    S.Kawamura Profile Picture
    1,532 on at

    Hi,

    Did you check on "Dimensions as a column" field on configuration package line?
    pastedimage1659473614903v1.png

    If this column is ON, downloaded excel may have shortcut dimension field.

    I hope this helps you.
    S.Kawamura

  • Verified answer
    AD-22040756-1 Profile Picture
    642 on at

    1. Does your configuration package have the same number of fields as the excel file you are using? It looks like in the excel file you have 15 fields but in the configuration package you have 214 fields. Best practice is for the configuration package and excel file to have the same number and order of fields.

    pastedimage1659455145604v1.png

    In the configuration package, if you go to Table -> Fields you can select the fields to include. You can select the fields you would like included here, then export to excel to create a template you can use

    pastedimage1659455218430v2.png

    2. In your Config. Package Fields page I only see the 'D_Cost Center (CC)' dimension being available as a column. 

    pastedimage1659455312740v3.png

    If you have 'Dimensions as Columns' checked off you would see in this page all your dimensions. For example:

    pastedimage1659455432298v4.png

    Try taking off 'Dimensions as Columns' and then adding it back and see if you can now see all your dimensions in the 'Config. Package Fields' Page. One scenario is this config. package was created before your dimensions were setup which is why it only contains the one dimensions, refreshing the 'Dimensions as Columns' should update the list of dimensions

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,476

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 719 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans