Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : MXpn08q6rg0vfAarnMFOkO
Microsoft Dynamics GP (Archived)

Zero Quantity on Stocktake

Like (0) ShareShare
ReportReport
Posted on 16 Jun 2008 21:11:37 by 100

I have a client who has 1000's of items.  When they do a stocktake many of these items are counted as zero.  Is there any way of having GP set the counted quantity on a stocktake to zero without going into each line?  Also, when you do go into each line, you can not simply put zero, you have to put another number and then change it to zero or it thinks you haven't counted that line yet.

Thanks,

*This post is locked for comments

  • Albert Quezada Profile Picture
    95 on 30 Nov 2017 at 14:03:59
    RE: Zero Quantity on Stocktake

    Hello. Leslie

    is possible you can show me step by step how I can accomplished this in GP 2013 R2?

    Thank you in advance,

  • Suggested answer
    L Vail Profile Picture
    65,271 on 05 Nov 2017 at 18:48:16
    RE: Zero Quantity on Stocktake

    If it's just the report that you want to change, you can do that in Report Writer by adding a restriction to the report. The restriction should include only items where the quantity on hand <> 0.

    Leslie

  • Suggested answer
    Almas Mahfooz Profile Picture
    11,006 User Group Leader on 03 Nov 2017 at 08:15:04
    RE: Zero Quantity on Stocktake

    Albert I don't think it can be done by report writer, but yes can be done by dexterity customization.

  • Albert Quezada Profile Picture
    95 on 02 Nov 2017 at 13:10:32
    RE: Zero Quantity on Stocktake

    Inventory---> Transactions---->Stock Count Schedule

  • Suggested answer
    Almas Mahfooz Profile Picture
    11,006 User Group Leader on 02 Nov 2017 at 08:36:39
    RE: Zero Quantity on Stocktake

    0 quantity items can be suppress from report, can you tell me the exact name of report or share screen shot?

  • Albert Quezada Profile Picture
    95 on 01 Nov 2017 at 14:23:01
    RE: Zero Quantity on Stocktake

    Good Morning Mariano.

    Is possible to run a stock count without the zeros? I'm running an item stock count by class and I just want the report to shows ONLY items that have quantity on hand. 22 pages with items that has zeros vs 5 pages items that have inventory in GP. (Historical Stock Trial Balance Status report)

  • Suggested answer
    Community Member Profile Picture
    on 08 Jan 2017 at 22:19:12
    RE: Zero Quantity on Stocktake

    declare @stockcountID char(20)

    set @stockcountID = 'CERO' -- replace for the actual stock count you created

    update IV10300 set ATPSTVRNC = 1 where stckcntid = @stockcountID

    update b set VERIFIED = 1,

    b.VARIANCEQTY = -b.CAPTUREDQTY,

    b.STCKSRLLTVRNC = -b.CAPTUREDQTY,

    b.COUNTEDQTY  = 0  

    from IV10301 b where stckcntid = @stockcountID

    update c set  c.VERIFIED  = 1,

    c.VARIANCEQTY = - c.CAPTUREDQTY,

    c.COUNTEDQTY = 0

    from IV10302 c where stckcntid = @stockcountID

  • Mariano Gomez Profile Picture
    26,225 on 28 Aug 2009 at 17:45:55
    Re: Re: Zero Quantity on Stocktake

    That was a known issue and I think it got fixed with SP4, but I have not confirmed this yet.

  • Community Member Profile Picture
    on 28 Aug 2009 at 16:20:24
    Re: Zero Quantity on Stocktake

    I found a bug in GP - V10. The GP Stock Count Mass Add items does not work when using multiple bins, check the "Include Items/Sites with 0 quantity and mass add using the Generic Description stock count range or one of the other options that is not an indexed field. NOTE: The "Include Items/Sites with 0 quantity" option is only available when using multiple bins.

  • Braam Koekemoer Profile Picture
    500 on 04 Mar 2009 at 08:40:52
    Re: Re: Re: Zero Quantity on Stocktake

    Thanks yes, that is true.

    We must do a product suggestion MBS that the add a mark all button to the stock entry screen. 

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,337 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete