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 GP (Archived)

Negative SOP Invoice Quantities - Inventory Balance Behavior Question

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Belinda Allen Profile Picture
    2,652 on at

    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.

  • Suggested answer
    Belinda Allen Profile Picture
    2,652 on at

    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
    Community Member Profile Picture
    on at

    Hi Belinda,

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

    I think that will work for our situation.

    Best,

    Adam

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 GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans