1. Home
  2. Point-Of-Sale Software
  3. Inventory Wizard Univeral Changes

Inventory Wizard Univeral Changes

At one point I had found a way to change the reorder point of ALL items in my data base to the same specific number (for a specific reason this was "-100"). I have since added new items to the data base and find that I need to repeat the process, but can't seem to figure out how I did it. I think I used the Inventory Wizard, and selected the 160 option and then did something to change all items. When I look at it now there doesn't appear to be a way to do it. What am I missing? Help text only explains the price change part of the wizard.

FYI- What I'm trying to accomplish here is to be able to generate a report which shows "-100" in some column that I don't otherwise need (this has to do with uploading my inventory to an online shopping cart). Since I don't use any PO components, the column could be either restock lvl or reorder pt.. It would also be simpler if I the "-100" would be automatically applied to each new inventory item, if that's possible somehow.

Thanks.

Reply to
PRJ
Loading thread data ...

Just run the Inventory Wizard, Task 160, all items. Enter 100 in one of the items new reorder point. Right click and copy, then right click - paste to all rows. Commit.

Reply to
Jeff Faul

Thanks. I was able to "paste to all rows" and it worked fine.

Reply to
PRJ

If you want the Reorder Point field updated to -100 every time you add a new item then you can add a trigger.

  1. Open the Store Operations Administrator
  2. Connect to your database
  3. Open a new query
  4. Copy and paste the following lines of code into the query window and run the query.

COPY BELOW HERE

/****** Object: Trigger dbo.tr_ItemUpdateReorderPoint Script Date:

06/05/07 9:45:00 PM ******/

CREATE TRIGGER tr_ItemUpdateReorderPoint ON Item AFTER INSERT AS

Update Item SET Item.ReorderPoint = '-100' FROM inserted WHERE Item.ID = inserted.ID

COPY ABOVE HERE

  1. If you wish to remove the trigger run the following code in the query window

DROP Trigger dbo.tr_ItemUpdateReorderPoint

NB: Always test any queries on a test database first before applying to a live database

Regards Michael (Brisbane, Australia)

Reply to
Michael

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.