Data Migration

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to upload sales discount prices in the data migration table. The process requires me to upload the data from an excel file then apply the data to NAV. However, when I do the initial upload, only the item numbers are uploaded. The other information (Sales Discount, currency code, sales code, etc.) is not uploaded for some reason. I tried using a new excel file as I thought my original template got corrupted , but that is not the case.

Our business model has several companies within NAV. The data migration works in all companies accept for the one I am trying to upload the information into.

Does anyone know why this would occur? This problem has only happened recently.

Thanks for your help,

Pete

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

keoma 32,729 on at

Like (0)

Report

first debug the migrate process. check the position where the data should be imported.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello Pete,

First you open your excel file and check data is there or not,

If data is there then check the xml schema of that excel, see the bellow screenshot,

if you found the schema, then verify every field by selecting.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

archer,

I cant debug this because the debugger breaks before I have a chance to upload the information.

Binesh,

I have confirmed that the schema is mapped. It is weird because the same file works in all companies within NAV except for one.

Thanks

Pete

Was this reply helpful? Yes No
Binesh 7,885 on at

Like (0)

Report

After importing the data from excel,

First check "Migration Fields" and confirmed weather Include is checked or not for all fields that you want.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

First Export 1 record with Data migration. IF that does work, open the resulting excel file, change it, so that you can import the one record. IF that does work, fine. If not, then there is something wrong with that company.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There may be something wrong with this company. I will review this with our consultants.

Thanks

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

If the file makes correct upload for the other companies in the database, but fails for this particular one in the same database, then there can be something wrong with the company. May be so that there are some settings in currency codes or sales codes are different?

Was this reply helpful? Yes No