Solved

How to use function in event to find out invoice no from invoice id.

  • 18 August 2020
  • 8 replies
  • 185 views

Userlevel 5
Badge +9

 

icon

Best answer by Deepak 19 August 2020, 07:43

View original

8 replies

Userlevel 7
Badge +24

hi 

try this

 

server method:

invoice_api.Get_Invoice_No(&NEW:COMPANY,&NEW:INVOICE_ID)

Userlevel 5
Badge +9

Thank you so much paul (Hero) I will try it and update you….!!!

Userlevel 5
Badge +9

hi 

try this

 

server method:

invoice_api.Get_Invoice_No(&NEW:COMPANY,&NEW:INVOICE_ID)

Wonderfull..!!!

Userlevel 5
Badge +9

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….!!!!

Userlevel 5
Badge +9

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. 

Regards

Deepak Navale

Userlevel 5
Badge +9

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  !!!

Userlevel 7
Badge +24

very good @Deepak 

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.

Userlevel 5
Badge +9

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….!!!

Regards

Deepak Navale

Reply