Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Urgent: Finished Goods Inventory Problem

Posted on by 1,110

I have a very serious problem regarding Finished Goods inventory stock. A batch of Production is posted by a user on 3 Jun 2014, but after that when I go through the smart list inventory transaction then that batch is there in posted state, but when I double click on any item of that batch it opened window "inventory transaction inquiry window" and all is fine. but when I opened Financial -> Summary or detail of that item ,and go to the debit of that month, and by giving specific date (3 Jun 2014) then it shows nothing, mean no any entry of production shows there, and also item quantity did not effect after entering that batch. now I ran reconcile of those items which are in that batch, after reconciling quantities of that item changed of all month. it effects all previous months, and changed stock of that item and now that item stock is showing in negative (in historical stock status as well as in inquiry window).

is there any way to undo the reconcile, or any other options so that inventory becomes match with actual. (according to account /store officer inventory quantities are OK until this reconcile but after this reconcile it effects the quantities of al months, including the previous fiscal years.

as test, I restore the backup of 2 Jun 2014 on a test server, and run reconcile of those items, but it did not effect any item quantity, but when I restore the db of 3jun 2014, and ran reconcile, it effects all inventory quantities.

i go through to mohdaoud.blogspot.com/.../mismatched-inventory-quantities.html but problem is, how i can undo / correct last years quantites, which were OK.

now I am in big trouble as fiscal year is near to end, any quick solution will be highly appreciate able, thanks....

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Urgent: Finished Goods Inventory Problem

    Okay then you have an issue with the transaction in the inventory tables that requires database modifications, the optimal solution is to restore the database to a time before the posting, if that is not possible I would suggest you restore your database to a testing environment and delete the transaction from all mentioned table and reconcile your inventory, if that worked as you need you can recreate your transaction and repost again, if everything worked as needed to apply the same on your production server.

    Hope that this fixes your issue.

  • RE: Urgent: Finished Goods Inventory Problem

    Edit : IV10200 table also contained no data of specified document.

  • RE: Urgent: Finished Goods Inventory Problem

    when i run reconcile this out put comes :

    Purchase Receipt ADJ1400359 contained invalid data and has been removed.

    The on hand quantity at BIN Main has been adjusted from 1635.150 to 1350.95.

    Now if i do GL entry, but how the last months/year inventory will be corrected???

    i restored db of 2 june 2014 on test, and run reconcile then no any change occurred. but when i restore 3 june db , and run reconcile, then it effects the inventory of all months including last year closing 30/6/2013. now i have different stock on live server of last year also. entry in gl will ok, but how can i match the history stock??

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Urgent: Finished Goods Inventory Problem

    As per your reply, it seems that all your inventory tables were affected properly, only IV10000 contains a corrupted record that need to be deleted, are you sure that all the records you found in the mentioned tables are correct, from date quantity and items?

    If yes then your inventory should look perfect, I have seen in your post that your inventory went in negative after doing the reconciliation which should mean that this was not due to this transaction and was to different type of transactions, if can verify this and confirm that your inventories were fine, I would advise you create the Journal Entry for this manually to tie the GL to the inventory and close the case.

  • RE: Urgent: Finished Goods Inventory Problem

    thx for reply...

    GP 2010

    Batch of production mean inventory adjustment, 3 June 2014 batch contain the production of 2 June 2014 which entered in gp using adjustment

    IVDOCNBR / Document number =ADJ1400359

    SEE30303

    IV10000 contain record of specific IVDOCNBR but BACHNUMB and BACHSOURC are empty and DOCDATE, MODIFDT, POSTEDDT and GLPOSTDT contain no date (i.e 1900-01-01 00:00:00.000)

    IV10001 contain no record of specified IVDOCNBR

    IV10200 contain records of specified document

    IV30200 contain records of specified document

    IV30300 contain records of specified document

    SEE30303 more then 14,000,000 rows and also contained records of specific document.

    on ur guidelines, these are db findings, now what to do next ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Urgent: Finished Goods Inventory Problem

    Hello Khurram,

    The information you provided is not enough to investigate your case, you need first to provide your GP version and to tell what was the first version you worked on in your company, this to identify if you have the SEE30303 table loaded with all inventory transactions or not, and to clarify what did you mean by "A batch of Production is posted", was that a manufacturing order receiving? Or purchasing receiving/inventory positive adjustment?

    Assuming that this is not a purchasing receiving transaction, you need to know what was the effect of the transaction you posted, take a look into the following tables and see the if the transaction is exist in these tables and if it is fully affected:

    IV10000, IV10001, IV10200, IV30200, IV30300, SEE30303, GL20000

    Please report back you findings to help you accordingly.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans