We had a stock counting in our advanced warehouse (bi enabled).
I have the stock count result in a Excel file with 4500 lines. How can I upload the data into the whse.physical inventory journal?
When i tried the rapit service package, Table 7311, there is an error "Phys. Inventory must be equal to ‘Yes’ in Warehouse Journal Line: Journal Template Name=PHYSINVT, Journal Batch Name=DEFAULT, Location Code=DC001, Line No.=20000. Current value is 'No’
I did something like that a few years ago. Rapid start will not work!
I remember it really was a challenge. The only way I where able to get it working correctly, was to start by running the “create physical inventory journal”, where it calculated the expected quantities. Then I updated it with the data (in my case from an XML file) that I had stored in a buffer table (you could use the excel buffer). If there where items not in NAV or without Lot No. (where required), then it was inserted, but marked as error.
It needs to run this job first, because what you’re posting is not really the physical inventory journal, but the difference between calculated and physical inventory.
Never share emails directly in posts, every thing you post here is public. It will with guarantee means it ends on spam lists, plus make DUG an interesting target for harvesting.
I have removed the email from the post. Please read the “how to post” in the “About pages” and when you make a new posts if in doubt.