34 Support questions or comments

• 
  Jun 19, 2023
  penn Purchased

  I got problem when import sql file of AWMS , It show error like this
  
  query SQL:
  
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phys_inv_details`
  --
  
  CREATE TABLE `phys_inv_details` (
  `id` int(11) NOT NULL,
  `invId` int(11) NOT NULL,
  `warehouseId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `stock` float NOT NULL,
  `stock_date` datetime NOT NULL DEFAULT current_timestamp(),
  `invCount` float NOT NULL,
  `invDate` date NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
  MySQL show: เอกสารประกอบ
  
  #1067 - Invalid default value for 'invDate'
  
  How to fix it. Anyone can help this
  Thanks
• 
  Jun 19, 2023
  monsernet Author

  Hello;
  In the table "phys_inv_details" change the type of the column "invDate" from Date to DateTime. And everything will be fine
• 
  Jun 19, 2023
  penn Purchased

  Thank you for your prompt response
  After amend the the type of the column "invDate" from Date to DateTime according to your advice I do import sql again but it show an error in "backup" table as follow
  
  --
  -- Indexes for table `backup`
  --
  ALTER TABLE `backup`
  ADD PRIMARY KEY (`backup_id`),
  ADD UNIQUE KEY `backup_name_UNIQUE` (`backup_name`)
  MySQL show: เอกสารประกอบ
  
  #1071 - Specified key was too long; max key length is 767 bytes
  
  Please suggest.
  Thanks
• 
  Jun 19, 2023
  monsernet Author

  You have to remove the INDEX key ( the grey key appearing just after the column name) from the "backup_name" column.:
  - Select the column "backup_name"
  - Go down , you will find a tab named "Indexes"
  - Just keep the primary key (first one) and remove the other indexes by clicking on "Drop" link
  This is a screenshot : https://imgur.com/a/qPRG6zE

• 
  May 17, 2023
  dkobe123

  Hello there, I have several questions regarding the AWMS.
  1. Is the software able to auto generate its picking location based on FIFO?
  2. What kind of report can it generate?
  Eg. Weekly ,Monthly stock movement
  3. The email settings is to notify users of what kind of activity?
  Eg. New receiving, stock volume, daily stock movement
  4.Can the warehouse layout show what kind of product is being placed?
  5.Can the software auto allocate and suggest which location/rack to place or retrieve the stock?
  6. Does admin can assign user with different custom roles?
• 
  May 19, 2023
  monsernet Author

  Hello:
  1- Because the use has the choice to select the appropriate shelf, the FIFO technique can not be admitted automatically by the system, so the picking technique will be done also by select from the user (warehouse agent).
  2- Reports : current stock(stock alert, out of stock) report, product movements report, inventory control, ..
  3- The inventory control report can generate monthly report, 3-months report, 6-months report and annual report. Other reports generate only current status.
  4- No, it shows only the total volume, the occupied volume and the percentage of occupancy.
  5- Yes. When retreiving stock or even adding new stock, the system suggest the shelves that have the enough volume to fit the volume to add and then the user select the shelves from the selected ones. Even when picking the items the system provide the total volume of the order and decrease the volume on each picking done.
  6- No, multi-user management is not available in the current script.
• 
  May 20, 2023
  dkobe123

  How about user role access?
  Is the software to assign user as (e.g picker, warehouse manager , checker)?
• 
  May 20, 2023
  monsernet Author

  Good day;
  User Management is not maintained in the script.

• 
  May 17, 2023
  dkobe123

  Hello there, I have several questions regarding the AWMS.
  1. Is the software able to auto generate its picking location based on FIFO?
  2. What kind of report can it generate?
  Eg. Weekly ,Monthly stock movement
  3. The email settings is to notify users of what kind of activity?
  Eg. New receiving, stock volume, daily stock movement
  4.Can the warehouse layout show what kind of product is being placed?
  5.Can the software auto allocate and suggest which location/rack to place or retrieve the stock?

