On the PCAPs, in the commitment section, I need to pull distributions that have "Yes" selected for "Against Commitment". I'd like to do this within the turnover formula but haven't figured out what to name the dimension, if it is even possible. I have tried various other wordings for the Against Commitment dimension but haven't gotten anywhere. This is the formula I currently have:
This looks like a custom field, added during implementation, and not a dimension or something that is usable from the standard reporting functions. We could use the SI.QUERY() function to retrieve all the transactions from the selected account, and filter. I suggest getting on a call together; I will reach out by e-mail
Thanks
0 Votes
A
Arthur. conoverposted
1 day ago
It is not a pre-defined or user-defined dimension, which is probably the issue I'm running into.
I am not a nonprofit or construction company, I am preparing Partner Capital Account Statements for investors in private equity funds.
Commitments are a statistical account in Intacct. You can book directly to this book to increase or decrease commitments, and in GJ Journal entries, there is an option to select whether individual contributions or distributions affect commitment or not.
0 Votes
Gabriel Michaudposted
6 days ago
Hi Arthur,
A few questions to better assist you:
Are you a non-profit or a construction company?
Do you have a user-defined book setup to track commitments balance?
Was there a user-defined dimension configured in your system to track the "Against Commitment" field?
Feel free to share screenshots of how the transaction looks like.
In previous implementations that I worked on, the commitments balance was tracked in a user-defined journal; in the context of construction companies this is typically done using the process outlined here. The SI.TURNOVER() function works with dimensions and journals/books, and that's how you would pull data related to commitments.
In the context of non-profits it may be different, and I will loop in one of my colleagues who's an expert in Intacct+NFP in case he has additional tips to provide.
We'll be able to get on a call with you as well if needed to help you get the report you need.
Thanks!
0 Votes
H
Harry Lewisposted
7 days ago
Within Intacct, how does this dimension appear?
Is it a pre-defined dimension that has been renamed?
0 Votes
On the PCAPs, in the commitment section, I need to pull distributions that have "Yes" selected for "Against Commitment". I'd like to do this within the turnover formula but haven't figured out what to name the dimension, if it is even possible. I have tried various other wordings for the Against Commitment dimension but haven't gotten anywhere. This is the formula I currently have:
=SI.TURNOVER(Connection,,"3100:3199",ITD_Start_Date,End_Date,Entity,Books,SI.DIMENSIONS(Connection,"customer",$AC$12, "agnst_commit","yes"))
0 Votes
4 Comments
Gabriel Michaud posted 1 day ago
Hi Arthur,
This looks like a custom field, added during implementation, and not a dimension or something that is usable from the standard reporting functions. We could use the SI.QUERY() function to retrieve all the transactions from the selected account, and filter. I suggest getting on a call together; I will reach out by e-mail
Thanks
0 Votes
Arthur. conover posted 1 day ago
It is not a pre-defined or user-defined dimension, which is probably the issue I'm running into.
I am not a nonprofit or construction company, I am preparing Partner Capital Account Statements for investors in private equity funds.
Commitments are a statistical account in Intacct. You can book directly to this book to increase or decrease commitments, and in GJ Journal entries, there is an option to select whether individual contributions or distributions affect commitment or not.
0 Votes
Gabriel Michaud posted 6 days ago
Hi Arthur,
A few questions to better assist you:
Feel free to share screenshots of how the transaction looks like.
In previous implementations that I worked on, the commitments balance was tracked in a user-defined journal; in the context of construction companies this is typically done using the process outlined here. The SI.TURNOVER() function works with dimensions and journals/books, and that's how you would pull data related to commitments.
In the context of non-profits it may be different, and I will loop in one of my colleagues who's an expert in Intacct+NFP in case he has additional tips to provide.
We'll be able to get on a call with you as well if needed to help you get the report you need.
Thanks!
0 Votes
Harry Lewis posted 7 days ago
Within Intacct, how does this dimension appear?
Is it a pre-defined dimension that has been renamed?
e.g.,
or is it a user-defined (custom) dimension?
0 Votes
Login or Sign up to post a comment