... please wait
Since 2020 I have worked under the hood of Delmiaworks ( formerly IQMS ). In that time I have built a collection of useful queries and code snippets that will only evolve over time.
I am updating them regularly on my Github.
Here is a list of some of the more useful ones:
- bomrevparents_by_itemno.sql - Stored function to recursively find parent components in a BOM based on a child component using the arinvt.itemno
- bomrevparents_by_id.sql - Stored function to recursively find parent components in a BOM based on a child component using the arinvt.id
- aq_cogs_qtr.sql - A function that returns the Cost of Goods and Services by quarter for a given year
- aq_create_backups.sql - A procedure that backs up the specified table. Takes WHERE as an argument.
- aq_trigger_add_supplier.sql - A useful trigger for EDI customers who have several or dynamic ship to locations. This automatically adds the service code for a given customer when a new ship to is added.
- aq_trigger_addnegwo_loc.sql - When a user moves the center schedule position this adds a zero location for the work order.
- aq_trigger_bi_ps_ticket.sql - Automatically add a note to the pick ticket when new pick ticket is added for specified items and customer(s)
- std_future_cost_comparison.sql - Compare the difference of the current standard cost and estimated future cost of all items.
- v_aq_search_iqalert_sql.sql - A view to quickly search the IQAlert tables that use a SQL query.
