Skip to main content

Notifications

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

  • JacoBosch Profile Picture
    JacoBosch 55 on at
    RE: Fields and Values not pulling through with Configuration Package

    Thanks, this helped :-)

  • JacoBosch Profile Picture
    JacoBosch 55 on at
    RE: Fields and Values not pulling through with Configuration Package

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

  • JacoBosch Profile Picture
    JacoBosch 55 on at
    RE: Fields and Values not pulling through with Configuration Package

    Hi ZHU

    Thanks for this. Was very usefull :-)

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,878 Super User 2025 Season 1 on at
    RE: Fields and Values not pulling through with Configuration Package

    Hi, just adding some info.

    https://cloudblogs.microsoft.com/dynamics365/it/2019/08/07/configuration-package-tips-from-business-central-support/

    pastedimage1659486441628v1.png

    An example in NAV:

    https://www.innovia.com/blog/rapidstart-data-clean-shortcut-dimension-population

    Hope this helps as well.

    Thanks.

    ZHU

  • Verified answer
    S.Kawamura Profile Picture
    S.Kawamura 1,520 on at
    RE: Fields and Values not pulling through with Configuration Package

    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
    AD-22040756-1 624 on at
    RE: Fields and Values not pulling through with Configuration Package

    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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans