I work for 3PL company with a medium sized warehouse. Inventory is coming up soon and we will be doing a full count of the store. Before that the company wants me to create print out for what is in each bin to check that everything is where it should be. The problem is that when checking bin counts in GP it automatically orders everything alphabetically by the entered item name. I have tried to rearrange in order of bin to make checking easier but I cannot find a way to do this. Exporting the file into either a word or excel document just creates corrupted files. If anyone has a solution or work around to reorganize how items are arranged in the bin quantities menu it would be very much appreciated.
*This post is locked for comments
This sounds like the best bet for what I am trying to do, I didn't know about all these extra form! Thank you very much.
I don't have a company where Multiple Bins has been activated for now, and it requires quite some preparation in order to do that (and there have to be no unposted invoices pending)..
However, I guess that the out-of-the-box default report that is embedded in GP doesn't allow you (usually) to sort the output (or rarely)..
You could eventually check if one of the existing Excel reports would do the job ? GP comes with over 200 built-in Excel (and SSRS) reports that can be deployed in your system and give you live-data access to most of the modules in GP (it's usually the equivalent of the default SmartLists that come within GP).
One of the Excel reports is called "ItemQuantities Items by Sites.xlsx" and returns some basic data on each items and location. The underlying SQL view that is used has many more fields that can be added, like [Bin Number], to the Excel report and return all the bin information too. That way you could build a PivotTable in Excel and sort / filter the data to your heart's content :-)
I am new to GP and so have been using the "Print" function out of the bin quantity module. It allows you to "Print" on screen or as a file. When I choose a file type, no matter what I save it as it always saves and appears as code in both Excel and Word. Printing normally is fine, it comes out like how it's supposed to, but it is still in alphabetical order, not by bins.
My main problem is just getting the lists in GP to arrange themselves in different ways. Is there a way to change how items are arranged in a list or do we have to go by the alphabetical order GP is giving me?
Hi Darren.
When you said 'Exporting the file into Excel creates a corrupted file".. how do you proceed with this export ? from a SmartLIST ? or are you using any other built-in export feature of GP ?
In GP there is typically a routine for doing stock counts :
Inventory >> Transactions >> Stock Count Schedule
Once the schedule is created, you can print it out on paper and hand it over to warehouse staff that would then cont the physical inventory..
Once the count is over, you use the stock count entry to post variances of your inventory into the system
Inventory >> Transactions >> Stock Count Entry
If your company has a fairly large inventory, you can split the schedule into smaller chunks, as otherwise it becomes huge and hard to manage. The button "Mass Add" at the bottom right allows you to filter your selection by various fields..
If this is something that is planned on a recurrent basis, you can check a box to keep the stock count schedule for another time.
If you're not sure about the entire process, try it out first in a TEST company and read the user guide related chapter about the whole process.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156