Finance (Financials)

This will include the questions related to Financials.

  • 4,324 Topics
  • 11,910 Replies

4324 Topics

R
Do Gooder (Partner)
roshanFDo Gooder (Partner)
asked in Finance (Financials)

How to Setup IFS to Receive Einvoices via PEPPOL

Hello Community,We are using IFS Applications APP 10-UPD 15 version. Currently we are trying to Automate AP processing and decided to use E-invoicing with PEPPOL to receive all our supplier invoices. But we are not quite sure what is the setup needed in IFS Applications in order to process the PEPPOL einvoices/xml files we receive from the Access Point. Really appreciate if you could let us know the steps or some guidelines as to how we should do this setup in IFS.

1
J
Sidekick (Partner)
7 months ago
V
Do Gooder (Partner)
Vinoy HeshanDo Gooder (Partner)
asked in Finance (Financials)

ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")

Hi,I get the following oracle error message in ‘Customer Invoices with errors’ window since 3rd May. ”ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")” I have added a new custom field to CustomerOrder LU on the same day. Only CUSTCOLDEB (debit collective invoices) shoots out this error.Code in new CFSELECT 'Företag - Återstående limit' || CHR(13) || CHR(10) || cl.comp_limits AS "Företag och återstående limit"FROM (SELECT LISTAGG(COMPANY || ' - ' ||               CASE WHEN CREDIT_BLOCK = 'TRUE' THEN 'STOPPAD'                   ELSE TO_CHAR(ROUND(NVL((SELECT remain_credit1                                             FROM IFSAPP.customer_credit_collection_qry q                                            WHERE q.identity = c.identity                                              AND q.company = c.company), CREDIT_LIMIT)), 'FM999G999G999')              END, CHR(13) || CHR(10)) WITHIN GROUP (ORDER BY COMPANY) comp_limitsFROM IFSAPP.CUSTOMER_CREDIT_INFO_CUST c

1
V
Do Gooder (Partner)
1 year ago
H
Do Gooder (Customer)
HRH31Do Gooder (Customer)
asked in Finance (Financials)

Credit limit and partial order shipment

Hi, Is there a way to partially release a customer order?  In particular, where a customer is approaching their credit limit, but we are happy to release partial goods/order lines to take a customer to , but stay within the given credit limit.  

1
P
Hero (Employee)
11 months ago
Link
Superhero (Customer)
LinkSuperhero (Customer)
asked in Finance (Financials)

Import e invoices via sftp

Dear community,my goal is to import an e-invoice (xml) to IFS via sftp. But it doesn’t work. IFS doesn’t take the xml file from our (internal) sFTP server. The settings in IFS connect works for other imports.If I change the “Location Type” to File then it works fine.Does anybody have experiences? Thank you.

1
Link
Superhero (Customer)
9 months ago
T
Do Gooder (Partner)
TecAlageSDo Gooder (Partner)
asked in Finance (Financials)

Project Accounting: Stop Reversal of Revenue Recongination Voucher

Hi Team,Good Day!!Can you any one guide is there any provision is available in IFS to stop reversal entries of revenue recognition entries in next month when use project type ‘Period Capitalization/ Revenue Recognition’ 

1
Ieva Rituma
Superhero (Employee)
1 year ago
V
Do Gooder (Partner)
VolkerWDo Gooder (Partner)
asked in Finance (Financials)

Supplier Direct Debit

A customer pays some of his suppliers by allowing them to pull direct debits from his account. It seems that this case is not supported by IFS at all (yet). Is this correct?IFS knows direct debit, but only where the IFS user is the supplier. It makes no sense to include the payment in a payment proposal because that would pay the supplier twice. And it is not possible to import it via a bank statement file because the transaction code 105 which is used by the bank for this purpose is set  to “Direct Cash” in IFS. With the trick described in the comments of  it seems to be possible to use the code anyway for supplier payments but we still can see that the function is not really supported - for example cash discounts are not automatically calculated and assigned there. So do we actually have to wait for a support of supplier direct debits in IFS? 

1
B
Do Gooder (Customer)
10 months ago
S
Do Gooder (Customer)
svrmhuebnerDo Gooder (Customer)
asked in Finance (Financials)

Cancel posted customer invoice

Is it possible to cancel a already posted customer invoice?  I know you can cancel a preliminary invoice, but are there any options to reverse a posted invoice?Thanks, Mark

1
L
Sidekick (Customer)
1 year ago
Peshala Gamage
Hero (Employee)
Peshala GamageHero (Employee)
asked in Finance (Financials)

Can we add fields to search?

Hi Team, One of our customers had raised the following question through a case, please make sure the customer gets all the answers for the requested question.“In the window "IL Voucher Rows Analysis", the search function does not include fields Company or Ledger ID. Is it possible to add these fields as search conditions?” Best Regards,Peshala

1
F
Superhero (Partner)
11 months ago
T
Do Gooder (Partner)
TecAlageSDo Gooder (Partner)
asked in Finance (Financials)

Project and Activity Sequence no is connected to Project Invoice

Hi Team, I have created sales contract and  all necessary project connection have been made in sales contract level. After that I have created AFP in that those project information is flowing, but when I create project invoice  those project and activity sequence no are not flowing to project invoice. Can any one tell why it is missing is there any basic data set up issues.

1
A
Sidekick (Partner)
6 months ago
N
Hero
Nagah.khaledHero
asked in Finance (Financials)

Error(there are no voucher rows in current voucher)occurred while booking invoice

our user created manual supplier invoice for many Pos.he is unable to post the invoice and system shows the below error message.Error(there are no voucher rows in current voucher) occurred while booking invoice.please advise?

1
T
Sidekick (Employee)
2 months ago
NPGIFSJOMAII
Sidekick (Customer)
NPGIFSJOMAIISidekick (Customer)
asked in Finance (Financials)

External supplier invoice load logic

Hello,We are receiveing standard IFS XML-invoices as external supplier invoices. Is there any documentation of the logic how an external invoice fil is created in IFS Cloud? We often get the question why is not this bank account included in the creation, why is this supplier not found in the creation. Why is this authorizer not found?Sometimes the value is supposed to come from the XML file, somtimes it is supposed to be retrieved from IFS. Can I find this logic somewhere? Kind regards,Johan

1
Link
Superhero (Customer)
11 months ago
MishaelAkleker
Sidekick (Partner)
MishaelAklekerSidekick (Partner)
asked in Finance (Financials)

Authorization of Supplier Credit Invoices

Hello, Thank you for taking the time to read! I am helping a customer who is raises Supplier Credit Invoices. When they do this, they would like some sort of authorization on this to kick on the posting proposal. I have tried various combinations including putting maximum amounts of 0 and amending the priorities etc, but the rule is not kicking in.  Would there be any way to apply a rule to the credit invoices raised? Any guidance would be appreciated :) Thanks!  

1
Ieva Rituma
Superhero (Employee)
11 months ago
Sachin Vithanage
Hero (Employee)
Sachin VithanageHero (Employee)
posted in Finance (Financials)

Interest Proposal - parameters

‘New Interest Proposal’ screen in IFS Cloud only allows to generate the proposal for a range of customers. However, there can be situations where we need to run the proposal only including some specific customers.  But the existing functionality does not allow this. In ‘Customer Reminder Proposals’ we have several ‘Operators’ and hence we are able to include/exclude specific customers.Therefore, it would be much better to introduce the same parameters to ‘Interest Proposals’ as well because both functionalities are related.  Also, this would improve the consistency of the application in similar features. 

1
Sachin Vithanage
Hero (Employee)
1 year ago
Sachin Vithanage
Hero (Employee)
Sachin VithanageHero (Employee)
posted in Finance (Financials)

Interest Proposal - Parameters

‘New Interest Proposal’ screen in IFS Cloud only allows to generate the proposal for a range of customers. However, there can be situations where we need to run the proposal only including some specific customers.  But the existing functionality does not allow this. In ‘Customer Reminder Proposals’ we have several ‘Operators’ and hence we are able to include/exclude specific customers.Therefore, it would be much better to introduce the same parameters to ‘Interest Proposals’ as well because both functionalities are related.  Also, this would improve the consistency of the application in similar features.

1
Sachin Vithanage
Hero (Employee)
1 year ago
T
Hero (Customer)
TosohLBlumHero (Customer)
asked in Finance (Financials)

Segregation of Duties - View Access

I’m working on our segregation of duties set up and would like to limit who can see the payment information for suppliers (routing # & account #).  This looks like I would control it by controlling the View Payment_address.  When I add that to a functional area, I get way too many users show up as having access.  However, there doesn’t seem to be a report like the Object Security Report that will show me what permission sets are giving the users this access. 1 - Is there a report that will show what permission sets have access to a view?2 - Where do I find the View PAYMENT_ADDRESS so I can remove it from the permission set? Thanks in advance. 

1
C
Hero (Customer)
11 months ago
C
Do Gooder (Partner)
CorBarbaLDo Gooder (Partner)
asked in Finance (Financials)

Entity Posting Control

HI I have a client who wants code part: Entity, to automatically post in the GL column when an order is invoiced, a PO is paid, when inventory has been received for Intercompany customers/suppliers. We have a pre-posting on the customer order and purchase order, so that a person will entry the Entity in pre-posting. The client does not want to do this. They want it to automatically populate when the intercompany customer or supplier is used.  Client solution: The one below is not working. They have a posting control IP2, with Code part Entity with IC2 type.  Inside the details, the intercompany group have detail specifications on customer group using AC4: country code.  Has anyone come across this situation?

1
F
Superhero (Partner)
11 months ago
O
Do Gooder (Customer)
OROPAVELNDo Gooder (Customer)
asked in Finance (Financials)

Bank integration and bank statement reconciliation

Dear IFS community,I would like to ask for help with my questions but first I need to describe company situation.Right now we are using IFS Cloud Web version: 22.2.7.20230331080827.0 Current status:Right now we are not using standard IFS functionality to send payments to bank and reconcile bank statements. We have our own functionality which is going to be obsolete, not working properly and needs lot of manual effort. We have +-40 entities in IFS and every entity could have several bank accounts. During month we are talking about +-50K transactions which needs to be correctly paired in IFS. What I need:Let’s take into account only the most common scenario where we need to send to Swift xml format (pain.003) and we receive from Swift xml acknowledgement that it was delivered to bank and later we receive from bank xml MT940 where are visible processed payments.1.) Is there any guide how to setup bank integration flow from scratch?2.) Does IFS support some xml transformation? XML file nee

1
M
Sidekick (Partner)
11 months ago
A
Sidekick (Partner)
ATarBPTSidekick (Partner)
asked in Finance (Financials)

PO Reference is still visible even when the PO has been matched

Hello everyone, I am using IFS Cloud 22R2. We are using posting proposals.When i create a manual supplier invoice, and select the PO Reference list, all the PO are fetched even the ones that were completely matched/closed.Also, when i select a specific supplier, the POs that are displayed are not filtered with the supplier.Is it a bug or did it occur previously ? How to clean the POs that are already matched ?Thanks, Tarek.

1
F
Superhero (Partner)
1 year ago
S
Do Gooder (Employee)
suwklkDo Gooder (Employee)
asked in Finance (Financials)

Why automatic authorization has been disabled when invoice lines were manually changed compared to purchase order values?

Why automatic authorization has been disabled when invoice lines were manually changed compared to purchase order values?Test steps:A purchase order is created for 10 items with the unit price set as 15 USD per item, creating a total value of 150 USD. The supplier invoice is for 1 item for 15 USD. The register arrival is done for 2 items for 15 USD each. When we use the "Match Invoices with New PO Receipts" the quantity has to be changed from 2 items to 1 item and this change is the reason leading to the manual authorization approval. (Automatic Invoice Posting Authorizers have been enabled through the routing rule) The system does not allow automatic authorization when the Invoice lines and posting lines have been changed compared to the purchase order values. Looking for any workaround for this scenario.

1
Shehan Almeida
Superhero (Employee)
11 months ago
K
Do Gooder
Kasun PradeepDo Gooder
asked in Finance (Financials)

Currency amount” is not being correctly converted to “Amount in Accounting currency  

HiHow to rectify below errorCurrency amount” is not being correctly converted to “Amount in Accounting currency  

1
F
Superhero (Partner)
1 year ago
S
Do Gooder (Partner)
santhoshDo Gooder (Partner)
asked in Finance (Financials)

Detail Statistics- Invoiced Sales-cannot Serialize the Data Error.

Hi,While Appling the data for the First and Exporting the data its Exported. But when I do the same Exercise for the second time with different dates, getting the below error. need your Expertise view on this issue.  

1
J
Superhero (Employee)
1 year ago
T
Do Gooder (Partner)
TecAlageSDo Gooder (Partner)
asked in Finance (Financials)

Depreciation proposal errors

Hi Team,I have created depreciation method selected method type as ‘Customized’.Specified Deprecation FactorWhen I execute ‘Create Depreciation Proposal’ no data is flowing in the proposal. In Depreciation proposal log I am getting following error. 

1
F
Superhero (Partner)
1 year ago
O
Do Gooder (Customer)
Olivia GachesDo Gooder (Customer)
asked in Finance (Financials)

Is there a link between the invoice exception code and the exclusion of a disputed customer in the reminder model?

How to exclude a disputed invoice of the reminder module? Can we use the “exception code” ?,  Thanks in advance

1
N
Hero (Employee)
11 months ago
D
Do Gooder (Customer)
dkjensenDo Gooder (Customer)
asked in Finance (Financials)

scheduled task language field

What impact does the language field have on a scheduled task? We have batch create customer invoice jobs for various companies.  Most have a default language of English, but we have one that is French(Canada).  The Language field is required, 

1
F
Superhero (Partner)
1 year ago
E
Do Gooder (Customer)
ENVTECH2Do Gooder (Customer)
asked in Finance (Financials)

Customer credit invoice with errors

A new employee (AKA Me) created a credit invoice for a customer but accidently wiped out the Account number, so the invoice is in printed status but cannot post. We have tried everything we can think of but we cannot get this invoice corrected and out of Customer Invoices with Errors. Any suggestions are greatly appreciated.  

1
N
Hero (Employee)
11 months ago

Badges

Show all badges
Terms & ConditionsCookie settings