Zero Quantity on Stocktake

(0) Share

Report

Posted on by Travis Vigar

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

I have the same question (0)

All responses (13)

Answers (0)

Albert Quezada 95 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Albert Quezada 95 on at

Like (0)

Report

RE: Zero Quantity on Stocktake

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

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Albert Quezada 95 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mariano Gomez 26,225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Braam Koekemoer 500 on at

Like (0)

Report

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.

Was this reply helpful? Yes No