Hi AllI need help about a request i would like to do in the view : PROJECT_TRANSACTIONIn this view, i have selected the items belowInternal_quantity Company_IDI have some parameters :$COMPANY_ID$ → value authorized : 622 or 6% $YEAR$ → value authorized : 2022 $MONTH$ → value authorized : 01 or 02, … $EMPLOYEE$ → value authorized : ERFOFR or %I would like to have this result IQ_TOTAL → Sum(INTERNAL_QUANTITY) IQ_TOTALINV → Sum(INTERNAL_QUANTITY) only for INVOICABILITY =’Facturable’ IQ_TOTALNOTINV → Sum(INTERNAL_QUANTITY) only for INVOICABILITY =’Non Facturable’ For Column IQ_TOTALINV , i tried this below with $COMPANY_ID$ = 6% and $YEAR$ =2022 and $MONTH$ =01 :(select sum(INTERNAL_QUANTITY) from PROJECT_TRANSACTION where INVOICABILITY='Non facturable' and COMPANY_ID LIKE '$COMPANY$' and (to_char(ACCOUNT_DATE,'yyyy') = '$YEAR$' and to_char(ACCOUNT_DATE,'mm')='$MONTH$'))But it is wrong, because i have the same value for every company … if you have any idea … Thank for your help /eric
Hi allafter having this error message “This Add-in is installed for all users on this computer and can only be connected or disconnected by an administrator”, I was no longer able to open my IFS BR Reports created.I uninstalled IFS BR 21.2.0.0 (installed before with the MSI) … and I installed again IFS BR .. but I always have the same issue.I follow the topics named “IFS BR issue with Office 365”.I have installed IFS BR as administrator but I always have the same message : Operation Cancelled (Exception of HRESULT : 0x80004004 (E_ABORT)it’s very strange because 1 hour before it’s running well, but after a Microsoft Crash, … I have this issue.Please contact me asap I really must use IFS BR and reports for an important presentation this week./RegardsERIC
Hi, we have a customer that has First Card as their vendor for credit card transactions to IFS/Travel Expense. Do you (here in this community) have experience to set up this integration? Thanks in advance for all your input
Already have an account? Login
No account yet? Create an account
Enter your username or 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.