Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Picking list qty differs from Sale order qty

Posted on by 765

Hi,

I created a sale order for an item with Qty 5 nos.

While  creating the picking list, the qty is changed from 5 nos to 15 nos.

how the qty gets changed , please advise

  • sriram Profile Picture
    sriram 765 on at
    RE: Picking list qty differs from Sale order qty

    Dear Mattguo,

    thanks for the detail process flow for the Log setting procedure.

    May be configuring the database log will help to track the changes from now on.

    I also have same issue in another Sale Order. Both Sale Order are Inter company orders.

    Refer below the issue

    Sale Order # 1

    Sale Order Qty : 5 Nos

    Picking List Qty : 15 Nos

    Sale Order # 2

    Sale order Qty : 10 Nos

    Picking List Qty : 20 Nos

    Now we can manually change the qty and do the posting. But how the change occurs or from where the qty is been added is to be known to fix this 

    pastedimage1575962933586v1.png

    pastedimage1575962982939v2.png

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Picking list qty differs from Sale order qty

    Hi Sriam,

    1.Enable the certain fields such as createdby, modifiedby, remainsalesphysical, remaininventphysical etc. in the"order lines" table from all table section

    57804.png

    4786.png

    25516.png

    2.Change the remaining delivery quantity:

    21550.png

    3.Check the log:

    6406.png

  • sriram Profile Picture
    sriram 765 on at
    RE: Picking list qty differs from Sale order qty

    Hi,

    We don't have the database log enabled.

    i think enabling log would help in future tracking

    Refer below the screen and advise

    pastedimage1575957013297v2.png

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Picking list qty differs from Sale order qty

    Hi Sriram,

    Need to enable the database log feature first, then the later change can be recorded. For previous change can not be recorded.

    Please have a look at Lachlan's blog: organicax.com/.../

    In your case, need to enable the certain fields such as createdby, modifiedby, remainsalesphysical, remaininventphysical etc. in the"order lines" table from all table section.

  • sriram Profile Picture
    sriram 765 on at
    RE: Picking list qty differs from Sale order qty

    HI, Where we can check the log

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Picking list qty differs from Sale order qty

    Hi Sriram,

    It may be that someone change the quantity, you can try to use database log to record the change

  • sriram Profile Picture
    sriram 765 on at
    RE: Picking list qty differs from Sale order qty

    Hi,

    there is no unit conversion

    while checking in the delivery remainder, there are 2 data shown

    Delivery remainder : 5 Nos and

    Inventory : 15 Nos.

    based on the above , the picking list is raised for 15 nos.

    could not able to find where the 10nos is getting added

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Picking list qty differs from Sale order qty

    Hi Sriram,

    Can you please check if there are any unit of conversions applied to the item. If inventory unit is changed from sales unit. This can be the reason for a changed quantity during pick list.

    Warm Regards,

    Zain.

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!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans