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)

MG-16101311-0 26,225 on at

Like (0)

Report

Re: Zero Quantity on Stocktake

1) Create a stock count schedule for all items. Go to Transactions > Inventory > Stock Count Schedule. Enter a Stock Count ID, i.e., CLRQTYS.
2) Mass Add all items in your inventory by any criteria
3) Start the count by clicking on the Start button. Close the Stock Count Schedule window.

NOTE: you can choose to uncheck the Reuse Stock Count checkmark.

4) Open the Stock Count Entry window. Go to Transactions > Inventory > Stock Count Entry. Mark all items as counted without entering any values (they are automatically defaulted to zero).

NOTE: If the company has a great number of products, the items can be marked as counted with the following SQL script

declare @stockcountID char(20)
set @stockcountID = 'CLRQTYS' -- replace for the actual stock count you created
update IV10300 set ATPSTVRNC = 1 where stckcntid = @stockcountID
update IV10301 set VERIFIED = 1 where stckcntid = @stockcountID

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

Like (0)

Report

Re: Zero Quantity on Stocktake

Hi, the only problem with this script is if an item has a qty on hand theoretically but there is no physical count, and the user does not know about it, no variance get calculated, which can cause stock count descrepencies, meaning the system stock for which no physical stock exist will remain on hand.

Was this reply helpful? Yes No
mpolino on at

Like (0)

Report

Re: Re: Zero Quantity on Stocktake

The assumption is that you would run the script after all the other counts are in. Running the script would be the last process to cleanup after the count was believed to be final.
Mark

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
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
MG-16101311-0 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
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
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

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

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

Was this reply helpful? Yes No