Announcements
No record found.
when we generate Item by Location matrix excel from print and send excel option, it will not generate dynamics column in excel in NAV 2013 R2. Please suggest solution ASAP.
*This post is locked for comments
What do you mean with "dynamic column"?? (like a table with filters?). Which Excel version are you using?
We are checking item by locatio-->Show Matrix--->Export to Excel.
Dynamic column are the locations in which the inventory bifurcated.
Regards
Mandar
Excel version in Excel 2010 standard version.
Do you mean something like that??
Sorry, that's the capture.
yes that one.
In our case it look like this
Matrix Page :-
Excel Page :-
Excel Generated from Print & send button Excel Action:-
Hi Saransh,
Saw you cross-posted your question. Here is the answer I gave you on DUG:
The reason this is happening is the nature of a matrix page in Dynamics NAV. A matrix page is not one page, but several pages combined into one. So when printing it's not one page, but multiple pages.
That's why most of these special matrix pages used by account schedules and analysis also have special coded Excel export functions. Just using the "native" NAV function will not work!
I have the same problem at a NAV2018 customer - the dimension columns are not exported.
The users are using same NAV client and same Excel version.
When one user uses "Print and sendt" function from G/L Entry by dimension matrix the dimension columns are not present - it looks like this:
When another user does the same the dimension columns are exported - and it looks like this:
So two different views from same NAV functionality.
Any suggestions on why the first user doesn't get the view with dimension columns?
Sorry, the first view looks like this:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
