Error inserting database for migrating location
Brought to you by:
jekkos,
pappastech
I have a problem while inserting the database for migrating inventory location in this version.
Thanks for the help anyway ^^
Here is the error log from the SQL:
SQL query: Documentation
INSERT INTO ospos_stock_locations( location_name ) (
SELECT location
FROM ospos_items
WHERE NOT
EXISTS (
SELECT location
FROM ospos_stock_locations
WHERE location_name = location
)
);
MySQL said: Documentation
it seems that the location column is not present in your database. I assume that you created the tables from scratch as it will only be present in case you migrate from 2.2.2 to 2.3.
Hi Jekkos
I used the database from 2.3 (database.sql) and I just assumed that if I want to use location migration I should install 2.3_migrate_location.sql
Is it correct?
Or I did wrong step ?
Thank Jekkos
No this is not the case, maybe I should of put that more clearly in the filename. The script is only useful if you were using location fields on the item before to denote the stock location. In case you're doing a fresh install, it's not needed.
Hi jekkos
Thank you for your reply...
Just another question about the stock here.
If I want to use separate location example warehouse and store.
Is there any possibility to can move the stock from one location to another with this version?
Thank you so much
yes there is an additional mode added in the receivings called requisitions. . here you can move quantities of a selected item from one stock to another.
Thank you so much jekkos.....
Hi jekkos...
Sorry to bother you again with another question.
In receiving page there are only two option : receive and return
There is no requisitions like you mentioned above.
Here is the screenshoot of mine :
ok you haven't configured an extra stock location yet. Mabye this isn't very clear from the docs, but in the config secion you need to add the names of your stock locations comma separated.
Once there are multiple locations the requisition option will appear in the receivings page.
Owh...I get it jekkos.
Thank you very much.