Interprise Suite Community / Interprise Suite Community Forums / Questions and Comments About Features, Functions and Workarounds / Inventory

Auto Allocating

Donna — Tue, 02 Feb 2010 10:09:55 GMT

In the workflow, is it necessary to to auto allocate every order? Each time we print, it pops up asking to auto allocate. Can this be turned off or preferences changed?

Thanks,
Donna

Committed Quantity is out of balance

Donna — Sat, 24 Apr 2010 06:31:31 GMT

We have an item that physically has zero in stock. We have shipped 6,873 pieces. We had an opening balance of 4,590 pieces and a GRN of 2,000 pieces.

Long story short. We have put into stock 6,875 pics and shipped out 6,873. All of these were put on sales orders, then rolled to invoices. The problem is that ISE shows 6,821 pieces committed still. If you go into the Inventory Module and call up the item, then click on the committed amount the "stock detail" box pops up and shows zero committed, but the Warehouse Stock Total box shows 2 on hand, 6,821 committed, free stock -6,819.

So, first, any ideas how it might have gotten out of balance? That's almost everything we have shipped on this item since the first of the year when we started ISE still showing committed. I have looked everywhere I can think of to see where it might be committed but there are no outstanding sales orders, no duplicated ones. Another odd piece to this is that there are 6,821 committed and we have shipped 6,873. That makes it off by 54 pieces. I have no transaction for 54 pieces.

Any ideas on how to fix it and get everything back in balance?

Thanks,
Donna

Vendor Price Increases

John Grande — Thu, 16 Apr 2009 15:33:25 GMT

Someone recently sent me the following question and thought I'd post it here. Anyone want to take a shot at this?

How do you change prices in Interprise? Many price changes have occurred on products I distribute. Can you import mass changes via spreadsheet or manually have to do them one item at time? If there are two vendors for same product can you import price changes for just one vendor using vendor item code?

Does anyone want to have a go at this one?

Duplicate Inventory Opening Balance Adjustments

Donna — Mon, 15 Feb 2010 13:53:40 GMT

What is the best way to fix a stock item that had an OBI adjustment done twice. Can one be deleted or is it best to do an off setting adjustment? I'm not looking for accounting type advice, just the best way to handle it in IS.

Thanks,
Donna

Barcode Label Printing

David — Wed, 15 Jul 2009 07:15:22 GMT

We have the ability to print Barcode product labels in Everest. Perfect for items we purchase unlabeled.

I see there is a printable 'Item profile' for items. I have seen also that we can custom build a reports that can include barcodes.

Anyone able to suggest how to go about making the label and also how to make it available to print in the item print dialog?

Bin Locations vs Warehouse locations

Mlittman — Wed, 09 Sep 2009 05:57:46 GMT

My customer has only 1 bin location per item. I am not sure whether to create a custom field in SP5.3.2 called Bin location and just have them enter the data there or should I attempt to use the warehouse locations fields? I have not been able to find any place to set the default location for each item and when it comes in from receiving ..how does the system know which location to populate?

Inventory Find - by other field data

ise_user — Thu, 20 Aug 2009 12:55:08 GMT

Lets say you want to find a stock item by a fields contents other than Item Name or Description how do you set this up?

i.e. 4.1.1. Inventory Item Find....Enter search criteria...Hoping it searchs the commodity code contents.

Even if you add the Commodity Code to the data dictionary as a searchable field - it is still not searched.

What am I missing - I know this i9s suppose to be easy to do.

Cheers

Matrix Item Description

Matthew White — Thu, 06 Aug 2009 08:08:26 GMT

We are starting to create new matrix items and notice that the description we enter on the Group is not the description that comes over on the item. The item description gets generated as the prefix code with the size and color attributes. So for example if my item as called Special Tee Shirt and I pick a prefix code of SP001, then the individual items get created as SP001 Size Large Color Red rather than Special Tee Shirt Size Large Color Red.

Does anyone have any feedback on this?

Inventory Quantity on a certain date

Matthew White — Wed, 29 Jul 2009 15:16:14 GMT

Is it possible to get the quantity in inventory of an item on a certain date in the past?

Item Status Values

Matthew White — Sun, 26 Jul 2009 15:14:31 GMT

Is there a way to add additional values in the Item Status field? I checked in the Data Dictionary on the InventoryItem.Status field and I see a static list of A,D,P for Active, Discontinued, and Phased Out. I thought I would be able to add my new values here but obviously there is a translation going on somewhere.

Item Taxable

Matthew White — Thu, 09 Jul 2009 13:46:31 GMT

We set up an item and set it with a Sales Tax Option = "item" and then Tax Code = " NO TAX" yet when I drop this item on a sales order for a local taxable customer, the item is taxed. Shouldn't the item tax override the customer tax flag?

Importing Non-Stocks

Mlittman — Tue, 14 Jul 2009 12:48:30 GMT

Is there any way of importing non-stock items into IS? I have only been able to import Stock Items. I have not found a way of changing the flags and allowing IS to import both Non and Stock Items.

Matrix Group Duplicate or Copy From - does not work

ise_user — Sat, 27 Jun 2009 23:06:42 GMT

Hi,
Does anyone know if this has been or will be fixed?

Select an inventory item that is a Matrix Group item (i.e. a Jacket that has colour and size options)
Select Copy Item
The item is copied but it does copy the Options or the image details.
If you do a Copy from in the Inventory wizard the same problem occurs.

This is a big deal if you are trying to add Matrix items to system/site - it effectively means you have to add each product from scratch - which will take a long time.......

Cheers

IS2007 Stf sp4 Hf1 4000.00004.rc2 (UK)

Item Ledger

NAYLARD — Thu, 18 Jun 2009 14:54:11 GMT

Why do GRN's appear twice in the item ledger? thx

Other Locations

Mlittman — Tue, 12 May 2009 08:29:05 GMT

I have a customer who is using SP5.3 and some of the products have quantities that show up in Other locations column. This is affecting his QTY Available. When I try to look in the Item screen and use the Warehouse TAB the Other Locations says 0.0. Yet in Invoicing it shows a qty. How can I correct or see why this data is different?

Is it possible to overwrite or update existing data using inventory import sheet?

Christian Byrne — Tue, 26 May 2009 19:11:26 GMT

I was wondering if there was a way to update my entire database of inventory using the inventory import sheet without duplicating the existing items. Is this possible and or am i going about it the wrong way?

Expanding the import fields in the inventory import sheet

Christian Byrne — Tue, 26 May 2009 19:21:37 GMT

I am getting ready to start importing products into my database and noticed that there are quite a few relavant fields missing in the inventory import sheet that would be nice to populate while doing an import than having to go back to each product and edit or tweak after the import. My question would be, Is there a way to add these fields into the inventory sheet and make then importable in the database? Example fields would be default warehouse, category 2,..web option...etc.

Any in sight would be greatly appreciated.

Web Option tab Filter by Role

Jim Wolf — Thu, 14 May 2009 10:44:53 GMT

In trying to resolve the problem mentioned in the previous post, I tried customizing the Web Option tab for a given role. I found that if you right-click on the heading area of the form, you get an option to add a filter to the form. The filtering wizard led me through the quick and easy process and I set up a filter by [i]Web Store Code[/i]="WEB-00002"

If you do that only and leave the customization form, it will not save your change. So you have to pretend to change the grid or something on the form and then it will save what you've done. When I go back into Inventory maintenance and go to the Web Option Tab, I see (this is VERY cool if it would work) my filter listed, but this is what it says:
[]='WEB-000002'

I think inside the [] it should say "WEB STORE CODE" because that's what I specified when I set up the form. Only I think moreover, the problem is that it should not be that, but instead it should be WebSiteCode, like that, without spaces. When you are setting up the filter, the options are given to you from a drop down list, and the list entries look like they come from the headings of the columns on the form, NOT from the data item names that are bound to the columns. The filter should be [WebSiteCode]='000002'

If I'm right, then this feature will not work until we get a patch from I/S. Does anyone know if this filter is stored somewhere where it can be manually edited so that it can be made to work without using the GUI.

Thanks.

Web Option tab problems in Inventory

Jim Wolf — Thu, 14 May 2009 10:26:09 GMT

I have a system that has the built-in default webstore WEB-000001, which is not
used, and the customer's actual webstore, WEB-000002. The actual
webstore, WEB-000002, is designated as the default webstore. However,
when they click on the Web Option tab in Inventory maintenance, the
program always selects WEB-000001 automatically. Before they can make
the changes to the web options for an item, they always have to click
on "WEB-000002." Is there an option or setting somewhere to make the
Inventory program select WEB-000002 automatically?