75,730
*This post is locked for comments
Replying to an older post hoping folks will still be able / willing to review and assist.
Client would like to have a query / a tool that they can key a SOP number into and get the source (inventory adjustment / PO receipt) that created the Cost for the COGS entry.
These tables appear to have what is needed, however the link
IV10201.SRCRCTSEQNM=IV10200.RCTSEQNM
is not enough. These values are not unique to the table, they dont appear to be unique to the item, nor to the item location combination.
Is there a unique link between these two tables?
thank!
I will do that. By the way, in this case the IV10201.CMPSEQNM went to one for all of these bogus transactions. Just another example of how messed there transactions are. None of these items are components of anything and never have been.
'We will be at Convergence in a booth straight back, slightly to the left. Stop by and say hello at least.
Very good points. What happened here was the in the IV30300 table it as easy to remove these bogus records. All the sales order numbers had a 001 after them. One good thing is that nothing every made it down to the ledger or the SEE30303 tables. So it messed up the IV10200, IV10201 and IV30300 tables. Thanks to your script it has given me reassurance that I am proceeding correctly.
Good luck Sir Richard,
The main essence of the script is that several times, the reconciliation doesn't get purchase receipt work and details tied as supposed to, several reasons could be behind that. The script ensures that all corrupted cost layers are retrieved and well handled.
One more thing to consider, after ensuring that IV10200 and IV10201 are tied correctly, the next step is to compare both of them with IV30300 and SEE30303 (if deployed). That's all part of "internal" inventory reconciliation which should be a prerequisite for inventory versus GL reconciliation.
Your feedback is highly appreciated,
By the way, that script found about 200 other items that have absolutely nothing to do with this issue. I will need to visit these items later.
Very useful script which confirmed what I have been doing is correct. When the batch duplicated the sales orders it updated both the IV10200 and IV10201 tables. I need to remove the duplicate transaction records from IV10201 while at the same time adjust the IV10200.QTYSOLD field. That is what I have been doing and I am about halfway through. It messed up about 125 items.
Nothing more valuable to add up, just in case the reconciliation didn't get it solved, you need to check the corrupted cost layers on the back end. A script and further illustration is provided below;
Inventory Reconciliation - Purchase Receipt Work and Details
Hope this helps,
What I need to correct is IV10200.QTYSOLD. Somehow with this bad batch quantities were removed from this field because it doubled up the invoices that posted. I have cleaned up the IV30300 table and now I am cleaning up the IV10201 table.
A small correction, IV10201 contains the "out" transactions for each record in IV10200, it simply represents the details of QTYSOLD field of IV10200.
IV10200 holds all the receiving's with all available cost layers and all the updates over the cost layers across the days like "Cost Adjustments" and "Landed Cost" updates.
IV30300 is the inventory history, it holds all the transactions that affects the inventory modules with "historical figures" to keep your documents synched with your archive, it shows the transactions figure as of the day of occurrence.
A simple workflow, once you create a receiving one record will be created in IV10200 for each line and one record will be created in IV30300, once you create a sales transaction a record will be created in IV10201 and the corresponding record in IV10200 will be updated to reflect the exported quantities; the relation between tables are exactly as explained by Richard, finally another record for each item will be created in IV30300 to keep the history of the transaction.
Hope that this helps.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (