Assign parameters to a purchase order header stored procedure
You can assign parameters to a purchase order header stored procedure by following these steps.
- On the menu, select PO Number Validation tab.
-
From the
Validate From setting, select the
Custom Database value.
The list of available settings is updated with respect to custom databases.
-
Select
Use Stored Procedures.
Several stored procedure settings are now available.
- Enter a value into the Stored Procedure Parameters setting that represents the assigned purchase order line numbers. For example, 1, 2, or 3.
- Save your changes.
- Navigate to Line Pairing Settings.
-
Ensure that
Do Line Pairing is selected.
Several line pairing settings are now available.
-
Ensure that
Get PO Lines From is set to
Custom Database and the
Use Stored Procedure setting is selected.
These selections display additional stored procedure settings.
- Set the Stored Procedure Parameters value to match the value entered in step 4 above.
- Save your changes.