Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Total item's all L...
Microsoft Dynamics GP (Archived)

Total item's all Lot No. (Inventory QTY not= SOP QTY)

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

Have cleared Activity, SY00800,SY00801, DEX_LOCK, DEX_Session after all GP users logout.

Have run CheckLink for all Sales and Inventory logical files.

By the way, I ensure correct Site ID was selected, and I have run the Utility>Inventory>Reconcile for the particular Item number. 

But in SOP invoice, the total quantity add-up for all the Lot numbers is not matched with the Available stock in Item Stock Inquiry! why is that so, how can I rectify it ?

Please advise, many thanks in advance.

[ GP 9.0 SP3, SQL server 2005 standard 32-bit ]

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    Hi William, just to confirm:

    Is it the case that when you include all sites you get the correct figures? - just wondering since you say 'So, the restricted view to BR site does cause this mismatch issue.'

    Have you resolved the issue? If the above is true, then a quantity must exist on anothe site - and it looks like its a negative qantity.

     

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Re: Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    They have only BR site (the main site) to keep all those stock, the rest of sites do not have this item. So, the restricted view to BR site does cause this mismatch issue.

    Anyway, I appreciate for your reply. Thank you so much.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    Hi William, would it be a site issue? In the Item Stock Enquiry window you are showing stock for all sites....while in the SOP Entry Lot Number enquiry you are restricted to site 'BR'.

    Restrict the display in the Item Stock Enquiry window to be just the 'BR' site and see do the figures agree.

    All I can think of at the moment...

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    I have done CheckLink for Inventory, Sales and Purchasing, and then completed Inventory Reconcile for this item GDEXT0022 but in the SOP invoice entry the QTY available for this item shows 5290.0000 but in the Inquiry>Inventory>Items or Item Stock, it shows 5060.000 with different of 230.0000 between SOP and Inventory.

    Why is that so? Please find the attached screen captures for more information.

    Screen_Capture_1_Inventory_Stock_Item

    Screen_Capture_2_SOP_Invoice_Entry

    Screen_Capture_2_SOP_Invoice_Entry_Lot_No

    Please advise. Many thanks.

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    Apology for confusion. Actually, in SOP invoice, I referring to the Invoice quantity then I will need to select the Lot Quantity in the "Sales Lot Number Entry" window, but all the Lot numbers add-up the Lot quantity available and the total is not the same as the Quantity Available showing in the Inquiry>Inventory>Lots (Lot Number Inquiry).

    In other words, in the SOP invoice entry I need to know the stock available for all the Lot numbers, but when I added all the Lot quantity, and is more than what is shown in the Lot Number Inquiry.

    Thank you for mentioning about the Item maintenance>Options>Maintain History settings, but this is not the cause.

    Please advice and many thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Total item's all Lot No. (Inventory QTY not= SOP QTY)

    Hi William,

    Not sure I fully understand the issue. There is no reason why the total quantity on SOP invoices for an item would add up to the inventory quantity. Are we talking about the Quantity Sold figure that is displayed in the Item Enquiry window?

    There is one reason why this might not match. If at some stage in the Item Maintenance window, the history options were not ticked, and sales invoices entered, then these sales invoice quantities would not affect the Inventory Qty Sold figure. Is the Total SOP quantities greater than the Qty Sold figure?

     

     

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