blueseerERP / blueseer

A Free ERP and EDI solution for the manufacturing community
MIT License
113 stars 41 forks source link

site dropdown not set in OrderBrowse menu #146

Open vaughnte opened 2 weeks ago

vaughnte commented 2 weeks ago

In the Order Browse menu, the site drop down list does not have a value. Several other menus, including the PO browse, is missing site assignment in the drop down menus.

vaughnte commented 2 weeks ago

This only impacts mysql backend versions of BlueSeer. This is a bug in version 7.0...up to patch level 22. The site security was updated in version 7 to accomodate 'allowed sites' per user. The default value is the asterick character...which implies all sites. However, the initial installation of the user mstr records had a crlf as the line terminator instead of just a linefeed. This caused the mysql record creation to create the allowedsite values of asterick/carriage-return as it expected only linefeed as the terminator during import. This has been patched with version 7.0.23. If you already have an installation of 7.0.22 or lower, you will need to update the sql record manually. The work around is to enter the user maintenance record and assign an actual value to 'allowed sites'. Enter '1000' or '*' in this field. This should set the field without the carriage-return on the end.