Has anyone written a Sequel Query to add parts to bills of material

I want to add an extra material to several bills of material. In particular, I need to add another material to all bills of material which contain a certain material.

So if the requirement includes part_ID '046520' then insert part_ID '000580' where the work order type is a master or a workorder

Does anyone have a Sequel Query which will do the job or that I can modify to do the job?

Thanks

Find more posts tagged with

VISUAL - Enterprise General Discussions

Accepted answers

All comments

cgibson

There are examples of code on the visual users google group that should help you accomplish this task.

groups.google.com/.../vmiug-tec

The best way to do this would be to use Visual API's to ensure the business logic is maintained, but I haven't tried that approach yet.

unknown

Unfortunately I'm not a member of vmiug-tec and I am unable to contact anyone to request permission to join.

chorvath

This is a pretty straightforward insert query - see one I performed below. This query adds a requirement item to engineering masters where part 9007TB001 already exists. Note the PIECE_NO+3 formula which gives the requirement a new, unused piece number.

insert into requirement ([WORKORDER_TYPE]
,[WORKORDER_BASE_ID]
,[WORKORDER_LOT_ID]
,[WORKORDER_SPLIT_ID]
,[WORKORDER_SUB_ID]
,[OPERATION_SEQ_NO]
,[PIECE_NO]
,[SUBORD_WO_SUB_ID]
,[PART_ID]
,[REFERENCE]
,[STATUS]
,[QTY_PER]
,[QTY_PER_TYPE]
,[FIXED_QTY]
,[SCRAP_PERCENT]
,[DIMENSIONS]
,[DIM_EXPRESSION]
,[USAGE_UM]
,[EFFECTIVE_DATE]
,[DISCONTINUE_DATE]
,[CALC_QTY]
,[ISSUED_QTY]
,[REQUIRED_DATE]
,[CLOSE_DATE]
,[UNIT_MATERIAL_COST]
,[UNIT_LABOR_COST]
,[UNIT_BURDEN_COST]
,[UNIT_SERVICE_COST]
,[BURDEN_PERCENT]
,[BURDEN_PER_UNIT]
,[FIXED_COST]
,[DRAWING_ID]
,[DRAWING_REV_NO]
,[VENDOR_ID]
,[VENDOR_PART_ID]
,[EST_MATERIAL_COST]
,[EST_LABOR_COST]
,[EST_BURDEN_COST]
,[EST_SERVICE_COST]
,[REM_MATERIAL_COST]
,[REM_LABOR_COST]
,[REM_BURDEN_COST]
,[REM_SERVICE_COST]
,[ACT_MATERIAL_COST]
,[ACT_LABOR_COST]
,[ACT_BURDEN_COST]
,[ACT_SERVICE_COST]
,[MFG_NAME]
,[MFG_PART_ID]
,[PROTECT_COST]
,[LENGTH]
,[WIDTH]
,[HEIGHT]
,[DRAWING_FILE]
,[WAREHOUSE_ID]
,[ALLOCATED_QTY]
,[FULFILLED_QTY]
,[PLANNING_LEADTIME]
,[REQUIRED_FOR_SETUP]
,[USER_1]
,[USER_2]
,[USER_3]
,[USER_4]
,[USER_5]
,[USER_6]
,[USER_7]
,[USER_8]
,[USER_9]
,[USER_10]
,[UDF_LAYOUT_ID]
,[calc_fixed_scrap]
,[WBS_CODE]
,[WBS_DESCRIPTION]
,[WBS_CLIN]
,[WBS_CUSTOMER_WBS]
,[WBS_CDRL]
,[WBS_TDC]
,[INHERIT_WAREHOUSE]
,[LOCATION_ID]
,[DUE_DATE]
,[DISPATCHED]
,[ORIG_STAGE_REVISION_ID]
,[STATUS_EFF_DATE]
,[ALT_PART_PARENT_PIECE_NO]
,[BID_RATE_CATEGORY_ID]
,[SITE_ID])

Select WORKORDER_TYPE, WORKORDER_BASE_ID, WORKORDER_LOT_ID, WORKORDER_SPLIT_ID, WORKORDER_SUB_ID, operation_Seq_No, piece_no+3, subord_WO_sub_ID, '9007DINS-SS', reference, status, ((QTY_PER*1.5)+0.25), QTY_PER_TYPE, Fixed_Qty, SCRAP_PERCENT, dimensions, dim_expression, 'EA', EFFECTIVE_DATE, discontinue_date, ((QTY_PER*1.5)+0.25), 0.00000000, REQUIRED_DATE, close_Date, 0.0602666, UNIT_LABOR_COST, UNIT_BURDEN_COST, UNIT_SERVICE_COST, BURDEN_PERCENT, BURDEN_PER_UNIT, FIXED_COST, drawing_Id, DRAWING_REV_NO, NULL, NULL, (((QTY_PER*1.5)+0.25)*0.0602666), EST_LABOR_COST, EST_BURDEN_COST, EST_SERVICE_COST, (((QTY_PER*1.5)+0.25)*0.0602666), REM_LABOR_COST, REM_BURDEN_COST, REM_SERVICE_COST, ACT_MATERIAL_COST, ACT_LABOR_COST, ACT_BURDEN_COST, ACT_SERVICE_COST, null, null, 'N', Null, null, null, null, null, ALLOCATED_QTY, FULFILLED_QTY, PLANNING_LEADTIME, REQUIRED_FOR_SETUP, user_1, user_2, user_3, user_4, user_5, user_6, user_7, user_8, user_9, user_10, UDF_LAYOUT_ID, calc_fixed_scrap, WBS_CODE, WBS_DESCRIPTION, WBS_CLIN, WBS_CUSTOMER_WBS, WBS_CDRL, WBS_TDC, 'N', LOCATION_ID, due_Date, dispatched, ORIG_STAGE_REVISION_ID, STATUS_EFF_DATE, ALT_PART_PARENT_PIECE_NO, BID_RATE_CATEGORY_ID, SITE_ID from requirement where part_id='9007TB001' and workorder_type='M'

Infor Landmark Technology_11.0.X_Overview_08142020.pdf

unknown

That worked well thank you

Copyright © 2025 Infor. All rights reserved.