Skip to main content

Finance (Financials)

This will include the questions related to Financials.

  • 5,434 Topics
  • 14,348 Replies
5434 Topics
N
Do Gooder (Partner)
NIEKDo Gooder (Partner)
asked in Finance (Financials)
Can column values be used in URL parameters instead of lobby filters?

Can we use a column value instead of a lobby filter parameter in a URL?For example: ifsapf:tbwCreateVoucher?COMPANY=[COMPANY column value](Note: COMPANY is not a search parameter in my lobby.)  Thank you!

310
N
Do Gooder (Partner)
S
Sidekick
SwatiSidekick
asked in Finance (Financials)
Shop order -material variance

Hello Need advise, on opening and closing of shop order  from previous week or month . Question 1:  If shop order is closed for example: in previous week and it gets re- opened to make any changes to shop order, this is giving me material variance in GL in the current period.(ie correction week).But sometime, when a shop order is opened and closed again without any changes to the shop order its still giving material variance again in GL. if there is no change why does IFS gives shop order variance again? and how can we avoid this? Question 2:sometime our we need to update the notes on control plan lines in a shop order, these orders can be old ie previous period, again this is re-calculating material variance.How can we overcome this, is there better way of updating notes on control plan without it impacting the material variance. Thanks Swati

1121
P
Do Gooder (Partner)
T
Do Gooder (Customer)
taenarenDo Gooder (Customer)
asked in Finance (Financials)
Voucher Date when cancelling a Manual Supplier Invoice

Hi, When cancelling a Manual Supplier Invoice that is in PostedAuth state - is there a way to set the Final Cancellation Voucher Date to default to the system date?   

180
T
Do Gooder (Customer)
K
Do Gooder (Customer)
kcook10Do Gooder (Customer)
asked in Finance (Financials)
Multi-Currency Customer Offset via Mixed Payment

I am trying to apply to CUPOAs to an open invoice (CD) on a customer account via a mixed payment since they payments & invoice are in different currencies (USD & CAD).  How do I get the transaction to balance in the mixed payment?   If I change the ‘Pay Amount in Invoice Curr’ of CUPOA 1213 to $1,398.07 so they net to $0, It still doesn’t balance for me to post.  HELP :)  

481
R
Hero (Employee)
P
Do Gooder (Customer)
PaulaAdkinsDo Gooder (Customer)
asked in Finance (Financials)
Manual Voucher Entry uploaded

How do you edit a manual voucher entry that was uploaded? The Voucher Entry is in a Not Approved status and the View Voucher Rows tab is populated.The Voucher Postings tab is NOT populated. Thanks  

1074
R
Hero (Customer)
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)
IL Opening Balance on ledger accounts

Hello,  My customer will soon start using an internal ledger for the first time (in Jan 2025). For IL opening balance to be uploaded on all accounts, whether ledger or not, I was wondering what could be the best approach For non ledger accounts, I could use a manual voucher to be created on 1st on Jan 2025.As for ledger accounts, option 1 : should I create a Q voucher on period 13 of the current year (2024) in the Internal Voucher Entry window, so that balances are transferred to period zero of next year in IL through the year end process? Or option 2 :  is it possible to just run the year end process, and then select an option to transfer GL year end balances to both GL and IL ?  (without creation of any Q voucher on IL as in option 1)If there is any option to update ledger account opening balance in Internal Ledger, I would be grateful of the community to share. Thank you for your helpTanya

1022
M
Sidekick (Partner)
A
Do Gooder (Partner)
AwijeDo Gooder (Partner)
asked in Finance (Financials)
creating Q vouchers in period 0

it is not possible to create journals in period 0 with a Q voucher type voucher

1543
M
Sidekick (Partner)
A
Do Gooder (Customer)
AlereiDo Gooder (Customer)
posted in Finance (Financials)
Nuances of RecieveEInvoiceService API

I’m in the process of integrating an OCR/IDP tool and IFS Clouds. At the moment, Supplier invoices are the document the tool will be used with.I’m excited that IFS cloud is going to take a modern, API first, approach. I’ve been exploring the ReceiveEinvoiceService API. However, the documentation (at least the docs linked in the API explorer) leaves something to be desired. It’s got some broken English and isn’t particularly clear. I was a bit surprised by this. It seems like an incredibly useful API, so I would have expected some better docs.Here is part of the documentation describing how to use it:Projection DocumentationService to receive an E-Invoice (Supplier Invoice) in the system.The structure ReceiveEinvoiceStructure describes the message different parts that can be used when creating the E-Invoice.If Invoice Image/Attachments are added (which is optional) to the message, ReceiveEinvoiceStructure, then the message needs to beprocessed in several steps in the follwing way:1. Cal

1601
NABALIN
Do Gooder (Customer)
N
Do Gooder (Partner)
NagarjunaDo Gooder (Partner)
asked in Finance (Financials)
Cash accounts not showing in mixed payment List of values

Hi Friends, I have created cash accounts in IFS. But while creating mixed payment cash accounts not appearing in list of values. Kindly help?  

392
T
Superhero (Employee)
M
Do Gooder (Customer)
MBARRAZADo Gooder (Customer)
asked in Finance (Financials)
Positive/Negative variance of Machine OH - Work center - Overhead2

Hello,We are beginning to use the Overhead2 (Manufacturing standard -Work center option - 322 Cost Bucket ID) we are requiring that any positive or negative variance of Machine OH can be book in 7682 account; attached you will find the details.Thank you

301
Marcel.Ausan
Ultimate Hero (Partner)
barner
Sidekick (Customer)
barnerSidekick (Customer)
asked in Finance (Financials)
Schedule Audit Interface Assistant - how to find genereated files (SAF-T)

Hi, We can run Audit Interface Assistant as Schedule.Backgroudjob is run, I can see the name of the file but I do not know where the SAF-T - XML file is stored.Do anybody knows where I can find those XML-files? Br. Barbara 

781
barner
Sidekick (Customer)
H
Hero (Partner)
Himarshi GunathilakaHero (Partner)
asked in Finance (Financials)
Error when executing CIS supplier verification

I’m trying to perform a supplier verification using a test scenario & getting the following error when RMB - Test Verify Supplier.  Current setup of the Tax Withholding / Reporting screen is shown below. Can anyone please help with the above error? Thank you

2384
Ieva Rituma
Superhero (Employee)
H
Sidekick (Partner)
HAFSASidekick (Partner)
asked in Finance (Financials)
cash Transfer between two companies

Hi IFS communityWhen creating a mixed payment—cash transfer from Company’s bank account to another company's bank account—I am encountering the following error message: Field [Voucher_type] is mandatory for Payments and requires a value  

646
R
Hero (Customer)
C
Do Gooder (Partner)
CapVijaToDo Gooder (Partner)
asked in Finance (Financials)
Currency Rate Type for Sales Contract & Project Invoice

Currently, requirement from customer at Poland location is to have fixed currency rate on sales contract for having planned revenue at a single rate and to have daily transaction rate on invoice.For purpose of same, fixed currency rate has been defined in currency rate type which is updated on sales contract and this rate is getting fetched on respective project invoice.However as per Polish local requirements, the Currency Rate on the invoice it should be daily transaction rate based on delivery date defined in Currency Rate type as TRANS_RATE (daily rates being updated).As of now, this functionality is included in Polish localization for Tax Currency Rate of invoice only but not for Invoice amount.Please share best practice to handle this scenario and whether to be part of localization or not.

911
Buddhika Kurera
Superhero (Employee)
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

4383
Link
Superhero (Customer)
T
Do Gooder (Customer)
taenarenDo Gooder (Customer)
asked in Finance (Financials)
Customer Analysis screen

Good day, We are finding instances where, on the Customer Analysis screen (Financials-Accounts Receivable-Customer Analysis) searching populates the correct customer in header but has different customer details in the 'Ledger Items's tab.Has anyone encountered this or similar in Cloud?   

400
T
Do Gooder (Customer)
K
Sidekick (Partner)
kruthikaSidekick (Partner)
asked in Finance (Financials)
Invoiced quantity is more then Purchase Quantity

Hello,We have issue , where Invoiced quantity is more then Purchased quantity and Invoiced quantity is in Paid Posted. How to resolve this issue ?Invoiced quantity is 43.5 and Purchased quantity is 40.Regards,Kruthika 

451
T
Superhero (Employee)
Y
Sidekick (Partner)
yenSidekick (Partner)
asked in Finance (Financials)
External supplier invoice load error

I have this load error ‘ The bank account xxxxxx is not valid for Supplier xxx in Company xx.’Anyone know which part went wrong?

4789
N
Do Gooder (Partner)
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Finance (Financials)
Automate Matching of Customer Payments

We have a request from The Business to automate matching of invoices for Customer Checks  - to match against the oldest ones first, or if it matches a months invoices (as the oldest one is in query) as a proposal before the payment is posted against the invoices.I can see many functional issues with this - but at the moment I’m tasked with looking into the technical feasibility. I almost posted as an new user for this question.I can see nothing in standard functionally - has anyone developed anything custom or been down this route before. Thanks,Matt

1662
M
Sidekick (Customer)
CTHMILLER
Do Gooder (Customer)
CTHMILLERDo Gooder (Customer)
asked in Finance (Financials)
Customer Payment Series ID Default value

 Is there a way to set the series ID on the customer payment page in APPS 10 to a different default? We’d like it to default to CD. Thanks, 

301
T
Superhero (Employee)
Thakshila Chandrasiri
Do Gooder (Partner)
Thakshila ChandrasiriDo Gooder (Partner)
asked in Finance (Financials)
Currency Revaluation Accounting Year basis

Hi Community, If we calculate the currency revaluation for the whole year at the end of period 12 instead of monthly, is there any system issues? Would the system allow it? I had couple of testing and noticed that for Balance sheet accounts total balance is revaluating.Appreciate your support on this. Best regards,Thakshila

552
Thakshila Chandrasiri
Do Gooder (Partner)
O
Do Gooder (Partner)
OumaimaDo Gooder (Partner)
asked in Finance (Financials)
Update of Migrated Invoice Statuses to 'Paid'"

Hello community, I have a question please about Payments, we have a list of migrated invoices, and we want to update their statuses in bulk to 'Paid'" statuse, is there a way to do that ?Thank you in advance !

392
O
Do Gooder (Partner)
B
Do Gooder (Partner)
BawLakshBDo Gooder (Partner)
asked in Finance (Financials)
Copy Company from a model

Hello, Our client needs to create about a 100 companies(SPV). We would like to know the complete list of tables which are copied when we create a new company and list of table which are specific to companies. Thanking you.  

351
T
Superhero (Employee)
N
Do Gooder (Partner)
NZCKAJASEDo Gooder (Partner)
asked in Finance (Financials)
How to remove a company from a user who has authorized invoices for that company?

I have a customer who needs to revoke company access for users who have moved from one company to another (IFS10). However, if the user has authorized invoices in the old company, it’s not possible to remove their access. Instead, an error message appears: “The Posting Authorizer… is used by x rows in another object (Posting Proposal Auth).”This issue has been discussed here several times before, but as far as I can see, no solution has been presented.Has anyone discovered a way to resolve this problem without altering or removing the old records from the database tables involved?Removing the old user and creating a new one has been suggested as a workaround: Remove company from user | IFS Community This is not a good option for my customer, as it would result in a lot of administrative work and loss of traceability in other parts of the system.Another suggestion is to revoke as much access as possible from the user, for the old company: FINANCE: How to revoke an Invoice Posting Author

890
N
Do Gooder (Partner)
T
Sidekick (Customer)
TaMaSidekick (Customer)
asked in Finance (Financials)
Fully depreciated object add value

Hi We have an object which is fully depreciated and the object is active. Now there is new costs for this object.I have match the supplier invoice with that object. Then I activate the added value with processFinancials\Fixed Assets\Object Functions\Add Investment - Progress and query for the object. Right click and select Activate. I check from Object balance analyse that the added value is on object. Balance is correct.I created depreciation proposal for that object. But the depr. proposal is empty.How to solve this? RegardsTarja

533
R
Hero (Employee)

Badges

  • 5th Reply
    jnolanhas earned the badge 5th Reply
  • 1st Topic
    IanTinhas earned the badge 1st Topic
  • 5th Reply
    pabdouhas earned the badge 5th Reply
  • 1st Topic
    DMThas earned the badge 1st Topic
  • 1st Reply
    Mike_Phas earned the badge 1st Reply
Show all badges
Terms & ConditionsCookie settings