Chris Prime

Currently, the only way to get current net book values for assets is through the depreciation schedule object, but non-depreciable assets don't have schedules. This requires running a separate report for just non-depreciable assets for their cost on the asset object and manually combining that report with the depreciation schedule report. You shouldn't need to run 2 reports to get the total value of all assets on the books.

I would like to see an option for mass disposal of assets, since assets are often disposed of in bulk. I have multiple customers requesting this feature.

Make SUPDOCID available in Custom Reports, Smart Rules/Events/Triggers, and the Query API calls. I have customers that want to require attachments on certain transactions (mostly GL) and there's currently no way to put rules on it, nor a way to report on it. The only option would be to write a custom application that cycles through all the Read results for all the attachments in the system and join them to the originating transactions. That's far too complex for the solution needed.

I was able to make it work in a Smart Rule, but not a Trigger. Here's my condition: (({!GLENTRY.ACCOUNTNO!} >= "9000") && ({!GLENTRY.GLBATCH.JOURNAL!} == "EBITDA")) || (({!GLENTRY.ACCOUNTNO!} < "9000") && ({!GLENTRY.GLBATCH.JOURNAL!} != "EBITDA")) So, if the user is in the EBITDA journal they can use any 9000+ account without error or they can use any account <9000 in any other journal without error. No custom field required. It would be nice if the same references could be used on a Trigger for consistency, but at least it works in the Smart Rule.

Louis, I appreciate the idea, but this isn't a good solution for us. It would probably work in this specific scenario, but being able to look at data on a header and line at the same time is the reason behind using a relational database and we'll want to do this often. Extending objects and managing new fields for every new requirement or new record that could otherwise be fulfilled with a join and logic comparison isn't a tenable solution. It's much more likely for us to run into errors if we have to also build a trigger to set a default on new accounts, set all of the existing ones once, and prevent users from changing the check mark when really we should just be able to join the line back to the header and compare 2 values. Not to mention it makes the product look really inflexible when we have to tell the customer we built this semi-complex solution that they have to maintain to get around the fact that we can't program something like "record.header.value like '9%'". I've run into a similar issue with reporting where we need to be able to report GL data alongside AR/AP data and Intacct just doesn't give us the ability to "join" across objects/modules. Granted, when building reports you actually can join the header/line data, so I wish the triggers and smart rules at least had that capability, but it would be best if all system features allowed you join across all objects as long as you have access to the keys to make the joins. Thanks again for taking the time to respond.

Thanks, Louis. I'll give this a try. I actually want to ignore the records where supdocid isn't blank because the blank entries need to be reported to the user to rectify.

Is there any way to reference a parent object in any of these scenarios? I'm trying to limit the GL accounts allowed on a GL entry based on the journal of the header batch. We have a custom journal that should only allow 9xxx accounts and all other journals should allow all accounts EXCEPT 9xxx. I need a rule or trigger that can validate both the account on the entry line object as well as the journal on the parent batch object. In the trigger you have access to special objects like CURRENTUSER. If you can't reference the parent from the child, is there a special object like CURRENTTRANSACTION that is available instead?

Is there any way to pull the SUPDOCID through the API or in a custom report/view? The users want to audit that all JEs have at least 1 attachment, but I can't find a way to query this either through the reports/views or through the API. I can query the attachments API, but it doesn't include an ID back to the parent object, so it's useless for my purposes.