But in the bin preference says there are 11 in stock. If you try to adjust the amount it goes to a negative in stock. How do I get rid of the quantity that appears in the bin. We dont use the bins at all so I dont know how it got there to begin with
Inventory and bin problems
Started by ACPTEXAS, Sep 29 2004 10:13 AM
3 replies to this topic
#1
ACPTEXAS
-
- Members
-
- 4 posts
Newbie
Posted 29 September 2004 - 10:13 AM
In the stock item information for a product...says we have zero in stock, commited, backoredered so forth
But in the bin preference says there are 11 in stock. If you try to adjust the amount it goes to a negative in stock. How do I get rid of the quantity that appears in the bin. We dont use the bins at all so I dont know how it got there to begin with
But in the bin preference says there are 11 in stock. If you try to adjust the amount it goes to a negative in stock. How do I get rid of the quantity that appears in the bin. We dont use the bins at all so I dont know how it got there to begin with
#2
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 29 September 2004 - 10:20 AM
Hey,
You will need to run the program in your momwin folder called DBUWIN.EXE
You can run it exclusively (with everyone out of MOM) from START / RUN in windows example Z:\momwin\dbuwin.exe or Z:\momwin\dbuwin.exe s ((the "s" stands for shared which will allow you to access the the tables while others are signed in)).
Once in dbuwin, click OPEN and find the BIN.DBF table.
Browse BIN.DBF for the item number in question.
Type the correct units of stock into the UNITS column.
** You are playing with live data. Any changes you make here can not be reversed. Always make sure you have a backup of your MOM folder before you start playing with any of the live data.
Cheers,
David
[email protected]
You will need to run the program in your momwin folder called DBUWIN.EXE
You can run it exclusively (with everyone out of MOM) from START / RUN in windows example Z:\momwin\dbuwin.exe or Z:\momwin\dbuwin.exe s ((the "s" stands for shared which will allow you to access the the tables while others are signed in)).
Once in dbuwin, click OPEN and find the BIN.DBF table.
Browse BIN.DBF for the item number in question.
Type the correct units of stock into the UNITS column.
** You are playing with live data. Any changes you make here can not be reversed. Always make sure you have a backup of your MOM folder before you start playing with any of the live data.
Cheers,
David
[email protected]
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
#3
ACPTEXAS
-
- Members
-
- 4 posts
Newbie
Posted 29 September 2004 - 01:27 PM
Thanks David!!!!
That worked like a charm
Amee'
That worked like a charm
Amee'
#4
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 29 September 2004 - 01:45 PM
Hey,
Terrific! I'm glad I could be of assistance! 6 years of MOM experience under my belt and I'm glad I can put it to good use.
Cheers,
Dave
Terrific! I'm glad I could be of assistance! 6 years of MOM experience under my belt and I'm glad I can put it to good use.
Cheers,
Dave
David Narciso
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
Ecommerce Operations Manager CVS Inc
[email protected]
mobile: 4168238175
DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.
2 user(s) are reading this topic
0 members, 2 guests, 0 anonymous users
