Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Received Item via PO R...
Microsoft Dynamics GP (Archived)

Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

(0) ShareShare
ReportReport
Posted on by DavidG 15

I got an interesting issue and I hope someone can help to fix/correct it.

We did a PO Receipt last month for an item, say item A for 969pcs. However, our Item Stock doesn't reflect such transaction. Instead, it addes such QTY to our initial QTY balance. 

So our first transaction for this item in Item Stock Inquiry (occured on Dec 2014) is 600pcs QTY In and the balance turns out to be 1549.

I did the Inventory Reconcile and Check Links, non of them detect/fix this. I assume this is due to the corruption during the PO Receipt (not that I am aware of). Is there anyway to fix or correct this?

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    Yes,

    Although, It won't have any effect on the item stock inquiry.

  • DavidG Profile Picture
    DavidG 15 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    I end up modify the line # for the 2nd transaction by increment it by 1. After adding those records manually to IV30300, Item Stock Inquiry looks good now.

    As a side note, since I modified the IV30300 table, should I do any update to IV30200?

  • DavidG Profile Picture
    DavidG 15 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    I have a question on inserting the record on IV30300,

    Per SEE30303 and IV10200, it has split my Receipt QTY of 940pcs into 2 records while referring to the same line sequence but 2 different receipt sequence and 2 different costs:

    [TRXQTYInBase],[TRXQTY], [LNSEQNBR], [RCTSEQNM], [UNITCOST]

    939, 940, 16384, 184, 11.1008

    1, 940, 16384, 185, 11.1256

    So when I insert into IV30303 as 2 records, I got a duplicate key error since it can't be using the same line sequence number. Should I avg the cost and combine it into a single record or manually update the line sequence?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    One last point, do not touch neither the IV10200 nor the IV10201, those are critical tables in the inventory module on which several dependencies are built. Any changes on them may have further negative ramifications.

    Adding a new record to the history table as retrieved from the other inventory tables should not be a big deal. Have a test environment before applying any changes to make sure that you are on the safe side.

    Your feedback is highly appreciated,

  • DavidG Profile Picture
    DavidG 15 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    Hello Mahmoud,

    Thanks for insight on how Inventory Stock inquiry works. It is now seems very clear to me that IV00102 and IV30300 are not in sync. It appears when the PO Receipt is done, the IV30300 is for some reason not recorded, but IV00102 did.

    As per your suggestion, I will try to add a new record to the IV30300 and update the dates for IV10200/201 (not that it matters).

    Btw, SEE30303 does have those transactions. Seems like SEE30300 is very similar to IV30303. Why two separate tables? Different purpose?

    David

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    Item Stock Inquiry retrieves data primarily from two tables, IV30300 (Transaction History) and IV00102 (Item Quantity Master). The current balance is retrieved from IV00102 and then transactions are considered from IV30300 to calculate (backward) the balances from today until the very first transaction. When there is a different in the first line between the Quantity In and the Balance, it is either that IV30300 is missing some transaction or that IV00102 balance is incorrect.

    The bottom line, if the inventory reconciliation has done nothing, you do need to add the records manually to IV30300 in order to make sure that internal inventory tables tie together in terms of the quantity balances. All inventory transaction table (IV10200 & IV10201, IV30300 and SEE30303) should speak the same language and provide the exact same balance, any missing transaction in any of these tables result with incorrect balances on the application level, and incoherent values.

    Your feedback is highly appreciated,

  • DavidG Profile Picture
    DavidG 15 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    The maintain history should be enabled at all time as we have new transactions recorded as we speak.

    I think the key lies on where the Item Stock Inquiry gathered its transactions from.

    The interesting part seems like that Item Stock Inquiry added the transaction qty to the opening qty balance, but not showed up. So maybe it is some transactions that with empty date. I just need to find it.

    Anyone who have any idea, please let me know.

    Thanks for all your help on this matter.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    IV30300 table doesn't have the record. Check the Item Master "Maintain History" setup. I'd first enable them back if they are disabled at the moment.

    Updating FLRPLNDT would still not bring the IV30300 record back, which is key to Item Stock/Transaction Inquiry. I'm afraid, this one's not fixable.

    You may however want to wait for others to pitch in with their thoughts.

  • DavidG Profile Picture
    DavidG 15 on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    Hi Vaidy,

    I checked IV10200, the PO Receipt is there, but the FLRPLNDT date filed is all empty (1900-01-01 00:00:00.000).

    As for IV30300, I don't see any record for this receipt.

    So what do you suggest? Will update the FLRPLNDT field will fix the Item Stock query issue?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Received Item via PO Receipt, but doesn't show up in Item Stock Inquiry

    I would check the table IV10200 (Purchase Receipts) at the backend and see if this PO receipt record is available there or not. I'd also check IV30300 (Item Transaction History).

    If both these tables do not contain this PO receipt, check if at some time "Maintain History" for this product is disabled.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans