Skip to main content
Solved

Invalid Character

  • April 12, 2023
  • 2 replies
  • 172 views

Forum|alt.badge.img+4

Hi IFS Community,

Thank you all in Advance.

Could you please explain why we cannot use “&” in the Invoice Number field in the Manual Customer Invoice /Manual Supplier Invoice Screen??

 

Best Regards,

Chathura

Best answer by Ieva Rituma

IFS is built on an Oracle database and in PLSQL language, the character & represents a parameter (i.e. it drives a function unlike a normal character would). If you tried to search for & in the search, it would not act like a normal character, but instead open another box where people can fill out the ID. Because it can’t be searched on, it also can’t be used in the name/ID field. 

2 replies

Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Answer
  • April 12, 2023

IFS is built on an Oracle database and in PLSQL language, the character & represents a parameter (i.e. it drives a function unlike a normal character would). If you tried to search for & in the search, it would not act like a normal character, but instead open another box where people can fill out the ID. Because it can’t be searched on, it also can’t be used in the name/ID field. 


Forum|alt.badge.img+4
  • Author
  • Sidekick (Partner)
  • April 19, 2023

@Ieva Rituma  Thank you very much!