Finance (Financials)

Sort order BACS.dat file

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

1 year ago

evjoseSidekick (Employee)

asked in Finance (Financials)

Accounts page - Edit All is not possible in all columns

In 22R1 it is not possible to do Edit All in all columns in the Accounts window, e.g. Keep Reported Currency as Currency Balance and Keep Balances Separated by Reporting Entity. Will this be changed in a new release or is this the way it shall work? It is very time consuming to enable it manually.

1 year ago

SMcLeesSidekick (Customer)

asked in Finance (Financials)

Cancel Matching - Mixed Payment

Have cancelled the matching on a mixed payment however it has not reversed as I would have expected.The payment is now not showing on the customer account, but is showing as a separate entry on an aged creditor list.How can I rectify this mixed payment (I am now unable to cancel the mixed payment) to show on customer account and not on the separate age creditor line?

5 months 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 ?

1 year 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

1 year ago

GT69Do Gooder (Customer)

asked in Finance (Financials)

Restricting access to invoices

HiWe have a requirement to restrict users entering, viewing and paying invoices from certain suppliers due to the confidential matters that invoices relate to e.g. workers compensation, fraud investigation. Is there any way of doing this without customisation? We are on the Aurena version of IFS CheersGT

1 year 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.

1 year 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?

1 year ago

Dave WouldhamDo Gooder (Customer)

asked in Finance (Financials)

Minority Interest calculation on Group Consolidation Apps 10

We are testing Group Consolidation in Apps 10 and have a couple of subsidiaries that are not 100% owned. One is 90% owned and the other is 50% owned, and both flagged with a Consolidation Method of Equity Majority. When running the consolidation, minority interest is being calculated and posted as per the posting control, but the calculations are not as expected (both are MI profit calculations are lower than they should be).Are there any other factors we need to take into account when setting up Group Consolidation that influence the minority interest calculation?Any help would be great.ThanksDave

1 year ago

bytsophanHero (Partner)

asked in Finance (Financials)

Group Consolidation, Elimination of Interim results

Hi i am looking for an instruction how to do a elimination of interim results. Is there an automatic way or is the elimination fo interim results a manual adjustment? A profit within the same Group must be eliminated. For Example Company A sells Goods to company B for 150’000 EUR. Cost of good sold in Company a would be 130’000 EUR. This means 20’000 EUR must be eliminated during the consolidation. BRSophal

1 year 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?

1 year 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.

1 year 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

1 year ago

lisa.gilesABSidekick (Customer)

asked in Finance (Financials)

Open Requisition Linked to Cancelled Purchase Order

Is it possible to reopen a Requisition linked to a Cancelled PO? A User cancelled a Purchase Order, but did not select ‘Yes’ to reopen the WO Purchase Requisition Lines. We need to reopen the WO Requisition so we can remove the Part Line and Remove the Material Line as it is still showing as required. Is this possible? Is there another way to delete the Material Line?

5 months ago

Dharshankumaar MahendranSuperhero (Partner)

asked in Finance (Financials)

Supplier Payment Proposal

Hi Community,Please let me know the functionality of the below scenario.In Supplier payment proposal details window the “Branch” field gets enabled when “Payment in Advance” tick is enabled.What is the functionality behind this and how such payment in advance could be used to match with invoices along with branch functionality (Is it with supplier offset?)

1 year 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:

1 year ago

AbdessamadDo Gooder (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

1 year 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

1 year ago

Flavia TomasoneDo Gooder (Employee)

posted in Finance (Financials)

Vat in adv invoices

in Italy is very common the use of adv invoice, the current IFS standard fuctionality not support the legal requirements for VAT and i want investigate if in other country there is a similar requirement.In italy when we create the adv invoice we should pay the vat and insert the invoice information in the vat books of the month ( does not matter if the invoice is paid or not), the vat code apply to the adv is the same of the final invoice.when we create the final invoice we create the invoice for the total amount and we deduct the amount of the adv invoice.As far as i know there is a Similar requirement in Tunisia. any other coutry has a similar requirement?thanksFlavia

9 months ago

ronhuHero (Customer)

asked in Finance (Financials)

negative amount in goods receipt dialogue box

Community,wondering what happened to those negative value in the supplier invoice receipt matching dialogue box? how to understand it from business aspect? Thank you.

5 months ago

AbdessamadDo Gooder (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.

1 year ago

AbdessamadDo Gooder (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?

1 year ago

Aus SSidekick (Customer)

asked in Finance (Financials)

Voucher Template

Hi Team,Is it possible to create a Voucher Template in IFS Cloud? Rather than passing vouchers every time it would be ideal to have a template and upload. Please help!

1 year 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

1 year ago

envkishonDo Gooder (Partner)

asked in Finance (Financials)

Supplier Name in Arabic does not support ISO20022 Supplier Payment File.

Hi, We have implement in IFS in ME and China, when we have Supplier Names in Arabic or Chinese Language, SEPA XML files does not have name names in Arabic or Chinese Language in SUPPLIER_NAME tag and it shows ….. as Shown below. <SUPPLIER_NAME>.. - ............- IT ......</SUPPLIER_NAME> Regards,Kishore Nenwani

1 year ago

Page 68 / 173

4318 Topics

Sort order BACS.dat file

Accounts page - Edit All is not possible in all columns

Cancel Matching - Mixed Payment

Excel output from Payment File trace information

File templates SAF-T

Restricting access to invoices

IFS 10- Work Order connection type VIM

IFS 10 - Project close with pendint transactions

Minority Interest calculation on Group Consolidation Apps 10

Group Consolidation, Elimination of Interim results

Process code

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

delivery overhead doesnt get posted

Open Requisition Linked to Cancelled Purchase Order

Supplier Payment Proposal

Rev Recognition Invalid Previous Accumulated Value - Discrepancy from GL Balance

Supplier Invoice Workflow

IFS cloud : Directory path for currency rates importation

Vat in adv invoices

negative amount in goods receipt dialogue box

Fixed asset error

Customer payment

Voucher Template

ACTUD and QR-code IFSAPP9

Supplier Name in Arabic does not support ISO20022 Supplier Payment File.

Badges

Finance (Financials)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded