Finance (Financials)

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.                    

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

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.

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 

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 ?

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)?  

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

Dear all,  I have been working on the EInvoice solution for India following the instructions provided in IFS Apps 10 Global Extension - India Country Solution for UPD15. The xml I got looks like the normal EInvoice missing all the specific tags for India (e.g. INSupplyType, INGstin, INHsnCode , etc.).  Does anyone has an idea where I miss something? Any advice is highly appreciated :) Please find below some screenshots with my setup: Company  CustomerHSN/SAC Sales PartIFS Connect  

I have a problem to get the mandatory code part preposting to kick in using the external web shop/punchout in 22R1Purchase request created directly in IFS: Mandatory pre-posting on cost center is working fine. In the shopping cart, on the other hand, there is an option to specify cost center on the line. Even if I do not add a cost center it is possible to submit the purchase rows.The button "Submit purchase order lines" should not be possible to use until the mandatory cost center is in place on the lines.I have been able to ascertain that IFS did not build support for mandatory purchase groups on non article purchases, that I also need, in the 22R1 version, it is in place in the 22R2 version.Anyone who has a clue about mandatory costcenter related to external webshop? If anyone has- please let me know.

Hello, everyone!Recently there is a problem in my IFS Cloud application, on the Posting Proposal screen. When the user describes an invoice on the posting line and wants to save the changes, the application returns an "N/A" error. Refreshing the page solves the problem. What could this be related to? It’s very common and annoying issue.Projection: PostingProposal/FormApp: IFS Cloud

Hi IFS team, We have a slight problem when doing the VAT reconciliation in IFS. There was a supplier which didn´t have its TAX ID Number filled in, we noticed it when we downloaded the tax ledger csv file from output for the month. We filled in the TAX ID Number in Document Tax Information in Supplier tab, however the problem still persists. We filled in the Tax ID number in Supplier tab, but when we are downloading the tax ledger the Tax ID Number still remains empty. Sorry for my bad explanation, if you need me to be more specific please write me, is there a way to fix this issue?

Hello Mates, I’ve created a purchase order for non inventory items with a supplier  in EUR but the company is in GBP.The currency rate in the  PO was 0,8792.Then, two days after, i’ve registed the invoice, the currency rate was 0,8770When i’ve matched the invoice with the PO, the sytem has  brings into the line the currency rate of PO 0,8792 instead of the currency rate of invoice 0,8770. Which brings some gap in accounting currency.For me it’s not normal that the system brings the currency rate of the PO instead of bringing the currency rate of the invoice.  Thanks for your help  

Hi There, Is there any other posting control can accomodate my requirement instead of posting to M24?

We would like to have separate payment series for ACH and CHK, both for suppliers and customers.I know I have to start by creating new payment series, then I can assign a new payment number serie to each, and also assign the appropriate payment type code to each.How do I know which payment type code refers to an ACH payment?

Hi IFS Community,Thank you all in Advance.Could you please explain why we cannot use “&” in the Invoice Number field in the Manual Customer Invoice /Manual Supplier Invoice Screen?? Best Regards,Chathura

Hi,Customer would like to match the PO with Invoice when the goods are received in Arrival. When I check the company set up, the option to enable is greyed out. Is this the right place to make this setup and how do I enable matching of PO at arrival? Thank you,Kind regardsRutuja

we have configured the object connections to enable the attachment option in the supplier invoice analysis window and refreshed the cache but not able to see the attachment option in supplier invoice analysis window pls do suggest how to activate the attachment option in the desired window.  Thanks, in advance.

Hello, We have set up automatic tolerance posting in our test environment, we have also set up the posting control for SP1, but we were wondering if there is a way to set up control type AC2 for this posting type. We want to be able to add a cost center to the tolerance posting, so we can easily identify when we look in the GL Rows analysis which cost center a particular entry goes too. Thank you!

We would like to compare the output of ‘Create Simulated Inventory Value’ with that of ‘Copy Costs to Cost Set One’ for our Inventory Revaluation process. Is there any way that the output generated from ‘Copy Costs to Cost Set One’ job preferably exported to excel? App9 UPD14

Hi There All May someone please assist me: Where do i change the Footer details of the Payment Advise Report:Does this read and pull through from the Company details? or not...  I also cannot trace that the document is here connected under Connect Report:what should i be looking for please   

Hi There Can I get some help/Guidance with the below error on Voucher entry screen:  “Cannot find FA year and FA period for event date 10-JAN-23. Please check the Depreciation Calendar.”  The FA DEP Calendar exists in IFS 

Hi Everyone,I was wondering if anyone has discovered an easy way of replicating the logical that IFS uses to create Intrastat reports in SQL? The reason why we are looking to do this is because we would like to see the parts which will appear on the Intrastat report without creating a new one in IFS.I’ve run the debugger in a test environment and this looks to run the following the following line:.Intrastat_Manager_API.Start_Intrastat_Process I’ve taken a look at what this procedure looks to include but before I go any further with this approach I was wondering if there was an alternative way of doing this?We are currently running IFSAPPS 10Many Thanks,Dan

We are not able to create project invoice for MCPR if we have more than one Our ID setup on the Customer. Is this correct? We need to invoice same customer from several companies, but now we have to manually change the Our ID on the Customer, depending on which company we are invoicing from. Anyone with any experience on this?   

Hi,We have IFS Apps9 version and need to implement online invoice transfer to Hungarian authorities through API. Online Invoice System 3.0 Interface Specification.pdf (gov.hu) We do have GET extension.Has anyone tried or implemented this in IFS Apps9? Really appreciate if you can share your experience in this regard.Thank youUpekha 

Hi , I can create manual voucher using the bellow posting lines. But when I try to create Interim voucher, I get the error “Field [TAX_CODE] is mandatory for Source Tax Item Accrul and requires a value.” Anyone is having Idea about this error.  Thanks in advance