Finance (Financials)

Hello, could someone tell me what the exact sort order is for a Bacs.dat (txt) file when creating a supplier payment order with BACS payment format? A BACS.dat file could look like this:12345,9876543,00000001000,Supplier A,,,54321,1234567,0000002000,Supplier B,,, But what is the logic for the sort order behind it?For example is it Account Number, Pay Amount in Inv Curr, Account Name, Identity, Our Reference… etc? Or is there no sort order at all (just to provide raw data without any logic)? Thank you! Best regardsGeorgios

700

2 years ago

geminirajeshHero

asked in Finance (Financials)

Excel output from Payment File trace information

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 ?

700

2 years ago

furkizioDo Gooder (Customer)

asked in Finance (Financials)

BACS Payment Using ISO20022 Format

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

4921

2 years ago

RLGroenerDo Gooder (Partner)

asked in Finance (Financials)

File templates SAF-T

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

690

2 years ago

TecAlageSDo Gooder (Partner)

asked in Finance (Financials)

IFS 10- Work Order connection type VIM

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.

780

2 years ago

ConAdriaRSidekick (Partner)

asked in Finance (Financials)

IFS 10 - Project close with pendint transactions

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?

500

2 years ago

KherdineSidekick (Partner)

asked in Finance (Financials)

Multi VAT Supplier invoice

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

1264

2 years ago

Maaret EklundDo Gooder (Customer)

asked in Finance (Financials)

External file type / header row

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.

9805

2 years ago

AOADo Gooder

asked in Finance (Financials)

Process code

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?

681

2 years ago

susanthaDo Gooder (Customer)

asked in Finance (Financials)

when try to cancel a mixedpayment entry there is an error occure"Cash account XXX is connected to payment intitute that cash account XXX"

this error occurred for an inter bank transfer.

861

2 years ago

bytsophanHero (Partner)

asked in Finance (Financials)

delivery overhead doesnt get posted

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. I also checked the supplier invoice posting there is no overhead posting: then i checked the System Event for delivery Overhead setup. I cannot get the checkbox ticked since i get the error message: then i checked the Arrival Event and this is ok: Any Idea how i get the delivery Overhead posted? Best RegardsSophal

1152

2 years ago

AbdessamadSidekick (Partner)

asked in Finance (Financials)

Supplier Invoice Workflow

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

3614

2 years ago

Shehan ChandrasekaraSidekick (Employee)

asked in Finance (Financials)

Rev Recognition Invalid Previous Accumulated Value - Discrepancy from GL Balance

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.The user had modified the 'Revenue recognised accumulated' value in the previous procedure. It seems that the user had modified the value more than once, but the application is only registering the initially modified value and not the subsequent modifications to the 'Revenue recognised accumulated' value.The root cause analysis identified that this was a core issue, and the FIX will be available on 21R2 SU15. WORKAROUND: N/ASolution: RnD confirmed that this will be fixed with 21R2 SU15 CAUSE: N/AADDITIONAL INFORMATION: N/ASCRIPTS/LOGS: N/A SOURCE: Shehan Chandrasekara VERIFIED:

200

2 years ago

TuukkaSidekick (Partner)

asked in Finance (Financials)

Posting external supplier invoice to Work Task

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

1004

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

IFS cloud : Directory path for currency rates importation

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

1033

2 years ago

KWPCFODo Gooder (Customer)

asked in Finance (Financials)

Customer Analysis Ratios

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?

1632

2 years ago

CLaudDo Gooder (Partner)

asked in Finance (Financials)

external supplier Invoice Template STDSIN1 matching with Purchase Order

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,..”

934

2 years ago

leadingzerosSidekick (Customer)

asked in Finance (Financials)

Credit Card Integration - APPS10 AURENA NOT PROMPTING FOR CSC CODE

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 CSC will be required, Has anyone else seen this? It seems like a bug in Aurena’s behavior, but wanted to check here before submitting a ticket with IFS.

1352

2 years ago

AbdessamadSidekick (Partner)

asked in Finance (Financials)

Customer payment

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?

1152

2 years ago

AbdessamadSidekick (Partner)

asked in Finance (Financials)

Fixed asset error

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.

370

2 years ago

TaMaSidekick (Customer)

asked in Finance (Financials)

Account missing from PL report

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

1228

2 years ago

WAHEEDFMDo Gooder (Customer)

asked in Finance (Financials)

TRIAL BALANCE QUERY

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.

6867

2 years ago

ronhuHero (Customer)

asked in Finance (Financials)

Print Customer Invoice in Base Currency

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.

1224

2 years ago

RLGroenerDo Gooder (Partner)

asked in Finance (Financials)

ACTUD and QR-code IFSAPP9

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

630

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

IFS Connect for Payment Files Creation in Background: company in file name

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

911

2 years ago

Page 99 / 197

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded