How to do pivot tables in excel 20137/11/2023 ![]() From there, select “Bin Contents.”įigure 1 – To show inventory on hand and the associated bins, start by selecting “Bin Contents” from the Item Card This gives us only the Bin Contents for the current item, so we removed the item filter.įigure 2 – Remove the item filter This then gave us the entire Bin Contents list for all items.įigure 3 – The entire Bin Contents list for all items is displayed We filtered out all of the zero quantities, which gave us the all of the Bin Contents containing inventory.įigure 4 – Remove the zero quantities to list all the Bin Contents containing inventory We then copied and pasted the data to Excel.įigure 5 – Copy and Paste the data into Microsoft Excel And from there, we created a Pivot Table to present the report.įigure 6 – Create a pivot table to display the report You can see that with a little knowledge of Dynamics NAV and some skills in Microsoft Excel, you can write reports from the Dynamics NAV data. Using Dynamics NAV 2013, we went to an item card. ![]() We did not find a report for this, so we thought that if we could get to the Bin Contents Table, we could export the data to Excel and create a Pivot Table to present the information. ![]() Yesterday a client called and asked if there was a report in Dynamics NAV that listed inventory on hand and in which warehouse bins the inventory was located.
0 Comments
Leave a Reply. |