Procurement settings

The Procurement heading under Setting is the procurement_reference module: eleven list screens, each a modref under modules/procurement_reference/. They feed the Requisition, RFQ, PO, MRR and Vendor Management forms.

How this page was verified

Written from master on 2026-09-06 and compared with the big five the same day. No earlier page existed. Every screen was mapped to its table.

The eleven screens

Label	modref	Table	Used by
Category	category	ts_category (a tree), ts_map_vendor	Vendor Management, RFQ
Cost Code	cost_code	ts_cost_code	Requisition items
Delivery To	deliver_to	ts_deliver_to (per client)	RFQ, PO
Incoterms	incoterms	ts_incoterms	PO
Component Code	component_code	ts_item_code	Requisition and MRR items (item_code_id)
Mode of Transport	modeTransport	ts_mode_transport	MRR
Packing Types	packing_types	ts_packing_types (per client)	MRR
Payment Terms	paymentTerms	ts_payment_terms	PO
Product / Brand	product	ts_product, ts_map_vendor_product	Vendor Management
Tax	gst	the tax rate on ts_company_address, with ts_currency	PO totals
Unit	unit	ts_unit	every item grid

Seven more scripts sit in the folder and are not in the menu: bidder_doc_type (ts_bidder_doctype), expediting_milestone (ts_expedite_milestone), expediting_status (ts_expediting_status), form_number (ts_form_number), pricing_basis (ts_pricing_basis), termCondition (ts_condition_terms) and item_code. They are reachable by typing the modref, and the expediting pair feeds Material Expediting.

What still runs on the legacy helper

Every screen here has one to nine iw_mysql_query() calls left, so on an instance where the helper throws the grids load through the shared $pdo reference loader and the edits fail. The heaviest are bidder_doc_type, pricing_basis and termCondition (nine each), category and cost_code (six).

Gotchas

• Category is a tree and is shared with Vendor Management. Deleting a parent does not delete its children; the vendor mappings then point at orphans.
• Component Code writes ts_item_code, not ts_component_code. Grep by table, not by label.
• Tax lives on the company address row. There is one rate per address, not a list.

Instance differences

Checked on 2026-09-06.

Instance	Difference
JOTRE	Installed. Adds an Item Master Data screen (item_master.php) and registers it in procurement_reference.php.
Jadestone, Medco, Timas	Not installed in their QA databases. Code identical to master.

Related

• Vendor Management, Requisition, Purchase Order.