Hi Kate, There may be a couple of things to check, 1: Are there other assets, with the same depreciation method, that are appearing in the proposal? 2: Does this asset have a salvage value? And has the NBV already reached the salvage value?.. therefore no more depreciation to recognise. 3: Are there any other active proposals where this asset may already have been included and is now waiting for approval / posting? 4: Potentially… Was the asset created through the import method and have the transactions been transferred? In other words, are you comfortable that your Asset Register can be reconciled to the relevant GL balances? That’s all I can think of for now :-) Jason
Hi Matthew, Thanks for sharing the code and example sheet. Is there a suitable time that we can connect / share screens to talk through the transactions on the screen? I’m based in Victoria, Australia so my time zone is AEST (but don’t let that be a lmitting factor, I’d be OK with a late night or early morning chat, whatever suits you). If you have MS Teams (or similar), you can send an invite to jasondereuck@hotmail.com I do think there are alternative options through IFS Business Reporter but it would be good to walk through some of the entries and get more understanding of the report’s intended use I.e. Is it to drive operations to complete their work or to substantiate financial entries at the end of the month (costs / revenue adjustments). Thanks Jason
Hi Matthew, Are you able to share a sample report showing the current logic that you’re applying to your report? I have built some work in progress reports in the Construction space but would like to see if any of it would be relevant for you. Jason
Hi, have you checked to see if the user may be selecting a a supplier invoice for offset that is already selected in a payment proposal?
Hi, The supply company and the customer company do not need to both cost account because you can set the resale value to zero. This comment is specific to recording hours, not multi-company supplier invoices that impact projects. In the supply company, you record the hours as a multi-company transaction where the internal cost may carry a value e.g $10 per hour. Based on the report code being used, you can set the associated sales value to $0. In the customer company, the hours will be recorded as far as units is concerned but at ZERO dollars. Hope that makes sense. I can possibly talk you through some more detail if you wanted to share screens and we can work through an example in your test environment. jason
@meshfemi if you need to create custom reports using Business Reporter please get in touch. Can do excel based reports such as P&L, Balance Sheet and many others.
Hi Pamith, You could consider creating a parameter for the report based on Accounting Period and allow the end user to select / enter a value when they run the report. Go into your report design and in the column where you placed the GL Balance object / repeated for each year, add a filter…... so that the amount is equal to or less than the parameter value. Jason
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.
