[lvi56]

I've been trying to delete old items from inventory. I have run into a problem with multiple items being backordered. How can I un-backorder the items? Nothing i found in other posts here has helped.

[lvi56]

Solution.

Went into dbuwin and modified the stock.dbf and bin.dbf tables. Also worked on changeing commited items. I backed up the entire database first of course.

[Andre]

What did you change in the files ?

I am having the same problem

[lvi56]

Andre, on Jan 31 2009, 09:53 AM, said:

What did you change in the files ?

I am having the same problem

Change the backorder column. You'll have to scroll through and find the items, then you'll see in the backordered column a number, change that to zero.
Backup the entire database before doing anything.

[planetdj]

lvi56, on Feb 3 2009, 01:19 PM, said:

Change the backorder column. You'll have to scroll through and find the items, then you'll see in the backordered column a number, change that to zero.
Backup the entire database before doing anything.

OUCH! That makes the item not BO in the STOCK database, but doesn't take into account the database that has those items on BO on specific orders. No offense, but I can clearly tell that you should NOT be using DBUWIN! You should have gone into MOM, list status of pending orders that are BO (narrowing it down to one specific sku if you want) and then open those orders and removing the item with BO status. What you have done will surely create the crashing of the MOM program during daily use whenever it encounters database corruption (which is what it is at this point.)

[lvi56]

planetdj, on Feb 7 2009, 11:45 AM, said:

OUCH! That makes the item not BO in the STOCK database, but doesn't take into account the database that has those items on BO on specific orders. No offense, but I can clearly tell that you should NOT be using DBUWIN! You should have gone into MOM, list status of pending orders that are BO (narrowing it down to one specific sku if you want) and then open those orders and removing the item with BO status. What you have done will surely create the crashing of the MOM program during daily use whenever it encounters database corruption (which is what it is at this point.)

It hasn't been a problem yet. Though I can see now how it could be, thanks for pointing it out. What we were doing was wiping everything from our database by deleting items and orders, to start from scratch. There were so many problems before, and many times having database corruption. Now everything is stable and we can do the list pending orders way of doing it.