Saturday, 27 July 2013

How to include Dimensions in Conf. Package Table Fields while using Rapid Start Services in NAV2013

You must have seen my blog video "How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services" here.
http://mohana-dynamicsnav.blogspot.in/2013/04/how-to-import-and-post-opening-balances.html

You can see the Dimensions in Conf. Package tables fields but you cant see Dimensions as fields in Newly created package.

How to add the Dimensions in newly created package table fields?



Posted by at
Labels: ,
Location: Hyderabad, Andhra Pradesh, India

9 comments:

  1. Anonymous20 February 2014 at 07:32

    Hi Mohana,

    Thanks for sharing.
    however, i'm able to see the dimension field on the field selection, but i still couldn't export it to excel. example, [Area (dimension), DEPARTMENT (dimension)] as column in excel.
    please help and advise.

    Thank You.

    ReplyDelete
  2. Anonymous2 April 2014 at 19:46

    Mohana,

    I am also running into the same issue. I added the "Dimensions as Columns" boolean and could see all the Dimensions when I went to Export the Template to Excel, the Dimensional fields to not flow to the template. I've noticed that there is no value in the Processing Order or Related Table ID fields when the Dimensions fields were added to the Table 81, but those fields seem to be non-editable so I can't put any values in there. I must be missing something simple but I cannot figure out what it is.

    Any advice would be appreciated.

    Thanks

    ReplyDelete
  3. Anonymous19 April 2014 at 03:27

    Hi Mohana,

    Great tip.

    I noticed that working with Rapid Start is fast on your machine. With me it is painfully slow. Are there any server options that needs to be configured for it to work faster?

    Thanks,

    Jakob

    ReplyDelete
  4. Anonymous19 April 2014 at 03:29

    Hi again,

    I have got the problem. The dimensions are not exported to Excel.

    Please advice,

    Jakob

    ReplyDelete
  5. Anonymous19 April 2014 at 03:47

    Hi all,

    Here is a work around.

    1. Add the columns that are missing to the table in the Excel template.
    2. Select the column header on one of the missing dimensions.
    3. Right click header of the table and choose the XML submenu -> XML source
    4. You will see the dimensions but without a red star which means that it is not mapped to any data in the Excel table.
    5. Right click the unmapped dimension and select which column it must be associated with.

    Best,

    Jakob

    ReplyDelete
    Replies
    1. Unknown2 December 2015 at 12:16

      Thanks for posting this Jakob--just what I needed!

      Bradley

      Delete
  6. Iaroslav30 August 2016 at 03:27

    Mohana,
    Thanks for this post!

    ReplyDelete
  7. Anonymous1 November 2016 at 17:39

    Instead of modifying the Page object, I just used "Config. Worksheet" instead.
    I added table 81 to a new row, then "Assign Package" and selected my rapidstart Configuration Package, then clicked the "Dimensions As Columns".
    From now on shortcut dimensions can be exported and imported to/from Excel. Did this by action "Export to Template" (Excel) from Config. Worksheet.

    ReplyDelete
    Replies
    1. Anonymous24 February 2017 at 15:14

      Exactly, that's the way to do it as Microsoft describes in the below link:
      The suggested solution by Mohana does not work in Dynamics NAV2016.

      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

      Delete

Subscribe to: Post Comments (Atom)