web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DAX 2009: Negative inv...
Microsoft Dynamics AX (Archived)

DAX 2009: Negative invoiced, negative deducted quantity on PO

(0) ShareShare
ReportReport
Posted on by DAXster 125

Hi all. We are using DAX 2009.  There is one user who made a series of Purchase Order packslip/invoice transactions (normal + reversal). The user has an ordered qty of 100. She pack slip the full quantity then partially invoiced it (only qty=99). Then for some business reason, she reversed it via packslip reverse, then invoice reverse. But when she did the invoice reversal,she indicated -100 in the 'Receive Now' quantity, but she updated the 'Update' qty (Posting form > Line Details > Inventory section > Update field) to -99. And this resulted to an Invoiced quantity of -1 and deducted quantity of -1 in inventtrans. 

We want to get rid of these negative quantities and/or just put back the PO line into its ordered state. 

Does anyone have any idea how ? We have tried several reversal postings for the PO line but no success. 

Hope to get some ideas here. Thanks in advance.

 

*This post is locked for comments

I have the same question (0)
  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Receive Now in 1 and invoice it - this would balance back to zero from what you have just said.

  • DAXster Profile Picture
    DAXster 125 on at

    It does not work. :(. The "1" received is deducted from the ordered quantity which you have returned during the reverse. And after this packing slip posting, the posting of the invoice is not allowed. It's giving out the error "The quantity cannot be invoiced because inventory transactions with a status of Received are insufficient."

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Then I would say you do not have a balanced line where -1 was ultimately invoiced as described, so something else has happened in addition to your description, unless I am misunderstanding the end position. On the quantity tab of the line what does it say about the remainder to receive and invoice?

  • DAXster Profile Picture
    DAXster 125 on at

    On the quantity tab after user's transaction, Invoiced is -1, Delivery Remainder is 100, Ordered is 100. All other quantities are zeroes.

    Also, looking at the transactions of that line, we have:

    Purchased for 100

    Sold for -99

    Deducted for -1

    Ordered for 100

    Maybe to better explain, here is the series of steps she made:

    1. Create SO line for qty=100.

    2. Packslip all

    3. Invoice it as follows

       a. In invoice posting form > parameters tab, quantity : Packing Slip

       b. Go to the Lines tab. Change the update quantity from 100 to 99

       c. Post invoice

       d. After this transaction, you have an invoiced qty = 99 but the remaining "1" did not reflect in the Invoice Remainder quantity. Because of this the user, reversed it thinking to correct it and re-do the transactions

    4. To reverse, she pack slipped -100.

    5. Then reversed the invoice as :

       a. In receive now, indicate -100 in qty.

       b. In the invoice posting form, go to "Line Details" tab > Update field (under Inventory section), set that to -99.

       c. Post Invoice

    Her step in 5-b caused this discrepancy.

    Thanks again for looking into this post.

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Point 3 step c - are you sure they did not tick the close flag, so invoicing 99? Also if I select Packing slip the quantity is not editable, set it to All and I can edit it. So I set it to All and invoice 99.

    Do I get to point 3 and the line states Invoiced 99, invoice remainder 1 delivered 100.

    Point 4 I cannot receive in -100 because the system tells me that the "Returned Quantity exceeds the updated Physical Quantity" which is true.

    So I go to the invoice and use the same deliver now but set it to -99 on the lines tab and post the invoice.

    After posting I have invoice remainder 1 and delivered 1 which is also true.

    I am not sure if it is your localisation or modifications but I cannot process through your scenario is the base demo company which makes it difficult to comment. The system I am using uses the controls of the system to prevent the situation you have, not sure why it is different.

    5b should not have caused you an issue, you invoiced 99 then invoiced -99 so the invoiced amount should be balanced out. I am unsure where you are getting the in-balance, but I cannot replicate it.

    Sorry

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans