We implemented this now based on simple character inputs from the scanner. The proper input field on the screen must be selected first, after that by scanning the qr code the values obtained from the code are inserted into the first and further input fields using a specific number of “tab” inputs to go to the right input fields.
thanks for your input. Since we cannot access the tables directly but only the views, I rewrote your statement: SELECT t.doc_class, d.title, t.doc_no, t.doc_rev, (dbms_lob.getlength(t.file_data)) / 1024 / 1024 AS file_size_MB, t.objversion, d.doc_status FROM IFSAPP.EDM_FILE_STORAGE t, IFSAPP.doc_issue d WHERE t.doc_class = d.doc_class AND t.doc_no = d.doc_no AND t.doc_sheet = d.doc_sheet AND t.doc_rev = d.doc_rev; This helps, thanks!
I found now a ESR and QR scanner (Crealogix PayEye) which comes with a software which has some kind of predefined integration for IFS. This can be found in the configuration file: [IFS World] PunktBetrag String:=; ReferenzNr String:=; TeilnehmerNr Tab Any idea how we can use this?
Thanks Steve, these are great inputs! I will check with my development team which approach they like most. Regards Michael
Yes, a csv would be a “interface solution”. Another solution could be to fill a custom field and have an event to spread its content to the other fields… I will check the link you sent. Thanks!
Hi Steve the content of the QR code in Swiss QR invoices is clearly specified: Account Number, Creditor Address, Reference Number, Debtor Address, Amount and Currency. So when we scan the QR code of such an invoice, we wanted these fields to be filled in automatically.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
