Finance (Financials)

I would want to generate a excel report like below from the Payment File Trace Information LUThis is the template that the bank gave us.Row 1&2 are headers, row 3&4, 5&6, 7&8 are the data from PAY_TRACE_ITEM_CASH_ACCOUNTI will have to generate such a excel and store it in a network location and the bank application will pick it up from the location and process the file for payment.What is the best way to get this done ?   

Hi community,I have a technical question regarding Beneficiary Name tag (<CdtTrfTxInf> <Cdtr> <Nm>). In BACS payments, the Beneficiary Name field is 18 characters. However, supplier name is longer than this. Has anyone managed to reduce IFS supplier name to 18 characters?Please see Beneficiary Name field in below link. Commercial Banking Online Support Centre (lloydsbank.com)ThanksFurkan

Good day, Is it possible to definea specific File template for a specific Country for the  SAF-T files? For a company in Portugal I have to define the SAF-T files in IFSAPP 9The system now only has one File Template.How can I import more templates and where can I get them or do I have to define them? Kind Regards,Raymond 

For other connection type like equipment etc., will be creating OESHIPNI transactions when delivery of non-inventory part from connected customer order, but the same is not working for VIM connection type work order. Can any one reply asap.

We have reopened a project in IFS10 APPS (A2021) to do some returns/refunds and now we can't close the project again. ERROR TEXT: The A2021 value used for the Project code item is missing or has an invalid time rangeWe see that all return transactions are in error status. Normally, to solve this error, we go to "Anailitic Element Values" and change the date. But in this case it has not been enough for the problem to be solved and these transactions still have errors. Does anyone know hot to solve it?    

hi, could you please help me to handle the multi VAT in supplier invoice?As i tested, when I did the setup, I lost the standard control of VAT on object…Maybe I am not doing the correct setupplease advice.thanks & regards,Kherdine

How was it possible the skip first row when transferring CSV-file with external file / voucher assistant? It was some setup in External file template, but can remember it. We are using Apps9.

Hi,What is the purpose of using process code to financial accounts? What do we need to consider in setting up process rules for the charter of accounts?

this error occurred for an inter bank transfer. 

Hi I been trying to active the delivery Overhead but somehow it wont work. i Setup the Purchase Part with the delivery Overhead 10% from the last purchase Price purchase order is also created: definition of inventory part I have checked if there is a posting created in the Inventory Transaction history but there is no such overhead posting.

Hello,I have a question about the SINWOF settings.I wanted to know if the use of authorization routing rules and authorization combination rules  is mandatory ? Best regards

ENVIRONMENT: IFS Cloud 22 R2 Service Update 7 AUDIENCE: All RESOLUTION/ANSWER:Adjusting the revenue to be recognised on some of the projects in the previous month, and these adjusted values are not being pulled into the current month’s revenue recognised previously accumulated column as expected.  This is leading to a difference in the GL Balance Analysis screen.

I have an External supplier invoice that was imported via integration (invoice series “SX”). In the posting proposal line, I enter my Work Order and Work Task. I authorize the posting proposal and finally post it. However, I don’t get a new Cost line to my Work Task.If I enter a Manual supplier invoice (invoice series “SI”), enter Work Order and Work Task on posting line, and finally post it, then I successfully get a new Cost line to my Work Task. I’m struggling to find the reason why these two processes act differently.Is there a parameter or some setting that affects these two processes? Any help on this would be appreciated.Br, Tuukka

Hi, where can I set the directory path for currency rate in input?Thanks  

I am looking for where and how I might be able to analyze a customers payment performance.  Specifically, I am looking for ratio’s on prior their prior payment performance.  In Customer Credit Analysis the Customer DSO and ART ratios show zero unless the customer has an open balance in A/R.So if a customer has no A/R then there are no payment performance ratios available.  Which means “inactive” customers or current customers with no A/R can’t be reviewed.Any suggestions?

Hi IFS Community,I was just researching about the external supplier invoice interface (STDSIN1)I get all the information about the invoice from an external system via the interface, including the order number.The question is if there is possibility that PO matching is done automatically? I read in the other post that it is not possible. Are you of the same opinion?“..I think PO matching is not possible in external supplier invoice interface,..” 

Hi everyone,  Working through integrating IFS with CyberSource on APPS10 Aurena. We’re able to get test transactions to process within the Customer Order Credit Card screens, however, we’re noticing that the CSC code is not being requested in Aurena, but it is getting requested when we attempt to do the same thing in Enterprise Explorer. We have verified on the basic data the Credit Card Gateway has CSC as required.  The below is for the same customer credit card for two different customer orders.Enterprise ExplorerAfter a RMB “Authorize Card” from the credit portion of an order, presented with a request to enter the CSC code.  AurenaAfter doing something similar in Aurena, the authorization request is sent, despite a message surfacing that a

Hello,I have a request to process regarding customer payments.It is requested to have a staggered payment as follows:30% at the order40% at the reception.30 at the invoicing.How to set this up?

Hello,  I face a problem linked to Fixed assets. I have FA that were created without being linked to a PO. When I try to get the FA back to investment statuts. I get this error message. Any ideas to resolve this issue ? Best regards.  

We have created new account, but this account is now missing from P&L based on account report. How to add it?

We are using IFS application Version 9, I am working on a project of reporting in that I need to fetch the Trial Balance Data directly from the Database. I know that from the application I can run the Trial Balance Report and Export it to Excel which I do not want. I need help to fetch the Trial Balance directly from the DB or any if you know the view which can provide me the TB Data.

Community, I have a question about customer invoice currency. if my customer order is in EUR currency, and my base currency is in USD, can i print the customer invoice in USD?Thank you. 

Good day,For a customer of my I need to implement the ACTUD and QR-code for a company in Portugal.Does anyone know how to get the AT-Validation Code?Must you do the buy using the webservice of the AT? I've also installed the localization of Portugal for APPS9. The customer is using IFSAPP 9Thank in advance for the answersRegards,Raymond

Hi,I am working on ifs cloud for payment  files creation in background , I want to bring back  the value “company”  on  file name.I have tried with the sender , but it doesnt match Thanks for your help    

Is there an Inventory Value Report matching with specific GL Account [which is defined in the posting controls] and Values?  Basically, looking for the inventory details associated with GL Account [Accounts are defined in the posting controls for each type of transactions] for e.g., Inventory Account, Goods In Transit, Goods at Supplier, etc.