If you get a runtime 13 while trying to access the sales order file or customer file after turning on the buyout feature run the following sql:

 

ALTER TABLE "sales_order_detail"(

  DROP COLUMN "po_type",

  DROP COLUMN "sequence_no",

  DROP COLUMN "operation",

  DROP COLUMN "proj_comp_date"

);

ALTER TABLE "sales_order_detail"(

  ADD COLUMN "po_type" CHAR(1),

  ADD COLUMN "sequence_no" NUMERIC(4,0),

  ADD COLUMN "operation" CHAR(10),

  ADD COLUMN "proj_comp_date" CHAR(8)

);

 

 

If you get a runtime 13 while trying to access the customer file run the following sql statement:

 

ALTER TABLE "customer"(

DROP COLUMN "intercompany"

);

ALTER TABLE "customer"(

ADD COLUMN "intercompany" CHAR(1)

);

 

If you get a runtime 13 while trying to access the inventory inquiry run the following sql statement:

 

ALTER TABLE "inventory_qty_detail"(

DROP COLUMN "attached_file",

DROP COLUMN "tag_notes"

);

ALTER TABLE "inventory_qty_detail"(

ADD COLUMN "attached_file" CHAR(260),

ADD COLUMN "tag_notes" CHAR(200)

);

 

Proc PO file, run the following sql statement:

 

ALTER TABLE "proc_po_child_tags"(

MODIFY COLUMN "location" CHAR(15)

);

 

On incats file run the following:

 

ALTER TABLE "inventory_categories"(

DROP COLUMN "int_create_pos"

);

ALTER TABLE "inventory_categories"(

ADD COLUMN "int_create_pos" CHAR(1)

);

 

 

On vendor file:

 

ALTER TABLE "vendors"(

DROP COLUMN "intercompany"

);

ALTER TABLE "vendors"(

ADD COLUMN "intercompany" CHAR(1)

);

 

On inventory items file a runtime 13 on VAT table do the following:

 

These should do it:

ALTER TABLE "inventory_items"(

DROP COLUMN "default_vendor",

DROP COLUMN "min_yield",

DROP COLUMN "thread_range",

DROP COLUMN "lead_time",

MODIFY COLUMN "processing_id" CHAR(5),

MODIFY COLUMN "default_thickness" NUMERIC(7,5),

MODIFY COLUMN "grade" CHAR(5)

);

ALTER TABLE "inventory_items"(

MODIFY COLUMN "processing_id" CHAR(10),

MODIFY COLUMN "default_thickness" NUMERIC(8,5),

MODIFY COLUMN "grade" CHAR(20),

ADD COLUMN "default_vendor" CHAR(10),

ADD COLUMN "min_yield" CHAR(5),

ADD COLUMN "thread_range" CHAR(25),

ADD COLUMN "lead_time" NUMERIC(5,2)

);

 

 If you get a runtime 13 while trying to launch the Purchase History Inquiry from the Inquiries button on the Inventory Inquiry Screen.


ALTER TABLE "inventory_history"(

MODIFY COLUMN "process_id" NUMERIC(2,0)

);

ALTER TABLE "inventory_history"(

MODIFY COLUMN "process_id" NUMERIC(4,0)

);