Hi All. We have problem assuring invoices being entered only once in the IFS Financials. The Invoice identity is validated to be unique, but that does not work if spaces are typed by mistake at the end or the beginning of the field. Any good idea or practice to suppress the leading/Trailing spaces in the IFS fields upon entry?
Question
Unique Invoice Identity - spaces
+6
If you can’t find and fix the source where it is possible to enter those leading/trailing spaces you can create a custom event to prevent the invoice from being created.
Example, if it is the invoice number that is the problem:
BEGIN
IF '&NEW:INVOICE_NO' != ltrim('&NEW:INVOICE_NO') THEN
Error_SYS.Record_General('Dummy','SPACECHECK: Invoice number "&NEW:INVOICE_NO" contains leading space(s) and that is not allowed.');
ELSIF '&NEW:INVOICE_NO' != rtrim('&NEW:INVOICE_NO') THEN
Error_SYS.Record_General('Dummy','SPACECHECK: Invoice number "&NEW:INVOICE_NO" contains trailing space(s) and that is not allowed.');
END IF;
END;
+6Hi Tomas. Thanks a lot for the hint. We will try!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.