• 
  Apr 12, 2023
  adiyang Purchased

  Hello, i already buy this product. But in login screen still show version 2.2 and did not have google captcha
  Could you please explain for this?
  Thank you
• 
  Apr 12, 2023
  monsernet Author

  Hello,
  Thank you for purchasing the item.
  The version is 2.3. and for the first use there is no google captcha displayed because you should generate google captcha keys first.
  I will explain to you how to add google captcha keys to be displayed in login page :
  - Click to the menu "General Settings"
  - Click on "application Settings" tab
  - Check the checkbox "Use google captcha in Log In page".
  - Enter your google captcha keys ( secret key and site key). If you don't know how to generate google captcha keys , you will find in the same page a link named " How to create Google Recaptcha V2 Keys" which will guide you.
  - Save and then logout. You will see the Google Captcha in the Log In page .
  This is a screenshot to clear things for you https://ibb.co/PNhmGCW .
  
  
• 
  Apr 14, 2023
  adiyang Purchased

  Hello Ali,
  
  Could you please check on my hosting server, because i already upload all the file to server but there is error in few menu. Thank you
• 
  Apr 14, 2023
  monsernet Author

  Hello,
  Sure, come on private message.

• 
  Apr 3, 2023
  alikwotdav

  where is the login information for the demo version????????????
  there is no even registration form
• 
  Apr 3, 2023
  monsernet Author

  
  The login information for the demo are already listed in the "Demo" section after "Features" section.

• 
  Mar 29, 2023
  451561266

  Hello, I would like to know what other devices or services would be necessary for the system to function properly and effectively after installing it.
• 
  Mar 29, 2023
  monsernet Author

  Good day;
  To work properly, you just need a server (local server or online server) .
  You download the script and follow the instructions mentioned in the installation section of the documentation file.
• 
  Mar 29, 2023
  451561266

  Thank you for your reply. I would like to ask another question: Does the barcode scanning mentioned in the system not require hardware equipment? Also, I have been trying to log in to the backend through the demo, but it keeps saying that the image verification code is incorrect, which prevents me from logging in successfully. Thank you.
• 
  Mar 29, 2023
  monsernet Author

  Good day;
  - Of course a barcode reader device is required for barcode scanning. But, you may still use the script even if you don't have a barcode scanner. To do so, just choose the product name from the list provided rather than scanning the barcode.
  - For security purposes, when logging in, you have to enter the letters/numbers shown in the picture provided in the LOGIN page.
  
  Thank you

• 
  Mar 11, 2023
  aomar09

  Hi,
  
  I wanted to understand few things.
  
  1. Is the barcodes tracked with the package? And what tool do I need to track the product with?
  2. Is the product tracked with the rack/aisle associated with it?
  3. Can I edit the logo and font/color of the website/app?
  4. Is the package tracked with the delivery driver as well as delivery point for package destination?
  
  Thank you I hope to hear from you soon.
