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) / Purchase order got inv...
Microsoft Dynamics AX (Archived)

Purchase order got invoiced fully but one of its invoiced line is having positive quantity against 'Ordered' column.

(0) ShareShare
ReportReport
Posted on by Balasubramanian Kum... 205

In Dynamics AX 2009, noticed that few purchase orders got invoiced fully but one of it's fully invoiced line is having positive quantity against the column 'Ordered' which is a calculated field.

If the purchase order line is having an open quantity, it wouldn't have been invoiced fully. In the same way, if the purchase order got invoiced fully, it is not possible to make any changes on it.

When did some initial analysis, the concerned transaction (in InventTrans) doesn't have any detail other than item id, qty, trans type, trans ref id, date expected, lot id, direction and issue status (as ordered), date status and inventdimid. When checked the inventory transaction log trace, it has shown that it came from production order but not sure how it got updated the invoiced purchase order with the positive ordered quantity. Also we had a planned purchase order for an item with one quantity higher than the invoiced quantity. Is that difference showing as ordered quantity when the concerned production order ended ? 

I would appreciate if anybody can explain how this would have happen and how can we remove the ordered quantity from the invoiced line with out hurting the system?

*This post is locked for comments

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

    Hi Balasubramanian,

    You can check the inquiry-form to verify Purch-Lines current status:

    Goto: AP >> Inquiries >> Order Status >> Backorder Purchase Lines Details

    in this inquiry-form, filter the overview-grid by PO Number related to your PO-Line

    If PO exsits, then check the Purchase-Line Tab >> Line Status (Is it 'Open Order' or 'Cancelled')

    If cancelled, then no need to worry since the PO-Line was already Cancelled (you can ignore the InventTrans status having Receive Pending Ordered).

     

  • Balasubramanian Kumaran Profile Picture
    Balasubramanian Kum... 205 on at

    Hi,

    Thanks for your response.

    Yes, there is a back-order for that PO exists with the  receipt status as 'Ordered' with 1 Qty. This Qty only showing up in the ordered column of the invoiced PO line (of that item).

    When checked the concerned PO-Line status, it says 'invoiced' but with the Qty in Ordered column as i mentioned in my post earlier. PO is also fully invoiced with the status 'invoiced'. Please suggest how this would have happened and how to resolve this issue.

    Thanks && Regards,

    Balasubramanian Kumaran

  • Community Member Profile Picture
    Community Member on at

    Hi Balasubramanian,

    Can you disclose these field values, it may help us to determine incase the InventTrans record is inconsistent

    PurchLine.PurchStatus = Invoiced

    PurchLine.PurchQty = ?

    PurchLine.QtyOrdered = ?

    PurchLine.RemainInventPhysical = ?

    PurchLine.RemainInventFinancial = ?

    PurchLine.RemainPurchFinancial = ?

    PurchLine.RemainPurchPhysical = ?

    InventTrans.TransType = ?

    InventTrans.StatusReceipt = ?

    InventTrans.Qty = ?

    InventTrans.VoucherPhysical = ?

    InventTrans.Voucher = ?

    InventTrans.Direction = ?

  • Balasubramanian Kumaran Profile Picture
    Balasubramanian Kum... 205 on at

    Hi,

    I have two records in InventTrans associated to the invoiced purchase order line and the requested details are in below.

    PurchLine:

    PurchLine.PurchStatus = Invoiced

    PurchLine.PurchQty = 2.00

    PurchLine.QtyOrdered = 2.00

    PurchLine.RemainInventPhysical = 0.00

    PurchLine.RemainInventFinancial = 0.00

    PurchLine.RemainPurchFinancial = 0.00

    PurchLine.RemainPurchPhysical = 0.00

    InventTrans 1:

    InventTrans.TransType = Purchase order

    InventTrans.StatusReceipt = Purchased

    InventTrans.Qty = 2.00

    InventTrans.VoucherPhysical = VPS-xxxxxx

    InventTrans.Voucher = API-xxxxxx

    InventTrans.Direction = Receipt

    InventTrans 2:

    InventTrans.TransType = Purchase order

    InventTrans.StatusReceipt = Ordered

    InventTrans.Qty = 1.00

    InventTrans.VoucherPhysical = ""

    InventTrans.Voucher = ""

    IncventTrans.Direction = Receipt

    Please let me know your suggestion.

    Thanks && Regards,

    Balasubramanian Kumaran

  • Balasubramanian Kumaran Profile Picture
    Balasubramanian Kum... 205 on at

    Hi All,

    Does anybody have any clue on how this would have happened..?

    Thanks && Regards,

    Balasubramanian Kumaran

  • Suggested answer
    Rachit Profile Picture
    Rachit 4,015 User Group Leader on at

    Hi Balasubramaniam,

    It is difficult to say what could have caused this as there can be many different reasons, so try to think on the below questions and see if you can identify anything:

    • Is this scenario reproducible? 
    • Is there any batch process or any custom process in your environment which Invoices purchase orders? 
    • Is there any customization done in your environment during the posting of purchase orders?
    • Was any data update job written/executed which lead to this scenario?
    • Has someone executed any SQL scripts to update purchase order line quantities? 

    As you mentioned, this is not possible by using standard AX processes. I have a feeling that some incorrect data update scripts have been executed in your environment. 

    In order to update the ordered quantity you can ask your developer to run a job to identify such order lines and cancel the open quantity against them by updating the deliver remainder as 0. 

    Test the above approach in your test environment before running any updates in Live environment. 

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Balasubramanian,

    Since your PO-Line is posted with correct qty and has related InventTrans record properly with matching qty

    You can delete the other InventTrans record which is causing to show incorrect Ordered-Qty

    The temporary solution for your situation is to Delete the following InventTrans 2 Record:

    Step1: Take Backup

    Step2: Copy the entire InventTrans 2 record (all fields) to excel (this is for future reference)

    Step3: Delete the following InventTrans 2 Record (use direct delete SQL-Statement, through SQL-Server Management Studio)

    InventTrans 2:

    InventTrans.TransType = Purchase order

    InventTrans.StatusReceipt = Ordered

    InventTrans.Qty = 1.00

    InventTrans.VoucherPhysical = ""

    InventTrans.Voucher = ""

    IncventTrans.Direction = Receipt

    Deleting this record will remove the ordered-qty appearing in PO-Line

    How this happened:

    In very rare situations i had observed buffer-allocation issues had caused some entries resulted in inconsistencies

    Additionally, you can check InventTrans-2 Record's createddatetime/modifieddatetime/createdby/modifiedby fields and comparing these with other records to identify the source

  • Balasubramanian Kumaran Profile Picture
    Balasubramanian Kum... 205 on at

    Hi Rachit,

    Thanks for your response.

    Have tried but not able to re-produce this scenario. Yes, there are lot of customizations / batch / custom process in AP but not to invoice PO. Moreover, this kind of issue is with very minimal POs (hardly in single digit) but not happening in bulk and also not occurring periodically. I too even have a gut feel that some data update job or sql script would have caused this issue but not able to prove this as well. Can able to correct this issue by executing a job but wanted to know the root cause of the same.

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