- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by bartlomiej.pobocha

44 Replies

Newest first

Oldest first

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to Print Pdf report automatically

below script connect PDF to existing report archive ADDITIONAL_INV_Q_R_CODE_REP, but I think it can be used for any other reports:DECLARE result_key_ NUMBER := 179065; print_ATTR_ VARCHAR2(200); PRINT_JOB_ID_ NUMBER; LAYOUT_NAME_ VARCHAR2(200);BEGIN CLIENT_SYS.CLEAR_ATTR(print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('PRINTER_ID','PDF_PRINTER',PRINT_ATTR_);--printer_id_ := Printer_Connection_API.Get_Default_Printer(Fnd_Session_API.Get_Fnd_User, 'ADDITIONAL_INV_Q_R_CODE_REP'); PRINT_JOB_API.NEW(PRINT_JOB_ID_, print_ATTR_); LAYOUT_NAME_ := REPORT_LAYOUT_DEFINITION_API.GET_DEFAULT_LAYOUT('ADDITIONAL_INV_Q_R_CODE_REP'); CLIENT_SYS.CLEAR_ATTR(print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('PRINT_JOB_ID',PRINT_JOB_ID_,print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('RESULT_KEY',result_key_,print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('LAYOUT_NAME',LAYOUT_NAME_,print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('OPTIONS','COPIES(1)',print_ATTR_); CLIENT_SYS.ADD_TO_ATTR('LANG_CODE','en',print_ATTR_); CLIENT_SYS.ADD_

zakDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

permission set query

Hello,Please refer to knowledge base article:Best regardsBartłomiej Pobocha

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to Print Pdf report automatically

@alpamuk what function I need to execute in event?

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to Print Pdf report automatically

@ashen_malaka_ranasinghe for me it is impossible, because of error: report hasn’t any parameters:is there any other option?

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to Print Pdf report automatically

Hello,@jzouaoui did you find the solution? I’m looking for the same functionality.Best regardsBartłomiej Pobocha

bartlomiej.pobochaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Who is executing sql event action: &AO or user?

solved - &AO is executing SQL statements, but the language of the current user can decide what value is passed by parameters

bartlomiej.pobochaSidekick (Employee)

asked in Supply Chain

Automatically transfer charges from Intercompany CO to PO, CO

Thank you. I considering two approaches to creating this functionality, could you please advise which will be the best?really big customization to handle it. Many small configurations(custom objects) that will improve and automate separate elements of the process e.g.: event will run background task wchih will creat the charges in PO when you release CO event will run background task wchih will creat the charges in second CO when you release CO event will run background task wchih will update the charges in first CO when update charges in second CO custom fields that will store relationship between charges in orders events that will block process when you don’t popertly update/create charges for all orders workflow for this process by emails and or approval rounting and or messages in application etc...

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Running Crystal Reports in Aurena - Unable to process your request

I found some kind of solution - you need to delete CR_WE_INIT connectin and then report in aurena will work, but you will lose security check descibed in this document: https://docs.ifs.com/techdocs/foundation1/020_installation/400_installation_options/005_operational_reporting/110_configure_crystal_web_service/010_setup_cws/default.htm#Configuring_the_System_Parameters

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Running Crystal Reports in Aurena - Unable to process your request

hello, could you please provide the solution?

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Problem with Crystal Reports in Aurena IFS10

Hello, could you please indicate which patch need to be installed?

bartlomiej.pobochaSidekick (Employee)

asked in Finance (Financials)

Automatically authorized of supplier invoice after preliminary posting

Hello, tax amount for split payment always is in first instalment.

bartlomiej.pobochaSidekick (Employee)

asked in Finance (Financials)

Automatically authorized of supplier invoice after preliminary posting

Yes, you could change payment term(payment term turns on/off split payment mechanizm). For tax = 0% you don’t need to use split payment, but clients usualy use split payment no metter what % of tax is on invoice.

bartlomiej.pobochaSidekick (Employee)

asked in Finance (Financials)

Automatically authorized of supplier invoice after preliminary posting

In Poland we are obligated to pay with two instalments, where first instalment is only tax. When you have 0% tax then amount of first instalment will be 0.

bartlomiej.pobochaSidekick (Employee)

posted in Finance (Financials)

Presentation of not overdue invoices in customer ledger age analysis report

Adam, in polish version of the report we have columns:“Nie do zapłaty” (in english version of the report “Not due”) - which I understand as not overdue and due today“Należne X-Y Dni”(in english version of the report “Due X-Y Days”) - which I understand as overdue from X to Y days. 0 isn’t overdue so in my opinion it shouldn’t belong to that column.I will try to explain it to customer.Thanks for all and best regardsBartłomiej Pobocha

bartlomiej.pobochaSidekick (Employee)

posted in Finance (Financials)

Presentation of not overdue invoices in customer ledger age analysis report

Hello,Thank all of you for your answers, specially Ralph for workaround. For me report simply shows false data in described use case, because if something is not overdue it should be presented it not overdue column. There is also best reardsBartłomiej Pobocha

bartlomiej.pobochaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Company as page parameter in custom logical unit

Any other idea how to limit access to the company for LU?

bartlomiej.pobochaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to save json file(respond from REST API in IFS connect) in custom table

Hello Joe, Thanks for the responds. I undestod that this case cann’t be handle without modification. The correct way to handle this requirement is transform json to XML and then save the XML in database using BizAPI provided by modification. I hope in the future IFS will provide some configurable custom solution for problems like this, because they will be very common. Best regardsBart

bartlomiej.pobochaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Do data of report from IFS business reporter tool is stored in database?

Thanks Stefan, I will try this idea.

bartlomiej.pobochaSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to save json file(respond from REST API in IFS connect) in custom table

Thanks for replay Joe!Structure of json is like that:{"Results": {"WebServiceOutput0": [ { "feature1": 0.7403482493914997, "feature2": 1.015384615384623, ... #another 400 other float type features on the same level(row) "Scored ": 39.0 }, { "feature1": 0.3403482493914997, "feature2": 1.547894615384623, ... #another 400 other float type features on the same level(row) "Scored": 128.0 }, ... #another rows. There could be up to 500 rows in single file. Each row could have aprox 26 500 characters { "feature1": 0.5503482493914997, "feature2": 1.235444615384623, ... #another 400 other float type features on the same level(row) "Scored": 22.0 } ] }}I want to save that many rows in custom table that I have in json

1
2

Page 2 / 2

Badges

Dustonhas earned the badge 1st Topic
userqueryhas earned the badge 5th Reply
motionenergygelhas earned the badge 1st Topic
incasolhas earned the badge 1st Topic
toxicoffhas earned the badge 1st Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK