Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Inventory Transaction - Document Type - Adjustment

Posted on by 100

I have an Adjustment Document in Inventory Transaction whose header appears as greyed.

The Quantities of the items in the transactions appear allocated and I cannot reconcile the same in order to allow the quantity added back to the inventory.

Can anyone suggest how to rectify this error through SQL 2000 script or through the GP 8.0

*This post is locked for comments

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Inventory Transaction - Document Type - Adjustment

    Ashok,

    I am going to assume Serial Numbers and Lot Numbers are not in play here, as this would add further complexity.

    Sounds like a corrupted transaction In the system, can you print the Edit List.

    I would always run a in Test company or a backup of the Live company first.

    1. Run a Check Links on Inventory Transaction Work under Maintenance >> Check Links >> Inventory.

    2. If that doesn't fix the issue, and you cannot post or delete the transaction manually run the following SQL Statements on the Company Database, (Test Company first), replacing the Document Number with your Number.:

    DELETE IV10000 WHERE IVDOCNBR = '00000000000000035'

    DELETE IV10001 WHERE IVDOCNBR = '00000000000000035'

    3. Run your Reconcile again, then make any Inventory adjustments as necessary.

    If you do not have the necessary skills for SQL Statements, please seek professional advice.

    Mick

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans