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
Hello. Leslie
is possible you can show me step by step how I can accomplished this in GP 2013 R2?
Thank you in advance,
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
Albert I don't think it can be done by report writer, but yes can be done by dexterity customization.
Inventory---> Transactions---->Stock Count Schedule
0 quantity items can be suppress from report, can you tell me the exact name of report or share screen shot?
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)
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
That was a known issue and I think it got fixed with SP4, but I have not confirmed this yet.
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.
Thanks yes, that is true.
We must do a product suggestion MBS that the add a mark all button to the stock entry screen.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156