web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Multiple Bins and site Allocations in GP2010

(0) ShareShare
ReportReport
Posted on by

Hello fellow GP strugglers,

A question for you, we never have been able to get out site qtys & allcoations to be matched by our Bin Qtys and alocations. No mater the number of scripts we kludge together and run, the bin quanties and allocations show up wrong quite frequently and I am forced to run SQL statements to force them to match the site qty's/alloc.

Now, I have been told that Microsoft is "fixing" this bug in 2013, but I just wonder how we could be the only company experiencing this, and if not, what have others done to mitigate it.

We have 11 warehouses in the US and Canada all with multiple bins and part# in the hundreds of thousands, and I spend HOURS each day just clearing unknown allocations from parts to that our shippers can fulfil orders and pick stock to be shipped on in-transit xfers... times that by 10 physical warehouses and bam, you understand my frustration... Pasted below is an example of what I spend most of each day fixing manually with SQL scripts?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    Re: Multiple Bins and site Allocations in GP2010

    I've experienced a similar problem on GP2010(sp1)  Inventory reconcile resolved the allocations.  No SQL script was needed.

  • Community Member Profile Picture
    on at
    Re: Multiple Bins and site Allocations in GP2010

    we were told by our vendor that a reconcile would take over 40 hours to run? We are thinking Thanksgiving Holiday 4 day weekend, to kick it off... Is there anyway to guesstimate how long it will run, can we try test run by warehouse? The tool looks like it's an all or nothing kind of thing?

  • Community Member Profile Picture
    on at
    Re: Multiple Bins and site Allocations in GP2010

    Hi Sheldon,

    I'm certain your vendor understands your database volumn much better than I do.  I would execute the process in a test enviroment.

    Donnette

  • Suggested answer
    Community Member Profile Picture
    on at
    Re: Multiple Bins and site Allocations in GP2010

    We use PSTL inventory reconcile at a client site, which is a lot faster, along with a login macro setup in Windows Task Scheduler to run automatically 3 times a week.  The client has over 56,000 inventory items associated with multiple Warehouse IDs.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans