How to limit data entry in the Project field to only existing projects when entering Purchase Order

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

A control table that links to the Projects table must be created.

1. Open Setup, General Parameters, Control Tables (GESACL).
2. Create a new record.
3. Enter a Code and Title.
4. Select Control Type: Table Reference.
5. In the Parameter Definition section, enter table OPPOR (Project).
6. Save the record.

Add the control table to the Supplier Order screen.

1. Open Development, Processing Dictionary, Screens, Screens (GESAMK).
2. Enter screen code POH2 (Suppliers Orders).
3. Click onto the Fields tab and locate field PJT (Project).
4. Scroll to the Control table column.
5. Select the control table created in the previous steps.
6. Save changes, then Validate the screen.