Finance (Financials)

How do I get reports in excel format fromIFS?

I am currently uploading daily bank statements to match against transactions, but only using previous day. I would like to start to upload today’s transactions so that they can be captured also without waiting a day process these.   My concern is that when we try to upload any addition payments the following day we won’t be able to upload a 2nd statement with that day and we have no check in IFS to ensure that we have uploaded everything from day before Does anyone ahve any processes or transactions they use for this?

I have question that I have close inventory period in menu “Inventory / Basic Data / Statistic Periods” and I already transfer transaction of inventory (Menu: Inventory / Transaction History / Aggregate Inventory Transactions per Period)But afterward I found some data was wrong so I need to revise the data and close period again.I’m not sure that it’s can do it or not and have any concern the other data or not?

Hi, In one of our companies they get error when running currency revalution for May period, error message says: Field [currency_amount] is mandatory for Currency Reval Detail and requires a value We have not see this before and cannot manage to find out where it comes from.Have anyone seen this before and can give us some indication on where to look and fix?We are on IFS10 upd 3 Regards,Anna

Hi I have the following constellation. Somethimes i need to be able to print an outgoing supplier invoice in order to do this i remove the flag from the supplier message setup and put it back in  the point is I cannot remove this flag permanently because then the intercompany message setup for the mainprocess would work anymore. Is there a way i can print or sent this outgoing supplier invoice without removing the default method? Otherwise i cannot post this invoice without printing Best RegardsSophal

Hi @MadushaDissanayake @Rasangi Tilakaratne @Viraj Sandaruwan Request you to please help me for the below scenario:I am not able to perform the Year end due to Currency Balance . I am able to view the currency balance in GL Balance Analysis window How to resolve this issue??Thanks,Rakesh

what is the deference between control type and posting type ?

Good afternoon, Does IFS support open-item managed GL ledgers? I have lots of users booking entries against balance sheet accounts, and we require to go through a lengthy month-end process to reconcile netting debits/credits (whether these be auto reversing journals or other types), in order to understand what makes up balances on our balance sheet. This is a lengthy and manual exercise, often involving thousands of lines in excel.It’s common for accounting software to enable open-item management of GL ledgers, allowing users to either: ‘close’ debits/credits against each other that net to zero  ‘close’ debits/credits against each other that dont net to zero but are within a tolerable threshold - writing off misc FX/variances to P&L accounts. automatically ‘close’ debits/credits against each other, if they pertain to auto reversing entries.Using the above functionality, allows balance sheet accounts to be maintained real-time, enabling management to get visibility of balance sheet

Hi,My purchase parts are “taxable” and I have entered a different tax code in the supplier for purchase part screen for each part. When raising a PR/PO, my tax codes pull out correctly for each line (different parts) from the supplier for purchase part set up.My PO is then  received.When I enter the supplier invoice (I’m using posting proposal), the system does not retrieve the tax code from the PO but from the supplier file or company, which is not correct.When I try to force the entry by creating 2 seperate lines in the supplier invoice, it doesn’t recognize the lines (it seems like the line ID ref is missing), and the matching is failed. The only way to perform the matching (and correct tax code) is if I retrieve the lines in the supplier invoice from the reception and if the set up of the supplier is “PO matching level = PO line), which is not relevant from a business point of view because of many gaps in terms of prices or quantity that will occur. Do you have any idea on how to f

Hi,I have two checking accounts. I am transferring money from one account to the other. What is the best way to post it in IFS. Both are ledger accounts so it will not allow a Mixed payment. I can do an external voucher upload but then that transaction is not included in the “Query - Cash Account Balance”.Any help would be much appreciated…Thanks,Debbie  

Hello,I have a problem with the integration of some data from an Oracle database into IFS. I have succeeded  to insert information about supplier into SUPPLIER_INFO_GENERAL table,  but fail to do so for IDENTITY_INVOICE_INFO.The error i get is : Catch : ORA-20110: Group 0 does not exist.On the other hand i have group 0 both in tables INVOICE_SUPPLIER_TYPE_GROUP and INVOICE_PARTY_TYPE_GROUP_TAB Any idea please ?

In  addition to enabling “Use Tax Invoice” in company level, what are the per-conditions to be filled in order to fetch values for following fields in Mixed Payment window?   

Good afternoon, I’m seeking an IFS solution for a recurring issue that my company sees - out of balance intercompany accounts after consolidation. We have many legal entites in the group, many of these trade with one another (one may purchase goods on behalf of another, or may pay salaries for employees that are seconded to projects completed by other entities etc). When accounting entries are posted, to move costs from one entity to another, this is done via two journal entries (or one, if combined into one upload)E.g. Company A incurred expenses that should be borne by Company BCompany A:Cr Expense ($100)Dr Intercompany AR/AP $100 - with counterparty BCompany B:Dr Expense $100Cr Intercompany AR/AP ($100) - with counterparty A Often, we see manual entry errors like the following:Company A:Cr Expense ($100)Dr Intercompany AR/AP $100 - with counterparty BCompany B:Dr Expense $100Cr Intercompany AR/AP ($100) - with counterparty CThe counterparty “C” was entered in error, and should have

Dear all, We added some new fixed assets to the system but in the wrong cmpany.We've added them and aslo imported them so they now have the status active  Due to the fact that the vouchers are already updated to the GL we can't delete them.So we want to Rollback of the import. Then this message appear.Does anyone has an idea how to solve tais?  

HelloWe do not use Fixed Assets, but plan on using the Lease Accounting functionality in IFS.  When I try to define a code part with FA accounting functionality, I get this error message.I’ve looked at the Company/Fixed Asset tab and the associated help for this company.  Help says:To enter fixed assets information per company:Open the Company window and query for the company for which you want to enter fixed assets information. Create a new record in the Fixed Assets tab.However, I’m not seeing how to Create a new recode in the Fixed Assets tab.  The + is greyed out on the toolbar, and no RMB options exist for creation.  I’m logged in as the application owner, so permissions should not be an issue.Any thoughts as to what I am missing?

Hi, Do we have any Localization Pack specific to Oman. If yes, can anyone share the document. Thanks for your support. 

Hi community,we would like to avoid the printout of Before correction lines within the correction invoice.In the xml file I found this parameter used as condition <DISPLAY_CO_LINES>TRUE</DISPLAY_CO_LINES>, but I don’t know how to influence this and if this can help. Thank you for any feedback!Regards Martina

Does anyone have either/both of these templates they could share, please?  If there is a completed example that works that would also be appreciated too. We have an issue (Apps 9) where we are trying to import a multi-line supplier invoice (one invoice no, multiple lines/postings/tax codes) but the invoice fails to load.  When we import an invoice with one record, it imports without error.  When we try multiple lines we get the following error Any suggestions/ideas would be much appreciated.   Linda

A customer contact which is not longer valid shall be deleted. In Case that this contact has been used e.g. in a customer order which has been Invoiced/Closed, the contact person can not longer be removed. If you try to delete the contact system checks whether any business objects refers to that customer contact and an error message appears:The information message 'The customer contact X is used by Y rows in another object (Business object contact)' is not really helpful for the user. The message does not listWhich particular objects are affected  Explain that it is possible to enable the checkbox 'Blocked for Use' in the mask ‘Person’ to block this Person ID for use as new customer contact and for CRM functionalitiesAfter enabling the checkbox ‘Blocked for Use’ it is visible in Customer Contact 360 mask and in Customer's contact tab.

Hi, We are interested in using the planned purchase cost in cost set 5.It works good for entities that don’t have Part Step Pricing in their Supplier agreements or Supplier for Purchase part Price lists. We are on  ifs10I have understood that when calculating planned purchase cost in this cost set, system will use purchase pricing logic, similar to when you enter a purchase order line for a part no.I also read in another tread that when calculating the planned purchase cost in Costing system will use:the standard lot size as order qty the effectivity date as price date. For some reason we do not get this to work when using price breaks, even if we have the standard lot size on the inventory part.Any one that have any input that could help us? Regards,Marika 

Hello...is there an easy way to migrate the “Accounting Structure” hierarchy across environments?  I asked the finance guys to do the setup in TEST environment and once finalized, then we can move it into PROD - but how???  This is a multi-level hierarchy so I don’t think a simple COPY/PASTE Object will do the trick.  Do I need to tell them it needs to be manually duplicated into PROD?  Or maybe we should just use Code Part Attributes and Attribute Connections (seems like it does the same thing anyway).  Thoughts??? (It looks like the COPY feature works across companies in the same environment...so that is something!) Tom Bowe

Hi Team,I have come across the following error when importing CAMT54 payment file.Attached herewith the relevant XML file. There’s no value in the file as suggested by the error.  Have any of you come across this error previously ? If so, please let me know how this could be solved.  

Hi I am trying to manually adjust an asset depreciation value in the month as the set up was not done properly at acquisition years ago, now system automatically calculated previous year/period dep, but it won’t allow me to post in previous financial year which I wouldn’t want to. Is there a way to delete the lines in the proposal?  Thanks 

Hi,We are having a problem with some supplier. Some off them are not receiving our automatique payment confirmation by email. I doubled check to validate and It seems that all configurations are correct. I try using my email and nothing happens. Anybody know how these confirmations are send? I tried do look all code and I couldn’t find how this process is triggered. Thanks

Is it possible to have payment terms that are due on a specific day of the week? For example W have a customer who will always pay on a Monday, but sometimes invoices are showing as overdue for 5-6 days - this is more of an issue at Month End.  Can we set up a payment term that will mean the invoice will be due on the Monday after 18 days for example?