account payables form personalization
Post on 22-Oct-2015
103 Views
Preview:
DESCRIPTION
TRANSCRIPT
1. Customization for making some field unupdateable
2. Customization for making due date un updateable for LAMS and RMM
3. Make requester required and default
=(SELECT full_name FROM per_all_people_f WHERE PERSON_ID = (select ORIG_SYSTEM_ID from wf_users where NAME = ${ps.username.value}))
4. Making Data Specific For Lams
5. Make Line Field Only Readable
6. GL Date From Invoice Date
7. Invoice Date and Invoice GL Date should be in same month
to_char(:INV_SUM_FOLDER.GL_DATE,'MON-YY') <> to_char(:INV_SUM_FOLDER.INVOICE_DATE,'MON-YY')and :INV_SUM_FOLDER.APPROVAL_STATUS_DISPLAY not in ( 'Validated','Cancelled')
8. Dist GL Date and Invoice date dhould be in same month
to_char(:INV_SUM_FOLDER.GL_DATE,'MON-YY') <> to_char(:D_SUM_FOLDER.ACCOUNTING_DATE,'MON-YY')and :INV_SUM_FOLDER.APPROVAL_STATUS_DISPLAY not in ( 'Validated','Cancelled')
9. Changing the prompt of Trading Partner
10. Invoice Amount cannot be zero
11. Create global variable to populate invoice id to validate due date on payment form for LAMS,RMM
12. Insert invoice due date in global variable to validate due date on payment form for LAMS,RMM
13. Making Description mandatory
14. Check to disallow the LAMS and RMM invoices from Invoice form
:INV_SUM_ACTIONS.PAY = 'Y'and :INV_SUM_FOLDER.SOURCE in ('LAMS','RMM')and :INV_SUM_FOLDER.ATTRIBUTE_CATEGORY in ('DISB-PAY','BO-REP','TL-REP')
top related