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 :
Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 128

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

I have the same question (0)
  • Unknown geen idee Profile Picture
    128 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
    297,200 Super User 2025 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

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans