Dimensions in Rapid Start Gen Journal Excel Template

fiver1967
fiver1967 Member Posts: 2
edited 2014-04-02 in NAV Three Tier
I am having problems creating an Excel Import for table 81 (General Journal) that includes the Dimensions. I have gone through the video tied to the link below and have done the "Dimensions as Columns" step and I can see that it did add the Dimension fields to the table. However, it added the fields with no "Processing Order" and no "Relation Table ID". The link below never gets to the point where it shows how the Dimensions are added to the Excel template once they are showing in the Table --Fields.

http://mohana-dynamicsnav.blogspot.com/ ... -conf.html

When I do the Excel - Export to Excel Step, the template does not include any of the Dimensional fields. Every other filed marked as "Include Field" shows up in Excel but not the Dimensional fields. I know I must be missing something simple, but I cannot figure out what it is.

Any assistance would be appreciated.

Thanks!

Comments

  • el1t_swe
    el1t_swe Member Posts: 1
    Hi,
    I had the same issue, you don't even need to do any modification as Mohana suggests.

    Have a look at this post:

    https://support.microsoft.com/en-us/help/2780200/dimensions-that-are-added-in-an-excel-worksheet-are-not-assigned-to-the-records-after-you-import-the-excel-worksheet-in-microsoft-dynamics-nav-2013

    Follow the steps below. You need to export/import data through the CONFIGURATION WORKSHEET and not the Rapid Start Pacakge.

    To import the Excel worksheet correctly, follow these steps after you apply the code fix:

    1. On the Configuration Worksheet page, add a table that can have shortcut dimensions assigned to it, for example, the G/L Account table (15).
    3. Click Actions, and then click Assign Package.
    4. Create new package, fill in the Code value and the Description value, and then click OK to assign the package to the worksheet line.
    5. On the worksheet line, enable the Dimensions as Columns setting.
    In the confirmation dialog box, click OK.
    6. Click Export to Template.
    7. Define dimensions for the customer in the Dimension columns. They are displayed as the last columns on the spreadsheet.
    8. Save the Excel worksheet, and then import it back to the Configuration Worksheet page by using the Import from Template action on the ribbon.
    9. Click Apply Data.

    After you do this, the account that you added in the Excel worksheet is added in Microsoft Dynamics NAV. You can see that the account has shortcut dimensions that you assigned to it in the Excel worksheet.
    //Arthur

Categories