Finance (Financials)

Hello, has anyone upgraded to Cloud version and then reopened a prior year?   We have gone from Apps9 to 24R1.2 and after reopening 2024 year and entering some reclass vouchers, the “clear revenue/cost balance” job is not finding the amounts to clear.   I’m then left with a balance in this section of accounts.  When I try to run the job I get this message:If I performed the exact same steps in Apps9 there were no issues. We are also testing service update 12 and same scenario.   I’ve logged a case with IFS but wanted to ask the community as well.  ​@Nancy Fink  any change in year end process in Cloud that I may be missing?  Thank you.

I am unable to find an existing schedule to have the below run daily.  Is this something that need created as a custom database task/schedule or if there a screen I can schedule it from?  Our goal is to have the Customer Credit Management Lobby updated daily.  I am also trying to find if there is a clean up process for this.  I see the API procedures in the DB but I do not want to create new tasks if there are existing ones.  

Hello,  How to generate a sepa file from a supplier payment proposal that encompasses all the payment transactions in one line instead of getting a line for each supplier payment of the payment proposal ?

Just installed the Business Planning/BP module in our IFS10 Test environment, and got an error message while trying to create a planning entry/unit: “The Accounting Code part does not exist”.  Here is my questions:Do I have to setup some special accounts for BP? Is there a code part K? I am only aware of A~J How to resolve this error.best,David 

HiWe have a scenario with a specific part where we want to capture the variant to standard price in the GL (which is working ok) and then when we receive the invoice, we match it against the receipte price rather than the PO line price.We had this working up until the 25r1 release and have noticed that this is no longer working.Is there a kind soul out their that can put us out of our misery as we’re unable to find any documents on how we did it!All help appreciated.Thanks Jay

Hello,I have a question about sold fixed assets and the FA balances analysis.We sold a fixed asset on February 21st, as you can see in the screenshot below.This fixed asset can be found in the balance for Period 1 (the period before the sale) with the status "Sold."However, when I try to obtain a balance for Period 2, I cannot find this sold fixed asset.I have noticed that this problem occurs for all fixed assets.The accountants need a report of fixed assets to compare it to the balance sheet, which we cannot obtain at the moment.Is there a way to set up this screen to include all fixed assets with all statuses?Best regards.

We are using App 9 with Avalara AvaTax connector for tax calculation. Florida has a discretionary surtax rule, where they have a cap of $5000 for county tax. This applies to the most Florida counties. The problem we are facing is the customer order tax amount is inaccurate, but the associated customer invoice has the correct tax amount. This is caused by the way IFS is sending the data to AvaTax.That is:Customer order sends each line item to be calculated.As for FL discretionary tax, any amount over $5000 is exempt from the county tax.For instance, when a line item amount is over $5000, the correct tax amount is calculated. Majority of line items are under $5000, so the sum of the tax on the customer order is inaccurate.Whereas the customer invoice tax amount is calculated with total net amount, instead of each line item.  Therefore, it is creating a discrepancy between the customer order amount and the customer invoice amount. Has anyone experienced the same issue, and did you find an

I’m trying to determine how to set up the discretionary sales surtax, as we have customers located in Florida. Most of these customers are also subject to a surtax cap, which typically applies only to the first $5,000 of the taxable amount. Each county has a different surtax rate and cap as well. Any guidance on this topic? 

hiWe are trying to Build Automation to generate ACH for Chase what are the best ways in cloud, getting trouble to see transformer if we use Routing rule. Any help will be grateful.

Hi everyone,When creating a supplier check with a voucher text (e.g., "check number" as shown in the image below), this text is carried over when the check is cashed, but only on the line of one accounting account. We would like this text to appear on the line of the bank-linked account (defined by posting key PP1). By default, the system uses the bank name (e.g., “SG” as shown in the screenshot below).How can we ensure that the text entered when creating the check is reflected on the accounting line defined by PP1? (Except doing a mixed payment) Thank you for your help

We are trying to load Open Customer Invoices with Parallel Currency using the STDCIN2 template where the are 3 amount fields feeding in to N31 to N33 Parallel Amounts in STDCIN2 file templateAfter swapping the amounts around a few times, it seems N31 does not appear anywhere in the Load ID’s created invoice, N32 seems to be assigned to Tax Amount In  Parallel currency and N33 seems to land in Net Amount In Parallel Currency. This render us the problem that the invoice’s posting is empty.Yes, we can adjust the value manually in the Posting Info.But that sort of defeats the purpose when the we boldly presume the fields are in template for a reason. Loaded resultsSo, we are reaching out to the Community, maybe someone had  similar experiences or has an idea to a resolution - other than correcting it manually 🙂Maybe there something obvious we are overlooking.

Hi All,I received what I thought was a very straightforward request for a custom events: Our customer wants to prevent Manual Customer Invoices from reaching PostedAuth status until the prepostings tab is filled out. This invoice should not be able to reach PostedAuth status So, I created a custom event using the following info: Then I created an event action with these conditions: And it’s running this code:DECLAREvar_company varchar2(25) := '&OLD:CODE_B';var_fsg varchar2(50) := '&OLD:CODE_C';var_sbu varchar2(50) := '&OLD:CODE_D';var_worksite varchar2(50) := '&OLD:CODE_E';var_project varchar2(50) := '&OLD:CODE_F';var_rel_party varchar2(50) := '&OLD:CODE_G';var_activity_seq varchar2(50) := '&OLD:PROJECT_ACTIVITY_ID';BEGINIF LEAST(var_company, var_fsg, var_sbu, var_worksite, var_project, var_rel_party, var_activity_seq) is null THENError_SYS.Record_General('ManCustInvoice', 'Please ensure that prepostings are properly filled out.');ELSE NULL;END IF;END;  But,

Hi Team,Good Day!!Can you any one guide is there any provision is available in IFS to stop reversal entries of revenue recognition entries in next month when use project type ‘Period Capitalization/ Revenue Recognition’ 

Hello, can you help me with this problem? Unable to match purchase order and invoice with additional costs in different currency in posting proposal. Have purchase order in USD, invoice for goods from PO in USD, but invoice for additional cost is in EUR.If use function “Price Adjustement Purchas” in posting proposal, add cost in row but when want the row save, mistage message is displeyed “Invoice XXX in USD already exist. It is not possible to match the same receipt with diffrent currency”. Thank you in advance.Jaroslava

Zero Balance Account Ralling Forward 2023 to 2024Is that Possible ?We want to Stop Zero Balance Account Ralling forward 

Hello dear community,I would like to monitor my work in progress using different accounting accounts (Raw materials, Consumables, Labour, Supplies, etc.).When I set up the M40 with a C124 control type, for example, the accounting entry for consumption on a shop order is made correctly on the different accounts. However, when the shop order is closed, the system displays an M40 charge control error stating that it can't find a control type and the only way to resolve this error at the moment is to set up an account in the posting header in the ‘Val def no TC value’ field. This means that you will then have to make a manual accounting entry to balance the various WIP accounts.Has anyone been able to find a control type for M40 that allows the work in progress to be tracked in detail on the same accounts when the shop order is issued and when the shop order is received?Please find the expected diagram in the attachment. 

I have a couple of suppliers with payment terms.I’ve entered 3 invoices that should pick up terms and provide a discount; however, when they appear on the proposal, there is no discount showing on the proposal.  It seems I have to go in and manually apply the discount.This is not going to work as I have 35 suppliers with discount terms. Shouldn’t this be an automatic process?

Hi everyone, According to the latest IFS Cloud 25R1 release notes, there should be a new ‘Offset’ command available in the Customer Check window.  However, during our testing in both the ifscloud25r1dc1 environment and the Enablement environment, the Offset command does not appear.  ifscloud25r1dc1 environment Enablement environment Has anyone else encountered this issue? Could you please advise if there's a specific configuration, permission, or setup step required to enable this functionality? Thanks in advance for your support! 

Hi AllFor end of year currency revaluation , i need a non reversed posting. I opt for “Do not reverse” and set “Original” in Revaluation Posting. Calculation and ackniwledgment are ok but when trying to create the Voucher, invalid code part demand requirements. I checked that GP9  respond to account code part requirement but there is still an error message. Does anyone know what the settings are or is it a bug? 

A new version of Perfidia v4.50.216 has been released. The actual version can be downloaded here:https://www.perfidia.de/downloads/psa/psasetup.exePerfidia Forum can also be accessed with GuestAccess (Gastzugang)https://www.perfidia.de/Perfidia?action=forum  

Finance is trying to rollback an incorrect Customer Offset and getting the following error.  How can they make the CUPIA get unpaid to roll this payment back? Thank you,Yvette 

When we extract customer tax IDs and validate them through the EU VAT validation system (VIES), we currently use GR as the country code. However, VIES requires the use of EL, which means the Finance team has to manually change the country code before uploading the data.To address this, I created a new country code entry for Greece using EL, but I’m reconsidering this approach. It doesn’t seem appropriate to have two ISO codes representing the same country, as this could lead to inconsistencies in our system (I have deleted the country code EL again).I’d appreciate your thoughts on how we should handle the ISO country code setup for Greece. Should we stick with the official ISO code GR, or is there a better way to align with VIES requirements without compromising data integrity?

Is it possible to change the parent company on a subsidiary company in IFS?  

In the Revenue Recognition Information tab in the project group there is a checkbox to Post Actual and Recognized Revenue Difference. What does this mean and what does it do if checked?

In a shop order, when there is a variance, I get detailed breakdowns of material, labor, machine and subcontracting costs in individual buckets and INVTRANHIST transaction.However, when I manipulate something on a production schedule and capture a variance, I am JUST getting a single PSDIFF transaction and that is NOT broken out by material, labor, machine and subcontracting costs.Has anyone encountered this and if so, how did you do a detailed variance analysis of production schedules to break out and report on material, labor, machine and subcontracting costs???