We are having a problem in Adagio Inventory 8.1A (090217). We receive product with POA. Then we send the printed receipt to the warehouse and the item is put away on the shelf. At that point the warehouse worker goes into Adagio Inventory and updates the Picking sequence using Edit Item. The problem is that when you look at the Quantities of the item in Item Inquiry, it shows the updated picking sequence at our other branches but our own branch still shows the old picking sequence before it was updated. When we look at Edit Picking Sequence, it shows our branch set to a specific picking sequence instead of "default". We have to manually change it back to "default". How can we force all branches to use the default location all of the time?

Hello Susan:

It sounds as if you are encountering a bug in POA when receiving brand new items. Another user found the issue under different circumstances, but I think the cause is the same.

See this thread (you can pick it up about half-way through): Related thread

Hi Bruce,

That link isn't working for me. Could you paste it again? I searched for it but didn't see the thread you're referring to.

I thought perhaps the issue might be something to do with Toolkit entries on those items, but I'm not sure. I haven't been able to pin down exactly what is causing it. I really wish we could lock all locations on "Default".

Hi Susan:

Strange, it works for me, but there's another way. Go to the "General Inquiries Forum" and look on the second page for the thread entitled "Physcal Inventory in IC" last updated on June 4, 2009.

It's a lengthy thread but I think the underlying situation is the same as your's.

We are still having problems with Picking Sequences for new items that are received in POA. After the product is received on the system in POA, we physically put it away on the shelf and then add the Pick Sequence to Adagio Inventory/Edit Item. The Pick Sequence then appears correctly in Edit Item, but in Item Inquiry/Quantity on the Pick Sequence column it shows up BLANK in the grid. The Item Inquiry/Profile tab shows the Pick Sequence correctly. Edit/Item Maintenance/Pick Sequence appears correctly (Default Picking Seq-E4, Location-WA, Picking Sequence-Default, however, the only way to get the Pick Sequence to show up correctly in the Item Inquiry/Quantity Tab/Pick Sequence column is to select the location and click Default. Then it says "Do you want to change the picking sequence for this item to default", and we click Yes. Voila, it now appears in the grid in Item Inquiry/Quantity/Pick Sequence.

I believe it was the Hot Fix on June 22/09 named: POHFP20090619.EXE that was suppose to fix this issue. It seems to be only partially fixed in that each location now appears correctly as "Default" in Item Maintenance/Edit Picking Sequence, however, it's still does not appear in the Item Inquiry/Quantity/Pick Sequence column on the grid, until you reset it to default manually.

Hi Susan,

Picking sequences on Inventory items are stored in two different places. There is a 'default' picking sequence that is stored on the master item and is visible on the Profile tab of Item Inquiry.

You can also set a picking sequence for a specific Location for that item, and this information is visible on the Quantities tab of Item Inquiry.

The problem you are seeing with 'blank' appearing in the 'Picking sequence' when using Item Inquiry and looking at the Quantities tab is likely not a Purchase Orders issue but rather an Inventory problem. If I take an item for which 'default' pick sequences are defined for all locations, then Edit the item and on the Location tab I highlight a location and click the 'Default Seq' button, I now no longer see the Master item pick sequence in Item Inquiry, but instead it is blank.

Or if I create a new item and within Edit Item I choose to make the item Active at a location by highlighting the location and clicking the Active button, the same scenario occurs.

To fix, I had to do what you did and use Edit / Item Maintenance / Pick Sequences and reset the location to Default.

So there may be an issue somewhere in using 'Default seq' and 'Active' when creating the item and what gets written to the 'Pick Sequence by Location' data file.

Do you have the Inventory option 'Allow items at all locations' enabled? This could have an influence on what you are doing and when this information is updated. Also, how (and where) are you creating the new item and how are you making the item active at a location (when creating the item or receiving goods)?

Allow items at all locations is enabled - yes.

We create new items usually in Inventory. Sometimes in POA.

OK, thanks for that information.

When new items are created, do you manually make items active within Edit Items and/or Item Maintenance / Item List for Location? Or do you simply receive goods in POA for that item to a location and let that process make the item active at that location? Or both?

I can confirm that making new items active at locations has the issue with showing 'blank' as the Pick Sequence within Item Inquiry, instead of the master item pick sequence. We'd like to ensure that if you perform steps in a different way, we fix that scenario as well.

We receive goods and in the process, POA requires that we make the item active.

When creating new item codes in Inventory, by default check there is a check mark in "Active Item". We do not change this.

Otherwise we don't do anything to make items active or not.

When will this issue be corrected? Before the Hot Fix on June 22/09 (POHFP20090619.EXE) I was able to identify where the problem was occuring using a Gridview filtered with {Picking Seq} <> "". We manually fixed the Inventory Items that showed up in that Gridview report. Now that the problem is only partially fixed, we have no way of finding these items until we run into individual problems. Is a fix coming soon??

Softrak Support,

Any update on a fix for the Pick Sequences?

Also, on a side note, we would love it the Pick Sequence field would accept more than 4 characters. We very often have the same item in more than 1 location (ie B2, F3, C5). The limitation of 4 characters is too restricting. Is this something that could be limited to more characters in the future?

A service pack is now available for Inventory 8.1B to show the pick sequence in Item Inquiry. Note that the scenario was something not being correctly saved on the item record, so just installing the service pack will not automatically correct the inquiry problem. You have to go back and re-edit items to ensure they are active at locations, and that will write the required information for the display issue.

Any items added in the future will be correctly set up to display the default picking sequence within Item Inquiry.

We can't change the picking sequence length right now for compatibility reasons, but we are open to considering changes for the future.

Hi Susan,

Some of the reports are printed in bin sequence (for picking). How can we handle more than a single bin for an item?

Hi Softrak Support, Great to hear about the fix. I look forward to receiving the download info in an email.

Hi Andrew, We have always used the Pick Sequence field for more than one warehouse location. An example is that we stock small items in bins for easy picking in section H4. When the bins run low, we restock from master boxes kept in C2. So our pick sequence is H4C2. Sometimes wire and cable takes up several sections so we enter it as B1-7. We've never had it so perfect to have every item on our system in only one section per item.

We have 5000 item codes on our system with 2500 of those with quantites on hand. Whenever we receive product, we update our pick sequence on the system. When a customer places an order, the pick sequence prints on Pick Slips so the product can be easily found. We therefore rely heavily on the pick sequence field being as descriptive and accurate as possible.

I can't think of a report that I've ever printed that I would sort by pick sequence. Occasionally if we're cleaning up a particular section I'll do a search in Inventory of items where the quantity on hand is greater than zero and the pick sequence contains B2.

A little off topic now is that in spite of all of our efforts to organize our product, the system and train our staff, picking errors are still occurring way too often. We have too many similar products with similar model numbers. When we replenish stock the product often comes in with a different model number and we end up with product in stock that is under the same item code and essentially the same item, but with a different model numbers on the box.

I think it may be in our future to integrate a bar code system so we can scan product as it is received, put away and sold. Is there a way to implement a bar code system with our Softrak software?

Hi Susan,

It's called warehouse management and comes from RF Pathways, but it's not cheap. 10 people saying "barcoding" have 10 different ideas of what that means.

Having said that, it's part of the "scope" discussion for future changes to Inventory. Of course, you're also talking about changes to OE and POA too, so this is a significant amount of development.

Dear Susan,

Are you still interested in "bar code system" for Adagio ?

My company specializes in developing mobile applications for Adagio.
I think I might have a solution for your business: "Warehouse Management for Adagio Accounting"

Please visit http://lenmax.com/wms.html to find more.

Regards,