You’re offline. This is a read only version of the page.
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
Yes,
Although, It won't have any effect on the 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?
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?
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,
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
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,
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.
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (