Finance (Financials)

CBKLeasureDo Gooder (Partner)

Intersite profitability between 2 companies

Has anyone been able to set up the intersite profitability between 2 companies? The documentation only mentions this is available between 2 sites within the same company but we have a need to use this across companies. I’ve set up both companies to allow intersite profitability but the posting controls are not triggering. We are using 21R2.

2738

2 years ago

Udanee

asked in Finance (Financials)

M92 Postings are not getting created in purchase receipt cancellation

Dear all,Transactions are stuck with status 99 in the distribution and manufacturing posting analysis .M92 posting type is missing from the entry.posting control window. Any idea as to what caused the automatic posting (M92)to be missing? Many thanks Udanee

1642

2 years ago

Janith BandaraHero (Employee)

asked in Finance (Financials)

Reconciled ID in Bank reconcilation

Is there any direct way to know the Reconciled ID of an invoice when it is matched with a bank reconciliation?Currenlty we need to manually navigate in the Cash Account reconciled transaction analysis to find the reconciled id of a particular invoice

895

2 years ago

JJäthingHero (Partner)

asked in Finance (Financials)

Danske Bank and ISO20022 Plusgiro payments

For quite some time now we have been struggling to get the ISO20022 pain.001.001.03 file to transfer Plusgiro payments for us. Danske Bank has told us not to use the combination SESBA and 9600, but to leave these both fields blank. It all sounds simple enough but we just don’t seem to get it right anyway. Any clues?

2182

2 years ago

NagarjunaDo Gooder (Partner)

asked in Finance (Financials)

IFS 8 Detail statistics- invoiced sales

Hi Team, I have invoiced a customer order and ran the job “Create Customer Order Details Statistics” for statistic type invoiced sales. Still, this does not create any record in “Detail Statistics - Invoiced Sales” window. Are there any specific basic data to be entered or steps to be followed in order to generate records in "Detail Statistics - Invoiced Sales" window? Thanks.Nagarjuna

1892

2 years ago

EBusbyDo Gooder (Customer)

asked in Finance (Financials)

Post External Supplier Invoices Without POs

Hello all,We use an external programme to manage employee expenses and we wish to upload the expenses as external supplier invoices to IFS to manage payment and accounting. The problem is that these invoices will not have POs to match to in IFS and therefore the posting proposals can’t be posted to the GL as they are unbalanced. We are able to get around this by manually adding a line to the posting proposal to in order to balance, however, with the amount of expenses (supplier invoices) we process this will be very time consuming.Is there a way to process external invoices with no PO’s to match to or a way to automate the inclusion of a balancing line on the posting proposal? The invoices can be automatically authorized and posted in IFS as they are already manually authorized in the external programme.Thanks in advance!

3359

2 years ago

FABPODo Gooder (Partner)

asked in Finance (Financials)

customer ledger age analysis report 21R1

Hello, I would like to know if the customer ledger age analysis report is available in cloud version. Thanks

632

2 years ago

HousseinySidekick (Customer)

asked in Finance (Financials)

Joining SQL table with IAL table issue

I am getting syntax error when trying to join SQL query with IAL table. Any clues?? select order_no, order_date from( select *from ifsinfo.icfr_pro_116bwhere project_id = '20012') X join IFSAPP.purchase_order Y on X.order_no = Y.order_no ThanksHousseiny

1582

2 years ago

cjones_saabDo Gooder (Customer)

asked in Finance (Financials)

Cancel Instant Invoice

We have an Instant Invoice in status PostedAuth that we need to cancel. Per the field level help in IEE it’s possible to have a Status of Canceled, however, there is no right mouse button option to cancel. Is there a way to cancel this invoice? If not how do we clear the amount due from the customer and the AR Balance and correct our revenue account. We are using APPS10, UD12. Thank you.

4564

2 years ago

ProMagnusDo Gooder (Partner)

asked in Finance (Financials)

Customer invoices posting error

Hi all, Getting below bug: ORA-20105: Invoice.ACCERROR1: Error (The Currency Posting Amounts for the Invoice XXXXX are not Balanced) occurred while booking Invoice CR XXXXX How to debug?

240213

2 years ago

NPCCHLOEDo Gooder (Customer)

asked in Finance (Financials)

Wrong Purchase Authorisation Rule

Hello! We are having an issue with a purchase requisition that has pulled through the wrong purchase authorisation rule. We have seen this before where there was an issue with the purchase group however for this purchase requisition there is no purchase group on the PR line. I’m unsure if this is relevant as well but the issues we had previously were with “no part” PRs and this issue has arisen from a “parts” PR. I have tried to recreate this to see if it was a fluke error however every time I try to replicate the PR, it still pulls the wrong rule through. Any guidance would be greatly appreciated Thanks!

681

2 years ago

LeifSidekick (Customer)

asked in Finance (Financials)

Transfer object - Fixed asset

We are merging two companies and therefore using the function Transfer object in fixed assets.When we come to objects that are fully depreciated we get an error message saying that transfer amount need to greater than zero. We want to transfer the acquisition value and the accumulated acquisition value, even though the net is zero.The error message when we try to create the transaction in the transfer object - progress view!

3736

2 years ago

Vindya WijesingheHero (Employee)

asked in Finance (Financials)

Integration Solution

Hi All,Could anyone share guidelines on how to set up a solution design for extracting Finance/Treasury data from a third-party tool and into IFS?

321

2 years ago

OsthewhaSidekick (Customer)

asked in Finance (Financials)

xml output for norwegian tax reporting

The Norwegian Tax Template S105 used for VAT reporting can now create an XML-file which can be uploaded to the Tax Authority manuallyUnfortunately, I need more information … perhaps more basic data to be able to set this up.Does anyone have a “set up guide” for this ? I have use the pdf created for update 16 as a documentation…..

790

2 years ago

Máté KubicsekSidekick (Customer)

asked in Finance (Financials)

Duplicated costs

Hi IFS community, We have a situation on our end, For a specific supplier a PO was created, we received the invoice after the service had been provided to us and we registered it in Manual supplier invoice without entering the PO number in PO reference. We received the PO through register purchase order arrivals and the PO to closed. However, now we noticed that the costs have duplicated in IFS which is not great. Please is there a method to reverse the duplicate costs? Thank you in advance.

1365

2 years ago

Máté KubicsekSidekick (Customer)

asked in Finance (Financials)

Supplier validation

Hi IFS community, Is there a function within IFS to validate all association numbers within IFS? A function which would show which association numbers are correct and the ones which are not. Thank you in advance.

430

2 years ago

BRSASidekick (Partner)

asked in Finance (Financials)

Posting Proposal - Voucher Date IFS Aurena

When doing the Final posting from Posting Proposal in IFS Aurena, I do not have the option of choosing the Voucher date.When doing exactly the same action in IFS 10, (Same Invoice), I do have the option of changing the Voucher date. How is this done in IFS Aurena?

515

2 years ago

ATarBPTSidekick (Partner)

asked in Finance (Financials)

Inventory closure - Month End

Hi all, I have a question regarding the inventory closure for month-end period. As soon as the period is closed (user group NON AC), I would like to freeze my inventory. It means that the new receptions won’t be able to impact my inventory value for the previous period.I launched the “Aggregate Inventory Transactions per Period” then i tried to receive a PO in March and i had this error message (which is a good news)Can anyone explain me what are the transactions that are blocked ? When should i generate that routine ? Is it related ? Is it possible to close the inventory value statistic period 1 day before the actual month end ? If you have any documentation or best practices, i am happy to hear it ?Thanks a lot, Tarek

1860

2 years ago

TomBeresfordDo Gooder (Customer)

asked in Finance (Financials)

BI extract for cost of sales & revenue for customer orders

Hi I am extracting data to PowerBI.I want to extract cost of sales and revenue for all customer order shipments.I want to combine shipment & order line data with GL voucher data (account, sales group) We are on Apps 9.I can’t figure out the links to do this.I want to start from closed/completed shipment lines. COST OF SALES:SHIPMENT_ORDER_LINE_OVW → links to → SHIPMENT, CUSTOMER_ORDER_LINE & CUSTOMER_ORDER using shipment_id, order_no, line_no, rel_no & line_item_no. Easy!INVENTORY_TRANSACTION_HIST2 → links to → MPCCOM_ACCOUNTING → links to → vouchers & voucher rows on accounting_id. Easy!But what is the link from shipment lines to inv trans hist? INVENTORY_TRANSACTION_HIST2 has fields SOURCE_REF1,2,3,4 & 5.1,2,3&4 are clearly Customer Order, Line, Rel, Lini Item (for SOURCE_REF_TYPE = Customer Order)What is SOURCE_REF5… Help says its delivery reference… so I think it is the key to link back to shipment line…. but cant find where it links to.

2332

2 years ago

ATarBPTSidekick (Partner)

asked in Finance (Financials)

Intercompany AP/AR Netting/Offset

Hello, I need some help regarding AP/AR Netting with my customer.The companies within the group are buying and selling each other goods. Let’s suppose the company A has an AP Balance with company B (1500€) and an AR Balance with company B (4200€).At the end of the month, the AP Balance is offset in a intercompany offset account (Credit) and the AR Balance offset as well in the same account (Debit).So, the intercompany offset account balance is the difference (so -2700€)The netting functionality allows me to offset the same amount in AP and AR (here 1500€), but i would like to post the difference.Is it possible to execute such process in IFS ? Which posting controls are involved ?Also, is it possible to have a different account for each one of the sister companies ? Thanks, Tarek

11383

2 years ago

ATarBPTSidekick (Partner)

asked in Finance (Financials)

Closing the user group doesn't generate any errors

Hi,We are testing the financial close period and i have a major mistake here.When i close a user group in a period (ex.: NON AC), i expect to have an error in the table "Supply Chain Manufacturing Posting Analysis" when registering a PO Arrival.I noticed that i had no error displayed and it is really affecting my period closing. Maybe i am missing a certain setup ? In IFSAPPS 10, the error was displayed but not in Cloud 22R2.Can you please help me here ?Thanks.

210

2 years ago

ROXTOBBRISidekick (Customer)

asked in Finance (Financials)

Customer Ledger Age Analysis Aurena

Hi! We’re running IFS apps10 IEE but transitioning over to Aurena in preparation to move over to Cloud. As our users are trying out functionality in Aurena, I’ve gotten reactions about that Customer Ledger Age Analysis in IEE is missing in Aurena. Is this available in Aurena and we just can’t find it or is it a missing functionality? Best regards, Tobias

421

2 years ago

yenSidekick (Partner)

asked in Finance (Financials)

GL Automatic Posting Rules is not working

Hi, I have configure a simple GL auto posting rule to distribute a cost account from cost centre A to B with voucher type M, I.However it is not working neither 2 function type. Could anyone shed some light what would affect the automatic feature ?

2866

2 years ago

PaengmuangJDo Gooder (Partner)

asked in Finance (Financials)

Different values for Curr_Amount and Dom_Amount

Hi All,Does anyone know why the ‘Curr_Amount’ and ‘Dom_Amount’ values can turn out to be different (even when the accounting currency and transaction currency are the same) (in the GET environment – with no specific localization)?

1750

2 years ago

gary.wilsonDo Gooder (Customer)

asked in Finance (Financials)

Customer Invoices - Preliminary Status

What’s the primary driver behind why customer invoices would go into preliminary status?

4651

2 years ago

Page 102 / 218

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded