When Dynamics GP administrators encounter an incorrect item balance or allocation, posting corruption and many other issues related to inventory, the first thing that comes in mind is to “Inventory Reconciliation”. Therefore, it is essential to understand the Inventory Reconciliation Process flow in order to determine how things will get corrected.
The following graphs shows the steps performed in Inventory Reconciliation for each item. Arrows directions are used to represent the “Data Flow”
Summary:
Below as an overall summarized representation for the several processes being involved in the process.
Best Regards,
Mahmoud M. AlSaadi
I understand this flow- but can you tell me, if a RECON record is created in the IV10201 table- where does it pull the IVIVINDX and IVIVOFIX- I have records that have been created with no IVIVINDX account index. Thanks!- Kristi
ReplyDeleteSupposedly, they should inherit the same IVIVINDX of the original cost layer in IV10200. The link is made by linking the following IV10200.RCTSEQNM=IV10201.SRCRCTSEQNM
DeleteYour feedback is highly appreciated,
Best Regards,
Mahmoud M. AlSaadi
We ran into an issue where Return Quantities were updated on items after running the IV Reconcile. Would you be able to tell me the scenarios that could result in quantities going from On-Hand to Returned? I would like to run a script that would identify what's causing it to happen.
ReplyDeleteWhen they do SOP Returns, they are setting the quantity types to On-Hand. But, there is a lot of history and I'm not sure that is was always done this way.
Below is an example of the one item's results after running the reconcile:
118303 Dutch Potato Salad Bulk
The On Order Quantity for Vendor 28450 has been adjusted from (630.00) to 0.00.
118303 Dutch Potato Salad Bulk All Sites
The On Hand Quantity has been adjusted from 630.00 to 30.00.
The Returned Quantity has been adjusted from 0.00 to 600.00.
The On Order Quantity has been adjusted from (630.00) to 0.00.
118303 Dutch Potato Salad Bulk MAIN
The On Hand Quantity has been adjusted from 630.00 to 30.00.
The Returned Quantity has been adjusted from 0.00 to 600.00.
The On Order Quantity has been adjusted from (630.00) to 0.00.
Hello John
DeleteThe IV10200 and IV10201 could tell the whole story, all cost layers are stored there (open and closed) along with the quantity type.
Adjusting the quantity type is based on reference cost layers in the "Purchase Receipt Work and Details Tables, IV10200 and IV10201"
Best Regards,
Mahmoud M. AlSaadi
dear Mohammad,
Deletethanks for the article it is very important,
i need your help for one item has issue with qtyonhand it is showing 0 while it should be 1, i have reconcile it without any error but on hand is 0. also i tried to change the value in iv10200
UPDATE IV10200 SET RCPTSOLD=0,QTYSOLD=0 WHERE ITEMNMBR='RBFS-058' AND RCPTNMBR='GTN0214266'
after that i have reconcile it and it goes back 0.
i have check all tables that i know as below but i could not success.
so how the reconcile procedure is working?
IV10200
ITEMNMBR QTYRECVD QTYSOLD QTYONHND
RBFS-058 1 1 1
RBFS-058 1 1 1
RBFS-058 1 1 1
RBFS-058 1 1 -1
RBFS-058 1 1 0
RBFS-058 1 1 -1
RBFS-058 1 1 0
RBFS-058 1 1 1
RBFS-058 1 1 1
RBFS-058 1 1 0
10 10
IV10201
ITEMNMBR QTYSOLD
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
RBFS-058 1
9
IV00200 NO serial tracking
iv00300 NO lot tracking
sop30300
ITEMNMBR QTYTOINV
RBFS-058 2
iv30300
TRXSORCE ITEMNMBR TRXQTY
RECVG00001599 RBFS-058 2
IVTFR00006773 RBFS-058 2
RECVG00002566 RBFS-058 2
IVTFR00010523 RBFS-058 2
RECVG00003564 RBFS-058 1
IVTFR00014660 RBFS-058 1
IVADJ00000945 RBFS-058 -2
SLSTE00007022 RBFS-058 -2
without transafer qty 1
Dear Mr. Foud
DeleteWould you please email me on MahmoodSaadi@Live.com in order to follow up on this case.
Best Regards,
Hi Mahmoud, thanks for sharing this information, is very usefull, let me check my system and try to see why reconcile add some RECONCILE lots... trying to see all item, I still can't find why are generating this added lot, all quantitys are correct. May you help me with that?
ReplyDeleteIV00300 (3 rows)
IV00102 (3 rows)
IV10200 (11 rows)
IV10201 (21 rows)
IV30300 (30 rows)
IV30400 (15 rows)
IV30301 (34 rows in join with IV30300)
Thanks for your support if you can, have a good day
Looking for why reconcile lots appears, I see that field DATERECD between IV00300 and IV10200 are differents, when this field are updated to same value, don't apper more reconcile lots.
DeleteThanks for sharing this flow information, it's helpfull.
PD: other fields ITEMNMBR, TRXLOCTN, RCTSEQNM and QTYRECVD already was equals