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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Customer balance/credit does not include picking routes

(0) ShareShare
ReportReport
Posted on by 132

Dear Madam/Sir,

Do you see any option to include picking routes in the customer balance/credit considerations?

Currently the standard functionality in D365 only seem to include pending invoices, orders on picking slip ... to calculate the credit status of a customer.

In our organization, due to the 3PL setup, there is quite a time gap between release of a picking route and packing list. This often results in a release of goods to a customer which has already exceeded their credit (by the value that is still in picking route status).

For example; Customer A has a credit limit of 100K and outstanding invoices for 70K, it seems that it has therefore 30K worth of credit to release orders against.

On Tuesday we have inventory worth of 20K to release to customer A, the packing slip will only come in around friday from the 3PL. On Wednesday we have 25K worth of inventory to release for the customer .... this gets released because the credit limit check is against the actual limit (100K) and any outstanding packing slips. So while the customer had only 30K of credit left, 45K was released.

If anybody sees options to manage this within D365, I would much appreciate your input. Currently we are trying a patch-work of Excel.

Kind regards,

Koen 

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    Hi Yes, you can have exception based on this with credit management setup in credit an collection

    exploredynamics365.home.blog/.../

    pastedimage1666252530195v1.png

  • Unknown geen idee Profile Picture
    132 on at

    Dear Saurabh Bharati,

    Thank you for your input, much appreciated.

    While I do see the option to trigger a check on the credit limit upon picking list creation, there does not seem to be any option to actually include the value of the picking list to be considered. This seems to only reflect a certain timing of the check, but not what should be included in a potential block.

    While going through your blog (very interesting) and especially the blocking rules, I also could not decipher any way to include the value of a picking list to be considered.

    Maybe I am missing something, if so, could you please help to clearify? Maybe you know of a particular blocking rule which does include the value of the picking list?

    Thank you in advance,

    Koen

  • Verified answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    You are right for deriving the amount of balance credit limit, currently out of the box doesn't consider the Picking list

    but i think if you include order value that automatically consider this status because at that point order status will be open only and which is there balance + all method

    Specifically picking list is not available

  • Unknown geen idee Profile Picture
    132 on at

    Dear Saurabh Bharati,

    Thank you for a quick response and confirmation of what I kinda expected already.

    I appreciate your suggestion regarding the sales order value. In my organization this does not work as it is common practice that sales orders get fulfilled in multiple picking lists over a large amount of time. For example the SO might be worth 200K which gets fulfilled as and when inventory becomes available. In total the SO might be fulfilled over 1 year in 20 different picking lists.

    In any case I now have confirmation of what cannot be done with standard functionality.

    Thank you,

    Koen

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans