Inventory project

[tiphanie]

Hi,

I am using Sugar CE 5.5.0 and I am looking for a module that can help me with inventories or rental equipment.

The "Inventory Items Module" does not work - the downloading proscess ends at 85%...

Thank you for your help.

[AlexAv]

Do you mean SugarCRM Module Loader?

[tiphanie]

Yes. I am looking for a module to load for inventory or rental equipment.

[AlexAv]

Near progress bar you had saw something like "Show Log".
Can you say what did you see in the Log?

[tiphanie]

Find below the text when I click DISPLAY LOG :

Installing Subpanel Layouts
Rebuilding Layoutdefs...
Installing Relationships
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding administration Section...
Installing Language Packs
Rebuilding Language...en_us
Installing Bean : Inventory_items
Error creating table: inventory_items: Query Failed:CREATE TABLE inventory_items (id char(36) NOT NULL ,date_entered bool DEFAULT 0 NOT NULL ,date_modified datetime NOT NULL ,modified_user_id varchar(36) NOT NULL ,assigned_user_id varchar(36) NULL ,created_by varchar(36) NULL ,deleted bool DEFAULT 0 NOT NULL ,inventory_number char(255) NOT NULL ,account_name char(255) NOT NULL ,account_id char(36) NOT NULL ,company_name varchar(255) NOT NULL ,storage_type varchar(255) NULL ,artist char(255) NOT NULL ,title char(255) NOT NULL ,circa int NULL ,date_received datetime NOT NULL ,date_left datetime NULL ,medium varchar(255) NOT NULL ,description char(255) NULL ,height double NULL ,width double NULL ,depth double NULL ,packing varchar(255) NULL ,square_footage double NULL ,in_storage varchar(255) NOT NULL ,value char(10) NULL ,insured varchar(255) NOT NULL ,facility varchar(255) NOT NULL ,location char(255) NULL ,photo char(255) DEFAULT 'default.jpg' NULL ,condition varchar(255) DEFAULT 'not inspected' NOT NULL ,condition_description char(255) NULL , PRIMARY KEY (id), KEY inventory_item_artist_index (artist)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition varchar(255) DEFAULT 'not inspected' NOT NULL ,condition_description ' at line 1


Thank you for your help!

[AlexAv]

Something wrong with SQL query.

[agcopley]

Hi,

I am using Sugar CE 5.5.0 and I am looking for a module that can help me with inventories or rental equipment.

The "Inventory Items Module" does not work - the downloading proscess ends at 85%...

Thank you for your help.

Hi,
What you could do is use the OpenSales modules from forge and use the Products module to monitor stock levels. The Quotes module can also be copied, renamed as 'receivables' say, and adjusted or augmented using logic_hooks to alter stock levels on receipt of goods. Just thinking outloud.

Andrew