Finance (Financials)

Trying to get highest 20 rows of the below query based on “Net Amount in USD” column which is a sum column. Any clues? select  INVOICE.IDENTITY as "Identity", supplier.vendor_name,to_char(sum(INVOICE.ACTUAL_NET_DOM_AMOUNT), '$999,999,999') as "Net Amount in USD" from &AO.INVOICE inner join&AO.supplieron &AO.Invoice.identity = &AO.supplier.vendor_nowhere   INVOICE.OBJSTATE <> 'Cancelled' group by INVOICE.IDENTITY,vendor_name 

I have an issue.When loading an external invoice, and when I check in the multi-company external supplier invoice… I find 2 lines.  Does anybody know how to fix this issue.Note that in the External supplier invoice I have only one line: Thanks for your help!! ivi

HiHow to rectify below errorCurrency amount” is not being correctly converted to “Amount in Accounting currency  

Topic raised on behalf of case G2339508I would like to experiment with Supplier Invoice Workflow, but not sure we have it installed.  1)  How can we tell if it is installed?2)  Where can I find instructions for installing it?

Good morning,  I was trying to create interim sales voucher for a period and I got this error in backrgoud job : Posting cannot be created for Customer Order A10078. AccountingCodestr.CODEMISSINGBUDPOSTING: The value  used for the code part Account and posting type                    ORA-20105: OutstandingSalesAccting.ACCERROR1 Please if you have any suggestion to correct the error. Thank you.  

Dear IFS community, Hope this message finds you well.One of my clients would like to hold its accounting books with 2 different inventory valuation methods at the same time in IFS.Does anyone has already “studied” such a case? In a nutshell, they want to be able to retrieve (from an accounting point of view), an inventory valuation either in standard cost method (and then identify price variance on specific accounts to reconcile with actual price) or in weighted average method. They would like to apply it to their full perimter : purchased and manufactured inventory part To my understanding, an inventory part can only be applied one inventory valuation method so it doesn’t look like it is possible but maybe I am missing something. Thanks for helpLaurent 

Its about the following error when the period is closed for a user group.‘Period 2022 -XX is not open for user group XX in Company XXXX’You will get this when transferring transactions to Finance and it can be seen in the ‘Backgroud Job’ details and its not visible in ‘Distribution and Manufacturing Postings Analysis’ and there you will find these records with status code-2 !This seems like the design… but do you have any idea why error message ‘Period 2022 -XX is not open for user group XX in Company XXXX’ is not shown in ‘Distribution and Manufacturing Postings Analysis’ ?Thank you !

Dear all,One of my client receives supplier invoices (related to goods purchasing) with freight cost included.The freight cost does not appear in the order (because the purchasing team is not able to anticipate this amount).The accounting team deals with the discrepancy, when entering the invoice in the books, by reallocating the cost in the right account or directly in the purchasing account.They would like to know if it is possible to breakdown the cost of freight directly on the related invoice on each line/article taking the full amount of each line as the ratio of breakdown.Their final objective is to impact the cost of freight in the total cost of stock for valuation purpose.Thanks for your help 

Hello, I have a question about the “Periodical Capitalization and Revenue Recognition” screen. Is it possible to choose the project to be included in an accounting period ? Or to unselect projets that already are retrieved. For exemple in the screen attached to this question, is it possible to delete the projects selected ? Best regards

Hi Guys  How to clear below errors   Posting type M201 is missing in Posting Control for company SASL and code part Account. Posting type M258 is missing in Posting Control for company SASL and code part Account. Posting type M257 is missing in Posting Control for company SASL and code part Account.

Community,User reported that there are 4 purchase receipts cannot be found in supplier invoice receipt window. in window Receipts, they do have status Received. In Invoiced Purchase Orders, we cannot find the 4 receipt references are receipt matched.wondering why?these 4 receipts are received last year. you can see they are connected to activity sequence. in below activity sequence, it is still in Released status. 

Our client’s requirement is to send the customer reminders in the following sequence.14 days before the due date 7 days after the due date 14 days after the due dateCan we do this via one template? - I have ‘include invoices not due’ in the template. However, where would we define the number of days?Help on this would be much appreciated.Thank you,Sandy

Good Afternoon - can anyone advise how the error messages below can be investigated.Code string combination "2146.02/-/-/-/-/-/-/-/-/-/-/" is not included in any one of the allowed combination rules for user group  in company 02.Code string combination "2165.01/100/C634/CONTRACTS/-/-/-/-/-/-/-/" is not included in any one of the allowed combination rules for user group  in company 02. Many thanks for your assistance.Dave

HiWe made an instant invoice with lot of attachments (146 docs) to be sent internally to another company, that’s the first time we put so many.Once we sent it, it generated this error:So I suspect the massive number of attachments to be the source of the problem.We removed them from the original Instant Invoice, but I fear it’s too late as this invoice seems already in “transit” and stuck with this error… Does anyone knows how to cancel it ?? or remove all the attachments from this object in transit ? or force it to move forward … Thanks in advance !!

Hi Team, Getting the below error while performing the matching in Posting Proposal window for a PO matched invoice. Request you to please help me in resolving this. Thanks in advance. Best Regards,Rakesh

For reference my company uses IFSAPP9 and I am located in the US. My accounting manager and I are trying to do our first year end close and create closing/opening balances for the new year. We just went live in October, so it has been a mess. Anyway, we messed a couple transactions during the preliminary year end up that we are trying to post. One posted, so I am trying to cancel that one and the other did not look right at all, so I am trying to reverse that one as well. However, when I try to approve the voucher, I keep getting an error message that user group AC is not associated with any voucher type with function group R for accounting Period 202301, see below. What does it mean and how do I fix this???I have tried adding the user group in voucher type per voucher series, as I have seen in other forums, same

Hi CommunityI need to check and view the Std Cost of few parts. How do I get this?Which Quick report or which IFS path will help me. Thanks in advance :)Su

Is someone able to explain to me why there is a cost difference in the roll up of the material costs for this part?  The Accumulated Cost for the Estimated Material cost of the component is 0.20374 for 2921-88-2.  The QPA for 2921-88-2 for the parent part 2921-88-2_HC-ML is 10.  From this you would expect the Accumulated Estimated Material Cost for 2921-88-2_HC-ML to be 2.03740.  However, it shows as 2.03742.  Why?    

HiDo we have a person in the forum who has knowledge of finansiel legel requirement for Finland, EVL, Aaland Tax and stock depreciations? BR.Michael

Hello,We have seen one issue where one of the new functional role created by us is getting changed ( granting some API’s access). We don’t have any update manual intervention to update the permission set but our access team observed that that has been updated when we had done some patch deployments. We have analyzed the patches and it wont contain any code which can modify the functional role. This is functional role created by access team so this is not IFS defined standard role to have impact from patch deployment. So, Can anyone guide me if you have seen this kind of issue? 

Hi. I am a beginner to use IFS.😅Please help me to know how to do “Customer Offset” I started to click ”+” (New)  and filled in Payment Currency. Then, what is next action?  

If you have set up Purchase requisitioner and authorizer to be inherited to Posting proposal from Purchase, there is a problem if the Forward authorization has been used on PR.It is still the original Authorizer that is inherited to the Posting proposal, it is not the one that actually did the authorizing on the PR.It is a problem that there is not a possibility to manually change authorizer on the PR/PO. This should be possible, the same way as it is on the Posting proposal. Instead, there is a possibility to Forward authorization. That is just fine, call it change authorizer or forward authorizer,  it does not matter. But the one who really authorized the PR, is the one who should be inherited to Posting proposal.Agree? 

Community, would like to borrow your mind here. we are testing external supplier invoice with ABBYY system. ABBYY will send XML files and SFTP to IFS, IFS will call BIZAPI. External supplier invoice is loaded, but there is one issue, invoice document is not checked in. wondering why? please refer to the screenshot attached. Thank you.

We are trying to close a GL accounting period, but we have the error shown below.  The problem is I cannot find in IFS where you can see what maintenance transactions are in “error”.  We are on APPS10. I checked all kinds of “maintenance” screens but to no avail.Please help!   

Hi IFS community, Is there a way to change the manual supplier invoice header after it has been saved, got a voucher number, it is not even authorized and it is PrelPosted status. We would like to fix the ammount.Is there a way to fix this? We don´t want to delete it. Thank you in advance.