Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Bin Quantity Entry Order

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bin Quantity Entry Order

    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.

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Bin Quantity Entry Order

    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 :-)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bin Quantity Entry Order

    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?

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Bin Quantity Entry Order

    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.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans