Skip to main content
Business Central forum
Answered

Fields and Values not pulling through with Configuration Package

editSubscribe (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

Categories:
  • 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 59,978 Super User 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
    Community member Profile Picture
    Community member 620 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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans