Generate Source Mapping -Excel

(0) Share

Report

Posted on by Abdullah Sarhan

Dears,,

We have new installation for AX 2012 R3, when i was trying to import chart of accounts through data import export framework, i made all the steps, when i was trying to make mapping from processing group for excel sheet that i made it , generate source mapping bottom is not active , it is just only for excel , any idea about please.

4331.mapping.png

thanks in advanced

*This post is locked for comments

I have the same question (1)

All responses (6)

Answers (0)

Sort by

Suggested answer

W@sim 22 on at

Like
a
(0)

Report
Copy link

Link copied!

First you have to generate the source file with the fields you have mentioned in your excel file.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,118 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Abdullah,

You have to specify the Sheet lookup field in the grid. Otherwise DIXF is not aware which sheet contains the columns.

Was this reply helpful? Yes No
Martin Dráb 239,932 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please choose which sheet you want to use (in Sheet lookup field).

Was this reply helpful? Yes No
Abdullah Sarhan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you Andre , i try but lookup sheet is empty

Was this reply helpful? Yes No
Abdullah Sarhan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Andre Sheet lookup is empty

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Abdullah,

if look up doesnt work, you can type it like 'Customers$' if the sheet name is Customers.

-Vinit

Was this reply helpful? Yes No