@BEKEDE HiThanks for your reply. I was able to make the report as Excel, but I have a feeling that there’s a issue with the format and how it extract data. Seems from this point it needs to be referred to our IFS guys. i have tried possible ways but the system is not so helpful :(Appreciate your input.
Hi @Dharshankumaar Mahendran Thank you for your reply.How do you get the Result Key for the Asset disposal under Order report?
Thanks Samuel. I had a try and it comes up. But will need to get more familiar with the Query design.
Hi, I tested around with query designer and the user set life time in ‘EstimatedLife’ is connectable with the object in a report. This would have to be a quick report of sorts in order to get the wanted results. I have attached a picture below to show an example how the connection would look like. You can see the results under Selected Attributes. Hi Samuel, This looks like a good solution. Legend!I went into my IFS Qery Designer but none of the Attributes comes up. Not sure why. I’ve searched by Object as per image.
Can we get the set life time given in the image for assets in a report?
Hi, I checked the screens and reports and was unable to find an existing screen / report that will show remaining life. I agree it would be good to have this on a screen / report. If you create a request, I’ll add comments and like / try to get others to like as well. It can be calculated. In IFS views we include the “Thru_Date” concept where depreciation has been calculated up to a given date (thru_date). With that, the acquisition date, and the life of the asset, we can calculate the remaining life. We would need to consider how the data would look in the tables when an asset is on hold. I’m thinking a quick report requested by IT. Sorry, Best regards, Thomas Thanks. So if we use the “Thru date” to a future date perhaps tweak it.
Hello, Here is a thread where the FA remaining life has been discussed: Fixed Asset Report with Remaining Life | IFS Community. With the solution described in the thread you are able to view the valid from and to dates but it doesn’t show the exact remaining life. I am not aware that there is standard report to pull that exact information. Thanks, I saw that, but it didn’t give a specific answer. Seems there’s no straightforward option.
Thanks heaps :)
Hey Ralph,I tried the IT team to get this information to me. Seems like too many roadblocks. :(You are absolutely right about not getting the bank details once the proposal is submitted. I will speak to AP to give this to me before submitting. Refer to your 2nd option, I enabled the Trace information for EFT. So when this is enabled, where can I see the bank account details? you are a super star and thanks :)
Thanks @Ralph Gericke How to do you get the Payment proposal PDF report?In my company once the AP create the proposal and send to bank, can’t access it. The other option is to go through Supplier payment Analysis. But still bank details are not shown :(
Thanks @KEVSER There’s always more than one way to do things in IFS :)
Thanks heaps. That worked.
Inventory Part in Stock includes quantities/cost/valuations: Inventory Part in Stock includes quantities/cost/valuations: Thanks Heaps, you're a champion.
Hey Cperduethanks for your reply.Sorry I might've confused you. My query is how to pull data relating to Std Cost for several parts. I checked under Parts (Pathh is Warehouse Management > Part > Inventory Parts) but is does not bring the Std Cost or the Estimated Material Cost. :(
I use IFS cloud and when I search by date created nothing comes up.whereas in Historic Payment File I can see the heading of the file. I can’t access the details of the payment though :(
Hi NarmadaThank you for your reply and the method. it’s helpful. Can I know what would be the search criteria to get the trace? I have the payment date, or the date payment proposal has been created. Would this be helpful or need to search by a different criterion?regardsSu
Hi,I would like below option. An IFS Academy Virtual Training And it would be awesome to learn on your own through a training manual and the Community Forum.
We reserve the Scrap function for material that is truly in a scrapped condition (that is, it is in inventory, but no longer of value for the intended purpose). This in turn limits its use because it doesn’t really cover lost material which as @gumabs indicates is more of an inventory control function in the counting area. If there are additional specific scenarios where it is intended to track the inventory disposal AND there is an intention to direct it to specific accounts and/or cost centers, then you can also consider the creation of Financial Projects that are setup for a specific account structure. The project is then used when issuing material that meets those particular conditions. The good thing with the project route is that it can easily be reversed to move inventory back out of the project if status changes or there is a mistake. Using the scrap function is no reversible directly without additional manual transactions. There are several tools for this inventory contro
Hi @Aus S You can also consider counting functionality which automatically writes-off inventory value. To my knowledge, scrap means physically the product is in stock but not possible to sell or use in production etc. Where counting means that physically the product is not available in the inventory (negative counting) or you have more product in warehouse than in IFS inventory (positive counting). In case of counting, you need to define M7 for positive counting and M184 for negative counting in posting control. Regards Thanks @gumabs yes that's another way to correct the situation. We found out that this stock is incorrect after the physical stock count. I tried to adjust at the stock count entry and the system didn't allow due to high variance :( Hence I thought to do in a different way.
Hi @Aus S, This will create inventory transaction with a transaction code ‘INVSCRAP’ in ‘Inventory Transaction History’ window. Then there is process called ‘Transfer inventory transactions’ which create GL vouchers relating to inventory transactions. There might be scheduled job to run ‘Transfer inventory transactions’ process in your organization. Therefore, it is better to check that internally. Once above process executed you can see the voucher no in inventory transaction history window. Refer below screen preview. Posting controls refers to the translation of different Business Events in IFS Applications into Financial Transactions. There are different posting types for different business events. M1 & M6 are the posting controls applicable for scrapping transactions. Hope this information would help you. Best Regards Narmada Thanks @Narmada
Hi Narmada @Narmada You are amazing, Thanks for this solution.I understood the first part but unsure about the Posting Control. (I’m new to IFS - only 2 months :) I’ve posted it but how can find the Journal entry to this transaction?
HiPlease follow the path. Accounting Rules Voucher Manual Voucher Voucher New VoucherAnd if you have the access rights it comes up at the point “Voucher Posting”. Please see below screen shot. This is IFS Cloud by the way.If that option is not there check with the IFS administrator to grant you access. Hope this helps!
Thanks so much :) It helped. Have a great day!
Hi @Ieva Rituma Thanks so much. I have access rights and can see it.Is there any training manual on how to create a template and then how to execute it. Would be great if you can assist.CheersSu
Thanks Kristen
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
