Hi @paul harland ,Can We user SQL query in IFS 8 events .I need to show cumulative customer wise sale in the email as SQL query output.Please Help….!!!RegardsDeepak Navale
Dear Paul , I need to modify above server method as Below:- INVOICE_API.Get_Invoice_No(&NEW:COMPANY,&NEW:IDENTITY,&NEW:PARTY_TYPE,&NEW:INVOICE_ID) Waiting for the user to create the invoice in Prod. Hoping it will work….!!!! Wonderfull job done !!!
Dear @paul harland ,Invoice number is coming in the event successfully.Thanks for your valuable support…!!!!Learned a new thing today….!!!Thank you community for creating this platform for users around the world.Here new users will get inspired from experts in IFS. RegardsDeepak Navale
Deepak, Attached is a presentation about Business Analytics and also some sample reports to help show you what is possible. Regards, Antony Thank You SO Much @anbouk for your help…!!! appreciate it…!!!
Dear @paul harland We are using Oracle 11g Wherein I have created one trigger to restrict the user but what happned last week when user was creating sales part where Inventory part is already present in system then also this trigger get fired and retricting user to create the sales part.So I have disabled this trigger.Please find the trigger logic:-**********************************************************************CREATE OR REPLACE TRIGGER INVNETORY_PART_05082020BEFORE INSERT ON sales_part_tabFOR EACH ROWwhen (NEW.CONTRACT='PPR01' AND NEW.Catalog_Type='INV')DECLARECURSOR C1 ISSELECT COUNT (*)FROM sales_part_tabWHERE contract='PPR01'AND PART_NO =:NEW.PART_NO ;cnt_ NUMBER;BEGIN OPEN C1; FETCH C1 INTO cnt_; CLOSE C1; IF NVL(CNT_,0) = 0 THEN ERROR_SYS.RECORD_GENERAL('SalesPart','ERRORINVPART: Inventory Part not present in system . Please check with admin. Error Through trigger INVNETORY_PART_05082020.',:NEW.PART_NO ); END IF;END;***************************
@paul harland can you help ….!!!
Dear Paul ,I need to modify above server method as Below:-INVOICE_API.Get_Invoice_No(&NEW:COMPANY,&NEW:IDENTITY,&NEW:PARTY_TYPE,&NEW:INVOICE_ID) Waiting for the user to create the invoice in Prod.Hoping it will work….!!!!
hi try this server method: invoice_api.Get_Invoice_No(&NEW:COMPANY,&NEW:INVOICE_ID) Wonderfull..!!!
Thank you so much paul (Hero) I will try it and update you….!!!
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.