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
Hello. Leslie
is possible you can show me step by step how I can accomplished this in GP 2013 R2?
Thank you in advance,
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.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (