Finance (Financials)

This will include the questions related to Financials.

  • 4,301 Topics
  • 11,848 Replies

4301 Topics

M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)

Update of inventory transaction after adding charges

Hello,  My customer receives supplier invoice with freight charges on it after having registered arrival of stock - before creating invoice, the customer wants to go to PO and add purchase charges; the issue is that after having already received the parts into inventory, the purchase charge added on PO does not update the inventory transaction value, not yet transferred, hence stock value is not updated to consider purchase charge as well.NB : The inventory transaction gets updated only if the PO charge is added before registering arrival. How to setup system to update transaction even if purchase part is already received ?  Thank you

4
M
Sidekick (Partner)
1 year ago
B
Do Gooder
BJSDo Gooder
asked in Finance (Financials)

Supplier Invoice M93 Posting C31 override

Hello,we are new in iFS world so we would like to ask for help here. For Supplier Invoices we plan to use posting control M93 and control type C31 for automatic account number assignment. Everything is set-up and working properly but there not possibile to override assigned account if neccesary during Manual Invoice processing. "Override” selection doesn’t seems to allow that. Any sugestions how to achieve this except reopening and edditing of line of the PO? Thank you

1
Ralph Gericke
Hero (Employee)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Finance (Financials)

Excel Report Output

Hey peoples, I want to be able run reports via order report functionality and have the output in excel format rather than PDF. Is there anyway of doing this without having to use an excel plug in. We are using IFS AurenaI have tried changing the default layout type to excel reports in the report definition screen in EE but that didn’t workCheersGT

4
G
Do Gooder (Customer)
1 year ago
InfKristN
Sidekick (Partner)
InfKristNSidekick (Partner)
asked in Finance (Financials)

Domestic payments Denmark config/setup

We have found nothing in F1 Doc on how IFS customers should configure their current local DK business in regards to ISO2022 format that seems to be the current domestic payments / format according to an old Nordea pdf on the interwebs.  Are the DK supplier payment address configured as an IBAN address ? Or is trial and error the recommended  “moment of service” ?In addition we find no info on how IFS in regards to FI Kort payments vs domestic ISO20022 configuration for local IFS customers. The following link received no response from the by IFS promoted community:  

0
InfKristN
Sidekick (Partner)
1 year ago
T
Do Gooder (Customer)
TCourtnayDo Gooder (Customer)
asked in Finance (Financials)

Move CUPOA between companies

Hi there! We have a customer that has an account across two different companies (6201 & 6202). A payment was receipted to their 6202 account that was supposed to be for an invoice on their 6201 account.  Is there anyway within IFS to pick up the payment, now sitting as a CUPOA on 6202, and move it to their 6201 account? Appreciate your help! :) 

4
A
Hero (Customer)
1 year ago
C
Superhero (Customer)
cjohnsonSuperhero (Customer)
asked in Finance (Financials)

Part Cost on Inactive Part

Hello all, I have a question related to Part Cost on an inactive part. I have a production part that was marked inactive two years ago. When this part is pulled into the Estimating module in IFS, the part cost calculated is different than that of the Part Cost screen in IFS for the PN. Given that it was marked inactive two years ago, would this be the reason that there is a difference in the costs? I have no found any documentation on how IFS behaves when part cost calculation is run against an inactive part. The estimate itself appears to be accurate, and Part Cost calculation has been run against the inactive part. Our labor class costs have changed since the part was marked inactive, and I am curious if there is some legacy cost values that would cause the difference?Any guidance would be greatly appreciated! 

0
C
Superhero (Customer)
1 year ago
G
Do Gooder (Customer)
GT69Do Gooder (Customer)
asked in Finance (Financials)

Copy customer information to create new supplier

HiWe need to create a number of suppliers that are existing customers. Is there a way do this using some sort of copy function or do we need to create the suppliers from scratch. We are using IFS Aurena CheersGT

3
G
Do Gooder (Customer)
1 year ago
T
Do Gooder (Customer)
TCourtnayDo Gooder (Customer)
asked in Finance (Financials)

Error Message When Trying to Offset

Error Message: Value is missing or has an invalid time interval for posting type PP38 control type AC7 code part A in company 6205We have an AC sitting on account that we are wanting to offset against an AD however are getting the above error message. We’ve also had the same error message come up when trying to receipt a payment against an invoice (same company number 6205 but different customer) Anyone know what we need to change?

2
B
Do Gooder
1 year ago
A
Do Gooder (Customer)
andrei.borromeoDo Gooder (Customer)
asked in Finance (Financials)

Small balance remaining after consolidation

When we consolidate, a small balance remains on the parent’s account even if the subsidiary account balance is zero. This seems to be caused by the exchange rate and possibly the decimal places used. For example: Account 1456 in company CCIBU (base currency CAD) had a balance of CAD 2,001 at the end of Period 2. When this was consolidated to parent company CCICN (base currency USD) at the exchange rate of 1.239130, the balance in CCI is USD 1,564.01. In Period 3, this balance in CCIBU was cleared by a CAD (2,001) transaction, so at the end of Period 3 its balance is CAD 0.00 .  But when consolidated to CCICN at the exchange rate of 1.26465, IFS books USD (1,564.02) against the balance and USD 18.24 to a currency translation account. So in Period 3, there is a remaining balance of USD 1,564.01 - USD 1,564.02 = (0.01) . The balance should be zero instead.  So it seems like in the course of converting amounts when consolidating, IFS is missing small amounts when it clears balances. In the

0
A
Do Gooder (Customer)
1 year ago
T
Sidekick (Customer)
TTRACYSidekick (Customer)
asked in Finance (Financials)

Invoice Posting Authorization flow

I would like to create an invoice posting authorization rule for Person A and Person B.Person A - $1500 limitPerson B - No limitIf the invoice is under $1500, I only want it to go to Person A and ignore Person B.  If invoice is over $1500, I would like it authorized by both Person A and Person B.Cannot seem to get this to work as it is requiring both to authorize no matter the dollar amount.I have Person A set at a $1500 limit on the Authorizers page.  I have a Rule set for Seq 10 at Person A and Seq 20 as Person B.

10
T
Superhero (Employee)
1 year ago
E
Do Gooder (Customer)
Emma PrickettDo Gooder (Customer)
asked in Finance (Financials)

Supplier State Tax Info for 1099 reporting

Hi,I am trying to get access to the Supplier State Tax Info screen in the Supplier Tax Withholding window, but its currently greyed out: I can see you must have the check box Supplement Tax Withholding ticked on the Company - Tax Control - Invoice screen, which I have.  Are there any other prerequisites required to gain access to the Supplier State Tax Info window? I am logged into our Development system trying to set up 1099 functionality. Thanking you in advance Emma

2
Ieva Rituma
Superhero (Employee)
1 year ago
G
Hero
GayanDHero
asked in Finance (Financials)

Employee Payments Using ISO20022

Hi,We are using App9 and looking for a solution to handle Employee Payments Using ISO20022.As of now we do not use HCM module and the Employee Expense system is separated from IFS.We have requirement to make the employee payments through IFS and using ISO20022. We will be moving IFS Cloud in few years time.What is the best approach handle this in App9? We have some thoughts around this and have identified few options. But, not sure which is best and simple.Register Employees as Suppliers and integrate with Employee Expense system to create a external supplier invoice. Create Employees as External Payment Recipients and generate a Non-Supplier Payment with a integration. Is there a External File Template for loading a Non-Supplier Payment ? Use the HR module and register Employees in IFS. Use Employee Payments. We do not want a heavy setup HR module that make it complicated.ThanksGayan

3
G
Sidekick (Customer)
50 minutes ago
Yoshini Silva
Hero (Employee)
Yoshini SilvaHero (Employee)
asked in Finance (Financials)

Financial requirements for Mexican localization to the IFS Cloud product

Hi,Could you please share a standard documentation which outlines the requirements for Mexican localization of the IFS Cloud version for Finance product? Thanks in advance!Best Regards,Yoshini

1
F
Superhero (Partner)
1 year ago
12Guide_PaulB
Hero (Partner)
12Guide_PaulBHero (Partner)
asked in Finance (Financials)

CAMT.053 info from tag 'AddtlNtryInf' missing in external payments

Is there a way to get information from tag <AddtlNtryInf> in the external payment transactions? This tag often contains additional information that can be useful to the users.The external payment transactions contain attributes Bank Transaction Info 1, Bank Transaction Info 2 and Bank Transaction Info 3 but these are (in my test cases) left empy.

0
12Guide_PaulB
Hero (Partner)
1 year ago
G
Do Gooder (Customer)
gcraig22Do Gooder (Customer)
asked in Finance (Financials)

Reversing External Voucher

I have accruals that I want to upload instead of manually enter. Can external vouchers auto-reverse? 

3
R
Hero (Customer)
1 year ago
R
Do Gooder (Customer)
RBaranowskiDo Gooder (Customer)
asked in Finance (Financials)

Match PO receipts and returns without Invoice

What is the best way to match a PO receipt with a return when there is not invoice.  Currently we are entering a penny invoice, match the receipts and returns, code the penny to PPV and then have to do a Supplier offset to write off the invoice.   There must be an easier way.

2
Ieva Rituma
Superhero (Employee)
1 year ago
D
Do Gooder (Customer)
DexpneDo Gooder (Customer)
asked in Finance (Financials)

Invoice print error due to report error

We are seeing the following error when trying to print a customer invoice GENREPORTIO:Could not generate report: 'TRANS_ERROR:Failed transforming report data : 'javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The end-tag for element type "PRICE_UNIT_MEA" must end with a '>' delimiter.''This happens when I do ‘reprint modified’. Also when I try to do reprint original from archive i get the same error but this time a little bit different:GENREPORTIO:Could not generate report: 'TRANS_ERROR:Failed transforming report data : 'javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: Element type "INVOICE_TEXT" must be followed by either attribute specifications, ">" or "/>".'' 

4
D
Do Gooder (Customer)
7 months ago
N
Do Gooder (Partner)
NZCKAJASEDo Gooder (Partner)
asked in Finance (Financials)

Transactions from External Files (CAMT054) are no longer summarized in Mixed Payments

Hi,My customer has a problem with CAMT054 files in Mixed Payment, after upgrade from IFS10 UPD6 to UPD15. Previously, when the transactions from "External Payments" (CAMT054 file) was loaded into a "Mixed Payment", transactions of the type "Acknowledge Supplier Payment Order", were grouped into one row (more or less) in "Mixed Payment"/ tab Transactions .The detailed information could then be viewed in tab "Matching Transactions" in the lower part of the window.UPD6:Now, after the upgrade to UPD15, one row for each transaction is created in the upper part of tab "Transactions" in "Mixed Payment", instead of a lump sum:This is a big problem for my customer when handling the payments, since there are now a large amount of rows to handle.Has someone else experienced the same problem? Any ideas of what changes in IFS10 UPD7 or later, that can explain why this functionality behaves differently after upgrading?Best regards,Karin

4
A
Sidekick (Partner)
26 days ago
L
Do Gooder (Partner)
larasibDo Gooder (Partner)
asked in Finance (Financials)

Procurement Clause Types - Not Showing on Documents

For documents generated by IFS, you can assign certain Phrases per Document Type and that works very well. Now, there is also a new module 'procurement clause types' in which you can assign clauses per supplier, project, part, activity, ... So, I suspect that with this functionality, instead of determining a few clauses per document type, you can do this more specifically for all documents relating to a particular supplier/project/part, for example. Steps to take are:Create a procurement clause type. Create phrases linked to this clause type. Create clause connection rules, to determine when the clause should appear on a document.After trying all these steps, I don’t seem to manage to view the clause on the documents.Are there certain extra steps to undertake/settings to change for this module to work?

3
R
Do Gooder (Partner)
11 months ago
A
Do Gooder (Customer)
abrickleyDo Gooder (Customer)
asked in Finance (Financials)

Payflo Pro Credit card error 12 - Declined

Hi All,  We have recently began having an issue when trying to process credit cards that they are being declined in IFS, however when processed directly in PayFlo Pro, they are approved and charged. We are not sure what could be causing this error. Has anyone experienced this before?   

3
A
Do Gooder (Customer)
1 year ago
H
Do Gooder (Customer)
hketDo Gooder (Customer)
asked in Finance (Financials)

Error while printing final invoice for customer order with paid advance invoice

Hello, I have made an advance invoice for customer order and the advance is paid. When I try to make the final invoice for the order, I get this error message.We are running IFS APP 10 UPD 8. I read from another case “Error message during printing an instant invoice”, which also had something to do with advance invoice, that there might be a bug in UPD8 (151458). Is this a totally different case? Any solution? 

2
H
Do Gooder (Customer)
1 year ago
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)

Update inventory transaction after change of price on PO

Hello, Whenever my customer receives a supplier invoice, before registering, she checks that the unit price on the purchase order is the same as invoice; if not the case, then they reopen the article line on PO to change price and close it again so that the right price gets mapped on the invoice. She prefers to proceed in this way rather than registering price difference on invoice. But when the arrival of PO was registered, it has been done with the initial price of PO (and not the updated one), so the inventory transaction showing a debit of M1 and credit of M10 are created with initial price and then transferred to accounting/ finance with a daily task; their status is “transferred”, code 3.How can i proceed with an update of these transactions on ARRIVAL event (M1 and M10) after having changed the price on PO line, so that finance gets updated too? Thank youTanya

5
F
Superhero (Partner)
1 year ago
N
Do Gooder (Customer)
nstacktkDo Gooder (Customer)
asked in Finance (Financials)

Customer Analysis - Invalid Table Name for Specific User

When a specific user tries to load customers on the customer analysis screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”.This issue only affects this user who has all the permissions that seem necessary and on a test database can access this fine.When I look at the query being ran that throws the error, for the user the table name “ledger_item_cu_det_qry_cfv” is missing. For any other user this table name is present in the query and they can load customers on this screen. Any ideas?

3
P
Do Gooder (Partner)
20 days ago
H
Do Gooder (Partner)
hayley.cairnsDo Gooder (Partner)
asked in Finance (Financials)

Group Consolidation - Historical Consolidation Rates

Hi, I’m trying to setup the Historical Rate Consolidation to ensure that certain balances in the consolidation are retained at the historical rate. I have setup the Historical Rate Consolidation page for the accounts in question but when running the consolidation process I’m expecting posting controls GCP23 and GCP24 to be triggered to make the relevant adjustment, however  no vouchers are being created.What setup is required to ensure these posting controls are triggered on consolidation. Thanks!

1
ThushanWij
Do Gooder (Employee)
1 year ago
G
Hero
GayanDHero
asked in Finance (Financials)

Non-supplier payments

Hi All,I am wandering whether Non-Supplier Payments are supported with ISO20022 file format in App 10 or Cloud?ThanksGayan

1
G
Hero
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings