Finance (Financials)

Is it possible to remove empty lines in external files, in ‘External File Template Control’?If there is an empty line in the import file - then there is no value to control in the control string - and I can’t find any information if there is a way to define a ‘null’ or ‘empty’ value to control against.The first control with the value ‘Voucher date’ works perfectly - removing the header line.I then have a list of voucher lines - and want to remove/disregard all lines that have an empty value in the first column. The import file could look something like:Voucher date;Account;Cost center;Amount;Project;Object;Tax code;Voucher text2024-05-20;1910;;100;;;1;RAD12024-05-20;3740;;-100;;;2;RAD2-2;;;;;;;;;;;;;;;;;;;;;

Hi,I have a manual supplier invoice that is created with a PO reference. But the manual supplier invoice value is different from the PO value due to that tax amounts also different (Use Tax used). Due to this scenario my invoice is in PrePosted status as my invoice is not balancing (411.20 is showing as the balance)PO value-5216.60Use tax value-404.29Net amount of the supplier invoice added as-5305.84Use tax amount-411.20Can anyone advice me on how to balance this manual supplier invoice.

Good morning,We are using Work Task Cost Codes to repost costs for the Work tasks. We have a question from the business, if there is any possibility to do the same thing with the revenue: move initially to Deferred revenue, and when the Work Order is closed to automatically move from Deferred to Actual revenue. Did anybody find a way to repost the revenue?Is this feature present in any IFS version? Would customization be a viable option?Thanks,Cora  

Hello, Has anyone seen the error "Not possible to calculate relative period with respect to last depreciation date 4/30/23"?We have a TAX Book (no GL postings) that won't run a Depreciation Proposal, and instead gives the above error.This happens when we run July 2023 Proposal (and forward). May and June Proposals processed without issue. But those Proposals did not generate any actual Depreciation and it seems these are related. Go live was related (from an Asset standpoint) to the 4/30/2023 date.Any simple things we may have overlooked? Regards,William Klotz

Hello. I am hoping someone can advise on what can be done in this instance. We have an order where we are selling one item for $100. But we have to bill in 3 stages (1st invoice for 30%, second invoice for 60%, and third invoice for 10%). Shipping of the item can occur anytime though usually at the last stage (ie. after the 30% and 60%. invoices). For a situation like this, what would be the most appropriate way to set up the order and do customer billing? I would appreciate any thoughts/advice.  Thank you.  

Hi Team,Does IFS ISO20022 CT support 3 decimal in ammount.Regards,Mukesh

  Hi,I am trying to set up IFS Cloud 23r1 to Pay Employee Travel Expenses using the Payment Method ISO20022. It is not outputting the Sort Code in the XML file.The Employee is set up with Property Codes to store the Bank Account under EMPPAYACC and Sort Code under EPSORTCODE. The Sort Code does not get output in the ISO20022 xml file created. The Account appears under  <IBAN> and if we add a BIC Code under BIC it appears under <BIC>. XML Extract for 0.01 Employee Payment:<CdtTrfTxInf>                <PmtId>                    <EndToEndId>29/240508/1</EndToEndId>                </PmtId>                <Amt>                    <InstdAmt Ccy="GBP">.01</InstdAmt>                </Amt>                <ChrgBr>SLEV</ChrgBr>                <CdtrAgt>                    <FinInstnId>                        <BIC>BUKBGB22</BIC>                    </FinInstnId>                </CdtrAgt> 

We’re looking to send our customers a reminder of due invoices 10 days prior to the actual due date. Most of our invoices are NET30, so this would be a reminder that goes out 20 days after the invoice date.I’m able to setup a reminder template that has tiers for 0 and 20 days, but it seems to only start after the invoice is past due.  If I have a tier 0 at 0 days and tier 1 at 20 days, it won’t generate anything on the Customer Reminder Proposal until the invoice is 20 days overdue.Does anyone have a solution to this?It seems like functionality that everyone would expect to be there out of the box.

I need guidance on the following:Changing the net value of a fixed asset. Updating the acquisition value. Ensuring the changes are reflected correctly in the General Ledger (GL). Could you please provide documentation on how to complete these tasks within IFS? Thanks in Advance!

Hello, IFS currently produces a payment file onto a Windows server which then passes through a 3rd party application called Bottomline PTX to get to the bank. We are being asked to look into direct integration to the bank that removes the file being placed on a windows server and 3rd party product.  The UK bank we use is HSBC and they suggested using their HSBC Connect offering.  I believe IFS Connect may be able to perform this, but we have no knowledge on this area or integrating with banks.  Currently we are using IFS Apps 8. Does anyone have experience of this and can provide some guidance and advise? Thanks in advance Regards Shaun

What is the best report in IFS where I can span years and get trailing twelve months sales revenue?.

What is the formula IFS uses to calculate DSO?  I have seen some help topics that mention they found the formula in the help pages, I am not finding it.

HI , I have below questions regarding AR.1.Is there a feature in IFS Cloud to track the communication history with the customer?2.What would be the first parameter to check by the system (invoice date/ payment amount or invoice number etc) to automatically match the customer payment with invoices when an external file is loaded and created a mixed payment?  Many ThanksLakna

Hello,  We are in the 7.5 version, I found the error at mentionned in the screenshot for the posting M1 “Account N cannot be found”. I  used the Default values for the posting in order to check if it comes from a previous bad setup of the M1 posting. The error persists. Do you have any ideas to solve this problem ? Best regards

Hello.I’m wondering if there is any way to create external voucher and make use of automatic accounting rule AP1/AP2 for Tax Received/Tax Disbursed. When such voucher is created via Voucher Entry manually, it’s enough to insert 2 rows and additional 2 rows for default tax account are created automatically with the usage of AP1/AP2. Whereas external voucher is blocked by imbalance error.Maybe there is some way to insert the rows externally from .csv file to Voucher Entry and modify them there to use the effect of AP1/AP2. I tried Migration Job, but still the rows appear only in View Rows and not in Voucher Postings. Thank you in advance for your tips :)

Hi Community, We work for e French company, an european exportator of goods, and they need to creat an intrastat every month.We got 2 questions concerning this functionnality :- Why the format of the CSV of the intrastats report is not at the format of PRODOUANE (the french customs) ? The column are in english and not in the right order.- The goods under a warranty (at 0 €) shipped, are reassembled in the intrastat report at 0€. But in the european laws, it should reassamble at the sale price they have.

Hi,Can I know whether it the standard solution in IFS app 10 with India localization activated provides the facility to generate GST reports as required by the legislation ? Or else is it required to use the business reporter tool and create GSTR1 and automate the submission via a 3rd party middleware ? If not best thing is to do manually by exporting tax transactions and analyze and submit to tax authorities ? Please advise.

In APP9, we have a RMB option, Work Order…, in Manual Supplier Invoice window.What are the criteria that need to be fulfilled for that RMB option to be enabled for a particular record? 

Hi guys.I had to put couple of assets on hold for depreciation. Those assets ware activated in 2017 without any investment. Recently I notified this error and allocated respective values through “add investment - progress”. Since 2017-2023 accounts are finalised and periods ware closed, I put them on hold until 31 March 2023. The problem is when I’m running depreciation for FY 23/24 “0” value JVs appear for the held periods (those ware already closed). Kindly guide me to overcome this issue and post depreciation 2023 April onwards. 

We are planning to start the GL voucher archiving as our data grows faster in the GL voucher row table.This is impacting day-to-day reporting and some month-end processes where data is fetching from GL voucher row tables.My question is if we archive these data will it impact any process in IFS for example “Calculate Revenue Recognition”? 

Hello! So, I recently just got employed with a company that uses IFS as their accounting software. I work in the accounting department and right now they do not use the bank reconciliation feature in IFS. They use excel spreadsheets and manually reconcile that way. I want to improve that process and utilize the bank rec feature within IFS. Now my question is, how do I go about starting that process? Will I need to make entries for each bank account to show the ending balances from May? I’d like to use the automatic transaction matching function and I’d like to be able to start reconciling for the month of June. I apologize if this seems confusing, I am new to IFS as well and figured this was a good place to start! Thank you for your time!

On behalf of a customer****Imagining the following scenario in the cost allocation functionality. There are the following Code parts defined:    With the cost allocation functionality, the Code Part Value "Preliminary 1" must allocate 25% of costs to "Cost Center A" and 75% to "Cost Center B".  Example:     However, Code part Value "Preliminary 2" must allocate cost to "Cost Center A" and "Cost Center B" according to the percentage of sales in each of these cost centers.   how can it be managed?  

Hello All, My customer has a problem because he sometimes manufacture purchase parts but the manufacturing cost is not considered to valuate parts : buckets ‘200’ Labor and 300 ‘Machine are missing (even missing on the shop order itself) Settings of inventory part:part type = puchase Inventory valuation method = Weighted Average Does someone knows if it’s normal in IFS? Is there any possibility to consider these cost buckets to valuate properly the parts received into stock Thanks in advance :) Antoine  

Q > Please let me know if it is possible to create a dynamic link in CLOUD BA Report. If Yes then How ?

HI 1.I created an instant invoice and allocated the rent income across six months. 2.Following is the voucher created and FULL amount has been debited to the rent income account for the same period.HOw to ensure that the revenue is allocated properly? Many ThanksL.K