Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Allocate orders based off of allocation rules

Posted on by Microsoft Employee

Hi,

We are looking for a solution to allocate our orders based off of the following allocation rules (listed in order of priority).

1) Order Type: 

(Priority at the Beg of Fiscal Month  - Warranties, Trials, Sales, Promos)

(Priority at the End of Fiscal Month – Warranties, Sales, Trials, Promos)

2) Order received date (Earlier Orders get processed first)

3) Qty on Order (Orders with smaller quantities are processed first)

Currently, our system is set up in the following way:

1) Order comes into GP from an external dashboard and automatically populates an order in the Sales Transaction Entry. Allocation occurs by line item but the quantities are not fulfilled.

2) The order goes through a series of checks and then gets placed in a batch to be transmitted via an integration piece to our Warehouse's web portal if all the checks pass.

3) The order is then fulfilled by our warehouse, where they send the serial numbers shipped back to GP via our integration piece.

4) The order is fulfilled in GP and moved to a FULFILLED batch. The order gets moved to an invoice and is then posted.

Is there an allocation module in GP that will help us implement the allocation based off the rules we are looking for before the orders are sent to our Warehouse (possibly allocated right before being transmitted to the Warehouse)? 

If not, what options would we have to create this functionality? 

I'm thinking we can allocate by document/batch and back order any shortages, but I'm unsure of how we could enforce the integration rules and how we would deal with new orders coming in throughout the day.

Any help would be appreciated. Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Allocate orders based off of allocation rules

    Thanks everyone.

    I will look into the Accellos application.

  • Verified answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: Allocate orders based off of allocation rules

    Accellos, now HighJump has an application for this purpose. It is called "Dynamic Order Allocation" and it has a predefined set of rules to prioritize the allocation, i.e. Customer Priority, Requested Ship Date, BO quantity, etc.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Allocate orders based off of allocation rules

    In our case, we are a developing a new tool written in dexterity that runs automatically when PO or MO Receipts are posted, or when all Holds are removed from a SOP document. There are rules like order type, customer priorities, etc.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Allocate orders based off of allocation rules

    Thanks Jorge.

    In regards to the customization you mention, are you customizing the 'Automatic Order Allocation' module to allow for the required allocation rules of your customers?

    Or is there another way you are customizing to meet the allocation rule requirements?

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at
    RE: Allocate orders based off of allocation rules

    The closest match to your requirement is the 'Automatic Order Allocation' which is part of the standard GP module 'Advanced Distributions'.

    Transactions > Sales > Automatic Order Allocation

    I am not aware of any 3rd party product that offers exactly what you are looking for.

    Currently I have similar requirements than yours from one of my customers, the only solution I found is to develop a bespoke product in Dexterity.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans