Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Credit limit check based on available inventory, not total sales order value?

Posted on by 124

Dear Madam/Sir,

Do you know a way in which the credit limit check is done based on available inventory of the sales orderlines, not total sales order value? (D365 F&O)

For example, I have a salesorder for customer AAA which has 2 lines (Line 1 is for product 1, line value is 100K. Line 2, is for product 2, line value is 100K). Total value of the order is 200K. Credit limit of the customer AAA is 120K. There is only available inventory for product 1, product 2 is out-of-stock with no view on possibly supply.

Currently the credit check on the picking list step (or any other step) will block as the total value of the sales order (200K) exceeds the credit limit of customer AAA (120K).

I would like the D365 F&O to allow the picking list through based on the fact that only 100K worth of goods will be send based on the available inventory for just line 1/product 1 in the sales order. The available inventory for product 1 at 100K is still below the credit limit of customer AAA (120K limit). The fact that there is a second line on the sales order is irrelevant as it it not supply (therefore not invoice).

It seems that all documentation/instruction for D365 credit check is on a total sales order value.

Thank you for your thoughts and ideas,

Koen

  • Unknown geen idee Profile Picture
    Unknown geen idee 124 on at
    RE: Credit limit check based on available inventory, not total sales order value?

    Dear Andre,

    Thank you for your input, much appreciated.

    I (finally) managed to test the idea that credit limit check on the packing slip is based on the line value in the packing slip itself (rather than the total order value).

    I am very happy to see that the lines on the packing slip determine if credit block is applied.

    To me it would seem logical as well that a credit limit check on the picking list would be determined by the value of the lines in the picking list (reservation), but it does the check on the total sales order value. Picking lists continue to end up in the credit check because the total order value exceeds the limit, but the available stock for just a few lines in that sales order is below the limit.

    It does not help that the Microsoft documentation only talks about sales order value (not line value included in the document).

    Thank you again, one step further,

    Koen

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: Credit limit check based on available inventory, not total sales order value?

    Hi Koen,

    There is no standard function to calculate the credit limit based on available inventory. In an ERP application, the available inventory can change the next minute.

    You can probably better have a credit check when posting the packing slip.

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans