I have requirement with respect to Forms. This is my First time working on Form Changes.Could you please guide me in detail how I can achieve below
Based on a Value in a Custom table I want to Validate the "Invoice Delivery Method"(Additional Header Information is DFF).
on the Sales Order Form .
The Relation between Sales order form and Custom table is the Customer Number on SO form and the Account_Number in Custom table.
1) changing from either "Hard Copy" or "Email" to "Email & EDI" or "EDI" will be possible only if the EDI Status field on the custom form is "Active".
A validation will check this and notify "Account EDI configuration is not active yet"
2)changing back from either "Email & EDI" or "EDI" to "Hard Copy" or "Email" will be possible only if the EDI Status field on the custom form is "Inactive".
I have created a TEST Table to hold the "EDI STATUS" FIELD.
CREATE TABLE TEST_TABLE
(ACCOUNT_NUMBER VARCHAR2(50)
,ACCOUNT_NAME VARCHAR2(250)
,REQUESTER_NAME VARCHAR2(250)
,PHONE VARCHAR2(50)
,PHONE_EXTENSION VARCHAR2(50)
,EMAIL VARCHAR2(100)
,IT_REPRESENTATIVE_NAME VARCHAR2(100)
,IT_REPRESENTATIVE_EMAIL VARCHAR2(100)
,IT_REPRESENTATIVE_PHONE VARCHAR2(50)
,MESSAGE_FORMAT VARCHAR2(50)
,CUSTOMER_TYPE VARCHAR2(50)
,EINVOICE_PROVIDER VARCHAR2(50)
,STANDARD_IDENTIFICATION_NUMBER VARCHAR2(50)
,REMARK VARCHAR2(50)
,EDI_STATUS VARCHAR2(50)
,CREATION_DATE DATE
,CREATED_BY INTEGER
,LAST_UPDATE_DATE DATE
,LAST_UPDATED_BY INTEGER);
Please let me know how this can be achieved or let me know if you need more details.