Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Oversold issue
Microsoft Dynamics GP (Archived)

Inventory Oversold issue

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have come across a weird issue where for some non tracked materials are oversold in cost layers i.e. sold quantity is issue layer( table  IV10201) is more than sold quantity and receipt quantity in receipt layer (table IV10200) for same receipt sequence number.

Join of tables : IV10200 - columns [ITEMNMBR], [TRXLOCTN], [RCTSEQNM]   join with IV2010 columns [ITEMNMBR], [TRXLOCTN], [SRCRCTSEQNM].

Due to this, if I validate Purchase receipt inquiry screen for the item and try to calculate on hand from Total Received - total sold then it does not get matched with actual on hand on item maintenance.

Please help me what is the best way to correct this. I though of one solution - to run inventory reconcile first for the item, then make a negative adjustment with  the variance generated from cost layer (Difference of total sold qty from issue layer-total receipt qty from receipt layer) for that item but doubtful to do this.

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Inventory Oversold issue

    Hi,

    I'm confused as to what you mean by 'non tracked materials'. I thought the only way you could get an entry in the Purchase Receipts tabled was to sell or receive inventory items. Anytime you have an internal inconsistency like this, you have good advice directing you to run the Reconcile utility. To research it I would match the SOP documents in the IV10201 table with the documents in the SOP30300 table. I think any history inventory transactions will touch the IV30303, SOP30300, SEE30303 and IV10200/IV10201 tables. Depending on how far it is off, you may just do your adjustment and be done with it. All of that tracking down is very tedious.

    Kind regards,

    Leslie

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: Inventory Oversold issue

    there is an option in Inventory/SOP to sell more then Qty. on hand and then Inv. goes Negative. However what you are thinking is also a workable solution. Reconciliation will make the necessary adjustments if something is not transferred and taken out correctly and then Variance adjustment is the way to. SOP also has a prompt at the time of taking the order; to override the Qty. on hand and can be disabled not to go negative.

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