Page 1 of 2 1 2 >
Topic Options
#39669 - 12/31/13 09:32 PM Inventory Worksheets
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
We used the physical inventory worksheet under transactions to get our count sheets. Worked well. I then used the export physical inventory worksheet to get an Excel copy. Again, worked well. But when I was transferring the count numbers from the count sheets to Excel, I ran into a problem in that the two sheets didn't match. It seems that the worksheet you get under transaction doesn't print "On demand" items while the exported worksheet does. We don't have many on demand items but there are a few, and it slowed me considerably only because I had to check to make sure that the numbering I was transferring matched the correct item in excel.

This the criteria for the transaction worksheet.
Sort order: Item number, picking sequence
Selection: Items from location with any control set
All item numbers
All picking sequences

Bruce has modified it once for us, so I was wondering if it could be modified to show on demand items? Actually, I would prefer that the export worksheet didn't export on demand items.

Any ideas?
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39670 - 01/01/14 06:28 AM Re: Inventory Worksheets [Re: MikeS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Mike,

By "on demand" items, do you mean "non-stock" items? I can understand why those aren't necessary on a physical inventory worksheet.

PS - Working petty late for a New Year's Eve, aren't you?
_________________________
Andrew Bates

Top
#39679 - 01/01/14 06:42 PM Re: Inventory Worksheets [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Hi Andrew,

Yes, and I would prefer not to have them on, but could you add this field to the list for exporting to excel? Once the physical inventory worksheet is exported, I could then sort it, and delete the non-stock (on demand) items so it then match the physical inventory worksheet I printed from under transactions.

Thanks

(We were chaperoning my son's new year's party and were off to bed when they decided to cook a couple of pizzas. There was no way my wife was going to bed until she knew the oven was off, which meant I wasn't going to bed either frown ).


Edited by MikeS (01/01/14 06:42 PM)
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39687 - 01/02/14 04:04 PM Re: Inventory Worksheets [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Mike,

I investigated this, and with the current release of Inventory, I could not replicate a problem where non-stock items were included in the exported Physical Inventory worksheet in Excel or CSV formats.

Perhaps by 'on demand', you meant items that have not yet been made 'active' at a location? Editing items and looking at the Locations tab shows the text 'On demand' in the 'Permit entry?' column if the item is not yet active at a location. Items not yet active at a location is different than a non-stock item, which means the 'stock item' option on the item is disabled.

If you can clarify specifically what you mean by 'on demand' with an example, that would give us a better chance to address any problems.
_________________________
Regards,
Softrak Tech Support

Top
#39691 - 01/03/14 03:42 AM Re: Inventory Worksheets [Re: Softrak Support]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Good Morning Support

1. All items in our inventory are stock items (stock item box checked under Units tab).
2. The Allow items at all locations option is turned on in the Company Profile.
3. On Demand shows for locations where an item is not active.

When I was transferring the count, the two lists didn't match. I just wanted to get it done so I didn't really pay attention to which items were missing. I'm going to look at it today to see if I can figure out what happened. I just assumed it was the items showing on demand (inactive). Will let you know.

Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39692 - 01/03/14 04:09 AM Re: Inventory Worksheets [Re: MikeS]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
The first dozen items that were missing all had a default picking sequence defined but were showing on demand (inactive) at all locations. Not sure how this happened but I suspect that it was when we transferred inventory over from the old accounting system. I'm going to check the rest of inventory to be sure but I think that's the problem.

Thanks


Attachments
Location.png (131 downloads)

_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39694 - 01/03/14 06:55 AM Re: Inventory Worksheets [Re: MikeS]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
I'm pretty sure I know what happened. All of the items I'm finding had some activity in our old accounting system but have had no activity in Adagio (all were zero quantity items when we switched). They have a pick sequence but no activity. This has caused the two lists to be out of sync. I have two questions though.

Firstly, say we decided to carry a new line of merchandise, for example bikes. To save time, all the models we plan on selling are entered into the inventory. Should they be checked as inactive or a non-stock item. Will either, or both, options have the item appear in the physical inventory worksheets (exported and printed)?

Secondly, is there an easy way of finding these type of inventory items? I'm having to go through the exported and printed worksheets item by item to find them. I tried to create a Gridview but can't find the field that regulates Permit Entry? which gives me on demand.

Thanks

Update:
I have a Gridview now (if both Units Sold YTD and Quantity On Hand are zero, this item will not appear on the printed Physical Inventory Worksheet).


Edited by MikeS (01/03/14 08:51 AM)
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39702 - 01/03/14 09:26 AM Re: Inventory Worksheets [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Mike,

I believe I was able to replicate the problem. I created a brand new item from scratch, and did not make it active at any location. Naturally the qty on hand is zero. When I choose 'All items' for the worksheet and also include the option 'Suppress 0 qty items', this new item does not print on the worksheet report, but it is included in the export file, incorrectly. This should be fixed.

If I make the item active at the location, then it properly gets suppressed from the export.

When an item is On Demand at a location, it means there is no record in the item location file for that item/location combination. So GridView can't be used to search for a data value there. Looks like you got something that works for GV?
_________________________
Regards,
Softrak Tech Support

Top
#39705 - 01/03/14 10:06 AM Re: Inventory Worksheets [Re: Softrak Support]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
The easiest way to re-create it is to create a new item by copying an existing item. The new item will have the originals' default picking sequence but will show on demand for all locations. It can be fixed by selecting the activate button. I think importing an adjustment file with a positive and negative quantity for each item is the easiest way to fix it, unless you have a better idea?

Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#39708 - 01/03/14 10:16 AM Re: Inventory Worksheets [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Easier - Edit a Location and open the Items tab. Items not active will be blank in the Selected column.
Click the All Items button to make all items active at that location.
Or if you want just a range of items, this can be done from the Item Range tab.
_________________________
Regards,
Softrak Tech Support

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 77 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30