Best answer by Deepak
View original
Best answer by Deepak
View originalHi
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….!!!
Regards
Deepak Navale
very good
I believe the difference is your list of parameters is based on Apps 8 whereas mine was based on the same method name in Apps 10.
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
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.
Regards
Deepak 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….!!!!
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….!!!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.