• View 6 more replies
• 
  Mar 11, 2023
  monsernet Author

  Hello Omar,
  
  1- In the script , the package is not tracked by barcode, The package tracking is a logistic operation and the script concerns only the warehouse operations.
  
  2- Yes, the product and its volume are tracked by location ( line number, rack number , shelf number). You can display the location of each product (menu "Inventory Control >> Storage locations).
  
  3- You can change the logo, the favicon, the application short name , the application long name as well as the company name and details, the currency, the timezone, the Date format, the number of decimal digits, the barcode settings, the QR code settings). You can also edit the warehouse information (length, width, height, storage zone, free zone, rack height, rack length, rack width, and many more settings. The font type/size and the colors are not customized in the script.
  
  4- As I told you earlier, the script is for warehouse management and when we talk about delivery tracking by driver and/or delivery point we are talking about logistic operations .
  
  I hope I have answered your questions well.
• 
  Mar 15, 2023
  aomar09

  Thank you
  
  Please submit video of step process of extracting file to http, database & config as some of the documentations have broken images links
• 
  Mar 16, 2023
  monsernet Author

  Ok. I will do my best to provide a demonstration video on how to install the script at the soonest possible.
• 
  Mar 16, 2023
  aomar09

  Thanks appreciate it,
  
  Also, how does the rack full/empty work? Is it through scanned barcode, amount of weight or simply putting in or removing from the area or is it done manually? I need to know the level of sophistication as well as the alerts of low stock will it automatically remind me, how will it know if it's in low stock, what does the bar codes represent in terms of tracking
  
  Thank you
• 
  Mar 16, 2023
  monsernet Author

  - First point : the rack is managed automatically when adding or remove stock. When adding new stock, the warehouse agent is required to enter the rack number and the system automatically check the availability of the volume of the chosen rack ( if there is available space in the rack, it will add it otherwise, it will show an alert stating that the rack does not have enough space ). When removing stock (transfer to another warehouse or delivery operation), the volume of the removed quantity will automatically deducted from the rack.
  - Second Point : You can check the current stock from the menu "Stock Control >> Current Stock". The stock status of each item(available, in stock alert, out of stock) are shown there .
  You can also display the items on stock alert as well as the items out of stock independently via the menu "Products" .
  - Third Point : Barcodes are used on adding stock to warehouse ( here you have 2 options either scanning the barcode of the item and all its information will be displayed OR manually selecting the item from the list and also all its details will be displayed then you have just to add the quantity you want to add ). The barcode is also used when creating new orders to be picked up from the racks.
  
  Thank you
• 
  Mar 17, 2023
  aomar07 Purchased

  Thank you for the detailed reply and quick response I appericate this very much.
  
  I just have a few more questions if you have an email or PM me if possible.
  
  1. When the barcode is printed can I use a normal scanner and will this locate the aisle/rack of the product via warehouse layout? I still don't understand this as once an item is scanned what information goes back to AWMS? Do I need to print barcodes assosictaed with the product/aisle/rack to locate this?
  
  2. In "Deliveries" the button which is pack/load/picked, will a warehouse agent need to manually input this data to confirm or can this be done automatically via barcodes?
  
  Thank you I believe I have as much information as I need. Thank you again would be nice to Have your whatsapp/email to understand this system further.
  
  Kind regards
• 
  Mar 18, 2023
  monsernet Author

  1- I did not understand what do you mean by "normal scanner". Anyway, you have to use a Barcode Scanner device to scan the product barcode. When you scan a barcode, it will not locate one position simply because the product can be located in different locations ( different racks ) . When adding stock, the system will ask you to which rack location(s) you want to add the quantities ( big quantity will added to different racks that is why system gives you the available racks and ask you to choose from them and to choose also the quantity in each rack. -- Please try to test adding different stocks , you will understand how it works. It is very simple ---
  
  2- The pick/pack/delivery operations are successive. It means after creating an order and get approved, this order should be picked ( the system does not know that you want to pick the order until you tell it. After picking up the items, the pack operation will be done automatically by the system according to the product dimensions and the number of items by box/ pallet which are already exist in database.
• 
  Mar 23, 2023
  aomar09

  Thanks much appreciated system looks good, just one final question in terms of database record via scanning how does information gets captured once scanned, does it only shoe display? Or is there a database that records all information
  
  I might need to look into 3rd party software that captures information rather than display this is vital to warehouse ecosystem
  
  Thanks
  
  Thanks
• 
  Mar 23, 2023
  monsernet Author

  Your question is a bit ambiguous but I will try to answer you and I hope my answer corresponds to what you are looking for.
  - When you want to add new stock: you scan the product barcode, the product information is retrieved from the database and displayed, then you add the quantity, the system will automatically calculate the volume needed for storage and automatically display the available racks (racks that can support the calculated volume). You just need to enter the volume you want to add to each rack. When adding the volumes, the system will automatically calculate and deduct the entered volume,
  - When you want to retrieve an order, 1st step: you select the products you want to add to the order. 2nd step: during the validation of the order, the volumes of the recovered products will be deducted from the storage locations (racks). To do this, you will manually select the racks (because, as I told you above, the same product can be found in different racks and the system does not know exactly which rack it will take the volume from.
  

• 
  Feb 9, 2023
  fadim

  Hello are you oen for customisations?
  
• 
  Feb 9, 2023
  monsernet Author

  Hello Fadi;
  Thank you for your interest.
  Sure, ready for any customization.
  
  

• 
  Jan 6, 2023
  rabiehana Purchased

  when i try to install script i got error msg when i import DB
  
  https://serving.photos.photobox.com/20806596f6fe083eb934e41ca9e3673811305ad88777e93df281755f69f6d15659b0542e.jpg
• View 10 more replies
• 
  Jan 7, 2023
  rabiehana Purchased

  any one support me
• 
  Jan 7, 2023
  monsernet Author

  Good evening Rabiehana;
  The error is happening because of SQL_MODES parameters in your phpmyadmin.
  I will give you 3 methods to resolve the problem. Choose one of them :
• 
  Jan 7, 2023
  monsernet Author

  1- First method:
  Before importing the file to phpmyadmin, remove NOT NULL DEFAULT current_timestamp from the "creation_date' in the table and change it to NULL. And import the file to phpmyadmin.
  Do not forget after importing the file and getting all tables , go back to table "physical_inventories' and change the default value directly from designer by unchecking the checkbox NULL and putting the DEFAULT to CURRENT_TIMESTAMP.
• 
  Jan 7, 2023
  monsernet Author

  2- Second Method :
  The error is happening because of SQL_MODES parameters in your phpmyadmin.
  To resolve it :
  1- In PhpMyAdmin, select your server : Normally it is 127.0.0.1 if you are working locally.
  2- Go to "SQL" tab and execute the following query :
  show variables like 'sql_mode' ;
  3- And remove the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" to make it work. This is the default sql_mode in mysql new versions.
• 
  Jan 7, 2023
  monsernet Author

  3- Third Method :
  If you are using XAMPP , you can simply :
  1- open the my.ini from your xampp control panel
  2- search for "mode" and you will get the line : sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
  3- Remove the text : NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
  4- Save the file and restart your MYSQL from the xampp control panel
• 
  Jan 7, 2023
  monsernet Author

  By the way, I am preparing new update for the script including the QR Code and item images and the correction of some bugs. The update will be uploaded soon.
• 
  Jan 8, 2023
  rabiehana Purchased

  still i have error after i change user and password on setting page
  
  https://serving.photos.photobox.com/952046890dc4688d6a7ec5004237b38a34bfc341c81712086ed1e6a7b15dd7d45e2b6221.jpg
• 
  Jan 8, 2023
  monsernet Author

  The 404 page is launched when the URL address is not correct. Can you tell me the steps you made until getting this 404 error page because I checked and no 404 page error coming after changing the user details ( email and password )
• 
  Jan 8, 2023
  rabiehana Purchased

  on localhost xampp its working normally but on online hosting not working i try 2 deferent host same error
• 
  Jan 8, 2023
  rabiehana Purchased

  if you can access remotely to check and fix it please
• 
  Jan 8, 2023
  rabiehana Purchased

  and if you can send to you whatsapp number
  
• 
  Jan 8, 2023
  monsernet Author

  Good day, please send me private message and I give you my number.
• 
  Jan 8, 2023
  rabiehana Purchased

  check your msg chat

• 
  Jan 3, 2023
  rabiehana Purchased

  can add photo for item's and category etc......
  can add logo of company when i print report or delivery report
• View 1 more reply
• 
  Jan 3, 2023
  rabiehana Purchased

  and also is there QR code for item's
• 
  Jan 3, 2023
  monsernet Author

  In the current script, adding a logo for the company is not available but you can add its code easily, you add upload field in the page General settings >> company information.
  For items, generating a barcode is available but QR code is not.
• 
  Jan 3, 2023
  rabiehana Purchased

  There is any plans on future to update this function's and add more features
• 
  Jan 3, 2023
  monsernet Author

  Yes. I will add the features of QR Code and item images soon. As will as the company logo.