Physical Inventory Sheet

(0) Share

Report

Posted on by Community Member

NAV 2016. Need to be able to export a report to excel that we can use for a physical inventory count. Needs to include bin, item number, item description and qty on hand. Also need to be able to sort it by bin.

TIA

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Copy/paste? Or do you want to import the results, too?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No need to have the ability to import results at this time. Just need a sheet to be used on a clipboard.

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Well, then Copy/Paste, errm, Send to Excel is your friend. As long as you can generate the calculated inventory, you can copy/paste the journal contents into excel and do your sorting/formatting afterwards.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi JaredG

You can follow this link by Saurav Dhyani

saurav-nav.blogspot.in/.../report-export-to-excel-with-font-colour.html

Was this reply helpful? Yes No
Suggested answer

tpupko 2,048 on at

Like (0)

Report

Hi,

you can set up Configuration Package to import data

Was this reply helpful? Yes No
Suggested answer

RobertasR 5,004 on at

Like (0)

Report

Hi Jared,

open 'Whse. Phys. Invt. Journal' or 'Phys. Inventory Journal' (depending on the setup of your warehouse), select the batch and hit 'Calculate Inventory'. This generates the journal for all existing items, their bins and quantities. You can copy-past this to Excel, or print the report choosing to export Excel (I prefer copy-paste though).

Hope this helps.

Robertas

Was this reply helpful? Yes No