Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Sunday, November 17, 2013

Inventory Reconciliation Flow

 

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”

1

2

 

Summary:

Below as an overall summarized representation for the several processes being involved in the process.

3

 

Best Regards,
Mahmoud M. AlSaadi

8 comments:

  1. 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

    ReplyDelete
    Replies
    1. Supposedly, 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

      Your feedback is highly appreciated,

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  2. 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.

    When 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.

    ReplyDelete
    Replies
    1. Hello John
      The 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

      Delete
    2. dear Mohammad,
      thanks 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

      Delete
    3. Dear Mr. Foud
      Would you please email me on MahmoodSaadi@Live.com in order to follow up on this case.

      Best Regards,

      Delete
  3. 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?
    IV00300 (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

    ReplyDelete
    Replies
    1. 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.

      Thanks for sharing this flow information, it's helpfull.

      PD: other fields ITEMNMBR, TRXLOCTN, RCTSEQNM and QTYRECVD already was equals

      Delete