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 :
Microsoft Dynamics NAV (Archived)

HOWTO - Cancel the (Direct Posting) Remaining Quantity

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

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

  • Community Member Profile Picture
    on at

    Tx.

    Yes, Sales order and Purchase order are open.

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

    Regards,

    L

  • Saurabh Shah Profile Picture
    4,560 on at

    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
    on at

    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
    4,560 on at

    Let me reproduce the case to suggest you the alternative.

  • keoma Profile Picture
    32,729 on at

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

  • Community Member Profile Picture
    on at

    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

  • Community Member Profile Picture
    on at

    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

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans