Print Page | Close Window

Inventory Report: Multiple totals for same Item

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=1529
Printed Date: 20 Oct 2020 at 4:38am
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: Inventory Report: Multiple totals for same Item
Posted By: Andre_D
Subject: Inventory Report: Multiple totals for same Item
Date Posted: 07 Apr 2013 at 8:37pm
Hello,

There has been a past post similar to mine, but your solution is no longer available.

Basically, if I have, say, 100 units of ItemA in Bin1 of Warehouse1, and I Direct Receive 20 units of ItemA to Bin1 of Warehouse1 (Adj. Code: Cycle Count), well, Inventory Units in Stock and Inventory Cycle Count Reports do show 120 units in Bin1.  They show 100 units in Bin1 and 20 units in Bin1.

I do not need to keep track of the age of my inventory. There really is no expiry date to my inventory items (A copper fitting for example).  Can I specify somewhere that any inventory reception method simply ADD the received amounts to what is already in stock in the specified location?

Your solution to the older post was as follows (but is no longer applicable)

__________________
Download

http://www.almyta.com/downloads/Inventory_Position_Snapshot_Totals.zip" rel="nofollow - http://www.almyta.com/downloads/Inventory_Position_Snapshot_Totals.zip

and unzip. Use the System/Import Reports menu to load this report into the system.
The report can be found in the All Reports screen, Inventory section.

__________________


Thank you,


André


 



Replies:
Posted By: Andre_D
Date Posted: 09 Apr 2013 at 11:35am
Hello,

I realize I made a type-o in my previous question that "may" be causing some confusion.

I wrote: ... (Adj. Code: Cycle Count), well, Inventory Units in Stock and Inventory Cycle Count Reports do show 120 units in http://viglink.pgpartner.com/mrdr.php?url=http%3A%2F%2Fviglink.pgpartner.com%2Fsearch_attrib.php%2Fform_keyword=bin1&mt=%7E%7E%7E%7E%7E%7E%7E%7En%7E%7E%7E" rel="nofollow - Bin1 .  They show 100 units in Bin1...

I Meant: ... (Adj. Code: Cycle Count), well, Inventory Units in Stock and Inventory Cycle Count Reports DON'T show 120 units in http://viglink.pgpartner.com/mrdr.php?url=http%3A%2F%2Fviglink.pgpartner.com%2Fsearch_attrib.php%2Fform_keyword=bin1&mt=%7E%7E%7E%7E%7E%7E%7E%7En%7E%7E%7E" rel="nofollow - Bin1 .  They show 100 units in Bin...

I apologize for the confusion if any.

If anyone can help, I would appreciate it.

Thank You,

André


Posted By: BillD
Date Posted: 10 Apr 2013 at 6:50am
The report Inventory_Position_Snapshot_Totals has been placed back into place. thank you for finding a bad link.
It is not just about expiration date. Each receiving transaction creates a separate row in the database. There is more info to each row than it seems. This is why we keep each receiving batch separately.
You can consolidate a few rows. Please see Help/Starting up, Consolidating Lots. Today, it is page 37.


Posted By: Andre_D
Date Posted: 10 Apr 2013 at 11:48am
Hello Bill,

Thank you for your response.

I had seen that we could consolidate some rows, but wondered if there was a default setting somewhere.

I didn't even wonder WHY we would want to keep everything separate, but it makes complete sense when I think about it.


Again, Thank you,

André


Posted By: BillD
Date Posted: 11 Apr 2013 at 7:40am
No, Andre, there is not such default.



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