Import xml in different companies and shotcut dimensions

DynamicsSol

Goodmorning,

I am facing a challenge ; I need to import a txt file that needs to be inserted in the general journal line.. That txt file has several companynames in it and based om the company name the line has to be inserted in the correct company. So far no problems, with changecompany this can be done. The problem rises when the shortcut dimensions (3/4/5) need to be inserted... In the older version it was pretty straightforward, but with 2013 and the Dimension Entry Set ID and the way it is determined I wonder if any of you have a working solution for this???

Thanks in advance.

Greets

tinoruijs

There's a function called GetDimensionSetID in Codeunit 408 which lets ýou pass a temporary record of the dimension set you want to check/create.
Works very nice I think.

There are quite some posts on Mibuso already on the new dimensions; http://mibuso.com/forum/search.php?keywords=create+Dimension+Entry+Set+ID+&terms=all&author=&sc=1&sf=all&sk=t&sd=d&sr=topics&st=0&ch=300&t=0&submit=Search+the+forum

DynamicsSol

Hi there,

thanks for the reply, but how will this then work with ChangeCompany ??


the file will look like:


G/l Account / amount/ Date/ Shortcut dim 1/ short cut dim2/ short cut dim 3/ dim 4/ Company name

We have about 10 companies in the Db and 1 file , so it will have to create the line sin different companies based on that "Company name"- field plus the Dimension need to be created..

Greets

tinoruijs

When you use a CHANGECOMPANY, NAV will know in which company you are and check for dimension sets in that company.
Here you see some nice examples about CHANGECOMPANY; http://msdn.microsoft.com/en-us/library/dd338929.aspx