Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / HOWTO - Cancel the (Di...
Microsoft Dynamics NAV (Archived)

HOWTO - Cancel the (Direct Posting) Remaining Quantity

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

My Case :
A Sales Order exists with <direct posting> for QTY 2,5.
A corresponding Purchase Order is linked with QTE 2,5.
A partial delivery has been validated for QTY 1,5.

The remaining ordered quantity will never be delivered...

Is it a way to avoid the message
'You cannot change Quantity because the order line is associated with purchase order..."

Howto change the remaining order quantity (Filed QTY) to cancel the remaining QTY and close the orders (Sales and Purchase) ?

TIA,
L

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    My Solution :

    Purchase side

    1)- Add a purchase line (not direct posting) with a negative quantity (QTY -1)

    2)- Validate Received quantity (+1 on first line and -1 on new second line)

    5)- Validate Purchase Invoice (first and second lines are now also fully invoiced)

    Sales side

    3)- Add a second line (not direct posting) with a negative quantity

    4)- Validate Ship and Invoice (first and second lines are now fully shipped and invoiced)

    Tx to all contributors,

    L

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Hi, in order to do this you will have to delete the purchase order line (if invoiced) after that there will be no connection between the sales order and the purchase order so you should be able to modify or delete the sales order line.

    Best regards

    /Benny

  • keoma Profile Picture
    keoma 32,675 on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    add a sales line with a neg. qty. of -1.5 and post.

  • Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Let me reproduce the case to suggest you the alternative.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Tx Saurabh.

    Yes it is a Drop Shipment (Field Direct Posting is activated).

    Yes the purchase quantity and the sale quantity must be changed (by the user).

    How can the user manage this case ? Must it be invoiced and then credited... or is it a better alternative ?

    Regards,

    L

  • Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Is this a Drop Shipment or Special Order ? 

    This error occurred in Drop Shipment case.

    There is a validation on quantity field of purchase line as below:

    IF "Drop Shipment" AND ("Document Type" <> "Document Type"::Invoice) THEN
    ERROR( Text001, FIELDCAPTION(Quantity),"Sales Order No.");

    Do you also need to change quantity in sales order? 

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Tx.

    Yes, Sales order and Purchase order are open.

    When trying to change the order quantity, the message displays...

    Regards,

    L

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HOWTO - Cancel the (Direct Posting) Remaining Quantity

    Did you try reopening the Sales Order as well as Purchase order and update the quantities?

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