|
| This site is dedicated to Almyta Systems Inventory Software |
Combine same Item ID in units in stock |
Post Reply 
|
| Author | |
Alain 
Newbie 
Joined: 27 Nov 2017 Points: 2 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Combine same Item ID in units in stockPosted: 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!
|
|
 |
|
|
Debra
Senior Member 
Joined: 22 Aug 2011 Points: 589 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
Alain
Newbie
Joined: 27 Nov 2017 Points: 2 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Debra
Senior Member
Joined: 22 Aug 2011 Points: 589 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 Dec 2017 at 7:48am |
|
You need to set a filter In Stock > 0
|
|
|
|
|
Rey
Newbie
Joined: 22 Apr 2019 Points: 2 |
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
|
Debbie
Newbie
Joined: 10 May 2019 Location: Durban Points: 1 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 Jun 2019 at 6:57am |
|
Please share once you have the answer to this as I have the same problem.
Thanks
|
|
|
|
|
Post Reply
|
|
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options