Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Negative SOP Invoice Quantities - Inventory Balance Behavior Question

Posted on by Microsoft Employee

Hi,

We ran into a situation where our users are entering both a positive and negative quantity on an SOP Invoice in GP.

For example, if a product is not being returned physically but there was an incorrect price on the original invoice it is less steps in GP to use a singular SOP Invoice and enter the originally invoiced quantity as a negative on line 1 and then a positive on line 2 with the corresponding adjusted pricing so that the net effect to inventory is zero but the adjusted pricing is whatever you need it to be.

We have found in this case that the positive invoice line correctly shows up in the Allocated quantity fields when using the the item quantity inquiry however the negative line quantity does not have any effect on the inventory balances.
This results in an incorrect Available quantity because the negative line is not taken into account. I would think the Allocated values in this case would acutally be net zero since the lines cancel each other out.
After posting the transaction the problem goes away.

So my question is, is this a bug or is this the expected behavior and if it is the expected behavior does anyone know why since it seems that the system handles this situation incorrectly.

Thanks for any help.

 

 

 

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Negative SOP Invoice Quantities - Inventory Balance Behavior Question

    Hi Belinda,

    Thanks for the information and the suggestion with the separate Invoice Type.

    I think that will work for our situation.

    Best,

    Adam

  • Suggested answer
    Belinda Allen Profile Picture
    Belinda Allen 2,652 on at
    Re: Negative SOP Invoice Quantities - Inventory Balance Behavior Question

    Adama,

    Here is a video link on my blog that covers various allocation methods.

    saci.com/.../Microsoft-Dynamics-GP-Sales-Order-Processing-Allocation

    http://www.BelindaTheGPcsi.com

  • Verified answer
    Belinda Allen Profile Picture
    Belinda Allen 2,652 on at
    Re: Negative SOP Invoice Quantities - Inventory Balance Behavior Question

    Hi Adam,

    This is not a bug.  Negative line items and returns do not allocate.  My suggestion would be the following:

    Continue doing the invoices the way you are doing them; however create a new Invoice Type for these corrections that does not automatically allocate the line items.  It would create a separate step to allocate, but you can before this right before posting and then the it would not affect inventory quantities at all.

    Another benefit with this process would be that you can change the Invoice number sequence to something that would indicate a price correction like INVPC001001.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans