Search options

Almost a year later I did come back to this.
I did a mysqldump and copied that file for safekeeping.
Set up a brand new installation, then after setting up the first company did DROP DATABASE.
I set up my admin user with the same name and password as on the original company, and the first company's name was also the same, I am not sure if that is important.
Created a new database and did mysql newdatabase < old_database_backup.sql
Seems to have worked but I am having the session login issue that others seem to have with 2.4.11

@rafat I will have a look at these values. Restoring the database from the prompt didn’t work. It takes a long time to return to the prompt but when I select * from 1_user I don’t see any of my logins there.

@kvvaradha I think you’re right except:
I’m being super cautious so I want to do the upgrade away from my production server first and I used MySQL 8 on the newer server because I thought MySQL 8 which allows multiple values on bind_address would be neat for security. I am almost certain that the production server is MySQL 5.7

I think that my initial error was using my company 0 to enter actual data. Any new installations I will reserve company 0 as setup or admin and immediately create another company for actual data entry.

Good morning gentlemen,
Isn't this possible that we can have multiple UOM's for items and a conversion factor between them. it would solve my issue and pricing levels at each UOM. I think a lot of users would find this useful from posts that I see relating to this?
In my own needs: UOM each and UOM case, conversion factor 24 each 1 case. price each $1, price case $20
In the case of bulk units:
1 bag sugar 55kg sugar 55000g. So a user could purchase a bag and sell grammes and the system automatically know that grammes are fractions of 1 bag?
Price 1 bag $550 Price kg $12.00 Price gramme $0.02
I had a return the other day of 12 bottles, half of a case which I had sold at case price as part of a full case but to credit at eaches would have refunded too much to the customer. So i had to return .5 of a case, which I could not disassemble I had to inventory adjust to remove half case and another adjust to add 12 bottles, and the values were slightly different.
Regards,
Kurt

I'm using the advanced manufacturing option to try to make a product where we had to adjust our manufacturing process due to an item shortage. Where I would normally use 60 screws to build a case I had to use adhesive (which I won't add as input, amount used is small and cost insignificant) and only used screws where they were structurally necessary, using only 20 screws. So I want to issue 20 screws to make 1 case which I did but when I process it says screws will go into negative. Have I done wrong or missed a step?
I don't want to make a new BOM or change the original to create this product because this will hopefully not happen again.

So I can do exactly what I propose already?
Which is put in x units + y units to obtain z units ?
If this is the case thanks and thanks for the quick response.