Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem occurred when I tried to add new warehouse to the system
11-06-2013, 04:51 AM (This post was last modified: 11-06-2013 04:57 AM by sunzhoujian.)
Post: #1
Problem occurred when I tried to add new warehouse to the system
成功 报告 : 新建仓库成功
数据库错误 1364 : 为所有已存在物料插入新仓库记录时发生错误, 因为
Field 'bin' doesn't have a default value
数据库SQL败 : 用作插入新仓库记录的 SQL 是
INSERT INTO locstock ( loccode, stockid, quantity, reorderlevel) SELECT 'YL', stockmaster.stockid, 0, 0 FROM stockmaster

The Version is the latest version 4.11.1
Find all posts by this user
Quote this message in a reply
11-06-2013, 10:53 AM
Post: #2
RE: Problem occurred when I tried to add new warehouse to the system
hi,
It's been solved in the SVN.

Please refer to this post for details: http://www.minghao.hk/bbs/read.php?tid=2522

Thanks best regards!

Exson
Find all posts by this user
Quote this message in a reply
11-07-2013, 05:37 PM
Post: #3
RE: Problem occurred when I tried to add new warehouse to the system
Well I was a bit sceptical too at first, but actually for those businesses that can keep the same stock always in the same location as many smaller businesses can, it is useful. The packing slip now shows where the stock is for picking.

Probably makes sense to default it to an empty string as you say.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
11-07-2013, 06:15 PM
Post: #4
RE: Problem occurred when I tried to add new warehouse to the system
hi, Tim and Phil,

Thank you for your comments. I've revised them to NOT NULL default '';

Best regards!

Exson
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)