Finance (Financials)

rcanningDo Gooder (Customer)

Is it possible to use the Collective invoice process with Advanced Invoices? I set a customer record to use Collective Invoice type on the Order>Misc Customer info tab.Then I created advanced invoices on two customer orders for this customer. When I created the Advanced Invoices I got a message box that said “Customer has Collective invoice functionality activated, by creating advanced invoice the order will be excluded from the collective invoice.”Is there anyway to include Advanced Invoices in with the Collective invoice process?We are using APPS 9 Rob

5512

2 years ago

svrmhuebnerDo Gooder (Customer)

asked in Finance (Financials)

Cancel posted customer invoice

Is it possible to cancel a already posted customer invoice? I know you can cancel a preliminary invoice, but are there any options to reverse a posted invoice?Thanks, Mark

4071

2 years ago

stephanie.bertoliniDo Gooder (Customer)

asked in Finance (Financials)

Stuck Supplier Payment Order

I have a user that created a supplier payment order, acknowledged it, and attempted to finalize it. However, the payment order did not process, and the invoice contained within the payment order is still showing as having an open balance. She mentioned that the invoice she processed was processed with a voucher date in the future, and she wasn’t sure if that is what cause the issue. I’ve attempted to go into the payment order (RMB > Details) and cancel the invoice, but because it’s already in acknowledged status, i’m unable to. Can anyone provide guidance on how to finish processing this payment order? The stuck payment order is the highlighted item. The invoice is already acknowledged, so the RMB option to cancel is grayed out.

1706

2 years ago

AlainKSidekick (Customer)

asked in Finance (Financials)

Reconciliation of not yet invoiced charges

Hello,I am looking for a way to reconcile my account “not yet received invoices - charge”.The report “not yet invoiced” does not help since It will show only the receipts but not the charges in the PO.We defined a dedicated account in the posting controls to book the receipts of charge but I have no details to justify to our auditors the balance.The matching of this account is not a viable solution since there are thousand of transactions and the automatic matching gave poor results. Basically, this reconciliation should be part of the report “not yet invoiced” but either there is a bug in the report or a missing functionality. Any clue how to make this reconciliation ? Thank you

1143

2 years ago

JGHSUSANDo Gooder (Customer)

asked in Finance (Financials)

Tax ID Numbers in Supplier>Document Tax Information

In Supplier>Document Tax information can you add multiple tax IDS for different countries where a supplier is registered for VAT in different countries. IFS looks to restrict having only one tax number for a supplier per company?EG I am looking to add both a UK VAT number and an Irish VAT number for the one supplier.The supplier has an address in Ireland. I can add the IE VAT number and validate it.However they also have a UK VAT registration and I wish to add their UK VAT number, but IFS does not seem to allow this?Also noted that the Tax ID type GBTAX is not available in list of values which is used to validate UK VAT numbers. This seems to be because the supplier has an address with a country not in the United Kingdom.Surely I do not need to add two supplier records for the one supplier?

4062

2 years ago

ManulakHero (Customer)

asked in Finance (Financials)

Network error when validating Supplier's doc tax ID via RMB

When the RMB “Validate Tax ID number” on Supplier>Address>Document Tax Information intermittently hits the below error.Tax ID Number ******** cannot be validated due to network problem.Further investigations:The error mostly occurs when the action performed perpetually The validation actually executes via the client (tbwSuppDocumentTaxInfo.cs) Looks like a client limitation (threshold for MS_MAX_CONCURRENT_REQ)Has this every happened to you?Any clue will be highly appreciated.Thank you.

2414

2 years ago

Vinoy HeshanDo Gooder (Partner)

asked in Finance (Financials)

ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")

Hi,I get the following oracle error message in ‘Customer Invoices with errors’ window since 3rd May. ”ORA-01400: cannot insert NULL into ("IFSAPP"."CUSTOMER_INFO_ADDRESS_CFT"."ROWKEY")” I have added a new custom field to CustomerOrder LU on the same day. Only CUSTCOLDEB (debit collective invoices) shoots out this error.Code in new CFSELECT 'Företag - Återstående limit' || CHR(13) || CHR(10) || cl.comp_limits AS "Företag och återstående limit"FROM (SELECT LISTAGG(COMPANY || ' - ' || CASE WHEN CREDIT_BLOCK = 'TRUE' THEN 'STOPPAD' ELSE TO_CHAR(ROUND(NVL((SELECT remain_credit1 FROM IFSAPP.customer_credit_collection_qry q WHERE q.identity = c.identity AND q.company = c.company), CREDIT_LIMIT)), 'FM999G999G999') END, CHR(13) || CHR(10)) WITHIN GROUP (ORDER BY COMPANY) comp_limitsFROM IFSAPP.CUSTOMER_CREDIT_INFO_CUST c

6111

2 years ago

nimesh

asked in Finance (Financials)

How to Clear Send Error Messages?

Hi,Anyone knows how to clear send error messages? This customer has been setup as internal customer to send e-invoices but company AS has a default Document Address with zip code and city. The vouchers of these invoices have already been posted to GL but still these errors do not clear.But error says:1) Company Document Address must have a value.2) Company Document Address Zip Code must have a value.3) Company Document Address City must have a value. Appreciate if anyone can advise? Thank you in advance!RegardsNimesh

3005

2 years ago

santhoshDo Gooder (Partner)

asked in Finance (Financials)

Detail Statistics- Invoiced Sales-cannot Serialize the Data Error.

Hi,While Appling the data for the First and Exporting the data its Exported. But when I do the same Exercise for the second time with different dates, getting the below error. need your Expertise view on this issue.

891

2 years ago

HousseinySidekick (Customer)

asked in Finance (Financials)

Help in Getting highest 20 rows (SQL query)

Trying to get highest 20 rows of the below query based on “Net Amount in USD” column which is a sum column. Any clues? select INVOICE.IDENTITY as "Identity", supplier.vendor_name,to_char(sum(INVOICE.ACTUAL_NET_DOM_AMOUNT), '$999,999,999') as "Net Amount in USD" from &AO.INVOICE inner join&AO.supplieron &AO.Invoice.identity = &AO.supplier.vendor_nowhere INVOICE.OBJSTATE <> 'Cancelled' group by INVOICE.IDENTITY,vendor_name

724

2 years ago

IviSidekick (Partner)

asked in Finance (Financials)

2 Lines for the same invoice, in the Multi-Company External Invoices vue

I have an issue.When loading an external invoice, and when I check in the multi-company external supplier invoice… I find 2 lines. Does anybody know how to fix this issue.Note that in the External supplier invoice I have only one line: Thanks for your help!! ivi

411

2 years ago

Kasun PradeepDo Gooder

asked in Finance (Financials)

Currency amount” is not being correctly converted to “Amount in Accounting currency

HiHow to rectify below errorCurrency amount” is not being correctly converted to “Amount in Accounting currency

591

2 years ago

Janith BandaraHero (Employee)

asked in Finance (Financials)

Supplier Invoice Workflow

Topic raised on behalf of case G2339508I would like to experiment with Supplier Invoice Workflow, but not sure we have it installed. 1) How can we tell if it is installed?2) Where can I find instructions for installing it?

3483

2 years ago

MelLindaBDo Gooder (Partner)

asked in Finance (Financials)

Error - Interim Sales Voucher

Good morning, I was trying to create interim sales voucher for a period and I got this error in backrgoud job : Posting cannot be created for Customer Order A10078. AccountingCodestr.CODEMISSINGBUDPOSTING: The value used for the code part Account and posting type ORA-20105: OutstandingSalesAccting.ACCERROR1 Please if you have any suggestion to correct the error. Thank you.

1641

2 years ago

Laurent SDo Gooder (Partner)

asked in Finance (Financials)

Inventory valuation in the books (purchased and manufactured)

Dear IFS community, Hope this message finds you well.One of my clients would like to hold its accounting books with 2 different inventory valuation methods at the same time in IFS.Does anyone has already “studied” such a case? In a nutshell, they want to be able to retrieve (from an accounting point of view), an inventory valuation either in standard cost method (and then identify price variance on specific accounts to reconcile with actual price) or in weighted average method. They would like to apply it to their full perimter : purchased and manufactured inventory part To my understanding, an inventory part can only be applied one inventory valuation method so it doesn’t look like it is possible but maybe I am missing something. Thanks for helpLaurent

1471

2 years ago

Tharanga IsharaSidekick (Employee)

asked in Finance (Financials)

‘Period 2022 -XX is not open for user group XX in Company XXXX’ not shown in ‘Distribution and Manufacturing Postings Analysis’

Its about the following error when the period is closed for a user group.‘Period 2022 -XX is not open for user group XX in Company XXXX’You will get this when transferring transactions to Finance and it can be seen in the ‘Backgroud Job’ details and its not visible in ‘Distribution and Manufacturing Postings Analysis’ and there you will find these records with status code-2 !This seems like the design… but do you have any idea why error message ‘Period 2022 -XX is not open for user group XX in Company XXXX’ is not shown in ‘Distribution and Manufacturing Postings Analysis’ ?Thank you !

7078

2 years ago

Laurent SDo Gooder (Partner)

asked in Finance (Financials)

Freight cost breakdown for stock valuation

Dear all,One of my client receives supplier invoices (related to goods purchasing) with freight cost included.The freight cost does not appear in the order (because the purchasing team is not able to anticipate this amount).The accounting team deals with the discrepancy, when entering the invoice in the books, by reallocating the cost in the right account or directly in the purchasing account.They would like to know if it is possible to breakdown the cost of freight directly on the related invoice on each line/article taking the full amount of each line as the ratio of breakdown.Their final objective is to impact the cost of freight in the total cost of stock for valuation purpose.Thanks for your help

2906

2 years ago

AbdessamadSidekick (Partner)

asked in Finance (Financials)

Choose the projects to include in capitalization

Hello, I have a question about the “Periodical Capitalization and Revenue Recognition” screen. Is it possible to choose the project to be included in an accounting period ? Or to unselect projets that already are retrieved. For exemple in the screen attached to this question, is it possible to delete the projects selected ? Best regards

912

2 years ago

Kasun PradeepDo Gooder

asked in Finance (Financials)

Error when closing the period

Hi Guys How to clear below errors Posting type M201 is missing in Posting Control for company SASL and code part Account. Posting type M258 is missing in Posting Control for company SASL and code part Account. Posting type M257 is missing in Posting Control for company SASL and code part Account.

1331

2 years ago

ronhuHero (Customer)

asked in Finance (Financials)

Supplier Invoice cannot be receipt match

Community,User reported that there are 4 purchase receipts cannot be found in supplier invoice receipt window. in window Receipts, they do have status Received. In Invoiced Purchase Orders, we cannot find the 4 receipt references are receipt matched.wondering why?these 4 receipts are received last year. you can see they are connected to activity sequence. in below activity sequence, it is still in Released status.

2674

2 years ago

SandyDo Gooder (Partner)

asked in Finance (Financials)

Customer Reminders

Our client’s requirement is to send the customer reminders in the following sequence.14 days before the due date 7 days after the due date 14 days after the due dateCan we do this via one template? - I have ‘include invoices not due’ in the template. However, where would we define the number of days?Help on this would be much appreciated.Thank you,Sandy

910

2 years ago

dmooreSidekick (Customer)

asked in Finance (Financials)

Code String Error Message

Good Afternoon - can anyone advise how the error messages below can be investigated.Code string combination "2146.02/-/-/-/-/-/-/-/-/-/-/" is not included in any one of the allowed combination rules for user group in company 02.Code string combination "2165.01/100/C634/CONTRACTS/-/-/-/-/-/-/-/" is not included in any one of the allowed combination rules for user group in company 02. Many thanks for your assistance.Dave

5542

2 years ago

ludovic.rougeanHero (Customer)

asked in Finance (Financials)

LOB locators cannot span transactions

HiWe made an instant invoice with lot of attachments (146 docs) to be sent internally to another company, that’s the first time we put so many.Once we sent it, it generated this error:So I suspect the massive number of attachments to be the source of the problem.We removed them from the original Instant Invoice, but I fear it’s too late as this invoice seems already in “transit” and stuck with this error… Does anyone knows how to cancel it ?? or remove all the attachments from this object in transit ? or force it to move forward … Thanks in advance !!

942

2 years ago

RakeshSidekick (Partner)

asked in Finance (Financials)

Issue while performing the matching

Hi Team, Getting the below error while performing the matching in Posting Proposal window for a PO matched invoice. Request you to please help me in resolving this. Thanks in advance. Best Regards,Rakesh

390

2 years ago

NOLYMIOLDo Gooder

asked in Finance (Financials)

Year End & Function Group Help

For reference my company uses IFSAPP9 and I am located in the US. My accounting manager and I are trying to do our first year end close and create closing/opening balances for the new year. We just went live in October, so it has been a mess. Anyway, we messed a couple transactions during the preliminary year end up that we are trying to post. One posted, so I am trying to cancel that one and the other did not look right at all, so I am trying to reverse that one as well. However, when I try to approve the voucher, I keep getting an error message that user group AC is not associated with any voucher type with function group R for accounting Period 202301, see below. What does it mean and how do I fix this???I have tried adding the user group in voucher type per voucher series, as I have seen in other forums, same error. Tried added user group AC to Voucher type R, still getting yelled at. I don’t understand how to fix this and it’s driving me nuts because I just want to get these thing

3694

2 years ago

Page 100 / 218

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded