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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Config. Package with D...
Microsoft Dynamics NAV (Archived)
Answered

Config. Package with Dimensions

(0) ShareShare
ReportReport
Posted on by Dwumor 100

Hi Experts,

We are uploading historical transactions into Dynamics NAV 2016 through the Config Package but I notice that the dimensions available in the fields of the Table ID 81 General Journal lines are only two which appears to be 2 short cut dimensions.

Client uses almost 6 dimensions for each line of posting so I am wondering if we could add additional fields to Table ID 81 and include more dimensions instead of the only two.

Is there a way out of this.

Many thanks in advance.

Regards

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Richard,

    We have 2 tools that help users import/export data with dimensions simply: one is built with Config. Package, one is Excel purely. However, you can do it via Config. Worksheet:

    - Search for Configuration Worksheet.

    - Create new line, choose Table ID.

    - Assign Package.

    - Activate Dimensions.

    - Export the Template.

    - Fill in data with Dimensions.

    - Import back the file.

  • Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Please check this video, it has an example.

    https://www.youtube.com/watch?v=R3rxKtTMTjg

  • Dwumor Profile Picture
    Dwumor 100 on at

    Hi Khoa,

    Many thanks for your feedback. How do activate the dimensions. Thanks on standby

  • Dwumor Profile Picture
    Dwumor 100 on at

    Hi Suresh,

    Thanks of for the information. I check the video and it appears the dimensions fields are already in the table 81. I want to know how the dimension field can be added to the Table , I think that is my difficulty.

    On standby for your advise.

    Regards

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Richard,

    To activate the dimensions, set true "Dimensions as Columns" for the Config. Line.

    Provided link from Suresh is good, Mohana has a detail Youtube guide video for this.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Review the video again it is just not importing 2 dimensions it is importing more than 2 which are on the table.

  • Verified answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Richard,

    Does it work for you? Otherwise, we can support you Licensed Tool to 31 December 2016 (whole year 2016 right :-) for your uploading historical transactions. Please contact our support email!

    Using steps are simple and straight forward:

    1. Add Dimensions in Config. Package Fields:

    Pic-2.png

    2. Export Template to Excel:

    Pic-2.png

    3. Fill in Data:

    Pic-3.png

    4. Import the Excel file.

  • Dwumor Profile Picture
    Dwumor 100 on at

    Thanks Suresh

  • Dwumor Profile Picture
    Dwumor 100 on at

    Many thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans