Is there a way to create an item / warehouse relationship prior to initiating a transaction?

SOLVED

Looking for some functionality that would be similar to Sage 500 Maintain Inventory, if you are familiar with that process.

Thanks for any assistance!

Parents
  • 0

    Not sure about the Sage 500 part, but there is a "Default Whse" setting in Item Maintenance.  It's only available if Require Multiple Warehouses is selected in setup.

  • 0 in reply to T-Storm

    The default WH doesn't solve our issue.  We are pushing SO's from website into a Sage 100 implementation with multiple warehouses, using Business Objects.  The customer can select a shipping warehouse when entering the order on the website.  It is therefore possible that the specific item/warehouse combination has not been created (all warehouses are authorized to have all items, but not all have yet been stocked with every item).  When that occurs, the order import fails on BOI validation - item does not exist in the warehouse.   We have to create the relationship before the order can be imported.  In 500, the item/warehouse combination can be set up as soon as the item is created, without any inventory transaction required.  Was wondering if anyone had created a similar function or a great work-around for Sage 100.

    Thanks.

  • 0 in reply to BBROWN

    Are you talking about adding the rows to IM_ItemWarehouse?  You might be able to do that on the Reorder screen (in IM) by selecting a Reorder Method, or by importing directly into the table using Visual Integrator.

  • 0 in reply to Kevin M
    verified answer

    For inventory there are two files of note. First is the CI_Item which is basically the Item Masterfile. The second is the Item_ItemWarehouseDetail. In this file a record is not created until there is a transaction involving the item and warehouse.  In your case a work around might be to import a record into the Warehouse Detail file, don't include any quantity. This would pass the BOI test although you would have to stock the warehouse before being about to ship/invoice out of it.

  • 0 in reply to BigLouie

    That was what I was hoping for - we have already covered the angle of the item transfer prior to shipment.  We determined (as a work around) that the relationship could be established by creating a PO line, then cancelling the PO - but that is a real pain.  Thanks - will check out coding some logic to insert these records via BOI.

  • 0 in reply to BBROWN

    Yes, with BOI you could code it so that if the record does not exist, create one.  Creating a record with no inventory in the Item Warehouse file is no big deal. Does not hurt or intefer with anything.

Reply Children
No Data