Print Page | Close Window

Combine same Item ID in units in stock

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Inventory Control
Forum Discription: Inventory operations
URL: http://www.almyta.com/forum/forum_posts.asp?TID=15698
Printed Date: 18 Feb 2018 at 10:05pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: Combine same Item ID in units in stock
Posted By: Alain
Subject: Combine same Item ID in units in stock
Date Posted: 27 Nov 2017 at 3:58am
Hello i have a question

Is it possible to combine same units in stock

at the moment it looks like this 

https://imgur.com/a/AY51Q

I want to combine and just show the total of each 
like 
10x 750029
10x 750173
and so on...

atm i have 27 pages

Thank you!




Replies:
Posted By: Debra
Date Posted: 30 Nov 2017 at 6:11am
You can use Item Master Summary report. It shows one line per item. Would it work for you? 


Posted By: Alain
Date Posted: 30 Nov 2017 at 2:38pm
That would theoretically works better but since i have a database as item master liste like over 5000 Items it shows a lot items with 0 in stock and when i switch to filter units then my Art.number(desription isn't in the right way. 

When i would do it withe the item Master Summary report i should be able to hide all 0 in stock items, but still keep my description A-Z filter work with everything higher than 0.

Is that possible somhow?

The problem is i just wanna use it to compare the list in ABC inventory to a manually Receive sheet that i recive from my deliverer.

Hope you understand what i mean :)

Thank you for your tipp


Posted By: Debra
Date Posted: 28 Dec 2017 at 7:48am

You need to set a filter  In Stock > 0 




Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk