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
Printed Date: 22 Jun 2021 at 6:17am
Software Version: Web Wiz Forums 10 -

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

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

atm i have 27 pages

Thank you!

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 

Posted By: Rey
Date Posted: 24 Apr 2019 at 12:27pm
I have the same problem. It shows plenty of rows with the same Item ID. Like this below

Item ID          Item Name                 Units
PN0001 Paper 8
PN0001             Paper 2
PN0001             Paper 5

I just want to do it like this:

Item ID Item Name Units
PN0001 Paper 15

Any solution to this issue?

Posted By: Debbie
Date Posted: 03 Jun 2019 at 6:57am
Please share once you have the answer to this as I have the same problem.


Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 -
Copyright ©2001-2011 Web Wiz Ltd. -