Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Item Transaction History check box affects which table(s)?

(0) ShareShare
ReportReport
Posted on by 75,730

When you check the Maintain History for Item Transactions for an item which tables are affected? I have tried comparing an item where that is checked and one where it is not and the same tables appear to be getting hit.

Categories:
  • Suggested answer
    RE: Item Transaction History check box affects which table(s)?

    Hi Richard,


    Without doing some detailed review and testing, I can't say for certain why the issue continues to return. There could be an issue with the Item Stock Inquiry window.


    We can see if any other GP folks can chime in on possibilities here; otherwise, we'd be happy to take a more detailed look into the client's issue in a support ticket.


    Best Regards,

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Item Transaction History check box affects which table(s)?

    Lucas, can you explain this dilemma?  Client had quantities that did not match when they would display U/M on the Item Stoick Inquiry screen. As long as the base U/M was quantity 1 all was fine. So here is what I did.

    1) Backup IV30300

    2) Remove all records in the IV10200 and IV30300 tables

    3) Reconcile quantities so IV00102 has zero qty on hand

    4) Flip the Maintain History flag on

    5) Import the transactions using the backup

    At this point in time now they can change the display U/M and the quantities agree. A week or two later after they have processed IV normally the problem returns. What could they be doing or what is set incorrectly to cause this issue to return?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Item Transaction History check box affects which table(s)?

    Thanks Lucas, that explains why their Item Stock Inquiry screen does not work.

  • Verified answer
    RE: Item Transaction History check box affects which table(s)?

    Hi Richard,


    The IV30300 (Inventory Transaction Amounts History) table is used for maintaining item transaction history.


    Mahmoud M. AlSaadi has a great little article on this option:
    https://mahmoudsaadi.blogspot.com/2014/01/inventory-maintainremove-transaction.html


    I don't think there have been any changes to that feature between versions.


    I hope that helps!

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans