Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Unposted Inventory Transfers in the Historical Table

Posted on by

Hi everyone,

Looking for some help on some mysterious transactions showing up in the GP view "InventoryTransactions".  We use this view in a SmartList for members of my Inventory team to track down issues.  I've received questions about 10 Inventory Transfer Documents that show up as "Unposted" and do not have a batch anywhere. After some poking around I noted that not only were these all probably created by a Check Links back on 10/5, but they are all "Unposted" but in the History Tables???

They all appear to either be simple Inventory Transfers used to move stuff between In Service and On Hand, and everything looks good on the floor, so I'm looking for advice on how to clean these up.  Assuming there is no way to "Post" from history, should I just update via SQL or delete from SQL?

Thanks,

Karl Pedersen

IT Director

Nye Lubricants, Inc.

*This post is locked for comments

  • KarlPedersen Profile Picture
    KarlPedersen on at
    RE: Unposted Inventory Transfers in the Historical Table

    In full disclosure, I am not very familiar with the proper tables to check. I am only looking at them because they are showing as Unposted in the "InventoryTransactions" GP SQL View.  

    If I open up the Inventory Transfer Inquiry to find them I can, but they don't show up in Entry, so I assumed they are historical.  

    They all have entries in IV10200 where the document number is under RCPTNMBR and the items and quantities match.

    My SEE30303 table is empty.  Anywhere else I should check?

    Karl

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Unposted Inventory Transfers in the Historical Table

    It is quite possible that checklinks would create documents in certain cases, but it would not post them automatically, they will be saved in order for you to check their validity and post them accordingly.

    Please let us know on whether you can check on which tables these transactions are; as Richard implies above, and share your resutls.

    Your feedback is highly appreciated,

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Unposted Inventory Transfers in the Historical Table

    In which tables do you see these transactions? IV10200, SEE30303 or other tables? You need to be careful what you remove because you do not want to mess up the IV reconcile routine.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans