Finance (Financials)

Vinoy HeshanDo Gooder (Partner)

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

4451

1 year 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

2295

1 year 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.

741

1 year 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

654

1 year 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

381

1 year 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

431

1 year 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?

3163

1 year 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.

1261

1 year 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

1191

1 year ago

Tharanga IsharaDo Gooder (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 !

6088

1 year 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

2316

1 year 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

772

1 year 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.

1161

1 year 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.

2174

1 year 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

800

1 year 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

3792

1 year 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 !!

872

1 year 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

380

1 year 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

3034

1 year ago

Aus SSidekick (Customer)

asked in Finance (Financials)

Standard Cost - View for several parts

Hi CommunityI need to check and view the Std Cost of few parts. How do I get this?Which Quick report or which IFS path will help me. Thanks in advance :)Su

1437

1 year ago

john.gregoryDo Gooder (Customer)

asked in Finance (Financials)

Differences in Part Cost Calculation in Cost Build-up Tree

Is someone able to explain to me why there is a cost difference in the roll up of the material costs for this part? The Accumulated Cost for the Estimated Material cost of the component is 0.20374 for 2921-88-2. The QPA for 2921-88-2 for the parent part 2921-88-2_HC-ML is 10. From this you would expect the Accumulated Estimated Material Cost for 2921-88-2_HC-ML to be 2.03740. However, it shows as 2.03742. Why?

661

1 year ago

mimaDo Gooder (Partner)

asked in Finance (Financials)

Reporting Finland

HiDo we have a person in the forum who has knowledge of finansiel legel requirement for Finland, EVL, Aaland Tax and stock depreciations? BR.Michael

150

1 year ago

NikitaVelapure19Do Gooder

asked in Finance (Financials)

is there any process which can modify the Permission Set automatically?

Hello,We have seen one issue where one of the new functional role created by us is getting changed ( granting some API’s access). We don’t have any update manual intervention to update the permission set but our access team observed that that has been updated when we had done some patch deployments. We have analyzed the patches and it wont contain any code which can modify the functional role. This is functional role created by access team so this is not IFS defined standard role to have impact from patch deployment. So, Can anyone guide me if you have seen this kind of issue?

501

1 year ago

SakofriDo Gooder (Customer)

asked in Finance (Financials)

Customer Offset

Hi. I am a beginner to use IFS.😅Please help me to know how to do “Customer Offset” I started to click ”+” (New) and filled in Payment Currency. Then, what is next action?

6721

1 year ago

Jan TSidekick (Employee)

asked in Finance (Financials)

Forward authorizer on PO not inherited to Supplier invoice

If you have set up Purchase requisitioner and authorizer to be inherited to Posting proposal from Purchase, there is a problem if the Forward authorization has been used on PR.It is still the original Authorizer that is inherited to the Posting proposal, it is not the one that actually did the authorizing on the PR.It is a problem that there is not a possibility to manually change authorizer on the PR/PO. This should be possible, the same way as it is on the Posting proposal. Instead, there is a possibility to Forward authorization. That is just fine, call it change authorizer or forward authorizer, it does not matter. But the one who really authorized the PR, is the one who should be inherited to Posting proposal.Agree?

610

1 year ago

Page 78 / 197

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded